Economics and financial managment
excel spreadsheet assignment
Cash Flow Statement
The manufacturing manager for Modern Manufacturing Company is working on a justification for implementing a
“Lean/Just-in-time” manufacturing system. No upfront investment will be needed. No revenue changes are forecasted.
A team of employees will spend their time training employees and making process changes. The salaries and benefits
of the “Just-in-time” staff are shown below for the three years of the project.
A team of employees will spend their time training employees and making process changes. The salaries and benefits
of the “Just-in-time” staff are shown below for the three years of the project. There will not be any change in
other S.G.&A. expenses.
Financial gains are expected to be a reduction in the following areas: cost of good sold, inventory, and accounts
payable. The data is shown below where each year changes from the previous year by the percentages shown.
Determine the present worth of the project to see if the savings justify the costs.
Data Block
Time Span
3
Years
Year
0
1
2
3
JIT Team costs
$300,000
$200,000
$100,000
COGS-Reduction per year
7.5%
annually
COGS at end of year 0
$3,000,000
Inventory Reduction per year
10%
annually
Inventory at end of year 0
$200,000
Accounts Receivable reduction
0%
annually
Accounts Receivable at end of year 0
$150,000
Accounts Payable & reduction
10%
annually
Accounts payable at end of year 0
$100,000
Tax Rate
25%
annually
Interest Expense annually
$250,000
constant every year
MARR
15%
ORDER THIS ESSAY HERE NOW AND GET A DISCOUNT !!!
You can place an order similar to this with us. You are assured of an authentic custom paper delivered within the given deadline besides our 24/7 customer support all through.
Latest completed orders:
# | topic title | discipline | academic level | pages | delivered |
---|---|---|---|---|---|
6
|
Writer's choice
|
Business
|
University
|
2
|
1 hour 32 min
|
7
|
Wise Approach to
|
Philosophy
|
College
|
2
|
2 hours 19 min
|
8
|
1980's and 1990
|
History
|
College
|
3
|
2 hours 20 min
|
9
|
pick the best topic
|
Finance
|
School
|
2
|
2 hours 27 min
|
10
|
finance for leisure
|
Finance
|
University
|
12
|
2 hours 36 min
|