四大之一的财务分析全套分析Excel模型

Financial Assumptions
EVM Impact*
Category: Inventory Management
Year of Benefit / Starting Year: Year 2
Asset Efficiency
One-Time/Recurring: One Time
Baseline Data Raw Material WIP
Category 4.2: Decrease average WIP inventory
Current Value $554,220
Current Value
Calculations A1
A2 Realized benefits
B1
Description
Average annual work in process inventory WIP inventory reduction % due to improved throughput from standard work 7 Description Projected decrease in average annual WIP inventory
Financial Impact Template Multi-Lane Strategy Business Case
Benefit FIT Title: Inventory
Benefit FIT Number:
4
Description: Inventory turnover will improve by decreasing the amount of raw material, work in progress, finished goods and slow-moving inventory.
Current Value $10,045,233
Current Value
Comments:
Projected Value
Low
High
5% Low
$27,711
10% High
$55,422
Projected Value
Low
High
10% Low $1,004,523
15% High $1,506,785
If One-Time, split over how many years: 3
Current Value $554,220
$10,045,233
$0
Product: 938
Scope
Region: Division X
Capacity
来自百度文库
% expected capacity consumed by common configurations4
Description Projected decrease in finished goods inventory9
Category 4.4: Reduction in slow moving inventory carrying cost
Calculations A1
A2
A3 A4 Realized benefits B1
20% 10$%0
Calculations
Description
A1
A2 Realized benefits
B1
Average value of raw materials on hand Raw material inventory reduction % as a result of more stable production schedule6 Description Projected decrease in average raw materials on hand
70%
Attachments Slow moving inventory
Average % of total machine value allocated to attachments5 % of total inventory that is slow moving5
Benefit Categories Category 4.1: Decrease average on hand raw materials
Description Total value of attachments within raw materials and WIP inventory
Current value of attachments that are slow moving Projected value of common configuration attachments that are slow moving % decrease in slow moving inventory10 Description Decrease in projected common configuration attachments
Current Value $0
Current Value
Current Value $2,119,890 $211,989 $148,392
Current Value
Projected Value
Low
High
10% Low
$0
High
15% $0
Projected Value
Low
% Change High
Low
High
Low
% Change High
Low
High
Category 4.3: Decrease average Finished Goods inventory
Calculations A1 A2
Realized benefits B1
Description Average annual value of finished goods inventory Factory inventory reduction %8
Finished Goods
Description Average value of raw materials on hand1 Average annual work in process inventory2
Average annual value of finished goods inventory3