Please include the excel formulas :)

Integrated Excel: Determining Basic Variance Analysis for Direct Materials, Direct Labor and Variable Overhead The standard cost card for a single unit of Robinson, Incorporated's products is shown below. \begin{tabular}{ll} Budgeted production for the month & 14,000 units \\ Actual production for the month & 13,500 units \end{tabular} Ac Di Di 1 Actua Va $2,45 $1,29 $89 1. Compute the direct material, direct labor and variable overhead variances. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. The standard cost card for a single unit of Robinson, Incorporated's products is shown below. \begin{tabular}{|c|c|c|c|c|c|} \hline & \multicolumn{2}{|c|}{ Standard Quantity } & \multicolumn{2}{|c|}{ Standard Price/Rate } & Standard Unit Cost \\ \hline Direct materials: & 2.5 & yards@ & $8.00 & per yard & $20.00 \\ \hline Direct labor: & 0.5 & hours@ & $18.00 & per hour & 9.00 \\ \hline Variable overhead (based on labor hours): & 0.5 & hours@ & $10.00 & per hour & 5.00 \\ \hline Budgeted production for the month & 14,000 & units & & & \\ \hline Actual production for the month & 13,500 & units & & & \\ \hline Actual Costs Incurred to Produce 13,500 units: & \multicolumn{2}{|c|}{ Standard Quantity } & \multicolumn{2}{|c|}{ Standard Price/Rate } & Total Actual Cost \\ \hline Direct Materials Purchased and Used & 35,100 & yards @ & $7.00 & per yard & $245,700 \\ \hline Direct Labor Paid & 7,425 & hours@ & $17.50 & per hour & $129,938 \\ \hline Variable Overhead Incurred & 7,425 & hours@ & $12.00 & per hour & $89,100 \\ \hline \end{tabular} 1. Compute the direct material, direct labor and variable overhead variances. Complete the following table comparing actual costs to the flexible budget and master budget. Use formulas for the spending and volume variances so that variance will appear as a negative number if unfavorable and a positive number if favorable. 9 Note: Use cell A2 to A15 from the given information to complete this question. 26 Using the formulas provided, compute the following variances. 27 Write if statements to enter an F or U to indicate whether the variance is favorable or unfavorable. 28 Note: Use cell A2 to A15 from the given information to complete this question. 29 30 31 32 33 34 35 36 37 38 39 40 41 \begin{tabular}{|l|l|l|} \hline Direct materials: & Variance & F or U \\ \hline Price Variance =AQ(SPAP) & & \\ \hline Quantity Variance =SP(SQAQ) & & \\ \hline Total Spending Variance & & \\ \hline Direct Labor & & \\ \hline Rate Variance =AH(SRAR) & & \\ \hline Efficiency Variance =SR(SHAH) & & \\ \hline Total Spending Variance & & \\ \hline Variable Overhead & & \\ \hline Rate Variance =AH(SRAR) & & \\ \hline Efficiency Variance =SR(SHAH) & & \\ \hline Total Spending Variance & & \\ \hline \end{tabular} 42