Xlsc3p6a1b13 monthly 1200 no no yes no no no moving

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ng Average Value 1,870.00 452.15 Tracking Report Dates Apr-1996 May-1996 Jun-1996 Jul-1996 Aug-1996 Sep-1996 Oct-1996 Nov-1996 Dec-1996 Jan-1997 Feb-1997 Mar-1997 Apr-1997 May-1997 Jun-1997 Jul-1997 Aug-1997 Sep-1997 Oct-1997 Nov-1997 Dec-1997 Jan-1998 Feb-1998 Mar-1998 Actual 1,544.00 Forecast 1,913.00 2,028.00 1,178.00 1,554.00 1,910.00 1,208.00 2,467.00 2,101.00 1,662.00 2,432.00 2,443.00 1,974.00 2,221.00 2,171.80 2,185.96 2,290.75 2,262.50 2,226.40 2,227.48 2,238.62 2,249.15 2,240.83 2,236.50 2,238.52 Fitted Values 1,791.57 1,742.05 1,776.24 1,826.59 1,696.88 1,643.40 1,716.60 1,575.60 1,663.40 1,848.00 1,869.60 1,974.00 Inventory 3,000.00 2,500.00 2,000.00 1,500.00 1,000.00 500.00 Actual Forecast Mar-1998 Feb-1998 Jan-1998 Dec-1997 Nov-1997 Oct-1997 Sep-1997 Aug-1997 Jul-1997 Jun-1997 May-1997 Apr-1997 Mar-1997 Feb-1997 Jan-1997 Dec-1996 Nov-1996 Oct-1996 Sep-1996 Aug-1996 Jul-1996 Jun-1996 May-1996 Apr-1996 0.00 Fitted Values Forecast -- Moving Average Selected Date Apr-1997 May-1997 Jun-1997 Jul-1997 Aug-1997 Sep-1997 Oct-1997 Nov-1997 Dec-1997 Jan-1998 Feb-1998 Mar-1998 Total Avg Max Min Monthly 2,221.00 2,171.80 2,185.96 2,290.75 2,262.50 2,226.40 2,227.48 2,238.62 2,249.15 2,240.83 2,236.50 2,238.52 26,789.52 2,232.46 2,290.75 2,171.80 Forecast Quarterly Annual 6,578.76 6,779.66 6,715.26 20,073.67 6,715.85 6,697.38 6,779.66 6,578.76 20,073.67 20,073.67 20,073.67 Summary Comments The forecast has an average error of The data has a standard deviation of The forecast exceeds the accuracy of a simple average by 22.35% 452.15 0.00% Audit Trail - Summary Analysis Audit Trail - Statistics Accuracy Measures Mean Absolute Percentage Error (MAPE) R-Square Root Mean Square Error Method Statistics Method Selected Average Periods Value 22.35% 0.00% 454.76 Forecast Statistics Mean Standard Deviation Value Moving Average 5 ForecastX Configuration Parameters Item Data range selected Time scale for data Periods to forecast Seasonal Length Replace Outliers Activated Replace Outliers Standard Deviations Replace Outliers Forecasting Technique Replace Missing Values Replace Missing Values (Lower Limit) Replace Missing Values (Upper Limit) Remove Leading Zeroes Remove Trailing Zeroes Use Holdback Evaluation Holdback Evaluation Period Apply Tracking Signal Apply Tracking Signal (Under Forecast Percentage) Apply Tracking Signal (Over Forecast Percentage) Forecast Method Selected Report Details Run Date: 2/24/2014 6:19:33 PM Author: Lucas Messenger Note: Value [Chapter 3.xlsx]C3P6'!$A$1:$B$13 Monthly 12.00 No No Yes No No No Moving Average Value 1,870.00 452.15 Date Jan-92 Feb-92 Mar-92 Apr-92 May-92 Jun-92 Jul-92 Aug-92 Sep-92 Oct-92 Nov-92 Dec-92 Jan-93 Feb-93 Mar-93 Apr-93 May-93 Jun-93 Jul-93 Aug-93 Sep-93 Oct-93 Nov-93 Dec-93 Jan-94 Feb-94 Mar-94 Apr-94 May-94 Jun-94 Jul-94 Aug-94 Sep-94 Oct-94 Nov-94 Dec-94 Jan-95 Feb-95 Mar-95 Apr-95 May-95 Jun-95 Jul-95 Aug-95 Sep-95 Oct-95 Nov-95 Dec-95 Jan-96 Feb-96 Mar-96 Apr-96 May-96 Jun-96 Jul-96 Aug-96 Sep-96 Oc...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online