Purchase Solution

forecast electricity cost

Not what you're looking for?

Ask Custom Question

Please see the attached file.

Explain your answer briefly and clearly, showing any necessary calculations.
Your answer should be in an Excel file.
1. Westminster Company has had the following experience over the past five quarters:
Units produced Electricity cost ($)
27,000 101,000
32,000 120,000
31,000 116,000
20,000 84,000
22,000 90,000
a) Using the high-low method, determine an equation for electricity cost (Y) as a function of units produced (X). Assume a linear function.
b) Using your equation, forecast electricity cost at a volume of 25,000 units produced.

Attachments
Purchase this Solution

Solution Summary

Help is given to forecast electricity cost.

Purchase this Solution


Free BrainMass Quizzes
Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.