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.Which of the following statements represent the carpentry,varnishing and limited demand for desks constraints?

A) B4:C4 ? B5:C5 B) E5 ? 0 C) D8:D10 ? E8:E10 D) E8:E10 ? D8:D10 A) B4:C4 ? B5:C5 B) E5 ? 0 C) D8:D10 ? E8:E10 D) E8:E10 ? D8:D10 C

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.Which cells should be the constraint cells in this problem?

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

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.Which cells should be changing cells in this problem?

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

Exhibit 3.5 The following questions are based on this problem and accompanying Excel windows. A company is planning production for the next 4 quarters.They want to minimize the cost of production.The production cost is stable but demand and production capacity vary from quarter to quarter.The maximum amount of inventory which can be held is 12,000 units and management wants to keep at least 3,000 units on hand.Quarterly inventory holding cost is 3% of the cost of production.The company estimates the number of units carried in inventory each month by averaging the beginning and ending inventory for each month.There are currently 5,000 units in inventory.The company wants to produce at no less than one half of its maximum capacity in any quarter. \[\begin{array}{l} \begin{array} { l r r r r r } &&\text { Quarter }\\ & { 1 } & 2 & { 3 } & { 4 } \\ \hline \text { Unit Production Cost } & \$ 300 & \$ 300 & \$ 300 & \mathbf { \$ 3 0 0 } \\ \text { Units Demanded } & 2,000 & 9,000 & 12,000 & 11,000 \\ \text { Marimum Production } & 8,000 & 7,000 & 8,000 & 9,000 \end{array} \end{array}\] Let S1U1P1PS1S1P0S1U1B1i S1U1B0S1U1P1= number of units produced in quarter i,i = 1,... ,4 S1S1P0BS1U1B1i S1U1B0= beginning inventory for quarter i MIN: S1U1P1300 PS1S1P0S1U1B11 S1U1B0S1U1P1+ 300 PS1S1P0S1U1B12 S1U1B0S1U1P1+ 300 PS1S1P0S1U1B13 S1U1B0S1U1P1+ 300 PS1S1P0S1U1B14 S1U1B0S1U1P1+S1S1P0 9BS1U1B11 S1U1B0+ BS1U1B12S1U1B0)/2 + 9BS1U1B12 S1U1B0+ BS1U1B13S1U1B0)/2 + 9BS1U1B13 S1U1B0+ BS1U1B14S1U1B0)/2 + 9BS1U1B14 S1U1B0+ BS1U1B15S1U1B0)/2 Subject to: S1U1P14000 ≤ PS1S1P0S1U1B11 S1U1B0S1U1P1≤ 8000S1S1P0 3500 ≤ PS1U1B12 S1U1B0≤ 7000 4000 ≤ PS1U1B13 S1U1B0≤ 8000 4500 ≤ PS1U1B14 S1U1B0≤ 9000 3000 ≤ BS1U1B11 S1U1B0+ PS1U1B11 S1U1B0− 2000 ≤ 12000 3000 ≤ BS1U1B12 S1U1B0+ PS1U1B12 S1U1B0− 9000 ≤ 12000 3000 ≤ BS1U1B13 S1U1B0+ PS1U1B13 S1U1B0− 12000 ≤ 12000 3000 ≤ BS1U1B14 S1U1B0+ PS1U1B14 S1U1B0− 11000 ≤ 12000 BS1U1B12 S1U1B0= BS1U1B11 S1U1B0+ PS1U1B11 S1U1B0− 2000 BS1U1B13 S1U1B0= BS1U1B12 S1U1B0+ PS1U1B12 S1U1B0− 9000 BS1U1B14 S1U1B0= BS1U1B13 S1U1B0+ PS1U1B13 S1U1B0− 12000 BS1U1B15 S1U1B0= BS1U1B14 S1U1B0+ PS1U1B14 S1U1B0− 11000 PS1U1B1iS1U1B0,BS1U1B1i S1U1B0≥ 0 $\begin{array}{|c|l|c|c|c|c|c|} \hline&A&B&C&D&E&F\\ \hline 1&&&\text { Quarter }\\ \hline 2 & & & 1 & 2 & 3 & 4 \\ \hline 3 & \text { Beginning Inventory } & & 5,000 & 11,000 & \begin{array}{c} 9,000 \\ \end{array} & \begin{array}{c} 5,000 \\ \end{array} \\ \hline 4 & \text { Units Produced } & & 8,000 & \begin{array}{c} 7,000 \\ \end{array} & \begin{array}{c} 8,000 \\ \end{array} & \begin{array}{c} 9,000 \\ \end{array} \\ \hline 5 & \text { Units Demanded } & & 2,000 & \begin{array}{c} 9,000 \\ \end{array} & 12,000 & 11,000 \\ \hline 6 & \text { Ending Inventory } & & 11,000 & \begin{array}{c} 9,000 \\ \end{array} & \begin{array}{c} 5,000 \\ \end{array} & \begin{array}{c} 3,000 \\ \end{array} \\\hline 7\\ \hline 8 & \text { Minimum Production } & & 4,000 & 3,500 & 4,000 & 4,500 \\ \hline 9 & \text { Maximum Production } & & 8,000 & 7,000 & 8,000 & 9,000 \\\hline10\\ \hline11& \text { Minimum Inventory } && 3,000 & 3,000 & 3,000 & 3,000 \\ \hline \end{array}$ $\begin{array}{|c|l|c|c|c|c|c|} \hline12 & \text { Maximum Inventory } & & 12,000 & 12,000 & 12,000 & 12,000 \\ \hline 13 & & & & & & \\ \hline 14 & \text { Unit Production Cost } & & \$ 300 & \$ 300 & \$ 300 & \$ 300\\ \hline 15 & \text { Unit Carrying Cost } & 3.00 \% & \$ 9.00 & \$ 9.00 & \$ 9.00 & \$ 9.00 \\\hline16\\ \hline 17 & \text { Quarterly Production Cost } & & \$ 2,400,000 & \$ 2,100,000 & \$ 2,400,000 & \$ 2,700,000 \\ \hline 18 & \text { Quarterly Carrying Cost } & & \$ 72,000 & \$ 90,000 & \$ 63,000 & \$ 36,000 \\ \hline 19 & & & & & & \\ \hline 20 & & & & & \text { Total Cost } & \$ 9,861,000 \\ \hline \end{array}$ -Refer to Exhibit 3.5.What formula should be entered in cell C18 in the accompanying Excel spreadsheet to compute the quarterly carrying costs?

