Question 1

Microsoft Excel contains a built-in optimizer called

Accepted Answer

A) what-if engines. 
B) calculators. 
C) solvers. 
D) risk analyzers. 
A) what-if engines. 
B) calculators. 
C) solvers. 
D) risk analyzers.

Question 2

A company needs to purchase several new machines to meet its future production needs.It can purchase three different types of machines A,B,and C.Each machine A costs $80,000 and requires 2,000 square feet of floor space.Each machine B costs $50,000 and requires 3,000 square feet of floor space.Each machine C costs $40,000 and requires 5,000 square feet of floor space.The machines can produce 200,250 and 350 units per day respectively.The plant can only afford $500,000 for all the machines and has at most 20,000 square feet of room for the machines.The company wants to buy as many machines as possible to maximize daily production.
What values would you enter in the Risk Solver Platform RSP)task pane for the following cells for this Excel spreadsheet implementation of the formulation for this problem?
Objective Cell: Variables Cells: Constraints Cells:

Accepted Answer

Objective Cell:
$F$6
Variables

Question 3

The "Analyze Without Solving" tool in Analytic Solver Platform is useful for

Accepted Answer

A) verifying the equations in a spreadsheet model. 
B) toggling between absolute and relative cell referencing. 
C) executing the Excel spreadsheet layout Wizard. 
D) naming cells and cell ranges for easier modifiability. 
A) verifying the equations in a spreadsheet model. 
B) toggling between absolute and relative cell referencing. 
C) executing the Excel spreadsheet layout Wizard. 
D) naming cells and cell ranges for easier modifiability.

Question 4

What function is used to add the contents of cells A1,A2 and A3?

Accepted Answer

A) =A1+A2+A3 
B) =ADDA1:A3) 
C) =TOTALA1:A3) 
D) =PRODUCTA1:A3) 
A) =A1+A2+A3 
B) =ADDA1:A3) 
C) =TOTALA1:A3) 
D) =PRODUCTA1:A3)

Question 5

Scaling problems

Accepted Answer

A) can cause Analytic Solver Platform to consider a linear problem as nonlinear. 
B) can cause problems in accuracy of solutions returned. 
C) are caused by small numbers and large numbers used in the same problem. 
D) all of these. 
A) can cause Analytic Solver Platform to consider a linear problem as nonlinear. 
B) can cause problems in accuracy of solutions returned. 
C) are caused by small numbers and large numbers used in the same problem. 
D) all of these.

Question 6

Exhibit 3.1
The following questions are based on this problem and accompanying Excel windows.
Jones Furniture Company produces beds and desks for college students.The production process requires carpentry and varnishing.Each bed requires 6 hours of carpentry and 4 hour of varnishing.Each desk requires 4 hours of carpentry and 8 hours of varnishing.There are 36 hours of carpentry time and 40 hours of varnishing time available.Beds generate $30 of profit and desks generate $40 of profit.Demand for desks is limited,so at most 8 will be produced.
Let S1U1P1XS1S1P0S1U1B11 S1U1B0S1U1P1= Number of Beds to produce S1S1P0XS1U1B12 S1U1B0= Number of Desks to produce
The LP model for the problem is
MAX: S1U1P130 XS1S1P0S1U1B11 S1U1B0S1U1P1+ 40 XS1S1P0S1U1B12S1U1B0
Subject to: S1U1P16 XS1S1P0S1U1B11 S1U1B0S1U1P1+ 4 XS1S1P0S1U1B12 S1U1B0S1U1P1≤ 36 carpentry)S1S1P0
4 XS1U1B11 S1U1B0+ 8 XS1U1B12 S1U1B0≤ 40 varnishing)
XS1U1B12 S1U1B0≤ 8 demand for desks)
XS1U1B11S1U1B0,XS1U1B12 S1U1B0≥ 0
  
-You have been given the following linear programming model.
MAX: 8 X1 + 5 X2
Subject to: 3 X1 + 5 X2 = 54
11 X1 + 10 X2 ≤ 144 X1 / X2 ≥12
X1,X2 ≥ 0
This formulation:

Accepted Answer

A) can be solved without preprocessing using LP 
B) cannot be solved using LP 
C) requires that the third constraint be first converted to a linear form: X1 - 12 X2 ≤ 0 
D) must be first converted to a minimization problem 
A) can be solved without preprocessing using LP 
B) cannot be solved using LP 
C) requires that the third constraint be first converted to a linear form: X1 - 12 X2 ≤ 0 
D) must be first converted to a minimization problem

