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 April May June July August 9,790 7,300 7,831 8,440 10,087 8,790 12,480 7,800 480 560 590 440 520 410 670 370 Show Me How 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. per employee hour 2. Using the high-low method, calculate the fixed cost of labor. 3. Using the high-low method, construct the cost formula for total labor cost. Total labor cost= x 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 February March April May June July August 9,790 7,300 7,831 8,440 10,087 8,790 12,480 7,800 480 560 590 440 520 410 670 370 Show Me How 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. per employee hour 2. Using the high-low method, calculate the fixed cost of labor. 3. Using the high-low method, construct the cost formula for total labor cost. Total labor cost= x Employee hours) +($

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

Similar questions

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:
A company sells mulch by the cubic yard. Grade A much sells for $150 per cubic yard and has variable costs of $65 per cubic yard. The company has fixed expenses of $15,000 per month. In August, the company sold 240 cubic yards of Grade A mulch. A. Calculate the contribution margin per unit for Grade A mulch. B. Calculate the contribution margin ratio of the Grade A mulch. C. Prepare a contribution margin income statement for the month of August.
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.
Grand Canyon Manufacturing Inc. produces and sells a product with a price of 100 per unit. The following cost data have been prepared for its estimated upper and lower limits of activity: Overhead: Selling and administrative expenses: Required: 1. Classify each cost element as either variable, fixed, or semi-variable. (Hint: Recall that variable expenses must go up in direct proportion to changes in the volume of activity.) 2. Calculate the break-even point in units and dollars. (Hint: First use the high-low method illustrated in Chapter 4 to separate costs into their fixed and variable components.) 3. Prepare a break-even chart. 4. Prepare a contribution income statement, similar in format to the statement appearing on page 540, assuming sales of 5,000 units. 5. Recompute the break-even point in units, assuming that variable costs increase by 20% and fixed costs are reduced by 50,000.
High-Low Method Refer to the information for Luisa Crimini above. Required: 1. Which month represents the high point? The low point? 2. Using the high-low method, compute the variable rate for tanning. Compute the fixed cost per month. 3. Using your answers to Requirement 2, write the cost formula for tanning services. 4. Calculate the total predicted cost of tanning services for September for 2,500 appointments using the formula found in Requirement 3. Of that total cost, how much is the total fixed cost for September? How much is the total predicted variable cost for September? 5. CONCEPTUAL CONNECTION Identify and briefly explain any additional issues that Luisa might be wise to consider when using the high-low method to estimate the costs of her tanning salon.
Method of Least Squares, Predicting Cost for Different Time Periods from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. However, assume that Tracy has used the method of least squares on the receiving data and has gotten the following results: Required: 1. Using the results from the method of least squares, prepare a cost formula for the receiving activity. 2. Using the formula from Requirement 1, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? (Note: Round your answer to the nearest dollar.) 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?
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…
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,490 550 February 7,000 630 March 7,531 670 April 8,140 500 May 9,787 590 June 8,490 460 July 12,872 760 August 7,500 420 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.$_________ 3. Using the high-low method, construct the cost formula for total labor cost. Total labor cost = $ _______ + ($__________ × Employee hours)
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,016 15,480 April 2,659 10,374 May 2,878 11,831 June 3,587 17,811 a.$0.62 b.$0.12 c.$1.25 d.$0.58
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…
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 to the nearest cent. Cost Machine Hours March $3,139 14,709 April 2,650 9,989 May 2,817 12,342 June 3,656 17,720 a. $0.74 b. $0.13 c. $1.43 d. $0.78
Cost BehaviorSmokeCity, Inc., manufactures barbeque smokers. Based on past experience, SmokeCity has found that its total annual overhead costs can be represented by the following formula: Over-head cost = $543,000 + $1.34X, where X equals number of smokers. Last year, SmokeCity pro-duced 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 unitsand (b) 21,600 units. (Round your answers to the nearest cent.) Explain this outcome.