Required:Assume that 665 employee hours are budgeted for the month of September. Use the total labor cost formula for the following calculations1. Calculate total variable labor cost for September. Round your answer to the nearest whole dollar.2. Calculate total labor cost for September. Round your answer to the nearest whole dollar. Uting High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted OutputPizza Vesuvio makes specialty pizzas. Data for the past 8 months were collectedMonthJanuaryFebruaryMarchAprilMayJuneJullyAugustLabor Cost Employee Hours$7,1008,2409.9996,5907,5509,5907,631360550660610480Assume that this information was used to construct the following formula for monthly labor cost.350570310Total Labor Cost-$5,534+ ($6.77 x Employee Hours)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

The total costs incurred for production are classified as fixed and variable costs. The high-low…

Required: Assume that 665 employee hours are budgeted for the month of September. Use the total labor cost formula for the following calculations: 1. Calculate total variable labor cost for September: Round your answer to the nearest whole dollar. 2. Calculate total labor cost for September. Round your answer to the nearest whole dollar

Required: Assume that 665 employee hours are budgeted for the month of September. Use the total labor cost formula for the following calculations: 1. Calculate total variable labor cost for September: Round your answer to the nearest whole dollar. 2. Calculate total labor cost for September. Round your answer to the nearest whole dollar

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 19BEA: Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for a Time Period That...

See similar textbooks

Related questions

Q: Assume the following for Round Top Inc. for the current fiscal year. Round Top applies overhead on…

A: PREDETERMINED OVERHEAD RATE Predetermined rate means an indirect cost rate. predetermined overhead…

Q: The production manager of Rordan Corporation prepared the following quarterly production forecast…

A: Direct labor cost is the amount paid to the labor to convert the raw material into final…

Q: The production manager of Rordan Corporation has submitted the following quarterly production…

A: Direct labor budget :— This budget is prepared to estimate the cost of direct labor incurred for…

Q: Johnston Company cleans and applies powder coat paint to metal items on a job-order basis. Johnston…

A: GIVEN Johnston Company deans and applies powder coat paint to metal items on a job-order basis.

Q: True or False. If the budgeted factory overhead cost is $460,000, the budgeted direct labor hours is…

A: Factory overhead rate per hour = Budgeted factory overhead cost/Budgeted direct labor hour

Q: The cheque-clearing office of Pay Loans Company is responsible for processing all cheques that come…

A: The objective of the question is to prepare an overhead performance report for October for the…

Q: Elite Stationary Inc. employs 20 full-time employees and 10 trainees. Direct and indirect costs are…

A: calculation of budgeted direct-cost rate and the budgeted indirect-cost rate Total Salary for…

Q: The production manager of Rordan Corporation has submitted the following quarterly production…

A: The company's direct labor budget shows the details of the total direct labor hours required to…

Q: Schneider inc. had the following information relating to year 1: Budgeted manufacturing overhead…

A: Overheads are considered as fixed and common expenses that should be allocated to the products on…

Q: If factory overhead is to be applied based on direct labor hours, the predetermined overhead rate is…

A: Predetermined overhead rate Predetermined overhead rate is an allocation rate that applies a certain…

Q: A company has the following information for the month of October. The company applies overhead (OH)…

A: Variable Overhead (V-OH) Efficiency Variance is computed using the following formula: -

Q: It applies overhead based on direct labor hours.…

A: Variable overhead is those manufacturing costs that vary roughly in relation to changes in…

Q: Kerekes Manufacturing Corporation has prepared the following overhead budget for next month.…

A: Variable cost is the cost that changes with change in the activity of the cost driver used. The…

Q: Accounting for manufacturing overhead This problem continues the Piedmont Computer Company situation…

A: 1. Predetermined overhead allocation rate for 2020 = Total estimated manufacturing overhead costs /…

Q: Use the budget data shown below for Sharp Company to answer the question that follow: Estimated…

A: Overhead applied = Overhead rate based on direct labor hour * Actual labor hour

Q: Joseph is working on the budget for his summer window-washing business, trying to figure out what…

A: Given dataMonthNumber of Labor Hour SpentTotal Cost160$1962105$322385$250Using a high-low method…

Concept explainers

Master Budget

A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.

Sales Budget and Selling

A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.

Question

Required:
Assume that 665 employee hours are budgeted for the month of September. Use the total labor cost formula for the following calculations
1. Calculate total variable labor cost for September. Round your answer to the nearest whole dollar.
2. Calculate total labor cost for September. Round your answer to the nearest whole dollar.

Uting High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output
Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected
Month
January
February
March
April
May
June
Jully
August
Labor Cost Employee Hours
$7,100
8,240
9.999
6,590
7,550
9,590
7,631
360
550
660
610
480
Assume that this information was used to construct the following formula for monthly labor cost.
350
570
310
Total Labor Cost-$5,534+ ($6.77 x Employee Hours)
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

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduction

VIEW

Step 2: Solution

VIEW

Solution

