Pizza Vesuvio makes specialty Month Labor Cost ($) January 9,790 February 7,300 7,831 March April May June July August 8,440 10,087 8,790 13,542 7,800 Cost, Calculate the Variable Rate, and Construct a Cost Function pizzas. Data for the past 8 months were collected: Employee Hours 530 620 660 490 570 450 740 410 Pizza Vesuvio's controller wants to calculate the fixed and variable costs associated with labor used in the restaurant. In your calculations, round the variable rate per employee hour to the nearest cent. If required, round your final answers to the nearest cent. Required: 1. Using the high-low method, calculate the variable rate. 6,200 X per employee hour 2. Using the high-low method, calculate the fixed cost of labor.

Pizza Vesuvio makes specialty Month Labor Cost ($) January 9,790 February 7,300 7,831 March April May June July August 8,440 10,087 8,790 13,542 7,800 Cost, Calculate the Variable Rate, and Construct a Cost Function pizzas. Data for the past 8 months were collected: Employee Hours 530 620 660 490 570 450 740 410 Pizza Vesuvio's controller wants to calculate the fixed and variable costs associated with labor used in the restaurant. In your calculations, round the variable rate per employee hour to the nearest cent. If required, round your final answers to the nearest cent. Required: 1. Using the high-low method, calculate the variable rate. 6,200 X per employee hour 2. Using the high-low method, calculate the fixed cost of labor.

Name: 4 -Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: 4 -Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and Construct a Cost FunctionPizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:Month Labor Cost ($)Employee HoursJanuaryFebruaryMarchAprilMayJuneJul

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 20BEA: Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and...

See similar textbooks

