0 sensitivity report worksheet report created 24 jul

This preview shows page 6 - 10 out of 13 pages.

Microsoft Excel 12.0 Sensitivity Report Worksheet: [Panchtantra.xlsx]Sheet1 Report Created: 24-Jul-10 9:35:46 AM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $D$20 metres Lungi 11000 0 0.9 1.0000E+030 1.0000E+030 $E$20 metres shirt 9600.0000242 0 0.5999999985 1.0000E+030 0.5999999985 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$26 Maximise Lungi Production 11000 -1 11000 1000 4333.3332626 $F$27 Production Capacity (No of loom days) 3000 7 3000 649.99999077 800 $F$28 Yarn Availablity 40s 1620000 0 2400000 1.0000E+030 779999.99389 $F$29 Yarn Availablity 60s 440000 0 480000 1.0000E+030 40000 $F$31 Sales constraint Shirt 9600 0 22000 1.0000E+030 12399.999976
Image of page 6

Subscribe to view the full document.

Microsoft Excel 12.0 Limits Report Worksheet: [Panchtantra.xlsx]Limits Report 2 Report Created: 24-Jul-10 9:35:46 AM Target Cell Name Value $F$23 Profit 15660 Adjustable Lower Target Upper Target Cell Name Value Limit Result Limit Result $D$20 metres Lungi 11000 #N/A #N/A #N/A #N/A $E$20 metres shirt 9600.000024 0 9900 9600.001989 15660.00119
Image of page 7
Microsoft Excel 12.0 Answer Report Worksheet: [Panchtantra.xlsx]Sheet1 Report Created: 24-Jul-10 9:59:01 AM Target Cell (Max) Cell Name Original Value Final Value $F$39 Profit 17100 17100 Adjustable Cells Cell Name Original Value Final Value $D$36 metres Lungi 8333.33333333 8333.33333333 $E$36 metres shirt 16000 16000 Constraints Cell Name Cell Value Formula Status Slack $F$47 Sales constraint Shirt 16000 $F$47<=$G$47 Not Binding 6000 $F$43 Production Capacity (No of loom days) 3000 $F$43<=$G$43 Binding 0 $F$44 Yarn Availablity 40s 2100000 $F$44<=$G$44 Not Binding 300000 $F$45 Yarn Availablity 60s 333333 $F$45<=$G$45 Not Binding 146666.6667 $F$46 Sales constraint Lungi 8333 $F$46<=$G$46 Not Binding 2666.666667 $F$42 Avg pay of weavers should be 20.5 21 $F$42>=$G$42 Binding 0
Image of page 8

Subscribe to view the full document.

Microsoft Excel 12.0 Sensitivity Report Worksheet: [Panchtantra.xlsx]Sheet1 Report Created: 24-Jul-10 9:59:01 AM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $D$36 metres Lungi 8333.3333333 0 0.9 0.54 1.0000E+030 $E$36 metres shirt 16000 0 0.6 1.00E+030 0.225 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$47 Sales constraint Shirt 16000 0 22000 1.00E+030 6000 $F$43 Production Capacity (No of loom days) 3000 18 3000 62.5 133.33333333 $F$44 Yarn Availablity 40s 2100000 0 2400000 1.00E+030 300000 $F$45
Image of page 9
Image of page 10
You've reached the end of this preview.
  • Spring '12
  • AbhinavDhar
  • Limit superior and limit inferior, Lungi, Sales constraint, Sales constraint Shirt

{[ 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