please do the excel portion completely

Direct Materials Variance Flller Uner Total Price variance: Actual price Standard price Variance Actual quantity Diroct materials price variance-(favorable) unfavorable Quantity varlance: Actual quantity used Standard quantity used Variance Standard price Direct materials quantity variance-(favorable) unfavorable Total direct materials cost variance-(favorablo) unfavorable Total direct materials cost variance: Actual cost Standard cost Total direct materials cost variance-(favorable) unfavorable Supporting calculations: Total Standard quantity used of fller Coats produced Standard amount per coat (bs.) Total Standard quantity used of liner. Coats produced Standard amount per coat (yds.) Total b. \begin{tabular}{|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} Time variance Actual tiime Standard time Varance Standard rate Direct labor time variance- (favorable) unfavorable Total direct labor cost variance-(favorable) unfavorable Total direct labor cont variance: Actual cost Standard cost Total direct labor cost variance- (favorable) unfavorable 2. [Key essay antwer here] Standard Amount per Unit \begin{tabular}{|c|c|c|} \hline & Women's Coats & Men's Coats \\ \hline Planned production & 5,000 units & 6,200 units \\ \hline Standard labor rate & $14.00 per hr. & $13.00 per hr. \\ \hline \end{tabular} 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: 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: a. Direct materials price, quantity, and total variance. Answer: Check Figure: Direct materials price variance, $12,220U b. 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? Direct Materials Variance Flller Uner Total Price variance: Actual price Standard price Variance Actual quantity Diroct materials price variance-(favorable) unfavorable Quantity varlance: Actual quantity used Standard quantity used Variance Standard price Direct materials quantity variance-(favorable) unfavorable Total direct materials cost variance-(favorablo) unfavorable Total direct materials cost variance: Actual cost Standard cost Total direct materials cost variance-(favorable) unfavorable Supporting calculations: Total Standard quantity used of fller Coats produced Standard amount per coat (bs.) Total Standard quantity used of liner. Coats produced Standard amount per coat (yds.) Total b. \begin{tabular}{|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} Time variance Actual tiime Standard time Varance Standard rate Direct labor time variance- (favorable) unfavorable Total direct labor cost variance-(favorable) unfavorable Total direct labor cont variance: Actual cost Standard cost Total direct labor cost variance- (favorable) unfavorable 2. [Key essay antwer here] Standard Amount per Unit \begin{tabular}{|c|c|c|} \hline & Women's Coats & Men's Coats \\ \hline Planned production & 5,000 units & 6,200 units \\ \hline Standard labor rate & $14.00 per hr. & $13.00 per hr. \\ \hline \end{tabular} 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: 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: a. Direct materials price, quantity, and total variance. Answer: Check Figure: Direct materials price variance, $12,220U b. 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