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...
-
Journalize the following transactions, using the allowance method of accounting for uncollectible receivables: June 2. Received $1,200 from Melissa Crone and wrote off the remainder owed of $4,000 as...
-
If we dont take care of our customers, someone else will. Explain the nature of this statement. Why does customer service management matter in the modern, global environment?
-
Early in your audit of the Kimberly Corporation, you note that the factory supervisor approves time cards for hours worked and for hourly rates and also distributes the payroll checks. Required: 1....
-
The 2012 and 2011 comparative balance sheets and 2012 income statement of Perfect Supply Corp. follow: Income statement Perfect Supply had no non-cash investing and financing transactions during...
-
When determining future resource needs, factors that should be considered include:?
-
Manchester Company merchandises a single product called ABC and uses a periodic inventory system. The ending inventory at the end of 2017 totaled 50,000 units and were valued using the average cost...
-
Under the assumptions of Sect. 6.4, suppose that \(T=2\) and consider a representative agent with logarithmic utility function \(\sum_{t=0}^{2} \delta^{t} \log \left(c_{t} ight)\). Suppose...
-
For the three-room house shown in Figure 7.35, all rooms are perfect squares and have the same dimensions. An air conditioner produces an equal amount of heat flow \(q_{\mathrm{ho}}\) out of each...
-
Consider the single-tank liquid-level system shown in Figure 7.19, where the volume flow rate into the tank through a pipe is \(q_{\mathrm{i}}\). The liquid leaves the tank through an orifice of area...
-
Find \(e^{\mathbf{A} t}\), where \(t\) is scalar, using a. The expm command. b. The inverse Laplace-transform approach. \(\mathbf{A}=\left[\begin{array}{ll}0 & 4 \\ 1 & 3\end{array} ight]\)
-
The model of a second-order system is given as \[4 \ddot{x}+4 \dot{x}+\frac{5}{4} x=0, \quad x(0)=0.5, \quad \dot{x}(0)=-1\] a. Identify the damping type and express the response \(x(t)\) in closed...
-
As discussed in the text, Person-focused pay programs are not suitable for all kinds of jobs. Based on your understanding of person-focused pay concepts, identify at least three jobs for which this...
-
Transform the while loop from the previous exercise into an equivalent for loop (make sure it produces the same output).
-
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...
-
The electric motor with an attached disk is running at a constant low speed of \(120 \mathrm{rev} / \mathrm{min}\) in the direction shown. Its housing and mounting base are initially at rest. The...
-
The motor housing and its bracket rotate about the \(Z\)-axis at the constant rate \(\Omega=3 \mathrm{rad} / \mathrm{s}\). The motor shaft and disk have a constant angular velocity of spin \(p=8...
-
The bent plate has a mass of \(70 \mathrm{~kg}\) per square meter of surface area and revolves about the \(z\)-axis at the rate \(\omega=30 \mathrm{rad} / \mathrm{s}\). Determine (a) the angular...
Study smarter with the SolutionInn App