Question 7

Robert Hope received a welcome surprise in this management science class;the instructor has decided to let each person define the percentage contribution to their grade for each of the graded instruments used in the class.These instruments were: homework,an individual project,a mid-term exam,and a final exam.Robert's grades on these instruments were 75,94,85,and 92,respectively.However,the instructor complicated Robert's task somewhat by adding the following stipulations:
• homework can account for up to 25% of the grade,but must be at least 5% of the grade;
• the project can account for up to 25% of the grade,but must be at least 5% of the grade;
• the mid-term and final must each account for between 10% and 40% of the grade but cannot account for more than 70% of the grade when the percentages are combined;and
• the project and final exam grades may not collectively constitute more than 50% of the grade.Formulate an LP model for Robert to maximize his numerical grade.

Accepted Answer

Let WS1U1B11 S1U1B0S1U1P1= weight assigned to homeworkS1S1P0
WS1U1B12 S1U1B0= weight assigned to t

Question 8

Pete's Plastics manufactures plastic at plants in Miami,St.Louis and Cleveland.Pete needs to ship plastic to customers in Pittsburgh,Atlanta and Chicago.He wants to minimize the cost of shipping the plastic from his plants to his customers.The data for the problem is summarized in the following table.
Distance From Plants to Customers
 $$\begin{array} { l c c c c } 
\text { Plant } & \text { Pittsburgh } & \text { Atlanta } & \text { Chicago } & \text { Supply } \
\hline \text { Miani } & 1,200 & 700 & 1,300 & 30 \
\text { St. Lauis } & 700 & 550 & 300 & 40 \
\text { Cleveland } & 125 & 675 & 350 & 50 \
\hline \text { Damand } & 40 & 60 & 20 &
\end{array}$$ 
Formulate the LP for this problem.

Accepted Answer

The answer of Pete's Plastics manufactures plastic at plants in...

Question 9

What action is required to make Analytic Solver Platform ASP)solve a specified problem?

Accepted Answer

A) Type go in cell A1. 
B) Click the "Optimize" button on the ASP Ribbon,or the green arrow "Solve" in the Task Pane. 
C) Click the Close button in the ASP Parameters dialog box. 
D) Click the Guess button in the ASP Parameters dialog box. 
A) Type go in cell A1. 
B) Click the "Optimize" button on the ASP Ribbon,or the green arrow "Solve" in the Task Pane. 
C) Click the Close button in the ASP Parameters dialog box. 
D) Click the Guess button in the ASP Parameters dialog box.

Question 10

Project 3.1 − The Diet Problem: Ordering Meals from McDonald's
Based on: Robert A.Bosch,"Big Mac Attack: The Diet Problem revisited,Eating at McDonald's," OR/MS Today,
August 1993,pp 30-31.
Tina Simpson is a new fourth-grade teacher at Forest Ridge Elementary.The first teacher workshop for the upcoming school year is next Monday and by majority vote,McDonald's was selected as the food of choice.As the new person,Tina is tasked with developing the meal for the workshop.McDonald's has graciously offered to deliver whatever food Tina decides to order,along with a variety of condiments applicable to whatever is ordered.Rather than offer a menu choice,Tina has decided to simply order the same meal for each person in the workshop.
To get started,Tina took a trip to McDonald's and obtained their published information on the nutritional content of their food.That data is summarized in the table below.

Tina wants the meal to be nutritionally complete.The National Research Council publishes their Recommended Daily Allowances.In this publication,they contend that a diet in this case the meal)should provide at least 100 percent of the U.S.RDA of numerous nutrients.The specific amount of the RDA depends on such factors as age,weight and gender.In addition,the council recommends daily sodium and cholesterol intakes be kept to at most 2.4 grams of sodium and 300 milligrams of cholesterol.Further,at most 30 percent of the calories consumed should come from fat,and at most 10 percent from saturated fat.Each gram of fat contains 9 calories.
Based on the above information,Tina wants to design a least-cost meal that provides at least 100% of the U.S.RDA of vitamins A,C,B1,B2,niacin,calcium,and iron;supplies at least 55 grams of protein;contains at most 3 grams of sodium;and contains at most 30 percent of its calories from fat.Only those foods list in the table above are available for the meal.
Formulate the LP model for Tina's problem.Develop a spreadsheet model of the problem and use Excel Solver to determine the least-cost meal that meets all the stated requirements.
What is the recommended meal? Is this meal reasonable? If not,modify the model to obtain what you believe to be a reasonable meal that meets the stated requirements.

