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,290 510
February 6,800 590
March 7,331 620
April 7,940 470
May 9,587 550
June 8,290 430
July 12,508 700
August 7,300 390
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,141
2. Using the high-low method, calculate the variable rate. $ 18.41 per employee hour
3. Using the high-low method, construct the cost formula for total labor cost. Total labor cost = $ 12,508 + ($ 18.41 × Employee hours)
1) Fixed cost = 12508-(700*16.80) = 748
2) Variable rate = Change in Cost/Change in Hour = (12508-7300)/(700-390) = 16.80 per employee hour
3) Formula :
Y = a+bx
Y = 748+16.80X
Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and Construct a Cost Function Pizza...
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,290 310 February 6,800 360 March 7,331 380 April 7,940 290 May 9,587 340 June 8,290 260 July 10,378 ...
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 510 February 7,000 590 March 7,531 620 April 8,140 470 May 9,787 550 June 8,490 430 July 12,708 700 August 7,500 390 Pizza Vesuvio's controller wants to calculate the fixed and variable costs associated with labor used in the restaurant. In your calculations, round the...
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 380 February 7,000 440 March 7,531 460 April 8,140 350 May 9,787 410 June 8,490 320 July 11,042 ...
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 January February March Labor Cost($) Employee Hours 9,490 7,000 7,531 8,140 9,787 8,490 April May June July 13,416 7,500 August 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...
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,590 430 February 7,100 500 March 7,631 530 April 8,240 400 May 9,887 460 June 8,590 360 July 11,864 590 August 7,600 330 Pizza Vesuvio's controller wants to calculate the fixed and variable costs associated with labor used in the restaurant. In your calculations, round the...
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 eight months were collected: Month Labor Cost($) Employee Hours January 5,896 260 February 8,623 390 March 9,286 420 April 6,854 310 May 7,960 360 June 6,412 290 July 7,750 440 August 7,517 340 Pizza Vesuvio's controller wants to calculate the fixed and variable costs associated with labor used in the restaurant In your calculations, round the...
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 9,390 January 400 February 6,900 470 March 7,431 500 8,040 April 370 May 9,687 430 June 8,390 340 July 11,850 560 August 7,400 310 Pizza Vesuvio's controller wants to calculate the fixed and variable costs associated with labor used in the restaurant. In your calculations, round the...
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,590 550 February 7,100 630 March 7,631 670 April 8,240 500 May 9,887 590 June 8,590 460 July 13,380 760 August 7,600 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...
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 570 February 7,000 660 March 7,531 700 April 8,140 May 9,787 620 480 June 8,490 July 13,520 790 August 7,500 440 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...
Calculator 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 370 February $9,699 560 March $7,940 640 April $9,587 620 May $8,290 490 June $7,331 360 July $9,290 580 August $7.250 320 Assume that this information was used to construct the following formula for monthly labor cost. Total Labor Cost - $6559 + ($2.16 x...