Question: Do this using excel, please show steps & formulas Consider the following demand data. D1=10,D2=20,D3=30,D4=40. ROUND ALL ANSWERS TO THE CLOSEST INTEGER. (a) Use Moving

Do this using excel, please show steps & formulas

Consider the following demand data. D1=10,D2=20,D3=30,D4=40. ROUND ALL ANSWERS TO THE CLOSEST INTEGER. (a) Use Moving Average with N=3 to determine: (i) F4,5=1/3(40+30+20)=30 (ii) F4,6=30 (iii) D5=50. Now find F5,6=1/3(D3+D4+D5)=1/3(120)=40 (iv) F5,7=F5,8=40 (b) Use Exponential Smoothing with alpha =0.5, consider that F4= 30, and determine: (i) F4,5= alpha D4+(1alpha)F4=0.5(40)+0.5(30)=35 (ii) F4,6=35

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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!

need these fast 1. Which of the following is an example of a positive statement? O A. If this good is bad for you, you should not consume it. O B. If you consume this good, you will get sick. O C....

PLEASE COMPLETE NO LATER THAN 10/07 @8:00AM Each question(1,2,& 3) must be a minimum of 200 words. Please make answers detailed and knowledgeable based off the attached reading. ARE YOU ABLE TO...

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

the questions and material to answer the questions are attached here.... thank you! Final Exam MBA604 Part A Period (month) Demand Northeast 1 2 3 4 5 6 7 8 9 10 11 12 13 1200 1300 1200 1400 1500...

Please see attachment. All three question need to be answered in narrative format. If you have questions, just let me know. Normal requirement for references are 2 outside our course text....

Please process at your earliest convenience. I have enclosed the attached document and other required documents. Thank you for your help! Consider how Kyler Valley Spring Park Lodge could use capital...

answer the question clearly You are building a flight-control system for which a convincing safety case must be made. Would you assign the tasks of safety requirements engineering, test case...

CableTech Bell Corporation (Cl'B) operates in the telecommunications industry. CI'B has two divisions: the Phone Division and the Cable Service Division. The Phone Division manufactures telephones in...

Hi I need answers immediately. Attached is a file. I need the detailed solutions (no excel, can be typed or handwritten) to the long answer portions ONLY. Please read instructions for rounding rules....

KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...

Why is the determination of unit cost information using job order costing important in the management process?

Find and graph the discrete-time dynamical system for tail length. These data define several discrete-time dynamical systems. For example, between the first measurement (on day 0.5) and the second...

1. Draw the structural formulae of the following compounds. (a) ethane (b) propene (c) methanol

Create a C# application named SalesTransactionDemo that declares several SalesTransaction objects and displays their values and their sum. The SalesTransaction class contains the following fields:...