Final Exam Review

Mod C: Transportation Models Step 1: Enter the Unit Cost of Moving from Origin 'i' to Destination 'j', Supply at 'i', and Cost Table Newark St. Louis Denver Seattle Portland 101 85 75 45 New Orleans 87 65 85 92 Raleigh 65 77 83 115 Dummy Origin 5 Demand at Destination 330 375 405 265 Step 2: Open the Solver from 'Data' tab in the Top Ribbon and click 'Solve'. Volume Table Dest 1 Dest 2 Dest 3 Dest 4 Origin 1 0 0 135 265 Origin 2 0 350 0 0 Origin 3 300 0 0 0 Origin 4 30 25 270 0 Origin 5 0 0 0 0 Column Total 330 375 405 265 Demand at Destination 330 375 405 265 Total Transportation Cost 64300 1). Tunai enterprise manufacturers fishing equipment. Use the Neward, DE St. Louis, MO Denver, CO Portland, OR $ 101.00 $ 85.00 $ 75.00 New Orleans, LA $ 87.00 $ 65.00 $ 85.00 Raleigh, NC $ 65.00 $ 77.00 $ 83.00 Supply 330 375 405 a). Is the problem balanced No If so/not, which b). What is the total transportation cost? $ 64,300.00

d Demand at 'j' Dest 5 Supply at Origin 400 350 300 325 1375 \ 1375 Dest 5 Row Total Supply at Origin 0 400 400 0 350 350 0 300 300 0 325 325 0 0 0 0 0 following table to find the total shipping costs from each manufacturing facility to their 4 warehous Seattle, WA Capacity $ 45.00 400 $ 92.00 350 $ 115.00 300 265 h area needs to be balanced? Supply by 325

Mod C: Transportation Models Step 1: Enter the Unit Cost of Moving from Origin 'i' to Destination 'j', Supply at 'i', and Cost Table Newark St. Louis Denver Seattle Portland 101 85 75 45 New Orleans 87 65 85 92 Raleigh 65 77 83 115 Dummy Origin 5 Demand at Destination 330 375 405 265 Step 2: Open the Solver from 'Data' tab in the Top Ribbon and click 'Solve'. Volume Table Dest 1 Dest 2 Dest 3 Dest 4 Origin 1 0 0 135 265 Origin 2 0 280 70 0 Origin 3 205 95 0 0 Origin 4 125 0 200 0 Origin 5 0 0 0 0 Column Total 330 375 405 265 Demand at Destination 330 375 405 265 Total Transportation Cost 66840 c). What if 95 units needs to be shipped from Raleigh to St. Lo d). Based on your answer to c)., were all demand levels met?

d Demand at 'j' Dest 5 Supply at Origin 400 350 300 325 1375 \ 1375 Dest 5 Row Total Supply at Origin 0 400 400 0 350 350 0 300 300 0 325 325 0 0 0 0 0 ouis, what would the total transportation cost be? $ 66,840.00 Yes If so/not, what warehouse(s) were backordered?

e). Were all demand levels met?All demand levels were met f). Was all supply exhausted? If so, which sites?

n Models d Demand at 'j' Dummy Dest 5 Supply at Origin 300 250 280 30 830 \ 830 Dummy Dest 5 Row Total Supply at Origin 30 300 300 250 250 280 280 0 0 0 0 30 0 30 0 od and answer the following: SaddleBrook Supply $ 27.00 300 $ 19.00 250 $ 18.00 280 300 llway to Plainfield? 225 enna to Cranbury? 275 llway to Saddlebrook? 45 $ 15,405.00

MOD B: LINEAR PROGRAMMING - 3 variable Step 1: Enter the LP model: nuggets mini-nuggets chips RHS Profits 5.50 4.25 6.75 pine bark 2.00 2.50 3.00 400 machine time 2.00 1.00 2.00 440 labor time 3.00 2.00 1.00 475 mini nug required 1.00 40 chips required 1.00 30 Step 2: Calculate the LHS in Constraints nuggets mini-nuggets chips LHS pine bark 2 2.5 3 400 machine time 2 1 2 310 labor time 3 2 1 425 mini nug required 0 1 0 40 chips required 0 0 1 30 Step 3: Run the Solver from the 'Data' tab in the Top Ribbon Optimal Solution x1 x2 x3 Profit 105.00 40.00 30.00 950.00 3). A garden store prepares various grades of pine bark for mulch: nugget The mulchingprocess requires pine bark (400 pounds available), machine Each bag of nuggets requires 2 pounds of bark, 2 minutes of machine tim Each bag of chips requires 3 pounds of bark, 2 minutes of machine time, a a). How many bags of each type of mulch should be made to maximize pr b). What is the optimal profit? 950.00 c). For this solution, what is the marginal value (shadow price) of pine bar d). What is the marginal value (shadow price) of machine time? e). What impact would decreasing labor hours by 30 have on the overall p

