demand forecasting, Supply Chain Management

Assignment Help:
As1. Ms. Winnie Lin’s company sells computers. Monthly sales for a six-month period are
as follows:
MONTH SALES
Jan 18,000
Feb 22,000
Mar 16,000
Apr 18,000
May 20,000
Jun 24,000
a. Plot the monthly data on a sheet of graph paper.
b. Compute the sales forecast for July using the following approaches: (1) a four-month
moving average; (2) a weighted three-month moving average using .50 for June, .30
for May and .20 for April; (3) a linear trend equation (4) exponential smoothing
with a (smoothing constant) equal to .40, assuming a February forecast of 18,000
c. Which method do you think is the least appropriate? Why?

Related Discussions:- demand forecasting

Reduced inventory level, Mining and Industrial Tyre Supply Inc (MITSI) dist...

Mining and Industrial Tyre Supply Inc (MITSI) distributes and sells tyres. While most of MITSI's sales come from earthmover and industrial tyres, they also stock and sell a very mi

What is the need of supply chain mapping, Question 1: What is the need ...

Question 1: What is the need of supply chain mapping? Briefly describe supply chain mapping. Explanation , Examples - diagram, use Question 2: Describe the three typ

DIFFERENCE BETWEEN SUPPLY CHAIN AND VALUE CHAIN, WHAT IS THE DIFFERENCE BET...

WHAT IS THE DIFFERENCE BETWEEN SUPPLY CHAIN AND VALUE CHAIN

Analyse the stages of the procurement cycle, Problem 1: What do you mea...

Problem 1: What do you meant by the ‘Purchasing Function'? Describe some benefits accrued to a firm having an effective purchasing function? Problem 2: Purchasing Depar

Answer, What is the effect of overstocking and under stocking in an organiz...

What is the effect of overstocking and under stocking in an organization?

What are the factors influencing contracting strategies, Question 1: De...

Question 1: Describe the terminologies used in purchasing of services and goods? A Client, users, sponsors, bidding, tender, contract, purchase order, line managers, buyer,

Challenge question, what is the potential negative or downside to the long-...

what is the potential negative or downside to the long-term Starbucks-OHL collaboration? identify what you consider to be three major potential problems in such long term relations

Analytics Exercise: Forecasting Supply Chain Demand—Starbuck, 1 Consider us...

1 Consider using a simple moving average model. Experiment with models using five weeks’ and three weeks’ past data. The past data in each region are given below (week 21 is the we

Sensitivity analysis, If I follow your recommended approach to managing my ...

If I follow your recommended approach to managing my farm so as to maximize my operating income next month, how much will I earn from selling the 100 hogs?” asks Igor. “How many ho

Write Your Message!

Captcha
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