Please post what you did to get these answers as well....

Using the completed breakeven analysis (below) for the Specialty Cake business, prepare the 12 month cash forecast (below)

Sales by Month

1 4.0 7 8.0

2 10.0 8 6.0

3 36.0 9 46.0

4 57.0 10 47.0

5 21.0 11 11.0

6 14.5 12 24.5

TOTAL 285.0

Beginning balance = $2,500

Simplified Cash Budget - 12 Month Forecast STEP & Enter data from Breakeren Analysis STEP # 2 Breakdos 12 month sales in mits - shoz tariations orer 12 month period, total nust equal sales per year in units Sales Per Year MONTH 1 MONTH 2 MONTH 3 MONTH 4 MONTH 5 MONTH 6 MONTH 7 MONTH 8 MONTH 9 MONTH 1 MONTH 11 MONTH 1: TOTAL In Unit nits Sold 0 STEP 4 3 Enter Breakeren data below Data entry required in highlighted fields sh Inflows Amount mit Sale Price per unit $ $ $ $ $ $ $ $ $ $ tal Inflows $ $ $ $ $ $ ash Outflows Per Unit Amount $ $ $ $ $ $ $ $ Annual Amount ariable Costs ter description ter description ter description ired Costs ter description ter description ter description ter description ter description ter description ter description $ $ $ $ $ $ $ $ $ $ $ $ $ $ otal Cash Outflows Total Cash outflows $ $ $ $ $ $ $ $ $ $ $ och Surplus or (Defici Cash Surplus (Dcficit) $ $ $ $ $ $ $ $ eginning Balance Beginning Balance $ - $ $ $ $ $ $ $ ding Balance Ending Balance $ $ $ $ $ $ $ Ending cash balance must equal profit component + start p cash (may be off slightly due to rounding error] Step 4 Enter beginning cash balance Breakeven Analysis (your company name) Contribution Margin ater sale price per unit $ 300.00 100% Sale price per unit Variable costs per unit materials labor supplies 60.00 50.00 20.00 2 ter variable costs description nd per unit cost ote: Data entry is required in a minimum of one row Total Variable Costs 130.00 43% Contribution margin per unit $ 170.00 57% Contribution margin percentage Fixed Costs equip sal taxes ady rent 2,400 24,000 4,800 1,200 6,000 Data entry required 3 Enter fixed cost escription and annual cost ote: Data entry is required in a minimum of one row Total Fixed Costs $ 38,400 4 Profit before income tax $ 10,000 Data entry optional Profit Component ter profit before income tax Breakeven Analysis Formula Sales needed to cover fixed expenses + profit component Fixed costs + Profit BFIT Contribution margin Breakeven Point Units Dollars 285 $ 85,412 11