Submission

Each question should be prepared as a separate document and each converted to a single PDF file,

which should be submitted to the appropriate Canvas dropbox prior to the due date and time.

Answers may be handwritten and/or typed as long as a single PDF file per question is submitted. Please submit the questions parts in order, or indicate clearly if any Excel outputs are appendicised.

Assistance

Kevin is available for office hours at times and locations to be advised.

There will be no staff answering Piazza questions on the day that the assignment is due. Excel Notes

This assignment requires you to construct spreadsheet models in Excel. You will be asked to submit two

views/screenshots of the spreadsheet; the first showing optimal spreadsheet values (as found by Solver) and the second showing the spreadsheet formulae.

For Questions 2 and 3, you will also be asked to submit your Excel .xlsx spreadsheet file. We will primarily

mark your screenshots in your PDF submission, but if needed, we will check your spreadsheets.

You can generate your Excel output either by printing the required reports directly to PDF (print in landscape mode where appropriate), or by using the Snipping Tool (Windows) or Command - Shift - 4 (Mac).

You can display formulae in Excel by using Formulas → Formula Auditing → Show Formulas (see image below, left).

Excel output showing formulae should include row and column headings; use Page Layout → Sheet Options → Headings → Print (see image below, right) to enable this in printouts, or else ensure that this is captured in your screenshot(s).

If indicated in the question, you should also include a screenshot of the Solver Parameters dialog window.

Diagrams and formulations on paper and in Excel must match the formats provided in lectures as closely as possible. You will receive very few marks for answers that do not reasonably match these formats.

Transportation Layout

Your layout should match that used in lectures.  This means that the only cells you can change are the

values highlighted below in green (and the associated text, highlighted in blue).  You can, of course, add

more rows and columns to these tables, but the ‘Total’ formulae and the ‘Total cost’ formula should have

the same format as shown. Coloured cells are optional in your formulation.