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,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.

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 18BEA: Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Refer...

See similar textbooks

Related questions

Q: The following information was taken from the annual manufacturing overhead cost budget of Wildhorse…

A: Maufacturing overhead is the amount of overhead incurred by the entity in the making of the goods.…

Q: The manufacturing costs of Ackerman Industries for the first three months of the year follow:…

A: The high-low method is a method to split the variable and fixed cost components of an entity's mixed…

Q: iv. Degree of operating leverage. Estimated percentage increase and decrease in net operating income…

A: iv. Degree of Operating Leverage = Contribution Margin / Operating Profit v. Estimated % Change in…

Q: Required: Assume that 665 employee hours are budgeted for the month of September. Use the total…

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

Q: The controller of Crane Production has collected the following monthly cost data for analyzing the…

A: The high-low method is used to differentiate the mixed cost. The mixed cost is the combination of…

Q: 2. Construct an Excel spreadsheet to solve the preceding requirement. Show how the solution will…

A: 2.Construct an Excel spreadsheet to solve the preceding requirement. Show how the solution will…

Q: The manufacturing overhead budget for Bramble Company contains the following items. Variable costs…

A: Total cost is the amount of cost incurred by the entity on the making and selling of the goods. It…

Q: The following data pertain to the Oneida restaurant Supply Company for the year just ended: Budget…

A: Manufacturing overhead means the cost incurred indirect in factory for the production of goods.…

Q: Wetherbee Tech Services (WTS) is a chain of computer maintenance technicians for households and…

A: Answer:- Formulas:- Price variance = (Standard rate - Actual rate) x Actual hoursEfficiency variance…

Q: not use ai please

A: Hello student! Direct Labor Budget shows the expected cost of work to be done on production during a…

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

A: The budget is prepared to estimate the requirements for the period. The direct labor budget is…

Q: The controller of Crane Production has collected the following monthly cost data for analyzing the…

A: Usually, businesses aim to comprehend the cost framework of the items they produce. As a result,…

Q: Standard labor hours per unit of 4.6 hours output Standard labor rate $20.40 per hours The following…

A: The direct labor cost refers to the cost incurred by a factory for the production of goods. The…

Q: Robin Company reported the following costs for the current month: Direct materials used $ 8,500…

A: TOTAL COSTTotal Cost is the cost which is incurred to manufacture a Product. Total Cost Includes…

Q: The output and production cost of a computer manufacturer for the last four months are as follows:…

A: Here in this question, we are required to calculate variable cost and fixed cost per unit for high…

Q: Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours.…

A: Lets understand the basics. Flexible budget is prepared to calcualte the cost, sales and profit at…

Q: Question: Asy Clean operates a chain of dry cleaners. It is experimenting with a…

A: Step 1: Find the operating expense factor for each required month.MonthOperating Expense…

Q: Howard Bannister Company budgets the following per-unit costs for the upcoming year. Direct Material…

A: ABSORPTION COSTINGAbsorption Costing is a Cost Management Accounting method in which all costs…

Q: Jay Corporation has decided to prepare contribution income statements for internal planning.…

A: Variable Cost :— It is the cost that changes with change in activity of cost driver. Variable cost…

Q: PROBLEM 5 Isko Corporation has the following budget estimate for the year 2020: Sales P2,800,000…

A: Hi student Since there are multiple questions, we will answer only first question. If you want…

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: Pittman Framing's cost formula for its supplies cost is $1,220 per month plus $11 per frame. For the…

A: Budgeted cost for 612 frames = (612 x $11) + $1,220 = $7,952 Actual cost for 612 frames = $7,650

Q: MCO Leather manufactures leather purses. Each purse requires 2 pounds of direct materials at a cost…

A: The question is based on the concept of Cost Accounting.Direct material budget is used to calculate…

Q: Peggy's Pillows produces and sells a decorative pillow for $75.00 per unit. In the first month of…

A: Absorption costing and variable costing are two costing systems being used in business. Under…

Q: Annie's Homemade Ice Cream is preparing a planning budget for August. Its budgeted revenue per…

A: Revenue and spending variances are the difference between actual and flexible budget results.…

Q: ackaging Solutions Corporation manufactures and sells a wide variety of packaging products.…

