Direct materials variancesBellingham Company produces a product that requires 2.3 standard pounds per unit. The standard price is$3.25 per pound. 16,400 units used 36,700 pounds, which were purchased at $3.40 per pound.This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform therequired analysis, and input your answers in the questions below.XOpen spreadsheetWhat is the direct materials (a) price variance, (b) quantity variance, and (c) cost variance? Round youranswers to the nearest dollar. Enter a favorable variance as a negative number using a minus sign and anunfavorable variance as a positive number.a. Direct materials price varianceb. Direct materials quantity variancec. Direct materials cost varianceLALALAUnfavorableFavorableUnfavorable

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.25 per pound. 16,400 units used 36,700 pounds, which were purchased at $3.40 per pound.This information has been coll

The variance is the difference between the standard and actual cost production data. The variance…

Business

Accounting

Direct materials variances Bellingham Company produces a product that requires 2.3 standard pounds per unit. The standard price is $3.25 per pound. 16,400 units used 36,700 pounds, which were purchased at $3.40 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 LA LA Unfavorable Favorable Unfavorable

Direct materials variances Bellingham Company produces a product that requires 2.3 standard pounds per unit. The standard price is $3.25 per pound. 16,400 units used 36,700 pounds, which were purchased at $3.40 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 LA LA Unfavorable Favorable Unfavorable

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter28: Statistics And Linear Regression (stats)

Section: Chapter Questions

Problem 2R

See similar textbooks

Similar questions

ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A% merica AS... rk i Required information 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) $ 150.00 98.00 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 of 80% of the company's capacity of 51,000 units per quarter. The following additional information is available. 49.00 63.00 $360.00 70% 35,700 249,900 Direct materials (1,377,000 pounds @ $5.00 per pound)…
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
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.
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.
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:
Required information [The following information applies to the questions displayed below.] Felix & Company reports the following information. Period Units Produced Total Costs $ 4,580 2 480 3,880 4,280 4,880 3,980 4,180 3 880 1,280 1,680 2,080 2,480 2,880 3,280 3,680 4 8,680 16,080 4,880 8 9 10 11,020 Use spreadsheet software to use ordinary least-squares regression to estimate the cost equation, including fixed and variable cost amounts. Cost equation = per unit
Part 1: Based on the data presented in the Unit VIII Spreadsheet Template in Excel (CM Breakeven tab):• Calculate the contribution margin (CM) for each of the three products sold at the cookie business.• Calculate the weighted average CM.• Calculate the breakeven point.Complete your calculations by filling in the highlighted cells, and embed a copy of the completed spreadsheet into this report. Discuss the results based on your calculations as far as which type of cookie you think is the most profitable, which has the highest CM, etc.
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.
Cost Flow Relationships The following information is available for the first year of operations of Idgie Inc., a manufacturer of fabricating equipment: $1,150,100 310,500 103,500 42,600 19,600 586,600 Total manufacturing costs for the period 1,269,700 Materials inventory, end of period 42,600 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. Sales Gross profit Indirect labor Indirect materials Other factory overhead Materials purchased X Open spreadsheet Using the above information, determine the following amounts: a. Cost of goods sold 839,600 501,400 264,400 X b. Direct materials cost c. Direct labor cost $
Applying Excel - Data Visualization: Exercise (Part 2 of 2) On the Data Visualization - Student tab in your Excel spreadsheet, update the price per unit for all four products for Office Warehouse Inc. with the data below: Products Available Paper Pens Sticky Notes Envelopes Required: Create a Pivot Table and determine the following information while analyzing the data: 2. Which product has the highest total units ordered and the highest total sales? (Enter your Units Ordered to the nearest whole unit and your Total Sales to 2 decimal places.) Units Ordered Total Sales Price per Unit $20.00 per case: $ 9.00 per box $9.00 per package $ 4.50 per box Product Total