Solve the media selection model with the restriction that the number of ads placed must be integer. Compare your solution with the linear optimization solution.

Reddy & Rao (R& R) is a small company in India that makes handmade artistic chairs for commercial businesses. The company makes four models. The time required making each of the models and cost per chair is given below.

R& R employs four people. Each of them works 8 hour shifts; 5 days a week (assume 4 weeks/ month). The demand for the next 3 months is estimated to be:

R& R keeps at most two of each model in inventory each month but wants to have at least one of Model D in inventory at all times. The current inventory of each model is 2. The cost to hold these finished chairs is 10% of the production cost. Develop and solve an optimization model to determine the optimal number of chairs to produce each month and the monthly inventories to minimize total cost and meet the expected demand.

Transcribed Image Text:

Model A Model B Model C Model D Cost per Unit $900.00 $650.00 $500.00 $750.00 Hours Required per unit 40 22 12 34