Week 7 Klein Industries. - Joe - Klein Industries Review Monthly Sales Minimum Maximum Small(x 14,000 21,000 Medium(y 6,200 12,500 Large(z 2,600 4,200

Week 7 Klein Industries. - Joe - Klein Industries Review...

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

Klein Industries Review Monthly Sales Small (x) Medium(y) Large (z) Minimum 14,000 6,200 2,600 Maximum 21,000 12,500 4,200 Minutes Small (x) Medium(y) Large (z) Bending/Forming 0.40 0.70 0.80 Welding 0.60 1.00 1.20 Painting 1.40 2.60 3.10 Small (x) Medium(y) Large (z) Unit profit $20.50 $34.00 $42.00 Total production time 2.40 4.30 5.10 Production time per unit 2.40 4.30 5.10 Profit per production time $8.54 $7.91 $8.24 Total Profit Maximization($) 20.50x + 34.00y + 42.00z Production constraints: x >= 14000 x <=21000 y >=6200 y <=12500 z >=2600 z <= 4200 Time constraints: 0.40x + 0.70y + 0.80z <= 23,400 0.60x + 1.00y + 1.20z <= 23,400 1.40x + 2.60y + 3.10z <= 46,800 Non Negativity Constaints: x,y,z >= 0 Production (Calculated Values) 16157 6200 2600 Profit: $651,221.43 Solver Table: D Variable x y z Calc Value 16157.142857 6200 2600 Total Obj Func 20.50 34.00 42.00 651221.43 Constraints: Prcessing Time 0.40 0.70 0.80 12882.86 <= 23400 0.60 1.00 1.20 19014.29 <= 23400 1.40 2.60 3.10 46800.00 <= 46800 Sales 1.00 16157.14 <= 21000 1.00 6200.00 <= 12500 1.00 2600.00 <= 4200 1.00 16157.14 >= 14000 1.00 6200.00 >= 6200 1.00 2600.00 >= 2600
Image of page 1
Hey (Production Manger)… It was great catching up with you yesterday at lunch. The team just finished running the numbers on the air compressor line and came up with an ideal scenario I wanted you to review. Based upon the timing and production information that you provided to us we've come
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 6 pages?

  • Fall '13
  • Gerald
  • Sales, calc value, Klein Industries.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture