Optimizing profit

[Duodu]

A company has decided to produce the product in standard shipping batches. To cope with the new product, an adjustment to production needs to be made on the lines that will make it. The company has given you the following information

	Product A	Product B	New Product
Profit (Objective)	£500	£750	£1,100
Batches to make	?	?	?

	Materials required per pallet type	Materials required per pallet type	Materials required per pallet type	Available	Units
Semi-skilled labor time	50	50	100	6000	Hours
Skilled labor time	5	15	10	800	Hours
Materials	500	400	300	31,000	Units

I want to use solver to

• Design an optimizer on excel and use solver to find out how many batches of each product to make to maximize profit
• model a reduction in skilled labor hours by 100 to 700

Thanks

 

[felixstraube]

I think there is information missing. How would you calculate profit?
How are the products produces? How many pallets per batch? Or how does this work?

 

[AhoyNC]

Maybe one of these links will help.

Using Solver to determine the optimal product mix - Microsoft Support