Read “New Bakery for Oz Bread” case study. Develop an Excel model to use Solver (i.e., an add-in for optimisation) to help answer the case questions. Write a business report summarising the case, the issues identified, and your analysis of the different networks options under consideration.
The following should be noted:
(a) Executive Summary (Summarise the case, the findings of analysis, and the recommendations in one page.)
(b) Table of Contents (List the sections and subsections with corresponding page numbers on a separate page.)
(c) List of Figures (List the figure numbers and captions, if any, with corresponding page numbers on a separate page.)
(d) List of Tables (List the table numbers and captions, if any, with corresponding page numbers on a separate page.)
(e) Summary of the Case (Use your own words to give a brief summary of the case in half a page.)
(f) Objectives (State the purposes of the study and what needs to be investigated in half a page.)
(g) Issues Identified (Analyse the information provided in the case to identify the issues faced by the company in half a page.)
(h) Network Option Analysis (Analyse in one page the network options (i.e., scenarios) under consideration using the information provided in the case. Both the current (i.e., as-is) and the optimized (i.e., improved) configurations need to be worked out. While the as-is situation can be worked out using simple calculation, MS Solver will be needed to find the optimized solutions. Summary of findings of the scenario tests for the case questions should also be presented. NOTE: Only summaries of the analyses are needed in this section. Details of the analyses should be given in the Answers to the Case Questions section. Use summary tables to show the configurations and costs.)
(i) Recommendations (Recommend the best option to adopt based on the outcome of the analysis in half a page.)
(j) Conclusions (Summarise the study and give insight in half a page.)
(k) Answers to the Case Questions (Answer the case questions one by one in separate subsection with the question number clearly stated. DO NOT MERGE EVERYTHING into a big paragraph or essay. Marks will be deducted if answers to the case questions are not provided separately as required. Make full use of the information in the case and the model as a tool to help answer the questions. Assessment is based on how thorough the case analysis, whether the model has been appropriately used, and how relevant the answers to the case questions are.)
(l) References (List the references used in the report in strict Harvard style.)
(m) Appendices (Show the problem formulation and the Solver setups of the model.)
Tips for Assignment 2
For the quantitative assignment, the optimisation model should be set up in such a way that once validated it can serve as a tool to help answer the case questions. To answer the case questions, you are required to create one model on a separate spreadsheet for each scenario for each year to facilitate assessment. This can be easily done by copying the validated base model to a new spreadsheet and amend the input parameters and constraints where necessary to represent the conditions of the scenario prior to running Solver to get the optimal solution. Basically, the workbook should comprise at least 11 worksheets. Ten of them should be models and one is the action plan based on the recommendation.
NOTE: DO NOT use only one single spreadsheet or a summary report in the Excel workbook for everything and expect the assessor to create the models for the different scenarios from scratch to check your answers. Marks will be significantly deducted if the required models are not provided.
The following file contains some tips for this assignment:
Tips for the Oz Bread case.pdf
Assignment 2 Marking Rubric
For this assignment, the following marking rubric will be used:
Assignment 2 marking rubric.pdf