Dow jones industrial average opening index

Assignment Help Operation Management
Reference no: EM13762701

The following table provides the Dow Jones Industrial Average (DJIA) opening index

value on the first working day of 1994 through 2013.

YEAR DJIA

2013 13,104

2012 12,392

2011 11,577

2010 10,431

2009 8,772

2008 13,262

2007 12,460

2006 10,718

2005 10,784

2004 10,453

2003 8,342

2002 10,022

2001 10,791

2000 11,502

1999 9,213

1998 7,908

1997 6,448

1996 5,117

1995 3,834

1994 3,754

Use Excel 2013, Excel QM or QM Windows to analyze the data, print out the summary output and attach it to your submission.

a) Develop a trend line and use it to predict the opening DJIA index value for years

2014, 2015 and 2016. Find the MSE for this model

b) Use exponential smoothing with trend adjustment to forecast the opening DJIA for 2014. Use ? = 0.8 and ? = 0.2.

c) Compare the MSE for this technique with the MSE for the Trends line and comment on the difference.

Reference no: EM13762701

Questions Cloud

What is the firms inventory turnover : Suppose the revenue for a firm is $2,000,000. Its cost of goods sold is $85,000, and its average inventory value for the year is $50,000. What is the firm’s inventory turnover? Please include the formula, at least one step of calculation
Working on the logical model of the system : Tip Top Staffing supplies employees to hundreds of IT firms that require specialized skills for specific projects. Systems analysts Lisa Nuevo and Bill Goodman are working on the logical model of Tip Top’s billing and records system, using DFDs, a da..
Explain possible assumptions or misconceptions about family : Explain possible assumptions or misconceptions about each family, and your ideas for how to develop a greater understanding of each family.
Evaluation about the process of going about the closure : The Rancho Solono Preparatory School case had controversy over an administrative decsion decision that affected families. The school board decided to hire a consultant to evaluate the closure and provide expertise. What is your evaluation about the p..
Dow jones industrial average opening index : The following table provides the Dow Jones Industrial Average (DJIA) opening index.  Develop a trend line and use it to predict the opening DJIA index value for years. Compare the MSE for this technique with the MSE for the Trends line and comment on..
What is the break-even point for each machine : Zoe Garcia is the manager of a small office support business that supplies copying, binding, and other services for local companies. Zoe must replace a worn-out copy machine that is used for black and white copying. What is the break-even point for e..
Facility layout at wheeled coach ambulance : Facility Layout at Wheeled Coach Ambulance. Briefly describe how and where Wheeled Coach has incorporated the following psychological component of job design into its assembly line jobs:
Major disadvantages of aggregating all inventories : List two major disadvantages of aggregating all inventories in one location? What is the most important operational decision related to transportation in a supply chain? List four auctions in supplier selection?
What is the quality level of the production process : A producer of high-strength wire cables that are used in lifting spreaders and containers in a shipyard requires that the strength of the cables be more than 20 ton/in2 . The cost of a defective cable (200 ft in length) is $900. What is the quality l..

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd