Question: 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

 Using Regression to Calculate Fixed Cost Calculate the Variable Rate, Construct
a Cost Formula, and Determine Budgeted Cost Pizza Vesuvio makes specialty pizzas.

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,100 360 February 8,140 550 March 9,899 630 April 9,787 590 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,547 X Variable 8.21 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. Calculate the variable rate per employee hour. Pre 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,547 X Variable 8.21 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. Calculate the variable rate per employee hour. per employee hour 2. Construct the cost formula for total labor cost. Total labor costs + S X Employee hours) 3. Calculate the budgeted cost for next month, assuming that 695 employee hours are budgeted. Round answer to the nearest dollar $

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!