Last Year's Forecast and Demand Data
Product #	Category	Forecast	Actual Demand
NO1	Never-out	769	678
NO2	Never-out	1070	987
NO3	Never-out	1121	1257
NO4	Never-out	1584	1582
NO5	Never-out	1919	1930
NO6	Never-out	633	684
NO7	Never-out	133	144
NO8	Never-out	364	316
NO9	Never-out	663	624
NO10	Never-out	1251	1380
NO11	Never-out	252	226
NO12	Never-out	413	413
NO13	Never-out	1839	1829
NO14	Never-out	242	262
NO15	Never-out	515	507
NO16	Never-out	1111	1163
NO17	Never-out	617	669
NO18	Never-out	1966	1935
NO19	Never-out	255	256
NO20	Never-out	1941	1987
NO21	Never-out	1442	1437
NO22	Never-out	1552	1284
NO23	Never-out	193	201
NO24	Never-out	1902	1925
NO25	Never-out	440	437
NO26	Never-out	1335	1119
NO27	Never-out	1412	1382
NO28	Never-out	555	589
NO29	Never-out	1012	894
NO30	Never-out	139	152
N1	New	476	237
N2	New	1338	1527
N3	New	1159	1135
N4	New	1924	774
N5	New	1024	1279
N6	New	172	115
N7	New	1339	760
N8	New	803	150
N9	New	1189	476
N10	New	1106	728
N11	New	290	158
N12	New	1265	184
N13	New	1212	728
N14	New	196	196
N15	New	1730	1322
N16	New	592	555
N17	New	839	527
N18	New	812	904
N19	New	1732	1370
N20	New	645	112

1) Calculate the A/F Ratios for all items. Then calculate the mean and stder of the A/F Ratios for each product category 2) Create two scatter plot charts: one for never outs and one for new products, showing the plot of forecast axis) vs. actual demand ly-axis). Place them in the spaces below. Make the x and yaxes have the same scale on both charts so that the 45 degree line on each has a slope of 1 fi.e., forecast = actual demand) and it is easy to compare across charts. Be sure to include axis labels. Never outs New Products 3) Based on Questions 1-2, describe in plain language) two differences that you observe between "never outs and new products with regards to forecasting performances be sure to interpret the average and the standard deviation of A/F ratios). Hypothesize a reason each difference might exist in practice at L.L. Bean