Credo Carpet Company produces three carpet designs: Coracle, Alpine and Fantasia, which are sold OR 30,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
Here is the linear programming model and answers to the questions 1 Linear programming model Maximiz... View the full answer
Related Book For
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale
Posted Date:
Students also viewed these general management questions
-
Block Corporation makes three products that use the current constraint, which is a particular type of machine. Data concerning those products appear below: Required: a. Rank the products in order of...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
17. [1.1/2 Points] DETAILS PREVIOUS ANSWERS MY NOTES ASK YOUR TEACHER Write the composite function in the form f(g(x)). [Identify the inner function u-g(x) and the outer function y=f(u).) (Use...
-
Define, describe and identify the elements of (a) good Data Backup Planning, (b) good Disaster Recovery Planning, and (c) good Business Continuity Planning. Be sure to identify and describe any...
-
Why has the effective capital gains tax rate tended to be substantially lower than the dividend tax rate in the United States? Given that this disparity exists, why do so many firms pay dividends?
-
Search the Internet including social media to obtain information on flying and passengers' airline preferences. Develop three double-barreled questions related to flying and passengers' airline...
-
Napa Tours Co. is a travel agency. The nine transactions recorded by Napa Tours during April 2018, its first month of operations, are indicated in the following T accounts: Indicate for each debit...
-
Six-sevenths of Jesse Black's inventory was destroyed by fire. He sold the remaining part, which was slightly damaged, for nine-elevenths of its value and received $2400. (a) What was the value of...
-
Using the data contained in Figure 2.3, what 52-week rate of return, excluding dividend yields, would an investor have received by purchasing the following portfolios of stocks? a. The stocks in the...
-
A project that costs $2,400 to install will provide annual cash flows of $590 for the next 5 years. The firm accepts projects with payback periods of less than 5 years. a. What is this project's...
-
Why should mines be air-conditioned?
-
Describe the three major kinds of plate boundaries.
-
What is the water that resides in the saturation zone called?
-
Why do some high-quality drills have diamond tips?
-
How does the atomic structure of glass differ from the atomic structure of the mineral calcite?
-
Fenimore Company purchased a copyright from another company early in 2020 for $50,000. Fenimore had not amortized the copyright because its value had not been diminished. The copyright has a useful...
-
Establish identity. cos( + k) = (-1)k cos , k any integer
-
The Foxridge Investment Group buys and sells rental income properties in southwest Virginia. Bill Hunter, president of Foxridge, has asked for your assistance in analyzing a small apartment building...
-
The O-rings in the booster rockets on the space shuttle are designed to expand when heated to seal different chambers of the rocket so that solid rocket fuel is not ignited prematurely. According to...
-
The Chickn-Pickn fast-food chain is considering how to expand its operations. Three types of retail outlets are possible: a lunch counter operation designed for office buildings in downtown areas, an...
-
Input information from the SBA Personal Financial Statements given to Sharptop Bank into a spreadsheet. a. Separate personal items (e.g., residence) from business items (e.g., inventory). b....
-
Compare your recalculated ending inventory to that given to Sharptop Bank and to Southern Appalachian Insurance. Is either estimated ending inventory materially different from that reported on the...
-
What accuracy certifications on the tax return and bank financial statement address providing materially inaccurate information?
Study smarter with the SolutionInn App