1. The construction of a new hockey arena is currently in the development planning stage. The National Hockey League is not certain of the number of luxury seating boxes planned for the upper section of the arena, as well as their profitability. Typically, large companies and high net-worth people may buy a seating box in the upper section of the arena for $225,000. The fixed costs of construction for the upper section seating box area is expected to be $3,750,000, with a variable cost of $120,000 for each box constructed.
2.  
3. Calculate the breakeven point for the number of upper section seating boxes in proposed arena? What is the contribution margin per upper section seating box constructed? (2 marks)
4.  
5. Planning stage schematics of the arena show that space is available for the construction of up to 30 upper section seating boxes. The marketing department for the project indicates that there are interested buyers and that all 30 could be sold if constructed. Do you recommend that these upper section seating boxes are constructed? What profit/loss is expected from building these boxes? (2 marks)
6.  
7. How will the break-even point change if the fixed cost decreases by 20%, variable cost increase by 10% and selling price decreases by 8%? (3 marks)
8.  
9. A bike tire manufacturing company is testing the wear of two models of tires: Super Slick tires and Big Bite tires. From testing trials, the company has collected the following information which measures the distance in meters that a bicycle tire can be used before showing its first signs of wear on it, taken from two samples of the two tire models from a the company. The company wants to use this data to test the research (alternative) hypothesis that the mean distance for Super Slick tires is lower than that of Big Bite tires. Please show all your work and conclude on whether the chain can conclude upon the research hypothesis. (4 marks)
10.  

Super Slick tire  (results in meters)	Big Bite tire  (results in meters)
249	277
365	302
179	259
297	253
186	224
110	270
190	279
278	316
223	275
222	260
240

1.  
2.  
3. The data given below shows the number of sunflower heads collected in tens collected in different areas of a sunflower field by sunflower pickers, who are all trained to pick sunflowers professionally and at the same rate. One of the sunflower picker has asked the manager of the sunflower picking operation to change their area of the field as they think it is unfair to them staying in an area that has a low number of sunflowers which are suitable for picking. Does the data below provide any evidence for the difference of the averages of number of sunflower heads collected amongst the three areas of the beach?  Test at 0.05 level of significance. (2 marks) Also, test at 0.10 level of significance. Does your answer change when testing at a 0.10 level of significance? (2 marks) Are there any other factors that should be considered when assessing whether there should be a change in the areas for the sunflower pickers? (1 mark)

Field Area	Field Area  1	Field Area  2	Field Area  3
# collected day 1	10	26	31
# collected day 2	17	18	44
# collected day 3	25	43	33
# collected day 4	18	54	16
# collected day 5	33	56	28
# collected day 6	13	19	59

1.  
2. Consider the following time series data.
3.  

Week	1	2	3	4	5	6	7	8	9	10
Value	139	148	126	150	139	135	150	137	147	152

1.  
2. Using Excel, construct a time series plot. What type of pattern exists in the data? (2 marks)
3.  
4. Develop a two-week moving average for this time series. Compute MSE and a forecast for week 11. (3 marks)
5.  
6. Use a smoothing factor of 0.35 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 11. (3 marks)
7.  
8. Compare the two-week moving average forecast with the exponential smoothing forecast using smoothing factor of 0.35. Which method appears to provide the better forecast based on MSE? (2 marks)
9.  
10.  
11. Model and solve the following scenarios using "solver" tool in excel (3 marks for modeling; 3 marks for solving)
12. Note that you must submit the excel document with your solver output to get credit for this question
13.  
14. Green Giant Skate Boards produces four models of skate boards. Skate board A requires 32 min of work in the woodworking department and 27 min of work in the painting and finishing department. Skate board B requires 28 min work in the woodworking department and 23 min of work in the painting and finishing department. Model C requires 25 min of work in the woodworking department and 30 min of work in the painting and finishing department. At most, 30 labour-hours are available in the woodworking department and 25 labor-hours are available in the painting and finishing department, each day. As there is a special kind of paint and process in creating skate board B, only 20 boards of skate board B can be made per day. Also, to maintain a stronger brand presence, Green Giant Skate Boards maintains that at least 5 of skate board A, at least 5 of skate board B, and at least 7 of skate board C must be made per day. 
15.  
16. It is anticipated that Green Giant Skate Boards will gain a profit of $25 from making and selling Skate Board A, $24 profit from making and selling skate board B, and $28 on skate board C. How many skate boards of each model should be produced each day to maximize the profit? 
17.  
18. Model and solve the following scenario using "solver" tool in excel (3 marks for modeling; 3 marks question for solving)
19.  
20. Samantha has saved up $110,000 to invest in corporate stocks (financial securities). Per discussion with her financial advisor, she has narrowed her choices to three types of securities: growth stocks that she assumes will yield a 10% return (dividends and capital appreciation) within a year, speculative stocks that she assumes will yield a 15% return (in the form of appreciation in stock price) within a year and ETFs which average at 7% return per year. Determine how much she should invest in each group of stocks to maximize the return on her investments within a year if she has decided to invest at least three times as much in growth stocks as in speculative stocks and at least two and a half times as much in ETFs as in growth stocks. 
21.  
22. What would her annual return be in percent and dollar amount?