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]
-
Tastee Foods produces canned chicken a la king. The chicken a la king passes through three departments: (1) Mixing, (2) Retort (sterilization), and (3) Packing. In the Mixing Department, chicken and...
-
Design a plastic disk to perform the calculations given by Model (2.13). Data from model 2.13 This computation leads to the model W = 0.0196/g (2.13)
-
What are some sources of financial information?
-
Prepare journal entries to record the transactions in E12- 3. In E12- 3. For each of the following transactions, identify the net asset classification ( unrestricted, temporarily restricted,...
-
Can accountancy be considered a profession? Explain your answer. When is a CPA considered to be in: Public practice? Commerce and industry? Education or the academe? Government? How is the...
-
Daniel Company uses a periodic inventory system. Data for 2015: beginning merchandise inventory (December 31, 2014), 2,000 units at $38; purchases, 8,000 units at $40; expenses (excluding income...
-
BMX Company has one employee. FICA Social Security taxes are 6.2% of the first $137,700 paid to its employee, and FICA Medicare taxes are 1.45% of gross pay. For BMX, its FUTA taxes are 0.6% and SUTA...
-
The Accounts receivable balance for Turning Leaves Furniture Restoration at December 31, 2010, was \($15,000\). During 2011, Turning Leaves completed the following transactions: a. Sales revenue on...
-
The source document used to specify the quantity and unit costs of raw materials issued into production is called a: a. Production order form. b. Materials requisition form. c. Direct labor time...
-
Why would a company use process costing rather than job order costing to compute product cost? a. The company produces units to customer specifications. b. The company manufactures a product using a...
-
Analyse a number of companies statements of financial position and calculate their current ratios, liquidity ratios and capital gearing ratios for the last two years. What do these ratios tell you...
-
Foleys Furniture Repair had trouble collecting its account receivable from Steve Stone. On July 19, 2012, Foleys finally wrote off Stones \($900\) account receivable. Foleys turned the account over...
-
Use the following information for all questions related to Colchuck Company. Colchuck Company has the following information for Year 1 and Year 2 . Year 1 is Colchuck's first year in business. Year 1...
-
Write electron configurations for the following ions, and determine which have noble-gas configurations: (a) Cd2+ (b) p3- (c) Zr4+ (d) Ru3+ (e) As3- (f) Ag+
-
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...
-
Use lists to find the LCM of 12 and 15.
-
Using prime factorization, determine the greatest common divisor of 120 and 200.
-
There are three gym classes. The number of students in the classes is 21,35 , and 28 . What is the largest team size that can be formed if teams from every class must have the same number of students?
Study smarter with the SolutionInn App