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

Western Pharmaceuticals A B, what should the case fill rate be for each pro...

what should the case fill rate be for each product given the current uncertainty levels and order quantities and how does the calculated aggregate case fill rate fill rate differ f

Factors influencing demand in organic food market, What is the factors infl...

What is the factors influencing demand in organic food market? Organic Food Market Organic farming is influenced by several factors. In this section, we analyse the factors tha

Process flow diagram-operations and supply chain, The Pampered Puss is a co...

The Pampered Puss is a company with headquarters in Melbourne, Australia and operates 35 retail shops. These shops are spread throughout the metropolitan area and were established

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

What is pestle analysis, Question 1: Explain the need for category managem...

Question 1: Explain the need for category management - Adds strategic value - Optimizes supplier relationship - Cultivates sustainable relationships with suppliers - S

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

Pricing Problem, Your job is to develop a prenegotiation position for all c...

Your job is to develop a prenegotiation position for all cost elements with explanations. Available information includes program information, a cost proposal, DCAS and DCAA reports

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,

Discuss the validity in Zimbabwe of the grounds on w, Discuss the validity ...

Discuss the validity in Zimbabwe of the grounds on which the profit maximising model of the firm has been defended.

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