Question: inventory forecast analytic. PLEASE help OFF Home Insert Draw Page Layout Formulas Data Review View B1 X fx Month A B D E G H

inventory forecast analytic. PLEASE help

OFF Home Insert Draw Page Layout Formulas Data Review View B1 X fx Month A B D E G H 1 2 3 4 5 6 7 8 9 10 Month January February March April May June July 12 13 Year 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 August September October November December January February March April May June July August September October November December Sales Dollars $717 $838 $859 $746 $946 $727 $998 $801 $988 $780 $866 $826 $957 $851 $917 $888 $845 $998 $995 $769 $805 $916 $724 $941 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 3B 39 40 QUESTION 1 What is the 5 month moving average forecast for Sales dollars for March 2020 using the data link provided below in Microsoft Excel? Select the closest answer. SalesData.xlsx 5878 $875 $917 $856 QUESTION 2 What is the 4 month weighted moving average forecast for Sales dollars for October 2020 using the data link provided below in Microsoft Excel? The weights are as follows: the weight of the newest data point is 0.5, the weight of the previous data point is 0.1, the weight of the previous data point is 0.1, and the weight of the oldest data point is 0.3. Select the closest answer. SalesData.xlsx $878 $807 $947 $998 QUESTION 3 What is the exponential smoothing forecast for Sales dollars for September 2020 using the data link provided below in Microsoft Excel Assume alpha or the smoothing constant to be 0.45. Select the closest answer Sales Data.xlsx 5911 $799 5873 $956 QUESTION 4 What is the Sales dollars forecast for May 2020 using the data link provided below in Microsoft Excel? You must use the Holt-Winter's forecast. Alpha, beta, and gamma all equal 0.70. Select the closest answer SalesData.xlsx 51.235 5903 $1,082 O $3,761

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!

please help me Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 ' ' % Conditional Formatting Formatas Table Call Styles Paste B A Alignment Number 28 Axfox A B O H...

attached was the journal entries and then all info from january. i am needing the general ledger for febuary, the trial balance and adjusted trial balance, balance sheet, income statement,ect. My...

please solve all the problems. Format Tools Data Window Help Espinal Mineis-ACP Excel File Edit View Insert BU Home insert Draw Page Layout Formulas Data Review View A- So Wrap Text B A aste Merge &...

Can anyone help me How to put the Formula to get the rightanswer. What will be the right formula and what mistake I ammaking. The right answer is -3975. Please help. File Home Insert Draw Page Layout...

Epinal Mineisy-OP Excel file Est View insert Format Tools Data Window Help Home inn Page Layout Formulas Data Review View A om :! Date Description of the Transaction March 1 Owners of OP invested...

The Chippewa Chocolates (CC) Company began business on January 1 st , 2020. After its first year of operation, CCs president, Allen Hale, is now trying to prepare the companys master budget for the...

How do you figure the cash balance, income statement, budgeted balance sheet and goal seeking? if anything i prefer to figure cash balance and income statement. THANK YOU! AutoSave Off H U A CCT 285...

Thank you for agreeing to help me with the accounting for my business. My dad always told me that learning how to do landscaping would be a great way to pay for my College education. However, I...

Window Help Format Tools Data Excel Espina Minels-ACP File Edit View insert BU Insert Page Layout Data Formulas Review View Home Draw W Text Mere Dentet F5 Spring Summer 2021. Mac Accounting Cycle...

please help me its so urgent Excal Fe Est View Format Tons Data Window Help DO Mountain Sports Ltd Case Study ACCT1110 Spring-VF-2 insert Draw Page Layout Formulas Data Review View Tell me Comments...

A small coffee shop administered a net promoter score survey to 17 customers. Here are the results of the survey: Compute the NPS for the coffee shop. 13508 455166 0 618131

In Chapter 7, you developed a use case diagram, an activity diagram, and a system sequence diagram for the use cases Rent movies and Return movies. In Chapter 11 you developed a first-cut DCD and...

Question 3 2 2 pts 1 4 Examples of training provided to expats are ( mark all that apply ) : family and dual career issues challenge prefudices, assumptions, and attitudes safety and security skills...

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...