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

Forecasting supply chain requirements, Need to do a moving average method. ...

Need to do a moving average method. Calculating the MA(2), 3 and 4. Please tell me if there is a question like in which data is given like Week Time Period

Purchasing and supply.., 5 steps in the process of evaluating the purchasin...

5 steps in the process of evaluating the purchasing and supply system

Prompt, 4. About 5% of delivered products are spoiled upon delivery with ei...

4. About 5% of delivered products are spoiled upon delivery with either the fish or plants dying, or both, due to sensitivity to changes in temperatures, which is a major financial

Network design, can you help with network design questions?

can you help with network design questions?

A Supply chain reconfiguration case study , A Supply chain reconfiguration ...

A Supply chain reconfiguration case study The case company (referred to as ABC) is a leading supplier of maintenance, repair and operating (MRO) products to business and institut

Fresh produce supply chain, The Fresh Produce Supply Chain Fresh produ...

The Fresh Produce Supply Chain Fresh produce was grown in many locations worldwide. However, certain areas proved more economically viable than others for large-scale producti

Packaging fresh produce, Packaging Fresh Produce Packaging for fresh pr...

Packaging Fresh Produce Packaging for fresh produce varied by region, purpose, and personal preference. Ideally, packaging was low cost, low maintenance, strong enough to prote

Show the benefits of the diversification strategy, The history of Mauritius...

The history of Mauritius is closely linked with the cultivation of sugarcane. Despite the fact that Mauritius has evolved from an agricultural-based economy to a services-based eco

Warehouse, introduction of the imporatance of materials handling and transp...

introduction of the imporatance of materials handling and transportation

Briefly explain main stages of a typical procurement cycle, Problem 1: ...

Problem 1: (a) Briefly explain the main stages of a typical procurement cycle. (b) Discuss four methods of dealing effectively with low value orders. Problem 2: J

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