Accepted Answer

Question 11

A company is planning production for the next 4 quarters.They want to minimize the cost of production.The production cost,demand and production capacity vary from quarter to quarter.The maximum amount of inventory which can be held is 100 units and management wants to keep at least 50 units on hand.Quarterly inventory holding cost is 4% of the cost of production.There are currently 50 units in inventory.The company wants to produce at no less than one half of its maximum capacity in any quarter.
Quarter
 $$\begin{array} { r r r r r } 
&1&2&3&4\
\hline \text { Unit Praduction Cost } & \$ 55 & \$ 50 & \$ 50 & \$ 45 \
\text { Units Demanded } & 100 & 150 & 180 & 120 \
\text { Maramum Production } & 150 & 150 & 160 & 130 \
\text { Holding cost } & \$ 2.2 & \$ 2 & \$ 2 & \$ 1.8
\end{array}$$ 
Let Pi = number of units produced in quarter i,i = 1,... ,4 Bi = beginning inventory for quarter i
MIN: 55 P1 + 50 P 2 + 50 P3 + 45 P4 +
2.2 B1 + B2)/2 + 2 B2 + B3)/2 + 2 B3 + B4)/2 + 1.8 B4 + B5)/2
Subject to: 75 ? P1 ? 150
75 ? P2 ? 150
80 ? P3 ? 160
65 ? P4 ? 130
50 ? B1 + P1 ? 100 ? 100
50 ? B2 + P2 ? 150 ? 100
50 ? B3 + P3 ? 180 ? 100
50 ? B4 + P4 ? 120 ? 100
B2 = B1 + P1 ? 100
B3 = B2 + P2 ? 150
B4 = B3 + P3 ? 180
B5 = B4 + P4 ? 120
Pi,Bi ? 0
   
What formulas are required for cells D3,D6,D8,D15,D17 and D18 in the Excel spreadsheet implementation of the formulation?

Accepted Answer

^D3^=C6 D6 =D3+D4-D5 D8 =D9

Question 12

In the Analytic Solver Platform dialog box simple upper and lower bounds for decision variables are specified by

Accepted Answer

A) referring directly to the decision variable cells in the Constraints-Bound area. 
B) requiring the addition of the bounds above and below the variable cells. 
C) resolving the problem with the bounds added. 
D) incorporating the bounds in the objective function. 
A) referring directly to the decision variable cells in the Constraints-Bound area. 
B) requiring the addition of the bounds above and below the variable cells. 
C) resolving the problem with the bounds added. 
D) incorporating the bounds in the objective function.

Question 13

Exhibit 3.3
The following questions are based on this problem and accompanying Excel windows.
Jack's distillery blends scotches for local bars and saloons.One of his customers has requested a special blend of scotch targeted as a bar scotch.The customer wants the blend to involve two scotch products,call them A and B.Product A is a higher quality scotch while product B is a cheaper brand.The customer wants to make the claim the blend is closer to high quality than the alternative.The customer wants 50 1500 ml bottles of the blend.Each bottle must contain at least 48% of Product A and at least 500 ml of B.The customer also specified that the blend have an alcohol content of at least 85%.Product A contains 95% alcohol while product B contains 78%.The blend is sold for $12.50 per bottle.Product A costs $7 per liter and product B costs $3 per liter.The company wants to determine the blend that will meet the customer's requirements and maximize profit.
Let S1U1P1XS1S1P0S1U1B11 S1U1B0S1U1P1= Number of liters of product A in total blend delivered S1S1P0XS1U1B12 S1U1B0= Number of liters of product B in total blend delivered
MIN: S1U1P17 XS1S1P0S1U1B11 S1U1B0S1U1P1+ 3 XS1S1P0S1U1B12S1U1B0
Subject to: S1U1P1XS1S1P0S1U1B11 S1U1B0S1U1P1+ XS1S1P0S1U1B12 S1U1B0S1U1P1= 1.5 * 50 Total liters of mix)S1S1P0XS1U1B11 S1U1B0≥ 0.48 * 1.5 * 50 XS1U1B11 S1U1B0minimum)
XS1U1B12 S1U1B0≥ 0.5 * 50 XS1U1B12 S1U1B0minimum)
.0.95 XS1U1B11 S1U1B0+ 0.78 XS1U1B12 S1U1B0≥ 0.85 * 1.5 * 50 85% alcohol minimum)XS1U1B11S1U1B0,XS1U1B12 S1U1B0≥ 0
 $$\begin{array} { | l | l | c | c | c | c |} 