e Maximization problem Variable Cells Final Reduced Objective Cell Name Value Cost Coefficient Objective Function $B$22 x1 105 0 5.5 $C$22 x2 40 0 4.25 $D$22 x3 30 0 6.75 Constraints Final Shadow Constraint Cell Name Value Price R.H. Side $E$14 pine bark 400 2.75 400 RHS $E$15 machine t 310 0 440 400 $E$16 labor time 425 0 475 440 $E$17 mini nug r 40 -2.625 40 475 $E$18 chips requ 30 -1.5 30 40 30 ts, mini-nuggets, and chips, with profits of $5.50, $4.25, and $6.75 per bag respectively. e time (440 minutes available), labor time (475 minutes available). me, and 3 minutes of labor. Each bag of mini-nuggets requires 2.5 pounds of bark, 1 minute of machine time, and and 1 minute of labor. The garden store is commited to producing atleast 30 bags of chips and 40 bags of mini- rofit? Nuggets = 105.00 Mini-nuggets = 40.00 Chips = 30.00 rk? 2.75 0 profit? there would be no impact on profit

Microsoft Excel 16.0 Sensitivity Report Worksheet: [Final Exam Review.xlsx]3-variable_Max Report Created: 12/8/2023 2:25:56 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$22:$D$22 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$14 Constraint 1 LHS 400 2.75 400 33.33333333 210 $E$15 Constraint 2 LHS 310 0 440 1E+030 130 $E$16 Constraint 3 LHS 425 0 475 1E+030 50 $E$17 Constraint 4 LHS 40 -2.625 40 84 28.57142857 $E$18 Constraint 5 LHS 30 -1.5 30 70 14.28571429

MOD B: LINEAR PROGRAMMING - 2 variable Minimizatio Step 1: Enter the LP model 1 2 Capacity (RHS) Costs 22,000.00 34,000.00 Objective Function HIGH 410.00 480.00 38000 MID 320.00 450.00 32000 LOW 220.00 390.00 29000 refinery 1 req 1.00 45 Constraint 5 Step 2: Calculate the LHS in Constraints (Current Usage) 1 2 Current Usage (LHS) Capacity (RHS) HIGH 410 480 41957.6923076923 38000 MID 320 450 36438.4615384615 32000 LOW 220 390 29000 29000 refinery 1 req 1 0 45 45 Constraint 5 0 0 0 0 Step 3: Run the Solver from the 'Data' tab in the Top Ribbon Optimal Solution x1 x2 Costs 45 48.97435897 $2,655,128.21 2,611,538.46 *cost for low but 500 *cost for e* 4). Noble Energy, located in Houston Texas, a small petroleum company, ow Refinery 1 costs $22,000 per day to operate, and it can produce 410 barrels o Refinery 1 (because of employee contractual commitments) needs to operate Refinery 2 is newer and more modern. It costs $34,000 per day to operate, a The company has orders totaling 38,000 barrels of high-grade oil, 32,000 ba How many days should it run each refinery to minimize its costs and still ref a). This is a minimization problem. b). How many days should it run each refinery to minimize its costs and still Refinery 1 45 Refinery 2 49 c). What is the optimal cost? $2,655,128.21 d). Are there any unused resources (capacity)? NO

on problem 0 less* wns two refineries. of high-grade oil, 320 barrels of medium-grade oil, and 220 barrels of low-grade oil each day. e at least 45 days. and it can produce 480 barrels of high-grade oil, 450 barrels of medium-grade oil, and 390 barrels of low arrels of medium-grade oil, and 29,000 barrels of low-grade oil. fine enough oil to meet its orders? l refine enough oil to meet its orders during there 4-month planning period? If so/not, what constraint and how much or not? None, there are no unused resources

sed by 500 barrels? cost would decrease by $43,589.75

MOD B: LINEAR PROGRAMMING - 2 variable Minimizatio Step 1: Enter the LP model 1 2 Capacity (RHS) Costs 22,000.00 34,000.00 Objective Function HIGH 410.00 480.00 38000 MID 320.00 450.00 32000 LOW 220.00 390.00 28500 refinery 1 1.00 45 Constraint 5 Step 2: Calculate the LHS in Constraints (Current Usage) x1 x2 Current Usage (LHS) Capacity (RHS) Constraint 1 410 480 41342.3076923077 38000 Constraint 2 320 450 35861.5384615385 32000 Constraint 3 220 390 28500 28500 Constraint 4 1 0 45 45 Constraint 5 0 0 0 0 Step 3: Run the Solver from the 'Data' tab in the Top Ribbon Optimal Solution x1 x2 Costs 45 47.69230769 $2,611,538.46 $ 2,655,128.21

on problem e). What impact would there be if the demand for low-grad