Requirements:
1. Create a spreadsheet model for this problem and solve it to determine the optimal solution.
2. Prepare a documentation sheet to support your model.
3. Prepare a three page report to the Town Council. Can you recommend an alternate plan to
Jennifer’s that would maximise total sales from the stores? Provide support for your
answer.
Assignment Deliverables:
1. Your spreadsheet model for this problem scenario with the ability to generate the optimal
solution.
2. Your documentation sheet for instruction and support for your model.
3. Your three page business report to the Town Council containing Jennifer’s plan for the ideal
arrangement of stores and your alternate recommendation.
Note: the three page business report should include an executive summary, introduction,
methodology, results/findings, discussion, conclusion and recommendations.
A title page, table of contents, reference list and appendix containing supporting
documentation may be submitted. These do not form part of the three page restrictions.
Note the reference list should contain references used in the body of your report.
4. Please include an assignment coversheet with your submission. Both word and pdf versions
of the coversheet can be downloaded from the assessment link and should be submitted
with your assignment to the Safe Assign link.
