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
-
The SEC alleged that many deficiencies occurred during the audit of CMH, as discussed in the Auditing in Practice feature in this chapter. Among the complaints were the following: 1. The audit firm...
-
What additional elements were included in relevance and reliability by PSAB? Why were they included?
-
Indicate whether each of the following actions is primarily related to (a) acquisition of long-term assets, (b) evaluating the financing of long-term assets, or (c) applying the matching rule to...
-
Cancico Communications has supplied the following data for use in its ABC system: During the year, Cancico Communications completed an order for special telephone equipment for a new customer,...
-
Solve questions with step by step please 1. (10 points) Use spherical coordinates to compute the surface area of a sphere of radius R (i.e. set up and evaluate a surface integral which represents the...
-
The percentage changes in prepaid expenses and other current assets jumped up 16.5% in scal 2014 and then fell by 35.2% in scal 2015. Did the changes in the dollar amounts of this account have a huge...
-
COMM 300 Research Methods Practice Assignment 6: Interview Transcript Objective:The objective of this assignment is to provide undergraduate students with hands-onexperience in conducting and...
-
Activity Q on a project has exactly 4 successors E, F, G, and H whose late start days are 20, 12, 38, and 32. (Here "day" means days after project start and successor in this context means that E, F,...
-
Find the center and radius of the sphere with the equation x2 + y2 + z2 = 6y + 18z - 2x. 9) Given a = 24i - 8j + 12k and b = 3i - j + 3/2 k , determine whether a and b are parallel, perpendicular, or...
-
While computing the cost of equity using the formula , rs=D1P0+grs=D1P0+g, we do not make any adjustment to express the cost of equity on an after-tax basis whereas while computing the cost of debt,...
-
T he ABC bank has a deposit base on which it holds excess reserves of $42 Million at a reserve rate that relates to a money multiplier (MM) of 5. On January 2, 2010, Mwen-Mwen, a customer of ABC bank...
-
a. What is the present value of $280,000 to be received after 40 years with a 16 percent discount rate? Use Appendix B as an approximate answer, but calculate your final answer using the formula and...
-
11 .Which activity is not part of the finance function ?a . cash receiptsC .credit6. portfolio managementd.general ledger
-
If 2 5 9 - k 5 8 = 2 5 8 , what is the value of k?
-
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....
-
(Appendix 5A) How is the sale of equipment reported on the statement of cash flows, using the indirect method?
-
What is gross profit or gross margin on sales? How is the gross profit ratio computed? In your explanation, assume that net sales revenue is $100,000 and cost of sales is $60,000.
-
Which basic accounting concept is satisfied by using the allowance method of accounting for bad debts?
Study smarter with the SolutionInn App