160 points Bikes "R" Us manufactures metal frames for mountain bikes. The standard cost per unit of the product is shown below: The predetermined manufacturing overhead rate is $15. Actual costs for October in producing 8.000 units were as follows: Instructions: (a) Compute all of the material variances ( 20 points) NOTE: In order to receive full credit, you must use Excel formulas in each cell with a '?'. (b) Compute all of the labor variances ( 20 points) NOTE: In order to receive full credit, you must use Excel formulas in each cell with a '?? (c) Compute the total overhead variance (15 points) NOTE: In order to receive full credit, you must use Excel formulas in each cell with a ??. (d) Compute the total variance (5 points): (D) Compute all of the material varlances (20 Pointa) Amount Actual Quantity Actual Price ? (hoved to 2 doch int) Standand Cuantity ? Standard Pilce Four io, 2 isocmin? (20 Peints) (b) Compute all of the labor variances (Found ta 2 docmaty) Actuad Hour Actual Rate Value Standard Houn ? Standard Plate Value (Flaind to 2 docinst) \begin{tabular}{cc} Actual Cost & Ameunt \\ \hline Standard Cont \end{tabular} Standard Cost. ? Total taber Vartance Labor Price Varlance Labor Quantity variance Amount ? ? ? ArNigarg: You most (c) Compute the total overhead varlance. wan farmulat in the cally. with a Th or yes will receive 2 inco point: (15 Pointe) (c) Compule the total varlance \begin{tabular}{|c|c|c|} \hline? & \\ \hline? & \\ \hline Amount & Exartiedhatromble \\ \hline? & \\ \hline \end{tabular} Mrminacen: You mutt use formulas in the cetha wath a 7 or yea will recelve triso points. What is the tatal Varlance? (use a formula to calcluate in the Yeliow' ahaded cell below) Total Vartance Ameun: (5 Polnta)]