\hline & \text { A }  & \mathrm { B } & \mathrm { C } & \mathrm { D } & \mathrm { E } \
\hline 1 & & \begin{array} { c } 
\text { Jacks' } \
\text { Distill } \
\text { ery }
\end{array} & & & \
\hline 2 & & & & & \
\hline 3 & & \mathrm {~A} & \mathrm {~B} & & \
\hline 4 & \text { Liters to use } & & & & \text { Total Cost: } \
\hline 5 & \text { Unit cost: } & 10.5 & 4 & & \
\hline 6 & & 5 & & \
\hline 7 & \text { Constraints: } & & & \text { Supplied } & \text { Requirement } \
\hline \mathbf { 8 } & \text { Total Liters } & 1 & 1 & & 75 \
\hline 9 & \text { A required } & 1 & & & 36 \
\hline 1 & \text { B required } & & 1 & & 25 \
\hline 0 & & & & & \
\hline 1 & \text { 85\% alcohal } & 0.95 & 0.78 & & 63.7 \
1 & & & & & \
\hline
\end{array}$$
-Refer to Exhibit 3.3.What formula should be entered in cell E5 in the accompanying Excel spreadsheet to compute total cost?

Accepted Answer

A) =B4*C4+B5*C5 
B) =SUMPRODUCTB4:C4,B5:C5) 
C) =SUMB5:C5) 
D) =SUME8:E10) 
A) =B4*C4+B5*C5 
B) =SUMPRODUCTB4:C4,B5:C5) 
C) =SUMB5:C5) 
D) =SUME8:E10)

Question 14

Robert Hope received a welcome surprise in this management science class;the instructor has decided to let each person define the percentage contribution to their grade for each of the graded instruments used in the class.These instruments were: homework,an individual project,a mid-term exam,and a final exam.Robert's grades on these instruments were 75,94,85,and 92,respectively.However,the instructor complicated Robert's task somewhat by adding the following stipulations:
• homework can account for up to 25% of the grade,but must be at least 5% of the grade;
• the project can account for up to 25% of the grade,but must be at least 5% of the grade;
• the mid-term and final must each account for between 10% and 40% of the grade but cannot account for more than 70% of the grade when the percentages are combined;and
• the project and final exam grades may not collectively constitute more than 50% of the grade.The following LP model allows Robert to maximize his numerical grade.
Let WS1U1B11S1U1B0= weight assigned to homework WS1U1B12S1U1B0= weight assigned to the project WS1U1B13S1U1B0= weight assigned to the mid-term
WS1U1B14S1U1B0= weight assigned to the final

12 Both Exams 0.65 0.70
13 Final & Project 0.5 0.50
What values would you enter in the Risk Solver Platform RSP)task pane for the cells in this Excel spreadsheet implementation of this problem?
Objective Cell: Variables Cells: Constraints Cells:

Accepted Answer

S1U1B0Objective Cell:
C10
Vari

Question 15

You have been given the following linear programming model and Excel spreadsheet to solve this problem.What cell references would you enter in the Risk Solver Platform RSP)task pane for the following?
Objective Cell:
 Variables Cells: 
Constraints Cells:
 
 $\begin{array}{|l|l|l|l|l|l|} 
\hline& \mathrm{A} & \mathrm{B} & \mathrm{C} & \mathrm{D} & \mathrm{E} \
\hline 1 & & & & & \
\hline 2 & & & & & \
\hline 3 & & \mathrm{X}_{1} & \mathrm{X}_{2} & & \\hline 4 & \text { Number to make: } & & & & \begin{array}{l}
\text { OBJ. FN. } \
\text { VALUE }
\end{array} \
\hline 5 & \text { Unit profit: } & 1 & 9 & & \&&2\\hline 6 & & & & & \
\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\hline 8 & 1 & 9 & 10.5 & & \begin{array}{c}
12 \
6\\end{array} \\hline 9 & 2 & 1 & 0 & & 5 \
\hline 10 & 3 & 0 & 1 & & 6 \
\hline
\end{array}$

