Wk7_BUSN625_Assignment.xlsx - Ouderkirk BUSN625 Klein Industries Unit Profit Small Medium Large Total Profit $ 20.50 $ 34.00 $ 42.00 $ 651,221.43

Wk7_BUSN625_Assignment.xlsx - Ouderkirk BUSN625 Klein...

This preview shows page 1 - 6 out of 6 pages.

Ouderkirk BUSN625 Klein Industries Small Medium Large Total Profit Unit Profit $ 20.50 $ 34.00 $ 42.00 $ 651,221.43 Monthly Sales Small Medium Large Minimum 14000 6200 2600 Maximum 21000 12500 4200 Checking poin Minutes Small Medium Large Available Time Time Used Bending/Forming 0.4 0.7 0.8 23400 12,883 Welding 0.6 1 1.2 23400 19014.28571 Painting 1.4 2.6 3.1 46800 46800 Total production time 2.4 4.3 5.1 Production 16157.14 6200 2600 Checking points Minimum 2,157 0 0 Maximum 4,843 6,300 1,600 Total Profit ($) Total Profit ($) = 20.50 small + 34.00 medium + 42.00 large Production constraints: 14,000 <= small <= 21,000 6,200 <= medium <= 12,500 2,600 <= large <= 4,200 Time constraints: 0.40 small + 0.70 medium + 0.80 large <= 23,400 0.60 small + 1.00 medium + 1.20 large <= 23,400 1.40 small + 2.60 medium + 3.10 large <= 46,800 Small Medium Large Unit profit $ 20.50 $ 34.00 $ 42.00 Production time per unit 2.4 4.3 5.1 Profit per production time $ 8.54 $ 7.91 $ 8.24
Image of page 1
nts Available-Used 10,517 4,386 0
Image of page 2
Microsoft Excel 16.0 Sensitivity Report Worksheet: [Wk7_BUSN625_Assignment.xlsx]Sheet1 Report Created: 1/20/2019 9:15:01 PM Variable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase $B$17 Production Small 21000 1.5322580645 20.5 1.00000E+030 $C$17 Production Medium 6200 -1.2258064516 34 1.2258064516 $D$17 Production Large 412.9032258 0 42 3.3928571428 Constraints Final Shadow Constraint Allowable Cell Name Value Price R.H. Side Increase $E$12 Bending/Forming Available Time 23400 0 4200 19200 $E$13 Welding Available Time
Image of page 3
Image of page 4
Image of page 5
Image of page 6

You've reached the end of your free preview.

Want to read all 6 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture