Requirement 2:Revise the data in your worksheet to reflect the results for the subsequent period as shown below:ABDE1 Chapter 10: Applying Excel23Data4Exhibit 10-1: Standard Cost CardInputsStandard QuantityStandard Price6.3.0 pounds4.00 per poundDirect materials7 Direct labor0.50 hours22.00 per hour8Variable manufacturing overhead0.50 hours6.00 per hour10 Actual results:11Actual output1,990 units12Actual variable manufacturing overhead cost7,018.0013Actual QuantityActual price14Actual direct materials cost6,060 pounds3.70 per pound15Actual direct labor cost1,210 hours22.10 per houra-1. What is the materials quantity variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable,and "None" for no effect (i.e., zero variance)).The amount of the materials quantity variancea-2. What is the materials price variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable,and "None" for no effect (i.e., zero variance)).The amount of the materials price varianceb-1. What is the labor efficiency variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable,and "None" for no effect (i.e., zero variance)).The amount of the labor efficiency varianceb-2. What is the labor rate variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and"None" for no effect (i.e., zero variance). Round your final answer to nearest whole dollar amount.)The amount of the labor rate variancec-1. What is the variable overhead efficiency variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" forunfavorable, and "None" for no effect (i.e., zero variance)).The amount of the variable overhead efficiency variancec-2. What is the variable overhead rate variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" forunfavorable, and "None" for no effect (i.e., zero variance)).The amount of the variable overhead rate variance A1fxChapter 10: Applying ExcelAВCEF1 Chapter 10: Applying Excel23 Data4 Exhibit 10-1: Standard Cost CardIпрutsStandard Quantity2.9 poundsStandard Price6 Direct materials7 Direct labor8 Variable manufacturing overhead$4.00 per pound$22.00 per hour$6.00 per hour0.60 hours0.60 hours9.10 Actual results:Actual output112,000 units$7,140Actual Quantity6,500 pounds12Actual variable manufacturing overhead costActual price$3.80 per pound$21.60 per hour1314Actual direct materials cost15Actual direct labor cost1,050 hours1617 Enter a formula into each of the cells marked with a ? below18 Main Example: Chapter 101920 Exhibit 10-4: Standard Cost Variance Analysis- Direct Materials21 Standard Quantity Allowed for the Actual Output, at Standard Price22 Actual Quantity of Input, at Standard Price23 Actual Quantity of Input, at Actual Price5,800 pounds x6,500 pounds x6,500 pounds x$4.00 per pound =$4.00 per pound =$3.80 per pound =$23,200$26,000$24,70024 Direct materials variances:Materials quantity varianceMaterials price varianceMaterials spending variance$2,660 U$1,300 F$1,500 U2526272829 Exhibit 10-6: Standard Cost Variance Analysis-Direct Labor30 Standard Hours Allowed for the Actual Output, at Standard Rate31 Actual Hours of Input, at Standard Rate32 Actual Hours of Input, at Actual Rate$22.00 per hour =$22.00 per hour =$21.60 per hour =$26,400$23,100$22,6801,200 hours x1,050 hours x1,050 hours x33 Direct labor variances:Labor efficiency varianceLabor rate variance$3,300 F$420 F$3,720 F343536Labor spending variance3738 Exhibit 10-8: Standard Cost Variance Analysis-Variable Manufacturing Overhead39 Standard Hours Allowed for the Actual Output, at Standard Rate40 Actual Hours of Input, at Standard Rate41 Actual Hours of Input, at Actual Rate42 Variable overhead variances:1,200 hours x1,050 hours x1,050 hours x$6.00 per hour =$6.00 per hour =$6.80 per hour =$7,200$6,300$7,140$900 F$840 U$60 F43Variable overhead efficiency variance44Variable overhead rate variance45Variable overhead spending variance

A B 1 Chapter 10: Applying Excel 2 3 Data 4 Exhibit 10-1: Standard Cost Card Inputs Standard Quantity Standard Price 6 Direct materials 7 Direct labor 8 Variable manufacturing overhead 3.0 pounds 4.00 per pound 0.50 hours 0.50 hours 22.00 per hour 6.00 per hour 6. 10 Actual results: 11 Actual output 1,990 units 12 Actual variable manufacturing overhead cost 7,018.00 13 Actual Quantity Actual price 6,060 pounds 1,210 hours 14 Actual direct materials cost 3.70 per pound 15 Actual direct labor cost 22.10 per hour a-1. What is the materials quantity variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)). The amount of the materials quantity variance a-2. What is the materials price variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)). The amount of the materials price variance b-1. What is the labor efficiency variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)).

A B 1 Chapter 10: Applying Excel 2 3 Data 4 Exhibit 10-1: Standard Cost Card Inputs Standard Quantity Standard Price 6 Direct materials 7 Direct labor 8 Variable manufacturing overhead 3.0 pounds 4.00 per pound 0.50 hours 0.50 hours 22.00 per hour 6.00 per hour 6. 10 Actual results: 11 Actual output 1,990 units 12 Actual variable manufacturing overhead cost 7,018.00 13 Actual Quantity Actual price 6,060 pounds 1,210 hours 14 Actual direct materials cost 3.70 per pound 15 Actual direct labor cost 22.10 per hour a-1. What is the materials quantity variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)). The amount of the materials quantity variance a-2. What is the materials price variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)). The amount of the materials price variance b-1. What is the labor efficiency variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)).

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Applying Excel 13: Predetermined Overhead Rate ✓ 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 A B Raw Materials Inventory 57,500 5,700 43,000 Finished Goods Inventory 216,000 Factory Overhead 14,800 61,000 52,300 6,000 Multiple Choice с =+C17/F11 =+C17/(SUM(B17:B19)) =+E5/E3 37,000 14.800 173,000 =+E5/E4 122,100 D E Assuming the company applies overhead as a percentage of direct labor cost, which formula accurately computes the predetermined overhead rate? Work in Process Inventory 37,000 216,000 111.000 122,100 54,100 Factory Wages Payable 172,000 0 111.000 ......... 61,000
A 1 Chapter 7: Applying Excel 2 3 Data 4 Selling price per unit 5 Manufacturing costs: 6 7 8 Variable per unit produced: Direct materials Direct labor Variable manufacturing overhead 9 10 Fixed manufacturing overhead per year 11 Selling and administrative expenses: 12 Variable per unit sold 13 Fixed per year 14 15 16 Units in beginning inventory 17 Units produced during the year 18 Units sold during the year 25 Units in beginning inventory 26 Units produced during the year 27 Units sold during the year 28 Units in ending inventory 29 30 Compute the Absorption Costing Unit Product Cost 31 32 Direct materials 33 Direct labor 34 Variable manufacturing overhead 35 Fixed manufacturing overhead 36 Absorption costing unit product cost 37 19 20 Enter a formula into each of the cells marked with a ? below 21 Review Problem 1: Contrasting Variable and Absorption Costing 22 23 Compute the Ending Inventory 24 46 Compute the Variable Costing Unit Product Cost 47 48 Direct materials 49 Direct labor…
AIP 9.6 Process Costing and Under-Absorbed Overhead LO 5, 8 Process costing can be performed with estimated cost and production data and actual cost and production data. A company estimated total manufacturing costs to be €4 million and estimated equivalent units be 20,000; therefore, the estimated cost per equivalent unit was €200. Inventory costs were adjusted for completed units based on this €200 estimated cost per equivalent unit. At the end of the year, the actual manufacturing costs were €5 million and the equivalent units produced were actually 22,000. How would you determine and account for the under-absorbed overhead?
EXERCISE 1-7 Direct and Indirect Costs L01-1 2.000.81 10 Kubin Company's relevant range of production is 18,000 to 22,000 units. When it produces and sells 20,000 units, its average costs per unit are as follows: Juris Required: 1. 2. 3. 4. a. b. a. b. the Untus ha babubong asin Direct materials.. Direct labor Variable manufacturing overhead Fixed manufacturing overhead Fixed selling expense Fixed administrative expense.. Sales commissions...... Variable administrative expense. b. Average Cost per Unit $7.00 $4.00 $1.50 $5.00 $3.50 $2.50 $1.00 $0.50 Assume the cost object is units of production: What is the total direct manufacturing cost incurred to make 20,000 units? What is the total indirect manufacturing cost incurred to make 20,000 units? Assume the cost object is the Manufacturing Department and that its total output is 20,000 units. How much total manufacturing cost is directly traceable to the Manufacturing Department? How much total manufacturing cost is an indirect cost that…
question 2
Period Co 5 AA Chapter 1 Assignment 7 A ! Home | bartl.. 2 W # S Total product cost ezto.mheducation.com A Okay 23 my.post.edu... Direct materials. Direct labor Variable manufacturing overhead Fixed manufacturing overhead Fixed selling expense Fixed administrative expense Sales commissions Variable administrative expense 3 E $ D () Required information [The following information applies to the questions displayed below.] Martinez Company's relevant range of production is 7,500 units to 12,500 units. When it produces and sells 10,000 units, its average costs per unit are as follows: $ 150,000 Saved 4 5 R T & LL V Question 1 -... Required: 1. For financial accounting purposes, what is the total amount of product costs incurred. to make 10,000 units? (Do not round intermediate calculations.) * 6 Y B G H 5 7 N G what is the h... Help U J Average Cost per Unit Save & Exit $7.00 $ 4.50 $ 1.40 $ 4.00 $ 4.00 $ 2.10 $ 1.10 $ 0.55 M You 8 1 K ! Init 1-C... Check my work I 9 O Submit L ? ct 0 P…
Assignment Ch 4 еBook Print Item Activity-Based Costing and Product Cost Distortion Four Finger Appliance Company manufactures small kitchen appliances. The product line consists of blenders and toaster ovens. Four Finger Appliance presently uses the multiple production department factory overhead rate method. The factory overhead is as follows: Assembly Department $186,000 Test and Pack Department 120,000 Total $306,000 The direct labor information for the production of 7,500 units of each product is as follows: Assembly Department Test and Pack Department Blender 750 dlh 2,250 dlh Toaster oven 2,250 750 Total 3,000 dlh 3,000 dlh Four Finger Appliance used direct labor hours to allocate production department factory overhead to products. The management of Four Finger Appliance Company has asked you to use activity-based costing to allocate factory overhead costs to the two products. You have determined that $81,000 of factory overhead from each of the production departments can be…
Unit 6 - Chapter 9 Assignment i 13 Part 13 of 15 10 points Required information Saved [The following information applies to the questions displayed below.] Preble Company manufactures one product. Its variable manufacturing overhead is applied to production based on direct labor-hours and its standard cost card per unit is as follows: Direct material: 6 pounds at $9.00 per pound Direct labor: 3 hours at $15 per hour 02:28:35 Variable overhead: 3 hours at $5 per hour Total standard variable cost per unit Print $ 54.00 45.00 15.00 $ 114.00 The company also established the following cost formulas for its selling expenses: Variable Fixed Cost per Cost per Unit Sold Advertising Sales salaries and commissions Shipping expenses Month $ 260,000 $ 220,000 $ 18.00 $ 9.00 The planning budget for March was based on producing and selling 20,000 units. However, during March the company actually produced and sold 25,000 units and incurred the following costs: a. Purchased 180,000 pounds of raw…
Question 9.3 Burnaby traders makes four products in a single facility. Following information regarding products is given: Product A B C D Selling Price per Unit $35.30 $30.20 $20.80 $26.00 Variable Manufacturing Cost per Unit $16.50 $15.80 $7.90 $8.50 Variable Selling Cost per Unit $3.80 $1.60 $1.90 $3.30 Milling Machine Minutes per Unit 3.20 1.80 2.20 2.50 Monthly Deman in Units 4,000 1,000 3,000 1,000 Maximum minutes on all machines (22,600) Required: 1) How many minutes of milling machine time would be required to satisfy demand for all four products? 2) Which product makes the LEAST profitable use of the milling machines? 3) Which product makes the MOST profitable use of the milling machines?
E 3 Mc Graw Hill connect® Problem 20-1A Weighted average: Cost per equivalent unit; costs assigned to products P1 Victory Company uses weighted average process costing. The company has two production processes. Conversion cost is added evenly throughout each process. Direct materials are added at the beginning of the first process. Additional information for the first process follows. Beginning work in process inventory Units started this period Units completed and transferred out Ending work in process inventory C $ Check (2) Conversion cost per equivalent unit, $4.50 4 Conversion Costs added this period Direct materials % Beginning work in process inventory Direct materials Conversion Total costs to account for 5 Required 1. Compute equivalent units of production for both direct materials and conversion. 2. Compute cost per equivalent unit of production for both direct materials and conversion. Unit Oll 60,000 820,000 700,000 180,000 A 6 Direct Materials Percent Complete $ 420,000…