Direct labor variances Bellingham Company produces a product that requires 3 standard direct labor hours per unit at a standard hourly rate of $22.00 per hour. 15,200 units used 65,200 hours at an hourly rate of $19.50 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. X 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 b. Direct labor time variance c. Direct labor cost variance

Direct labor variances Bellingham Company produces a product that requires 3 standard direct labor hours per unit at a standard hourly rate of $22.00 per hour. 15,200 units used 65,200 hours at an hourly rate of $19.50 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. X 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 b. Direct labor time variance c. Direct labor cost variance

Name: Direct labor variancesBellingham Company produces a product that requ
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: Direct labor variancesBellingham Company produces a product that requires 3 standard direct labor hours per unit at a standard hourly rate of $22.00 per hour. 15,200 unitsused 65,200 hours at an hourly rate of $19.50 per hour.This information has be

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter4: Accounting For Factory Overhead

Section: Chapter Questions

Problem 4P: Using the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2....

See similar textbooks

Similar questions

Using the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2. Determine the cost to be charged to the product for the year. 3. Determine the cost to be charged to factory overhead for the year. 4. Determine the plotted data points using Chart Wizard. 5. Determine R2. 6. How do these solutions compare to the solutions in P4-2 and P4-3? 7. What does R2 tell you about this cost model?
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 managerial accountant at Sunny Manufacturing needs to determine how many costs are fixed costs and how many costs are variable costs in the organization. The managerial accountant reported the following information: Use the high-low method to determine the cost equation and use machine hours as the base for a cost driver in the analysis. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). Month Machine-Hours Total Cost January 1,800 $21,500 February 2,900 $23,200 March 1,000 $19,750 April 2,400 $21,000 May 3,400 $23,900
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 $
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)…
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…
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 managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through c. Click the icon to view the monthly data. a. Develop a simple linear regression model between billable hours and overhead costs. Overhead Costs = +xBillable Hours X Monthly Overhead Costs and Billable Hours Data (Round the constant to one decimal place as needed. Round the coefficient to four decimal places as needed. Do not include the $ symbol in your answers.) Overhead Costs Billable Hours 0 $315,000 3,000 $365,000 4,000 $395,000 5,000 $447,000 6,000 $530,000 7,000 $550,000 8,000
The managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through c. Click the icon to view the monthly data. a. Develop a simple linear regression model between billable hours and overhead costs. Overhead Costs +(9) x Billable Hours (Round the constant to one decimal place as needed. Round the coefficient to four decimal places as needed. Do not include the $ symbol in your answers.) X Monthly Overhead Costs and Billable Hours Data Overhead Costs Billable Hours $315,000 3,000 $360,000 4,000 $385,000 5,000 $438,000 6,000 $520,000 7,000 $540,000 8,000 D Print Done
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
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…
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