Part 12-720 34-720 1-720 34-420 1-420 Total Days U n it! Day Total Days U n it! Day Q1 Unit Sales 09/28/ 03 01/04! 04 4,311 10,214 13,851 7,397 3,609 39,382 64 615 Q2 Unit Sales 01/04/04 04/03/04 6,637 20,983 31,507 9,043 7,049 75,219 65 1,157 Q3 Unit Sales 04/04/04 07/03/04 7,823 27,492 66,644 11,233 9,676 122,868 64 1,920 Q4 Unit Sales 0 7/04/04 10/02/04 6,652 19,535 17,337 7,496 3,976 54,996 63 873 292,463 256 1,142 Raw '56 8.70% 26.70% 44.20% 12.00% 8.30% 100.00% Plan Bill % 10.60% 25.10% 44.10% 12.00% 8.20% 100 Forecast 12-mth Demand Actual 1,400iday Demand 37, 100 87,850 154,350 42,000 28,700 350 I000 250 1,400 350,000 250 1,400 1. How accurate was Wilkins demand forecast for the first quarter of 2005? Use the forecast error and MAPE to calculate forecast accuracy. Calculate the accuracies for the re valves and PVBs aggregate family of products as well as for each product of both families individually. Note: to disaggregate the product family forecast into the individual products use the planning bill % of Exhibits 3 and 4