Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

USING EXCEL Your company is considering investing in an automation system for its production line, with in order to have savings in salaries. Get the

USING EXCEL Your company is considering investing in an automation system for its production line, with in order to have savings in salaries. Get the Net Cash Flow for this project, calculate its Value Net Present and Internal Rate of Return considering the following data:  Automation system hardware cost: $250,000  Hardware shipping cost: $25,000  Cost of automation system software: $75,000  Necessary adaptations to the facilities: $50,000  New operators needed: 3  Cost of initial training: $10,000 per operator  Salaries of each of the new operators: $1,500 per month  Salaries of each of the current workers: $1,000 per month  Current workers who will no longer be needed: 10  Hiring costs for new operators: $500 per operator  Firing costs for current workers: $1,000 per worker  Electricity consumed by the system: 250 kWh per month  Cost of electricity: $2.5 per kWh  System maintenance cost: $2,500 per year  System life: 10 years  Salvage value: $50,000  MARR = 18% per year

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Innovation In Public Transport Finance

Authors: Shishir Mathur

1st Edition

1138250139, 978-1138250130

More Books

Students also viewed these Finance questions

Question

3. Contrast relational contexts in organizations

Answered: 1 week ago

Question

2. Describe ways in which organizational culture is communicated

Answered: 1 week ago

Question

1. Describe and compare approaches to managing an organization

Answered: 1 week ago