Reference no: EM13983020
Problem 1
The daily production process at a soda bottling company produces regular orange-flavored (x1), regular lemon-flavored (x2), diet orange-flavored (x3), and diet lemon-flavored (x4) drinks. The company operates 18 hours (1,080 minutes) per day and uses two types of syrups with daily available inventories of 260 and 220 gallons for syrup types 1 and 2,respectively. The demand for the two orange-flavored drinks combined is no more than 250 bottles and the two lemon-flavored drinks have a combined daily demand of at least 300 bottles. The company wishes to choose the production level for each type of drink in order to maximize its total profit.
|
|
Production Time
(Minutes)
|
Syrup 1 (Gallons)
|
Syrup 2 (Gallons)
|
Profit per Unit
|
|
Regular Orange Drink
|
1.2
|
0.30
|
0.10
|
$1.20
|
|
Regular Lemon Drink
|
1
|
0.25
|
0.25
|
$1.50
|
|
Diet Orange Drink
|
1.4
|
0.25
|
0.20
|
$1.80
|
|
Diet Lemon Drink
|
2
|
0.40
|
0.30
|
$2.00
|
a) Write the mathematical formulation of the problem.
b) Use the Excel Solver to solve the problem. Generate the answer and sensitivity reports in Excel, and submit your Excel workbook as a separate attachment. Provide the results obtained from the Solver.
c) The optimal value of one of the decision variables is zero. What should the minimum profit per bottle be for this decision variable to change to a nonzero value?
d) Management is considering adding two hours to the daily production time. Should the two hours be added? What will the contribution be to the optimal profit?
e) Which syrup type do you recommend to be increased? Why?
f) Suppose that the daily amount of syrup 1 is increased to 280 gallons. How much will this change contribute to the optimal profit?
g) Suppose that the daily amount of syrup 2 is increased to 230 gallons. How much will this change contribute to the optimal profit?
Problem 2
Burroughs Garment Company manufactures men's shirts and women's blouses for Walmark Discount Stores. Walmark will accept all production supplied by Burroughs. The production process includes cutting, sewing, and packaging. Burroughs employs 25 workers in the cutting department, 35 in the sewing department, and 5 in the packaging department. The factory works an 8-hour shift, 5 days a week.
| Minutes per Unit |
| Garment |
Cutting |
Sewing |
Packaging |
Unit Price ($) |
| Shirts |
20 |
70 |
12 |
8 |
| Blouses |
60 |
60 |
4 |
12 |
The following table provides the time requirements and price per unit for the garments.
a) Write the mathematical formulation of the problem.
b) Solve the problem graphically or by using the simplex iterations to determine the optimal weekly production schedule for Burroughs.
c) Algebraically, determine the sensitivity ranges for the unit price of a blouse.
d) Determine the worth of one hour of cutting, sewing, and packaging in terms of total revenue. (Hint: Use the Solver sensitivity analysis.)
e) If overtime can be used in cutting and sewing, what is the maximum hourly rate Burroughs should pay for overtime?
|
What is the tension in the cord
: A small steel sphere of mass 0.40 kg is attached by a 0.50 m long cord to a swivel pin set into the surface of a friction-less table top. The sphere moves in a circle on the horizontal surface witha speed of 6.0 m/s. what is the magnitude of the c..
|
|
What is the voltage drop across the extension cord
: What is the voltage drop across the extension cord if the 18-gauge cord is used instead, with the same current being drawn? How does using the 18-gauge cord in place of the 12-gauge cord affect the operation of the appliance? Be specific.
|
|
Comment on the concerns of the client
: The client is very suspicious that the manager has not randomly selected the stocks. She believes that the chances of all 7 of the stocks being large cap must be very low. Compute the probability of all 7 being large cap and comment on the concern..
|
|
What is the acute danger in using a longer tube
: In snorkeling a swimmer breathes by means of a tube that extends above the water level. Why is the tube restricted to about 20 centimeters? That is, what is the acute danger in using a longer tube?
|
|
Solve problem graphically or by using the simplex iterations
: Which syrup type do you recommend to be increased? Why - Suppose that the daily amount of syrup 1 is increased to 280 gallons. How much will this change contribute to the optimal profit?
|
|
What was the acceleration of the soap box car
: A soap box derby race car has a speed of 2 m/s as it passes the first check point and has a final speed of 20 m/s asit passes the second chech point. If 15 seconds of time elapses between checkpoints, what was the acceleration of the soap box car?
|
|
Wood product companies in the world
: The Weyerhauser Lumber Company headquartered in Tacoma, Washington, is one of the largest timber and wood product companies in the world. Weyerhauser manufactures plywood at one of its Oregon plants.
|
|
Poisson distribution with a mean
: Arrivals to a bank automated teller machine (ATM) are distributed according to a Poisson distribution with a mean equal to three per 15 minutes.
|
|
Average return on business analytics projects
: International Data Corp. (IDC) has shown that the average return on business analytics projects was almost four-and-a-half times the initial investment.
|