Can you do it in Excel and put the formulas ( CNTRL ~) please!!

,000 shirts. 10.1 Shirt Company prepared the following budget for 201X based on the production and sale of 6 $270,000 Sales Cost of goods sold Depreciation (straight-line) Direct labor Direct materials Machinery repairs ($900 fixed) Plant (factory) managers salary Factory Insurance Utilities ($3,000 fixed) Gross proft Operating Expenses (SG&A) Administrative salaries Advertising expense Packaging expense Sales commissions expense Shipping expense Travel & entertainment expense $3,400 15,000 62,400 1,800 40,000 2,400 6.000 131.000 $139,000 S60,000 20,000 2,400 6,000 12,000 5000 105,400 $33,600 Operating Income A. Classify each cost as either variable or fixed. B. Calculate the cost per unit for all variable costs. C. Prepare flexible budgets using the contribution margin format (Sales - VC- CM-FC OD Assume sales of four, six, and eight thousand units. 10.2 Shirt Company's actual income statement for 201X (from problem 10.1) is shown below. Shirt Co sold 7,600 units during the year. Prepare a budget to actual performance report using the contribution margin format. (Be sure to make a fair comparison by recasting the budget at the actual activity level). Sales Cost of goods sold Depreciation (straight-line) Direct labor Direct materials Machinery repairs ($900 fixed) Plant (factory) managers salary Factory Insurance Utilities ($3,000 was fixed) Gross profit Operating Expenses (SG&A Administrative salaries Advertising expense Packaging expense Sales commissions expense Shipping expense Travel & entertainment expense Operating Income $326,800 $3,600 19,776 75,776 2,000 38,000 2,500 6.040 $147.692 $179,108 $57,000 22,000 3,420 7,448 15,580 4.000 $69,660 61