5 lac microsoft excel 120 answer report worksheet

This preview shows page 1 - 7 out of 13 pages.

exceed 1.5 lac
Image of page 1

Subscribe to view the full document.

Microsoft Excel 12.0 Answer Report Worksheet: [Panchtantra.xlsx]Sheet1 Report Created: 24-Jul-10 9:37:46 AM Target Cell (Max) Cell Name Original Value Final Value $F$8 Profit 14280 18000 Adjustable Cells Cell Name Original Value Final Value $D$5 metres Lungi 1200 6666.66666663 $E$5 metres shirt 22000 20000 Constraints Cell Name Cell Value Formula Status Slack $F$11 Production Capacity (No of loom days) 3000 $F$11<=$G$11 Binding 0 $F$12 Yarn Availablity 40s 2400000 $F$12<=$G$12 Not Binding 1.24862E-005 $F$13 Yarn Availablity 60s 266667 $F$13<=$G$13 Not Binding 213333.3333 $F$14 Sales constraint Lungi 6667 $F$14<=$G$14 Not Binding 4333.333333 $F$15 Sales constraint Shirt 20000 $F$15<=$G$15 Not Binding 2000
Image of page 2
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Panchtantra.xlsx]Sheet1 Report Created: 24-Jul-10 9:37:46 AM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $D$5 metres Lungi 6666.6666666 0 0.9 0.54 0.54 $E$5 metres shirt 20000 0 0.6 0.9 0.225 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$11 Production Capacity (No of loom days) 3000 4 3000 650 500 $F$12 Yarn Availablity 40s 2400000 0 2400000 150000 780000 $F$13 Yarn Availablity 60s 266667 0 480000 1.00E+030 213333.33333 $F$14 Sales constraint Lungi 6667 0 11000 1.00E+030 4333.3333334 $F$15 Sales constraint Shirt 20000 0 22000 1.00E+030 2000
Image of page 3

Subscribe to view the full document.

Microsoft Excel 12.0 Limits Report Worksheet: [Panchtantra.xlsx]Limits Report 1 Report Created: 24-Jul-10 9:37:46 AM Target Cell Name Value $F$8 Profit 18000 Adjustable Lower Target Upper Target Cell Name Value Limit Result Limit Result $D$5 metres Lungi 6666.666667 0 12000 6666.666683 18000.00002 $E$5 metres shirt 20000 0 6000 19999.99869 17999.99921
Image of page 4
Microsoft Excel 12.0 Answer Report Worksheet: [Panchtantra.xlsx]Sheet1 Report Created: 24-Jul-10 9:35:46 AM Target Cell (Max) Cell Name Original Value Final Value $F$23 Profit 1080 15660 Adjustable Cells Cell Name Original Value Final Value $D$20 metres Lungi 1200 11000 $E$20 metres shirt 0 9600.00002424 Constraints Cell Name Cell Value Formula Status Slack $F$26 Maximise Lungi Production 11000 $F$26=$G$26 Not Binding 0 $F$27 Production Capacity (No of loom days) 3000 $F$27<=$G$27 Not Binding 2.02205E-006 $F$28 Yarn Availablity 40s 1620000 $F$28<=$G$28 Not Binding 779999.9976 $F$29 Yarn Availablity 60s 440000 $F$29<=$G$29 Not Binding 40000 $F$31 Sales constraint Shirt 9600 $F$31<=$G$31 Not Binding 12399.99998
Image of page 5

Subscribe to view the full document.

Microsoft Excel 12.0 Sensitivity Report
Image of page 6
Image of page 7
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