Question OZ The following estimates have been provided for Martin's Bicycle Shop : Pessimistic forecast Most likely forecast Optimistic forecast Sales $400, 000 $520 , 000 $600 , 000 Costs and expenses , classified according to their behaviour in relation to sales as either Variable* or Fixed are as follows :" Variable Costs Cost of Sales 60% of sales revenue Freight Costs 2` of sales revenue Sales Commissions 3% of sales revenue Sales Discounts 5 % of sales revenue Fixed Costs Depreciation $8, 200 Insurance 51, 600 Office Supplies 54, 800 Power ( Gas & Electricity') 56, 000 Rent of Shop Premises 510, 400 Salaries & Wages 540, 000 Sales Promotion Expenses $12, 000 Required : Prepare a detailed Statement of Financial Performance budget using flexible* budgeting techniques . The task should be completed using excel spreadsheet