| A | B | C | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | LAUNCH YOUR COAT BRAND > December Learning Challenge | ||||||||||||
2 | |||||||||||||
3 | PART A: HOW TO USE THIS SPREADSHEET | ||||||||||||
4 | |||||||||||||
5 | #1 | When a box is yellow, that means you will need to add something. Either choose from the drop-down menu or type in your answer. | |||||||||||
6 | |||||||||||||
7 | #2 | When a box is blue, it is showing you the RESULT of your decisions. When an blue box says ERROR or #VALUE, please double-check that all the yellow boxes are filled in. Don't type anything in the blue boxes. | |||||||||||
8 | |||||||||||||
9 | #3 | When a box is green, it is giving you helpful tips or instructions. Don't type anything in the green boxes. | |||||||||||
10 | |||||||||||||
11 | PART B: FILL IN YOUR INFO | ||||||||||||
12 | |||||||||||||
13 | Your Name: | < Type in your name! | |||||||||||
14 | Your Email: | < Type in your email address! | |||||||||||
15 | Your Grade: | < Click the arrow to choose from the drop-down menu! | |||||||||||
16 | Your Class: | < Type in your teacher's name! | |||||||||||
17 | |||||||||||||
18 | What will you name your new coat brand? | ||||||||||||
19 | < Create a name and type it here! | ||||||||||||
20 | |||||||||||||
21 | PART C: YOUR DECISIONS | ||||||||||||
22 | |||||||||||||
23 | Decision #1 - Material Sourcing | ||||||||||||
24 | First, you must decide how you want to source your materials to create the coats. You have a choice between going a sustainable or profit maximizing route. To maximize profit, you can choose to minimize cost by selecting unsustainable clothing dyes which only cost $2 million. However, they may cause harm to the environment. To protect our planet, you can choose renewable and recyclable materials that cost $4 million but makes your brand much more sustainable. With each of these considerations in mind, what will you choose? | ||||||||||||
25 | < Use the drop-down menu to make your decision! | [INSERT CHOICE HERE] | |||||||||||
26 | |||||||||||||
27 | Decision #2 - Coat Pricing | ||||||||||||
28 | Next, decide what price you will charge for your product. The minimum price you can charge is $50 and the maximum is $150. While charging a higher price will help you gain more money for each coat you sell, not all customers will be willing to pay a high price. Choose carefully! | ||||||||||||
29 | < Use the drop-down menu to make your decision! | [INSERT CHOICE HERE] | |||||||||||
30 | |||||||||||||
31 | Decision #3 - Advertising | ||||||||||||
32 | Now decide how much money you want to spend on advertising. As we learned in the Marketing & Media workshop, advertising will help potential customers to learn about your product, and will help convince them to buy it. You may choose to not advertise, or spend a low, medium, or high amount of money on advertising. | ||||||||||||
33 | < Use the drop-down menu to make your decision! | [INSERT CHOICE HERE] | |||||||||||
34 | |||||||||||||
35 | Decision #4 - Website | ||||||||||||
36 | You must also decide whether or not you want to launch a website to sell your Coats online. If you choose not to launch a website, you can still sell your Coats in physical stores, like SportChek. However, launching a website will help you reach more customers. It will cost you $1000. What will you decide? | ||||||||||||
37 | < Use the drop-down menu to make your decision! | [INSERT CHOICE HERE] | |||||||||||
38 | |||||||||||||
39 | Decision #5 - Employees | ||||||||||||
40 | Finally, managing a business by yourself can be challenging! You have to decide whether you should hire employees. Each additional employee you hire will cost $5000 per year. You can choose to hire up to 5 employees maximum. The more staff you hire, the more customers will be satisfied with your service and potententially purchase more coats! However, their purchases are not guaranteed and hiring employees can cost a lot of money. Which option will you choose? | ||||||||||||
41 | < Use the drop-down menu to make your decision! | [INSERT CHOICE HERE] | |||||||||||
42 | |||||||||||||
43 | PART E: BIG THINK QUESTIONS | ||||||||||||
44 | |||||||||||||
45 | Why did you select and a price of ? How do you think these decisions impact customers' desire to buy your coats? Write a short paragraph to explain your thinking (4-5 sentences) in the box below: | ||||||||||||
46 | |||||||||||||
47 | |||||||||||||
48 | For your third decision, you selected . Recall our November workshop on Marketing and Media, what sort of marketing tactics would you choose to help promote your business? (You may choose to write in bullet points to explain your answer) | ||||||||||||
49 | |||||||||||||
50 | |||||||||||||
51 | Why do you think it is important to budget your money in your business and how will the revenue you make impact your personal finances? (4-5 sentences) | ||||||||||||
52 | |||||||||||||
53 | |||||||||||||
54 | What do you think is the opportunity cost of each decision you made? Did considering the opportunity cost make you (want to) change any of your decisions? (4-5 sentences) | ||||||||||||
55 | |||||||||||||
56 | |||||||||||||
57 | Move on to the next page to continue (Click "Results and Questions") -> | ||||||||||||