A: The variance is the difference between the actual and standard production data. The spending…

Q: Packaging Solutions Corporation manufactures and sells a wide variety of packaging products.…

A: Step 1:1.In this step the following workings and calculations are made in order to get the required…

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

100%

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.

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 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 High-Low to Calculate Predicted Total Variable Cost and Total Cost for a Time Period That Differs from the Data Period 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 4,000 employee hours are budgeted for the coming year. Use the total labor cost formula to make the following calculations: 1. Calculate total variable labor cost for the year. 2. Calculate total fixed labor cost for the year. 3. Calculate total labor cost for the coming year. 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 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 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,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.
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
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
Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Month Labor Cost Employee Hours January $7,000 360 February 8,140 550 March 9,899 630 April 9,787 600 May 8,490 480 June 7,450 350 July 9,490 570 August 7,531 310 Coefficients shown by a regression program for Pizza Vesuvio's data are: Intercept 4,497 X Variable 8.26 In your calculations, round the variable rate per employee hour to the nearest cent. Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of labor.$fill in the blank 1 Calculate the variable rate per employee hour.$fill in the blank 2per employee hour 2. Construct the cost formula for total labor cost.Total labor cost = $fill in the blank 3 + ($fill in the blank 4 × Employee hours) 3. Calculate the budgeted…
Aero Travel Trailer Manufacturing is working on budgeting utility cost. The controller has decided that utilities are a function of the hours worked during the month. The following information is available and representative of the company’s utility costs: - Hours worked Utility cost incurred Low point 1,300 $ 903 High point 1,680 1,074 If 1,425 hours are worked in a month, total utility cost (rounded to the nearest dollar) using the high-low method should be Group of answer choices $947. $959. $954. $976.
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
V/T Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and Construct a Cost Function Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Month Labor Cost Employee Hours January February March $7,000 8,140 9,899 9,787 8,490 7,450 tot Feedback 360 550 April May June July 9,490 August 7,531 310 Pizza Vesuvio's controller wants to calculate the fixed and variable costs associated with labor used in th restaurant. ►Check My Work 630 610 480 350 In your calculations, round the variable rate per employee hour to the nearest cent. Required: 1. Using the high-low method, calculate the fixed cost of labor. 570 2. Using the high-low method, calculate the variable rate. per employee hour 3. Using the high-low method, construct the cost formula for total labor cost. Total labor cost = $ + [$ x Employee hours] Dreviou Ma
QUESTION A company manufactures a food product data for which for one week has been analyzed as follows:Standard cost data: KDirect materials: 10 units at K1.50 15Direct wages: 5 hours at K4.00 20Production overhead: 5 hours at K5.00 2560Other overhead may be ignored.Profit margin is 20% of sales Price.Budgeted sales are K30,000 per week.Actual data:Sales K29,880Direct materials K6,435Direct wages K8,162Analysis of variances;Adverse FavourableDirect materials price 585Usage 375Direct labour: rate 318Efficiency 180Production overhead: expenditure 200Volume 375BBAC 212 ASSIGNMENT ONE SEMISTER 2 2021It can be assumed that the production and sales achieved resulted in no changes of stock.REQUIRED;From the data given, to calculate: (i) the actual output; (ii) the actual profit; (iii) the actualn price per unit of material (iv) actual labour rate per hour; (v) the amount of production overhead incurred; (vi) the amount of overhead absorbed; (vii) the amount of production efficiency variance;…
Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for esch deportment. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Cost Formulas Direct labor Indirect labor Utilitics Supplies Equipment depreciation Factory rent Ргopсrty tакеs Factory adninistration $15.88g $8, 280 + $1.68g $6,400 + $e.seg $1,180 + $e.48g $23,0ee + $3.78g $8,400 $2,100 $11,700 + $1.9eg The Production Department planned to work 8,000 lebor-hours in March; however, it octually worked 8,400 lobor-hours during the month. Its actual costs incurred in March are listed below: Actual Cost Incurred in March $134,738 $ 19,860 $ 14,578 $ 4,988 $ 54, 88e $ 8,700 $ 2,100 $ 26,470 Direct labor Indirect labor lities Supplies Equipment depreciation Factory rent Property taxes Factory administration Required: 1. Prepare the Production…