QUESTION 5 (20 marks) Study the case below and answer all questions that follow. You are an operations analyst at MPQ Limited, a manufacturer of a broad range of electric motorcycles. One of your main responsibilities is the development of an aggregate plan for the company. a. Specify the basic capacity or demand options that you would rely on to produce an effective aggregate plan for MPQ Limited. b. You have been tasked with the development of an aggregate plan for the year ended 31 December 2022. Accordingly, you have developed monthly forecasts for a range of motorcydes as presented in Table 5.1, below. Table 5.1: The demand forecast developed for the year ended 31 December 2022. c. Compute and tabulate the daily demand for each month in the table below (round off to the nearest whole number). (6 marks) d. Assuming that MPQ Limited had adopted a level strategy for the year ended 31 December 2022, compute the average daily demand for the year (round off to the nearest whole number). (3 marks) e. Prepare a graph showing the monthly forecasts and average daily forecast (in units per day) for MPQ Limited. (3 marks) QUESTION 5 (20 marks) Study the case below and answer all questions that follow. You are an operations analyst at MPQ Limited, a manufacturer of a broad range of electric motorcycles. One of your main responsibilities is the development of an aggregate plan for the company. a. Specify the basic capacity or demand options that you would rely on to produce an effective aggregate plan for MPQ Limited. b. You have been tasked with the development of an aggregate plan for the year ended 31 December 2022. Accordingly, you have developed monthly forecasts for a range of motorcydes as presented in Table 5.1, below. Table 5.1: The demand forecast developed for the year ended 31 December 2022. c. Compute and tabulate the daily demand for each month in the table below (round off to the nearest whole number). (6 marks) d. Assuming that MPQ Limited had adopted a level strategy for the year ended 31 December 2022, compute the average daily demand for the year (round off to the nearest whole number). (3 marks) e. Prepare a graph showing the monthly forecasts and average daily forecast (in units per day) for MPQ Limited