Forecasting for the Jersey Dairy Products Company
Not what you're looking for?
The Jersey Dairy Products Company produces cheese, which it sells to supermarkets and food processing companies. because of concernes about cholesterol and fat in cheese, the company has seen demad for its products decline during the past decade. It is now considering introducint some alternative low fat dairy products and wants to determine how much available plant capacity it will have next year. The company has developed an exponential smoothing forecast with a=.40 to foecast cheese demand. The actual demand and the forecasts from the model are as follows.
Year Demand(1,000 lb) Forecast
1 16.8 -
2 14.1 16.8
3 15.3 15.7
4 12.7 15.5
5 11.9 14.4
6 12.3 13.4
7 11.5 12.9
8 10.8 12.4
Access the accuracy of the forecast model by using MAD and cumulative error. If the exponential smoothing forecast model does not appear to be acurate, determine whether a linear trend moldel would provide a more accurate forecast
Purchase this Solution
Solution Summary
The solution includes techniques for MAD and cumulative error in order to solve this forecasting problem using Excel.
Purchase this Solution
Free BrainMass Quizzes
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce