Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

12 Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Pizza Vesuvio makes speciality pizzas. Data for the past

image text in transcribed

12 Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Pizza Vesuvio makes speciality pizzas. Data for the past 8 months and the estimate for 3 September were collected. 345 6 Month DATA Labor Cost Employee Hours 8 76220 January $7,000 340 February 8,140 530 March 9.899 620 10 April 9,787 590 11 May 8,490 460 12 June 7.450 330 13 July 9,490 550 14 August 7,531 290 15 59 16 Estimated employee hours for September 665 17 Assume that this information was used to construct the following formula for monthly labor 18 cost. 19 20 Total Labor Cost 21 $5,450 + ( $7.18 x Employee Hours) + Using formulas and cell references, perform the required analysis, and input your answers into the green cells in the Amount column. Transfer the numeric results for the green entry 22 cells (D25:D26) into the appropriate fields in CNOWV2 for grading 23 24 Required: 25 1. Total variable labor cost for September 26 2 Total labor cost for September Amount Formulas

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

Intermediate Accounting

Authors: J. David Spiceland, James Sepe, Mark Nelson

6th edition

978-0077400163

Students also viewed these Accounting questions

Question

=+2. What is the standard deviation of the sample proportion?

Answered: 1 week ago

Question

Evaluate factors that influence employment opportunities.

Answered: 1 week ago