Question: 2 diffewnt question. Problem 3-9 (Algo) a. Obtain the linear trend equation for the following data on new checking accounts at Fair Savings Bank and


Problem 3-9 (Algo) a. Obtain the linear trend equation for the following data on new checking accounts at Fair Savings Bank and use it to predict expected new checking accounts for periods 16 through 19. (Round your intermediate calculations and final answers to 2 decimal places.) 232 243 Period New Accounts Period New Accounts Period New Accounts 1 200 6 11 281 2 212 2 12 275 3 211 8 250 13 283 228 9 253 14 288 5 235 10 15 312 267 y Y16 Y17 Y18 719 Problem 3-2 (Algo) National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Feb. Mar. Apr. May. Jun. Jul. Aug. Sales (000)Units 18 21 15 23 20 26 23 Click here for the Excel Data File a. Forecast September sales volume using each of the following: (1) The naive approach Naive approach 23 thousands (2) A five-month moving average. (Round your answer to 2 decimal places.) Moving average 21.40 thousands (3) A weighted average using 0.60 for August. 0.10 for July, and 0.30 for June (Round your answer to 2 decimal places.) Weighted average 22,400.00 thousands (4) Exponential smoothing with a smoothing constant equal to 0.15, assuming a March forecast of 16(000). (Round your intermediat forecast values and final answer to 2 decimal places.) Forecast thousands (5) A linear trend equation (Round your intermediate calculations and final answer to 2 decimal places.) YE thousands
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
