Reference no: EM133552369 , Length: word count:2500

Enterprise Analytics for Business Professionals

Assessment - Enterprise Analysis Problems

Analyse and report your analysis on one of the two enterprise decision problems below. Your analysis and reporting should do the following as appropriate to the problem:

1. State your assumptions.
2. Define the objective of the decision or decisions, and any conditions.
3. Structure the problem in such a way that data collection and analysis will lead to the best decision alternative given the objective and conditions.
4. Choose appropriate data collection and analysis methods from among those covered in this course and explain why they are appropriate for the problem. *
5. Describe how you would apply the methods to the problem.
6. Where there are sufficient data provided or otherwise available...
a. Apply methods to the problem. (Report sufficient detail for replication/auditing.)
b. Describe the findings of your analyses and the resulting decision recommendation.
7. Describe how the decision, if it were implemented, should be monitored and evaluated.
8. Speculate on how the process might be improved in the light of possible feedback or more resources.

Problem 1: Investment decision

Your task is to advise a farmer on what crop to plant in the forthcoming season (2022 for the purpose of this assignment). The farmer usually grows chickpeas (6-8mm Kabuli).

Your analysis should compare the prospects for lentils (medium rainfall), miling oats(medium rainfall) with the prospects for chickpeas for the 2022 season. You can ignore issues about crop sequencing.

Using the data in PIRSA (2022), and your own choice of forecasting method, prepare forecast (pro forma) gross margin financial statements along the lines of the ones in the PIRSA (2022) report for expected revenue and variable costs, and for pessimistic and optimistic scenario revenue and variable costs.

Write a report to address items 1 to 8, above also include the excel sheet.