solution

1. Martha Manufacturing a product through three separate production lines “A”, “B” and “C”. Costs for producing a product through each line as well as maximum outputs of each line and fixed cost associated with setting up the line is shown below:

Production line	Cost per unit	Maximum production	Fixed cost
A	1.5	28	150
B	1.0	32	170
C	1.25	25	160

The company has received an order of 60 units to be produced.

Model the problem for optimum number of products to be made from each production line.

1. Formulate a linear programming model for maximizing total profit contribution. (7 marks)

1. Solve the linear program formulated in part (a). How much of each product should be produced, and what is the projected total profit contribution? (7 marks)

**Note that you need to submit your excel document to get credit for this part. please attach the formula for each section and please do it asap