answer these problems

The cost characteristics of a CO testing machine at Dytran Instruments are shown below. The cost of a new fester is $100,000. The equation for determin- ing the AW of keeping the tester for 2 years is: (a] AW = -100,1004/PAS) - [42,010(P/F,1) + 4700(P/F31 4/PS) +40,000(4/F,5) (8) AW = -100,000(4/P12) - [42000(P/F,1) + 47000(P/F12)](4/P13) + 4000(4/F 2) (C) AW = -100,000(4/242) - 47,000 () AW = -100,000(4/243) - 42,000 Machine Age, MBO Costs, Salvage Value Years $ per Year at End of Wear, $ -42,000 -47.0DO -49.000 31,000 -90,000 24,030 -52,000 15 030 -54,000 -63,000 -67,000Use linear programming and a spreadsheet-based solution technique to select from the independent unequal-life projects in Problem 12.17. Solve the capital budgeting problem in Problem 12.20(a), using the linear programming model and a spreadsheet. Johnson and Johnson is expanding its first-aid products line for individuals allergic to latex. The research team comprised of doctors, engineers, and chemists has proposed the four projects esti- mated in Problem 12.18. Develop the linear programming model and use a spreadsheet to se- lect the projects to be funded. The MARK is 12% per year, and the budget limit is $16 million. All monetary values are in $1000 units Using the estimates in Problem 12.18 and repeated spreadsheet solution of the capital budgeting prob- lem for budget limits ranging from b = $5000 to b = $25,000, develop a spreadsheet chart that plots & versus the value of Z Danbrian M\f\f\f