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. Data for the past 8 months were collected: Employee Hours Month January February March April May June July August X Variable Labor Cost $7,000 8,140 9,899 9,787 8,490 7,450 9,490 7,531 Coefficients shown by a regression program for Pizza Vesuvio's data are: Intercept Check My Work 4,481 8.32 360 1. Calculate the fixed cost of labor. 550 630 590 480 350 570 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: 310 Calculate the variable rate per employee hour. per employee hour
 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 Caiculate Fixed Cost Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Pirza Vesuvio mahes specialty pirzas, Oata for the past 8 months were collected: Coefficients shown by a regression program for pizza Vesuvio's data are: Use the results of regression to make the folioning calculaticns: 1. Calculate the nxed cost of labor: Calculate the variable rate per employee Nout: per emplopee hour 2. Construct the cost formula for total labor cost. Tetal labor cost is +(4) * Emploree hour) 3. Calculate the budgeted cost for next month, assuming that 675 emplovee hours arn budgeted, Mound arswer to the nearest doits

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!