Bellingham Company produces a product that requires 2.5 standard pounds per unit. The standard price is $3.65 per pound. 15,100 units used 36,400 pounds, which were purchased at $3.85 per pound. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet What is the direct materials (a) price variance, (b) quantity variance, and (c) cost variance? Round your answers to the nearest dollar. Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number. a. Direct materials price variance b. Direct materials quantity variance c. Direct materials cost variance $ $ $

Bellingham Company produces a product that requires 2.5 standard pounds per unit. The standard price is $3.65 per pound. 15,100 units used 36,400 pounds, which were purchased at $3.85 per pound. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet What is the direct materials (a) price variance, (b) quantity variance, and (c) cost variance? Round your answers to the nearest dollar. Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number. a. Direct materials price variance b. Direct materials quantity variance c. Direct materials cost variance $ $ $

Name: Bellingham Company produces a product that requires 2.5 standard poun
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: Bellingham Company produces a product that requires 2.5 standard pounds per unit. The standard price is $3.65 per pound. 15,100 units used 36,400 pounds, which were purchased at $3.85 per pound.This information has been collected in the Microsoft Ex

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter24: Material And Labor Variances (primevar)

Section: Chapter Questions

Problem 4R: The worksheet you have developed will handle most simple variance analysis problems. Try the problem...

See similar textbooks

Similar questions

