Decision variables Cost/pound Feed 1 Feed 2 Feed 3 Feed 4 4500 2000 0 1500 $ 0.25 $ 0.30 $ 0.32 $ 0.15 Corn Grain Minreals 30% 10% 20% Total Cost 1950 5% 30% 20% 20% 15% 20% 10% 10% 30% Total 8000 LHS 1600 1200 1750 = Required 8000 >= >= >= RHS 1600 1200 1200 Company Investment Maximum amount 25% return Years to Maturity 1 112,500 $ 187,500 8.65% 11 2 75,000 $ 187,500 9.50% 10 3 187,500 $ 187,500 10.00% 6 4 187,500 $ 187,500 8.75% 10 5 0 $ 187,500 9.25% 7 6 187,500 $ 187,500 9.00% 13 Total Invested $ Total available 750,000 750,000 Profit $ 68,887.50 Total Half of the money 10+ years? (yes=1, no=0) Rating High rating? (1=no, 0=yes) 1 1-Excellent 0 1 3-Good 1 0 4-Fair 1 1 1-Excellent 0 0 3-Good 1 1 2-Very Good 0 $ 562,500 375,000 Total $ 35% of money 262,500 262,500 Tellers Salary 9 a.m.-10 a.m. 10 a.m.-11 a.m. 11 a.m.-Noon Noon-1 p.m. 1 p.m.-2 p.m. 2 p.m.-3 p.m. 3 p.m.-4 p.m. 4 p.m.-5 p.m. Max full time part time limit F 10 $ P1 0 90 $ P2 7 28 $ P3 2 28 $ P4 5 28 $ P5 0 28 $ 28 1 1 1 1 1 0.5 1 1 1 0.5 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 4 4 4 4 4 Total Saraly $ 1,292 10 >= 10 17 >= 12 14 >= 14 19 >= 16 24 >= 18 17 >= 17 15 >= 15 10 >= 10 10 56 <= <= 12 56 1 2 3 4 5 6 Beginning Inventory unit produced Unit demanded Ending Inventory 2,750 4,000 1,000 5,750 5,750 3,500 4,500 4,750 4,750 4,000 6,000 2,750 2,750 4,250 5,500 1,500 1,500 4,000 3,500 2,000 2,000 3,500 4,000 1,500 Maximum Production Minimum Production 4,000 2,000 3,500 1,750 4,000 2,000 4,500 2,250 4,000 2,000 3,500 1,750 Minimum Inventory Maximum Inventory 1,500 6,000 1,500 6,000 1,500 6,000 1,500 6,000 ### ### ### ### Production cost Inventory carrying cost $ $ 240 $ 3.60 $ 250 $ 3.75 $ 265 $ 3.98 $ 285 $ 4.28 $ 280 $ 4.20 $ 260 3.90 Monthly Production cost Monthly Inventory carring cost $ $ 960,000 $ 15,300 $ 875,000 $ 19,688 $ 1,060,000 $ 14,906 $ 1,211,250 $ 9,084 $ 1,120,000 $ 7,350 $ 910,000 6,825 Total Cost $ 6,209,403.1 BA 3623 - Management Science - Assignment #1 DUE DATE: June 08, 2016 at 3:30pm You should submit all your Excel files through D2L. Question 1: Question 2: Question 3: 1 BA 3623 - Management Science - Assignment #1 DUE DATE: June 08, 2016 at 3:30pm Question 4: Question 5: Question 6: 2 Scanned by CamScanner Scanned by CamScanner