Question: Please do it in Excel SEO Off L DFF Sunner Hmeo Onli Suraj PateSP File Home Insert Page Layout Formulas Data Review View Help Sha

Please do it in Excel
SEO Off L DFF Sunner Hmeo Onli Suraj PateSP File Home Insert Page Layout Formulas Data Review View Help Sha o ? - do LG Tables Illustrations Add- ins Recommended Charts Maps PivotChart Sparklines Filters Lin 3D Map v Tours Charts Linke C12 B C D E F G H 1 2 Name Your Name 3 4 5 6 Problem 1.6 Spas A Spa store manager wants to forecast Jan, Feb, Mar for next year. Trend: f = 70 +5 (t) where t=0 for June last year Seasonal relatives: Jan=1.10, Feb=1.02, Mar=.95 7 8 9 10 Period Trend SR Forecast Month Jun Year Last Year 11 0 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 1.4 1.5 1.6 1.7 1.8 1.2 1.3 1.1 3 89F SunnyStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
