Use Microsoft Excel to answer all the questions below. Please upload one single Excel solution file on Blackboard by the due date, with each question answered on separate sheet of the same Excel file.

Questions:

1. Identify possible data patterns in the historical data (inventory cases, 2016-2020). Draw the data plot using Excel. That will help you to see the possible data patterns. Does the historical data have a Seasonal pattern? Trend pattern? Horizontal pattern? Explain.

2. Based on the data patterns, apply all of the following possible forecasting models: linear trend forecast, trend and seasonal forecast with dummy variables, and moving average forecast with periods k=2 and k=4. Explain why these methods may or may not be used for forecasting in this case.

3. Utilize Excel to identify the best forecasting model among the four models discussed in question 2 based on MAE and MAPE. Make a table with forecast accuracy measures MAE and MAPE for each of the four forecasting models. Apply the best forecasting model to forecast inventory in all 4 quarters of 2021.

4. Answer the question from the case study: should DistCo. acquire more warehouse capacity in 2021? (Hint: will the forecasted number of cases in the 4th quarter of 2021 be close to or greater than 292,000-294,000 cases)

QUESTION 7 In a saturated solution of a salt in water, the rate of crystallization > the rate of dissolution a. the rate of dissolution > the rate of crystallization b. seed crystal addition may cause massive crystallization addition of more water causes massive crystallization d. the rate of crystallization = the rate of dissolution eD Question 6 1 pts A genetic mutation that contributes to a predisposition to develop a disorder would be considered a factor. O Proximal contributory factor O Reinforcing contributory factor O Distal contributory factor O Ultimate contributory factor D Question 7 1 pts factors decrease the probability that disorder will occur. O Resilience O Risk O Protective O Proximal D Question 8 1 pts True or false: Heritability is measured by the statistic h2. O True O FalseQuestion 5 (12 marks): You must answer both part (a) and part (b). Bec made a contract to purchase Jule's car. Bec paid a deposit of $1,000 with payment of the balance of the purchase price to take place on 11 May at 10.00 am. On 8 May, Bec lost her driver's licence due to accumulated loss of points. (a) Could Bec terminate the contract and recover the deposit, since she was not permitted to drive the car on 11 May? Why/Why not? (6 marks) (b) Since Bec could not drive for a while, she went on a 21-day holiday cruise. She paid for it in advance. A term of the contract provided that passengers would experience an enjoyable and relaxing holiday. Fifteen days into the cruise, the ship hit a rock and sank. Bec lost all her belongings and was extremely disappointed that the cruise turned out to be such a disaster. Advise Bec if she would succeed in claiming for damages. (6 marks): 26 01 30 Question 28 (1 point) Saved The Canada Pension Plan (CPP) and the Quebec Pension Plan (QPP) are: O A) mandatory plans. O B) optional, mandatory, and contributory plans. ( C) optional plans. OD) contributory plans. E) mandatory and contributory plans.You use this create table statement: create table ddl_un (id number(3) city varchar2(15), state char(2) , constraint location_UN unique(city, state) ); Next, you insert some data with these statements: Insert into ddl_un (id, city, state) values (1, 'Chicago', 'IL'); Insert into ddl_un (id, city, state) values (2, 'Pekin', 'IL'); Insert into ddl_un (id, city, state) values (3, null, 'NY'); Finally, you attempt to insert the following statements. Which will fail? O Insert into ddl_un (id, city, state) values (4, 'Pekin', 'IL'); O Insert into ddl_un (id, city, state) values (7, null, null); O Insert into ddl_un (id, city, state) values (5, 'Chicago', 'CA'); Insert into ddl_un (id, city, state) values (6, 'Pekin', 'IN'); O Insert into ddl_un (id, city, state) values (8, null, 'NY')