Question: PDQ Company - ANSWER REPORT (from Excel and Solver) Objective Cell (Max) Cell Name Original Value Final Value $D$20 Total Profit X1 9 28 Variable

PDQ Company - ANSWER REPORT (from Excel and Solver)

Objective Cell (Max)

Cell

Name

Original Value

Final Value

$D$20

Total Profit X1

9

28

Variable Cells

Cell

Name

Original Value

Final Value

Integer

$D$16

Quantities X1

1

2

Contin

$E$16

Quantities X2

1

4

Contin

Constraints

Cell

Name

Cell Value

Formula

Status

Slack

$F$23

LHS

10

$F$23<=$H$23

Binding

0

$F$24

LHS

36

$F$24<=$H$24

Binding

0

$F$25

LHS

2

$F$25<=$H$25

Not Binding

2

2) Write a summary to interpret the results that are shown in the above Answer Report.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

help! thanks! 1) A typical linear programming objective function might be written as 3X+2Y+5Z20. A. True B. False 2) What is slack? A) The maximum value for any constraint. B) The leftover or unused...

Q:

MS electronics supply highly complex components for military communications systems. Four products, named the MX range, share the labor hours available for each of the four production processes:...

Q:

Globex Investment Capital Corporation, a financial firm, owns six assets that have the following estimated returns ($ million) if sold in one of the next three years. For example, if asset 1 is sold...

Q:

MS electronics supply highly complex components for military communications systems. Four products, named the MX range, share the labor hours available for each of the four production processes:...

Q:

MS electronics supply highly complex components for military communications systems. Four products, named the MX range, share the labor hours available for each of the four production processes:...

Q:

MS electronics supply highly complex components for military communications systems. Four products, named the MX range, share the labor hours available for each of the four production processes:...

Q:

Objective Cell (Max) Cell Name Original Value Final Value $I$7 Max 80888.89 80888.89 Variable Cells Cell Name Original Value Final Value Integer $E$6 X1 111.1 111.1 Contin $F$6 X2 4 4 Contin $G$6 X3...

Q:

Zales Jeweller uses rubies and sapphires to produce two types of rings. A type 1 ring requires two rubies, three sapphires and one hour of jeweller s labour time. A type 2 ring requires three rubies,...

Q:

Objective Cell (Max) Cell Name Original Value Final Value $I$7 Max 80888.89 80888.89 Variable Cells Cell Name Original Value Final Value Integer $E$6 X1 111.1 111.1 Contin $F$6 X2 4 4 Contin $G$6 X3...

Q:

Given the following Linear program with the corresponding Excel printout: Maximize Z = 3X 1 + 5X 2 Subject to: X 1 + 2X 2 50 -X 1 + X 2 10 Non-negativity: X 1 0 X 2 0 EXCEL PRINTOUT Objective Cell...

Q:

a) Suppose that gn > 0 is a sequence of integrable functions which satisfies Show that if f : [a, b] R is integrable on [a, b], then b) Prove that if f is integrable on [0,1], then tb lim gn (x) dx...

Q:

The Cardboard Box Company (CBC) is a public limited company based in the West Midlands of the UK. The company manufactures cardboard packaging, (mainly boxes), for companies who sell their goods...

Q:

In process costing, costs flow from one department to the next through debits and credits to the Blank 1 Question 2 3 account. Options 1 ) cost of goods sold 2 ) materials inventory 3 ) work in...

Q:

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...