Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Credo Carpet Company produces three carpet designs: Coracle, Alpine and Fantasia, which are sold OR 30, OR 40 and OR 65 each, respectively. The

Credo Carpet Company produces three carpet designs: Coracle, Alpine and Fantasia, which are sold OR 30, OR 40 

Credo Carpet Company produces three carpet designs: Coracle, Alpine and Fantasia, which are sold OR 30, OR 40 and OR 65 each, respectively. The carpets are made from three different types of wool - plain, flecked, and dyed, supplied on 10 km drums at OR IXY, OR 40 and OR 10 per drum, respectively. XY refers to the first two digits of your student ID starting from the right. The Coracle requires 0.5 km of plain, 0.2 km of flecked, and 0.2 km of dyed wool. The Alpine requires 0.7 km of plain, 0.2 km of flecked, and 0.2 km of dyed wool. The Fantasia requires 0.2 km of plain, 0.5 km of flecked, and 1 km of dyed wool. There are currently 5 drums of plain wool, 2 drums of flecked, and 3 drums of dyed wool available. Besides the cost of the materials, the other production costs are estimated to OR 4, OR 7 and OR 10 per unit of Coracle, Alpine and Fantasia, respectively. 1. Formulate the linear programming model to help Credo Carpet Company develop a production plan that maximizes the overall profit. 2. Use Excel to solve the problem and provide the corresponding sensitivity report. 3. How many of each type of carpet should be produced and what profit will this generate? 4. Which constraints are binding? Explain. 5. Three additional drums of plain wool can be provided by the supplier at a cost of OR 50 per drum. Should Credo purchase this wool and, if so, how many drums should they purchase? Explain. 6. What is the range of optimality for the coefficient of Alpine? 7. In the optimal solution, one of the carpets is not produced. At what profit would Credo start producing this carpet? How can such a solution be implemented in practice? Explain. 8. If the price of wool increases with OR 20 per drum, will the optimum production plan change and what will be its effect on the optimal profit? Justify your answer. 9. Due to global supply difficulties, the suppliers of wool have suggested an adjustment plan for the supply of wool, where the flecked supply is decreased to 4 km and the dyed is increased by 1 km. How would such a change affect Credo's overall profit? Justify your answer.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Here is the linear programming model and answers to the questions 1 Linear programming model Maximiz... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Spreadsheet Modeling And Decision Analysis A Practical Introduction To Management Science

Authors: Cliff T. Ragsdale

5th Edition

324656645, 324656637, 9780324656640, 978-0324656633

More Books

Students also viewed these General Management questions

Question

Under what conditions are two qualitative variables independent?

Answered: 1 week ago

Question

Establish identity. cos( + k) = (-1)k cos , k any integer

Answered: 1 week ago