please, help me to figure these two questions in excel .

if it can show me the specific step on excel, that will be awesome.

A buyer for a frozen yogurt franchise with 145 stores is responsible for all the asset purchases at her company. She has decided to upgrade the equipment of her outlets by installing new cash registers. She believes that if she purchases these latest cash regis- ters, they will last for the next eight years. She is considering a quote from a supplier who agreed to supply the cash registers for $1,050 per register. The buyer wants to order one register for each store (145 registers). Along with the registers, she also decided to buy two add-ons for each registera credit card machine and an automatic coin dis- penser. The two accessories would cost her an additional $120 and $185 per register.

As with any purchase of new equipment, support would be required to maintain the equipment. The buyer decided to purchase an eight-year warranty, which would cost $200 per register. She also estimated that she will need to spend money to link the registers to the computer system, which would cost $110 per quarter per register and A buyer for a frozen yogurt franchise with 145 stores is responsible for all the asset purchases at her company. She has decided to upgrade the equipment of her outlets by installing new cash registers. She believes that if she purchases these latest cash regis- ters, they will last for the next eight years. She is considering a quote from a supplier who agreed to supply the cash registers for $1,050 per register. The buyer wants to order one register for each store (145 registers). Along with the registers, she also decided to buy two add-ons for each registera credit card machine and an automatic coin dis- penser. The two accessories would cost her an additional $120 and $185 per register. As with any purchase of new equipment, support would be required to maintain the equipment. The buyer decided to purchase an eight-year warranty, which would cost $200 per register. She also estimated that she will need to spend money to link the registers to the computer system, which would cost $110 per quarter per register and an additional $160 every six months per register for maintenance. The buyer will need to pay a one-time upfront training charge of $100 per register to train the outlet managers. She also considered the cost of downtime every year (when the registers are not work- ing and another form of cashing people out must be used). She estimated the downtime to be 12 hours per register per year, and the cost to be $55 per hour. She was confident that the high-end registers would have a salvage value of $120 per register at the end of their life. As she was calculating the cost, she suddenly realized that there were other costs related to the purchase. The cost to install the registers was $380 per register. She cal- culated that finalizing the sourcing contract for the registers, security service, and other costs would take the work of 2 full-time equivalent people working in the purchasing department exactly 30 days of each persons time. She thought that she would need the help of a sourcing manager who makes a total salary of $160,000 per year and an assis- tant who earns $105,000 per year. They would place an initial purchase order, which would cost the company $275 and each year they would submit 6 invoices at an estimate of $53 each for the register service costs. a) Using the data provided above, calculate the total cost of ownership for the buyers decision (do not consider the time value of money). b) Where should the buyer focus her efforts to reduce the TCO?

2) You are a buyer for Clinique Corporation, which is considering adding a new lens to their product line of digital cameras. A Dutch supplier produces these lenses and you are considering buying them from that company. The supplier wants to bid on your order. You told him that your demand would be 23,000 units, 36,000 units, 58,000 units and 76,000 units in years 1, 2, 3, and 4, respectively, and he has offered you a competitive price of $80 per unit. As you think through the offer, you also anticipate that the ship- ping charges would be $3.25 per unit and import/custom charges would be $7.50 per unit. In addition to these costs, there would also be administrative costs, which would amount to $4,200 per month to purchase the lenses. As an alternative, you can produce the lenses at your own factory, but there are some costs associated with this option as well. Raw materials would cost $23 per unit. Direct labor would cost $21.50 per unit, with an additional 25% surcharge for benefits. Indirect labor is estimated at $17 per unit, plus 25% for benefits. You will also need to purchase a new machine immediately, which will cost $3,000,000 and spend an upfront cost of $800,000 for engineering and design. You plan to add overhead costs at a rate of 60% of the cost of direct labor (not including benefits). a) What are the costs associated with each of the two options (do not consider the time value of money)? b) What would be a good option for you? c) What other issues might you consider when making your decision?