A) =C15*C3+C6 B) =C15*C3+C6) C) =C15*C3/2 D) =C15*C3+C6)/2 A) =C15*C3+C6 B) =C15*C3+C6) C) =C15*C3/2 D) =C15*C3+C6)/2

Exhibit 3.5 The following questions are based on this problem and accompanying Excel windows. A company is planning production for the next 4 quarters.They want to minimize the cost of production.The production cost is stable but demand and production capacity vary from quarter to quarter.The maximum amount of inventory which can be held is 12,000 units and management wants to keep at least 3,000 units on hand.Quarterly inventory holding cost is 3% of the cost of production.The company estimates the number of units carried in inventory each month by averaging the beginning and ending inventory for each month.There are currently 5,000 units in inventory.The company wants to produce at no less than one half of its maximum capacity in any quarter. \[\begin{array}{l} \begin{array} { l r r r r r } &&\text { Quarter }\\ & { 1 } & 2 & { 3 } & { 4 } \\ \hline \text { Unit Production Cost } & \$ 300 & \$ 300 & \$ 300 & \mathbf { \$ 3 0 0 } \\ \text { Units Demanded } & 2,000 & 9,000 & 12,000 & 11,000 \\ \text { Marimum Production } & 8,000 & 7,000 & 8,000 & 9,000 \end{array} \end{array}\] Let S1U1P1PS1S1P0S1U1B1i S1U1B0S1U1P1= number of units produced in quarter i,i = 1,... ,4 S1S1P0BS1U1B1i S1U1B0= beginning inventory for quarter i MIN: S1U1P1300 PS1S1P0S1U1B11 S1U1B0S1U1P1+ 300 PS1S1P0S1U1B12 S1U1B0S1U1P1+ 300 PS1S1P0S1U1B13 S1U1B0S1U1P1+ 300 PS1S1P0S1U1B14 S1U1B0S1U1P1+S1S1P0 9BS1U1B11 S1U1B0+ BS1U1B12S1U1B0)/2 + 9BS1U1B12 S1U1B0+ BS1U1B13S1U1B0)/2 + 9BS1U1B13 S1U1B0+ BS1U1B14S1U1B0)/2 + 9BS1U1B14 S1U1B0+ BS1U1B15S1U1B0)/2 Subject to: S1U1P14000 ≤ PS1S1P0S1U1B11 S1U1B0S1U1P1≤ 8000S1S1P0 3500 ≤ PS1U1B12 S1U1B0≤ 7000 4000 ≤ PS1U1B13 S1U1B0≤ 8000 4500 ≤ PS1U1B14 S1U1B0≤ 9000 3000 ≤ BS1U1B11 S1U1B0+ PS1U1B11 S1U1B0− 2000 ≤ 12000 3000 ≤ BS1U1B12 S1U1B0+ PS1U1B12 S1U1B0− 9000 ≤ 12000 3000 ≤ BS1U1B13 S1U1B0+ PS1U1B13 S1U1B0− 12000 ≤ 12000 3000 ≤ BS1U1B14 S1U1B0+ PS1U1B14 S1U1B0− 11000 ≤ 12000 BS1U1B12 S1U1B0= BS1U1B11 S1U1B0+ PS1U1B11 S1U1B0− 2000 BS1U1B13 S1U1B0= BS1U1B12 S1U1B0+ PS1U1B12 S1U1B0− 9000 BS1U1B14 S1U1B0= BS1U1B13 S1U1B0+ PS1U1B13 S1U1B0− 12000 BS1U1B15 S1U1B0= BS1U1B14 S1U1B0+ PS1U1B14 S1U1B0− 11000 PS1U1B1iS1U1B0,BS1U1B1i S1U1B0≥ 0 $\begin{array}{|c|l|c|c|c|c|c|} \hline&A&B&C&D&E&F\\ \hline 1&&&\text { Quarter }\\ \hline 2 & & & 1 & 2 & 3 & 4 \\ \hline 3 & \text { Beginning Inventory } & & 5,000 & 11,000 & \begin{array}{c} 9,000 \\ \end{array} & \begin{array}{c} 5,000 \\ \end{array} \\ \hline 4 & \text { Units Produced } & & 8,000 & \begin{array}{c} 7,000 \\ \end{array} & \begin{array}{c} 8,000 \\ \end{array} & \begin{array}{c} 9,000 \\ \end{array} \\ \hline 5 & \text { Units Demanded } & & 2,000 & \begin{array}{c} 9,000 \\ \end{array} & 12,000 & 11,000 \\ \hline 6 & \text { Ending Inventory } & & 11,000 & \begin{array}{c} 9,000 \\ \end{array} & \begin{array}{c} 5,000 \\ \end{array} & \begin{array}{c} 3,000 \\ \end{array} \\\hline 7\\ \hline 8 & \text { Minimum Production } & & 4,000 & 3,500 & 4,000 & 4,500 \\ \hline 9 & \text { Maximum Production } & & 8,000 & 7,000 & 8,000 & 9,000 \\\hline10\\ \hline11& \text { Minimum Inventory } && 3,000 & 3,000 & 3,000 & 3,000 \\ \hline \end{array}$ $\begin{array}{|c|l|c|c|c|c|c|} \hline12 & \text { Maximum Inventory } & & 12,000 & 12,000 & 12,000 & 12,000 \\ \hline 13 & & & & & & \\ \hline 14 & \text { Unit Production Cost } & & \$ 300 & \$ 300 & \$ 300 & \$ 300\\ \hline 15 & \text { Unit Carrying Cost } & 3.00 \% & \$ 9.00 & \$ 9.00 & \$ 9.00 & \$ 9.00 \\\hline16\\ \hline 17 & \text { Quarterly Production Cost } & & \$ 2,400,000 & \$ 2,100,000 & \$ 2,400,000 & \$ 2,700,000 \\ \hline 18 & \text { Quarterly Carrying Cost } & & \$ 72,000 & \$ 90,000 & \$ 63,000 & \$ 36,000 \\ \hline 19 & & & & & & \\ \hline 20 & & & & & \text { Total Cost } & \$ 9,861,000 \\ \hline \end{array}$ -Refer to Exhibit 3.5.What formula could be entered in cell F20 in the accompanying Excel spreadsheet to compute the Total Cost for all four quarters?

