1 Assessment task 2 — Assignment Due date: Tuesday of Week 7 [4pm [AEST] 16 April 2013] ASSESSMENT Weighting: 30% 2 Objectives This assessment item relates to the course learning outcomes 2, 3, 4 and 7. Details The assignment is designed to help you to gain and/or improve your generic, analytical and information technology skills. There are two parts to this assignment. Part A is designed to enhance your skills in the planning, designing and using of spreadsheets and relates to budgets. Part B is designed to enhance your written communication and analytical skills and relates to various costing issues to consider in making decisions. Students must use spreadsheets such as excel in Microsoft Office to answer Part A. You will lose all 15 marks allocated to the use of spreadsheets if you choose not to use spreadsheets. As this is an advanced course, it is assumed that students enrolled in this course are familiar with the use of spreadsheets. If you are not familiar with using spreadsheets or some functions of a spreadsheet, we advise you to use the help facilities which are provided within most spreadsheet software. You will also find help on how to use spreadsheets on the internet and/or in textbooks in most libraries. In addition to these sources, students can also contact the Academic Learning Centre and the lecturer or tutor at the local campus. Distance Education students may contact the Course Coordinator for assistance. Students must design the spreadsheets so that you have one input sheet for entering all numeric values. You must also have various output sheets for the eleven required budgets. You must not enter any numeric values in the output sheets. The input sheet must be the only source of data entry and must be linked to all other output sheets. Thus, the output spreadsheets must only contain formulae for calculating the figures. In essence, ensure you design your spreadsheet in such a way that when you change a numeric value in an input cell in the…