The Galaxy Protectors Company (GPC) produces four types of clones: light infantry, medium Infantry, heavy infantry...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Galaxy Protectors Company (GPC) produces four types of clones: light infantry, medium Infantry, heavy infantry and lightsaber infantry. GPC also produces engineers and pilots. Planet capacities limit total production to at most 300 clones per year. Light, medium and heavy infantries are cloned together in a facility with total capacity of 100 clones. Lightsaber infantries are cloned in another facility with capacity of 50; lastly engineers and pilots have a capacity of 200 clones in total. GPC's marketing strategy requires that light, medium and heavy infantry types must constitute at least one third of the clone mix for all of the infantry types. Profits, market supply, and raw clone material efficiencies are given in a separate excel file. The Galaxy Average Raw Material Efficieney (GARME) standards in the Clone Material Policy require an average raw clone material efficiency of 25 kg per clone. GPC wants to determine the number of cach clone type to produce. a-) Write a mathematical model that maximizes the total profit. Define your decision variables clearly. Solve your model using CPLEX Studio OPL. Use the excel data file you have been provided. b-) GPC has decided to redesign the light, medium and heavy infantry facility and the total capacity of this facility has been decreased to 60 clones. Will you recommend this redesign to GPC? Why? c-) If the GARME standards require an average raw clone material efficiency of 35 Kg per clone, which clones will be produced to obtain the optimal solution? Market Raw Clone Туре Profits Сарacity Supply Material (Kg) Light Infantry Medium Infantry Heavy Infantry Lightsaber Infantry Engineer Pilot 1000 610 40 1555 420 34 100 1850 320 15 3600 35 12 50 2700 355 20 200 2400 200 25 Total Production Limit 300 The Galaxy Protectors Company (GPC) produces four types of clones: light infantry, medium Infantry, heavy infantry and lightsaber infantry. GPC also produces engineers and pilots. Planet capacities limit total production to at most 300 clones per year. Light, medium and heavy infantries are cloned together in a facility with total capacity of 100 clones. Lightsaber infantries are cloned in another facility with capacity of 50; lastly engineers and pilots have a capacity of 200 clones in total. GPC's marketing strategy requires that light, medium and heavy infantry types must constitute at least one third of the clone mix for all of the infantry types. Profits, market supply, and raw clone material efficiencies are given in a separate excel file. The Galaxy Average Raw Material Efficieney (GARME) standards in the Clone Material Policy require an average raw clone material efficiency of 25 kg per clone. GPC wants to determine the number of cach clone type to produce. a-) Write a mathematical model that maximizes the total profit. Define your decision variables clearly. Solve your model using CPLEX Studio OPL. Use the excel data file you have been provided. b-) GPC has decided to redesign the light, medium and heavy infantry facility and the total capacity of this facility has been decreased to 60 clones. Will you recommend this redesign to GPC? Why? c-) If the GARME standards require an average raw clone material efficiency of 35 Kg per clone, which clones will be produced to obtain the optimal solution? Market Raw Clone Туре Profits Сарacity Supply Material (Kg) Light Infantry Medium Infantry Heavy Infantry Lightsaber Infantry Engineer Pilot 1000 610 40 1555 420 34 100 1850 320 15 3600 35 12 50 2700 355 20 200 2400 200 25 Total Production Limit 300 The Galaxy Protectors Company (GPC) produces four types of clones: light infantry, medium Infantry, heavy infantry and lightsaber infantry. GPC also produces engineers and pilots. Planet capacities limit total production to at most 300 clones per year. Light, medium and heavy infantries are cloned together in a facility with total capacity of 100 clones. Lightsaber infantries are cloned in another facility with capacity of 50; lastly engineers and pilots have a capacity of 200 clones in total. GPC's marketing strategy requires that light, medium and heavy infantry types must constitute at least one third of the clone mix for all of the infantry types. Profits, market supply, and raw clone material efficiencies are given in a separate excel file. The Galaxy Average Raw Material Efficieney (GARME) standards in the Clone Material Policy require an average raw clone material efficiency of 25 kg per clone. GPC wants to determine the number of cach clone type to produce. a-) Write a mathematical model that maximizes the total profit. Define your decision variables clearly. Solve your model using CPLEX Studio OPL. Use the excel data file you have been provided. b-) GPC has decided to redesign the light, medium and heavy infantry facility and the total capacity of this facility has been decreased to 60 clones. Will you recommend this redesign to GPC? Why? c-) If the GARME standards require an average raw clone material efficiency of 35 Kg per clone, which clones will be produced to obtain the optimal solution? Market Raw Clone Туре Profits Сарacity Supply Material (Kg) Light Infantry Medium Infantry Heavy Infantry Lightsaber Infantry Engineer Pilot 1000 610 40 1555 420 34 100 1850 320 15 3600 35 12 50 2700 355 20 200 2400 200 25 Total Production Limit 300 The Galaxy Protectors Company (GPC) produces four types of clones: light infantry, medium Infantry, heavy infantry and lightsaber infantry. GPC also produces engineers and pilots. Planet capacities limit total production to at most 300 clones per year. Light, medium and heavy infantries are cloned together in a facility with total capacity of 100 clones. Lightsaber infantries are cloned in another facility with capacity of 50; lastly engineers and pilots have a capacity of 200 clones in total. GPC's marketing strategy requires that light, medium and heavy infantry types must constitute at least one third of the clone mix for all of the infantry types. Profits, market supply, and raw clone material efficiencies are given in a separate excel file. The Galaxy Average Raw Material Efficieney (GARME) standards in the Clone Material Policy require an average raw clone material efficiency of 25 kg per clone. GPC wants to determine the number of cach clone type to produce. a-) Write a mathematical model that maximizes the total profit. Define your decision variables clearly. Solve your model using CPLEX Studio OPL. Use the excel data file you have been provided. b-) GPC has decided to redesign the light, medium and heavy infantry facility and the total capacity of this facility has been decreased to 60 clones. Will you recommend this redesign to GPC? Why? c-) If the GARME standards require an average raw clone material efficiency of 35 Kg per clone, which clones will be produced to obtain the optimal solution? Market Raw Clone Туре Profits Сарacity Supply Material (Kg) Light Infantry Medium Infantry Heavy Infantry Lightsaber Infantry Engineer Pilot 1000 610 40 1555 420 34 100 1850 320 15 3600 35 12 50 2700 355 20 200 2400 200 25 Total Production Limit 300 The Galaxy Protectors Company (GPC) produces four types of clones: light infantry, medium Infantry, heavy infantry and lightsaber infantry. GPC also produces engineers and pilots. Planet capacities limit total production to at most 300 clones per year. Light, medium and heavy infantries are cloned together in a facility with total capacity of 100 clones. Lightsaber infantries are cloned in another facility with capacity of 50; lastly engineers and pilots have a capacity of 200 clones in total. GPC's marketing strategy requires that light, medium and heavy infantry types must constitute at least one third of the clone mix for all of the infantry types. Profits, market supply, and raw clone material efficiencies are given in a separate excel file. The Galaxy Average Raw Material Efficieney (GARME) standards in the Clone Material Policy require an average raw clone material efficiency of 25 kg per clone. GPC wants to determine the number of cach clone type to produce. a-) Write a mathematical model that maximizes the total profit. Define your decision variables clearly. Solve your model using CPLEX Studio OPL. Use the excel data file you have been provided. b-) GPC has decided to redesign the light, medium and heavy infantry facility and the total capacity of this facility has been decreased to 60 clones. Will you recommend this redesign to GPC? Why? c-) If the GARME standards require an average raw clone material efficiency of 35 Kg per clone, which clones will be produced to obtain the optimal solution? Market Raw Clone Туре Profits Сарacity Supply Material (Kg) Light Infantry Medium Infantry Heavy Infantry Lightsaber Infantry Engineer Pilot 1000 610 40 1555 420 34 100 1850 320 15 3600 35 12 50 2700 355 20 200 2400 200 25 Total Production Limit 300 The Galaxy Protectors Company (GPC) produces four types of clones: light infantry, medium Infantry, heavy infantry and lightsaber infantry. GPC also produces engineers and pilots. Planet capacities limit total production to at most 300 clones per year. Light, medium and heavy infantries are cloned together in a facility with total capacity of 100 clones. Lightsaber infantries are cloned in another facility with capacity of 50; lastly engineers and pilots have a capacity of 200 clones in total. GPC's marketing strategy requires that light, medium and heavy infantry types must constitute at least one third of the clone mix for all of the infantry types. Profits, market supply, and raw clone material efficiencies are given in a separate excel file. The Galaxy Average Raw Material Efficieney (GARME) standards in the Clone Material Policy require an average raw clone material efficiency of 25 kg per clone. GPC wants to determine the number of cach clone type to produce. a-) Write a mathematical model that maximizes the total profit. Define your decision variables clearly. Solve your model using CPLEX Studio OPL. Use the excel data file you have been provided. b-) GPC has decided to redesign the light, medium and heavy infantry facility and the total capacity of this facility has been decreased to 60 clones. Will you recommend this redesign to GPC? Why? c-) If the GARME standards require an average raw clone material efficiency of 35 Kg per clone, which clones will be produced to obtain the optimal solution? Market Raw Clone Туре Profits Сарacity Supply Material (Kg) Light Infantry Medium Infantry Heavy Infantry Lightsaber Infantry Engineer Pilot 1000 610 40 1555 420 34 100 1850 320 15 3600 35 12 50 2700 355 20 200 2400 200 25 Total Production Limit 300
Expert Answer:
Answer rating: 100% (QA)
light infartry medium infontey heavry infantry and lightsablr Ans The Gralax... View the full answer
Related Book For
Management Science The Art of Modeling with Spreadsheets
ISBN: 978-1118582695
4th edition
Authors: Stephen G. Powell, Kenneth R. Baker
Posted Date:
Students also viewed these accounting questions
-
Healthy Times produces four types of frozen TV dinners that it sells to supermarkets and independent grocery stores. The company operates from two locations: a manufacturing plant and a refrigerated...
-
Electra produces four types of electric motors, each on a separate assembly line. The respective capacities of the lines are 500, 500, 800, and 750 motors per day. Type 1 motor uses 8 units of a...
-
Type i light bulbs function for a random amount of time having mean i and standard deviation i, i = 1, 2. A light bulb randomly chosen from a bin of bulbs is a type 1 bulb with probability p and a...
-
1.think about the evolution of the food industry, What was it in the past, and what will it be in the future? How will the 4 p's of marketing evolve within the industry you selected? 2.What is one...
-
Some hoteliers believe that a hotel's balance sheet is the best indicator of its economic health while others point to the income statement as the better measure of financial strength. Which document...
-
1. What central changes are contributing to the growth of Yum! Brands in global markets? 2. Give some examples of ways that you believe Yum! Brands will have to adapt its offerings to appeal to...
-
Briefly describe the three phases of the World Wide Webs development.
-
Carow Corporation purchased, as a held-to-maturity investment, $60,000 of the 8%, 5-year bonds of Harrison, Inc. for $65,118, which provides a 6% return. The bonds pay interest semiannually. Prepare...
-
A fisherman fishing from a pier observes that the float on his line bobs up and down, taking 3 s to move from its highest point to its lowest point. He also estimates that the distance between...
-
Determine the amount of the completed gift, if any, arising from each of the following occurrences. a. A parent sells real estate valued at $1.8 million to an adult child, who pays $1 million in...
-
Q2 Draw the S.F. and B.M. diagrams for the beam loaded as shown in Fig below, and determine (a) (b) The position and magnitude of the maximum B.M., and The position of point of contra flexure, if any...
-
Dahl and Westhoff have decided to form a partnership. They have agreed that Dahl is to invest $400,000 and that Westhoff is to invest $100,000. Dahl is to devote one-third time to the business, and...
-
Crane Company applies manufacturing overhead to jobs on the basis of machine hours used. Overhead costs are expected to total $350,000 for the year, and machine usage is estimated at 125,000 hours....
-
Artyom, who works for Annushka's antique shop, forges Annushka's name ontwo checks, cashes the checks and deposits the funds into his own bank account. Artyom is overcome by his feeling of remorse,...
-
What does "nothingness" represent for Beckett? Support your answer with textual support from the play. Samuel Beckett's "Endgame".
-
1. Graph in Excel showing the evolution of Australian Real GDP and Real Wages Growth since 2000 till June 2023. 2. Graphs in Excel for two other variables whose own evolution sheds light on that of...
-
Why does using the Charge Description Master create concern when trying to comply with the CMS requirements for price transparency? Question 189 options: Consumers may not have access to the price...
-
Consider the discrete group G of order 8 that has the following Cayley diagram e If we have the sequence of operations: fcagec, which of the options represents the reduction of the sequence to a...
-
The Hawley Lighting Company manufactures four families of household lighting at its factory. The product families are table lamps, floor lamps, ceiling fixtures, and pendant lamps. The following...
-
Hill-O-Beans Coffee Company blends four component beans into three final blends of coffee: one is sold to luxury hotels, another to restaurants, and the third to supermarkets for store label brands....
-
A firm operates a docking facility for container ships in Singapore. At present, the facility consists of two identical docks. Ships typically arrive during the night. The number of ships that arrive...
-
The lathe post not provided with power feed is (a) lead screw (b) carriage (c) compound rest (d) cross slide
-
A cone shaped recess at the top of drilled hole can be made by (a) countersinking (b) counterboring (c) taper drilling (d) grooing.
-
Power feed is not provided on the following drilling machine : (a) bench drill press (b) gang drilling machine (c) radial drilling machine (d) all of the above.
Study smarter with the SolutionInn App