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

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 X Variable 4,517 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 = $ + ($ x Employee hours) 3. Calculate the budgeted cost for next month, assuming that 675 employee hours are budgeted.

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

Managerial Accounting The Cornerstone Of Business Decision Making

Authors: Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

8th Edition

0357715349, 978-0357715345

More Books

Students also viewed these Accounting questions

Question

What are the key elements of a system investigation report?

Answered: 1 week ago