Summarizes the initial cost and revenue potential

Assignment Help Finance Basics
Reference no: EM131332873

A company has $1, 00,000 to invest in new R&D projects. The company wants to determine what set of projects should be selected.  

The following table summarizes the initial cost and revenue potential for each of the projects. 

Project

Initial Cost

Expected Revenue

1

$500,000

$1,500,000

2

$500,000

$1,500,000

3

$500,000

$1,800,000

4

$500,000

$1,800,000

a.) Formulate an LP model for this problem with the objective of maximizing total profit.

b.) Implement your model in a spreadsheet and solve it

c.) What is the optimal solution?

Reference no: EM131332873

Questions Cloud

An otherwise identical but levered firm : An unlevered firm has a value of $525 million. An otherwise identical but levered firm has $50 million in debt. Under the MM zero-tax model, what is the value of the levered firm? Enter your answer in millions. For example, an answer of $1.2 million ..
Examine the conversations of two married couples : The narrative dialogues "Home Burial" and "The Death of the Hired Man" examine the conversations of two married couples. In a carefully constructed paper of 1,500-1,750 words, compare and contrast the two poems.
Perfectly efficient market an active strategy mutual fund : In a perfectly efficient market, an active strategy mutual fund that charges a 1% fee has about a 47% chance of beating the index net of fee. In a universe of 5,000 funds, how many funds would you expect to beat the index all but once out of the past..
What is the sellers expected revenue : Find a symmetric equilibrium.- What is the seller's expected revenue?- Which entry fee maximizes the seller's expected revenue?
Summarizes the initial cost and revenue potential : A company has $1, 00,000 to invest in new R&D projects. The company wants to determine what set of projects should be selected.  The following table summarizes the initial cost and revenue potential for each of the projects.
Discount stock brokerages impact the internet revolution : How can you compare "tulip mania" from 17th century Holland to the dot.com debacle of the 20th century from a financial point of view? Name and explain three ways in which the Internet revolution changed the lives of ordinary citizens. How did the bi..
What is the sellers expected revenue : Find a symmetric equilibrium.- What is the seller's expected revenue?- Which entry fee maximizes the seller's expected revenue?
Develop an action plan of key events and activities : Develop an action plan of key events and activities that they can undertake over the next 6 months to acquire the knowledge, skills and behaviours identified as requiring development in Section 1.
Dividends to be qualified under current tax laws : A fund has $829 million dollars of assets, $27 million of liabilities, and 13 million shares outstanding. During the year the fund made qualified dividend distributions of $2.8 per share, long term capital gains distributions of $1.9, and short-term ..

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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