Please answer with the formulas thank you

The primary purpose of this assignment is to give you practice calculating variances. The Templates variances you need to calculate are described under the "REQUIRED" heading below. Direct Materials The secondary purpose of this assignment is to improve your proficiency in using Excel as a tool Actual Actual Input Quantity Flexible for analysis (as opposed to word processing software). Cost x Budgeted (Std) Price Budget (Applied) Example: Purchases Usage REQUIRED: 810,000 All yellow cells in this template (right) must be completed with formulas referencing other cells. For example, do not just type the number $810,000 in cell F9. Instead, you must enter the formula in the cell to calculate this number. Indicate whether variances are favorable (FAV) or unfavorable (UNF) Price Variance Efficiency Variance in the "green" cells beside each amount. Some formulas will reference the problem; other formulas will use cells in the template. Variances should not have a minus sign or parentheses. NOTE: There is NO "total" variance because Price & Efficiency Variances are measured at different times for D SUBMISSION: You must submit your Excel file (1) with the yellow and green cells completed and Direct Labor (2) submit a written report in Word according to instructions included in the Canvas assignment. You must Actual Actual Input Quantity Flexible name the file in this format: acc-3365-Excel-(1st initial & last name) and acc-3365-Word-(1st initial & last Cost x Budgeted (Std) Rate Budget (Applied) name) Be certain to include your full name in the cell in the upper right corner of the first line (above) in this file. Assignment will not be accepted late other than due to emergency situations as described in the syllabus. PROBLEM: Mascot Mfg. makes costumes for athletic team mascots and uses a standard costing system. The company recognizes (isolates) materials price variances at the time the materials are purchased. Price Variance Efficiency Variance They allocate (apply) OH based on # of DL hours. Following are this year's cost and standards data; assumes 52 weeks per year. Flexible Budget (TOTAL) Variance Actual cost and data from the current month: Variable Manufacturing Overhead Actual number of yards of materials purchased 28,500 Actual Actual Input Quantity Flexible Actual cost of materials purchased 810,000 $ 28.42 per yd Cost Incurred x Budgeted (Std) Rate Budget (Applied) Allocated Actual number of yards used in production 27,350 Actual number of costumes produced 2,300 Actual direct labor hours 133,500 Actual direct labor cost LA 5,500,000 $ 41.20 per hr Actual variable MOH (in total) 665,000 Spending Variance Efficiency Varience Actual fixed MOH (in total) 1,488,000 Flexible Budget (TOTAL) Variance Standards (for a planned level of production of 2,200 units per month) Direct Materials: Fixed Manufacturing Overhead Yards per costume 12.50 yards Actual Flexible Budget Price per yard A 26.00 average Cost Incurred Static FOH Budget (Same as Static) Allocated Direct Labor: D.L. Hours per costume 62.00 hours D.L. Rate per hour 44.50 average Variable MOH standard rate per direct labor hour 4.35 per D.L. hour Fixed MOH standard rate per direct labor hour 9.47 per D.L. hour Spending Variance Production Volume Variance Total Budgeted Fixed MOH (for 1 month) 1,250,000 TOTAL Fixed OH Variance Requirement #1: Using Excel functionality, calculate these variances using the templates to the right