Direct materials variancesBellingham Company produces a product that requires 2.3 standard pounds per unit. The standard price is $3.20 per pound. 16,300units used 37,000 pounds, which were purchased at $3.30 per pound.This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and inputyour answers in the questions below.XOpen spreadsheetWhat 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 varianceb. Direct materials quantity variancec. Direct materials cost variance$UnfavorableFavorableUnfavorableFeedbackCheck My WorkUnfavorable variances can be thought of as increasing costs (a debit). Favorable variances can be thought of as decreasing costs (a credit).Cost variance is the difference between the actual and standard total cost.

Name: Direct materials variancesBellingham Company produces a product that
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: Direct materials variancesBellingham Company produces a product that requires 2.3 standard pounds per unit. The standard price is $3.20 per pound. 16,300units used 37,000 pounds, which were purchased at $3.30 per pound.This information has been coll

Lets understand the basics.Direct material price variance is a variance between the rate at which…

Business

Accounting

Direct materials variances Bellingham Company produces a product that requires 2.3 standard pounds per unit. The standard price is $3.20 p units used 37,000 pounds, which were purchased at $3.30 per pound. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required a your answers in the questions below. X Open spreadsheet

Direct materials variances Bellingham Company produces a product that requires 2.3 standard pounds per unit. The standard price is $3.20 p units used 37,000 pounds, which were purchased at $3.30 per pound. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required a your answers in the questions below. X Open spreadsheet

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter3: Cost Behavior And Cost Forecasting

Section: Chapter Questions

Problem 67P: Refer to the information for Farnsworth Company (p. 139) for the first 10 months of data on...

See similar textbooks

Similar questions

meducation.com/ext/map/index.html?_con=con&external_browser=0&launch Url=https%253A%252F %252Fne S... Use the following information for the Problems below. (Algo) [The following information applies to the questions displayed below.] Trini Company set the following standard costs per unit for its single product Direct materials (30 pounds @ $5.00 per pound) Direct labor (7 hours @ $14 per hour) Variable overhead (7 hours @ $7 per hour) Fixed overhead (7 hours @ $9 per hour) Standard cost per unit Production (in units) Standard direct labor hours (7 DLH per unit) Budgeted overhead (flexible budget) Fixed overhead Variable overhead Overhead is applied using direct labor hours. The standard overhead rate is based on a predicted activity level o the company's capacity of 51,000 units per quarter. The following additional information is available. $ 150.00 98.00 49.00 63.00 $360.00 70% 35,700 249,900 $ 2,570,400 $1,749,300 Direct materials (1,377,000 pounds @ $5.00 per pound) Direct labor…
Build a spreadsheet: Construct and excel spreadsheet to solve all of the preceding requirements. Show how both cost schedules and the income statement will change if raw material purchases amounted to $190,000 and indirect labor was $20,000.
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
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:
need answers for 1,2,3 and 4 4. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how both cost schedules and the income statement will change if the following data change: direct labor is $390,000 and utilities cost $35,000.
The cost of materials for product A are as follows. Material W: $2,250 Material X: $3,000 Material Y: $3,600 Material Z: $150 If the material proportions were displayed on a pie chart, how many degrees would material Y represent? A 90 degrees B 120 degrees C 144 degrees D 204 degrees
Convert the accompanying database to an Excel table to find: a.The total cost of all orders. b.Thetotal quantity of airframe fasteners purchased. c. The total cost of all orders placed with Manley Valve. Question content area bottom Part 1 a. The total cost of all orders is $?????? enter your response here.
This section has a nine-part comprehensive problem with multiple questions to address. Download the Chapter 9 Comprehensive Problem Template below to complete all parts. You will need your Bergevin and MacQueen book for reference. Redlands Inc. reported standard and actual costs for the product that it manufactures: Item Standard Actual Direct material price $3 per lb. $2 per lb. Direct materials quantity 2 lbs. 4 lbs. Direct labor price $5 $7 Direct labor quantity 3 hours 2 hours Factory overhead cost $2 per machine hour ---- Machine hours per unit 2 machine hours 3 machine hours Number of finished products made 10 12 Number of finished products sold 10 11 Sales per unit $40 $40 * Redlands used machine hours to apply factory overhead costs. The company incurred $90 actual total factory overhead costs to make the 12 products. 1. Standard product cost Item Price Quantity Total Direct materials Direct labor Factory overhead Standard…
4. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how both cost schedules and the income statement will change if the following data change: direct labor is $390,000 and utilities cost $35,000.
Refer to the information for Farnsworth Company (p. 139) for the first 10 months of data on receiving orders and receiving cost. Now suppose that Tracy has gathered 2 more months of data: Note: For the following requirements, round the intercept terms to the nearest dollar, round the variable rates to the nearest cent, and R2 to two decimal places. Required: 1. Run two regressions using a computer spreadsheet program such as Excel. First, use the method of least squares on the first 10 months of data. Then, use the method of least squares on all 12 months of data. Write down the results for the intercept, slope, and R2 for each regression. Compare the results. 2. CONCEPTUAL CONNECTION Prepare a scattergraph using all 12 months of data. Do any points appear to be outliers? Suppose Tracy has learned that the factory suffered severe storm damage during Month 11 that required extensive repairs to the receiving areaincluding major repairs on a forklift. These expenses, included in Month 11 receiving costs, are not expected to recur. What step might Tracy, using her judgment, take to amend the results from the method of least squares? 3. CONCEPTUAL CONNECTION Rerun the method of least squares, using all the data except for Month 11. (You should now have 11 months of data.) Prepare a cost formula for receiving based on these results, and calculate the predicted receiving cost for a month with 1,450 receiving orders. Discuss the results from this regression versus those from the regression for 12 months of data.
Healthfirst (HF) Ltd has recently started to produce a face shield and product's standard cost data are as follows: Cost per unit Direct materials Perspex (0.5 meters @ $15 per meter) $ 7.50 Direct materials Hardened Plastic (0.25 meters at $20.00 per meter) 5.00 Direct manufacturing labour (0.5 hr @ $30.00 per hr) Manufacturing overhead Total Cost 15.00 Required Should HF accept the offer. Show all computations. 30.00 $57.50 Additional information 45% of the Manufacturing overhead changes with the number of units produced. Additionally, if production of face shields is discontinued, 20% of the remaining fixed cost will be avoided. The budgeted production used to compute overheads is 10,000 units per quarter. HF has been approached by another company who is willing to supply the face shields at $50. Per unit. The space used to manufacture face shields can be used to Generate $ 120,000 in contribution margin per quarter.
Refer to the data given below.Required:1. Draw a scatter diagram and graph the company’s energy cost behavior using the visual-fit method.2. Predict the energy cost for a month in which 26,000 pints of applesauce are produced.3. What peculiarity is apparent from the scatter diagram? What should the cost analyst do?