Question 1 Execute Malaysia Sdn Bhd operates a modern fleet, and offers a wide range of sophisticated business aircraft strategically located at their operating bases worldwide. Using the financial information provided below, answer the questions that follow. Fixed costs per year: Aircraft leasing & maintenance: RM1,500,000 Staff wages & salaries: RM750,000 Marketing: RM360,000 Aerodrome costs: RM850,000 Expected demand revenue and costs per aircraft flight: Average price per flight RM20,000 Variable cost per flight RM2,100 Using the information above: a. Develop a model of total cost for ExecuJet in the first year. (1 mark) b. Develop a model for total profit if X is the expected number of flights per month. (1 mark) c. They have forecasted the demand to be 38 flights per month. What would be the profit earned if the forecast is accurate? (1 mark) d. What is the breakeven point? (2 marks) e. Construct the problem using the Excel model. (2 marks) Question 2 Scientists in Malaysia would like to establish the regression relationship between Covid-19 cases and the corresponding fatality rate due to the disease. They have collected the following data: Month Covid-19 cases, X (tested positive) Fatality cases, Y Jan-20 8 0 17 0 2741 3236 1817 43 59 13 6 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 820 337 364 4 2 1884 9 20324 113 34149 111 111 47373 81539 168 a. Develop the simple linear regression formula for the situation above. Round up final answers to 4 decimal points. (4 marks) b. Estimate the number of fatality cases if the Covid-19 cases are estimated to hit 150,000 in March 2021. (1 mark) c. What is the number of fatality cases if the Covid-19 cases were 100? (1 mark) d. From answers in b and c, how well does the regression equation fit the data? (1 mark) Question 3 QYT Manufacturing produces Fibre Optic (FO) and Radio Frequency (RF) cable assemblies for applications in Telecommunication Industry. Each cable assembly goes through three (3) common manufacturing processes: Each FO cable assembly requires 12 minutes in cutting, 15 minutes in terminating and 30 minutes in testing. Each RF cable assembly requires 40 minutes in cutting, 20 minutes in terminating and 60 minutes in testing. In the coming shift, QYT has 52 minutes of cutting capacity available, 40 minutes of terminating capacity, and 90 minutes of testing capacity. Assume that all FO cable assemblies produced can be sold for a profit of RM20 and all RF cable assemblies can be sold for a profit of RM50. a. Formulate an LP model for this problem. (2 marks) b. Sketch the feasible region for this problem in excel. (3 marks) c. Determine the optimal solution to this problem using corner points. (3 marks) (Total: 8 marks) Question 4 Below are the actual weekly booking from the day new Perodua Myvi was launched: Period Number of units Week 1 Week 2 Week 3 Week 4 Week 5 5,000 5,050 4,800 4,750 5,650 (a) What is the forecast for Week 6 using a moving average model with an average period (AP) = 3? (round your answer to the nearest whole number) (2 marks) (b) Using Nave approach, what will be the forecast for Week 6? (2 marks) (c) What is the forecast for Week 6 using a weighted moving average model with weights 0.5 (for newest), 0.3 and 0.2 (for oldest)? (2 marks) (d) Using exponential smoothed forecasting approach and an alpha value of 0.2, what is the exponential smoothed forecast for Week 6 whereby the forecast and actual data for Week 2 are the same. marks)
