Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please only answer if you can include excel formulas. Fill out cells with question marks with the proper formula. Thank you Chapter 10: Applying Excel
Please only answer if you can include excel formulas. Fill out cells with question marks with the proper formula. Thank you
Chapter 10: Applying Excel ***** ****************************** .. Standard Quantity HER *************** Data Exhibit 10-1: Standard Cost Card Inputs Direct materials Direct labor Variable manufacturing overhead 3.0 poun... Standard Price $4.00 per pound $22.00 per hour $6.00 per hour irreder ***** 0.50 hours 0.50 hours ***** THERE ... Frrrr. ************ TEC ######## ***** Actual results Actual output Actual variable manufacturing overhead cost ********** it yer** *************************************TERVEERTIER 2,000 units $7,140 Actual Quantity 6,500 pounds ... 1,050 hours **************** . Actual price ***** $3.80 per pound $21.60 per hour Actual direct materials cost Actual direct labor cost ******** ******************************** Str. *** ######## ********* ************ ********* ********* Enter a formula into each of the cells marked with a ? below WHERE Main Example: Chapter 10 ***** ...pe (EFTER ser ******************* HOTELSEFELETTRICI ? pounds x RESISTENT 2 pounds x 2 pounds ? per pound per pound ? per pound ! BEDRE Her ERR ? ? . BEL Exhibit 10-4: Standard Cost Varlance Analysis-Direct Materials Standard Quantity Allowed for the Actual Output, at Standard Price Actual Quantity of Input, at Standard Price Actual Quantity of Input, at Actual Price Direct materials variances: narendanum ........................ Materials quantity variance Materials price variance Materials spending variance sueden ***..... ************** 21 21 ************ REBRER *...******** PRERRARI ***** 2 hours x ? hours x ? hours x ? per hour ? per hour ?iper hour = *** ***** *** Exhibit 10-6: Standard Cost Variance Analysis-Direct Labor Standard Hours Allowed for the Actual Output at Standard Rate Actual Hours of Input, at Standard Rate Actual Hours of Input at Actual Rate Direct labor variances Labor efficiency variance ............ Labor rate variance Labor spending variance ***** ? ? ? **************** + my ................................ ***** ..................RESERVATION HERRE *** ? per hour = ? per hour = Piper hour BER ***** Exhibit 10-8: Standard Cost Variance Analysis-Variable Manufacturing Overhead Standard Hours Allowed for the Actual Output at Standard Rate ? hours x Actual Hours of Input, at Standard Rate 2 x hours x Actual Hours of Input at Actual Rate 2 hours x Variable overhead variances Variable overhead efficiency variance ? Page 1....... Variable overhead rate variance ? Vanable overhead spending variance ? ? ? ****************** RRRRRRR ******************** *************************Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started