Ch%207_p1

Ch%207_p1 - Sheet1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 Chapter 7 Problem 1 Monthly base sales #ADDIN? Cash sales factor 0.1 Delayed Payment factor 0.9 Cost factor #ADDIN? Labor cost factor 0.2 Material cost factor 0.8 Operating cost factor 0.19 Long-term loan 96000 Long-term interest rate 0.09 Short-term interest rate #ADDIN? Desired ending cash factor 0.19 Month January February March April May June July August SeptemberOctober November December Seasonal factor 0.85 0.87 0.9 0.91 0.94 1.02 1.03 1.06 1.06 1.1 1.12 1.13 Actual sales #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? Beginning cash balance -7015 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? Cash sales #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? Monthly collections 50882 50882 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? Total cash receipts
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.
Ask a homework question - tutors are online