CellMall ,a cellphone company located in Vanderbijlpark, is planning to sell two new models of cellphones. They have acquired the Mokia-N12 at R 1500 each and they plan to sell them at R2999 each. The Sum5ang-599 can be acquired at R 3000 each and sold at a profit of R2000 each. Their total budget for purchasing is R 1500000 per month. Storage costs are estimated to be R10 each per month for Mokia-N12 and R 15 each per month for Sumsang-599. The storage budget is R25000 per month. Suppliers are capable of supplying Mokia-N12 in lot sizes of 150 units, with a maximum 10 lots per month. They can also supply Sumsang-599 in lot sizes of 200 units with a maximum of 8 lots per month. CellMall must order at least one lot per month. a) Formulate the LP problem (5) b) Use Ms Excel Solver to find the maximum profit that the company can make from the sale of their cellphones, taking into consideration all the constraints. (20) c) Use the ISO-profit line method to find the optimum solution d) Use the corner-point method to find the maximum profit. (10) Graphs for c) can be drawn by hand and either scanned or a picture taken. CellMall ,a cellphone company located in Vanderbijlpark, is planning to sell two new models of cellphones. They have acquired the Mokia-N12 at R 1500 each and they plan to sell them at R2999 each. The Sum5ang-599 can be acquired at R 3000 each and sold at a profit of R2000 each. Their total budget for purchasing is R 1500000 per month. Storage costs are estimated to be R10 each per month for Mokia-N12 and R 15 each per month for Sumsang-599. The storage budget is R25000 per month. Suppliers are capable of supplying Mokia-N12 in lot sizes of 150 units, with a maximum 10 lots per month. They can also supply Sumsang-599 in lot sizes of 200 units with a maximum of 8 lots per month. CellMall must order at least one lot per month. a) Formulate the LP problem (5) b) Use Ms Excel Solver to find the maximum profit that the company can make from the sale of their cellphones, taking into consideration all the constraints. (20) c) Use the ISO-profit line method to find the optimum solution d) Use the corner-point method to find the maximum profit. (10) Graphs for c) can be drawn by hand and either scanned or a picture taken