Access the Car Detailing 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: 30 120 130 120 Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 60 90 70 120 Starting cash =$ 3,000 Upon completion of the Cash Budget, answer the following questions: 1. What month has the highest cash deficit Month Amount 2. What month has the highest cash surplus Month Amount 3. What month(s) must the company borrow money Month(s) 4. What is the ending cash balance for Month 6 Breakeven Analysis Car Detailing Inc Contribution Margin Enter sale price per unit Sale price per unit $ 175.00 100% 100% Variable costs per unit supplies Sabor util 2 30.00 75.00 20.00 Enter variable costs description and per unit cost xxxxx Total Variable Costs 125.00 71% note: Data entry is required in a minimum of one row Contribution margin per unit 50.00 29% + Contribution margin percentage Fixed Costs Data entry required Enter fixed cost description and annual cost owner sal owner taxes equip/tool Ise rent advertising insurance misc Xxxxx xxxxx XXXXX Total Fixed Costs 15,000 3,000 3,600 6,000 2,400 3,000 2,500 3 note: Data entry is required in a minimum of one row 35,500 4 Profit Component Enter profit before income tax - Profit before income tax $ 10,000 + Data entry optional Breakeven Analysis Formula Profit BFIT Sales needed to cover fixed expenses + profit component Fixed costs + Contribution margin Breakeven Point Units Dollars 910.00 $ 159,250 Required Sales Volume Month Sales per Sales per Sales per Week 13,271 3,063 436 Day Proof Income Statement 910 $ 175.00 159,250 910 Sales in units Sale price per unit Total sales Sales in units Variable cost per unit Total Variable costs Contribution margin/Gross Profit Fixed expenses 125.00 113,750 45,500 35,500 Profit before income tax 10,000