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

  Best illustrates the dynamics

With the approach of night, our body temperatures begin to drop. This best illustrates the dynamics of the

  What is emotion

What is emotion? In what types of social settings might an individual observe the following emotions: sadness, anger, disgust, nervousness, and happiness?

  In designing the layout for an orthopedic hospital

In designing the layout for an orthopedic hospital, describe how the design might be affected by the most important flow component being designated to be either patients, doctors, nurses, or access to expensive diagnostic equipment such as x-ray, cat..

  Racial ideologies and their effects on society

For the period from 1500 to 1830, compare North American racial ideologies and their effects on society with Latin American/Caribbean racial ideologies and their effects on society.

  Required for contract modification

Gross v. Diehl Specialties International, Inc. 1. Why did the court determine that plaintiff's postemployment benefits should revert to those in his original contract instead being limited to those in the modified contract? 2. What argument did defen..

  Discuss the stanford prison study

Critically discuss the Stanford Prison Study done by Philip Zimbardo in the early 1970s. Discuss how Zimbardo's findings apply to similar real-life examples.

  Rank each of the six lunar positions

Rank each of the six lunar positions from left to right based on the amount of the Moon’s illuminated surface that is visible from Earth, from greatest to least.

  Describes herself as confident and trusting

Janice describes herself as confident and trusting, and she displays both high self-esteem and high self-efficacy. The dimension of health this relates to is the

  Expressed about reality or unreality of god

What are the different views expressed about the reality or unreality of God? Provide detail such as, notions of monotheism, pantheism, polytheism, atheism, agnosticism, immanence, animism, and transcendence.

  Ethics in their long term business dealings

What do companies have to do to have successful ethics in their long term business dealings? Look for resources on the Internet and summarize the best practices you find. (Provide references)

  Display of graphics on web sites

New Apps Company develops “Browser Lite,” software to speed the display of graphics on Web sites. Browser Lite has the most copyright protection under

  Explain the diminishing effectiveness of reconstruction

The immediate cause for the Texan Americans' declaration of independence on March 2, 1836 was that. Which of the following does not help to explain the diminishing effectiveness of Reconstruction in the South?

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