A student project at WCU was initiated to try to determine the impact of implementation of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A student project at WCU was initiated to try to determine the impact of implementation of new technologies. The students want to survey both distance and residential undergraduate students in the four different years at Western (first year, sophomore, junior, and senior). They have estimated that it will cost them $5.50 to survey first year and sophomore residential students and $8.00 to survey junior and senior residential students. The cost to interview distance students is slightly higher. It will cost $6.75 for first year and sophomores and $9.50 for junior and seniors. For statistical validity they want to interview at least 900 students. They feel that there are certain criteria that they must adhere to: At least 25% of first year students surveyed should be distance students At least 20% of sophomore students surveyed should be distance students At least 35% of junior students surveyed should be distance students At least 40% of senior students surveyed should be distance students No more than 35% of all the students surveyed should be first year students Juniors and seniors should be at least 45% of the students surveyed Each of the eight types of students must be represented in the survey by at least 10% of the total interviews Formulate and solve this problem in Excel to determine the number of each type of student that should be surveyed that meets the requirements and minimizes the cost to carry out the interviews. 1. a) What is the minimum cost in your optimal solution (the value of the objective function)? 2. b) If the cost of surveying first year and sophomore residential students increases from $5.50 to $7.00 - what is the new minimum cost in your optimal solution? A student project at WCU was initiated to try to determine the impact of implementation of new technologies. The students want to survey both distance and residential undergraduate students in the four different years at Western (first year, sophomore, junior, and senior). They have estimated that it will cost them $5.50 to survey first year and sophomore residential students and $8.00 to survey junior and senior residential students. The cost to interview distance students is slightly higher. It will cost $6.75 for first year and sophomores and $9.50 for junior and seniors. For statistical validity they want to interview at least 900 students. They feel that there are certain criteria that they must adhere to: At least 25% of first year students surveyed should be distance students At least 20% of sophomore students surveyed should be distance students At least 35% of junior students surveyed should be distance students At least 40% of senior students surveyed should be distance students No more than 35% of all the students surveyed should be first year students Juniors and seniors should be at least 45% of the students surveyed Each of the eight types of students must be represented in the survey by at least 10% of the total interviews Formulate and solve this problem in Excel to determine the number of each type of student that should be surveyed that meets the requirements and minimizes the cost to carry out the interviews. 1. a) What is the minimum cost in your optimal solution (the value of the objective function)? 2. b) If the cost of surveying first year and sophomore residential students increases from $5.50 to $7.00 - what is the new minimum cost in your optimal solution?
Expert Answer:
Answer rating: 100% (QA)
To solve this problem in Excel we can use the Solver addin to find the optimal solution that meets the given requirements and minimizes the cost of th... View the full answer
Related Book For
Operations Management Creating Value Along the Supply Chain
ISBN: 978-1118301173
1st Canadian Edition
Authors: Roberta S. Russell, Bernard W. Taylor, Ignacio Castillo, Navneet Vidyarthi
Posted Date:
Students also viewed these finance questions
-
To be a case manager provide a detailed short summary including your intentions and goals and the type of opportunities that are helpful for securing a position as a case manager. Write it in the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Answer the following questions: 1. Build the management-research question hierarchy for Starbuck project 2. the Duetto Card team turned to Green field Online to recruit a panel for one of its online...
-
Construct the general solution of x ' = Ax involving complex eigenfunctions and then obtain the general real solution. Describe the shapes of typical trajectories. =[ A = 3. -2 1]
-
Solve Problem 8.126 assuming that = 75 o .
-
A particle with a mass of 4 kg has a position vector in meters given by r = 3t 2 i 2tj 3k, where t is the time in seconds. For t = 5 s determine the angular momentum of the particle and the moment...
-
French and Schultz ("Water Use Efficiency of Wheat in a Mediterranean-type Environment, I The Relation between Yield, Water Use, and Climate," Australian Journal of Agricultural Research, 35, 743-64)...
-
This problem continues the Davis Consulting situation from Problem P2-43. You will need to use the unadjusted trial balance and posted T-accounts that you prepared in Problem P2- 43. The unadjusted...
-
Consider a Specific-Factors model where two countries, Domestic and Foreign, produce two goods, A and B, using labor L and capital K. Take the following information as given: In Domestic, the...
-
1. What factors might have enabled JLR to raise new debt at less than half the coupon rate of interest in 2015 compared with the debt raised in 2011? 2. Compute the amount at which existing...
-
1 2 1 The element of second row and third column in the inverse of 2 1 0 is. -1 0 1 (a) -2 (b) -1 (c) 1 (d) 2
-
Discuss and evaluate Costco's mode of entry for the various markets in which it is operating. What ideal mode of entry would you recommend for new markets?
-
What would be your chief concerns if you were a worker in a pure capitalist economy in which the government only provided the following public goods: the right of individuals to be legally free; the...
-
Utility function is a helpful tool to represent preferences so we can analyze resource allocation using mathematical notations and generate predictions about how the most preferred, affordable...
-
In what way does Bergner's (2023) article identify stressors that arose during the pandemic for many, and in particular, themes relating to intersectionality, that can impact the stressors people are...
-
Explain how the two companies have continued to evolve their ERP systems over time, what lessons can be learned from Amazon and Apple's ERP integration experiences, and how can these lessons be...
-
Assume that the risk-free rate is 5%. Which of the followingstatements is CORRECT? a. If a stock's beta were less than 1.0, its required return underthe CAPM would be less than 5%. b. If a stock's...
-
The column shown in the figure is fixed at the base and free at the upper end. A compressive load P acts at the top of the column with an eccentricity e from the axis of the column. Beginning with...
-
Glen Wong is an emergency medical technician for a local rescue team and is routinely called on to render emergency care to citizens facing crisis situations. Although Glen has received extensive...
-
During registration at Poly every quarter, students in the Faculty of Management must have their courses approved by the departmental adviser. It takes the adviser an average of five minutes...
-
Local University in Problem S7-3 is attempting to locate the best site for a new student center and athletic complex. The university administration would like to know what the best location is...
-
Summer and winter constellations are different because (a) of the spin of Earth about its polar axis. (b) the night sky faces in opposite directions in summer and winter. (c) of the tilt of Earths...
-
The property of a star that relates to the amount of energy per unit time it is producing is its (a) luminosity. (b) apparent brightness. (c) color. (d) volume. (e) mass.
-
What is the star nearest Earth? (a) Proxima Centauri (b) Polaris (c) Mercury (d) the Sun
Study smarter with the SolutionInn App