Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Pizza Vesuvio...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Labor Cost Employee Hours: $7,200 8,340 10,099 9,987 Month January February March April May June 380 570 X Open spreadsheet 650 630 500 370 8,690 7,650 July 9,690 August 7,731 Assume that this information was used to construct the following formula for monthly labor cost. 590 330 Total Labor Cost = $5,289 + ($7.40 x Employee Hours) This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and im Required: Assume that 645 employee hours are budgeted for the month of September. Use the total labor cost formula for the following calcul 1. Calculate total variable labor cost for September. Round your answer to the nearest whole dollar. 2. Calculate total labor cost for September. Round your answer to the nearest whole dollar. 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. 12 2 5 DATA 6 Month 7 8 9 March 10 April 11 May 12 June January February Labor Cost 13 July 14 August 15 16 Estimated employee hours for September 17 18 19 20 Total Labor Cost = 21 22 REQUIRED: 23 $7,200 8,340 10,099 9,987 8,690 7,650 9,690 7,731 34 Assume that this information was used to construct the following formula for monthly labor cost. $5,289 Employee Hours 380 570 650 630 500 370 590 330 Calculate total variable labor cost for September. 24 25 26 Total variable labor cost for September 27 28 REQUIRED: 29 Calculate total labor cost for September. 30 31 Total labor cost for September 32 33 645 Using formulas and cell references from the problem data, perform the required analysis. Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWV2 for grading. $7.40 x Employee Hours) Formulas Formulas Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Labor Cost Employee Hours: $7,200 8,340 10,099 9,987 Month January February March April May June 380 570 X Open spreadsheet 650 630 500 370 8,690 7,650 July 9,690 August 7,731 Assume that this information was used to construct the following formula for monthly labor cost. 590 330 Total Labor Cost = $5,289 + ($7.40 x Employee Hours) This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and im Required: Assume that 645 employee hours are budgeted for the month of September. Use the total labor cost formula for the following calcul 1. Calculate total variable labor cost for September. Round your answer to the nearest whole dollar. 2. Calculate total labor cost for September. Round your answer to the nearest whole dollar. 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. 12 2 5 DATA 6 Month 7 8 9 March 10 April 11 May 12 June January February Labor Cost 13 July 14 August 15 16 Estimated employee hours for September 17 18 19 20 Total Labor Cost = 21 22 REQUIRED: 23 $7,200 8,340 10,099 9,987 8,690 7,650 9,690 7,731 34 Assume that this information was used to construct the following formula for monthly labor cost. $5,289 Employee Hours 380 570 650 630 500 370 590 330 Calculate total variable labor cost for September. 24 25 26 Total variable labor cost for September 27 28 REQUIRED: 29 Calculate total labor cost for September. 30 31 Total labor cost for September 32 33 645 Using formulas and cell references from the problem data, perform the required analysis. Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWV2 for grading. $7.40 x Employee Hours) Formulas Formulas
Expert Answer:
Answer rating: 100% (QA)
From the images provided we have a formula to calculate the total labor cost which is given as Total ... View the full answer
Related Book For
Managerial Accounting The Cornerstone Of Business Decision Making
ISBN: 9780357715345
8th Edition
Authors: Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Posted Date:
Students also viewed these accounting questions
-
A manager has a list of items that have been sorted according to an item ID. Some of them are duplicates. She wants to add a code to the database that assigns a 1 to the item if it is unique, and if...
-
Pizza Vesuvio makes specialty pizzas. Data for the 8 months were collected. Coefficients shown by a regression program for Pizza Vesuvios data are: Intercept 4,517 X Variable 8.20 Required : Use the...
-
The controller for Beckham Company believes that the number of direct labor hours is associated with overhead cost. He collected the following data on the number of direct labor hours and associated...
-
In this assignment, you will take on the role of the Warden of a maximum custody state correctional facility. Your unit's use of force incidents has dramatically increased over the last year to...
-
Distinguish between the non-controlling, or minority, interest in net income and the non- controlling, or minority, interest in net assets of a consolidated subsidiary
-
Alcorn Service Company was formed on January 1, Year 1. Events Affecting the Year 1 Accounting Period 1. Acquired $20,000 cash from the issue of common stock. 2. Purchased $800 of supplies on...
-
What is a Problem Space?
-
The ledger of Wainwright Company at the end of the current year shows Accounts Receivable $78,000; Credit Sales $810,000; and Sales Returns and Allowances $40,000. Instructions (a) If Wainwright uses...
-
An ornithologist clocks an eagle diving at some prey at 82 m/s. He knows that this particular type of eagle typically dives from a height of 57 m and can accelerate 31 m/s. How fast might the eagle...
-
Code Churn is a common metric used to measure the efficiency and productivity of software engineers and computer programmers. It?s usually measured as the percentage of a programmer?s code that must...
-
Suppose that an urn contains two different types of coupons: three coupons of type A and four coupons of type B. After Alice draws a coupon out of the urn, the urn is reset to its original state of...
-
A capacitor with capacitance C has been connected to a resistor R and an ideal battery with voltage V as shown in the figure. The capacitor is fully charged so no current flows before the switch is...
-
3. Write the equations for the sum of the forces acting in the x and y directions for the junction of the cords in the diagram below. T2 60 3 kg T1 Bonus: Find the values of T and T.
-
Consider the energy levels for a hydrogen atom, listed in the table below. Each energy represents what is required for the negatively charged electron to escape. For example, if the electron were in...
-
The figure shows a mass spectrometer where a negatively charged ion (q = -2e, m = 4.25x10-26 kg) moves between the plates of the velocity selector and then enters the deflection chamber. The electric...
-
A counterweight of mass m = 4.80 kg is attached to a light cord that is wound around a pulley as shown in the figure below. The pulley is a thin hoop of radius R = 6.00 cm and mass M = 2.50 kg. The...
-
In 2007, Amazon decided to make a foray into the grocery market by launching Amazon Fresh. This service allowed customers to order groceries online, which would then be delivered to their homes the...
-
Continuation of Exercise 4-83. (a) What is the probability that the first major crack occurs between 12 and 15 miles of the start of inspection? (b) What is the probability that there are no major...
-
Which of the following is a financing activity? a. Increase in inventories b. Purchase of land c. Increase in accounts receivable d. Issuance of a mortgage e. All of these
-
Slapshot Company makes ice hockey sticks. Last week, direct materials (wood, paint, Kevlar, and resin) costing $32,000 were put into production. Direct labor of $28,000 (10 workers 200 hours $14...
-
What are some ways that a manager can identify a feasible set of decision alternatives?
-
What is prescriptive analytics?
-
What are the four Vs of big data?
-
How does data science software for programmers differ from data science software for business users?
Study smarter with the SolutionInn App