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 in the blank 3 + ($fill in the blank 4 × 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 in the blank 3 + ($fill in the blank 4 × Employee hours)
Trending now
This is a popular solution!
Learn your way
Includes step-by-step video
Step by step
Solved in 2 steps
