Determine impact of implementation of new technologies

Assignment Help Financial Management

Reference no: EM131458210

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.

a) What is the minimum cost in your optimal solution (the value of the objective function)?

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?

Reference no: EM131458210

Questions Cloud

What is the current value of one share of this stock : The Bell Weather Co. is a new firm in a rapidly growing industry. What is the current value of one share of this stock if required rate of return

Define the identical contracts : Given the difference between forward rate agreements and interest rate futures contracts, would you expect the FRA rate to equal the futures interest rate.

Identify the privacy concerns highlighted in the scenario : Identify the privacy concerns highlighted in the scenario. How could these privacy concerns create risk for the employer?

Find two articles describing firms : You will use the Internet to find two articles describing firms' use of a cooperate strategy:

Determine impact of implementation of new technologies : A student project at WCU was initiated to try to determine the impact of implementation of new technologies.

Summarize the steps necessary to set up a wireless network : Summarize the steps necessary to set up a wireless network. Summarize how the wireless developments over the last 5 years have impacted networking.

Define case study of procter and gamble versus bankers trust : Procter and Gamble versus Bankers Trust: Caveat Emptor (Thunderbird Case A06-05-0001, European Case Clearing House). The case analyzes a complex interest rate.

Establishing smart policies : What major organizations are leading the way toward establishing smart policies and what benefits have those organizations received.

Describe and evaluate what chares schwab is doing : How might the company's culture of not buying into hype and not taking exercise risks affects its organizational structure design?

User Account

All Pages