Team budgeting information volunteers forecasting

Assignment Help Other Subject
Reference no: EM13334408

Must use excel for all work

Problem 2. A professor has been contacted by four not-for-profit agencies that are willing to work with student consulting teams. The agencies need help with such things as budgeting, information systems, coordinating volunteers, and forecasting. Although each of the four student teams could work with any of the agencies, the professor feels that there is a difference in the amount of time it would take each group to solve each problem. The professor's estimate of the time, in days, is given in the table below. Use the computer solution to see which team works with which project.

Projects

Team Budgeting Information Volunteers Forecasting

A 32 35 15 27

B 38 40 18 35

C 41 42 25 38

D 45 45 30 42

a. Formulate an LP to find the which team works with which project , so that the total time is minimized

b. Find the optimal Solution using Excel

Reference no: EM13334408

Questions Cloud

What is the new critical path and earliest completion time : The R&D dept. is planning to bid on a large project for the development of a new communication system for commercial planes. The accompanying table shows the activities, time & sequence required
Explain the standard cell potential for the reaction : The standard cell potential for the reaction below is +0.63 V. The cell potential for this reaction is __________ V when Zn2+ = 3.5M and Pb2+ = 2.0x10^-4 M. Pb2+ (aq) + Zn (s) --> Zn2+ (aq) + Pb(s)
Three different representatives to visit what is probability : The United States House of Representatives has 78 women representative with 59 being democrats and 19 being republicans. If a lobbyist for AARP randomly selects three different representatives to visit what is the probability
Obtain the anisotropic effective mass of the electrons : The energy momentum relationship for the conduction band of a 3D semiconductor is: E= (h bar)^2/2m*[k(x)^2/2+k(y)^2+k(z)^2]
Team budgeting information volunteers forecasting : A professor has been contacted by four not-for-profit agencies that are willing to work with student consulting teams. The agencies need help with such things as budgeting, information systems, coordinating volunteers, and forecasting.
Compute how long will it take to hit the ground : The seed has a mass of 250 mg., a functional lift-to-drag ratio of 4.0, a lift coefficient under the same conditions of 0.3, and a wing area of 5000 mm2. How long will it take to hit the ground
Explain what is the partial pressure of oxygen : A gaseous mixture of O2 and N2 contains 38.8% nitrogen by mass. What is the partial pressure of oxygen in the mixture if the total pressure is 365mmHg
3310 telephone polls and 1855 home polls : The We Poll Them service has been engaged to make 3310 telephone polls and 1855 home polls
Improvement to make communication more effective : Collect samples of a series of incoming and outgoing letters of the organization selected. Analyze these letters to determine whether principles and techniques explained in the book of communication were observed or not

Reviews

Write a Review

Other Subject Questions & Answers

  Compatibility-relative advantage-observability

Describe three products whose adoption rates have been affected by complexity, compatibility, relative advantage, observability, and / or trialability.

  Cut of manpower numbers according to crime statistics

present the need or cut of manpower numbers according to the crime statistics you obtained and analyzed that will make the police department decisively more efficient by drops of crime rates in the worst crimes presented by your data.

  Research project-sociological

Write a hypothesis that pertains to sociology i.e homelessness, drug abuse, violence etc. Identify the independent and dependent variables

  Greenhouse gases and global climate

The methods used in Stern Review should be discussed critically- especially the use of discounting

  Anti-drug legislation analysis

Which you assess federal and state anti-drug legislation. Compare and contrast the similarities and differences among various states, as well as federal policy. Be sure to examine the proposition of legalization of certain drugs and the potential imp..

  About unified system of justice

Why doesn't the United States have a unified system of justice instead of the current fragmented, patchwork system of competition.

  Virtual reality created by the computer

In The Matrix, the world Neo lives in proves to be virtual reality created by the computer. How do technologies influence or distort our perceptions? To what extent can we trust our senses to perceive the reality around us?

  Complementary or alternative healthcare

How are complementary or alternative healthcare options different from traditional healthcare? Are there any similarities? What are the risks of alternative and traditional healthcare?

  Selective advantages of bipedality for these hominins

What structural changes were selected for in early hominins to facilitate bipedality and what were the selective advantages of bipedality for these hominins?

  Implications of tax

A popular local actress agreed to sell her life story to a weekly magazine . Under the contract the actress was to be paid $ 25000 on signing the agreement and $ 75000 on completion of the manuscript .

  Cosmic microwave background radiation is the radiation left

I thought the big bang was hot! If the cosmic microwave background radiation is the radiation left over from the big band, why is it only 3k?

  Explain different preclassical thinkers

Write down the different preclassical thinkers recognized in this lesson. What ideas did each contribute to Enlightenment philosophy?

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