Excel template - Saved Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Editing V Arial 10 v B A v ... Ev ab Merge v General V $ v F4 v X VA A B C D E F G H K L M 1 Moving Average Forecast (4 periods) 2 Use the area below to draw a line chart for the four-period moving average. 3 Period Actual Demand Forecast Formulas 4 1,400 2,300 2, 100 1,700 ONOUAWN 2,600 #N/A 3,700 #N/A 3,000 #N/A 8 2,900 #N/A 12 9 4,300 #N/A 13 10 4,600 #N/A 14 11 4,200 #N/A 15 12 4,200 #N/A 16 13 #N/A 17 18 19 20D Control Center | DroneMobile Ac X D2L Grades - 22F --Intro Supply Chair X MindTap - Cengage Learning X G Calculate the forecast for the per X Excel Online Student Work X + V X > C eng.cengage.com/staticb/ui/evo/index.html?deploymentld=58810925458335823008825427&elSBN=9781337617130&id=1604350711&snapshotld=31426898 I S Error Sandip v CENGAGE | MINDTAP Q Search this course ? My Home Microsoft Excel Activity #1: Moving Average Forecast X Courses Question 1 0/10 Catalog and Study Tools Submit Excel Online Structured Activity: Moving Average Forecast Rental Options Consider the demand for some product over the last 12 periods. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop the four-period moving average forecast and answer the following questions. College Success Tips X Career Success Tips Open spreadsheet ? Help Questions Give Feedback 1. Calculate the forecast for the periods from 5 to 13 using a four-period simple moving average. Do not round intermediate calculations. Round your answers to the nearest whole number. Period Forecast 5 A-Z Office 10 00 10 11 12 N 13 Back Next 58.F ENG 9:52 AM Partly sunny US 2022-09-22