UPDATED Could you please solve this QUESTION 6-68. Also, can you solve it again using excel? (So need to solve it twice. One time normally, then solve it again using excel). Also, the values on excel should be generic values (not fixed).

EXAMPLE 6-3 Analyzing Alternatives with Different Reject Rates Consider the four plastic molding presses of Example 6-2. Suppose that each press is still capable of producing 120,000 total units per year, but the estimated reject rate is different for each alternative. This means that theexpected revenue will differ among the alternatives sinceonly nondefective units can be sold. The data for the four presses are summarized below. The life of each press (and the study period) is five years. P3 Capital investment $24,000 $30,400 $49,600 $52,000 Total annual expenses $1.200 $29,128 S25,152 $22,880 Reject rate 8.4% 0.3% 2.6%. 5.6% If all nondefective units can be sold for $0.375 per unit, which press should be chosen? Solve by hand and by spreadsheet. Solution by Hand In this example, each of the four alternative presses produces 120,000 units per year, but they have different estimated reject rates. Therefore, the number of nondefective output units produced and sold per year, as well as the annual revenues received by thecompany, varies among the alternatives. But theannual expenses are assumed to be unaffected by the reject rates. In this situation, the preferred alternative will maximize overall profitability (Rule 1, Section 6.2.2) That is, the four presses need to be compared as investment alternatives. The PW, AW, and FW calculations for Alternative P4 are given below: $22,300, $5,882, $52,000(F/P,10%,5) -0.0560020,000 (50.375) -$22,800 F/A, 10%, 50 $35,914 The PW, AW, and FW values for Alternatives PT, P2, and P3 are determined with similar calculations and shown for all four alternatives in Table 6-2. Alternative P2 maximizes all three equivalent-worth measures of overall profitability and is preferred [versus PA in Example 6-21. The preference ranking (P2 P4 P3 P1) is the same for the three methods but is different from the ranking in Example 6-2. The different preferred alternative and preference ranking are the result of the varying capability among the presses to produce nondefective output units