Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

Month Labor Cost Employee Hours
January $6,900 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,452
X Variable 8.31

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. $fill in the blank 1

Calculate the variable rate per employee hour. $fill in the blank 2per employee hour

2. Construct the cost formula for total labor cost. Total labor cost = $fill in the blank 3 + ($fill in the blank 4 Employee hours)

3. Calculate the budgeted cost for next month, assuming that 700 employee hours are budgeted. Round answer to the nearest dollar.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

CIA Part 1 Essentials Of Internal Auditing 2022

Authors: MUHAMMAD ZAIN

1st Edition

B09PHFC28N, 979-8794951356

More Books

Students also viewed these Accounting questions

Question

Evaluate employees readiness for training. page 275

Answered: 1 week ago