Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

solve the all problem FatCat Compary manufactures pool tables using four main components: a slate, a felt, four legs, and a cue holder. The marketing

solve the all problem
image text in transcribed
FatCat Compary manufactures pool tables using four main components: a slate, a felt, four legs, and a cue holder. The marketing department estimates that at least 5000 pool tables will be sold next month. Fatcat purchases the felt from an outside supplier, but the slate, legs and cue holder may either be manufactured by the company or purchased from an outside supplier. Manufacturing and purchose costs per unit are shown in the table below. Three departments are involved in the production of these components. The time (in minutes per unit) required to process each component in each department and the available monthly capacity (in hours) for the three departments are as follows. The management wants at least 25% of each component to be manufactured by FatCat. 1-) Formulate an LP model to minimize the cost of FatCat to satisfy the demand for pool tables. Clearly define all decision variables and constraints. 2-) Use OPL to solve your model. Attach the CPL file to your submission. a) How many ofeach component should be manufactured and how many should be purchosed? b) What is the to tal cost of the manufacturing and purchasing plan? c) How many hours of production time are used in each department? 3-) Answer the following questions. Explain in detail. (Suppose that your computers are down after solving Question 2 so that you cannot solve a new problem from scratch (2) a) How much should FatCat be willing to pay for an additional hour of time in the shaping department? b) Another manufacturer has offered to sell slates to FatCat for $42 each. Could FatCat improve its position by pursuing this opportunity? Why or why not

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_2

Step: 3

blur-text-image_3

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

Transactions On Large Scale Data And Knowledge Centered Systems Xxviii Special Issue On Database And Expert Systems Applications Lncs 9940

Authors: Abdelkader Hameurlain ,Josef Kung ,Roland Wagner ,Qimin Chen

1st Edition

3662534541, 978-3662534540

Students also viewed these Databases questions