10 Sep Assignment 1: Unit 1 (8%) Assignment 1 will require you to demonstrate an

Assignment 1: Unit 1 (8%)

Assignment 1 will require you to demonstrate an understanding of the concepts learned in Unit 1 as well as demonstrate skills in using software for business functions. You will submit this assignment as a PowerPoint presentation by giving your explanations, preferably on the notes pages of PowerPoints, or by using PowerPoint voice-overs (recording over PowerPoint or inserting audio file) or recording your assignment presentation using the Kaltura Express tool ( Kaltura Video Upload Instructions ). Please note that if you decide not to attempt certain questions, you should still create and leave blank slides for those questions and do your next question on the appropriate slide number suggested.

Please DO NOT attach videos directly in the assignment submission point. Use the Embed Kaltura Media button in the text editor as shown here:  Kaltura Video Upload Instructions

Note

If you do not already have access to Microsoft Office products, you can obtain them through  IT Services for Students .

Instructions

Start by opening PowerPoint on your device and creating a new presentation. Once you have created your presentation, go to the File Menu and select, “Save as”; choose the storage location where you want to save it (your hard drive/memory stick/folder etc.). Type the file name as “MNGT1711-your last name-your student id-Assignment 1” and save. Double click on the saved file and use it to develop Assignment 1. 

Question 1 (slide 1): 15 marks

Consider the following scenario and develop a MS Excel model of the profit for this business. Tony opened a pizza restaurant in a food court. Last month he sold 3000 pizzas at an average price of $10 each. He bought his pizza dough shells from a local bakery at $2 each and spent $2000 on various kind of toppings and other raw materials last month. He has two employees and each one of them worked 160 hours last month at a rate of $10 per hour. In addition, he paid $800 rent to the mall and $200 for the energy and utilities costs. How much profit, before taxes, did Tony earned last month? Build the model for Tony’s monthly profit on an Excel spreadsheet. You must  not manually input the answer into Excel; use the formulae in Excel to calculate profit. Copy your completed Excel model and paste it to slide 1 and title the slide as Question 1. Don’t forget to save your assignment presentation after each question.  You are required to submit your Excel file when submitting the Assignment 1.

Question 2 (slide 2 to slide 6): 15 marks

You are restricted to use five slides (2 to 6) for this question. Title slide 2 as “Question 2”.

Canada’s version of capitalism allows for freedom of choice, right to fair competition, right to own property, and the right to keep after-tax profits. Prepare a PowerPoint presentation on your understanding of the Canadian economy in terms of the shades of free market economy features it exhibits, and also on the Government controls and socialism features it has. You are free to use any information and data from any source, but you must cite the sources in APA format. The discussion can be written on notes pages or use voice over.

Question 3 (slide 7 to slide 9): 20 marks

You are restricted to using three slides (7 to 9) for this question, with slide 7 titled as “Question 3”. Prepare an Excel table with the first column representing the year. Track down Canada’s annual GDP, inflation rate, and unemployment rate over the last 20 years and put them in columns 2–4 of Excel. You can use any resources to gather this information, but you must cite the sources in APA format . Copy and paste your table onto PowerPoint slide 7. On slides 8–9, you will discuss the important insights from your table. For example, you can discuss important trends you noticed, health of the Canadian economy over certain years, effect of your variables (GDP, unemployment rate, inflation rate) on Canadian businesses, comparison with our neighbour, the United States, and how our economies are linked. On the notes page, please provide the link of the website(s) from where you gathered this data. The discussion can be written on notes pages or use voice over.

Question 4 (slide 10 to slide 15): 15 marks

Title slide 10 as “Question 4” and prepare a spectrum on the PowerPoint slide with one end titled “Capitalism” and the other end as “Communism”. You can use the “insert>>shapes/smart-art” menu to build this spectrum or import it as a picture. Consider these countries: Canada, USA, India, China, and Great Britain. Put each country on the spectrum based on their economic system. Make one PowerPoint slide per country (slides 10–15), and then explain your reasoning for each country’s placement on the spectrum.

Question 5 (slide 16 to slide 18): 20 marks

Title slide 16 as “Question 5”. Opening the Bank of Canada’s 2019  Monetary Policy Report  on the Canadian economy PDF:

· Go to Table 2 on page 8; edit>>take a snapshot of the table by selecting the appropriate area and paste the table on slide 16. Identify and explain the major contributing sectors to the Canadian GDP.

· Go to Table 3, page 9; edit>>take a snapshot of the table by selecting the appropriate area and paste the table on slide 17. Identify and explain the trends in CPI projections and real GDP.

· Go to Chart 9, page 11; edit>>take a snapshot of the chart by selecting the appropriate area and paste the chart on slide 18. Identify and explain which sectors of Canadian economy are experiencing an employment growth rate.

Note

After going through the relevant pages of the report, your explanations can be written in the notes pages, or provided through voice over.

Question 6 (slide 19): 15 marks

Based on your readings in this unit, prepare a list of five challenges faced by Aboriginal businesses. Place this list on slide 19. For each challenge, suggest one solution strategy on the notes page.

References (slide 20)

On this last slide, provide references for all resources used. The  APA Style PowerPoint Slide or Lecture Note References  page provides specific information on how to format your citations.