Question
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
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
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started