Question: Use this information to answer Questions 1-3. High Low Method Calculation You are the manager of an educational facility and have been asked to predict

Use this information to answer Questions 1-3. High Low Method Calculation You are the manager of an educational facility and have been asked to predict analyze the electric cost for 2020 based on the following 12 months of Information, You know the electric cost has both fixed and variable costs. Month KW Used Cost January 64,700 6,235.0 February 68,000 6,400.0 March 67,000 6,350.0 April 56,000 5,800.0 May 59,000 5,950.0 June 67,500 6,375.0 July 71,200 6,560.0 August 65,900 6,295.0 September 78,000 6,900.0 October 79,500 6,975.0 November 89,200 7,460.0 December 87,300 7,365.0 What is the variable cost per KW? What is the fixed cost per month? If this company were to use 18,145 KW, predict the total cost?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

High Low Method Calculation You are the manager of an educational facility and have beenasked to predict analyze the electric cost for 2020 based on the following 12 months of Information, You know...

Part One Big Als Pizza, Inc., a new subsidiary of Big Als Pizza Emporium, has been established to produce partially baked, flash-frozen, 16-inch meat pizzas to be sold wholesale to grocery and...

OK, here is the problem. It is supposed to be done in excel. E-mail me if you have any questions. Thank you! ashley_bates05@hotmail.com Part One Big Al's Pizza, Inc., a new subsidiary of Big Al's...

Board CHAPTER 1 Economics: Foundations and Models n this book, we use economics to answer questions such as the following What determines the prices of goods and services from bottled water to smart...

Part One Big Als Pizza, Inc., a new subsidiary of Big Als Pizza Emporium, has been established to produce partially baked, flash-frozen, 16-inch meat pizzas to be sold wholesale to grocery and...

Number 8,32,33,34,44 please. I dont know how to do any of them. Fundamentals of Finance (FIN305) Problem Set 4 Part I Take your time to work through the questions presented below to make sure you...

there is an excel sheet but it wont let me upload it i would be happy to email it some how D 1 2 3 TTT 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39...

When are outcomes said to be independent? What is meant by the gamblers fallacy?

What is the difference in reporting income from a subsidiary in the parents separate income statement and in consolidated financial statements?

Of the following, the controls that are often difficult for internal auditors to evaluate because of the lack of criteria or standards are A . Preventive controls. B . Financial controls. C ....

what id a supersntigen