Word Report and Excel Solver needed
Budget: $10 – $30 AUD
-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER.
-report should be mainly for the economic order quantity
(EOQ) analysis and the answers to the qualitative questions. No introduction
-1900 word report
-There should be at least FOUR worksheets in the Excel
workbook. Two of them should show the following two demand
forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne.
1. Moving average
2. Static method.
for the other two: summary of the regression
analysis for the static method. The other one should compare the performance of the two forecasting methods using the key performance indicators (KPIs) mentioned in Task 1 Question (c). The suggested table format should be used.
-SETUP SOLVER WITH CONSTRAINTS of labels and keys for illustration and tracking
-report should be mainly for the economic order quantity
(EOQ) analysis and the answers to the qualitative questions. No introduction
-1900 word report
-There should be at least FOUR worksheets in the Excel
workbook. Two of them should show the following two demand
forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne.
1. Moving average
2. Static method.
for the other two: summary of the regression
analysis for the static method. The other one should compare the performance of the two forecasting methods using the key performance indicators (KPIs) mentioned in Task 1 Question (c). The suggested table format should be used.
-SETUP SOLVER WITH CONSTRAINTS of labels and keys for illustration and tracking