I need help knowing how to compute these (formula in each cell) spreadsheets based off of the information given.

First Tab: Before Flex Budget The company is doing their planning for the coming year and has developed a production cost budget for 12,000 units, and they also want to figure out a budget for other potential production levels. Required: 1) Compute the cost formula for each of the cost elements. 2) Calculate the before-the-fact flexible budget amounts for 8,000 units and 16,000 units (which are both in the relevant range of output). Use excel formulas based on the cost formulas to determine the budgeted amounts. Second Tab: Performance Report Assume that at the beginning of the year, the company settles on the production cost budget for 12,000 units as the most likely scenario and includes that in their master budget. At the end of the year, actual units produced for the year were 11,000. Actual production costs are as shown on the spreadsheet. Required: 1) Prepare a performance report comparing actual results to the static budget (budget at 12,000 units). a. Compute the variance amount. Favorable variances should be shown with parentheses. b. Indicate whether the variance is Favorable - For Unfavorable - U. 2) Prepare a performance report comparing actual results to a budget at the actual level of activity. a. Calculate the budget amounts for each of the cost components based on the cost formula amounts. b. Compute the variance amount. Favorable variances should be shown with parentheses. c. Indicate whether the variance is Favorable - For Unfavorable - U. First Tab: D E F A B 1 Before-the-Fact Flexible Budget 2 3 4 Cost Formula Production Level in Units 8,000 12,000 16,000 5 $360,000 60,000 132,000 72,000 36,000 240,000 6 Direct Materials 7 Direct Labor 8 9 Variable Overhead: 10 Supplies 11 Power 12 Repairs 13 Total Variable Overhead 14 15 Fixed Overhead: 16 Depreciation 17 Salaries 18 Rent 19 Total Fixed Overhead 20 21 Total Product Cost 22 Unit Product Cost 18,000 115,000 53,000 186,000 $ 846,000 $ 70.50 23 24 25 Second Tab: L F/U B D E F H 1 Performance Report, Actual Results vs. Budget 2 3 Performance Report based on Static Budget Performance Report based on Actual Level of Activity 4 Actual Results Static Budget Variance F/U Actual Results Flexible Budget Variance 5 # of Units Produced 11,000 12,000 Cost Formula 11,000 11,000 6 7 Direct Materials $ 338,000 $ 338,000 8 Direct Labor 55,000 55,000 9 10 Variable Overhead: 11 Supplies 125,000 125,000 12 Power 68,000 68,000 13 Repairs 28,000 28,000 14 Total Variable Overhead 221,000 221,000 15 16 Fixed Overhead: : 17 Depreciation 21,000 21,000 18 Salaries 113,000 113,000 19 Rent 53,000 53,000 20 Total Fixed Overhead 187,000 187,000 21 22 Total Product Costs $ 801,000 $ 801,000 23 24 Questions: 25 1. Did the company do a good job of controlling costs? On what do you base your answer? 26 27 28 29 2. How much of the total variance vs. the static budget is due to lower activity and how much is due to good/poor cost control? 30 31