Question: WHAT ARE THE CORRECT FORMULAS FOR PART C ON EXCEL? THE PART B FORMULA IS CORRECT. THE CORRECT ANSWERS ARE CORRECT IN THE QUESTION. The

WHAT ARE THE CORRECT FORMULAS FOR PART C ON EXCEL? THE PART B FORMULA IS CORRECT.

THE CORRECT ANSWERS ARE CORRECT IN THE QUESTION.

WHAT ARE THE CORRECT FORMULAS FOR PART C ON

The following table shows the actual demand observed over the last 11 years: 2 4 6 9 10 Year Demand 1 7 3 5 5 13 7 12 8 13 11 7 9 9 8 9 11 This exercise contains only parts b, c, and d. b) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your responses to one decimal place). Year 4 5 6 7 8 9 10 11 12 Forecast 7.0 7.7 9.0 10.0 11.0 11.0 11.3 11.0 9.0 c) Using the 3-year weighted moving average with weights 0.10, 0.30, and 0.60, using 0.60 for the most recent period, provide the forecast from periods 4 through 12 (round your responses to one decimal place). Year 4 5 6 7 8 9 10 11 12 8.4 Forecast 6.4 7.8 11.0 9.6 10.9 12.2 10.5 10.6 d) Mean absolute deviation for the forecast developed using the 3-year moving average is 2.33 and for the 3-year weighted moving average is 2.83. Based on this information, the better forecast is achieved using the 3-year moving average approach A B 9 A B C D 1 Year Registrations (000) 3 Year MA 2 1 7 3 2 9 4 3 5 5 4 9 =AVERAGE(B2:34) 65 13 =AVERAGE(B3:35) 76 8 =AVERAGE(B4:36) 8 7 12 =AVERAGE(B5:17) 98 13 =AVERAGE(B6:B8) 10 9 9 =AVERAGE(B7:39) 11 10 11 =AVERAGE(B8:B10) 12 11 7 =AVERAGE(B9:B11) 13 12 =AVERAGE(B10:B12) 14 15 Year Registrations (000) Weight 3 Year WMA 16 1 7 0.6 17 2 9 0.3 18 3 5 0.1 19 4 9 =SUMPRODUCT($C$16:$C$18,816:B18)/4 20 5 13 =SUMPRODUCT($C$16:$C$18,B17:319)/4 21 6 8 =SUMPRODUCT($C$16:$C$18,018:B20)/4 22 7 =SUMPRODUCT($C$16:$C$18,319:B21)/4 23 8 13 =SUMPRODUCT($C$16:$C$18,B20:B22)/4 24 9 9 =SUMPRODUCT($C$16:$C$18,B21:B23)/4 25 10 11 =SUMPRODUCT($C$16:$C$18,B22:B24)/4 26 11 7 =SUMPRODUCT($C$16:$C$18,B23:325)/4 27 12 =SUMPRODUCT($C$16:$C$18,B24:B26)/4 9 9 12 9

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!

Stock Returns and Variance Estimating stock returns, variance and standard deviation. Problem 1: You bought 100 shares of Starbucks Corp. (SBUX) 7 years ago (1 Aug 95) for $5.00 per share and sold...

5.8.4 Test (TS): Applications of Probability Test Archis Chinmulgund Geometry Sem 2 (S3990682) Points possible: 50 Date: ____________ Answer the following questions using what you've learned from...

List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...

Help?! This is my current assignment and I'm completely lost. Instructions NAME: To complete the homework assignments in the templates provided: 1. The question is provided for each problem. You may...

the answer for 1-7 are there, could ypu please answer 8-12 Answer 1 of 1 Done A,B) 733 AVERAGE YEAR SEMESTER GA PAHA FRESHMAN FALL 25 FRESHMAN SPRING 22 2.5 FRESHMAN SUMMER 27 2 SOPHOMORA 2.08...

please help!! b. Suppose you are considering two possible investment opportunities: a 12year Treasury bond and a 7-year, A-rated corporate bond. The current real risk-free rate is 4%, and inflation...

PLEASE SOLVE QUESTION 3 USING EXCEL ONLY!!! SHOW ALL FOMRULAS USED IN EXCEL 2. The following table shows information about an Amazon.com bond as of July 19, 2017: Amazon.com Bond Information...

MINDTAP Q Search this cours nterest Rate Determination and Yield Curves b. Suppose you are considering two possible investment opportunities: a 12-year Treasury bond and a 7-year, AA-rated corporate...

I would like to know if someone can assist with inputting the formulas into the Excel spreadsheets..... Answers are provided, however, the formulas were omitted. Week 9 Chapter 21: Problems 3(a-e),...

Expressed x = 7,8, 9 in R' as a linear combination of the following vectors u = 2, 1, 4 , v = 1, 1,3 and w = 3,2,5. %3D

Outsourcing is one of the major trends in business management over the past 20 years. It has evolved from a purely cost-reducing measure to a transformative strategy. a. Describe how the purposes of...

P2.25 H. S. Black is noted for developing a negative feedback amplifier in 1927. Often overlooked is the fact that three years earlier he had invented a circuit design technique known as feedforward...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...