Question: 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.

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.

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

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:

Model A Model B Model C Model D Cost per Unit $900.00

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.

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

Step by Step Solution

3.39 Rating (174 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Media Selection Model Radio TV Magazine How m... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

607-B-B-C-B-M (1005).xlsx

300 KBs Excel File

Students Have Also Explored These Related Business Communication Questions!