Accepted Answer

S1U1B0Objective Cell:
$E$5
Var

Question 16

Exhibit 3.1
The following questions are based on this problem and accompanying Excel windows.
Jones Furniture Company produces beds and desks for college students.The production process requires carpentry and varnishing.Each bed requires 6 hours of carpentry and 4 hour of varnishing.Each desk requires 4 hours of carpentry and 8 hours of varnishing.There are 36 hours of carpentry time and 40 hours of varnishing time available.Beds generate $30 of profit and desks generate $40 of profit.Demand for desks is limited,so at most 8 will be produced.
Let S1U1P1XS1S1P0S1U1B11 S1U1B0S1U1P1= Number of Beds to produce S1S1P0XS1U1B12 S1U1B0= Number of Desks to produce
The LP model for the problem is
MAX: S1U1P130 XS1S1P0S1U1B11 S1U1B0S1U1P1+ 40 XS1S1P0S1U1B12S1U1B0
Subject to: S1U1P16 XS1S1P0S1U1B11 S1U1B0S1U1P1+ 4 XS1S1P0S1U1B12 S1U1B0S1U1P1≤ 36 carpentry)S1S1P0
4 XS1U1B11 S1U1B0+ 8 XS1U1B12 S1U1B0≤ 40 varnishing)XS1U1B12 S1U1B0≤ 8 demand for desks)XS1U1B11S1U1B0,XS1U1B12 S1U1B0≥ 0
 $\begin{array}{|c|c|c|c|c|c|} 
\hline & \mathrm{A} & \mathrm{B} & \mathrm{C} & \mathrm{D} & \mathrm{E} \
\hline 1 & & \text { Jones } & & & \
\text { Furnit } & & & & \
\hline 2 & & \text { ure } & & & \
\hline 3 & & & & & \
\hline 4 & \text { Number to make: } & & & & \text { Total Profit: } \
\hline 5 & \text { Unit profit: } & 30 & 40 & & \
\hline 6 & & & & & \
\hline 7 & \text { Constraints: } & & & \begin{array}{c}
\text { Use } \
\mathrm{d}
\end{array} & \text { Available } \
\hline 8 & \text { Carpentry } & 6 & 4 & & 36 \
\hline 9 & \text { Varnishing } & 4 & 8 & & 40 \
\hline 10 & \text { Desk demand } & & 1 & & 8\
\hline
\end{array}$
-Refer to Exhibit 3.1.What formula should be entered in cell E5 in the accompanying Excel spreadsheet to compute total profit?

Accepted Answer

A) =B4*B5+C4*C5 
B) =SUMPRODUCTB8:C8,$B$4:$C$4) 
C) =SUMB5:C5) 
D) =SUME8:E10) 
A) =B4*B5+C4*C5 
B) =SUMPRODUCTB8:C8,$B$4:$C$4) 
C) =SUMB5:C5) 
D) =SUME8:E10)

Question 17

Carlton construction is supplying building materials for a new mall construction project in Kansas.Their contract calls for a total of 250,000 tons of material to be delivered over a three-week period.Carlton's supply depot has access to three modes of transportation: a trucking fleet,railway delivery,and air cargo transport.Their contract calls for 120,000 tons delivered by the end of week one,80% of the total delivered by the end of week two,and the entire amount delivered by the end of week three.Contracts in place with the transportation companies call for at least 45% of the total delivered be delivered by trucking,at least 40% of the total delivered be delivered by railway,and up to 15% of the total delivered be delivered by air cargo.Unfortunately,competing demands limit the availability of each mode of transportation each of the three weeks to the following levels all in thousands of tons):
 $\begin{array}{cccc}
\text { Week } & \text { Trucking Limits } & \text { Railway Limits } & \text { Air Cargo Limits } \
\hline 1 & 45 & 60 & 15 \
2 & 50 & 55 & 10 \
3 & 55 & 45 & 5 \
\hline \text { Costs } \$ \text { per } 1000 \text { tons) } & \$ 20 & \$ 14 & \$ 40\
&0&0&0
\end{array}$
 
Formulate an LP model for this logistics problem.

Accepted Answer

The answer of Carlton construction is supplying building materials for...

Question 18

