Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions