What is the maximum profit under the optimal solution? An up-and-coming drug company needs to decide production
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
An up-and-coming drug company needs to decide production levels for the upcoming week. The company sells three types of drugs, Jomentum, Zapitol, and Pakoderm, each of which is produced in batches. The labor requirements, profit per batch, and weekly demand for each type of drug is given below, along with the company's weekly capacity (labor hours). Labor hours required/batch Drug Profit per batch Manufacturing Quality Testing Weekly Demand Jomentum 29 30 13 52 Zapitol Pakoderm 21 25 8 130 62 32 19 67 4000 3200 Weekly capacity (labor hours) The output for an LP solution is provided below. Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$12 Production Jomentum 52 0 29 1E+30 3.80 $C$12 Production Zapitol 12 0 21 3.17 21 $D$12 Production Pakoderm 67 0 62 1E+30 83.12 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $G$24 Jomentum Demand $G$25 Zapitol Demand $G$26 Pakoderm Demand 226 52 4 52 9.87 52 12 0 130 1E+30 118.16 67 83 67 9.25 67 $B$25 Manufacturing Needed 4000 1 4000 2954 296 $B$26 Quality Testing Needed 2044 0 3200 1E+30 1156.28 The objective is to come up with the production volumes (number of batches) of the three products to maximize profit. We denote the production volumes of Jometum, Zapitol, and Pakoderm by X,, X₂, and Xp, respectively. An up-and-coming drug company needs to decide production levels for the upcoming week. The company sells three types of drugs, Jomentum, Zapitol, and Pakoderm, each of which is produced in batches. The labor requirements, profit per batch, and weekly demand for each type of drug is given below, along with the company's weekly capacity (labor hours). Labor hours required/batch Drug Profit per batch Manufacturing Quality Testing Weekly Demand Jomentum 29 30 13 52 Zapitol Pakoderm 21 25 8 130 62 32 19 67 4000 3200 Weekly capacity (labor hours) The output for an LP solution is provided below. Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$12 Production Jomentum 52 0 29 1E+30 3.80 $C$12 Production Zapitol 12 0 21 3.17 21 $D$12 Production Pakoderm 67 0 62 1E+30 83.12 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $G$24 Jomentum Demand $G$25 Zapitol Demand $G$26 Pakoderm Demand 226 52 4 52 9.87 52 12 0 130 1E+30 118.16 67 83 67 9.25 67 $B$25 Manufacturing Needed 4000 1 4000 2954 296 $B$26 Quality Testing Needed 2044 0 3200 1E+30 1156.28 The objective is to come up with the production volumes (number of batches) of the three products to maximize profit. We denote the production volumes of Jometum, Zapitol, and Pakoderm by X,, X₂, and Xp, respectively.
Expert 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 general management questions
-
Determine the optimal incubation condition for HaCat cells to grow? Answer all questions and record all calculations in your lab book. 1. Calculate the appropriate amount of reagents necessary to...
-
An up-and-coming drug company needs to decide production levels for the upcoming week. Suppose now the company sells 5 types of drugs, Jomentum, Zapitol, Pakoderm, Kioal, and Diadol. Each drug is...
-
Alpha Corp. (a spinoff of Alpha Beta) makes Product X, which is composed of two Part Ys. Complete the following MRP matrices for X and Y, and construct a planned order report. When are orders placed...
-
At the end of the current year, Accounts Receivable has a balance of $1,975,000; Allowance for Doubtful Accounts has a credit balance of $19,670; and sales for the year total $28,550,000. Using the...
-
What is systems certification?
-
Shiloh supplies equipment to the automotive and commercial vehicle markets and other industrial customers. It specializes in materials and designs that reduce vehicle weight and increase fuel...
-
Tierney Company begins operations on April 1. Information from job cost sheets shows the following. Job 12 was completed in April. Job 10 was completed in May. Jobs 11 and 13 were completed in June....
-
1)Consider the crowding out model. Assume there are men and women in the labor force and three occupations: preschool, elementary and secondary teachers. Suppose only women can work as elementary and...
-
show all the calculations in detail! Also, please do not copied and pasted answers from another website (Especially c_h_e_g_g) a) b) B' A' A' B' A' B A FIGURE 2. Details of geometry to determine...
-
On June 3 , 2 0 X 1 , Georgia State Company received a $ 1 0 , 4 0 0 , 4 5 - day, 1 0 percent note from Sampson Byrd , a customer whose account was past due. The note was discounted on June 1 8 , 2 0...
-
How do conservation strategies and policy frameworks, such as protected areas, habitat restoration, species reintroductions, and international agreements like the Convention on Biological Diversity,...
-
Competitor Profile of New York city. Please write detail information and references below. Thanks
-
a- What is an operating system? Why do we need to conduct its Audit? b- Mention the three main tasks of an operating system c- write the five fundamental objectives of the operating system
-
Why does a company that has just filed a petition change the name on its bank accounts to include the company name and debtor in possession?
-
A four-bit binary number is represented as A3A2A1A0, where A3, A2, A1, and A0 represent the individual bits and A0 is equal to the LSB. Design a logic circuit that will produce a HIGH output whenever...
-
Write the statement to store the contents of the txtAge control in an Integer variable named intAge.
-
Refer to the Medical Supplies for Banjul case. From the corresponding exercise in Chapter 3, review the design of a spreadsheet that will enable you to request the required funds from your teams...
-
A given stock is currently priced at $100. Historically, its annual return has been 12 percent with a standard deviation of 15 percent. Build a spreadsheet simulation model for the stock price, using...
-
You are organizing rides for a group of campers going on an all-day, off-site trip. You have lined up some drivers, and your problem is to assign campers to drivers. The drivers and the capacities of...
-
A landlord appeals and a tenant cross-appeals a district court ruling affirming in part and reversing in part a small claims court decision in a residential landlordtenant dispute. This is a case...
-
Norman Eastwood owns and lives in a single-family home with his wife (the Property). The Property is located in the Willow Bend Lakes Community in Plano, Texas. The Willow Bend Lakes Community is...
-
20 East 67th Street Associates LLC (Landlord) is the owner of a seven-story residential property located at 20 East 67th Street in Manhattan, New York (the Property). On January 2, 2019, Emily Jerome...
Study smarter with the SolutionInn App