Question: this is all one question QUESTION 9 The following time series shows the sales of a particular commodity over the past 7 weeks. (Download the

this is all one question

QUESTION 9 The following time series shows the sales of a particular commodity over the past 7 weeks. (Download the Excel file if needed: Exponential Smoothing.xls) Week Sales Forecast 1 1.123 2 1.157 3 1.138 4 1.120 5 1.130 6 1.132 1.188 2 2 1.157 3 1.138 4 1.120 3 1,130 6 1.132 7 1.188 1. Use a = 0.3 to develop the exponential smoothing values for the time series. Complete the table for forecast values. If there is no value for the forecast, type: "No value". Round the numbers to two decimal places if needed. 2. What is the forecast sale for the next week (week 8)? Sales in Week 8 = 2 C D E G Forecast J K M N 2 Werk 1 2 S 4 3 5 Sales 1120 1,157 1,138 1.120 1.130 1.132 1.188 7 9 10 11 12

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!

can you please type and send so that i can copy and paste Assignment 2 1- The following time series shows the sales of a particular product over the past 12 months. Month - 2 3 4 5 6 Sales 105 135...

A B C D E F G H K M N O P 0.2 Sales Squared 20 points Week Exponential Squared Moving Smoothing error average error The following time series shows the sales of a particular commodity over W N 1,123...

QUESTION 20 The following time series shows the sales of a particular commodity over the past 7 weeks. Week Sales Forecast 1 1,123 2 1.157 3 1.138 1,120 5 1.130 6 1,132 7 1.188 1. Use a = 0.3 to...

Q2-Sales Data (4pt) Download "Q2" Excel file from Moodle. Use this template to answer the questions (part 1 to 4) below. Save the files as "Question Number Last Name" (e.g. Q2_LEE) The following time...

Moving to another question will save this response. estion 5 The following time series shows the sales of a particular commodity over the past 5 weeks: Using =0.3, what is the exponential smoothing...

Forecasting Revenues Project The City of Colorado Springs depends on sales and use tax revenue for t_l_19_r_r_raj9rity_of the General Fund's annual revenue Since the Great Recession of 2008, the city...

Hoyt, Inc. has estimated current year sales (in millions) for the next four quarters. Q1 $240Q2 $250 Q3 $205 Q4 $350 ? Sales for the 1st quarter next year are projected to be $230.? Accounts...

Question 2 5 pts The time series below shows the sales of a particular commodity over the past 5 weeks. Week Sales 1 1,190 2 1,104 3 1,191 4 1,175 5 1.171 Using a = 0.3, what is the exponential...

Instructions Throughout this course we will continue to use the Excel spreadsheet program as a tool to solve and document typical business problems related to the week's topics. We will continue to...

QUESTION 19 The following times series shows the demand for a particular product over the past 6 months. (Download the Excel file if needed: Moving Average.xlsx) Month Demand Forecast 1 250 2 220 3...

The figure above shows cost curves for a perfectly competitive firm Suppose that market price is $520. A firm producing 2,150 units of output should produce profits of $ A profit-maximizing firm will...

Read the Crisis at the Mill Case Study and conversation: To: Shankar Krishnan, Managing Director at the global professional services firm Alvarez & Marshal (A&M) From: Steve Cohen, Managing...

Charlene Nakedi was diagnosed with terminal cancer during August 2 0 2 3 . She is married to Daniel out of community of property and they have a daughter, Janette, aged 2 1 , and a son, James, aged 1...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...