A) SUMPRODUCT$C$4:$F$4,C17:F17) B) SUMC17:F17)+ SUMC18:F18) C) PRODUCTSUMC14:F15,C17:F18) D) SUMPRODUCTC4:F4,C14:F14)+ SUMPRODUCTC6:F6,C15:F15) A) SUMPRODUCT$C$4:$F$4,C17:F17) B) SUMC17:F17)+ SUMC18:F18) C) PRODUCTSUMC14:F15,C17:F18) D) SUMPRODUCTC4:F4,C14:F14)+ SUMPRODUCTC6:F6,C15:F15)

Exhibit 3.5 The following questions are based on this problem and accompanying Excel windows. A company is planning production for the next 4 quarters.They want to minimize the cost of production.The production cost is stable but demand and production capacity vary from quarter to quarter.The maximum amount of inventory which can be held is 12,000 units and management wants to keep at least 3,000 units on hand.Quarterly inventory holding cost is 3% of the cost of production.The company estimates the number of units carried in inventory each month by averaging the beginning and ending inventory for each month.There are currently 5,000 units in inventory.The company wants to produce at no less than one half of its maximum capacity in any quarter. \[\begin{array}{l} \begin{array} { l r r r r r } &&\text { Quarter }\\ & { 1 } & 2 & { 3 } & { 4 } \\ \hline \text { Unit Production Cost } & \$ 300 & \$ 300 & \$ 300 & \mathbf { \$ 3 0 0 } \\ \text { Units Demanded } & 2,000 & 9,000 & 12,000 & 11,000 \\ \text { Marimum Production } & 8,000 & 7,000 & 8,000 & 9,000 \end{array} \end{array}\] Let S1U1P1PS1S1P0S1U1B1i S1U1B0S1U1P1= number of units produced in quarter i,i = 1,... ,4 S1S1P0BS1U1B1i S1U1B0= beginning inventory for quarter i MIN: S1U1P1300 PS1S1P0S1U1B11 S1U1B0S1U1P1+ 300 PS1S1P0S1U1B12 S1U1B0S1U1P1+ 300 PS1S1P0S1U1B13 S1U1B0S1U1P1+ 300 PS1S1P0S1U1B14 S1U1B0S1U1P1+S1S1P0 9BS1U1B11 S1U1B0+ BS1U1B12S1U1B0)/2 + 9BS1U1B12 S1U1B0+ BS1U1B13S1U1B0)/2 + 9BS1U1B13 S1U1B0+ BS1U1B14S1U1B0)/2 + 9BS1U1B14 S1U1B0+ BS1U1B15S1U1B0)/2 Subject to: S1U1P14000 ≤ PS1S1P0S1U1B11 S1U1B0S1U1P1≤ 8000S1S1P0 3500 ≤ PS1U1B12 S1U1B0≤ 7000 4000 ≤ PS1U1B13 S1U1B0≤ 8000 4500 ≤ PS1U1B14 S1U1B0≤ 9000 3000 ≤ BS1U1B11 S1U1B0+ PS1U1B11 S1U1B0− 2000 ≤ 12000 3000 ≤ BS1U1B12 S1U1B0+ PS1U1B12 S1U1B0− 9000 ≤ 12000 3000 ≤ BS1U1B13 S1U1B0+ PS1U1B13 S1U1B0− 12000 ≤ 12000 3000 ≤ BS1U1B14 S1U1B0+ PS1U1B14 S1U1B0− 11000 ≤ 12000 BS1U1B12 S1U1B0= BS1U1B11 S1U1B0+ PS1U1B11 S1U1B0− 2000 BS1U1B13 S1U1B0= BS1U1B12 S1U1B0+ PS1U1B12 S1U1B0− 9000 BS1U1B14 S1U1B0= BS1U1B13 S1U1B0+ PS1U1B13 S1U1B0− 12000 BS1U1B15 S1U1B0= BS1U1B14 S1U1B0+ PS1U1B14 S1U1B0− 11000 PS1U1B1iS1U1B0,BS1U1B1i S1U1B0≥ 0 $\begin{array}{|c|l|c|c|c|c|c|} \hline&A&B&C&D&E&F\\ \hline 1&&&\text { Quarter }\\ \hline 2 & & & 1 & 2 & 3 & 4 \\ \hline 3 & \text { Beginning Inventory } & & 5,000 & 11,000 & \begin{array}{c} 9,000 \\ \end{array} & \begin{array}{c} 5,000 \\ \end{array} \\ \hline 4 & \text { Units Produced } & & 8,000 & \begin{array}{c} 7,000 \\ \end{array} & \begin{array}{c} 8,000 \\ \end{array} & \begin{array}{c} 9,000 \\ \end{array} \\ \hline 5 & \text { Units Demanded } & & 2,000 & \begin{array}{c} 9,000 \\ \end{array} & 12,000 & 11,000 \\ \hline 6 & \text { Ending Inventory } & & 11,000 & \begin{array}{c} 9,000 \\ \end{array} & \begin{array}{c} 5,000 \\ \end{array} & \begin{array}{c} 3,000 \\ \end{array} \\\hline 7\\ \hline 8 & \text { Minimum Production } & & 4,000 & 3,500 & 4,000 & 4,500 \\ \hline 9 & \text { Maximum Production } & & 8,000 & 7,000 & 8,000 & 9,000 \\\hline10\\ \hline11& \text { Minimum Inventory } && 3,000 & 3,000 & 3,000 & 3,000 \\ \hline \end{array}$ $\begin{array}{|c|l|c|c|c|c|c|} \hline12 & \text { Maximum Inventory } & & 12,000 & 12,000 & 12,000 & 12,000 \\ \hline 13 & & & & & & \\ \hline 14 & \text { Unit Production Cost } & & \$ 300 & \$ 300 & \$ 300 & \$ 300\\ \hline 15 & \text { Unit Carrying Cost } & 3.00 \% & \$ 9.00 & \$ 9.00 & \$ 9.00 & \$ 9.00 \\\hline16\\ \hline 17 & \text { Quarterly Production Cost } & & \$ 2,400,000 & \$ 2,100,000 & \$ 2,400,000 & \$ 2,700,000 \\ \hline 18 & \text { Quarterly Carrying Cost } & & \$ 72,000 & \$ 90,000 & \$ 63,000 & \$ 36,000 \\ \hline 19 & & & & & & \\ \hline 20 & & & & & \text { Total Cost } & \$ 9,861,000 \\ \hline \end{array}$ -Refer to Exhibit 3.5.Which cells are changing cells in the accompanying Excel spreadsheet?

