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

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

Name: Bellingham Company produces a product that requires 3 standard direct
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: Bellingham Company produces a product that requires 3 standard direct labor hours per unitat a standard hourly rate of $20.00 per hour. 15, 800 units used 63,000 hours at an hourly rateof $19.65 per hour. This information has been collected in the M

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

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 $ $ $
Ramona Company has the following labor-related data: Standard labor hours for output: 15,000 hours Standard labor rate: $10 per hour Actual labor rate: $8 per hour Actual labor hours: 17,500 hours Given this data, which one of the following would be included in the single journal entry needed to record Wages Payable and the labor variances? a. credit Labor Efficiency Variance for $25,000 b. debit Labor Rate Variance for $35,000 c. credit Wages Payable for $175,000 d. debit Work-In-Process Inventory for $140,000 e. credit Labor Rate Variance for $10,000 f. credit Labor Rate Variance for $35,000 g. credit Labor Efficiency Variance for $10,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.
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.
ThingOne Company has the following information available for the past year. They use machine hours to allocate overhead. What is the variable overhead efficiency variance?
For a simple regression analysis model that is used to allocate factory overhead, an internal auditor finds that the intersection of the line of best fit for the overhead allocation with the y-axis is $14,000. The slope of the line is 0.2. The independent variable, factory wages, amounts to $810,000 for the month. What is the estimated amount of factory overhead to be allocated for the month? Multiple Choice $289,400. $162.000. $68,000. $88,000.
Using simple regression to estimate factory overhead, an internal auditor finds that the line of best fit intersects at the y-axis at $5,000 for overhead allocation. The slope of the line is 0.30. The dependent variable, represented by factory wages, amounts to $900,000 for the month. What is the estimated amount of factory overhead to be allocated for the month? Multiple Choice $180,000 $5,000 $905,000 $275,000 some other answer
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.
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
Thorne Company has the following information available for the past year. They use machine hours to allocate overhead. NOTE: All dollar amounts are rounded to whole dollars and shown with "$" and commas as needed (i.e. $12,345). For the variance conditions, your answer is either "F” (for Favorable) or "U” (for Unfavorable) - capital letter and no quotes. What is the variable overhead efficiency variance? Is it favorable or unfavorable?
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