bikewhee Textl2 -...

Info iconThis preview shows page 1. Sign up to view the full content.

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

Unformatted text preview: 0a0872be71446a189859363d8693659f32d67e66.xls A B C D 1 Bicycle Wheel Production Problem -- "Grid" Version 2 Activities 3 Make Make Make 4 Spokes Rims Wheels 5 Machine Time 0.04 0.6 0 6 Labor 0.01 0.5 1.2 7 Spokes 1 0 -72 8 Rims 0 1 -1 9 Wheels 0 0 1 10 $0.05 $4.00 $11.00 11 Direct Unit Cost 12 Amount of 8000 300 150 13 Activity 14 15 Usage of Revenue 16 Machine Time 500 Cost 17 Labor 410 Profit 18 19 Amount Sold 20 Spokes -2800 21 Rims 150 22 Wheels 150 23 Values E F Limit 378 267 $0.10 Unit $10.00 Selling $50.00 Price G H I x1 = Number of spokes made x2 = Number of rims made x3 = Number of wheels made M ax : 0.1(x 1-72 x 3)+10(x 2- x 3) +50x 3 [ 0.05 x 1+4 x 2+11 x 3] S.T. 0.4 x1+6 x2 ≤ 378 0.1x1+0.5x2+1.2x3≤267 x1-72 x3 ≥ 0 INPUT/OUTPUT TABLE x2 - x3 ≥ 0 $8,720.00 $3,250.00 $5,470.00 Positive numbers are output of products from x 1, x 2, x 3 ≥ 0 this activity. Negative numbers are input of producs into this activity 0a0872be71446a189859363d8693659f32d67e66.xls J K L 1 2 x1 = Number of spokes made 3 x2 = Number of rims made 4 x3 = Number of wheels made 5 M ax : 0.1(x 1-72 x 3)+10(x 2- x 3) +50x 3 6 7 [ 0.05 x 1+4 x 2+11 x 3] 8 S.T. 9 0.4 10 x2 ≤ 378 x1+6 0.1x1+0.5x2+1.2x3≤267 11 12 x1-72 x3 ≥ 0 x213x3 ≥ 0 14 x 1, x 2, x 3 ≥ 0 15 16 17 18 19 20 21 22 23 Values 0a0872be71446a189859363d8693659f32d67e66.xls A B C D E F G 1 Bicycle Wheel Production Problem -- "Grid" Version 2 Activities 3 MakeMakeMake 4 SpokesRims Wheels Limit 5 Machine Time 0.04 0.6 0 378 6 Labor 0.01 0.5 1.2 267 7 Spokes 1 0 -72 $0.10 Unit 8 Rims 0 1 -1 $10.00 Selling 9 0 0 1 $50.00 Price 10 Wheels Direct Unit Cost $0.05 ### ### 11 12 7200 150 Decision Variables >= 0 100 13Amount of 14 Activity Constrained <= E6:E7 15 Usage of Revenue $5,500.00 16 M17 achine Time 378 Cost $2,060.00 Labor 267 Profit $3,440.00 18 19 Amount Sold 20 0 Objective, Maximize 21 Spokes Rims 50 22 100 Constrained >= 0 23 Wheels Formulas ...
View Full Document

This note was uploaded on 09/28/2011 for the course MANAGEMENT 386 taught by Professor Ben-israel during the Spring '11 term at Rutgers.

Ask a homework question - tutors are online