Question: Week 1 2 3 4 5 6 7 8 9 10 11 12 A product has a consistent year round demand. You are the

Week 1 2 3 4 5 6 7 8 9 10 11 12 A product has a consistent year round demand. You are the planner and have been tasked with experimenting with some time series analysis. Using this previous weekly demand, calculate the following forecasts for each period possible. A) 4 Period Simple moving average B) 3 Period O Weighted moving average using weights of .7,.2,.1, C) four period weighted moving average with weights of .4,.3,.2,.1 and D) Exponential Smoothing forecast using an Alpha of .25. and a Week 1 forecast of 1900 units. Round all forecasts to whole numbers. Demand 1850 1760 1832 1895 1906 1852 1786 1790 1809 1925 1948 1960 SMA 4 Period WMA .7,.2,.1 WMA .4, .3, .2, .1 EXP Sm .25 1900

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

SOLUTION To calculate the forecasts using different methods well use the provided demand data and apply the specified forecasting techniques Here are the calculations for each period A 4Period Simple ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Find out: (1) Break-even point (5) Sala to cann a profit of $120,000 (3) Selling price per unit, of the B.C.P brought down to 60,000 units Fixed cort $100.000 Vanable cast poo unit: $6 Selling price...

If the focal length of a lens is 3 centimeters and the image distance is 5 centimeters from the lens, what is the distance from the object to the lens?

What are 2 examples of U.S. public health laws that improve environments to make healthy choices easier for individuals. Explain how these laws help with chronic disease prevention or management.

Please see the snap photo below for further instructions. thank you 1. Read the Electrolux and GE Applianceh 2. \"the Excel spreadsheet template prov1 e posted N 3 Answer the following questions....

Hi I need help with this assignment. I uploaded photos of the excel sheets involved in a Supply Chain LOGEX Simulation. It asks to find optimal information beginning in week 4 through 12. AutoSave...

Analytics Exercise 21-1 (Algo) Recently, Phil Harris, the production control manager at Brunswick, read an article on time-phased requirements planning. He was curious about how this technique might...

I have questions on "Chapter 17 Time Series Analysis and Forecasting. The questions is in the attachment; that are problem number 29 and 30 (it is on last three pages, not the multiple choice...

Slyses ELE UNIVERSE TO IF and Nested IF (Spoints) 1. Examine the Assignment details worksheet and enter your full name. 2. Click on the Customer Relations worksheet and play around with the data by...

Please asnwer the last three questions ! Charts 1-4 and project the inventory and Available To Promise (ATP) components Master Schedule 4: Head and Taillight Set - Existing Inventory = 5 Master...

CASE 14 CONSOLIDATED WEEDCUTTERS Part Number Made from Part Number Quantity per 100 301 2. 302 2 150 302 1 Consolidated Weedcutters Inc. makes two models of cutters, the standard (part number 100),...

Find the slope of the graph of the function at the given input value. Round your answer to three decimal places. f(x) = 3x - 3*, x = 4

An antiseptic solution contains hydrogen peroxide, H2O2, in water. The solution is 0.600 m H2O2. What is the mole fraction of hydrogen peroxide?

The following statement is an example of which decision - making trap? Hey , we just did something exactly like this. I know just what to do ! Overconfidence Confirmation Availability Sunk costs

On January 1, 2001, Wishful Thinking, a lessor, entered into a direct financing lease agreement with Lennard Company The lease agreement required 6 equal annual payments of $50,000 at the end of each...

On January 1, 2003, Plentiva Company signed a five year lease that required equal payments of $55,000 at the end of each year The cost value of the lease equipment was $100,000 The estimated residual...

Place a control button in the worksheet that calls a VBA macro that processes the following sales data (your final code should work with data sheets that have more or fewer regions and more or fewer...

An object with m 1 = 5kg is attached to a spring of negligible mass. This mass/spring combination is then slid horizontally on a frictionless surface with a velocity of 5m/s towards a stationary...

Mr. Y. K. Chan has asked for your professional advice. Please write a report to him discussing the matters he should consider, in particular related to: 1. Duties, rights and competences of a...

Solve for the given problem. Please show your solutions clearly and orderly.

Recently, Phil Harris, the production control manager at Brunswick, read an article on time-phased requirements planning. He was curious about how this technique might work in scheduling Brunswick's...

this is the question Consider the model y = XB+E, where E(e|X) ==0 and V(e|X) = N. 1. Derive the expected value and covariance matrix of the estimator BaLs=(X'a'X)X'N'y. (1) 2. Consider the case...

1. Complete the master schedule for Product X, including the projected available inventory and the ATP numbers. 2. From the master schedule for Product X and using the data given for components A, B,...

3.6. The Acme Widget Company makes widgets in two models, and the bottleneck operation is in work center 1. Following is the resource bill (in hours per part). Hours per Part Work Center Model A...

QUESTION 2 Ricardo is currently working on a lot sizing decision in his shop. The net requirements for a material from an MRP schedule are: Week 1 2 3 4 5 6 7 8 Net requirements 600 800 1200 1650...

A manufacturer keeps its finished inventories in a warehouse, which serves three downstream retailers. Assume that the manufacturer's warehouse has an initial inventory of 3000 items and a minimum...