Forecast total apparent consumption

Assignment Help Other Subject
Reference no: EM13944848

Learning Outcomes: By exploring the application of business forecasts you will gain an understanding of the value of forecasting in a business environment. Preparing a forecast will provide you with the skills to apply quantitative and qualitative forecasting techniques when required for business decision making. The analysis of a volume of actual data will require application of a spreadsheet, supporting the value of software programs in facilitating the use of time series data. Research using the internet will increase your knowledge of data availability for use in business forecasting.

Task: use the data on the following table from the ABS to complete this task

1. Forecast total apparent consumption (‘000) Litres for 1) white wine 2) Red wine, and 3) Total wine, in terms of volume of beverage for 2006 - 2015. Prepare line graphs for each forecast and the actuals on the same axes.

2. Forecast per capita consumption (litres) for Total wine by volume 2006 - 2015. Prepare a line graph for this forecast and the actuals on the same axes.

3. Explain by whom and for what purpose the forecasts would be used. Provide examples of decisions that would be made based on the forecasts, including the consequences of incorrect decisions.

4. Based on the uses and consequences, determine an acceptable level of accuracy for the forecasts.

5. Use graphing software to calculate the Centred Moving Average (CMA) for the total apparent consumption. Prepare a line graph showing actual data and CMA on the same graph.

6. Observe the data and graph for trends, cycles or irregularities. Include details of your observations in your report.

7. Combine your observations with research on such factors as the future of the economy, the industry and any other variables that you think may be relevant in predicting a combined trend/cycle growth % for 2015. Make sure your research is appropriate for the wine industry. Report your prediction, including a summary of your findings and assumptions to justify your prediction.

8. Compare your forecast with actual results from the data and calculate the MAPE. Comment on the accuracy of your forecast comparing it with your acceptable level of accuracy determined earlier. Explain how you could have produced a more accurate result, think of different methods or different assumptions that may have worked better and whether the actual results have been affected by any unusual factors or incidences.

Reference no: EM13944848

Discuss the implications of possible solutions for project

You are a consultant in a hospice facility for adult patients who come from diverse ethnic and cultural backgrounds. The administration has two concerns. First, there have b

Pat invented a device that could be screwed into the ground

Pat invented a device that could be screwed into the ground, adding piping as necessary, to create a do-it-yourself well.  The pipe could then be attached to a pump to draw gr

What is the population of your research design

What is the population of your research design? Does the research (or the research question) require a representative sample of your population? Why or Why Not? What sampling

Describe your process and the items you uncovered

Describe your process and the items you uncovered during your review. In a few sentences, explain how you will correct the issues and ask questions if you need help or advic

Discuss the role you think cognitive psychology plays

Based on what you have learned, discuss the role you think cognitive psychology plays in understanding human behavior and interactions. How has this field advanced our under

What solution are different governments trying to achieve

Describe the ways in which different levels of government interrelate. What solution are the different governments trying to achieve? Identify the advantages and disadvantag

Can you come up with an example of a research study

Think about ethics in research - can you come up with an example of a research study that would be unethical today? Why is it unethical? What should be done instead? Are the

Example in the literature of a successful intervention

Locate one example in the literature of a successful intervention that addressed a social determinant of health. Give the full reference to the article using APA formatting. F

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd