perfume - Processefineefine Raw MaterialBruteanelle Limit...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
615f505d22e6fd4a1de50ee505ff01eb7a3a59b2.xls Values Perfume Problem -- "Grid" Version Activities Process Refine Refine Raw Material Brute Chanelle Limit Raw Material 1 0 0 4000 Lab Time 1 3 2 6000 Unit Selling price Amount Sold Regular Brute 3 -1 0 $7.00 11333.33 Luxury Brute 0 1 0 $18.00 666.67 Regular Chanelle 4 0 -1 $6.00 16000 Luxury Chanelle 0 0 1 $14.00 0 Direct Unit Cost $3.00 $4.00 $4.00 Amount of 4000 666.67 0 Activity Usage of Revenue $187,333.33 Raw Material 4000 Cost $14,666.67 Lab Time 6000 Profit $172,666.67 Amount Sold Regular Brute 11333.33 Luxury Brute 666.67 Regular Chanelle 16000 Luxury Chanelle 0 A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
615f505d22e6fd4a1de50ee505ff01eb7a3a59b2.xls Formulas Perfume Problem -- "Grid" Version Activities
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Processefineefine Raw MaterialBruteanelle Limit Material 1 4000 Lab Time 1 3 2 6000 lar Brute 3-1 $7.00 Unit ury Brute 1 $18.00 Selling Chanelle 4-1 $6.00 Price Chanelle 1 $14.00 Unit Cost $3.00 ### ### mount of 4000 ### ision Variables, >=0 Activity Constrained <= E6:E7 Usage of Reve $187,333.33 Material 4000 Cost $14,666.67 Lab Time 6000 Profit $172,666.67 Amount Sold lar Brute 11333.33 Objective, Max ury Brute 666.67 Chanelle 16000 Constrained >= 0 Chanelle A B C D E F G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25...
View Full Document

This note was uploaded on 12/17/2010 for the course MSIS 623:386 taught by Professor Markowitz during the Fall '09 term at Rutgers.

Page1 / 2

perfume - Processefineefine Raw MaterialBruteanelle Limit...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online