A) C4:F4 B) C9:F9 C) F20 D) C12:F12 A) C4:F4 B) C9:F9 C) F20 D) C12:F12

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 D11 in the accompanying Excel spreadsheet to compute the total liters of alcohol supplied?

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

Exam 3: Modeling and Solving Lp Problems in a Spreadsheet

A farmer is planning his spring planting.He has 20 acres on which he can plant a combination of Corn,Pumpkins and Beans.He wants to maximize his profit but there is a limited demand for each crop.Each crop also requires fertilizer and irrigation water which are in short supply.There are only 50 acre ft of irrigation available and only 8,000 pounds/acre of fertilizer available.The following table summarizes the data for the problem. $\begin{array}{l|clccc}&\text { Profit per } & \text { Yield per } & \text { Maximum } & \text { Irrigation } & \text { Fertilizer } \\\text { Crop }&\text { Acre } \$) & \text { Acre } 1 \mathrm{~b} \text { ) } & \text { Demand } \mathrm{lb} \text { ) } & \text { acre } \mathrm{ft}) & \text { pounds/acre) }\\\hline\text { Corn } & 2,100 & 21,000 & 200,000 & 2 & 500 \\\text { Pumpkin } & 900 & 10,000 & 180,000 & 3 & 400 \\\text { Beans } & 1,050 & 3,500 & 80,000 & 1 & 300\end{array}$ Enter the numbers in the appropriate cells of ranges B12:D12 and E8:F12 in the Excel spreadsheet to solve this problem based on the following formulation. Let ^X₁^{= aces of corn} X₂= acres of pumpkin X₃= acres of beans MAX: ^2100X₁^{+ 900X}₂^{+ 1050X}₃ Subject to: ^21X₁^{≤ 200} 10X₂≤ 180 3.5X₃≤ 80 X₁+ X₂+ X₃≤ 20 2X₁+ 3X₂+ 1X₃≤ 50 5X₁+ 4X₂+ 3X₃≤ 80 X₁,X₂,X₃≥ 0 A B C D E F 1 Farm Planning Problem 2 3 Corn Pumplin Beans 4 Acres to plant Total Profit: 5 Profit per acre 6 7 Constraints: Used Available 8 Corn demand 9 Pumpkin demand 10 Bean demand 11 Water 12 Fertilizer

Free

(Essay)

4.7/5

(41)

Question 1

Correct Answer:

Verified

$\begin{array}{|c|c|c|c|c|c|c|} \hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } & \text { F } \\\hline 1 & & \text { Farm } & \text { Planning } & \text { Problem } & & \\\hline 2 & & & & & & \\\hline 3 & & \text { Corn } & \text { Pumplin } & \text { Beans } & & \\\hline 4 & \text { Acres to plant } & & & & & \text { Total Profit: } \\\hline 5 & \text { Profit per acre } & 210 & 900 & 105 & & \\& & 0 & & 0 & & \\\hline 6 & & & & & & \\\hline 7 & \text { Constraints: } & & & & \text { Used } & \text { Available } \\\hline 8 & \text { Corn demand } & 21000 & & & & \begin{array}{c}20000 \\0\end{array} \\\hline 9 & \text { Pumpkin demand } & & 10000 & & & \begin{array}{c}18000 \\0\end{array} \\\hline 10 & \text { Bean demand } & & & \begin{array}{c}350 \\0\end{array} & & 80000 \\\hline 11 & \text { Water } & 2 & 3 & 1 & & 50 \\\hline 12 & \text { Fertilizer } & 500 & 400 & 300 & & 8000 \\\hline\end{array}$