An international textile company’s North America Division must decide which type of fabric cutting machines it will use—straight knife or round knife. The estimates are summarized below. Compare them on the basis of annual worth values at i = 10% per year using (a) factors, and (b) single-cell spreadsheet functions.
What will be an ideal response?
(a) Factors
AW Round = -250,000(A/P,10%,6) – 31,000 + 40,000(A/F,10%,6)
= -250,000(0.22961) – 31,000 + 40,000(0.12961)
= $-83,218
AW Straight = -170,000(A/P,10%,4) – 35,000 – 26,000(P/F,10%,2)(A/P,10%,4)
+ 10,000(A/F,10%,4)
= -170,000(0.31547) – 35,000 – 26,000(0.8264)(0.31547)
+ 10,000(0.21547)
= $-93,254
Select Round Knife
(b) Round knife: = - PMT(10%,6,-250000,40000) – 31000 displays $-83,218
Straight knife: = - PMT(10%,4,-170000,10000) - 35000 - PMT(10%,4,-PV(10%,2,,
-26000)) displays $-93,254
Select Round knife
You might also like to view...
____________________ held that people who accept a job assume the risks that go with it.
Fill in the blank(s) with the appropriate word(s).
What are four sources from which you can obtain pets? What are the advantages and disadvantages of
each source?
What will be an ideal response?To create ______ balance, several smaller items on one side of the imaginary line dividing an image are balanced by a large item on the other side
Fill in the blank(s) with correct word
The period of a waveform is?
A) The measure of the height of a waveform B) The time a periodic wave takes to complete one cycle C) The reciprocal of time D) Another name for cps