Exam-1.doc (Compatibility Model- Word (Product Activation Failed) Review View Te

Question

Exam-1.doc (Compatibility Model- Word (Product Activation Failed) Review View Tell me what you want to do Mailings Emphasis Heading 1 1 Normal Strong Subtitle Paragraph Styles The sales data for ABC Company is given in the table. Answer the following questions based on the results obtained from linear trend using EXCEL shown below. (5 marks) 3. Sales Sales Month (t) S000) (y 125 122 125 129 127 132 129 135 137 138 140 135 130 125 120 115 110 y 1.6788x+ 120.67 -Sales 5 6 Linear (Sales) 10 1 2 3 4 5 6 7 8 9 10 a) From the trend line identify the value of a: b: Ga-bt) b) Find the forecast for the sales of month 12 - c) How much is the expected monthly increase or decrease in the sales according to the trend line d) In which month the deviation was minimum based on the trend line e) In which month the deviation was maximum based on the trend line [D e

Explanation / Answer

Trend line Y = a+bt a 120.67 b 1.6788 Ans A t Y=a+bt Month Sales Forecast 1 125 122.3488 2 122 124.0276 3 125 125.7064 4 129 127.3852 5 127 129.064 6 132 130.7428 7 129 132.4216 8 135 134.1004 9 137 135.7792 10 138 137.458 11 139.1368 12 140.8156 Ans B Monthly increase is b 1.6788 Ans C t S Y=a+bt We consider abs for max or min deviation Month Sales Forecast Deviation (Y-S) 1 125 122.3488 2.6512 2 122 124.0276 -2.0276 3 125 125.7064 -0.7064 4 129 127.3852 1.6148 5 127 129.064 -2.064 6 132 130.7428 1.2572 7 129 132.4216 -3.4216 Max deviation Ans E 8 135 134.1004 0.8996 9 137 135.7792 1.2208 10 138 137.458 0.542 Min Deviation Ans D 11 139.1368 12 140.8156

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.