Exhibit 3.2
The following questions are based on this problem and accompanying Excel windows.
The Byte computer company produces two models of computers,Plain and Fancy.It wants to plan how many computers to produce next month to maximize profits.Producing these computers requires wiring,assembly and inspection time.Each computer produces a certain level of profits but faces only a limited demand.There are also a limited number of wiring,assembly and inspection hours available in each month.The data for this problem is summarized in the following table.
 $\begin{array}{cccccc} 
& & \text { Maximum } & & \text { Assembly } & \text { Inspection } \
\text { Computer } & \text { Profit per } & \text { demand for } & \text { Wiring Hours } & \text { Hours } & \text { Hours } \
\text { Model } & \text { Model } \$ \text { ) } & \text { product } & \text { Required } & \text { Required } & \text { Required } \
\hline \text { Plain } & 30 & 80 & .4 & .5 & .2 \
\text { Fancy } & 40 & 90 & .5 & .4 & .3 \
\hline&&\text {hours avaible}&50&50&22\
\hline
\end{array}$ Let S1U1P1XS1S1P0S1U1B11 S1U1B0S1U1P1= Number of Plain computers to produce S1S1P0XS1U1B12 S1U1B0= Number of Fancy computers to produce
MAX: S1U1P130 XS1S1P0S1U1B11 S1U1B0S1U1P1+ 40 XS1S1P0S1U1B12S1U1B0
Subject to: S1U1P1.4 XS1S1P0S1U1B11 S1U1B0S1U1P1+ .5 XS1S1P0S1U1B12 S1U1B0S1U1P1≤ 50 wiring hours)S1S1P0
.5 XS1U1B11 S1U1B0+ .4 XS1U1B12 S1U1B0≤ 50 assembly hours)
.2 XS1U1B11 S1U1B0+ .2 XS1U1B12 S1U1B0≤ 22 inspection hours)XS1U1B11 S1U1B0≤ 80 Plain computers demand)XS1U1B12 S1U1B0≤ 90 Fancy computers demand)XS1U1B11S1U1B0,XS1U1B12 S1U1B0≥ 0
 $\begin{array}{|c|c|c|c|c|c|}
\hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } \
\hline 1 & & \begin{array}{c}
\text { Byte } \
\text { Computer } \
\text { Company }
\end{array} & & & \
\hline 2 & & & & & \
\hline 3 & & \text { Plain } & \text { Fancy } & & \
\hline 4 & \text { Number to make: } & & & & \text { Total Profit: } \
\hline 5 & \text { Unit profit: } & 30 & 40 & & \
\hline 6 & & & & & \
\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \
\hline 8 & \text { Wiring } & 0.4 & 0.5 & & 50 \
\hline 9 & \text { Assembly } & 0.5 & 0.4 & & 50 \
\hline 10 & \text { Inspection } & 0.2 & 0.3 & & 22 \
\hline 11 & \text { Plain Demand } & 1 & & & 80 \
\hline 12 & \text { Fancy Demand } & & 1 & & 90 \
\hline
\end{array}$
-Refer to Exhibit 3.2.Which cells should be changing cells in this problem?

Accepted Answer

A) B4:C4 
B) E5 
C) D8:D10 
D) E8:E10 
A) B4:C4 
B) E5 
C) D8:D10 
D) E8:E10

Question 19

The "Objective Value of" option in the Analytic Solver Platform task pane may be used to

Accepted Answer

A) find a solution at a maximum value. 
B) find a solution at a minimum value. 
C) find a solution for a specific objective function value. 
D) returns the best feasible solution. 
A) find a solution at a maximum value. 
B) find a solution at a minimum value. 
C) find a solution for a specific objective function value. 
D) returns the best feasible solution.

Question 20

Exhibit 3.2
The following questions are based on this problem and accompanying Excel windows.
The Byte computer company produces two models of computers,Plain and Fancy.It wants to plan how many computers to produce next month to maximize profits.Producing these computers requires wiring,assembly and inspection time.Each computer produces a certain level of profits but faces only a limited demand.There are also a limited number of wiring,assembly and inspection hours available in each month.The data for this problem is summarized in the following table.
 $\begin{array}{cccccc} 
