Using High-Low to Calculate and cont Calculate the Variable Roster, and Construct a cost functie Piazza Vesuvio makes speciaky puzzas. Data for the past 3 months were collected: Month Labor Cost($) Employee Hours Lanuary 9.490 February 7,000 March 7,531 April May 9,787 June 8.490 July 11,820 August 7,500 300 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. Tota labor cost = (5 Employee hours) Using High-Low to Calculate Predicted Total Variable cost and Total Cost for Budgeted Output 420 Pizza Vesuvio makes specialy pizzas. Data for the past 3 months were collected: Month Labor Cost Employee Hours January $6,900 February $9.799 March $8,040 April $9,687 May $8.390 $7,431 July $9,390 August $7.350 370 Assume that this information was used to construct the following formula for monthly labor cost. Total Labor Cost = $6577 - ($2.09 x Employee Hours) Required: June Assume that 685 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 lashearest 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 a Time Period that differs from the Data Period Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Month Labor Cost Employee Hours $6,900 380 February 9.799 March 8.040 April 9.687 May 8,390 June July 7,431 9,390 590 August 7.350 330 Assume that this information was used to construct the following formula for monthly labor cost Total Labor Cost - $6,637 + (52.16 X Employee Hours) Required: Assume that 3.900 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 coming year Round your answer to the nearest dollar 2. Calculate total fixed labor cost for the coming year. Round your answer to the heat doar 3. Calculate total labor cost for the coming year. Round your answer to the nearest della