Question

The following information relates to ABC Company's utilities cost and activity for the first six months...

The following information relates to ABC Company's utilities cost and activity
for the first six months of 2021:

         Month           Utilities Costs        Units Produced
         January             $17,200                6,200
         February             14,500                5,300
         March                18,600                7,100
         April                13,700                4,800
         May                  15,900                5,900
         June                 12,800                4,600

ABC Company expects to produce 6,500 units during July.

Using the high-low method, calculate ABC Company's expected utilities cost
for July.

Homework Answers

Answer #1
Calculation of expected utilities cost for July as per high-low method:
High Activity = 7,100 units = March
Low Activity = 4,600 units = June
Utilities cost of :
March = $       18,600
June = $       12,800
Variable cost per unit = ($18,600 - $ 12,800) / (7,100 - 4,600)
= ($5,800) / (2,500)
= $2.32 per unit produced
To calculate total fixed cost:
As per high activity = $18,600 - (7,100 X $2.32) = $         2,128
As per low activity = $ 12,800 - (4,600X $2.32) = $         2,128
Cost formula for utilities cost = $2,128 + $2.32X
Expected utilities cost for July = $2,128 + ($2.32*6,500) = $       17,208
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
Given the following cost and activity observations for Smithson Company's utilities, use the high-low method to...
Given the following cost and activity observations for Smithson Company's utilities, use the high-low method to calculate Smithson's fixed costs per month. Cost Machine Hours January $75,830 10,100 February 126,860 18,200 March 88,800 12,100 April 108,830 15,300 a.$12,200 b.$20,700 c.$9,800 d.$39,000
Given the following cost and activity observations for Smithson Company's utilities, use the high-low method to...
Given the following cost and activity observations for Smithson Company's utilities, use the high-low method to calculate Smithson's fixed costs per month. Round your final answer to the nearest dollar. Do not round interim calculations. Cost Machine Hours January $26,400 10,100 February 37,500 18,400 March 28,900 12,000 April 30,200 14,900 a.$21,918 b.$10,314 c.$12,893 d.$41,258
Handy’s Hats makes the world’s best hats. Information for the last eight months follows: Month Number...
Handy’s Hats makes the world’s best hats. Information for the last eight months follows: Month Number of Hats Produced Total Cost January 3,500 $6,000 February 5,250 8,615 March 2,800 5,250 April 4,800 8,200 May 1,600 4,600 June 2,500 5,300 July 3,250 5,700 August 4,350 7,920 Using the high-low method, calculate the total fixed cost per month and the variable cost per hat. (Round your "Variable Cost per Unit" answer to 3 decimal places.) Variable cost per unit: Fixed Cost:
Hardigree Insurance has collected the following information over the last six months. Month Units produced Total...
Hardigree Insurance has collected the following information over the last six months. Month Units produced Total costs March 2,000 $6,700 April 3,200 9,400 May 2,200 7,100 June 3,000 9,500 July 2,800 8,000 August 2,100 6,600 Using the high-low method, how much is the total fixed cost? $2,200 $7,910 $2,300 $4,400
The following information is available for a company’s maintenance cost over the last twelve months: Month...
The following information is available for a company’s maintenance cost over the last twelve months: Month Maintenance Hours Maintenance Cost January 43 $43,820 February 38 $45,010 March 35 $44,000 April 31 $45,000 May 36 $43,200 June 28 $38,760 July 18 $32,300 August 19 $35,440 September 25 $37,500 October 29 $39,560 November 34 $42,100 December 39 $46,700 Based on the high-low method, what is the variable and fixed cost component of total maintenance cost? Variable cost per unit: $ Fixed cost:...
PLEASE PLEASE ANSWER ASAP. THANK YOU! 1. Consider Derek's budget information: materials to be used, $63,000;...
PLEASE PLEASE ANSWER ASAP. THANK YOU! 1. Consider Derek's budget information: materials to be used, $63,000; direct labor, $198,800; factory overhead, $396,100; work in process inventory on January 1, $187,100; and work in progress inventory on December 31, $197,400. What is the budgeted cost of goods manufactured for the year? a.$647,600 b.$657,900 c.$845,000 6. Use the information for the company below to answer the question that follow. A company is preparing its cash budget. Its cash balance on January 1...
Exercise 8-1 Schedule of Expected Cash Collections [LO8-2] Silver Company makes a product that is very...
Exercise 8-1 Schedule of Expected Cash Collections [LO8-2] Silver Company makes a product that is very popular as a Mother’s Day gift. Thus, peak sales occur in May of each year, as shown in the company’s sales budget for the second quarter given below: April May June Total Budgeted sales (all on account) $440,000 $640,000 $220,000 $1,300,000 From past experience, the company has learned that 30% of a month’s sales are collected in the month of sale, another 60% are...