Total Cost of Ownership (TCO) Using MS Excel Timely Assignment Help
Total Cost of Ownership (TCO) Using MS Excel Timely Assignment Help
Applied Sciences online homework marketplace
Total Cost of Ownership (TCO) Using MS ExcelThe production manager has asked you to purchase a replacement numerically controlled (NC) plasma-cutting machine for the metal fabrication shop. She has provided you with the manufacturer’s number and model number for two models and indicates that the performance of either machine is perfectly acceptable. The existing tooling and fixtures will also work with either machine. Footprint and utility requirements are nearly the same as the old machine and will not require changes to the facility. The equipment will be depreciated over a ten-year period, which is also the expected service life. An annual service contract is required after the expiration of the warranty and throughout the remaining service life. You will take advantage of a 2% discount offered by each supplier for paying cash. You decide to complete a total cost of ownership (TCO) analysis to help make the purchasing decision.The two manufacturers have provided the following additional information:Cuts All Model 10Super-Hot Model Z2Base price$79,000$68,000Freight/Delivery$3,000$2,200Warranty5 years3 yearsAnnual service contract$759$632Consumables cost per year$522$630Annual electric cost$444$520Annual water cost$230$180Operator training$300IncludedResidual value after 10 years$39,000$21,000Submit a MS Excel spreadsheet that calculates the total cost of ownership of each machine. Based on the TCO calculation, specify which model you recommend purchasing.
Have trouble solving the various types of essays? Don’t worry. Our team of brilliant essay writers will help you with your requirements. We understand that working on more than one type of essay can be a bit hectic as well as confusing when each type of essay has its own set of guidelines. However, that is not a problem for our extraordinary essay writing helpers. They can provide the necessary essay writing help, irrespective of the intricacy of the topic or the essay type. If you are wondering what types of essays are covered by our essay writers, here’s your answer.