Include formulas for each cell

Liner Filler C B 8.20 $ 1.90 Direct Materials Variance 8.00 2.00 Price variance: 0.20 Actual price (0. 10 85, 100 12,220 Standard price 48,000 17,020 $ Variance $ (4,800) Actual quantity Direct materials price variance-(favorable) unfavorable 85, 100 48,000 Quantity variance: Actual quantity used (lbs.) Standard quantity used (Ibs.) Variance (lbs.) Standard price Direct materials quantity vanance-(favorable) unfavorable Total direct materials cost variance-(favorable) unfavorable Total direct materials cost variance Actual cost Standard cost Total direct materials cost variance-(favorable) unfavorable Men's Total Supporting calculations Worners Standard quantity used of filler: 4,400 5,800 Coats produced Standard amount per coal (Ibs.) Total Standard quantity used of liner. Coats produced Standard amount per coat (yds.) Total Women's Men's Coats Costs Total Direct Labor Variance Rate variance: Actual rate Standard rate Variance Actual time Direct labor rate variance-(favorable) unfavorable Time variance Actual time Standard time Variance Standard rate Direct labor time variance-(favorable) unfavorable Total direct labor cost variance-(favorable) unfavorable Total direct labor cost variance: Actual cost 67 Standard cost 6B Total direct labor cost variance-(favorable) unfavorable 69 70 Pr. 23-2B Enter Accessibility; Investigate + 100% OM - ACG2071 - SOA - 2023 Spring (7) References Mailings Review View ? Tell me Comments Flexible budgeting and variance analysis Obj. 1, 2, 3 ExcelI'm Really Cold Coat Company makes women's and men's coats. Both products require filler and lining material. The following planning information has been made available: Standard Amount per Unit Women's Coats Men's Coats Standard Price per Unit Filler 4.0 lb 5.2 lb. $2.00 per lb. Liner 7.0 yds 9.4 yds. 8.00 per yd. Standard labor time 0.40 hr. 0.50 hr. Women's Coats Men's Coats Planned production 5,000 units 6,200 units Standard labor rate $14.00 per hr. $13.00 per hr. I'm Really Cold Coat Company does not expect there to be any beginning or ending inventories of filler and lining material. At the end of the budget year, I'm Really Cold Coat Company experienced the following actual results: Women's Coats Men's Coats Actual production 4,400 5,800 Actual Price per Unit Actual Quantity Purchased and Used Filler $1.90 per lb. 48,000 Liner 8.20 per yd. 85,100 Actual Labor Rate Actual Labor Hours Used Women's coats $14.10 per hr. 1,825 Men's coats 13.30 per hr. 2,800 The expected beginning inventory and desired ending inventory were realized. Instructions 1. Prepare the following variance analyses for both coats and the total, based on the actual results and production levels at the end of the budget year: 1. Direct materials price, quantity, and total variance Answer Check Figure: Direct materials price variance, $12,220 U 2. Direct labor rate, time, and total variance 2. Why are the standard amounts in part (1) based on the actual production at the end of the year instead of the planned production at the beginning of the year