Need help filling out this excell sheet

1 ACC 3365-Excel Project 2 DUE DATE: Wednesday, Nov.8 not later than 10 a.m. via TRACS "Assignments Student Name: 4 The primary purpose of shis assignment is to give you practice celculating variancos. The 5 variances you need to calculate are descrbed under the "requirements" heading beiow 6 The secondary purpose of this assignment is to improve your proficiency in using Excel as a too 7 for analysis (as opposed to a word p Templates Direct Materials Actual Irput Quantity Example- $661,254 9 REQUIRED: All yellow areas in the templates provided must contain formulas 10 referencing other cells. Do net just type the number $661,254 in coll E6. Rather 11 enter the formula to calculate this number. Ind case whether variances are favorablc (FAV) or 12 unfavorable (UNF) in the "green" cells beside oa variance amount. 13 14 SUBMISSION: Youmust submit this Excel fie (1) with the yellow and green blocks completed and 15 (2) wih the gray shaded areas belaw completed re: narrative analysis. When you submit your file 16 you must name the file in this fermat: ace-3385-Excel-2-lfirst initial & last namel such as acc-3385-Excel-2-CCorn 17 Be certain to include your full rame in the cell on the right side of the first line (above) 18 Assignment wil not be accepted late other than due to emergency situations as described in the syiabus 19 Price Variance Emiciency Varisance NOTE: There is NO "Tota variance because Price & Elliciency Variances are measured af dweren! fimes. PROBLEM: Patarson Awning manufactures awnings and uses a standard cost system. The company 21 aloca os OH based on the number of DL hours, Following are the company's cosi and standerds data: 23 Standards: 24 Direct Materials 25 Yards per awning 26 Price per yard 27 Direct Labor 28 Hours per awning 29 Rate per hour 30 Variable MOH standard rate per direc: labor hour 31 Fxed MCH standerd rate per direct labor hour 32 Toal budgeted tooed MOH cost Acoual Input Quantity x Budgeted (Standard) Price Cost Budget (Applied) 2200 yards 13.00 5.00 hours 15.00 8.00 6.00 Price Variance Efficiency Variance Flexible Budget (TOTAL) Varianc S 63,500 Actual Input Quantity 34 Actual cost and data from the current month: 35 Number of yards purchased 36 Cost of yards purchased 51,280 12.90 ted (Standard) Prioe Bud S 681,254 SAME Number of yards used 8 Number of awrings produced 39 Actual direct labor hours 7,500 yards 10,850 S 15.50 Data Templates+ 1 ACC 3365-Excel Project 2 DUE DATE: Wednesday, Nov.8 not later than 10 a.m. via TRACS "Assignments Student Name: 4 The primary purpose of shis assignment is to give you practice celculating variancos. The 5 variances you need to calculate are descrbed under the "requirements" heading beiow 6 The secondary purpose of this assignment is to improve your proficiency in using Excel as a too 7 for analysis (as opposed to a word p Templates Direct Materials Actual Irput Quantity Example- $661,254 9 REQUIRED: All yellow areas in the templates provided must contain formulas 10 referencing other cells. Do net just type the number $661,254 in coll E6. Rather 11 enter the formula to calculate this number. Ind case whether variances are favorablc (FAV) or 12 unfavorable (UNF) in the "green" cells beside oa variance amount. 13 14 SUBMISSION: Youmust submit this Excel fie (1) with the yellow and green blocks completed and 15 (2) wih the gray shaded areas belaw completed re: narrative analysis. When you submit your file 16 you must name the file in this fermat: ace-3385-Excel-2-lfirst initial & last namel such as acc-3385-Excel-2-CCorn 17 Be certain to include your full rame in the cell on the right side of the first line (above) 18 Assignment wil not be accepted late other than due to emergency situations as described in the syiabus 19 Price Variance Emiciency Varisance NOTE: There is NO "Tota variance because Price & Elliciency Variances are measured af dweren! fimes. PROBLEM: Patarson Awning manufactures awnings and uses a standard cost system. The company 21 aloca os OH based on the number of DL hours, Following are the company's cosi and standerds data: 23 Standards: 24 Direct Materials 25 Yards per awning 26 Price per yard 27 Direct Labor 28 Hours per awning 29 Rate per hour 30 Variable MOH standard rate per direc: labor hour 31 Fxed MCH standerd rate per direct labor hour 32 Toal budgeted tooed MOH cost Acoual Input Quantity x Budgeted (Standard) Price Cost Budget (Applied) 2200 yards 13.00 5.00 hours 15.00 8.00 6.00 Price Variance Efficiency Variance Flexible Budget (TOTAL) Varianc S 63,500 Actual Input Quantity 34 Actual cost and data from the current month: 35 Number of yards purchased 36 Cost of yards purchased 51,280 12.90 ted (Standard) Prioe Bud S 681,254 SAME Number of yards used 8 Number of awrings produced 39 Actual direct labor hours 7,500 yards 10,850 S 15.50 Data Templates+