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
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
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