Using the attached template answer the following question. (Note that the data from P06_40.xlsx is already in the excel sheet)You are given a group of possible investment projects for your company’s capital. For each project, you are given the NPV the project would add to the firm, as well as the cash outflow required by each project during each year. Given the information in the file P06_40.xlsx, determine the investments that maximize the firm’s NPV. The firm has $25 million available during each of the next five years. All numbers are in millions of dollars. LE34581223222581 Capital budgeting7 Year 18 Year 2Year 310 Year 411 Year 512 NPV161718 Budget constraints1920 Year 121 Year 2A22 Year 323 Year 424 Year 527Note: All cash amounts are in $millions.29Cash outflows in various years, NPV of projectsProject 1$126 Total NPV30x ✓ fx14 Selected projects (1 if selected, 0 if not)ÞBPG-40555552$3$2$1$2COutflowDR AProject 2 Project 3 Project 4$3$4$4$4555555$3$1$1$30DProject 1 Project 2 Project 3$3$2$3$35BudgetE*******$6$5$2$2$8$40******$1$2$3$5- 12Project 5 Project 6 Project 7 Project 8 Project 9 Project 10 Project 11 Project 12$5$2$0$9$8$42G**555*$4$5$1H$5$6$2055555$3$3$4$7$30$0$4$6$3$31General$%9$1$1$4265333E$8$33$6fun.cc5$3$2$4$1$35$1538-28$2$1$1$1$37Project 4 Project 5 Project 6 Project 7 Project 8 Project 9 Project 10 Project 11 Project 12$754$2$1538MTell meConditional FormattFormat as TableCell StylesN

Given data is Available to invest = $25 million per year

Using the attached template answer the following question. (Note that the data from P06_40.xlsx is already in the excel sheet) You are given a group of possible investment projects for your company’s capital. For each project, you are given the NPV the project would add to the firm, as well as the cash outflow required by each project during each year. Given the information in the file P06_40.xlsx, determine the investments that maximize the firm’s NPV. The firm has $25 million available during each of the next five years. All numbers are in millions of dollars.

Using the attached template answer the following question. (Note that the data from P06_40.xlsx is already in the excel sheet) You are given a group of possible investment projects for your company’s capital. For each project, you are given the NPV the project would add to the firm, as well as the cash outflow required by each project during each year. Given the information in the file P06_40.xlsx, determine the investments that maximize the firm’s NPV. The firm has $25 million available during each of the next five years. All numbers are in millions of dollars.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter7: Nonlinear Optimization Models

Section7.6: Models For Rating Sports Teams

Problem 28P

See similar textbooks

Similar questions

