Question

Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for a Time Period that...

Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for a Time Period that Differs from the Data Period

Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:

Month Labor Cost Employee Hours
January $7,100 340
February 9,999 530
March 8,240 610
April 9,887 590
May 8,590 460
June 7,631 330
July 9,590 550
August 7,550 290

Assume that this information was used to construct the following formula for monthly labor cost.

Total Labor Cost = $6,924 + ($2.16 X Employee Hours)

Required:

Assume that 3,900 employee hours are budgeted for the coming year. Use the total labor cost formula to make the following calculations:

1. Calculate total variable labor cost for the coming year. Round your answer to the nearest dollar.
$fill in the blank 1

2. Calculate total fixed labor cost for the coming year. Round your answer to the nearest dollar.
$fill in the blank 2

3. Calculate total labor cost for the coming year. Round your answer to the nearest dollar.

Homework Answers

Answer #1

Solution:

1. $8,424

2. $83,088

3. $91,512

Explanation:

Labour cost Employee hours
High activity level 9,999 610
Low activity level 7,100 290
Change

2,899

(9999-7100)

320

(610-320)

Variable cost

9.06

(2899/320)

Total cost 7,100
Variable cost element 9.06
Fixed cost element

4473

7100 - (290 x 9.06)

Assume 3900 employee hours

Total labour cost = $6,924 + (2.16 x employee hours) is given

Here

1. Variable labour cost = 2.16 x 3900 = 8,424

2. Fixed cost = 6924 x 12 = 83,088

