Question: Please use Excel and include all Excel formulas and Solver solutions. After tallying the receipts for their first year of operation, the owners of the
Please use Excel and include all Excel formulas and Solver solutions.


After tallying the receipts for their first year of operation, the owners of the Taco Barn are encouraged. Sales of their artisanal tacos, made from such exotic ingredients as ground beef, cheese, and beans, have been strong and seem to give hope to the coming year. Taco sales by month are shown in the table. The manager is open to suggestions for forecasting models and decides to try both a linear trend model and an exponential smoothing model with an alpha of 0.8. Generate forecasts for the year using these techniques and then calculate forecast errors using MAD to determine which is the superior method in this scenario
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
