Question: help with b c d GA Assignment-Linear Programming CellMall , a cellphone company located in Vanderbijlpark, is planning to sell two new model of cellphones.

help with b c d
GA Assignment-Linear Programming CellMall , a cellphone company located in Vanderbijlpark, is planning to sell two new model of cellphones. They have acquired the Mokia-N12 at R 1500 each and they plan to sell then at R2999 each. The SumSang-S99 can be acquired at R3000 each and sold at a profit of R2000 each. Their total budget for purchasing is R1500000 per month. Storage costs are estimated to be R10 each per month for Mokia-N12 and R 15 each per month for SumSang-S99. 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-S99 in lot sizes of 200 units with a maximur 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. Graphs for c) can be drawn by hand and either scanned or a picture takenStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
