solution
Bata makes shoes at its factories in Penang, Melaka and Kuantan. The shoes are shipped weekly from its factories to its main customers in Singapore, Johor Baru, Kuala Lumpur and Ipoh. The maximum capacity of each factory are 12,000 pairs per month. For the Hari Raya season, Bata has received orders of 6,000 pairs, 8,000 pairs, 10,000 pairs and 12,000 pairs of shoes from Singapore, Johor Baru, Kuala Lumpur and Ipoh respectively. The transport costs in RM for a pair of shoes is given in table 3 below: Table 3: Transport Cost To From Singapore r Johor Baru Kuala Lumpur Ipoh Penang 3.50 2.80 2.50 2.20 Melaka 3.00 1.80 2.20 2.90 Kuantan 4.50 4.00 3.00 3.50 (a) Summarize the above data in the form of a transportation table. (1 mark) (b) Develop the network model of the distribution system. (2 marks) (c) Formulate the LP model. (use the Xij notation to define your variables) (5 marks) (d) Develop the excel model for this problem using the excel sheet provided. Show the important excel formulae in your model. Copy-paste your model in your answer sheet. (5 marks) (e) Fill up table 4 below shows clearly the quantities transported from each factory to each distribution center and the minimum total transportation costs. Table 4 To From Singapore Johor Baru Kuala Lumpur Ipoh Penang Melaka Kuantan Total Transportation costs = (2 marks) (f) Due to the pandemic and MCO 3.0, demand for shoes has dropped after the Hari Raya. The demand is forecasted to be 4,000 pairs, 7,000 pairs, 8,000 pairs and 5,000 pairs of shoes from Singapore, Johor Baru, Kuala Lumpur and Ipoh respectively. Due to this low demand, management is considering temporarily shutting down either the Kuantan or Melaka factory. Advise the management which factory to shut down clearly showing the results of your analysis. (5 marks)
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

