solve by linear programming and cplex This project can be completed individually or in groups of 2
Fantastic news! We've Found the answer you've been seeking!
Question:
solve by linear programming and cplex
Transcribed Image Text:
This project can be completed individually or in groups of 2 students. You should solve your project using the IBM ILOG CPLEX Optimization Studio. Project Description You have recently been hired as an operations research analyst in a consulting firm. Congratulations! The company now assigned you to work for Toysco, which manufactures plastic toys. You are required to help Toysco develop an optimized work schedule for the plant over the next 12 months. Last year, under a similar demand and without any optimization tools, the company cleared around $2,000,000 in profits from their five products. To manufacture plastic toys, Toysco purchases recycled plastic for $70/ton and new plastic for $100/ton. Due to the quality of the plastic, only 80% of the recycled plastic can be used to produce the products. Furthermore, due to environmental regulations, at most 4 tons of new plastic material can be purchased at any month, and the availability of recycled plastic is at most 11 tons. Table 1 shows the price of each toy and the required plastic to produce the toys. Due to quality requirements, at least 20%, 10%, 25%, 60%, and 40% of Trucks, Mini slides, Toy tools, Stacking rings, and Ducks respectively, must be manufactured from new plastic. Also, due to manufacturing limitations, Toy tools and Ducks cannot be produced at the same month. Report Month 1 2 3 4 5 Each product held over in inventory from one month to the next month costs the company $0.5. If demand at each month is not met, then there is a penalty cost of $1/per item. In such a case, the item is placed on backorder and the order must be shipped to the customer at some future time. Demand of each product over the next 12 months is shown in Table 2. You must assume that you have nothing in inventory or items that are backordered, and that you must end at the end of the 12th month with the same condition. 67 Table 1 - Selling Price of Each Type of toy and required plastic Selling Price ($) Required plastic Toys 7 8 9 10 11 12 Truck Mini slide Toy tools Stacking rings Duck Truck Table 2-Demand of each type of toy over the next 12 months Beam Toy tools 3,000 1,000 700 1,400 2,000 2,000 1,000 1,700 2,000 3,000 1,000 700 $27 $45 $22 $15 $8 Mini slide 1,400 300 900 800 1,400 900 900 1,000 1,700 1,500 1,900 2,000 (lb) 2 10 1.5 1.5 0.5 2,700 2,400 3,100 1,600 3,600 3,700 2,000 3,100 3,300 3,000 2,000 3,100 Stacking rings 2,500 1,300 500 3,300 2,100 1,500 1,000 800 4,100 2,000 2,800 100 Duck 1,200 1,500 4,300 3,900 800 200 3,500 1,200 2,200 1,300 4,100 1,000 This project can be completed individually or in groups of 2 students. You should solve your project using the IBM ILOG CPLEX Optimization Studio. Project Description You have recently been hired as an operations research analyst in a consulting firm. Congratulations! The company now assigned you to work for Toysco, which manufactures plastic toys. You are required to help Toysco develop an optimized work schedule for the plant over the next 12 months. Last year, under a similar demand and without any optimization tools, the company cleared around $2,000,000 in profits from their five products. To manufacture plastic toys, Toysco purchases recycled plastic for $70/ton and new plastic for $100/ton. Due to the quality of the plastic, only 80% of the recycled plastic can be used to produce the products. Furthermore, due to environmental regulations, at most 4 tons of new plastic material can be purchased at any month, and the availability of recycled plastic is at most 11 tons. Table 1 shows the price of each toy and the required plastic to produce the toys. Due to quality requirements, at least 20%, 10%, 25%, 60%, and 40% of Trucks, Mini slides, Toy tools, Stacking rings, and Ducks respectively, must be manufactured from new plastic. Also, due to manufacturing limitations, Toy tools and Ducks cannot be produced at the same month. Report Month 1 2 3 4 5 Each product held over in inventory from one month to the next month costs the company $0.5. If demand at each month is not met, then there is a penalty cost of $1/per item. In such a case, the item is placed on backorder and the order must be shipped to the customer at some future time. Demand of each product over the next 12 months is shown in Table 2. You must assume that you have nothing in inventory or items that are backordered, and that you must end at the end of the 12th month with the same condition. 67 Table 1 - Selling Price of Each Type of toy and required plastic Selling Price ($) Required plastic Toys 7 8 9 10 11 12 Truck Mini slide Toy tools Stacking rings Duck Truck Table 2-Demand of each type of toy over the next 12 months Beam Toy tools 3,000 1,000 700 1,400 2,000 2,000 1,000 1,700 2,000 3,000 1,000 700 $27 $45 $22 $15 $8 Mini slide 1,400 300 900 800 1,400 900 900 1,000 1,700 1,500 1,900 2,000 (lb) 2 10 1.5 1.5 0.5 2,700 2,400 3,100 1,600 3,600 3,700 2,000 3,100 3,300 3,000 2,000 3,100 Stacking rings 2,500 1,300 500 3,300 2,100 1,500 1,000 800 4,100 2,000 2,800 100 Duck 1,200 1,500 4,300 3,900 800 200 3,500 1,200 2,200 1,300 4,100 1,000
Expert Answer:
Answer rating: 100% (QA)
Introduction Toysco a plastic toy manufacturer faces challenges in managing their work schedule for the plant With a variety of toys and plastic requirements they need an optimized work schedule to ma... View the full answer
Related Book For
Auditing a business risk appraoch
ISBN: 978-0324375589
6th Edition
Authors: larry e. rittenberg, bradley j. schwieger, karla m. johnston
Posted Date:
Students also viewed these mechanical engineering questions
-
Solve these problems using graphical linear programming and answer the questions that follow. Use simultaneous equations to determine the optimal values of the decision variables. a. b. c. (1) What...
-
Solve these problems using graphical linear programming and then answer the questions that follow. Use simultaneous equations to determine the optimal values of the decision variables. a. b. (1) What...
-
Solve the linear programming problem by applying the simplex method to the dual problem. Minimize subject to C = 2x1 + x2 x1 + x2 8 x1 + 2x2 4 x1,x2 0
-
In using the bolt cutter shown, a worker applies two 300-N forces to the handles. Determine the magnitude of the forces exerted by the cutter on the bolt. 300 N 12 mm 24 mm E 24 mm 460 mm 96 mm 300 N...
-
What is capacity balance? Why is it hard to achieve? What methods are used to deal with capacity imbalances?
-
Explain the import role that information systems play in supporting a supply chain strategy?
-
The alternate hypothesis for a goodness-of-fit test says that some of the probabilities differ from those specified by the null hypothesis. In Exercises 11 and 12, determine whether the statement is...
-
The Questron Company manufactures telecommunications equipment at its plant in Scranton, Pennsylvania. The company has marketing divisions throughout the world. A Questron marketing division in...
-
What are the key risks associated with investing in stocks, please explain?
-
A vaccine to prevent severe rotavirus gastroenteritis (diarrhea) was given to African children within the first year of life as part of a drug study. The study reported that of the 3298 children...
-
Use the following information to complete next balance sheet. Long term debt to equity 0.50. Total asset turnover 2.5 times. Average collection period 18 days. Inventory turn-over 9 times. Gross...
-
Write a program to implement two searching algorithms. (1) a linear search algorithm and (2) a binary search algorithm. If the algorithm finds the searched key value, print out how many comparisons...
-
. Calculate total trees, fruit yield (in kg) and output of orange juice (in litres) for 100, 150, 200, 250, 300, 350, 400, 450, 500 and 550 Ha of total land use and present your answers in a table...
-
es Yuvwell Corporation's direct labor budget for next year contained the following information: Budgeted direct labor-hours 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 8,200 8,300 8,600 8,000 The...
-
Key Question Checklist .Is this business activity one that is specifically addressed in the U.S. Constitution? What general direction of control may be taken by the appropriate government entity? Are...
-
Provide a digital story used by an organization or a person that has relevance to your specialty area. Provide a review and critique of that digital story. A few areas to touch upon are: is the...
-
The main goal of the trait-and-factor approach is to find a job for a person. identify areas of one's life that have affected the success or failure on a previous job. determine whether to refer an...
-
(a) Water flows through the nozzle of a garden hose. Find an expression for m in terms of line pressure P 1 , ambient pressure P 2 , inside hose diameter D 1 , and nozzle outlet diameter D 2 . Assume...
-
Under what circumstances is it appropriate for a CPA to disclose confidential information about a client?
-
How does an auditor determine the fair value of goodwill if: The reporting entity is the total company and the company is publicly traded. The reporting entity is the total company and the company...
-
What are the audit steps associated with assessing the risk of material misstatement for the revenue cycle?
-
A hospitals records show that the cost of carrying out health checks in the last five accounting periods has been as follows: Using the highlow method and ignoring inflation, the estimated cost of...
-
Intermediate: Cost estimation using the linear regression formula. The management accountant at Josephine Ltd is trying to predict the quarterly total maintenance cost for a group of similar...
-
The budget for the production cost of a new product was based on the following assumptions: (i) Time for the 1 st batch of output = 10 hours (ii) Learning rate = 80 per cent (iii) Learning will cease...
Study smarter with the SolutionInn App