Question: Using High - Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted OutputPizza Vesuvio makes specialty pizzas. Data for the past 8

Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted OutputPizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:MonthLabor CostEmployee HoursJanuary$7,000340February8,140530March9,899640April9,787590May8,490460June7,450330July9,490550August7,531290Assume that this information was used to construct the following formula for monthly labor cost.Total Labor Cost = $5,569+($6.77\times Employee Hours)This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.Open spreadsheetRequired: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 to the nearest whole dollar.fill in the blank 1 of 1$4,9952. Calculate total labor cost for September. Round your answer to the nearest whole dollar.fill in the blank 1 of 1$10,232Feedback AreaFeedback1. Total Variable Labor Cost = Variable Rate \times Employee Hours2. Use the cost formula given.Total Labor Cost Employee Hours
 Using High-Low to Calculate Predicted Total Variable Cost and Total Cost

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!