Determine the forecasted demand for the coming month

Assignment Help Operation Management

Reference no: EM131721633

PART A: Introduction and Methodology

Chapter 7 presents methods of forecasting, order management, and customer service. Please review again the concepts of Chapter 7 and also study Appendix 7. The appendix explains how to determine the "activity-based costing" system. Also, Table 7.1 shows one method to adjust demand using weights, depending upon the reliability and importance of the data from previous months. Compare how the projected demand was determined using the "simple moving average" and a "weighted moving average." In this particular example, more "weight" or reliability was given to the data from the past month.

PART B: Application (please scroll down to see all the instructions)

You got the following information of sales (demand) for four products:

Product Alpha Product Omega Product Gama Product Beta

Last Month 1300 2500 800 180

Two Months Ago 1250 2670 950 25

Three Months Ago 1100 3200 1230 110

Four Months Ago 920 4230 1300 12

Five Months Ago 1230 2990 1390 55

Six Months Ago 1520 2130 1456 9

Determine the forecasted demand for the coming month by using the simple moving average (similar to the textbook example) and a weighted moving average. This time and due to seasonal sales, you will assign a higher weight to the demand that is the farthest from the present time -that is, sales tend to have a six-month cycle; so the most reliable data is from the past. Make sure that adding the weights will always be one (or 100%). Examine the numbers and, in addition to the two methods, determine your own forecast. Create a spreadsheet with your calculations and conclude. these two methods provide a reliable number? Would you like to have an educated guess of the demand for this month just by looking how these numbers behave?

Reference no: EM131721633

Questions Cloud

Explain which charting method you would select to display : Critical to ensure that the fundamental structure of data is understood. If data are only presented in a summarized, narrative form, misinterpretation

Why should cash flow be projected for a new product : Why should cash flow be projected for a new product and what other factors should be included in the analysis?

World wide web affect accountability in important ways : the World Wide Web affect accountability in important ways. Do you think e-reporting makes government more responsive

Information statements of a public firm benny : You are given with the following information statements of a public firm Benny in the airline industry concurrently.

Determine the forecasted demand for the coming month : Determine the forecasted demand for the coming month by using the simple moving average (similar to the textbook example) and a weighted moving average.

Outline a brief business continuity plan : Outline a brief business continuity plan, including controls to reduce the risks in advance as well as a disaster recovery plan

Calculate the value of a bond that matures : Calculate the value of a bond that matures in 10 years and has a $1,000 par value. The annual coupon interest rate is 9 percent

What is the implied interest rate of the lottery winnings : You just won $35 million in the Florida lottery. The State will pay you over 20 years of $1.75 million each year beginning immediately.

Coupon bond of semi-annual coupon payment : Suppose you're given with the following information for some assets; a 10-year 2.0%-coupon bond of semi-annualcoupon payment with face value

User Account

All Pages