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...
-
In the following list of nuclides, identify (a) Those with filled nucleon shells, (b) Those with one nucleon outside a filled shell, and (c) Those with one vacancy in an otherwise filled shell: 13C,...
-
Tyrone is a sales executive for a small company that does not have an accountable plan for reimbursing its employees for business expenses. Tyrone spends \($420\) on business expenses which he can...
-
For Example 16-1, estimate an average \(\mathrm{H}_{\mathrm{OG}}\) in the stripping section. Then calculate \(\mathrm{n}_{\mathrm{OG}}\) and \(\mathrm{h}_{\mathrm{E}}=\mathrm{H}_{\mathrm{OG}, \text {...
-
Following the Special Committee investigation in late 2003, Le-Nature's dismissed EY and retained BDO Seidman to serve as its independent audit firm. What safeguards are in place to mitigate the...
-
A 63-year-old couple is considering opening a business of their own. They will either purchase an established Gift and Card Shoppe or open a new Wine Boutique. The Gift Shoppe has a continuous income...
-
Determine the largest intensity w 0 of the distributed load that the beam can support if the beam can withstand a maximum shear force of V max = 1200 lb and a maximum bending moment of M max = 600 lb...
-
a. RKH Company is a small consulting service based just outside Los Angeles. It has two partners, Sebastian and Viola, and average monthly sales revenue of $25,000. At any one time, Sebastian and...
-
What is the As-Designed Configuration, and when is it established?
-
What is the difference between baseline management and CM?
-
What is a PRR and what is it intended to accomplish?
-
What is a TRR and what is it intended to accomplish?
-
How do you apply IV&V internally?
-
You've just purchased a $1,000 face value bon for $930. It pays semi-annual coupons and has 10 years to maturity and a 7.60% coupon rate. At what price should you be able to sell the bond in 4 years...
-
Derive Eq. (18.33) from Eq. (18.32).
-
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?
-
Define a forward stock split. What is the major reason for a forward stock split?
-
What information is presented in a statement of retained earnings? What information is presented in a statement of stockholders' equity?
-
How is a corporation's dividend yield calculated?
Study smarter with the SolutionInn App