& & \text { Maximum } & & \text { Assembly } & \text { Inspection } \
\text { Computer } & \text { Profit per } & \text { demand for } & \text { Wiring Hours } & \text { Hours } & \text { Hours } \
\text { Model } & \text { Model } \$ \text { ) } & \text { product } & \text { Required } & \text { Required } & \text { Required } \
\hline \text { Plain } & 30 & 80 & .4 & .5 & .2 \
\text { Fancy } & 40 & 90 & .5 & .4 & .3 \
\hline&&\text {hours avaible}&50&50&22\
\hline
\end{array}$ Let S1U1P1XS1S1P0S1U1B11 S1U1B0S1U1P1= Number of Plain computers to produce S1S1P0XS1U1B12 S1U1B0= Number of Fancy computers to produce
MAX: S1U1P130 XS1S1P0S1U1B11 S1U1B0S1U1P1+ 40 XS1S1P0S1U1B12S1U1B0
Subject to: S1U1P1.4 XS1S1P0S1U1B11 S1U1B0S1U1P1+ .5 XS1S1P0S1U1B12 S1U1B0S1U1P1≤ 50 wiring hours)S1S1P0
.5 XS1U1B11 S1U1B0+ .4 XS1U1B12 S1U1B0≤ 50 assembly hours)
.2 XS1U1B11 S1U1B0+ .2 XS1U1B12 S1U1B0≤ 22 inspection hours)XS1U1B11 S1U1B0≤ 80 Plain computers demand)XS1U1B12 S1U1B0≤ 90 Fancy computers demand)XS1U1B11S1U1B0,XS1U1B12 S1U1B0≥ 0
 $\begin{array}{|c|c|c|c|c|c|}
\hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } \
\hline 1 & & \begin{array}{c}
\text { Byte } \
\text { Computer } \
\text { Company }
\end{array} & & & \
\hline 2 & & & & & \
\hline 3 & & \text { Plain } & \text { Fancy } & & \
\hline 4 & \text { Number to make: } & & & & \text { Total Profit: } \
\hline 5 & \text { Unit profit: } & 30 & 40 & & \
\hline 6 & & & & & \
\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \
\hline 8 & \text { Wiring } & 0.4 & 0.5 & & 50 \
\hline 9 & \text { Assembly } & 0.5 & 0.4 & & 50 \
\hline 10 & \text { Inspection } & 0.2 & 0.3 & & 22 \
\hline 11 & \text { Plain Demand } & 1 & & & 80 \
\hline 12 & \text { Fancy Demand } & & 1 & & 90 \
\hline
\end{array}$
-Refer to Exhibit 3.2.Which cells should be the constraint cells in this problem?

Accepted Answer

A) B4:C4 
B) E5 
C) D8:D12 
D) E8:E12 
A) B4:C4 
B) E5 
C) D8:D12 
D) E8:E12

Microsoft Excel contains a built-in optimizer called

The "Analyze Without Solving" tool in Analytic Solver Platform is useful for

What function is used to add the contents of cells A1,A2 and A3?

Scaling problems

What action is required to make Analytic Solver Platform ASP)solve a specified problem?

In the Analytic Solver Platform dialog box simple upper and lower bounds for decision variables are specified by

The "Objective Value of" option in the Analytic Solver Platform task pane may be used to

Introduction to Modeling and Decision Analysis

Introduction to Optimization and Linear Programming

Sensitivity Analysis and the Simplex Method

Network Modeling

Integer Linear Programming

Goal Programming and Multiple Objective Optimization

Nonlinear Programming and Evolutionary Optimization

Regression Analysis

Data Mining

Time Series Forecasting

Introduction to Simulation Using Analytic Solver Platform

Queuing Theory

Decision Analysis

Project Management Online

Filters

Exam 3: Modeling and Solving Lp Problems in a Spreadsheet

Microsoft Excel contains a built-in optimizer called

The "Analyze Without Solving" tool in Analytic Solver Platform is useful for

What function is used to add the contents of cells A1,A2 and A3?

Scaling problems

What action is required to make Analytic Solver Platform ASP)solve a specified problem?

In the Analytic Solver Platform dialog box simple upper and lower bounds for decision variables are specified by

The "Objective Value of" option in the Analytic Solver Platform task pane may be used to

Introduction to Modeling and Decision Analysis

Introduction to Optimization and Linear Programming

Sensitivity Analysis and the Simplex Method

Network Modeling

Integer Linear Programming

Goal Programming and Multiple Objective Optimization

Nonlinear Programming and Evolutionary Optimization

Regression Analysis

Data Mining

Time Series Forecasting

Introduction to Simulation Using Analytic Solver Platform

Queuing Theory

Decision Analysis

Project Management Online

Filters