1

ACCT1002: Business Simulation and Report (40%)

No. Details Allocated

Mark

Awarded

Mark

1. Business Simulation (5%)

Completion of the simulation game (i.e., making all

decisions, without leaving any decisions incomplete).

Profit/loss will have no impact on marks.

• Your spreadsheet must to be completed and submitted

in Microsoft Excel (.xls or .xlsx format only).

Submitting your spreadsheet in any other format

(such as pdf or screenshot) will result in a mark of

zero (0) for both the Business Simulation (5%) and

Ratio Calculation (15%) as we will not be able to

mark your submission;

• Your submission must be made on Blackboard under

“Business Simulation Excel Submission” folder which

you will find on Blackboard under “Assessment 3 –

Business Simulation and report” (scroll all the way to

the bottom to see the submission link).

5

2. Ratio Calculation (15%)

• Correct calculations of all ratios from both tabs of the

business simulation spreadsheet (i.e., 2019 Ratio

Analysis and 2020 Ratio Analysis)

• Please also show your final answer (Do not show

workings)

• Please use a calculator to calculate your ratios (do

not type in excel formula as will show as working

as will be marked incorrect)

• Ratios are to be rounded to 4 decimal places

• Please use the formula provided next to each ratio in the

spreadsheet

• Each ratio calculation carries 0.5 marks (30 ratios in total

to calculate)

15

3. Report (20%) – Please use template provided on

Blackboard under “Assessment > Assessment 3 >

Business Simulation Spreadsheet and Template”.

Your submission must be made in Microsoft word and

uploaded to Turnitin upload to Turnitin using the “Business

Simulation Report Submission” folder which you will find on

2

Blackboard under “Assessment 3 – Business Simulation and

report” (scroll all the way to the bottom to see the submission

link).

Introduction:

• Please provide a brief introduction outlining the purpose

of this report. Your introduction must contain:

o A brief overview of your company;

o Strategies implemented;

o Introduce the purpose of this report;

o Summarize key performance figure and trend

from the analysis.

1

Body:

• Write a report to compare the movement of each ratio;

• You will be required to write a short paragraph analyzing

the ratio from 2019 to 2020;

• You will also need to provide potential (logical and

feasible) explanations to explain the movement;

• Please see exemplar below:

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 (2020 figure-2019 figure)/2019 figure

(i.e. [(0.38 – 0.5)/0.5}.

Please note that the above is a very brief example only – Do Not

Copy and Paste from the above (your analysis needs to have

significantly more detail in explaining the movements. When

doing so, you may consider the following:

• Describe the overall trend and evaluate (positive or

negative change) – include the figures generated from

the simulation and percentage that you calculated;

• Describe the changes in each of the variables used to

15

3

calculate the respective ratio (i.e., the numerator and

denominator);

• Comment of the relative changes in the numerator and

denominator (provide percentage change, which change

was more significant, which change had the highest

impact on the ratio etc);

• Provide qualitative comments to explain the movements

(both in nominator and denominator and overall ratio) –

Simply stating “COVID-19 is insufficient; your

explanations need to relate to your decision(s) made.

Conclusion:

In your conclusion, please provide the following (please

remember that this part is worth the most marks; therefore, this

part needs to be quite significant in quantity as compared to other

parts):

• The overall performance of your company from the

simulation (i.e., profit or loss). Then, please break your

analysis further into the three ratio categories

(profitability, liquidity, and financial stability). Please

state the profit / loss amount along with other key figures

that you deem important;

• Possible explanation explaining the movements in your

profit / loss and other key ratios;

• Possible recommendations

• If you had a loss, what do you think is the major

decision that caused the loss?

• What could you have done to result to a profit

instead?

• If you had a profit, what major decisions made

caused the profit?

• What could you have done to improve the profit?

• What is the future direction of your business?

3

Grammar and Structure of the Report / Rounding Marks 1

Additional Comments:

Once you have completed all three milestones described above, you will be required to upload both your

completed Business Simulation spreadsheet and word document report as follows (Please refer to the

video posted on Blackboard under “Assessment > Assessment 3 – Business Simulation and Report >

“How to submit your Business Simulation and Report” for a walk-through on how to submit your report

and spreadsheet):

4

a) Your completed Simulation (the full spreadsheet) – please label the file as

“studentno.lastname.campus.xlsx” (i.e., “12345678.Smith.Bentley.xlsx”) and upload to

“Business Simulation Excel Submission” folder which you will find on Blackboard under

“Assessment 3 – Business Simulation and report; and

b) Your report (ensuring that you follow the structure as outlined in section 3 above) in word

version – please label the file as “studentno.lastname.campus.doc” (i.e.,

“12345678.Smith.Bentley.docx”) and upload to Turnitin using the “Business Simulation Report

Submission” folder which you will find on Blackboard under “Assessment 3 – Business

Simulation and report.

STUDENT GRADE – TOTAL OUT OF 40 40

Comments

5