req. 1&2 please !

Help ser Exercise 14-29 (Algo) Generating a Flexible Budget; Spreadsheet Application [LO 14-3] C $ 1,986,600 Crane Corporation's master budget for the year is shown below Sales (60,200 units) Cost of goods sold: Direct materials Direct labor $ 150,600 Overhead (variable overhead applied at 30% of 463,560 direct labor cost) 242.000 Gross profit Selling expenses: Sales comissions (all variable) $ 169,463 Rent (all fixed) 42,000 Insurance (all short-term fixed) 32,000 General expenses: 93,000 Salaries (all short-term fixed) 78,000 Rent (all short-term fixed) Depreciation (all short-term fixed) Operating income 886, 140 $ 1,100,460 52.000 456,463 $ 633,997 Required: 1. During the year, the company manufactured and sold 55.200 units of product. Prepare a flexible budget for this level of output 2. Now suppose that the actual level of output was 65,200 units. Prepare a flexible budget for this output level Complete this question by entering your answers in the tabs below. Prev 1 of 5 Next > TELU MILL WIVULVIU CRANE CORPORATION Flexible Budget Sales Less: Cost of goods sold. Direct materials Direct labor 0 $ 0 Manufacturing overhead: Variable Fixed Gross profit Less: Operating expenses Selling expenses: Sales commissions Rent Insurance General expenses: Salaries Rent Depreciation 0 Operating income CA 0 VUL UNILEV Ints CRANE CORPORATION Flexible Budget Sales Less: Cost of goods sold Direct materials Direct labor Manufacturing overhead Variable eBook Print eferences $ $ 0 Fixed Gross profit Less: Operating expenses Selling expenses Sales commissions Rent Insurance General expenses Salaries Rent Depreciation Operating income 5