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

  Demonstrating slant in criminal justice system

The numerous protections found in the Bill of Rights for those charged with criminal offenses seem to demonstrate this slant in the criminal justice system. Do you agree with this philosophy? Why or why not?

  Explain forces of influence through critical thinking

What forces of influence must be considered while recognizing the problem through critical thinking? What methods can be utilized during problem formulation?

  Role of intent in criminal la

What is the role of intent in criminal law?

  Describing casualty gap

One of best examples of the way in which social class affects life chances is idea of "The Casualty Gap". The burdens of war, including, importantly, the dying

  Private developers or government officials

Problems sometimes arise between applied anthropologists and private developers or government officials. Many agencies want to implement changes immediately and without consideration for the people who will be impacted

  Methods for recruitment involves individuals applying

Which of the following methods for recruitment involves individuals applying for positions at an organization with out any prompting from the organization?

  Types of legal citations are found in blue book of citation

What 2 types of legal citations are found in the blue book of citation format. I think one is for citing legal memorandum and the other is ?. Please elaborate as to the differences in each style and why they are different.

  Describe the hertzsprung-russel diagram

Describe the Hertzsprung-Russel diagram. How is it useful in classifying stars? Where do stars tend to cluster on the diagram? Where on the H-R diagram does a star spend most of its life?

  Healthy baby

There are numerous things that pregnant women should and should not do to have a healthy baby. Pick one and explain why it is so important. Please answer in 160 words or less and include the url or reference used.

  Long term care facility and healthcare

Will you please enumerate what duties of a facility you find to be paramount and why and please state reasons for priorities and where you feel these duties clash?

  Explaining the bankruptcy and reorganization

Should the petition for involuntary bankruptcy be granted? Explain. Can the bankruptcy court confirm the debtor's plan of reorganization? Explain. 3) Who may file Chapter 7 bankruptcy? How has this changed over the past year?

  Wheat is dependent on number of inherited pigment genes

Kernal color in wheat is dependent on the number of inherited pigment genes that are additive in their effects. If an uppercase letter contributes pigment but a lowercase does not, what color of wheat kernels would be expected in the progeny when a p..

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