Minimum supply requirements

Assignment Help Basic Computer Science
Reference no: EM132340458

Karen is in charge of internship assignments for all students at Northwestern. Karen understands that there is a limited supply of Northwestern students from either the College or the Analytics School. The four main locations she can assign to are Texas, California, DC, or New York; each having their own maximum demand requirements (i.e., Texas can accommodate no more than 750 students). Karen understands that the Analytics School must supply AT LEAST 1000 and the College AT LEAST 1,400 students, respectively and there is limited demand for them at the locations. The specific requirements are shown in the Excel sheet. You are tasked with creating an Excel Spreadsheet model and solving (optimizing) it two different ways, first to maximize the number of students assigned and the second to minimize total cost while meeting the minimum supply requirements.

Assignment - Supply (At Least)

Analytics School (AS) 1,000

College (COL) 1,400

Location - Demand (At Most)

Texas (TX) 750

California (CA) 650

DC (DC) 300

New York (NY) 80$

Cost $ per Student TX CA DC NY

AS 3000 2500 5000 4000

COL 4500 4000 1500 2000

Reference no: EM132340458

Questions Cloud

Understand the differences between signs and symptoms : Determine the differences between the different disease classifications. Understand epidemiology. Understand the differences between signs and symptoms.
What is the sample mean : A STAT 200 professor took a sample of 10 midterm exam scores from a class of 30 students. The 10 scores are shown in the table below:
Represent the number of conference : The following data represent the number of conference wins for each Southeastern Conference (SEC) men's basketball team during the 2018-2019 regular season:
Disease research paper : Student will conduct scientific literature research and write a 4-page paper on a human disease or disorder of choice.
Minimum supply requirements : Karen is in charge of internship assignments for all students at Northwestern. Karen understands that there is a limited supply of Northwestern students
Part of the brain-medulla oblongata-pons and midbrain : Choose one part of the brain (medulla oblongata, pons, midbrain, thalamus, hypothalamus, epithalamus, cerebellum, or one of the cerebral lobes).
Amount of gasoline consumed : After each vehicle has been driven for 250 miles, the amount of gasoline consumed is measured.
Give an intuitive explanation : After you have found the best strategy, give an intuitive explanation of why it is the best and why it is called "bold play."
State the null and alternative hypotheses : State the null and alternative hypotheses for your test. Find the mean and standard deviation of the sampling distribution of sample proportions.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Facing a potentially unethical action

Identify the three questions that an ethics-based manager should ask when facing a potentially unethical action

  Discuss roles in a pci dss security assessment

The primary roles involved in a Payment Card Industry Data Security Standard (PCI DSS) security assessment are merchant, merchant's security personnel, merchant's networking personnel, service providers (if any), payment brand (such as Visa and Maste..

  What is opportunity cost in economics

What is Opportunity Cost in economics (define Opportunity Cost)? Also, Provide Two examples of an Opportunity Cost.

  Explain why each of these is a still-life

Explain why each of these is a still-life. Can you find another still-life? Modify the Life model in the NetLogo models library to include a button that saves your new still-life configuration.

  Suitable for supply chain web applications

Assess why SSL/TLS (Secure Sockets Layer/Transport Layer Security) is not suitable for supply chain web applications.

  Workbook and a worksheet group in excel

What is the difference between a Workbook and a Worksheet group in excel?

  What implications might follow from such price differentials

How have movements in the £$ exchange rate contributed to these differences? (Note on average the US prices were 20% higher only 12 months previously.)

  Standard normal curve lies to the left

Find z such that 87.9% of the standard normal curve lies to the left of z. (Enter a number. Round your answer to two decimal places.)

  Persistence of memory

"New York, NY (AP, Nov. 20, 2017) - Salvador Dali's iconic painting, "The Persistence of Memory" of 1931 - considered the Catalan surrealist's

  Determine the shift amount on the caesar cipher

Note: the number of letters on your last name will determine the shift amount on the Caesar's Cipher.

  Model the operation of siding

A program is to be written to model a railroad switching yard. One part of the switching network consists of a main track and a siding onto

  Malicious code protection

Do you agree that in order to fight the spreading of malicious code (i.e., virus, worm, trojan, etc.), using only antivirus (AV) software is NOT sufficient.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd