代做ACCT1002: Business Simulation instruction document代做留学生SQL语言

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