Ch%207_p1 - Sheet1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47

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

This preview shows page 1 out of 1 page.

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 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? Labor costs #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture