Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for a Time Period that Differs from the Data Period Pizza Vesuvio makes specialty

image text in transcribedimage text in transcribed

image text in transcribed

image text in transcribed

Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for a Time Period that Differs from the Data Period Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Month Labor Cost Employee Hours January $6,800 420 February 7,940 610 March 9,699 730 April 9,587 670 May B,290 540 June 7,250 410 July 9,290 630 August 7,331 370 Assume that this information was used to construct the following formula for monthly labor cost. Total Labor Cost = $4,897 + ($6,58 x Employee Hours) This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Assume that 4,200 employee hours are budgeted for the coming year. Use the total labor cost formula to make the following calculations: 1. Calculate total variable labor cost for the coming year. Round your answer to the nearest dollar 2. Calculate total fixed labor cost for the coming year. Round your answer to the nearest dollar. 3. Calculate total labor cost for the coming year. Round your 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_2

Step: 3

blur-text-image_3

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

Elementary Statistics

Authors: Mario F. Triola

3rd Canadian Edition

032122597X, 978-0321225979

More Books

Students also viewed these Accounting questions

Question

What are the principal alloying elements in SAE 4340 steel?

Answered: 1 week ago