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. (8 marks) 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 motorcycles as presented in Table 5.1, below Table 5.1: The demand forecast developed for the year ended 31 December 2022. MONTH PRODUCTION DAYS DEMAND FORECAST Jan-2022 16 150 Feb-2022 16 150 Mar-2022 250 Apr-2022 250 May-2022 400 Jun-2022 500 Jul-2022 600 Aug-2022 750 Sep-2022 450 Oct-2022 250 Nov-2022 150 Dec-2022 150 Compute and tabulate the daily demand for each month in the table below (round off to the nearest whole number). (6 marks) MONTH PRODUCTION DEMAND DEMAND PER DAYS FORECAST DAY Jan-2022 16 150 Feb-2022 16 150 Mar-2022 23 250 Apr-2022 250 May-2022 400 Jun-2022 500 Jul-2022 600 Aug-2022 750 Sep-2022 Oct-2022 Nov-2022 Dec-2022 Total 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