Question: Need a solution to this problem with INTEGER PROGRAMMING model. Need an integer programming formulation as well as a solution in excel solver. A paper

Need a solution to this problem with INTEGER PROGRAMMING model. Need an integer programming formulation as well as a solution in excel solver.
A paper mill produces jumbo reels of paper which are 150cm. wide, and which then need to be cut into reels of standard smaller widths to meet the market demand. The demand for the upcoming season is as follows: The mill cuts the jumbo reels to meet the demand with minimal waste. Waste is defined as any leftover portion of the cut jumbo reels that cannot be used to meet the demand. Waste is incurred by either trim loss or surplus. Trim loss is incurred, for example, if a jumbo reel is cut into three 45cm. reels. The left-over 15cm. reel needs to be disposed as there is no demand for this size. Surplus is incurred, for example, if 100 jumbo reels are each cut into two 45cm. and one 60cm. reels. The demand for 60 cm. reels will be fully satisfied, but there will be a 50 reel (2100150) surplus of 45cm. reels. The combinations of various standard widths and trim waste that can be obtained from a jumbo reel are called patterns. The table below describes pattern #1. Formulate the integer programming model that finds the number of jumbo reels to be cut according to each pattern, to meet demand with minimal wasteStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
