Future Value
1
2
3
4
5
6
7
8
9
10
1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05
$ 100.00
100
1.05
$
10
162.89 using the algabraic formula
($162.89) using the Excel function
FV = PV (1+i)
FV
PV
i
Future Value
Present Value
interest rate
number of payme
Write-Up Questions for the Tanpin Kanri Case
Length Requirement:
While quality answers are the ultimate basis for my grading on this assignment, the following
important length requirement may help ensure that enough effort, thoughts, and details are
demon
D eztomheducation.<um,-’i1iri.tpx
vs i J:-
2 ' 000 points
2 Change all ofthe numbers in the data area ofyour worksheet so that it looks like this
A E C D
I Chapter 3: Applying Excel
2
3 Data
A Allocation base Machineehours
5 Estimated manufacturing overhe
D eztornheducatlon.<om,-’hm.tpx
2 _ gems
0.00 paints
Requirement 2:
Change all ufthe numbers in the data area ufyuurwarksheet so that lt looks llkethls
4 A
3 Data
4 Begrnnmg work tn pruness mventnry
5 Unrts in pracess 200
E Complehon Wllh rESpECtIu rnai
a
D eztomheducation.<um,-’hiii.tpx
2 Mine
a no paint:
2 Change all ufthe numbers in the data area ufyuurwurhsheetsu that it leeks like this
A B C D
1 Chapter 5:Applyina Excel
2
3 Dale
4 Unll sales 20,000 units
5 Seiiiriq price Der unit 530 Der unit
521 pe
D eztomheducatron.cum/I1m.tpx Q
Assume that Oﬁ'rceMart places nrders more trequently but everything else remains the same On ynur A
worksheet increase the number uturders tram 4tu15.[PrIortu completan ttns requirementE change
all worksheet lrgures back