Homework 2 Repco Drug Production

Homework 2 Repco Drug Production - Drug A Drug B Drug C...

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

View Full Document Right Arrow Icon
Repco production process model Inputs used (along side) to make one unit of product (along top) Range names used: Drug A Drug B Drug C Drug D Hours_available =Model!$D$23 Labor hours 1 2 3 4 Hours_used =Model!$B$23 Revenue_from_sales =Model!$B$25 Drug A 0 2 0 1 Units_produced =Model!$B$16:$D$16 Drug B 0 0 1 0 Units_sold =Model!$B$19:$D$19 Drug C 0 0 0 1 Units_used_in_production =Model!$B$18:$D$18 Unit selling prices Drug A Drug B Drug C Drug D $8 $70 $100 $150 Production and sales plan Units of products used (along side) to make products (along top)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Drug A Drug B Drug C Drug D Drug A Drug B Drug C Drug D Units produced 2000 1000 Drug A 2000 >= >= >= >= Drug B Units used in production 2000 Drug C Units sold 1000 Labor hour constraint Hours used Hours available 4000 <= 4000 Revenue from sales $70,000 Objective to maximize A B C D E F G H I J K 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 27...
View Full Document

This note was uploaded on 10/05/2008 for the course EBGN 525 taught by Professor Gurgur during the Fall '08 term at Mines.

Ask a homework question - tutors are online