Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please include an excel formula for every cell with a question mark Chapter 10: Applying Excel 6. Estetid ******************** .. ... Data Exhibit 10-1: Standard

image text in transcribed

Please include an excel formula for every cell with a question mark

Chapter 10: Applying Excel 6. Estetid ******************** .. ... Data Exhibit 10-1: Standard Cost Card Inputs Direct materials Direct labor RU Variable manufacturing overhead HELLERE Standard Quantity 3.0 pounds 0.50 hours 0.501 hours ********** Standard Price $4.00 per pound $22.00 per hour $6.00 per hour ... *************************** ERER *********** ************ RE********************************** ***HERE BESTSERESSE ***** Actual results Actual output Actual variable manufacturing overhead cost TERCEPERIRE HEREHE ** HOTEL THERRIER***** . 2,000 units $7,140 Actual Quantity 6,500 pounds 1,050 hours T ... SHARES Actual direct materials cost EXTREMITTANUT Actual direct labor cost Actual price $3.80 per pound $21.60 per hour ********* FERRETERLE... ELLER Enter a formula into each of the cells marked with a ? below Main Example: Chapter 10 PREFERRER ****************** 1CREEN THERE WEITERE 2 ? pounds x 2 pounds x 2 pounds x ? iper pound = per pound = ?i per pound *** LIBERABERLEHETHERE BEREIFISPRATITEETTI HERRESERR** Exhlblt 10-4: Standard Cost Varlance Analys/s-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: STARTER Materials quantity variance Materials price variance Materials spending variance Persian RRE ? 2 ***** EDELIVEREIRREGUT 14:4138........................ ? ***FREE*** *** ***** BERETETTELEENTE HVERNARE 3*** CERERE * hours x inseri 2 hours x IEEE 2 hours x Exhibit 10-6: Standard Cost Variance Analysis-Direct Labor Standard Hours Allowed for the Actual Output at Standard Rate REHBETHIDHIW Actual Hours of Input at Standard Rate ********** THERE Actual Hours of Input, at Actual Rate Direct labor variances Labor efficiency variance ....... Labor rate variance Labor spending variance ? per hour ? per hour = ? per hour ? ? HERE*********** ********* RESIERT HARD******* ? TERRESTREIBEREBROCHET ********************** ? BERRIER ?iper hour = ? per hour = ? per hour RESISTERS 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 artani..... ? hours x Actual Hours of Input, at Actual Rate ? hours X Variable overhead variances: Variable overhead efficiency variance ? Page 1 Variable overhead rate variance Variable overhead spending variance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Total Quality Safety Management And Auditing

Authors: Michael B. Weinstein

1st Edition

1566702836, 978-1566702836

More Books

Students also viewed these Accounting questions