class file LP 3e P3-18 final.xlsx

class file LP 3e P3-18 final.xlsx - Problem 3-18(a Number...

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Problem 3-18 (a) Number of attendants 27.0 0.0 17.0 0.0 23.0 0.0 Objective 1 1 1 1 1 1 67.0 Constraints 6am-10am needs 1 1 27.0 >= 27 10am-2pm needs 1 1 17.0 >= 12 2pm-6pm needs 1 1 17.0 >= 23 6pm-10pm needs 1 1 23.0 >= 29 10pm-2am needs 1 1 23.0 >= 23 2am-6am needs 1 1 27.0 >= 8 LHS Sign RHS Start at 2am Start at 6am Start at 10am Start at 2pm Start at 6pm Start at 10pm
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
e FORMULAS P3-18 (a Number o#########0.0 ### 0.0 Objective 1 1 1 1 1 1 67.0 Constraints 6am-10a 1 1 27.0 >= 27 10am-2pm n 1 1 17.0 >= 12 2pm-6pm needs 1 1 17.0 >= 23 6pm-10pm needs 1 1 23.0 >= 29 10pm-2am needs 1 1 23.0 >= 23 2am-6am 1 1 27.0 >= 8 LHS Sign RHS at 2a m at 6a m 10 a m at 2p m at 6p m at 10 pm A B C D E F G H I J 1 2 3 4 5 6 7 8 9 10 11 12 13
Image of page 2
Microsoft Excel 15.32 Answer Report Worksheet: [class file LP 3e P3-18.xls]P3-18 (a) Report Created: 4/9/17 1:21:58 AM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.073655 Seconds. Iterations: 7 Subproblems: 0 Solver Options Max Time 100 sec, Iterations 100, Precision 0.000001, Use Automatic Scaling Max Subproblems 5000, Max Integer Sols 5000, Integer Tolerance 0.05%, Assume NonNegative Objective Cell (Min) Cell Name Original Value Final Value $H$5 Objective 0.0 73.0 Variable Cells Cell Name Original Value Final Value Integer $B$4 Number of attendants Start at 2am 0.0 27.0 Contin $C$4 Number of attendants Start at 6am 0.0 0.0 Contin $D$4 Number of attendants Start at 10a 0.0 17.0 Contin $E$4 Number of attendants Start at 2pm 0.0 6.0 Contin $F$4 Number of attendants Start at 6pm 0.0 23.0 Contin $G$4 Number of attendants Start at 10p 0.0 0.0 Contin Constraints Cell Name Cell Value Formula Status Slack $H$7
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern