B C D R E F G . 1 J K L M N o P Q MONTH1 MONTH 2 MONTH 3 MONTH 4 MONTH 5 MONTH 6 MONTH 7 MONTH 8 MONTH 9 MONTH 10 MONTH 11 MONTH 12 TOTAL S In Units 4 20 30 60 60 70 120 120 130 120 90 40 50 910 910 STEP # 3 Enter Breakeven data below Data entry required in highlighted fields Amount $ 175 per unit $ 3.500 $ 5.250 $ 10,500 $ 10,500 $ 12,250 $ 21,000 $ 21,000 $ 22,750 $ 21,000 $ 15,750 $ 7,000 $ 8,750 S 159,250 $ 3,500 $ 5,250 $ 10,500 $ 10,500 $ 12,250 $ 21,000 $ 21,000 $ 22,750 $ 21,000 $ 15,750 $ 7,000 $ 8,750 $ 159,250 $ 600 $ 1,500 $ 400 $ 900 $ 2,250 $ 600 $ 1,800 $ 4,500 $ 1,200 $ 1,800 $ 4,500 $ 1,200 $ 2,100 S 5,250 $ 1,400 $ 3,600 $ 9,000 $ 2,400 $ 3.600 $ 9,000 $ 2,400 $ 3,900 S 9,750 $ 2,600 $ 3,600 $ 9,000 $ 2,400 $ 2,700 $ 6,750 $ 1,800 $ 1,200 $ 3,000 $ 800 $ 1,500 $ 3,750 $ 1,000 $ 27,300 68,250 18,200 $ 6 Units Sold 7 8 9 Cash Inflows 10 11 Unit Sale Price 12 13 14 15 Total Inflows 16 17 Cash Outflows 18 19 Variable Costs 20 Supplies 21 Labor 22 Util 23 Fixed Costs 24 Owner sal 25 Owner taxes 26 Equip/tool ise 27 Rent 28 Advertising 29 Insurance 30 Misc 31 32 33 Total Cash Outflows 34 35 Cash Surplus or (Deficit) 36 37 Beginning Balance 38 39 Ending Balance 40 41 42 43 44 Per Unit Amount $ 30 75 $ 20 Annual Amount $ 15,000 $ 3,000 $ 3,600 $ 6.000 2,400 $ 3,000 $ 2.500 S $ $ $ S $ $ O 1,250 $ 250 $ 300 $ 500 $ 200 $ 250 $ 208 $ 1,250 $ 250 $ 300 $ 500 $ 200 $ 250 $ 208 $ 1,250 $ 250 $ 300 $ 500 $ 200 $ 250 $ 208 $ 1,250 $ 250 $ 300 $ 500 $ 200 $ 250 $ 208 $ 1,250 $ 250 $ 300 $ 500 $ 200 $ 250 $ 208 $ 1.250 $ 250 $ 300 $ 500 $ 200 $ 250 $ 208 $ 1.250 $ 250 $ 300 $ 500 $ 200 $ 250 $ 208 $ 1,250 $ 250 $ 300 $ 500 $ 200 $ 250 $ 208 $ 1,250 $ 250 $ 300 $ 500 $ 200 $ 250 $ 208 $ 1.250 $ 250 $ 300 $ 500 $ 200 $ 250 $ 208 $ 1,250 $ 250 $ 300 $ 500 $ 200 $ 250 $ 208 $ 1,250 $ 250 $ 300 $ 500 $ 200 $ 250 $ 208 $ 15,000 3,000 3,600 6,000 2.400 3,000 2,500 Total Cash outflows $ 5,458 $ 6,708 $ 10,458 $ 10,458 $ 11,708 $ 17,958 $ 17,958 $ 19,208 $ 17,958 $ 14,208 $ 7,958 $ 9,208 S 149,250 Cash Surplus (Deficit) $ (1,958) $ (1,458) $ 42 $ 42 $ 542 $ 3,042 $ 3,042 $ 3,542 $ 3,042 $ 1,542 $ (958) $ (458) Beginning Balance $ 3,000 $ 1,042 $ (417) $ (375) $ (333) $ 208 $ 3,250 $ 6,292 $ 9,833 $ 12,875 $ 14,417 $ 13,458 Ending Balance 1,042 $ (417) S (375) $ (333) $ 208 $ 3,250 $ 6,292 $ 9,833 $ 12,875 $ 14,417 $ 13,458 $ 13,000 Ending cash balance must equal profit component + start up cash (may be off slightly due to rounding error) Step 4 Enter beginning cash balance Breakeven Analysis Car Detailing Inc Contribution Margin Enter sale price per unit 175.00 100% 2 Sale price per unit Variable costs per unit supplies Yabor util Xxxxx x x Total Variable Costs 30.00 75.00 20.00 Enter variable costs description and per unit cost note: Data entry is required in a minimum of one row 125.00 71% Contribution margin per unit $ 50.00 29% Contribution margin percentage Fixed Costs 15,000 3,000 3,600 Data entry required Enter fixed cost description and annual cost 6.000 2.400 owner sal owner taxes equip/tool Ise rent advertising insurance misc xxxxx Total Fixed Costs 3,000 2,500 note: Data entry is required in a minimum of one row $ 35,500 Profit Component Enter profit before income tax Breakeven Analysis Formula Profit before income tax S 10,000 Data entry optional Breakeven Point Units Dollars 910.00 $ 159,250 Required Sales Volume 76 $ 13,271 18 3,063 2 436 Proof Sales needed to cover Fixed costs + Profit BFIT fixed expenses + profit component Contribution margin Sales per Month Sales per Week Sales per Day Income Statement Sales in units 910 Sale price per unit s 175.00 Total sales $ 159.250 Sales in units 910 Variable cost per unit $ 125.00 Total Variable costs 113.750 Contribution margin/Gross Profit Fixed expenses Profit before income tax S 45,500 35,500 10,000 $ Cash Budget Access the Car Detailing Breakeven Analysis (document in Canvas, under Test 3 instructions). Complete the Cash Budget (file in Canvas, under Test 3 instructions). The breakdown of sales per month are as follows: Month 1 20 Month 7 120 Month 2 30 Month 8 130 Month 3 60 Month 9 120 Month 4 60 Month 10 90 Month 5 70 Month 11 40 Month 6 120 Month 12 50 Starting cash =$ 3,000 Upon completion of the Cash Budget, answer the following questions: 1. What month has the highest cash deficit? O Month 8 O Month 2 O Month 1 O Month3