Monthly Demand Forecasting in Excel
Budget: $30 – $250 USD
I have 1–2 years of historical monthly demand figures from a manufacturing setting and I need a clear, quantitative forecast for the next period. There are no identifiable seasonal patterns in the data, so the focus is on comparing classic time-series techniques side by side.
Here is exactly what I want to see in the final Excel workbook:
• Separate, transparent worksheets for each method—Naïve, Moving Average, Exponential Smoothing, Trend Projection, and simple Linear Regression—showing every intermediate step rather than just final numbers.
• A concise summary table that lines up each method’s forecast, error measures (MAE, MAPE, or similar), and your overall ranking of the techniques.
• A short, plain-language explanation inside the file (or as a linked Word/PDF if you prefer) outlining why one method outperformed the others and which approach I should rely on for operational planning.
Please keep formulas visible, use standard Excel functions only (no add-ins or macros), and format the worksheets so another student can follow the logic easily. Experience with operations research, industrial engineering, or similar academic projects is a plus because the explanations must read professionally.
Turnaround is flexible for quality, but let me know how much time you need upfront.
Here is exactly what I want to see in the final Excel workbook:
• Separate, transparent worksheets for each method—Naïve, Moving Average, Exponential Smoothing, Trend Projection, and simple Linear Regression—showing every intermediate step rather than just final numbers.
• A concise summary table that lines up each method’s forecast, error measures (MAE, MAPE, or similar), and your overall ranking of the techniques.
• A short, plain-language explanation inside the file (or as a linked Word/PDF if you prefer) outlining why one method outperformed the others and which approach I should rely on for operational planning.
Please keep formulas visible, use standard Excel functions only (no add-ins or macros), and format the worksheets so another student can follow the logic easily. Experience with operations research, industrial engineering, or similar academic projects is a plus because the explanations must read professionally.
Turnaround is flexible for quality, but let me know how much time you need upfront.