Please help with the below question, there is an excel spreadsheet attached that needs to be filled out:

LO.3 (Comprehensive) Piedmont Manufacturing produces metal products with the following standard quantity and cost information: Direct Material Aluminum Copper Direct labor Variable overhead Fixed overhead 4sheets@$4 3 sheets @ $8 7 hours @ $16 5 machine hours @ $6 5 machine hours @ $4 $ 16 24 112 30 20 Overhead rates were based on normal monthly capacity of 6,000 machine hours. During November, the company produced only 850 units because of a labor strike, which occurred during union contract negotiations. After the dispute was set- tled, the company scheduled overtime to try to meet regular production levels. The fol- lowing costs were incurred in November: Material Aluminum Copper Direct Labor Regular time Regular time Variable Overhead 4,000 sheets purchased @ $3.80; used 3,500 sheets 3,000 sheets purchased @ $8.40; used 2,600 sheets 5,200 hours @ $16 (pre-contract settlement) 900 hours @ $17 (post-contract settlement) $23,300 (based on 4,175 machine hours) Fixed Overhead $18,850 (based on 4,175 machine hours) Determine the following and prepare the journal entries to record the standard costing information for November: a. Total material price variance b. Total material usage (quantity) variance c. Labor rate variance d. Labor efficiency variance e. Variable overhead spending variance f.Variable overhead efficiency variance g. Fixed overhead spending variance h. Volume variance i.Budget variance

Problem 7-58 Name: Insert or select your answers in the gray-shaded cells. If an answer is incorrect, the word "wrong" will appear. a. Material price variance: Material price variance = AQ x (AP - SP) Aluminum Copper Total Copper Total Actual price (AP) - Standard price (SP) x Actual quantity used (AQ) Material price variance b. Material usage variance: Standard quantity of aluminum Standard quantity of copper Material usage variance = SP x (AQ - SQ) Aluminum Actual quantity (AQ) - Standard quantity (SQ) x Standard price (SP) Material usage variance c. Labor rate variance: Total actual labor cost Standard labor cost d. Labor efficiency variance: Labor efficiency variance = SP x (AH - SH) Actual hours (AH) Standard hours (SH) Standard price (SP) Labor efficiency variance e. Variable overhead spending variance: Actual VOH Budgeted VOH at actual hrs. f. Variable overhead efficiency variance: Budget at actual Less: Budget at standard g. Fixed overhead spending variance: Actual FOH Budgeted FOH h. FOH volume variance: Budget FOH Applied FOH i. Budget variance: Actual OH Budgeted OH at standard hrs. OR VOH spending VOH efficiency FOH spending