Question 2: Spencer Enterprises is attempting to choose among a series of new investment alternatives. The potential investment alternatives, the net present value of the future stream of returns, the capital requirements, and the available capital funds over the next three years are summarized as follows: Alternative Limited warehouse expansion Extensive warehouse expansion Test market new product Advertising campaign Basic research Purchase new equipment Capital funds available Net Present Value ($) Year 1 Year 2 Year 3 3000 1000 4000 2000 1500 1800 2500 3500 3500 6000 4000 5000 5000 1000 4000 1000 500 900 10500 7000 8750 4000 6000 10500 4000 8000 3000 (a) Develop and solve an optimization model for maximizing the net present value. (b) Assume that only one of the warehouse expansion projects can be implemented. How do you model this restriction?

Question 2: Spencer Enterprises is attempting to choose among a series of new investment alternatives. The potential investment alternatives, the net present value of the future stream of returns, the capital requirements, and the available capital funds over the next three years are summarized as follows: Alternative Limited warehouse expansion Extensive warehouse expansion Test market new product Advertising campaign Basic research Purchase new equipment Capital funds available Net Present Value ($) Year 1 Year 2 Year 3 3000 1000 4000 2000 1500 1800 2500 3500 3500 6000 4000 5000 5000 1000 4000 1000 500 900 10500 7000 8750 4000 6000 10500 4000 8000 3000 (a) Develop and solve an optimization model for maximizing the net present value. (b) Assume that only one of the warehouse expansion projects can be implemented. How do you model this restriction?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Perform cost-benefit analysis and describewhat is meant by the time value of money,present value, discount rate, net present value,return on investment, and break-even analysis.
Plan for potential investors for 39 Storage https://www.39storage.com/ (This Company) Cover these points below Identify the problem to be solved. Introduce your solution to the problem. Discuss your beginning traction for getting sales. Identify the target market. Explain the costs of acquiring customers in your target market. Communicate the value proposition relative to competitors. Describe the basics of the revenue model. Provide financial projections, along with the assumptions. Sell the team. Identify your funding needs, and explain the use of the funds (the investment price must be stated) Describe possible exit strategies—how the investors may be able to cash out. End on a high note—remind investors why your product/service/team is so great.
2 To produce a Strategic Direction to facilitating growth (figure 1b). Please indicate the strategic direction into Information Technology Strategy, Structure and Funding
⁴ using the integrated marketing mix, make a plan by which a restaurant can plan to survive current Covid 19 situation and amid upcoming crisis .
Indicate the trading strategy for Compulectrics, American Rubber and Gold Mines Expected Return Beta T-Bills 8% 0 Index Funds 15% 1 Compulectrics 17.4% 1.29 American Rubber 13.8% 0.68 Gold Mines 1.7% 0.86
Explain Briefly. 1. In selecting a target market, what must the engineer manager do? 2. Determination of fund requirements are? Describe each. 3. What are the sources of Funds? Explain each.
ro forma income statement. Given the income statement , for California Cement Company for 2013 and an expected sales growth rate of 6.67% for 2014, prepare a pro forma income statement for 2014. First, find the percentage of each income statement line from 2013 as a percent of sales. (Round to three decimal places.) California Cement Company Income Statement for 2013 Sales revenue $ 22,869,000 Cost of goods sold $ -11,637,000 Selling, general, and administrative expenses $ -3,993,000 Depreciation expenses $ -1,331,000 EBIT $ 5,908,000 Interest expense $ -175,000 Taxable income $ 5,733,000 Taxes $ -2,512,462 Net income $ 3,220,538 What is the sales forecast for 2014? (Round to the nearest dollar.) The pro forma income statement for 2014 is: (Round to the nearest dollar.) California Cement Company Pro Forma Income Statement for 2014 Sales revenue $ ? 100.00% Cost of goods sold $ ? 50.885 %…
To find the net present values of future cash flows for six different discounted rate of interest, use: a. Data Table b. Goal Seek c. None of these d. Scenario manager
Identify the Generic Strategy that PennyMac Financial Services Inc is using to compete currently. Other Significant strategies? Give as much details as possible.
Use the following financial statements of Heifer Sports Inc. in Table 14.14 to find Heifer’s:a) Inventory turnover ratio in 2012.b) Debt/equity ratio in 2012.c) Cash flow from operating activities in 2012.d) Average collection period.e) Fixed-asset turnover ratio.f) Return on equity.
A company that pursues and achieves strategic objectives: Answer C) is frequently in a better position to improve its future financial performance because of the increased competitiveness that flows from the achievement of strategic objectives. D) is likely to be a weak financial performer because diverting resources to the pursuit of strategic objectives takes away from the achievement of financial performance targets. B) is generally not strongly focused on its true mission of making a profit. A) is likely to weaken the achievement of its short-term and long-term financial objectives.
What was interesting about the AstraZeneca Shares Drop on Weak Quarterly Report Despite 2024 Growth Guidance? What was educational about the AstraZeneca Shares Drop on Weak Quarterly Report Despite 2024 Growth Guidance? What was insightful about the AstraZeneca Shares Drop on Weak Quarterly Report Despite 2024 Growth Guidance?