Hand Written Solutions please

HOW MUCH TO SPEND 1. A machine is needed to produce parts at the rate of 60 per hour. The operator to run the machine will be paid $11.47 per hour. The parts cost $.47 each and will be sold for $.93 each after this operation. This operation is expected to be needed for 7 years. SOYD deprwill be used and 10% salvage is assumed. Assume that revenues, labor, and material costs ow uniformly and continuously throughout the year, and that the machine will run for 8 hours per day, 250 days per year. a. If the tax rate is 47% and MARR is 20%, how much can be spent on this machine? Solve this using the AEC equation and then construct a spreadsheet and use solver to solve this problem. b. Assume SL depreciation is used. Repeat part a. 0. Assume 5 XLMACRS is used. Repeat part a. d. Assume the rst cost is expensed and the salvage is income in year 7. Repeat part a. c. Find how much can be spent with SL deprby varying the debt ratio from 0 to 1.0. TABLE FORMAT YEAR 1 YEAR 2 YEAR 3 REVENUES OPERATING EXPENSES BEFORE TAX CASH FLOW(BTCF) INTEREST DEPRECIATION TAXABLE INCOlVIE TAX AFTER TAX CASH FLOW(ATCF) INTEREST DIVIDENDS CASH REMAINING DEBT REMAINING EQUITY REMAINING TOTAL REMAINING