A beverage cans manufacturer makes 3 types of soft drink cans needed for the beverage producers...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A beverage cans manufacturer makes 3 types of soft drink cans needed for the beverage producers to fill soft drinks of three different volumes. The maximum availability of the machines' time allotted per day is 90 hours and the supply of metal is limited to 120 kg per day. The following table provides the details of the input needed to manufacture one batch of 100 cans. Cans Large Medium Small Maximum Metal (kgybatch 5. 120 Machines' Time (hrybatch 4.4 4.2 90 Profit/batch 50 Let L= number of Large cans produced M= number of Medium cans produced S= number of Small cans produced $45 $42 Formulate and solve for the recommended production quantities for all the three different types cans by maximizing the profit. Use Excel solver to find your answers. Report the optimal value of L QUESTION 2 Based on question 1, use Excel Solver to find the optimal solution and report the value of M. QUESTION 3 Based on question 1. use Excel Solver to find the optimal solution and report the value of S QUESTION 4 Based on question 1, use Excel Solver to find the optimal solution and report the optimal value of the objective function, A beverage cans manufacturer makes 3 types of soft drink cans needed for the beverage producers to fill soft drinks of three different volumes. The maximum availability of the machines' time allotted per day is 90 hours and the supply of metal is limited to 120 kg per day. The following table provides the details of the input needed to manufacture one batch of 100 cans. Cans Large Medium Small Maximum Metal (kgybatch 5. 120 Machines' Time (hrybatch 4.4 4.2 90 Profit/batch 50 Let L= number of Large cans produced M= number of Medium cans produced S= number of Small cans produced $45 $42 Formulate and solve for the recommended production quantities for all the three different types cans by maximizing the profit. Use Excel solver to find your answers. Report the optimal value of L QUESTION 2 Based on question 1, use Excel Solver to find the optimal solution and report the value of M. QUESTION 3 Based on question 1. use Excel Solver to find the optimal solution and report the value of S QUESTION 4 Based on question 1, use Excel Solver to find the optimal solution and report the optimal value of the objective function,
Expert Answer:
Related Book For
Finite Mathematics and Its Applications
ISBN: 978-0134768632
12th edition
Authors: Larry J. Goldstein, David I. Schneider, Martha J. Siegel, Steven Hair
Posted Date:
Students also viewed these general management questions
-
A soft drink manufacturer puts one of three different quotations on the inside of each bottle cap. Assuming that each of the quotations is equally likely to appear, what is the probability of...
-
A soft-drink manufacturer wants to make cylindrical cans for its product. The can is to have a volume of 12 fluid ounces, which is approximately 22 cubic inches. Find the dimensions of the of the can...
-
A certain vending companys soft drink dispensing machines are supposed to serve 6 oz of beverage. Various machines were sampled, and the resulting amounts of dispensed drink (in ounces) were...
-
In Exercises find the extrema and the points of inflection (if any exist) of the function. Use a graphing utility to graph the function and confirm your results. f(x) = xe-x
-
In an article in Public Roads (1983), Bissell, Pilkington, Mason, and Woods study bridge safety (measured in accident rates per 100 million vehicles) and the difference between the width of the...
-
Chipotle Mexican Grill, Inc. is a quick-service restaurant providing a focused menu of burritos, tacos, and salads. Chipotle's balance sheets for the end of two recent years are as follows: A....
-
Using the software development life cycle approach, do we apply project management principles to software development? Elaborate on your answer.
-
The bookkeeper for Willingham Corporation made these errors in journalizing and posting. 1. A credit posting of $400 to Accounts Receivable was omitted. 2. A debit posting of $750 for Prepaid...
-
3. May 9: Derby's engineering staff complete the train design and it is approved by officials from OM as well as the Transportation Safety Board. 4. August 1: Derby completes construction of the 10...
-
Consolidation related simulation example: Millennium Capital Management, Inc., (MCM) acquired a 90% interest in NextGen, Inc. MCM's Financial Manager, Matthew Steven, has prepared a draft memo to the...
-
Verify that the function z(x, y) = ln(e* +e") is a solution equations z z + x 1 and 82z 82 z 2 of the partial differential 22 z ???? Show that the functions e3x+4y cos 5z satisfies the...
-
Aaron transferred property with a basis of $50,000 and a fair market value of $75,000 plus services worth $25,000 to BK Corporation for stock of BK valued at $100,000. Immediately after the exchange,...
-
An entity is considering a total upgrade of their Motorola radio inventory and an official has been tasked with determining the total cost of ownership for a new cache of devices. A total of 120...
-
A taxpayer spends $50,000 on a new roof, $5,000 for minor repairs, and $15,000 for a new driveway on a residential rental property. What value of these "repairs" is required to be capitalized instead...
-
In 2020, Jimi Hendrix Corporation began selling a new line of guitars. The company guarantees the instruments against manufacturing defects for two years from the date of sale. The company has...
-
A taxpayer takes out a distribution to satisfy their need to make RMDs on their account. In doing so, they pull out $5,000. They actually needed to pull out $8,000 and the IRS assesses and collects a...
-
One key difference between tariffs and quotas is that a . . tariffs put a legal limit on how much of a good can be imported, while a quota is a tax on imported goods. b . . tariffs raise revenue for...
-
Quadrilateral EFGH is a kite. Find mG. E H <105 G 50 F
-
Find n (S), given that n (T) = 7, n (S T) = 5, and n (S T) = 10.
-
Draw the logic circuit that represents each of the logical statements in Exercises 5-8. Determine the output when the variables have the values given? 1. p ((q r); for p = 1, q = 0, r = 1 2. (p q)...
-
1. A mouse is put into a T-maze (a maze shaped like a T). In this maze, it has the choice of turning to the left and being rewarded with cheese or going to the right and receiving a mild shock....
-
Consider the following observations: a. Fit the nonlinear regression model \[ y=\theta_{1} e^{\theta_{2} x}+\varepsilon \] to these data. Discuss how you obtained the starting values. b. Test for...
-
For the models shown below, determine whether it is a linear model, an intrinsically linear model, or a nonlinear model. If the model is intrinsically linear, show how it can be linearized by a...
-
Sketch the expectation function for the logistic growth model (12.34) for \(\theta_{1}=1, \theta_{3}=1\), and values of \(\theta_{2}=1,4,8\), respectively. Overlay these plots on the same \(x-y\)...
Study smarter with the SolutionInn App