Question: Solve with Excel and Upload the model and Answer Report. There are 1,400/2,500/1,200/700 applicants at Whoop! University to the English/Civil Engineering/Chemical Engineering/Physics programs respectively. Tuition

Solve with Excel and Upload the model and Answer Report.

Solve with Excel and Upload the model and Answer

There are 1,400/2,500/1,200/700 applicants at Whoop! University to the English/Civil Engineering/Chemical Engineering/Physics programs respectively. Tuition per student is set at $2,000/$3,000/$4,000/$2,500 respectively. The total number of engineering students must be at most 3,000. The number of computer hours per week required by each student is 2/16/20/10 respectively and the available total computer hours per week are 75,000.The dormitories can house at most 5,000 in total. Whoop! University would like to select the best admission policy to maximize their total tuition. Formulate this problem as a LP [assume that students can be modeled with continuous variables] X1 X2 X37X4 = students admitted to English Civil Engineering/Chemical Engineering/Physics MAX Z-2,000x1 + 3,000x2 + 4,000x3 + 2,500x4 s.t. X2 +xz

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!

Please show steps for setting up the answer report. I will upvote Solve with Excel and Upload the model and Answer Report. There are 1,400/2,500/1,200/700 applicants at Whoop! University to the...

Please show steps on how to solve in Excel a. Upload your completed assignment to Elms (Canvas). For this exercise, you can download the case excel and a handout with case exhibits that you will need...

Suppose that a project will cost $95,000 initially and it will generate the following nonconventional cash flows: Year 1: $135,000 Year 2: $120,000 Year 3: $168,000 Year 4: $110,000 Year 5: $122,000...

Solve using excel and upload screenshots Solve using excel and upload screenshots Suppose Company X has the following returns: 2016 2017 2018 7% -5% 21% -7% 2019 i) What is the arithmetic Average...

3.S4. Producing and Distributing AEDs at Heart Start Heart Start produces automated external defibrillators in each of two different plants (A and B). The unit production costs and monthly production...

1) Suppose that a project will cost $90,000 initially and it will generate the following nonconventional cash flows: Year 1: $130,000 Year 2: $115,000 Year 3: $170,000 a) If the required return is...

As a broker at Churnem & Burnem Securities, you recommend stocks to your clients. After gathering data on Furniture Factory, you have found that its dividend has been growing at a rate of 4 % per...

Please solve using excel and upload what the excel input would be. 25. Falling parachutist As in Problem 25 of Section 2.5, you bail out of a helicopter and immediately open your parachute, so your...

please solve in Excel and upload excel sheet Question 4: Drolet Manufacturing Company. in Saint-Hubert, Quebec. makes flashing lights for toys. The company operates its production facility 300 days...

The retina of a human eye can detect light when radiant energy incident on it is at least 4.0 10-17 J. For light of 600-nm wavelength, how many photons does this correspond to?

In a random sample of five people, the mean driving distance to work was 22.2 miles and the standard deviation was 5.8 miles. You are given the sample mean and the sample standard deviation. Assume...

( Cash Receivables ) / Current Liabilities is known as: Goodwill Receivables to Payables Quick Ratio Debt to Worth Overbilling

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...