At the beginning of month t, farmer Smith has xtbushels of wheat in his warehouse. He has the opportunityto sell wheat at a price st dollars per bushel and can buywheat at pt dollars per bushel. Farmer Smith’s warehousecan hold at most C units at the end of each month.a Formulate a recursion that can be used to maximizethe total profit earned during the next T months.b Let ft(xt) be the maximum profit that can be earnedduring months t, t 1, . . . , T, given that xt bushels of wheat are in the warehouse at the beginning of month t. By working backward, show that for appropriately cho-sen constants at and bt, ft(xt) at btxt c During any given month, show that the profit-maximizing policy has the following properties: (1) The amount sold during month t will equal either xt or zero.(2) The amount purchased during a given month will beeither zero or sufficient to bring the month’s endingstock to C bushels.
The below is an extract from the fixed asset register of ABC Ltd as at 31 December 2019Date of PurchaseCostuseful lifeLand1-Jan-306,000,000.000Building28-Feb-172,000,000.0020Vehicle:650,000.00Toyota Hilux1-Oct-19 350,000.005Ford Ranger30-Jun-17 300,000.005Furniture and Fittings1-May-20150,000.002Activities throughout the 2020 Financial Period:1. New Machinery have been purchased on 01 April 2020 at a Cost of N$ 4000,000. The machinery has been installed on the 15 April 2020 and was available for use on the 01 May 2020. Machinery is the only property plant and equipment of the company that is measured according to the revaluation method.1.1. On the 30th of October 2020 management decided to revalue the machinery due to a drastic decline in the revenue from sale of machinery produced inventory.Net replacement cost for the machine as at the 30th of October 2020 is N$2 000 000.2. The Toyota Hilux was involved in an accident on 1 October 2020 due to the floods and was written off by the…
Based on the following sensitivity analysis, which of the following products would be considered most sensitive to changes or errors in the objective function coefficient? Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient AllowableIncrease AllowableDecrease $B$2 Product_1 0 −2 25 11 4 $B$3 Product_2 175 0 25 12 14 $B$4 Product_3 0 −1.5 25 8 5 Constraints Cell Name Final Value Shadow Price Constraint R.H.Side AllowableIncrease AllowableDecrease $H$9 Resource_A 0 0 100 1E+30 100 $H$10 Resource_B 525 0 800 1E+30 275 $H$11 Resource_C 700 1.75 700 366.6666667 700 multiple choice Product_1 Product_2 Product_3
Ariel holds a $10,000 portfolio that consists of four stocks. Her investment in each stock, as well as each stock’s beta, is listed in the following table: Stock Investment Beta Standard Deviation Andalusian Limited (AL) $3,500 0.80 15.00% Kulatsu Motors Co. (KMC) $2,000 1.50 12.00% Western Gas & Electric Co. (WGC) $1,500 1.20 16.00% Makissi Corp. (MC) $3,000 0.50 22.50% Suppose all stocks in Ariel’s portfolio were equally weighted. Which of these stocks would contribute the least market risk to the portfolio? Makissi Corp. Andalusian Limited Western Gas & Electric Co. Kulatsu Motors Co. Suppose all stocks in the portfolio were equally weighted. Which of these stocks would have the least amount of standalone risk? Western Gas & Electric Co. Makissi Corp. Andalusian Limited Kulatsu Motors Co. If the risk-free rate is 4% and the market risk premium is 6%, what is Ariel’s…
Based on the following sensitivity analysis, which of the following products would be considered most sensitive to changes or errors in the objective function coefficient? Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient AllowableIncrease AllowableDecrease $B$2 Product_1 0 −2 25 10 5 $B$3 Product_2 175 0 25 10 14 $B$4 Product_3 0 −1.5 25 8 6 Constraints Cell Name Final Value Shadow Price Constraint R.H.Side AllowableIncrease AllowableDecrease $H$9 Resource_A 0 0 100 1E+30 100 $H$10 Resource_B 525 0 800 1E+30 275 $H$11 Resource_C 700 1.75 700 366.6666667 700 Choose the product Product 1 Product 2 Product 3
2) A buyer for a large sporting goods store chain must place orders for professional footballs with the footballmanufacturer six months prior to the time the footballs will be sold in the stores. The buyer must decidein November how many footballs to order for sale during the upcoming late summer and fall months.Assume that each football costs the chain $45. Furthermore, assume that each can be sold for a retail priceof $90. If the footballs are still on the shelves after next Christmas, they can be discounted and sold for$35 each. The probability distribution of consumer demand for these footballs (in hundreds) during theupcoming season has been assessed by the market research specialists and is presented below. Finally,assume that the sporting goods store chain must purchase the footballs in lots of 100 units. Demand Probability 4 0.30 5 0.50 6 0.20 a) Construct a decision tree…
A. Write a document with the following information: 1. What do you expect your job to pay when you start? 2. What benefits are musts for you? 3. What benefits would you like to have even though they are not musts? 4. Include the graph you generate in step B below. B. Create a spreadsheet and a graph of life vs funds For each year of your remaining life specify the amount you plan to save/invest/withdraw that year and how much you expect that amount to increase during the year (base on actual data – typical savings interest rate, typical stock market interest rate, typical CDs, typical…). Calculate how much your funds will increase/decrease over your life and create a life (x-axis) vs funds (y-axis) plot.
Based on the following sensitivity analysis, which of the following products would be considered most sensitive to changes or errors in the objective function coefficient? A. Product_2 B. Product_1 C. Product_3 Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient AllowableIncrease AllowableDecrease $B$2 Product_1 0 −2 25 13 5 $B$3 Product_2 175 0 25 8 9 $B$4 Product_3 0 −1.5 25 11 3 Constraints Cell Name Final Value Shadow Price Constraint R.H.Side AllowableIncrease AllowableDecrease $H$9 Resource_A 0 0 100 1E+30 100 $H$10 Resource_B 525 0 800 1E+30 275 $H$11 Resource_C 700 1.75 700 366.6666667 700
Consider a monopolistically competitive market with NN firms. Each firm's business opportunities are described by the following equations: Demand: Q=100N−PQ=100N−P Marginal Revenue: MR=100N−2QMR=100N−2Q Total Cost: TC=50+Q2TC=50+Q2 Marginal Cost: MC=2QMC=2Q How much profit does each firm make? a: 1,250/N*2−50 b: 2,500/N*2−50 c: 50+625/N*2 d: 1,875/N*2 In the long run, how many firms will exist in this market?
Ning Caterers quotes a price of P940.80 per person for a banquet dinner. This priceincludes the 12% VAT and 20% service charge. The VAT is computed based on thefood’s selling price plus the service charge. The service charge is computed based onthe food’s selling price only. At what amount does Ning Caterers price the food?a. P710.77 c. P613b. P700.00 d. P840 show the solution please
4. Spears Rowbuck has recorded the following sales figures. Calculate the seasonal indices for Thursday and Friday. Week 1 Week 2 Week 3 Week 4 Monday 43 51 40 66.0 Tuesday 45 41 57 58.6 Wednesday 22 37 30 34.7 Thursday 25 22 33 36.7 Friday 31 25 37 25.0 a. Thursday = 29.18, Friday = 29.50 b. Thursday = 0.2074, Friday = 1.1632 c. None of the other options. d. Thursday = 0.7678, Friday = 0.7763 e. Thursday = 0.6142, Friday = 0.6211
The general fund revenue receipts for the state of Kentucky for 2003 (period 1) to (period 15 ) follows. Do not round intermediate calculations. Budget Year Period ($billions) 2003 1 6.785 2004 2 6.973 2005 3 7.647 2006 4 8.373 2007 5 8.579 2008 6 8.666 2009 7 8.428 2010 8 8.223 2011 9 8.755 2012 10 9.097 2013 11 9.301 2014 12 9.554 2015 13 9.963 2016 14 10.334 2017 15 10.474 A. Develop a linear trend equation for this time series. Round your answers to 4 decimals. Tt = ____+ _____t B. What is the forecast for 16 period ? Round your answer to two decimal places. $_____billion