The worksheet you have developed will handle most simple variance analysis problems. Try the problem below for Pscheidl, Inc.: Actual production for October was 11,500 units. Compute the direct materials and direct labor variances for Pscheidl, Inc. Be careful when entering your input because this problem presents the information in a different format from the McGrade Industries data. Save the file as PRIMEVAR4. Print the worksheet when done.
Bellingham Company produces a product that requires 3 standard direct labor hours per unit at a standard hourly rate of $20.00 per hour. 15, 800 units used 63,000 hours at an hourly rate of $19.65 per hour. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet What is the direct labor (a) rate variance, (b) time variance, and (c) cost variance? Round your answers to the nearest dollar. Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number. a. Direct labor rate variance $fill in the blank 2 b. Direct labor time variance $fill in the blank 4 c. Direct labor cost variance $fill in the blank 6
Acme Inc. has the following information available: Actual price paid for material $0.900 Standard price for material $0.625 Actual quantity purchased and used in production 90 Standard quantity for units produced 60 Actual labor rate per hour $16 Standard labor rate per hour $14 Actual hours 210 Standard hours for units produced 220 Compute the material price and quantity, and the labor rate and efficiency variances. Round your answers to two decimal places. Enter all amounts as positive numbers. Material price variance $fill in the blank 1 Material quantity variance $fill in the blank 3 Labor rate variance $fill in the blank 5 Labor efficiency variance $fill in the blank 7
Best, Inc. uses a standard cost system and provides the following information. (Click the icon to view the information.) variable overhead, $3,800; actual fixed overhead, $3, 500; actual direct labor hours, 1,400. Read the requirements. Data table Requirement 1. Compute the variable overhead cost and efficiency variances and fixed overhead cost and volume variances. Begin with the variable overhead cost and efficiency variances. Select the required formulas, compute the variable overhead cost and favorable (F) or unfavorable (U). (Abbreviations used: AC = actual cost; AQ = actual quantity; FOH = fixed overhead; SC = standardco \table [[,, Formula,Variance], [VOH cost variance, = , 1 = , ], [VOH efficiency variance, =,1 =, 0
Last month, Bugsby Corporation purchased and used the same quantity of material in producing its product, speed bumps for traffic control. FE(Click the icon to view the table.) Complete the following table. (Round your answers to two decimal places.) Direct materials information Standard pounds per unit Standard price per pound Actual quantity purchased and used per unit Actual price paid for material per pound Direct materials price variance Direct materials quantity variance Total direct material variance Number of units produced $ $ $ $ Medium speed bump 10 1.00 1.80 1.280 U 400 F 200 S speed bump $ $ $ Large 1.50 12 2.30 2,880 U 2,430 U 300 Data table Direct materials information Standard pounds per unit. Standard price per pound.. Actual quantity purchased and used per unit Actual price paid for material per pound.. Direct materials price variance.. Direct materials quantity variance. Total direct material variance.. Number of units produced Print Medium speed Large speed bump…
Direct materials information Standard pounds per unit..... Standard price per pound... Actual quantity purchased and used per unit ...... Actual price paid for material per pound.. Direct materials price variance..... Direct materials quantity variance.... Total direct material variance.. Number of units produced Medium speed Large speed bump bump $ $ 15 1.00 $ ? 1.80 $ $1,120 U 100 F ? 100 ? 1.80 16 2.10 $1,920 U ? $480 U 400
Acme Inc. has the following information available: Actual price paid for material $1.000 Standard price for material $0.730 Actual quantity purchased and used in production 100 Standard quantity for units produced 80 Actual labor rate per hour $16 Standard labor rate per hour $14 Actual hours 200 Standard hours for units produced 230 Compute the material price and quantity, and the labor rate and efficiency variances. Round your answers to two decimal places. Enter all amounts as positive numbers. Material price variance Material quantity variance Labor rate variance $ Labor efficiency variance $ Favorable Unfavorable
Last month, Brentwood Corporation purchased and used the same quantity of material in producing its product, speed bumps for traffic control. (Click the icon to view the table.) Complete the following table. (Round your answers to two decimal places.) Direct materials information Standard pounds per unit Standard price per pound Actual quantity purchased and used per unit Actual price paid for material per pound Direct materials price variance Direct materials quantity variance Total direct material variance Number of units produced $ $ $ $ Medium speed bump $ 12 1.00 10 1.50 2,000 U 800 F 1,200 400 U $ $ $ Large speed bump $ C $ 1.60 14 2.30 4,900 U 2,400 F 2,500 U 500
Ziegler Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the total cost. The data for various levels of production are as follows: Units Produced Total Costs 97,500 $27,165,000 112,500 29,715,000 124,500 31,755,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Determine the variable cost per unit and the total fixed cost. Round your answer for variable cost to the nearest cent. Round your answer for total fixed costs to the nearest dollar. Variable cost: $fill in the blank 2 per unit Total fixed cost: $fill in the blank 3 Based on part (a), estimate the total cost for 80,000 units of production. Round your answer to the nearest dollar. Total cost for 80,000 units: $fill in the blank 4
Using the format dicaksed in Exthbit 21.10 and Exhibit 21.11 of your textbook or formulas solve for the following variance. You may use EXCEL WORD. Picture of Paper, or enter your work into Camvas. I will cover how to do this during the Zoom recorded lecture for that week or during a recording Standard Quantities and Costs: DM (.25 it per unit at $10 per foot)=$2.50 DL(5hour per unit at 520 per hour)=$10.00Total Dirsct Cost per unit=$12.50 Additional information: During the period, MK, Inc, badgeted to produce 2.000 widgets, it actually produced 1.900 widgets. K Actual Quantibes, and Costs: DM purchased & used = 505 feet at $9.80Dthours used +990 hours at $19.75 Required: Calculate the following variances using the matrix format mentioned above or formulas: -Price Variance - Quantity Variancer - Total DM Vanance - Rate Variarice - Eificiency Variance - Total DL Variance
HeadsetHeadset manufactures headphone cases. During September 20182018, the company produced and sold 108 comma 000108,000 cases and recorded the following cost data: LOADING... (Click the icon to view the cost data.) Read the requirements LOADING... . Requirement 1. Compute the cost and efficiency variances for direct materials and direct labor. Begin with the cost variances. Select the required formulas, compute the cost variances for direct materials and direct labor, and identify whether each variance is favorable (F) or unfavorable (U).(Abbreviations used: AC = actual cost; AQ = actual quantity; FOH = fixed overhead; SC = standard cost; SQ = standard quantity.) Formula Variance Direct materials cost variance = = Direct labor cost variance = = Next compute the efficiency variances. Select the required formulas, compute the efficiency variances for direct materials and…
Ziegler Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the total cost. The data for various levels of production are as follows: Units Produced Total Costs $28,166,000 104,000 114,000 29,781,000 128,000 32,042,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Determine the variable cost per unit and the total fixed cost. Round your answer for variable cost to the nearest cent. Round your answer for total fixed costs to the nearest dollar. Variable cost: per unit Total fixed cost: b. Based on part (a), estimate the total cost for 84,000 units of production. Round your answer to the nearest dollar. Total cost for 84,000 units: