a) Use integer linear programming to solve the capital rationing problem with the project listedbelow, a budget of $16,000, and a 12% MARR.Project Cash FlowsEOYAВD-$5,000.00 -$6,000.00$1,000.00-$9,000.00 -$8,000.00$5,000.001$500.00$0.00$1,700.00$2,400.002$500.00$5,000.00$0.003$500.00$2,000.00$0.00$3,000.00$38,000.00 $10,500.00$500.00$0.00$0.00 $18,000.004$0.00b) Verify your answer from part (a) by enumerating and evaluating all project bundles.

Answered: Image /qna-images/answer/dc348615-d949-4353-af3b-e30e8d32d8b0.jpg

Answered: a) Use integer linear programming to…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 21P

See similar textbooks

Similar questions

4. Using a discounted rate of 12 percent, INITIAL COST NET CASH FLOW YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 PROJECT A (BROILER) K100,000 (20,000) 10,000 40.000 40.000 150.000 PROJECT B (LAYERS) K100,000 33,000 33,000 33,000 33,000 33,000 a. Determine the net present value of project A and B b. Calculate the IRR on mutually exclusive investment of project A and B. C. Which project must the farm undertake and why?
1.You’re managing a project to install 400 windows in a new skyscraper and need to figure outyour budget. Each week of the project costs the same: your team members are paid a total of $4,000every week, and you need $2,000 worth of parts each week to do the work. If the project isscheduled to last 16 weeks, calculate theBAC, PV, EV, AC, SPI, SV, CPI, SPI, CV for the project? 2.You’re managing a highway construction project. Your total budget is $650,000, and there isa total of 7,500 hours of work scheduled on the project. You check with your accountingdepartment, and they tell you that you’ve spent a total of $400,000. According to the schedule,your crew should have worked 4,500 hours, but your foreman says that the crew was allowed towork some overtime, and they’ve put in 5,100 hours of work. Calculate theBAC, PV, EV, AC, SPI, SV, CPI, SPI, CV for the project?
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
Kiley Electronics is considering a project that has the following cash flow data. What is the project's IRR, and should the firm accept the project based on IRR if its WACC is 13.00%? Year 0 1 2 3 Cash flows -$1,100 $450 $470 $490 13.31%; Accept 13.31%; Reject -14.64%; Reject 11.98%; Accept 11.98%; Reject
You are working on a manufacturing project having a budget of PKR 3,600,000 and expected time of its completion is one year. There is an ideal condition that your budget and work are evenly spread across the duration of the project that is twelve month. At the end of forth month, the senior management has called a meeting and invited all the stakeholders to brief about the status of the project. You being the PM of this project is giving the presentation to all the attendees and informed that project is on schedule and PKR 1,800,000 have already been spent on the project. Required: Calculate Cost and Schedule Variance What is SPI and CPI of the project? Estimate at completion and Estimated time to complete?
[Project Management] Because a housing project is running late, the developer will need to complete and deliver the houses as quickly as possible. You and your management team are responsible for mitigating the situation by including a time-cost trade-off analysis into the project. You will need to include the following: Normal crash Activity Prior Days cost, RM Days cost, RM A 7,000 7,000 B A 8,000 9 8,000 B 14 6,000 12 11,000 D B 18 5,000 11 8,500 E C,D 12 8,000 12 8,000 E 20 6,000 16 12,000 E 7,000 7,000 E 11 11,000 7 15,000 G, H 10 15,000 21,000 7 I, F 6 9,000 6 9,000 Construct a network diagram (PDM), including activity early start, late start, early finish, late finish and float.
Consider a project with an initial investment of $60,000, a 6 year useful life (and study period), and a $10,000 salvage value. You expect an annual net revenue of $15,000 (before tax), a MARR before tax of 15.3%, and an effective tax rate of 35%. The capital equipment is to be depreciated using MACRS GDS and a 3 year class life. A)For the cash flow , compute after-tax MARR and evaluate the cash flow using an equivalent worth method. B) Develop the after-tax cash flows for the project of using a 4 year class life and MACRS ADS. Draw the after-tax cash flow diagram.
Stinnett Transmissions, Incorporated, has the following estimates for its new gear assembly project: Price $1,220 per unit; variable costs = $3.75 million; quantity = 90,000 units. Suppose the company believes all of its estimates are accurate only to within ±15 percent. What values should the company use for the four variables given here when it performs its best-case scenario analysis? What about the worst-case scenario? Pls don't copy answer i give up vote
The decision was made by JMP management that a certain critical development in the overall project will be subcontracted-out to a vendor. JMP has issued a six-month cost plus fixed fee contract for that development, and you are the vendor's project manager. The approved JMP budget for your development is $500,000. A recent Earned Value Analysis that your firm (the vendor) has done shows that you will complete the project four weeks ahead of time, thus depriving your firm of $80,000 of billable time. Among your options are: 1. Since it was the approved budget, go ahead and bill JMP for the entire $500.000. 2. Inform JMP of the project status and completion date, and ask if they'd like to add any features to account for the monies spent. 3. Inform JMP of the project status and completion date. 4. Bill JMP for the $500,000 by adding more work at the end of the project.
You are the project manager of the software installationproject in Table 7.12. You would like to find the minimum-costschedule for your project. There is a $1,000-per-week penaltyfor each week the project is delayed beyond week 25. In addi-tion, your project team determined that indirect project costsare $2,500 per week.a. What would be your target completion week?b. How much would you save in total project costs with yourschedule?
Th e dean of the business school wants to start off eringthis program starting 32 weeks from now. Using the informationprovided in Problem 15,(a) Calculate the probability of the program starting ontime.(b) If the dean needs a 95 percent probability of being doneon time, how long can the expected project duration be?
Preliminary plans are underway for construction of a new stadium for a major league baseball team. City officials question the number and profitability of the luxury corporate boxes planned for the upper deck of the stadium. Corporations and selected individuals may purchase a box for $300,000. The fixed construction cost for the upper-deck area is estimated to be $4,500,000, with a variable cost of $150,000 for each box constructed. a. What is the breakeven point for the number of luxury boxes in the new stadium? b. Preliminary drawings for the stadium show that space is available for the construction of up to 50 luxury boxes. Promoters indicate that buyers are available and that all 50 could be sold if constructed. What is your recommendation concerning the construction of luxury boxes? What profit is anticipated?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS