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

image text in transcribed

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 600 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 X Variable 4,431 8.37 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 650 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 with AI-Powered 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

Fundamentals of Financial Management

Authors: Eugene F. Brigham, Joel F. Houston

Concise 6th Edition

324664559, 978-0324664553

Students also viewed these Finance questions

Question

34. Provide an example of value stream mapping.

Answered: 1 week ago

Question

37. What are the 5Ss of housekeeping? What is the sixth?

Answered: 1 week ago