3. Total labour cost = variable cost + fixed cost = 8424 + 83088 = 91,512

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and construct a cost function Pizza...
Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and construct a cost function Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Month Labor Cost Employee Hours January 9,590 490 February 7,100 570 March 7,631 610 April 8,240 460 May 9,887 530 June 8,590 420 July 12,460 680 August 7,600 380 Pizza Vesuvio's controller wants to calculate the fixed and variable costs associated with labor used in the restaurant. In your calculations, round the...
Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and Construct a Cost Function Pizza...
Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and Construct a Cost Function Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Month Labor Cost($) Employee Hours January 9,790 290 February 7,300 330 March 7,831 350 April 8,440 260 May 10,087 310 June 8,790 240 July 11,040 400 August 7,800 220 Pizza Vesuvio's controller wants to calculate the fixed and variable costs associated with labor used in the restaurant. In your calculations, round the...
Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Pizza Vesuvio...
Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Pizza Vesuvio makes specialty pizzas. Data for the past eight months were collected: Month Labor Cost Employee Hours January $7,000   360 February 8,140 550 March 9,899 630 April 9,787 610 May 8,490 480 June 7,450 350 July 9,490 570 August 7,531 310 Assume that this information was used to construct the following formula for monthly labor cost. Total Labor Cost = $5,237 + ($7.40 x Employee...
Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and Construct a Cost Function Pizza...
Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and Construct a Cost Function Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Month Labor Cost($) Employee Hours January 9,290 350 February 6,800 410 March 7,331 430 April 7,940 320 May 9,587 380 June 8,290 300 July 10,732 490 August 7,300 270 Pizza Vesuvio's controller wants to calculate the fixed and variable costs associated with labor used in the restaurant. In your calculations, round the...
Cost Behavior Alisha Incorporated manufactures medical stents for use in heart bypass surgery. Based on past...
Cost Behavior Alisha Incorporated manufactures medical stents for use in heart bypass surgery. Based on past experience, Alisha has found that its total maintenance costs can be represented by the following formula: Maintenance Cost = $386,000 + $17.40X where X = Number of Heart Stents. Last year, Alisha produced 70,000 stents. Actual maintenance costs for the year were as expected. Required: 1. What is the total maintenance cost incurred by Alisha last year? Round your answer to the nearest dollar....
Calculate the total variable cost per unit. Variable cost per unit Calculate the total fixed expense...
Calculate the total variable cost per unit. Variable cost per unit Calculate the total fixed expense for the year. Total fixed expense for the year Operating income Operating loss Sales Total contribution margin Total fixed cost Total variable cost Head-First Company plans to sell 5,000 bicycle helmets at $75 each in the coming year. Product costs include: Direct materials per helmet $ 30 Direct labor per helmet 8 Variable factory overhead per helmet 4 Total fixed factory overhead 20,000 Variable...
Flexible Overhead Budget Wiki Wiki Company has determined that the variable overhead rate is $3.8 per...
Flexible Overhead Budget Wiki Wiki Company has determined that the variable overhead rate is $3.8 per direct labor hour in the Fabrication Department. The normal production capacity for the Fabrication Department is 9,000 hours for the month. Fixed costs are budgeted at $47,700 for the month. a. Prepare a monthly factory overhead flexible budget for 8,000, 9,000, and 10,000 hours of production. Enter all amounts as positive numbers. Wiki Wiki Company Monthly Factory Overhead Cost Budget-Fabrication Department Direct labor hours...
Direct Materials and Direct Labor Variance Analysis Shasta Fixture Company manufactures faucets in a small manufacturing...
Direct Materials and Direct Labor Variance Analysis Shasta Fixture Company manufactures faucets in a small manufacturing facility. The faucets are made from brass. Manufacturing has 30 employees. Each employee presently provides 35 hours of labor per week. Information about a production week is as follows: Standard wage per hour $16.80 Standard labor time per unit 20 min. Standard number of lbs. of brass 1.9 lbs. Standard price per lb. of brass $10.25 Actual price per lb. of brass $10.50 Actual...
Predetermined Overhead Rate, Applied Overhead, Unit Cost Ripley, Inc., costs products using a normal costing system....
Predetermined Overhead Rate, Applied Overhead, Unit Cost Ripley, Inc., costs products using a normal costing system. The following data are available for last year: Budgeted:       Overhead      $343,000       Machine hours      88,000       Direct labor hours      9,800 Actual:       Overhead      $342,200       Machine hours      85,800       Direct labor hours       9,580       Prime cost      $1,464,700       Number of units      180,000 Overhead is applied on the basis of direct labor hours. Required: 1. What was the predetermined overhead rate? $fill in the...
Direct Materials and Direct Labor Variance Analysis Shasta Fixture Company manufactures faucets in a small manufacturing...
Direct Materials and Direct Labor Variance Analysis Shasta Fixture Company manufactures faucets in a small manufacturing facility. The faucets are made from brass. Manufacturing has 50 employees. Each employee presently provides 36 hours of labor per week. Information about a production week is as follows: Standard wage per hour $16.20 Standard labor time per unit 20 min. Standard number of lbs. of brass 1.8 lbs. Standard price per lb. of brass $13.00 Actual price per lb. of brass $13.25 Actual...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT
Active Questions
  • Emerald Co. uses a perpetual inventory system and records purchases of merchandise at net cost. The...
    asked 23 minutes ago
  • Movie stars and U.S. presidents have fished Pyramid Lake. It is one of the best places...
    asked 57 minutes ago
  • what advantages do percent distributions have over frequency distributions when comparing populations at different years?
    asked 1 hour ago
  • Richard has just been given a 6-question multiple-choice quiz in his history class. Each question has...
    asked 1 hour ago
  • Write about westernized elements in life; westernization in our life, and this includes Americanization.
    asked 2 hours ago
  • The college Physical Education Department offered an Advanced First Aid course last summer. The scores on...
    asked 2 hours ago
  • Researchers hypothesized that increasing a woman's level of arousal would increase her perceptions of attractiveness of...
    asked 2 hours ago
  • Equation 37-14b in the textbook gives the energy emitted by Hydrogen when electrons transition between states...
    asked 2 hours ago
  • Theory of Computation Please provide explanation too on how it works a. Give an NFA recognizing...
    asked 2 hours ago
  • Question 1 A sequential pattern detection circuit (state machine) has input A and output Y, which...
    asked 2 hours ago
  • Natural Foods Inc. is planning to invest in new manufacturing equipment to make a new garden...
    asked 3 hours ago
  • Explain why a callable bond's price would be expected to decline less than an otherwise comparable...
    asked 3 hours ago