View the step-by-step solution to:

Instructions: Due date: Thursday May 10th in class. Please briefly explain each constraint, such as "capacity limit for resource A". COMPUTER...

i attatch file
Instructions: 1. This assignment can be done individually or in a group of no more than two students. 2. Due date: Thursday May 10 th in class . 3. For each linear programming formulation, please clearly state the three elements (definition of decision variables and their measurement units, objective function and constraints). Please briefly explain each constraint, such as “capacity limit for resource A”. 1. COMPUTER PRODUCTION. MVC Enterprises can manufacture four different computer models; the Student, Plus, Net, and Pro models. The following gives the configurations of each models Student Plus Net Pro Processor Celeron Pentium Celeron Pentium Hard Drive 20 gb 20 gb 20 gb 20 gb Floppy Drives 1 1 2 1 Zip Drive YES YES NO YES Audio/Video CD R/W DVD DVD + CD R/W DVD + CD R/W Monitor 15” 15” 17” 17” Case Tower Mini-Tower Mini-Tower Tower Production Times (hrs.) .4 .5 .6 .8 Unit Profit $70 $80 $130 $150 MVC must satisfy a contract that produces a minimum of 100 Net models per week. MVC employs 25 workers, each of whom averages 30 production hours each per week. The following resources are available weekly: Processors Hard Drives Other Drives Celeron – 700 20 gb – 800 Floppy – 1600 Pentium – 550 30 gb – 950 Zip – 1000 Audiovisual Monitors Cases CD R/W – 1600 15” – 850 Mini-Tower – 1250 DVD – 900 17” – 800 Tower – 750
Background image of page 1
The problem is formulated and solved in Excel Solver as follows. Decision variables: X 1 = Number of Student models produced each week X 2 = Number of Plus models produced each week X 3 = Number of Net models produced each week X 4 = Number of Pro models produced each week Objective function: MAX 70X 1 + 80X 2 + 130X 3 + 150X 4 Subject to : X 3 100 (Contract) .4X 1 + .5X 2 + .6X 3 + .8X 4 750 (Production Hours) X 1 + + X 3 700 (Celeron) X 2 + X 4 550 (Pentium) X 1 + X 2 + X 3 + 800 (20gb Hard Drives) X 4 950 (30gb Hard Drives) X 1 + X 2 + 2X 3 + X 4 1600 (Floppy Drives) X 1 + X 2 + X 4 1000 (Zip Drives) X 1 + X 3 + X 4 1600 (CD R/W's) X 2 + X 3 + X 4 900 (DVD's) X 1 + X 2 850 (15-in. monitors) X 3 + X 4 800 (17-in. monitors) X 2 + X 3 1250 (Mini-tower cases) X 1 + X 4 750 (Tower cases) All X's 0
Background image of page 2
Show entire document

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question