Five projects are reviewed over a five-year period to evaluate the expected rate of return. The table below shows the expected profits as well as the related annual cost to the project. We want to know that, In a five-year period, choosing which of these projects is cost-effective? Write the desired mathematical model (explain your logic). annual cost Project 2 expected profit 4 4 32 4 4 4 7. 35 2 4 8. 3 40 4 5. 3 7. 6. 31 15 6 8. 9. 2. 25 Available credit 65 62 68 70 75 64 4. 3.

Five projects are reviewed over a five-year period to evaluate the expected rate of return. The table below shows the expected profits as well as the related annual cost to the project. We want to know that, In a five-year period, choosing which of these projects is cost-effective? Write the desired mathematical model (explain your logic). annual cost Project 2 expected profit 4 4 32 4 4 4 7. 35 2 4 8. 3 40 4 5. 3 7. 6. 31 15 6 8. 9. 2. 25 Available credit 65 62 68 70 75 64 4. 3.

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

1. Suppose we have a project with the following cash flows and required return. What is the NPV and IRR of the project? t 0 $ Cash flow (250,000) 1 234567 Return: NPV: IRR: 41,000 48,000 63,000 79,000 88,000 64,000 41,000 12% 2. Given the information of Stock A, please figure out the expected return, variance, and standard deviation of the stock. (6) (5) Squared (1) State of (2) (3) (4) Probability of Return if State Product Return Deviation from Expected Return Return Deviation from Expected (7) Product Economy State Occurs (2) × (3) (3) - E(R) Return (2) x (6) Boom 0.2 0.24 Normal 0.5 0.11 Recovery 0.2 0.02 Recession 0.1 -0.013 Expected return= Variance = The standard deviation is the square root of the variance, so the standard deviation is: Standard deviation:
Instruction: Conduct a SWOT Analysis for the College of Business Administration and Accountancy. Minimum of three (3), Maximum of 7. Do not write anything in the colored area of the matrix. Table 1. SWOT Matrix for CBAA 1. 2. 3. 4. 5. 6. 7. 2. 3. 4. 5. 6. 7. SWOT MATRIX CBAA OPPORTUNITIES THREATS 1. 2. 3. 7. STRENGTHS 1. 2. 3. 4. 5. 6. 7. WEAKNESSES Page 1 of 2
Upp
Emerson Electric is considering the purchase of equipment that will allow the company to manufacture a new line of wireless devices for home appliance control. The first cost will be $80,000 and the life estimated is 6 years with a salvage value of $10,000. Three different salespeople have provided estimates regarding the added revenue the equipment will generate. Salespersons 1,2, and 3 have made estimates of $10,000 , $16,000 , and $18,000 per year respectively if the Companys MARR is 8% per year find the PW of each salespersons estimates.
An R&D project in a company is working on a project to make a sample product to be displayed at an international fair in Las Vegas held in 18 months. With additional equipments, the company can make sure they make the sample in 18 months. Develop an optimal crashing time-cost solution to help the company in this project to be ready on time for the fair. C, 4 B, 3 А,5 H,7 D, 3 F, 9 G, 2 Cost per month Activity Normal Time to crash 9,000 4,000 6,000 4,000 2,000 5,000 2,000 9,000 A В C 4 E F 9. G 2 H 7 Duration Path Activity to crash (months) АВСН ADEH FGH
What is the future value of $50,000.00 invested this year @ 5%, for 15 years?
The table shows the hypothetical trade-off between different combinations of Stealth Bombers and B-1 Bombers that might be produced in a year with the limited U.S. capacity, ceteris paribus. Production Possibilities for Bombers Combination Number of B-1 Opportunity Cost (Foregone Stealth) S T 0 NA Number of Stealth 10 Opportunity Cost (Foregone B-1) 1 9 U V 2 3 In the production range of 7 to 9 Stealth bombers, the opportunity cost of producing 1 more Stealth Bomber in terms of B-1 Bombers is 7 4 NA Multiple Choice 0. 3. 0.5. 2.
b. What is the expected value for the rezoned apartments, if the rezoning cost is included (but land cost is excluded)? Note: Do not round your intermediate calculations. Enter your answers in millions rounded to 2 decimal places. Negative amounts should be indicated by a minus sign. Expected value million c. If the land is rezoned, what should the contractor decide? O Build shopping center O Build apartments d. What is the expected revenue, if the land is not rezoned (excluding the land cost)? Note: Do not round your intermediate calculations. Enter your answers in millions rounded to 2 decimal places. Negative amounts should be indicated by a minus sign. Expected revenue million e. What is the expected net profit of entire project, including all applicable costs? Note: Do not round your intermediate calculations. Enter your answers in millions rounded to 2 decimal places. Negative amounts should be indicated by a minus sign. Expected net profit million
Recently, you were assigned to manage a project for your company. You have constructed a network diagram depicting the various activities in the project (shown below to the right). In addition, you have asked your team to estimate the amount of time that they would expect each of the activities to take. Their responses are shown in the following table: D ew an example Activity A B с D Get more help. E Optimistic 4 5 4 1 Time Estimates (days) Most Likely 8 8 5 4 3 a. What is the expected completion time of the project? The expected completion time is days. (Enter your response as an integer.) 8 Pessimistic 12 12 7 5 MacBook Pro 9 Start + B D ( Finish A Q Q Clear all Check answer +
Based on Exhibit 9-9, or using a financial calculator, what would be the monthly mortgage payments for each of the following situations? Note: Round time value factor and final answers to 2 decimal places. What relationship exists between the length of the loan and the monthly payment? How does the mortgage rate affect the monthly payment? Monthly Mortgage Payment a. $123,000, 15-year loan at 6.00 percent. b. $165,000, 30-year loan at 7.50 percent. c. $68,000, 20-year loan at 7.50 percent. d-1. Longer mortgage terms mean a monthly payment. d-2. For increase in mortgage rate monthly payment is required.
Use the identified following five cost risks , and do the qualitative analysis of risk using the risk matrix shown below? 1. Scope Creep 2. Uncertain Market Conditions 3- Inadequate Risk Assessment 4. Poorly Defined Project Requirements 5. Unforeseen Site Conditions
Suppose SureStep could begin a machinery upgrade and training program to increase its worker productivity. This program would result in the following values of labor hours per pair of shoes over the next four months: 4, 3.9, 3.8, and 3.8. How much would this new program be worth to SureStep, at least for this four-month planning horizon with no backlogging? How might you evaluate the program’s worth beyond the next four months?