How to get an equation, graph it, and solve it? Imi12 13 14' 15 16 17 18 19|610 1120 ' 21' 22'23 24' 2518716504131The Admissions Office at Big State University needs to decide how many in-state studentsand how many out of state students to admit to the next class. Like many universities, BigState U has limited resources, and budget considerations have to play a part in admissionspolicy.Here are the constraints on the Admissions Office decision:The college president wants this class to contribute a total of at least $2,500,000 to theschool after it graduates. In the past, Big State U has gotten an average of $8,000 incontributions from each in-state student admitted and an average of $2,000 from each out-of-state student admitted.The faculty at the college wants entering students with good grade point averages. Gradesof in-state students average less than grades of out-of-state students. Therefore, the facultyis urging the school to admit at least as many out-of-statę students as in ștate- students.The housing office is not able to spend more than $85,000 to cover costs such as meals andutilities for students in residence halls during vacation periods. Because out-of-statestudents are more likely to stay on campus during vacations, the housing office needs totake these differences into account. In-State students will cost the office an average of $100each for vacation-time expenses, while out of state students will cost an average of $200each.The college treasurer needs to minimize educational costs. Because students take differentcourses, it costs an average of $7,200 a year to teach an in-state student and an average of$6,000 a year to teach an out-of-state student.Phew...Your job is to recommend how many students from each category should be admitted toBig State U. You need to minimize educational costs, as the treasurer requires, within theconstraints set by the college president, the faculty, and the housing office.(our write up should include a proof that your solution is the best possible within the

Answered: Image /qna-images/answer/5c6597df-332b-436c-baf2-740ad5486430.jpg

Answered: How to get an equation, graph it, and…

Business

Operations Management

How to get an equation, graph it, and solve it?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Below is data of lobster sales volume from a seafood company. We are using exponential smoothing (α = 0.5) and 3-year moving average to forecast it. a. Please fill the blanks above and write your processes below. b. What are the mean absolute deviations (MADs) of the two methods? Whichmethod will you choose based on the results? *Please solve for a-b and type or write all your work/steps and answers on paper* NO EXCEL, thank you
State and explain what is meant by the concept of time series ?
Use the following for the next 2 questions: A company forecasts that it will ship 120,000 boxes of product in June. The product has a monthly turnover of 3. The company plans to use its facility to ship 80,000 boxes and the balance of the 40,000 boxes will ship from a rented facility. Space may be rented for a charge of $7 per box per month with an in-and-out handling charge of $0.45 per box shipped. 1. What is the rented (fixed) storage cost for June? - $280,000 - $180,000 - $42,500 - $250,000 - $93,333 - $153,333 - $173,333 2. What is the rented variable cost for June? - $33,333 - $43,333 - $6,000 - $38,000 - $18,000 - $28,000 - $23,333
give details calculation
Dave F letcher, the general manager of NorthCarolina Engineering Corporation (NCEC), thinks that his firm'sengineering services contracted to highway construction firms aredirectly rela ted to the volume of highway construction businesscontracted with companies in his geographic area. He wondersif thjs is really so, and if it is, can this information help him planhjs operations better by forecasting the quantity of his engineeringservices required by construction firms in each quarter of theyear? The following table presents the sales of his services andtotal amounts of contracts for hjghway construction over the pasteight quarters:…
Café Michigan's manager, Gary Stark, suspects that demand for mocha latte coffees depends on the price being charged. Based on historical observations, Gary has gathered the following data, which show the numbers of these coffees sold over six different price values: IT Price Number Sold $2.60 $3.60 $2.00 $4.20 $3.10 $4.00 770 505 975 250 315 490 Using simple linear regression and given that the price per cup is $1.85, the forecasted demand for mocha latte coffees will be cups (enter your response rounded to one decimal place).
What is the Y coordinate if we use the center of gravity method? Please keep 3 decimals in your final answer
The County Transportation Department needs to determine usage factors by day of the week for a popular toll bridge connecting different parts of the city. In the current study, they are considering only working days. Suppose that the numbers of cars using the bridge each working day over the past four weeks were (in thousands of cars) Find the seasonal factors corresponding to daily usage of the bridge.
Tom Glass forecasts electrical demand for the FlatlandsPublic Power District (FPPD). The FPPD wants to take itsComstock power plant out of service for maintenance whendemand is expected to be low. After shutdown, performingmaintenance and getting the plant back on line takes two weeks. The utility has enough other generating capacity tosatisfy 1,550 megawatts (MW) of demand while Comstockis out of service. Table 8.5 shows weekly peak demands(in MW) for the past several autumns. When next in year 6should the Comstock plant be scheduled for maintenance?
Please include an excel sheet showing calculations