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

The Foundational 15 (Algo) [LO1-1, LO1-2, LO1-3, LO1-4, LO1-5, LO1-6] Skip to question [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: Average Cost Per Unit Direct materials $ 6.90 Direct labor $ 4.40 Variable manufacturing overhead $ 1.50 Fixed manufacturing overhead $ 4.00 Fixed selling expense $ 3.90 Fixed administrative expense $ 2.00 Sales commissions $ 1.00 Variable administrative expense $ 0.50 Foundational 1-14 (Algo) 14. If 11,000 units are produced, what are the total amounts of direct and indirect manufacturing costs incurred to support this level of production? (Do not round intermediate calculations.)
The Foundational 15 (Algo) [LO1-1, LO1-2, LO1-3, LO1-4, LO1-5, LO1-6] Skip to question [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: Average Cost Per Unit Direct materials $ 6.90 Direct labor $ 4.40 Variable manufacturing overhead $ 1.50 Fixed manufacturing overhead $ 4.00 Fixed selling expense $ 3.90 Fixed administrative expense $ 2.00 Sales commissions $ 1.00 Variable administrative expense $ 0.50 Foundational 1-12 (Algo) 12. If 12,500 units are produced, what is the total amount of manufacturing overhead cost incurred to support this level of production? What is this total amount expressed on a per unit basis? (Round your "per unit" answer to 2 decimal places.)
The Foundational 15 (Algo) [LO1-1, LO1-2, LO1-3, LO1-4, LO1-5, LO1-6] Skip to question [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: Average Cost Per Unit Direct materials $ 6.90 Direct labor $ 4.40 Variable manufacturing overhead $ 1.50 Fixed manufacturing overhead $ 4.00 Fixed selling expense $ 3.90 Fixed administrative expense $ 2.00 Sales commissions $ 1.00 Variable administrative expense $ 0.50 Foundational 1-13 (Algo) 13. If the selling price is $22.90 per unit, what is the contribution margin per unit? (Do not round intermediate calculations. Round your answer to 2 decimal places.)
Particulars 2 units 4 units 8 units Direct Material @ $88000 per unit $176000 $352000 $704000 Direct Manufacturing labor @ $25 per labor hour $131750 = (5270 × $25) $224000 = (8960 × $25) $380800 = (15232 × $25) Variable Manufacturing Overheads Cost @ $15 per labor hour $79050 = (5270 × $15) $134400 = (8960 × $15) $228,480 = (15232 × $15) Total Variable Cost of Production $315655 $710400 $1313280
ACC 307 – HW #4 – Chapters 7 and 8 The Beal Manufacturing Company’s costing system has two direct-cost categories: direct materials and direct manufacturing labor. Manufacturing overhead (both variable and fixed) is allocated to products on the basis of standard direct manufacturing laborhours (DLH). At the beginning of 2012, Beal adopted the following standards for its manufacturing costs: Direct materials Direct manufacturing labor Manufacturing overhead: Input 3 lb. at $5 per Ib. 5 hrs. at $15 per hr. Cost per Output Unit $ 15.00 75.00 $6 per DLH $8 per DLH Variable 30.00 40.00 Fixed Standard manufacturing cost per output unit $160.00 The denominator level for total manufacturing overhead per month in 2012 is 40,000 direct manufacturing labor-hours. Beal's flexible budget for January 2012 was based on this denominator level. The records for January indicated the following: Direct materials purchased Direct materials used Direct manufacturing labor Total actual manufacturing overhead…
ACC 307 – HW #4 – Chapters 7 and 8 The Beal Manufacturing Company’s costing system has two direct-cost categories: direct materials and direct manufacturing labor. Manufacturing overhead (both variable and fixed) is allocated to products on the basis of standard direct manufacturing laborhours (DLH). At the beginning of 2012, Beal adopted the following standards for its manufacturing costs: Direct materials Direct manufacturing labor Manufacturing overhead: Input 3 lb. at $5 per Ib. 5 hrs. at $15 per hr. Cost per Output Unit $ 15.00 75.00 $6 per DLH $8 per DLH Variable 30.00 40.00 Fixed Standard manufacturing cost per output unit $160.00 The denominator level for total manufacturing overhead per month in 2012 is 40,000 direct manufacturing labor-hours. Beal's flexible budget for January 2012 was based on this denominator level. The records for January indicated the following: Direct materials purchased Direct materials used Direct manufacturing labor Total actual manufacturing overhead…
ACC 307 – HW #4 – Chapters 7 and 8 The Beal Manufacturing Company’s costing system has two direct-cost categories: direct materials and direct manufacturing labor. Manufacturing overhead (both variable and fixed) is allocated to products on the basis of standard direct manufacturing laborhours (DLH). At the beginning of 2012, Beal adopted the following standards for its manufacturing costs: Direct materials Direct manufacturing labor Manufacturing overhead: Input 3 lb. at $5 per Ib. 5 hrs. at $15 per hr. Cost per Output Unit $ 15.00 75.00 $6 per DLH $8 per DLH Variable 30.00 40.00 Fixed Standard manufacturing cost per output unit $160.00 The denominator level for total manufacturing overhead per month in 2012 is 40,000 direct manufacturing labor-hours. Beal's flexible budget for January 2012 was based on this denominator level. The records for January indicated the following: Direct materials purchased Direct materials used Direct manufacturing labor Total actual manufacturing overhead…
Problem 4Sales Price Php 300 per unitFixed Cost:Marketing and administrative Php 24,000.00 per periodManufacturing overhead Php 30,000.00 per periodVariable Cost:Marketing and administrative Php 6 per unitManufacturing overhead Php 9 per unitDirect Labor Php 30 per unitDirect Materials Php 60 per unitUnit Produced and sold Php 1,200 per periodRequired: 1. Variable manufacturing cost per unit2. Variable cost per unit3. Full manufacturing cost per unit4. Full cost to make and sell per unit5. Compute Net income
The Foundational 15 (Static) [LO9-1, LO9-2, LO9-4, LO9-5, LO9-6] Skip to question [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: 5 pounds at $8.00 per pound $ 40.00 Direct labor: 2 hours at $14 per hour 28.00 Variable overhead: 2 hours at $5 per hour 10.00 Total standard variable cost per unit $ 78.00 The company also established the following cost formulas for its selling expenses: Fixed Cost per Month Variable Cost per Unit Sold Advertising $ 200,000 Sales salaries and commissions $ 100,000 $ 12.00 Shipping expenses $ 3.00 The planning budget for March was based on producing and selling 25,000 units. However, during March the company actually produced and sold 30,000 units and incurred the following costs: Purchased…
ParticularsAmountDirect materialR12Direct laborR50Variable manufacturing overheadR6.50Fixed manufacturing overhead (R81,000/2,550 units)R31.76Unit product cost for the month under absorption costingR100.26 Prepare an income statement for the month using the Marginal costing method
Required information The Foundational 15 (Static) [LO9-1, LO9-2, LO9-4, LO9-5, LO9-6] Skip to question [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: 5 pounds at $8.00 per pound $ 40.00 Direct labor: 2 hours at $14 per hour 28.00 Variable overhead: 2 hours at $5 per hour 10.00 Total standard variable cost per unit $ 78.00 The company also established the following cost formulas for its selling expenses: Fixed Cost per Month Variable Cost per Unit Sold Advertising $ 200,000 Sales salaries and commissions $ 100,000 $ 12.00 Shipping expenses $ 3.00 The planning budget for March was based on producing and selling 25,000 units. However, during March the company actually produced and sold 30,000 units and incurred the following…
1) Eberling, Incorporated, manufactures and sells two products: Product Q9 and Product Z8. Data concerning the expected production of each product and the expected total direct labor-hours (DLHs) required to produce that output appear below: Expected Production Direct Labor-Hours Per Unit Total Direct Labor-Hours Product Q9 900 8.0 7,200 Product Z8 1,000 7.0 7,000 Total direct labor-hours 14,200 The direct labor rate is $27.70 per DLH. The direct materials cost per unit is $122.40 for Product Q9 and $103.20 for Product Z8. The company has an activity-based costing system with the following activity cost pools, activity measures, and expected activity: Activity Cost Pools Activity Measures Estimated Overhead Cost Expected Activity Product Q9 Product Z8 Total Labor-related DLHs $ 531,080 7,200 7,000 14,200 Production orders Orders 74,880 600 700 1,300 Order size MHs 541,944 3,800 4,000 7,800 $ 1,147,904 Required: Determine the unit product cost of each product under the activity-based…