ACCT1002: Business Simulation instruction document
As you will be completing this exercise as part of an assessment, please note that you will be awarded marks at three distinct milestones:
1. This Simulation is used as an assessment, and full mark will be awarded for playing the simulation (i.e. making all decisions, without leaving any decisions incomplete).
Your profit/loss will have no impact on your marks.
2. Additional marks will be awarded for the correct calculations of all ratios (for both “Ratio Analysis” tabs). Please note that there is a total of 30 ratios that you will need to complete (15 from each “Ration Analysis” tabs). Please ensure to calculate all, using the formula provided next to each ratio.
3. The final component of this assessment (once you have played the simulation game, and calculated all ratios) will be to write a report to compare the movement of each ratio. You will also be required to write a short paragraph analysing the movement of each ratio from 2019 to 2020 and providing a potential explanation. Please use template provided on Blackboard under “Assessment > Assessment 3 > Business Simulation Spreadsheet and Template”. When doing so, please structure your answer as such:
i.Profitability Ratios – Net Profit Margin
As seen from our ratio analysis, the 2019 net profit margin was 0.5 (222,222/444,444) and the 2020 net profit margin was calculated as 0.38 (150,000/400,000). This demonstrates a drop of 24%. This movement can be explained by a decline in both the Net Profit (from $222,222 in 2019 to $150,000 in 2020) and decline in Net Sales (from $444,444 in 2019 to $400,000 in 2020). However, the reduction in Net Profit was proportionately higher than the reduction in Net Sales. This decline can be explained by the reduction in sales volume and selling price for pizzas (as a result of offering combo deals) due to COVID 19.
{Numbers used in this example are assumed figures). The % movement is calculated as (2020figure-2019figure)/2019figure (i.e. [(0.38 — 0.5)/0.5}.
Once you have completed all three milestones described above, you will be required to upload both the excel spreadsheet simulation and your word document report as follows:
a) Business Simulation Excel Spreadsheet (20%):
This is where you will be able to find the Business Simulation Spreadsheet for you to play the simulation game: “Assessment > Assessment 3 - Business Simulation and Report > Business Simulation Spreadsheet and Report Template”; as below:
Once you have completed the simulation game and answered all the ratio calculations, please label the file as “studentno.lastname.campus.xlsx” (i.e. “12345678.Smith.Bentley.xlsx”) and upload to Blackboard under “Assessment > Assessment 3 > Business Simulation and Report > Business Simulation Excel Submission” ; as illustrated below:
i. Click on the “Assessment” tab of Blackboard as below:
ii. Click on “Assessment 3 – Business Simulation and Report as below:
iii. Scroll all the way to the bottom, until you see “Business Simulation Excel Submission” (note the word Excel); as below:
b) Word document report (20%):
You will be able to download the template as shown below:
Once you have completed the report using the above mentioned template, (ensuring that you follow the structure as provided in the example in the unit outline above) in word version, please label the file as “studentno.lastname.campus.doc” (i.e. “12345678.Smith.Bentley.docx”) and upload to Turnitin as instructed below:
i. Click on the “Assessment” tab of Blackboard as below:
ii. Click on “Assessment 3 — Business Simulation and Report as below:
iii. Scroll all the way to the bottom, until you see “Business Simulation Report Submission” (note the word Report); as below:
iv. Click on “view / complete
v. Choose your name from the list “under Author” and upload your word document.
More instructions (including a marking guide) will be provided on Blackboard.
Welcome to a short instruction document on the business simulation excel file. This file will briefly explain what you will see in the simulation and give you a short set of instructions on things you may be unsure of.
PLEASE NOTE: THERE ARE A LOT OF TABS IN THIS SPREADSHEET. TO
NAVIGATE TO THE NEXT SET OF TABS, THENAGIVATION BUTTONS ARE ON THE BOTTOM LEFT
The first two tabs are for your Student Details and some background information. Please fill these in fully with all the requested details. These will be kept confidential and will not be shared with 3rd parties