Scenario
Seasonal Delights Catering offer personalised catering to corporate clients. To help cost their jobs they have
recently implemented a Job Costing System. The head chef has allocated a costing for ingredients to each
menu item to help quickly calculate how much they will spend on materials based on the menu selected by
the client. For each job casual staff are employed by the hour as required. You need to help finish off the
spreadsheet template that they will use to cost Job 4155 and all future jobs.
Start by downloading the assessment workbook from iLearn and copying/moving it to an appropriate folder.
When you open the Excel file it is very important that you Enable Macros and Content. You will then be asked
to enter your Student Number (you will not be able to edit it afterwards, so type it in carefully) and then enter
your Student Name. Please note the first two worksheets are locked and you will only be able to change the
cells specified.

DETAILED ASSIGNMENT

20200930060309accg2000_excel_assessment_s2_2020instructions