Construct a spreadsheet that computes equivalent annual cost

Assignment Help Business Management

Reference no: EM131374878

A new bottle-capping machine costs R45 000, including R5000 for installation. Operating and maintenance costs are expected to be R3000 for the first year, increasing by R1000 each year thereafter. The salvage value is calculated by straight-line depreciation where a value of 0 is assumed at the end of the service life.

(a) Construct a spreadsheet that computes the equivalent annual cost (EAC) for the bottle capper. Wha t is the economic life if the expected service life is 6, 7, 8, 9, or 10 years? Interest is 12%.

(b) How sensitive is the economic life to the different length of sendee life? Construct a sensitivity graph to illustrate this point.

Reference no: EM131374878

Questions Cloud

What has to happen for things to change : Why does health inequality persist in a wealthy nation like the US? What are the causes of the inequality and what has to happen for things to change - Why do you think the US-Mexico border region have been the subject of such close scrutiny, wher..

Find the annual worth of the new water purification system : Find the annual worth of the new water purification system if the current operating hours are 1500 per year on average. ALARR is 10%.

Assignment - create a visual aid that illustrates a problem : Assignment - Create a visual aid that illustrates a problem. Using this visual aid, write a brief report that includes the data, the significance, and the cause of the problem. Include a suggestion for eliminating the problem

Analyze the cultural environment in which you work : Analyze the cultural environment in which you work. Ask yourself and your co-workers the following questions. Do you feel that your supervisors welcome your ideas and respect them even when they may disagree with them?

Construct a spreadsheet that computes equivalent annual cost : Construct a spreadsheet that computes the equivalent annual cost (EAC) for the bottle capper. Wha t is the economic life if the expected service life is 6, 7, 8, 9, or 10 years? Interest is 12%.

Find the annual worth of the truck : TT's after-tax MARR is 12%. Find the annual worth of the truck if the annual revenues are $12 000, and for each $1000 revenue increment up to $22 000.

Do we need to distinguish between shuttle and taxi : Consider simplifying the number of nouns associated with the vehicles. Are "vehicle" and "taxi" synonyms in this context? Do we need to distinguish between "shuttle" and "taxi"? What about between the type of vehicle and "driver"? Justify your ans..

Why might you think this big-picture is significant : Why might you think this "big-picture" is significant? Also, why do you think this type of perspective on the Bible is oftentimes neglected

Compare and contrast the portrayal of history : Compare and contrast the portrayal of history in 4 films that we watched this semester. How do the films revisit the past and for what purpose? What events in history did the films chose to portray? Why?

User Account

All Pages