Question: 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

1. COMPUTER PRODUCTION. MVC Enterprises can

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 model Student Celeron 20 gb Plus Pentium 20 gb Net Celeron 20 gb Pro Pentium 30 gb NO YES CD R/W YES DVD DVD + CD R/W Processor Hard Drive Floppy Drives Zip Drive Audio/Video Monitor Case Production Times (hrs.) Unit Profit YES DVD + CD R/W 17" Tower 15" 15 17" Tower Mini-Tower Mini-Tower .5 $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 Celeron - 700 Pentium - 550 Hard Drives 20 gb-800 30 gb-950 Other Drives Floppy-1600 Zip-1000 Audiovisual CD R/W-1600 DVD-900 Monitors 15" - 850 17" - 800 Cases Mini-Tower - 1250 Tower - 750 The problem is formulated and solved in Excel Solver as follows. Decision variables: X1 = Number of Student models produced each week X2 = Number of Plus models produced each week X3 = Number of Net models produced each week X = Number of Pro models produced each week Objective function: MAX 70X: + 80X2 + 130X: + 150X, Subject to : X 4X1 + 5X2 + .6X3+ 8X4 s XS s X4 S X2 + 2X3 + X: X1 + X2 + X: S X1 + X: + X S X2 + X: + X. S X1 + X2 S 100 (Contract) 750 (Production Hours) 700 (Celeron) 550 (Pentium) 800 (20gb Hard Drives) 950 (30gb Hard Drives) 1600 (Floppy Drives) 1000 (Zip Drives) 1600 (CD R/W's) 900 (DVD's) 850 (15-in. monitors) 800 (17-in. monitors) 1250 (Mini-tower cases) 750 (Tower cases) X2+ X3 X All X's 20 S S Model in Excel: G6 - A =SUMPRODUCT($C$4:$F$4,06:56) A B C D E F 1 MVC ENTERPRISES G H I Student 325 Plus 100 Net 375 Pro 425 Production 70 Total 143250 80 150 375 0.4 0.8 Profit Contract Production Hours Celeron Pentium 20 gb drives 30 gb drives Floppies Zip Drives CD RAV's DVD's 15-in Monitors 17-in Monitors Mini-Tower Cases Tower Cases 745 700 525 800 425 1600 850 A A A 111 1125 1000 1600 900 900 425 800 475 750 850 800 E =$1$7 Not Binding 745 SG$8=$1$8 Not Binding 700 $G$9

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

P14-26. Forecasting with Parsimonious Method and Estimating Share Value Using the ROPI Model Following are income statements and balance sheets for Cisco Systems. CISCO SYSTEMS Consolidated...

COMPUTER PRODUCTION. MVC Enterprises can manufacture four different computer models; the Student, Plus, Net, and Pro models. The following gives the configurations of each model:

Financial Statement Analysis Obtain a copy of the 2009 annual report for a publicly held firm. Try to obtain an annual report for a retail or manufacturing firm. Be sure that the financial statement...

CASE 11 Sirius XM Satellite Radio Inc. in 2014: On Track to Succeed connect after a Near-Death Experience? Arthur A. Thompson The University of Alabama In February 2009, the outlook for Sirius XM...

FILE TOOLS VIEW 6401819_1_writing-case--4 - Word (Product Activation Failed) Financing Early Operations Musk's first entrepreneurial venture was to join up with his brother, Kimbal, and establish...

I need a 10 page paper for my MIS class. Please do not copy and paste as my school is getting stricter on plagiarism. I have attached the assignment and the sample \fData Analytic Thinking 1 Data...

Need script to do sentimental analysis in python for amazon review data Here is the dataset text ## I purchased this monitor because of budgetary concerns . inexpensive[+1][a] ## This item was the...

Read: Strategic Management Cases Case Study #12 Pixar Case Study #20 Nintendo: Could the Switch Turn on Gamers? Prepare a written SWOT analysis for each company using the information provided in the...

The proliferation and ubiquity of technology has presented great advantages and great challenges. The best practices of companies and organizations now include governance departments and initiatives...

Why should a foreign marketer study economic development? Discuss.

According to AS 3 1 0 1 , all of the following factors are relevant to the auditor's determination of Critical Audit Matters, except: Multiple Choice whether the matter was communicated or required...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...