Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and...

70.2K

Verified Solution

Question

Accounting

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,000 360
February 8,140 550
March 9,899 630
April 9,787 610
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,517
X Variable 8.20

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 cost = $ + ($ Employee hours)

3. Calculate the budgeted cost for next month, assuming that 675 employee hours are budgeted. $

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students