Apply basic costs and costing techniques to practical scenarios.
Learning Outcome 4: Create a budget and a cost volume profit analysis given practical scenarios.
Work in teams (groups) of 3 members (you must obtain your lecturer’s approval for a group of a different number). You may discuss the selection of teams with your lecturer, who may decide to allocate you into teams or he/she may decide to form teams using a random process.
You must notify your lecturer of your teams by the Friday of week 6 and be prepared to be allocated into teams if the lecturer so decides.
Any work which has been copied or shared between groups or teams will result in a “Fail” grade for all students concerned. So please make sure that the answer to this team assignment is your own work and not copied from any source.
Submission: The assignment will need to be submitted electronically through the student portal – use the link under “Assessments” to submit the information.(The portal will close at 11.59pm AEST – Students in Adelaide and Brisbane please note to adjust for the time difference)
Required: Using Excel, answer the questions below. Use one tab per question and also include any written response within Excel.
Note that marks are also allocated for professional presentation and the use of formulas within Excel