### Predicting kilowatt usage

Assignment Help Management Information Sys
##### Reference no: EM1323433

Predicting Kilowatt Usage- Economics/Information System

The company has determined kilowatt-hours used for last year and now wants to predict how usage can be controlled over the next year. It has identified a general growth percentage of 1.5%. This means its usage is expected to increase by at least that percentage. To balance that, each office applies a savings factor that reduces that growth factor. The directions for completing the formulas are on the sheet. When the projections are completed, you'll use Goal Seek to see how or if the company could reach a targeted kilowatt-hours saving level with a probable growth rate.

In cell D15, calculate first-quarter kilowatt-hours for next year using the forecast formula explained on the worksheet in cell B5. This formula uses absolute and mixed references. Hint: Formula in cell D15 should be =C15*(1+\$H\$4)*\$H6. Copy the formula without formatting to complete this section of the sheet for each quarter.
3. In cell H15, use SUM function with a range that does not include values from last year. Copy the formula to cell H18. Show a Next Year Total in cell H19.
4. Add a scenario named 1.5% Growth with the changing cell as cell H4. Include your name in the comment.
5. Use Goal Seek to find a growth rate that will result in 5,000,000 in total kilowatt-hours (cell H19). Use cell H4 as the changing cell. Save the Goal Seek solution as a scenario named New Growth, and include your name in the comment.
6. Create a scenario summary report for cells D15:G18. Make sure the report sheet is placed to the left of EnergyFrocast sheet.
7. Make a copy of the EnergyForecast worksheet, hiding columns A:C. Show formulas. Place the formula sheet to the right of the EnergyForecast sheet.
8. Save and close the workbook. Submit your work.

Solution Summary
This paper uses excel to predict how kilowatt usage can be controlled over the next year using a growth grate.

#### Questions Cloud

 Roles and goals of health care operations managers : This response states operations managements. The roles and goals of health care operations managers are discussed as well. References are included. Evaluate functional system : Evaluate functional system that would include a customer's name and explain the purpose of the system and why it would be included. Martin decision making model : Recognize a problem in your organization, or a challenge from your simulation experience, and apply the four stages of Martin's decision-making model to it. Explain the hyper-social organization : Explain the hyper-social organization. Explain the four pillars of a hyper-social organization Predicting kilowatt usage : Predicting Kilowatt Usage- Economics/Information System This paper uses excel to predict how kilowatt usage can be controlled over the next year using a growth grate Prepare a variance analysis report : Prepare a variance analysis report based on the information Overall description of company history : Company Research of five companies is provided in the structured manner in this response. The answer includes references employed. Who should be responsible for security : Who should be responsible for security- the government or individuals? Why do you think that? Linear programming using manual computation and excel solver : Formulate linear programming model for this problem. Mention the objective function (minimize or maximize) and all model constraints. Solve this model graphically. Identify the following: each constraint line, feasible solution area, x1, x2 and Z..

### Write a Review

#### Information technology and the changing fabric

Illustrations of concepts from organizational structure, organizational power and politics and organizational culture.

#### Case study: software-as-a-service goes mainstream

Explain the questions based on case study. case study - salesforce.com: software-as-a-service goes mainstream

#### Research proposal on cloud computing

The usage and influence of outsourcing and cloud computing on Management Information Systems is the proposed topic of the research project.

#### Host an e-commerce site for a small start-up company

This paper will help develop internet skills in commercial services for hosting an e-commerce site for a small start-up company.

#### How are internet technologies affecting the structure

How are Internet technologies affecting the structure and work roles of modern organizations?

#### Segregation of duties in the personal computing environment

Why is inadequate segregation of duties a problem in the personal computing environment?

#### Social media strategy implementation and evaluation

Social media strategy implementation and evaluation

#### Problems in the personal computing environment

What is the basic purpose behind segregation of duties a problem in the personal computing environment?

#### Role of it/is in an organisation

Prepare a presentation on Information Systems and Organizational changes

#### Perky pies

Information systems to adequately manage supply both up and down stream.

#### Mark the equilibrium price and quantity

The demand schedule for computer chips.

#### Visit and analyze the company-specific web-site

Visit and analyze the Company-specific web-site with respect to E-Commerce issues