If you can, please, solve in Excel and show formula keys used.

Preble Company manufactures one product. Its variable manufacturing overhead is applied to production based on direct labor-hours and its standard cost card per unit is as follows: Direct material: 5 pounds at $8.00 per pound Direct labor: 2 hours at $14 per hour Variable overhead: 2 hours at $5 per hour Total standard variable cost per unit $ 40.00 28.00 10.00 $ 78.00 The company also established the following cost formulas for its selling expenses: Variable Cost per Unit Sold Fixed Cost per Month $ 200,000 $ 100,000 Advertising Sales salaries and commissions Shipping expenses $ 12.00 $ 3.00 The planning budget for March was based on producing and selling 25,000 units. However, during March the company actually produced and sold 30,000 units and incurred the following costs: a. Purchased 160,000 pounds of raw materials at a cost of $7.50 per pound. All of this material was used in production b. Direct-laborers worked 55,000 hours at a rate of $15.00 per hour. c. Total variable manufacturing overhead for the month was $280,500. G 1 2 3 4 Prey of 4 Next > b. Direct-laborers worked 55,000 hours at a rate of $15.00 per hour. c. Total variable manufacturing overhead for the month was $280,500. d. Total advertising, sales salaries and commissions, and shipping expenses were $210,000, $455,000, and $115,000, respectively. Foundational 9-12 (Static) 12. What amounts of advertising, sales salaries and commissions, and shipping expenses would be included in the company's flexible budget for March? Advertising Sales salaries and commissions Shipping expenses Foundational 9-13 (Static) 13. What is the spending variance related to advertising? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.). Input the amount as a positive value.) Spending variance related to advertising ho Foundational 9-14 (Static) 14. What is the spending variance related to sales salaries and commissions? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.). Input the amount as a positive value.) Spending variance related to sales salaries and commissions 15. What is the spending variance related to shipping expenses? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.). Input the amount as a positive value.) Spending variance related to shipping expenses