What is the optimal solution

Assignment Help Business Management
Reference no: EM132987234

A developer of video game software has seven proposals for new games. Unfortunately, the company cannot develop all the proposals because its budget for new projects is limited to $950,000, and it has only 20 programmers to assign to new projects. The financial requirements, returns, and the number of programmers required by each project are summarized in the following table. Projects 2 and 6 require specialized programming knowledge that only one of the programmers has. Both of these projects cannot be selected because the programmer with the necessary skills can be assigned to only one of the projects. (Note: All dollar amounts represent thousands.)

Project, Programmers, Required Capital, Required Estimated NPV

1 7 $250 $650

2 6 $175 $550

3 9 $300 $600

4 5 $150 $450

5 6 $145 $375

6 4 $160 $525

7 8 $325 $750

b. Create a spreadsheet model for this problem and solve it.

c. What is the optimal solution?

Reference no: EM132987234

Questions Cloud

Discuss the financial performance and financial position : Discuss the financial performance, financial position and cash flow of these two companies: a. By referring to balance sheet, income statement
Consequences of the hock lee bus riot in singapore : What were the causes and the long-term consequences of the Hock Lee Bus Riot in Singapore?
Meal planning : When working in the nutrition field, it is important to understand the meal planning process.
Basic pieces of passenger information : Your customers are a family of four who lives in Toronto. They want to spend a week in Puerto Vallarta on vacation from November 01 to November 08, 2021. hold b
What is the optimal solution : A developer of video game software has seven proposals for new games. Unfortunately, the company cannot develop all the proposals because its budget for new pro
Calculate the calorie requirements : First, you need to calculate the calorie requirements for your case study
Compute the total value of the ninty-two bonds : Compute the total value of the 92 bonds. The Florida Investment Fund buys 92 bonds of the Gator Corporation through a broker.
Statistical process control in quality system : Discuss the integration of acceptance sampling with statistical process control in a quality system. What is meant by the term "statistically valid?"
What is return rate that bond investors are seeking : The United States treasury bond rate is 2.75% and Jones's beta is 0.90. Jones's tax rate is 25%. What is return rate that bond investors are seeking form Jones?

Reviews

Write a Review

Business Management Questions & Answers

  Ingredients for starting a successful business

What would it take for you to start one? Would you be as thorough as the subject of the article "Death of Gut Instinct" by Joshua Hyatt?

  What the most appropriate visualisations for the dashboard

MIS171 Business Analytics Assignment, DEAKIN BUSINESS SCHOOL, Australia. What are the most appropriate visualisations for the dashboard

  Development of marketing strategy

Why is marketing research important to the development of a marketing strategy? Provide a specific example.

  What is the purpose of the indenture

What is the purpose of the indenture? How do I identify sources of risk to the bondholder?

  Was ling bound to this contract with pro golf industry

explain however, informed pro shops or retailers of the limitation on Karsten's authority. Nonetheless, Karsten, anxious to make a big sale, made a contract to sell 700 pairs of Ling golf shoes to Pro Golf Industry. Was Ling bound to this contract..

  Why is remm more complete

-What sets REMM apart (in particular, from the economic model)?

  Resistance to change questionnaire

Imagine taking an automated "Resistance to Change Questionnaire" test and below is the automated result you get from the test:

  Is the us economy male-dominated

Is the U.S. economy male-dominated? Give reasons to explain your answer

  Stacks of? coal-fired electricity generating? plants

The EPA is planning to stiffen the requirements for cleaning pollutants from the stacks of? coal-fired electricity generating? plants

  Event of getting two heads

Three fair coins are tossed. Let E be the event of getting one head and let F be the event of getting two heads. Find P(F|E) and P(E|F).

  Design a program that displays a table of the centigrade

Design a program that displays a table of the centigrade temperatures 0 through 20 and their Fahrenheit equivalents.

  Importance of collective bargaining agreement

Please explain the definition and importance of Collective Bargaining Agreement as a simple two-way conversationin which the participants attempt to resolve the

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