National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a s

Question

National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:

    

   

    

A linear trend equation.(Round your intermediate calculations and final answer to 2 decimal places.)

   

    

A five-month moving average. (Round your answer to 2 decimal places.)

    

    

Exponential smoothing with a smoothing constant equal to .20, assuming a March forecast of 19(000). (Round your intermediate forecast values and final answer to 2 decimal places)

    

   

    

    

A weighted average using .50 for August, .10 for July, and .40 for June. (Round your answer to 2 decimal places.)

     

National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:

Explanation / Answer

Answer:(2) 5 Month moving average=11+21+18+25+22/5

=$19.40

Answer:(3)

Answer:(4) $22 thousand

Answer:(5) 0.50*22+0.10*25+0.40*18

=$11+$2.5+$7.2

=$20.7

Month Forecast = F (old) + 0.20[Actual-F(old)] April 19.2 = 19 + 0.20(20-19) May 17.56 = 19.2 + 0.20(11-19.20) June 18.248 = 17.56 + 0.20(21-17.56) July 18.1984 = 18.248 + 0.20(18-18.248) Aug 19.55832 = 18.198 + 0.20(25-18.1984) Sept 20.04634 = 19.558 + 0.20(22-19.5583)

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

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