mathematics

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.

 

 

 

Fliptop Model

Tiptop Model

Available production hrs.

Ink Assembly

3

4

36

Molding Time

5

4

40

Plastic

5

2

30

 

 

 

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.

 

 

A.        360

 

B.        600

 

C.        700

 

D.        740

 

E.         800

 

 

 

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

 

s.t.

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
Variable Cells
    Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$18 Map A 1500 0 1 1 0.333333333
$C$18 Map B 1000 0 1 0.333333333 1E+30
$D$18 Map C 1000 0 2 0.333333333 1E+30
$E$18 Map D 2833.333333 0 2 1 0.5
Constraints
    Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$B$24     Print 15000 0.5 15000 1000 5666.666667
$B$25     Cut 16500 0 20000 1E+30 3500
$B$26     Fold 20000 0.166666667 20000 7000 1000
$B$27     Print A 1500 0 1000 500 1E+30
$B$28     Print B 1000 -0.33333333 1000 1750 1000
$B$29     Print C 1000 -0.33333333 1000 500 1000

 

 

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.

 

 

 

A.        1,500

 

B.        11,166.67

 

C.        11,500.67

 

D.        11,666.67

 

E.         12,566.67

 

 

 

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?

 

A.        $3200

B.        $4000

C.        $4280

D.        $6295

E.         $7875

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

s.t.

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
Variable Cells
    Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$18  SemiAuto 74.05063291 0 800 628.5714286 432.4786325
$C$18  Robotic 22.78481013 0 1000 1666.666667 440
$D$18  Manual 0 -320.253164 500 320.2531646 1E+30
Constraints
    Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$B$24 Skilled labor 4500 5.569620253 4500 3605.263158 1800
$B$25 Unskilled labor 9000 6.329113924 9000 3805.555556 5850
$B$26 Assembly line 1566.455696 0 2000 1E+30 433.5443038

 

 

 

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?

 

 

 

A.        $22,785.00

 

B.        $19,125.64

 

C.        $33,800.00

 

D.        $102,805.32

 

E.         $104,810.32

 

 

 

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?

 

 

 

A.        $253.16

 

B.        $222.80

 

C.        $341.00

 

D.        $129.50

 

E.         $119.50

 

 

 

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?

 

 

 

A.        2875.33

 

B.        1280.56

 

C.        1550.56

 

D.        3805.56

 

E.         3605.26

 

 

 

37.       Using the Excel output above, how much is each additional unit of unskilled labor worth?

 

 

 

A.        $74.500

 

B.        $22.790

 

C.        $5.570

 

D.        $6.329

 

E.         $3.250

 

 

 

  1. 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.

 

 

 

Order now and get 10% discount on all orders above $50 now!!The professional are ready and willing handle your assignment.

ORDER NOW »»