Could somebody help me solve this using Excel solver? Show your work please!

At the beginning of year one, a manufacturing company purchases a new machine. The cost of buying this machine at the beginning of year 1,2,3, and 4 (at the start of each subsequent year) is given in Table 1. Since the company wants to use up-to-date machines, the company can replace the used machine with a new machine at any time after one year of use. For example, if the company switched to a new machine at the beginning of year two and used it for two years, the total cost would be $ 365 (new machine price + 2 years use = $350 + $ 15). The cost of maintaining this type of machine, depending on its period of use, is also given in Table 2. If the machine used three years, the total of three years of maintenance cost would be $20. Assume that there is no trade-in value when a machine is replaced. The goal of this company is to minimize the total cost (which includes the purchase and maintenance costs) of owning and using this type of machine for the next four years (e.g., the end time is the beginning of year 5). In particular, the company wants to determine the years in which a new machine should be purchased. Table 1: New machine price at the beginning of the year. Year 2 Purchase Price $300 $350 3 $400 4 $450 Table 2: Total machine maintenance cost depending on the period of use Year 1 year use 2 years use 3 years use Maintenance Cost $10 $15 $20 4 years use $30 a) Define the decision variables. b) Define the objective function. c) Define the constraints 1 3 4 2 $350 $300 $400 $450 1 year use 2 years use $10 $15 3 years use $20 4 years use $30 To From Buy 1 Cost DEC Replace 2 Maint 10 15 20 1 3 1 Price 300 300 300 350 350 400 4 Decision x12 x13 x14 X23 X24 x34 310 315 320 360 365 410 2. 3 10 4 N 15 10 3 4 Objective Min 310 x12 + 315 x13 + 320 x14 + 360 x23 + 365 x24 +410 X34 660 1 715 3 860 Objective Constraint Node IN 1 1 2 (x12) 3 (x13+x23) 4 (x14+x24+x34) = OUT (X12+x13+x14) (x23+x24) (x34) --> Excel: X13+x23-x34 = 0 1 x(ij) : binary