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 eight months were collected:
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 eight months were collected:
Month
Labor Cost
Employee Hours
January
$7,000
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,481
X Variable
8.32
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 cost = $ + ($ × Employee hours)
3. Calculate the budgeted cost for next month, assuming that 670 employee hours are budgeted. Round answer to the nearest dollar.
$
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code “Newclient”
The post 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 eight months were collected: appeared first on Superb Professors.