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

Sales by Month

14.078.0

210.086.0

336.0946.0

457.01047.0

521.01111.0

614.51224.5

TOTAL285.0

(your company name) Contribution Margin Enter sale price per unit Sale price per unit 300.00 100% Variable costs per unit materials 60.00 2 labor 50.00 Enter variable costs description supplies 20.00 and per unit cost XXXX XXXX note: Data entry is required Total Variable Costs 130.00 43% in a minimum of one row Contribution margin per unit 170.00 57% Contribution margin percentage Fixed Costs equip $ 2,400 sal 24.000 taxes 4,800 Data entry required Enter fixed cost adv 1.200 description and annual cost 3 rent 6,000 XXxxx note: Data entry is required xxxx in a minimum of one row XXXXX XXXX XXXXX Total Fixed Costs 38,400 Profit Component 4 Enter profit before income tax Profit before income tax $ 10,000 + Data entry optional Breakeven Analysis Formula Breakeven Point Sales needed to cover Fixed costs + Profit BFIT Units Dollars fixed expenses + profit component Contribution margin 285 $ 85,412 39 Required Sales Volume Sales per Month 24 9 7,118 Sales per Week 1I II 5 1,643 Sales per Day 234 Proof Income Statement Sales in units 285 Sale price per unit 300.00 Total sales 85,412 Sales in units 285 Variable cost per unit 130.00 Total Variable costs 37,012 Contribution margin/Gross Profit 48,400 Fixed expenses 38,400 Profit before income tax 10,000Cash Budget - Non Seasonal Business BTE 302 STEP # 2 Simplified Cash Budget Enter 12 month sales in units - show variation over 12 month period MONTH 1 MONTH 2 MONTH 3 MONTH 4 MONTH 5 MONTH 6 MONTH 7 Units Sold STEP # 3 Cash Inflows Enter breakeven data Unit Sale Price per unit Other Revenues Interest Income Total Inflows - - - - Cash Outflows Variable Costs Outflow 1 per unit Outflow 2 per unit Outflow 3 per unit 1 1 III III 1 1 I Fixed Costs Outflow 1 per month Outflow 2 per month I III I III III I III III III III 1 Outflow 3 per month Outflow 4 1 per month I Outflow 5 per month Outflow 6 per month 1 Outflow 7 per month 1 1 1 1 1 Total Cash Outflows Total Cash outflows - - - - - Cash Surplus or (Deficit) Cash Surplus (Deficit) - - - Beginning Balance Beginning Balance 2, 500 2, 500 2, 500 2, 500 2, 500 2, 500 2, 500 Ending Balance Ending Balance 2, 500 2, 500 2, 500 2, 500 2, 500 2, 500 2, 500STEP # 1 starting point - Sales Per Year data taken from MONTH 7 MONTH 8 MONTH 9 MONTH 10 MONTH 11 MONTH 12 TOTAL In Units breakeven analysis spreadsheet - must equal after unit sales by month entered - - - - Indicates data entry required Data taken from breakeven analysis spreadsheet III III I I I 1 III III I I III III III I IIII III - - - - ending cash balance must 2, 500 2, 500 2, 500 2, 500 2, 500 2, 500 equal profit component + start up cash of 2,500 (may be off slightly due to 2, 500 2, 500 2, 500 2, 500 2, 500 2, 500 rounding error)