please solve it using excel

show me how did you find the values in the cells in your excel,so that i can follow your steps on my excel

because then i have to solve it on excel

A firm operates at full capacity to manufacture 10,000 items a year of a product to meet market demand. It is anticipated the demand will increase in the following few years. The firm is considering two alternatives to meet the anticipated increase in demand. The planning horizon is 4 years, and the MARR is 10% p.a. Alternative 1: Use the existing machine and cater for the increase in demand by using overtime. The costing data for this option are shown below. Present value of the existing machine: $10,000 Fixed annual operating cost (regardless of the quantity manufacture): $10,000 Added value per item up 10,000 items $5 Added value per item for all items above 10,000 (due to overtime costs) $4 Salvage value of the machine after 4 years $0 Note: Added value per item is the contribution per item, i.e. Gross profit which is the difference between selling price and direct cost. Alternative 2: Sell the existing machine and replace it with a new automatic machine with higher capacity. Due to productivity improvements, the added value per item will be $8. The costing data for this option are shown below. Initial cost of the new machine: Fixed annual operating cost (regardless of the quantity manufacture): Added value per item Salvage value of the machine after 4 years $50,000 $30,000 $8 $0 The firm feels confident about the costing data except the fixed annual operating cost for the new machine. It feels that the estimated fixed annual operating cost for the new machine may be subject to error. In addition, the estimated increase in demand is also subject to error. Advise the firm the option that it should adopt under different scenarios, i.e. changes in fixed operating cost of the new machine and changes in annual demand for the product