VIEW

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Refer to the information for Pizza Vesuvio on the previous page. Coefficients shown by a regression program for Pizza Vesuvios data are: Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of labor and the variable rate per employee hour. 2. Construct the cost formula for total labor cost. 3. Calculate the budgeted cost for next month, assuming that 675 employee hours are budgeted. (Note: Round answers to the nearest dollar.) Use the following information for Brief Exercises 3-17 through 3-20: Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:
Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Refer to the information for Pizza Vesuvio on the previous page. Assume that this information was used to construct the following formula for monthly labor cost. TotalLaborCost=5,237+(7.40EmployeeHours) Required: Assume that 675 employee hours are budgeted for the month of September. Use the total labor cost formula for the following calculations: 1. Calculate total variable labor cost for September. 2. Calculate total labor cost for September.
Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Pizza Vesuvio makes specialty pizzas. Data for the past eight months were collected: Month Labour Cost ($) Employee Hours January $7,300 February $8,440 March $10,199 April $10,087 May $8,790 June $7,750 July $9,790 August $7,831 Assume that this information was used to construct the following formula for monthly labour cost. Total Labour Cost = $4,319 + ($8.28 x Employee Hours) 410 600 710 660 530 400 620 360 Required: Assume that 695 employee hours are budgeted for the month of September. Use the total labour cost formula for the following calculations: 1. Calculate total variable labour cost for September. Round your answer to nearest dollar. 2. Calculate total labour cost for September. Round your answer to nearest dollar.
Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Month Labor Cost Employee Hours January $6,800 390 February $9,699 580 March $7,940 670 April $9,587 640 May $8,290 510 June $7,331 380 July $9,290 600 August $7,250 340 Assume that this information was used to construct the following formula for monthly labor cost. Total Labor Cost = $6539 + ($2.09 x Employee Hours) Required: Assume that 705 employee hours are budgeted for the month of September. Use the total labor cost formula for the following calculations: 1. Calculate total variable labor cost for September. Round your answer to nearest whole number. 2. Calculate total labor cost for September. Round your answer to nearest whole number.
Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Month Labor Cost Employee Hours January $6,900 340 February $9,799 530 March $8,040 650 April $9,687 590 May $8,390 460 June $7,431 330 July $9,390 550 August $7,350 290 Assume that this information was used to construct the following formula for monthly labor cost. Total Labor Cost - $6793 + ($1.92 x Employee Hours) Required: Assume that 695 employee hours are budgeted for the month of September. Use the total labor cost formula for the following calculations: 1. Calculate total variable labor cost for September. Round your answer to nearest whole number.
Using High - Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Month Labor Cost Employee Hours January $7,000 430 February $9,899 620 March $ 8,140 730 April $9, 787 680 May $8,490 550 June $7,531 420 July $9, 490 640 August $ 7,450 380 Assume that this information was used to construct the following formula for monthly labor cost. Total Labor Cost = $6701 + ($1.97 x Employee Hours) Required: Assume that 655 employee hours are budgeted for the month of September. Use the total labor cost formula for the following calculations: 1. Calculate total variable labor cost for September. Round your answer to nearest whole number. $fill in the blank 1 2. Calculate total labor cost for September. Round your answer to nearest whole number. $fill in the blank 2
Please help me
Required Informati (The following information applies to the questions displayed below.] Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: pexTA Elenent Variable Element per Cuntomer Served $ 5,800 $1,200 $ 570 Actual Total for May $184,000 $ 105,300 $ 16,500 * 41,600 per Month Revenue Enployee salaries and wagen Travel expennes other expenees $65,000 44,000 When preparing its planning budget the company estimated that it would serve 30 customers per month; however, du May the company octually served 35 customers. 5. What net operating income would appear in Adger's flexible budget for May? Net operating income
Classify each of the costs in table A into variable and fixed cost?
Use the Information below to answer the two questions that follow. A company provides delivery services and uses two activity measures for its costs: the miles driven and the number of customer order. For the most recent month, the company reported the following information: Actual $ 12,940 $ 22 per mile $ 13 per order Budgeted Fixed cost per month Varlable cost per mile Varlable cost per order $ 26 $ 12 Miles driven Customer orders Budgeted 74 480 Actual 64miles 460 orders Spending Varlance for total costs $203 Unfavorable Q. What was the company's budgeted fixed cost per month? ANS. S Q. What was the company's activity variance for the month? ANS. $ (Click to select) v
1. The amount of fixed factory costs applied to product during the first 6 months under absorption costing is? 2. Reported net income (or loss) for the first 6 months under absorption costing is? 3. Reported net income (or loss) for the first 6 months under variable costing is?
Required information [The following information applies to the questions displayed below.) Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Fixed Element Variable Element Actual per Customer Total per Month for May $ 182,000 $ 110,300 $ 27,200 $ 32,600 Served $ 5,600 $ 1,600 Revenue $ 55,000 Employee salaries and wages Travel expenses Other expenses 850 $ 34,000 When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers. 2. What amount of employee salaries and wages would be included in Adger's flexible budget for May? Amount of employee salaries and wages included in the flexible budget