Running sum of the forecast errors

Assignment Help Other Subject
Reference no: EM13331742

Hoops Industries has a simple forecasting model. The following table shows the forecast for eight weeks and the actual demand.

Week Forecast Demand Actual Demand

1 140 137

2 140 133

3 140 150

4 140 160

5 140 180

6 150 170

7 150 185

8 150 205

Calculate the three-week moving average forecast for Week 9. Compute the MAD and MAPE of forecast errors. Using the running sum of the forecast errors (RSFE), compute the tracking signal.

Based on your answers to the above, comment on Hoops’ method of forecasting.

Submit your answers in a Microsoft Excel sheet.

Reference no: EM13331742

Questions Cloud

What are the pros and cons of a chain of command : What are the pros and cons of a chain of command as an organizational tool. What benefits are provided by the use of a specific chain of command? What issues might result from its use?
Forecasting is art-science of predicting future events : Forecasting is the art and science of predicting future events. Organizations are constantly creating forecasts for different uses within the organization. Besides setting production levels, what are some other uses of forecasts within the organizati..
Decision of starting his business in international market : An Entrepreneur was running his business successfully in Pakistan. He decided to expand his business in the international market. He sent few very senior employees to the Europe for running his branch over there.
Introduce its first product in the market : Suppose you have registered a new company & now your company is going to introduce its first product in the market, Product has been developed after having all product related decisions the only pending decision is “fixing introductory product price”
Running sum of the forecast errors : Calculate the three-week moving average forecast for Week 9. Compute the MAD and MAPE of forecast errors. Using the running sum of the forecast errors (RSFE), compute the tracking signal.
Government project want their activities on critical path : The government spends a large amount of money each year on contracts. In fact, the federal procurement department spent over $425 billion in the fiscal year 2006 with over $33 million on Lockheed Martin Corporation alone. These projects are often kno..
Key external factors-threats and opportunities : As you have studied about external and internal factors in an industry analysis. Your job is to identify only the key external factors (Threats and Opportunities) of Virtual University of Pakistan. You should point out at least 10 Opportunities and t..
Porter s competitive factors : Which of the following is EXCLUDED from Porter s competitive factors?
Defined as a procedure for valuing the price of a stock : Which of the following is defined as a procedure for valuing the price of a stock by using predicted dividends and discounting them back to present value?

Reviews

Write a Review

 

Other Subject Questions & Answers

  Preventive health service or curative care

Should national funding priorities in the United States primarily address preventive health service or curative care? Discuss the reasons for the answer.

  Large moons of jupiter did galileo find most significant

Which of the following observations of the motions of the large moons of jupiter did galileo find most significant?

  Distribution of the number of bagel customers

A baker wants to know how many dozens of bagels to bake each day in order to maximize pro?t. For any given day, the probability distribution of the number of bagel customers is given by

  Should these types of restrictions be made into law

The European Community has proposed a set of laws that would strictly limit how database information is used and who has access to it.

  How formal organizations have evolved over past century

Describe how formal organizations have evolved over past century. Write down differences were there in organizations a century ago, compared to today's organizations?

  Wireless device such as smart phone

Have you ever used a mobile, wireless device such as smart phone? If so, what do you like or dislike about it? In what ways could your use of that device be made better?

  Traditional gender based division of labor by encouraging

The author of a report to publicize the first attempt by the English to start a North American colony. Handsome Lake believed that it was in his society's best interest to modify its traditional gender based division of labor by encouraging

  What is values

What values (if any) are assigned to x, y, and ch after each of these statements execute?

  Example of conditioanl

Provide example of conditioanl where, the antecedent is false and the consequent is true, and conditional is true. Also where the conditional is false.

  Automobile engine does not turn over nor does anything else

When you turn the key to start your car, the automobile engine does not turn over nor does anything else happen. which of the following procedures would be the first action to take in determining the cause of the problem?

  Water at 20 c is pumped from bottom of a large storage tank

Water at 20 C Is pumped from the bottom of a large storage tank where the pressure is 310.3 kpa gage to a nozzle which is 15.25m above the tank bottom and discharges to the atmosphere with a velocity in the nozzle of 19.81m/s. the water flow rate is ..

  The spread of christianity

Read "The Spread of Christianity ", "The Latin Church in Western Europe" and "The Encounter between War and Religion." Discuss the development of the Roman Catholic Church.

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