Explore BrainMass

Explore BrainMass

    Projection model for Moss Fertilizers

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    ** Please see the attached file for the data **

    Moss Fertilizers
    Data collected on the yearly demand for 50-pound bags of fertilizer at Moss are shown in attached Excel sheet

    (a) Develop a three-year moving average forecast to predict sales for years 4 through 12. Is the forecasting method used appropriate for the data? Why or why not?

    (b) Use any computer program to develop a trend equation. Find the projected sales in years 12 and 13. Is the forecasting method used appropriate for the data? Why or why not?

    Computer output 2 Excel worksheets. Alternatively, you can show manual calculations. Note that trend projection is a time-series model and the independent variable should be time, which is year in this problem.
    Analysis/discussion. Show detailed calculations.

    © BrainMass Inc. brainmass.com June 4, 2020, 1:52 am ad1c9bdddf
    https://brainmass.com/business/sales-revenue/projection-model-moss-fertilizers-424843

    Attachments

    Solution Summary

    This solutions provides detailed step-by-step of how to produce a trend analysis for moss fertilizers in Excel. It also shows how to determine the best forecasting model. A spreadsheet file with detailed computations is included.

    $2.19

    ADVERTISEMENT