Determine the forecast for each sku using method

Assignment Help Supply Chain Management
Reference no: EM138855

Cooper Toys sells a portable baby stroller called the Tot n' Trot. The past two years of demand for Tot n'Trots are shown in the table below. Use an appropriate method to forecast the 6  months from January through June 2006. Please defend your use of forecasting method (i.e. why you selected your particular method). If you are using smoothing constants, you must also defend (mathematically please) why you selected the values that you did. How good is your forecast?

Jan 2004

1200

Feb

1400

Mar

1450

Apr

1580

May

1796

June

2102

July

2152

Aug

2022

Sept

1888

Oct

1938

Nov

1988

Dec

1839

Jan 2005

1684

Feb

1944

Mar

1994

Apr

2154

May

2430

June

2827

July

2877

Aug

2687

Sept

2492

Oct

2542

Nov

2592

Dec

2382

Using the forecasting paper supplied, "Forecasting demand for single-period products: A case study in the apparel industry", Mostard, Teunter, de Koster, European Journal of Operational Research, Vol 211, and the demand information given in the Excel spreadsheet "demand data for forecasting":

  • Determine the forecast for each SKU using Method 1, 2 and 3. Then, assume the season is over, and your actual demand is given in the sheet "realized demand". Determine:
  • The accuracy of your forecast (quantitatively and qualitatively).

Now read Section 3.2.1 of the paper. Assume you have five experts and their forecasts are given in the "experts" sheet. Using the method given:

  • Determine your forecast for each SKU and the accuracy of these experts (quantitatively and qualitatively).
  • Attachment:- File_2.xlsx
  • Attachment:- File_3.pdf

Reference no: EM138855

Previous Q& A

  Marketing division sell its product.

What is the optimal transfer price for the basic plastic item . At what price should the marketing division sell its product.

  Elasticity of demand for its products

The Wilson Company's marketing manager has determined that the price elasticity of demand for its products equals.

  Equal wage rates in every market of labor

Suppose that all the necessary conditions exist for the realization of equal wage rates in every market of labor.

  What is the thickness of electroplated gold

Two 53 {rm g} blocks are held 30 {rm cm} above a table. One of them is just touching a 50-long spring. The blocks are released at the same time. The block on the left hits the table at accurately the same instant as the block on the right first comes..

  Demand for labour is elastic

if the demand for labor is elastic because the demand for labor will decrease more when you have elastic demand than if demand were inelastic.

  If the boat proceeds at its maximum speed

A child in danger of drowning in a river is being carried downstream by a current that has a speed of 2.75 km/hr. The child is 0.560 km from shore and 0.750 km upstream of a boat landing when a rescue boat sets out. If the boat proceeds at its maximu..

  Profits of boat makers in short run

What happens to the profits of boat makers in short run. Illustrate what happens to the number of boat makers in the long run.

  A sports car moving at constant speed

Below are birds-eye views of six identical toy cars moving to the right at 2? Various forces act on the cars with magnitudes and directions indicated below. All forces act in the horizontal plane and are either equivalent or at 45 or 90 degrees to ca..

  Income tax in a certain nation is computed

Suppose that the income tax in a certain nation is computed as a flat rate of 5 percent, but no tax is levied above $50,000 in taxable income.

  Magnitude and direction of the car''s acceleration

In the 1950s, an experimental train that had a mass of 2.30 x 10^4 kg was powered across a level track by a jet engine that produced the thrust of 5.30 x 10^5 N for a distance of 504 m. unless otherwise directed, suppose that air resistance is neglig..

Reviews

Write a Review

 

Similar Q& A

  What do you meant by logistics performance index

What do you meant by Logistics Performance Index?  How can it be used? Give an example. Evaluate the expected number of trucks waiting in the queue to be unloaded and evaluate the expected time in the queue- that is the expected time a truck has..

  What is the economic order quantity for fans in units

Nittany Fans of Lewistown, Pennsylvania, is a distributor of industrial fans used in plants, warehouses, and other industrial facilities.

  Explain the levels of intensity in the distribution channel

Explain the levels of intensity in the distribution channel

  Explain the supply chain of milk

Explain the supply chain of milk

  Compare and contrast economic - market, and relevancy

Please compare and contrast economic, market, and relevancy value.

  Depth analysis of a global cold chain

The logistics of a global cold chain getting fresh vegetables from farms in Thailand to supermarkets in Europe

  Prepare a global trading environment

To what extent has the World Trade Organization helped to prepare a global trading environment that is favorable for your business or country?

  Criteria when making new location decisions

Identify a number of the typical criteria used when making new location decisions

  Explain the supply chain management concept

Explain the supply chain management concept, Differentiate between public and private sector organisations in terms of their supply chain objectives and strategies

  Supply chain management questions

Briefly define the following two supply chain metrics: (i) inventory turnover ratio and (ii) supply chain velocity.

  Forecasting method and forecast the demand for the years

Select the appropriate forecasting method and forecast the demand for the years 2010 to 2012. Determine the production and subcontracted quantities per quarter.

  Brushing up on inventory control

Health system in Pennsylvania

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