ACCG200 Management Accounting

Scenario

Futura robotics manufacture custom made robotic components. Each job is unique and costed individually. You are required to create a spreadsheet that records a list of completed jobs and allows the company to cost up new jobs.

Start by downloading the assessment workbook from iLearn and copying/moving it to an appropriate folder. When you open the workbook it is very important that you Enable Macros/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.

General Guidelines

• With the exception of the Journal Accounts, which are to be selected from the drop-down list, all the light blue cells require you to insert some form of calculation or cell reference, i.e. start with an “=” - just typing in the answer will result in 0 marks.
• Do not change the structure of the workbook in any way or put any workings anywhere other than directed.
• Only use rounding functions where specifically requested.
• The use of named ranges and tables is encouraged, and where specified may be required. If not specifically required there will be no penalty for not using them, but it may make the formulas more difficult.
• Because you are developing a model that we will wish to use for future years/jobs or different values it is very important that all calculations will return a correct answer regardless of the values in the spreadsheet and must still work correctly when the lists of data (e.g. Completed Jobs, & Inventory) are sorted in a different order.
• Double check your answers as you go as one wrong result may affect other results.
• Remember to save often!
• When you are ready to submit, save, close and upload the correct completed Excel File to iLearn (Excel Submission). You do not need to rename the file as iLearn will automatically attach your student number but please ensure that it is an Excel file you submit, (Numbers files will not be accepted), that it is bigger than 1KB (means you’ve submitted wrong file) and that there are no “non-English” characters in the file name as these files cannot be opened in an English version of Excel.