I need help on this please.

The primary purpose of this assignment is to give you practice calculating and explaining variances Thevariances you need to calculate are described under the "requirements" heading below. The secondary purpose of this assignment is to improve your proficiency in using Excel as a tool for analysis (as opposed to a word processor). All yellow areas should contain formulas referencing other cells, i.c., don't simply type the number $661,254 in cell E6. Rather, enter the formula to calculate this number. Indicate whether variances are favorable (F) or unfavorable (U). Actual Cost Actual Input Quantity Flexible Price Price Variance Paterson Awning manufactures awningsand uses a standard cost system. The company allocates overhead based on the number of direct labor hours. The following are the company's cost and standatds data: Actual Input Quantity Direct Materials Cost 22.00 Yards per awning Price per yard $13.00 Direct Labor 5.00 15.00 8,00 6.00 63,500 Hours per awning Rate per hour Price Variance Variance Variable MOH standard rate per direct labor hour Fixed MOH standard rate per direct labor hour Total budgeted fixed MOH cost Flexible Budget Variance S Variable Manufacturin Actual Cost Actual Input Quantity Actual cost and data from the current month Number of yards purchased Cost of yards purchased Number of yards uscd Number of awnings produced Actual direct labor hours Actual direct labor cost Actual variable MOH Actual fixed MOH 51,260 S 661,254 47,500 2,200 10,850 168,175 93,310 67,500 Price Spending Variance Flexible Budget Variance Requirement 1: Caleculate the following variances using the templates to the right. Actual Cost Actual Input x Bud 1.Direct material variances 2. Direct labor variances 3. Variable MOH variances 4. Fixed MOH variances Allocatood