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

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 following data relate to the direct materials cost for the production of 1,800 automobile tires: Actual: 60,900 lb. at $1.70 Standard: 59,100 lb. at $1.75 a. Determine the direct materials price variance, direct materials quantity variance, and total direct materials cost variance. Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number. Price variance $fill in the blank 1 Quantity variance $fill in the blank 3 Total direct materials cost variance $fill in the blank 5
I. Krueger Corporation in Washington, D.C., U.S., recently implemented a standard cost system. The company's cost accountant has gathered the following information needed to perform a variance analysis at the end of the month: Standard Cost Information Direct materials.... Quantity allowed per unit . Direct labor rate..... Hours allowed per unit .. Fixed overhead budgeted . Normal level of production .. Variable overhead application rate . Fixed overhead application rate ($12,000 _ 1,200 units)... 10.00 per unit Total overhead application rate.. $5 per pound .100 pounds per unit $20.00 per hour 2 hours per unit $12,000 per month . 1,200 units $ 2.00 per unit $12.00 per unit Actual Cost Information Cost of materials purchased and used ... Pounds of materials purchased and used . Cost of direct labor .... $468,000 .104,000 pounds $46,480 2,240 hours Hours of direct labor.. arre$2,352 .$12,850 Cost of variable overhead . Cost of fixed overhead . Volume of production ..1,000 units…
Required:a) Prepare a flexed budget and calculate the total variances b) Using the data, analyse each of the cost variances: Materials; Labour;Variable Overheads and; Fixed Overheads c) Using data, calculate the Sales price variance and the Sales volume variance
please answer all with working please answer in text . answer all please please please 1. What is the materials price variance for March? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for none effect.) 2. What is the materials quantity variance for March? 3. If Preble had purchases 182,000kg of materials at $7.40 per kg and used 160,000kg in productions, what would be the materials price variance efficiency for March? 4. If Preble had purchases 182,000kg of materials at $7.40 per kg and used 160,000kg in productions, what would be the materials quantity variance efficiency for March? 5. What is the labour rate variance for March? 6. What is the labour efficiency for March?
Get the Answer for all Questions
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:
Please help me with the functions needed to populate the correct answers in the highlighted areas. Thank you! Accessibility tab summary: Financial information for Patterson Incorporated, is presented in cells A4 to G14 and rows 16 to 17. A statement of requirement is presented in rows 19 to 24. A table for Standard Cost Variance Analysis - Direct Materials for student presentation is presented in cells A26 to B29 and A31 to C32. A table for Standard Cost Variance Analysis - Variable Manufacturing Overhead for student presentation is presented in cells A43 to B45 and A47 to C48. A statement of requirement is presented in row 50. A table for student presentation is presented in cell A52 to E62. Standards for one of Patterson, Inc.'s products is shown below, along with actual cost data for the month: Direct materials: Standard 2.4 yards @ $2.75 per yard $6.60 Actual 3.0 yards @ $2.70 per yard $8.10 Direct…
Please help me with all answers thanku
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
Do not give image format
Provide Answer for A B and C.. please provide with Step
The following data relate to the direct materials cost for the production of automobile tires: Actual: 56,700 lbs. at $2.05 per lb.Standard: 55,600 lbs. at $2.10 per lb. a. Determine the direct materials price variance, direct materials quantity variance, and total direct materials cost variance. Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number. Line Item Description Amount Variance Direct Materials Price Variance $fill in the blank 1 Direct Materials Quantity Variance $fill in the blank 3 Total Direct Materials Cost Variance $fill in the blank 5