Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. 16. a developer of video game software has seven p

16. A developer of video game software has seven proposals for new games. Unfortunately, the company cannot...

70.2K

Verified Solution

Question

Accounting

16. A developer of video game software has seven proposals fornew games. Unfortunately,
the company cannot develop all the proposals because its budget fornew projects
is limited to $950,000, and it has only 20 programmers to assign tonew projects.
The financial requirements, returns, and the number of programmersrequired 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 ofthese
projects cannot be selected because the programmer with thenecessary skills can be
assigned to only one of the projects. (Note: All dollar amountsrepresent 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
a. Formulate an ILP model for this problem.
b. Create a spreadsheet model for this problem and solve it.
c. What is the optimal solution?

Answer & Explanation Solved by verified expert
3.8 Ratings (515 Votes)
a Let each project be assigned a binary variable The binary variable will represent if a    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Algebra
1.2K views

Make a table of values for the function f x 3 x 1 X y...

Finance
1.2K views

Here are the three scenarios of the state of the economy in a country A: State...

Basic Math
1.2K views

A mass weighing 20 pounds stretches a spring 6 inches. The mass is initially released from...

Biology
1.2K views

DNA fingerprinting requires a process called gel in which electricity is used to move molecules...

Basic Math
1.2K views

What should go in the green box A 18 17 15 Enter a b c...

Calculus
1.2K views

Divide.(-10x+7x-5)(2x-3)Write your answer in the following form: Quotient +

Algebra
1.2K views

Find the distance between the given pair of points on the number line 1 5...

Accounting
1.2K views

explain the difference between pioneer status and investment tax allowance and their tax benefit

Accounting
1.2K views

Imperial Jewelers manufactures and sells a gold bracelet for $402.00. The companys accounting system says...

Accounting
1.2K views

MSI is considering eliminating a product from its ToddleTown Tours collection. This collection is aimed...

Accounting
1.2K views

amortization of premium using the straight-line method. If an amount box does not require an...

Finance
1.2K views

You are to receive $0 at the end of year one, $30 at the end...