Similar questions

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 9,790 360 February 7,300 420 March 7,831 450 April 8,440 340 May 10,087 390 June 8,790 310 July 11,496 500 August 7,800 280 Pizza Vesuvio's controller wants to calculate the fixed and variable costs associated with labor used in the restaurant. In your calculations, round the variable rate per employee hour to the nearest cent. If required, round your final answers to the nearest cent. Required: 1. Using the high-low method, calculate the fixed cost of labor. 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 - |× Employee hours)
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 9,790 300 February 7,300 350 March 7,831 370 April 8,440 280 May 10,087 320 June 8,790 250 July 10,932 410 August 7,800 230 Pizza Vesuvio's controller wants to calculate the fixed and variable costs associated with labor used in the restaurant. In your calculations, round the variable rate per employee hour to the nearest cent. If required, round your final answers to the nearest cent. Required: 1. Using the high-low method, calculate the variable rate. $fill in the blank 1 per employee hour 2. Using the high-low method, calculate the fixed cost of labor. $fill in the blank 2 3. Using the high-low method, construct the cost formula for total labor cost. Total labor cost = $fill…
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
Given the following cost and activity observations for Bounty Company's utilities, use the high-low method to determine Bounty's variable utilities cost per machine hour. Round your answer to the nearest cent. Cost Machine Hours March $3,042 15,473 April 2,687 9,834 May 2,869 11,801 June 3,639 17,923 a.$0.55 b.$0.59 c.$1.29 d.$0.12
Tracey Packaged Snax reports the following information for November: Units produced and sold Per unit revenue and costs: Sales revenue Direct materials costs Direct labor costs Variable manufacturing overhead Fixed manufacturing overhead (at 320,000 units) Variable marketing and administrative costs Fixed marketing and administrative costs (at 320,000 units) Required: a. Prepare a gross margin income statement. b. Prepare a contribution margin income statement. Complete this question by entering your answers in the tabs below. Required A Required B Prepare a gross margin income statement. Sales revenue Gross margin Gross Margin Income Statement Fixed marketing and administrative costs Operating profit $ 1,152,000 (176,000) 320,000 $ 3.60 1.05 0.30 0.20 0.95 0.15 0.55
Tracey Packaged Snax reports the following information for November: Units produced and sold Per unit revenue and costs: Sales revenue Direct materials costs Direct labor costs Variable manufacturing overhead Fixed manufacturing overhead (at 320,000 units) Variable marketing and administrative costs Fixed marketing and administrative costs (at 320,000 units) Required: a. Prepare a gross margin income statement. b. Prepare a contribution margin income statement. Complete this question by entering your ansivers in the tabs below. Required A Required B Prepare a contribution margin income statement. Contribution Margin Income Statement 320,000 $9.60 1.65 0.90 0.80 1.55 0.75 1.15
Mudhaiby Co. gathered the following information on power costs and factory machine usage for the last Six months: Month Power Cost Factory Machine Hours | January R.O.24,400 13,900 February 29,200 17,600 March 29,000 16,800 April 22,340 13,200 May 19,900 11,600 June 14,900 6,600 Instructions Using the high-low method of analyzing costs, answer the following questions and show computations to support your answers. (a) What is the estimated variable portion of power costs per factory machine hour? (b) What is the estimated fixed power cost each month? (c) If it is estimated that 10,000 factory machine hours will be run in July, what is the expected total power cost for July?
Sunland Co. gathered the following information on power costs and factory machine usage for the last six months: Power Cost Factory Machine Hours $28,390 15,800 36,069 21,400 32,895 18,700 ITT 26,235 15,100 23,890 13,500 20,700 Month January February March April May June Using the high-low method of analyzing costs, answer the following questions and show computations to support your answers. (a) Your answer is correct. What is the estimated variable portion of power costs per factory machine hour? (Round answer to 2 decimal places, e.g. 15.25.) Variable power costs $ (b) eTextbook and Media * Your answer is incorrect. 10.500 Fixed power costs What is the estimated fixed power cost each month? High 1.41 per factory machine hour 20,683 $ Low Attempts: 1 of 5 used
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:
SmokeCity, Inc., manufactures barbeque smokers. Based on past experience, SmokeCity has found that its total annual overhead costs can be represented by the following formula: Overhead cost = 543,000 + 1.34X, where X equals number of smokers. Last year, SmokeCity produced 20,000 smokers. Actual overhead costs for the year were as expected. Required: 1. What is the driver for the overhead activity? 2. What is the total overhead cost incurred by SmokeCity last year? 3. What is the total fixed overhead cost incurred by SmokeCity last year? 4. What is the total variable overhead cost incurred by SmokeCity last year? 5. What is the overhead cost per unit produced? 6. What is the fixed overhead cost per unit? 7. What is the variable overhead cost per unit? 8. Recalculate Requirements 5, 6, and 7 for the following levels of production: (a) 19,500 units and (b) 21,600 units. (Round your answers to the nearest cent.) Explain this outcome.
Scattergraph, High-Low Method, and Predicting Cost for a Different Time Period from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. Required: 1. Prepare a scattergraph based on the 10 months of data. Does the relationship appear to be linear? 2. Using the high-low method, prepare a cost formula for the receiving activity. Using this formula, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? 3. Prepare a cost formula for the receiving activity for a quarter. Based on this formula, what is the predicted cost of receiving for a quarter in which 4,650 receiving orders are anticipated? Prepare a cost formula for the receiving activity for a year. Based on this formula, what is the predicted cost of receiving for a year in which 18,000 receiving orders are anticipated? Use the following information for Problems 3-60 and 3-61: Farnsworth Company has gathered data on its overhead activities and associated costs for the past 10 months. Tracy Heppler, a member of the controllers department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is receiving raw materials (unloading incoming goods, counting goods, and inspecting goods), which she believes is driven by the number of receiving orders. Ten months of data have been gathered for the receiving activity and are as follows:
Cushing, Inc., costs products using a normal costing system. The following data are available for last year: Overhead is applied on the basis of direct labor hours. What was last years per unit product cost? a. 1.39 b. 4.40 c. 4.43 d. 3.01