Questions 27 & 28 apply to this information: Quill Manufacturing Business makes two models of marking pens. An unlabeled graph for this problem and the requirements for each lot of pens in the three manufacturing departments are given below. All three departments are necessary in the production of both types of pens. The profit for either kind of pen is $1000 per lot. An unlabeled graph for this problem is given below. The dotted line represents the objective function line.
Available production hrs.
27. What is the optimal production quantity of the Fliptop model?
A. 5 lots
B. 4 lots
C. 2 lots
D. 7 lots
E. 6 lots
28. If all the constraint inequalities in the original problem were ≥, then the following is true:
A. The value of the objective function at the optimum solution is zero
B. There will be multiple optimal solutions
C. The problem will become unbounded
D. The problem has a unique solution
E. None of the above is true
29. Let M be the number of units to make and B be the number of units to buy of a certain product. If it costs $2 to make a unit and $3 to buy a unit and 4000 units are needed, the objective function of the LP model to minimize the cost of production would be,
A. Min 4000 (M + B)
B. Max 8000M + 12000B
C. Min 2M + 3B
D. Max 2M + 3B
E. Min 4000U -2M-3B
30. The Quiet Meadow Studio sells photographs and prints. It cost $20 to purchase each photograph and it takes 2 hours to frame it. It costs $25 to purchase each print and it takes 5 hours to frame it. The store has at most $400 to spend and at most 60 hours to frame.
It makes $30 profit on each photograph and $50 profit on each print. Determine the maximum profit.
Questions 31 & 32 apply to this information: Quality Bike Maps has produced four map designs for the local area. A limited amount of time (in minutes) is allocated to the printing, cutting and folding of each map. Additionally, at least one thousand of map designs A, B, and C must be printed. The profit per map is $1 for A and B and $2 for C and D. The Excel output is provided below.
Max Profit = A + B + 2 C + 2 D
A + 2 B + 3 C + 3 D < 15000 Print
2 A + 4 B + C + 3 D < 20000 Cut
3 A + 2 B + 5 C + 3 D < 20000 Fold
A > 1000 Print A
B > 1000 Print B
C > 1000 Print C
|Microsoft Excel 14.0 Sensitivity Report|
|Objective Function Value $10,166.67|
31. Answer the following question using the Excel output above. Which constraint(s) are binding?
A. Print and Fold
B. Cut and Print A
C. Print B and Print C
D. Print and Cut
E. Print, Fold, Print B and Print C
32. Answer the following question using the Excel output above. Keeping within the confines of the problem, the profit on Map A has increased by one dollar. Determine the new objective function value.
33. Quentin Magic Brown manufactures sports shoes and wants to maximize the company’s profits. The company makes two types of sport shoe, Airwalkers and Bouncy Basketball shoes. The company earns $10 profit on each pair of Airwalkers and $18 profit on each pair of Bouncy Basketball shoes.
The manufacturing process includes cutting the materials on a machine and having workers assemble the pieces. Each pair of Airwalkers requires 3 minutes of cutting time and the Bouncy Basketball shoes require 2 minutes. The machines that cut the material can run at most 1200 minutes a week.
Each worker takes 7 hours to assemble a pair of Airwalkers and 8 hours to assemble a pair of Bouncy Basketball shoes; the maximum number of hours available is 3500 per week.
Determine the maximum profit for this problem?
Questions 34-37 apply to the Excel output for the Quantum Mo-Botics model is below. The company makes three types of machines and has limitations with regards to the amount of skilled and unskilled labor hours available and time on the assembly line.
MAX Profit = 800SemiAuto+1000Robotic + 500Manual
30SemiAuto + 100Robotic + 45Manual < 4500 Skilled Labor
100SemiAuto + 70Robotic + 90Manual < 9000 Unskilled Labor
15SemiAuto + 20Robotic + 10Manual < 2000 Assembly Line
|Microsoft Excel 14.0 Sensitivity Report|
|Objective Function Value||$ 82,025.32|
34. Answer the following question using the Excel output above, determine the new objective function value if the profit on the second variable, Robotic, increases by $1000?
35. Answer the following question using the Excel output above. Keeping within the confines of the problem, you are required to hire a full time (40 hours) person who is qualified to work in any department. Select the constraint where you will gain the most profit and determine the additional profit to be gained?
36. Answer the following question using the Excel output above. Keeping within the confines of the problem, how many more hours of skilled workers could you add to the department?
37. Using the Excel output above, how much is each additional unit of unskilled labor worth?
- An ice cream plant make’s Chocolate and Strawberry ice cream.
There is $40 profit for a case of Chocolate and $32 for a case of Strawberry and has the following constraints:
32C + 8S < 4,800 Flavoring
28C + 32S < 14,000 Coloring
a. What is the optimal solution?
b. Now add a constraint: demand for Strawberry is always less than 200 cases and determine the optimal solution.
c. Add another constraint: demand for Chocolate is always less than 400 cases and determine the optimal solution.