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 Budgeted OutputPizza Vesuvio makes specialty pizzas. Data for the past 8

Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted OutputPizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:MonthLabor CostEmployee HoursJanuary$7,000340February8,140530March9,899640April9,787590May8,490460June7,450330July9,490550August7,531290Assume that this information was used to construct the following formula for monthly labor cost.Total Labor Cost = $5,569+($6.77\times 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.Open spreadsheetRequired:Assume that 685 employee hours are budgeted for the month of September. Use the total labor cost formula for the following calculations:1. Calculate total variable labor cost for September. Round your answer to the nearest whole dollar.fill in the blank 1 of 1$4,9952. Calculate total labor cost for September. Round your answer to the nearest whole dollar.fill in the blank 1 of 1$10,232Feedback AreaFeedback1. Total Variable Labor Cost = Variable Rate \times Employee Hours2. Use the cost formula given.Total Labor Cost Employee Hours
image text in transcribed

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

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

Medical Practice Accounting And Finance

Authors: Rose Marie Bukics, Donald R. Chambers

1st Edition

155738617X, 9781557386175

More Books

Students also viewed these Accounting questions