|
Navigation |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Manufacturing Model |
|
|
Global |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
|
|
Project Name |
Project_Name |
|
|
Financial
Robot |
|
|
|
Model Revision |
Model_Date |
|
|
23 Jul 14 |
|
|
|
|
Model Name |
Model_Name |
|
|
Manufacturing
Model |
|
|
|
|
Period Start Date |
Date_BoP |
|
|
01 Jul 14 |
01 Oct 14 |
01 Jan 15 |
01 Apr 15 |
01 Jul 15 |
01 Oct 15 |
01 Jan 16 |
01 Apr 16 |
01 Jul 16 |
01 Oct 16 |
01 Jan 17 |
01 Apr 17 |
01 Jul 17 |
01 Oct 17 |
01 Jan 18 |
01 Apr 18 |
01 Jul 18 |
01 Oct 18 |
01 Jan 19 |
01 Apr 19 |
01 Jul 19 |
01 Oct 19 |
01 Jan 20 |
01 Apr 20 |
01 Jul 20 |
01 Oct 20 |
01 Jan 21 |
01 Apr 21 |
01 Jul 21 |
01 Oct 21 |
01 Jan 22 |
01 Apr 22 |
01 Jul 22 |
01 Oct 22 |
01 Jan 23 |
01 Apr 23 |
01 Jul 23 |
|
Period End Date |
Date_EoP |
|
30 Jun 14 |
30 Sep 14 |
31 Dec 14 |
31 Mar 15 |
30 Jun 15 |
30 Sep 15 |
31 Dec 15 |
31 Mar 16 |
30 Jun 16 |
30 Sep 16 |
31 Dec 16 |
31 Mar 17 |
30 Jun 17 |
30 Sep 17 |
31 Dec 17 |
31 Mar 18 |
30 Jun 18 |
30 Sep 18 |
31 Dec 18 |
31 Mar 19 |
30 Jun 19 |
30 Sep 19 |
31 Dec 19 |
31 Mar 20 |
30 Jun 20 |
30 Sep 20 |
31 Dec 20 |
31 Mar 21 |
30 Jun 21 |
30 Sep 21 |
31 Dec 21 |
31 Mar 22 |
30 Jun 22 |
30 Sep 22 |
31 Dec 22 |
31 Mar 23 |
30 Jun 23 |
30 Sep 23 |
|
|
|
|
|
Month Counter |
Month_Count |
|
3.0 |
6.0 |
9.0 |
12.0 |
15.0 |
18.0 |
21.0 |
24.0 |
27.0 |
30.0 |
33.0 |
36.0 |
39.0 |
42.0 |
45.0 |
48.0 |
51.0 |
54.0 |
57.0 |
60.0 |
63.0 |
66.0 |
69.0 |
72.0 |
75.0 |
78.0 |
81.0 |
84.0 |
87.0 |
90.0 |
93.0 |
96.0 |
99.0 |
102.0 |
105.0 |
108.0 |
111.0 |
|
Quarter Counter |
Quarter_Count |
|
1.0 |
2.0 |
3.0 |
4.0 |
5.0 |
6.0 |
7.0 |
8.0 |
9.0 |
10.0 |
11.0 |
12.0 |
13.0 |
14.0 |
15.0 |
16.0 |
17.0 |
18.0 |
19.0 |
20.0 |
21.0 |
22.0 |
23.0 |
24.0 |
25.0 |
26.0 |
27.0 |
28.0 |
29.0 |
30.0 |
31.0 |
32.0 |
33.0 |
34.0 |
35.0 |
36.0 |
37.0 |
|
Year Counter |
Year_Count |
|
1.0 |
1.0 |
1.0 |
1.0 |
2.0 |
2.0 |
2.0 |
2.0 |
3.0 |
3.0 |
3.0 |
3.0 |
4.0 |
4.0 |
4.0 |
4.0 |
5.0 |
5.0 |
5.0 |
5.0 |
6.0 |
6.0 |
6.0 |
6.0 |
7.0 |
7.0 |
7.0 |
7.0 |
8.0 |
8.0 |
8.0 |
8.0 |
9.0 |
9.0 |
9.0 |
9.0 |
10.0 |
|
Number of Periods Flag |
Nperiod |
|
4.0 |
|
|
Time step duration, Days |
step_d |
|
91.3 |
|
|
Time step name |
step_name |
|
Quarters |
|
|
Income Tax |
CT |
|
20.0% |
|
|
|
|
Currency |
FX |
|
GBP |
|
|
Currency Unit |
X |
|
000s |
|
|
Volume Scale |
Y |
|
|
1 000 |
|
|
|
Input Labels for P&L
and BS items =>> |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
COGS Items |
|
COGS Unit Labels |
|
Central Costs Items |
|
|
|
|
|
|
Name or Name Range |
Assign Value |
|
Name or Name Range |
Assign Value |
|
Name or Name Range |
Assign Value |
|
|
|
|
|
COGS1 |
|
Item 1 |
|
COGSu1 |
|
kg |
|
CCosts1 |
|
Sales & Marketing |
|
|
|
|
|
COGS2 |
|
Item 2 |
|
COGSu2 |
|
m3 |
|
CCosts2 |
|
Administration |
|
|
|
|
|
COGS3 |
|
Item 3 |
|
COGSu3 |
|
kWt |
|
CCosts3 |
|
Rent & Leases |
|
|
|
|
|
COGS4 |
|
Item 4 |
|
COGSu4 |
|
FTE |
|
CCosts4 |
|
Consulting |
|
|
|
|
|
COGS5 |
|
Item 5 |
|
COGSu5 |
|
kg |
|
CCosts5 |
|
Other CC |
|
|
|
|
|
COGS6 |
|
Item 6 |
|
COGSu6 |
|
m3 |
|
|
|
|
|
|
COGS7 |
|
Item 7 |
|
COGSu7 |
|
kWt |
|
|
|
|
|
|
COGS8 |
|
Item 8 |
|
COGSu8 |
|
FTE |
|
|
|
|
|
|
COGS9 |
|
Item 9 |
|
COGSu9 |
|
kg |
|
|
|
|
|
|
COGS10 |
|
Item 10 |
|
COGSu10 |
|
m3 |
|
|
|
|
|
|
|
|
|
|
|
Working Capital Items |
|
Debt & Long Term Balance Sheet Items |
|
|
Capex & Dep'n |
|
|
|
|
|
|
Name or Name Range |
Assign Value |
|
Name or Name Range |
Assign Value |
|
Name or Name Range |
Assign Value |
|
|
|
|
|
Wcapital1 |
|
Debtors |
|
OtherLTA |
|
Other Long Term Assets |
|
FAssets1 |
|
Buildings |
|
|
|
|
|
Wcapital2 |
|
Inventory |
|
OtherLTL |
|
Other Long Term
Liabilities |
|
FAssets2 |
|
Machines |
|
|
|
|
|
Wcapital3 |
|
Raw Materials |
|
Revolver |
|
Short Term Revolver |
|
FAssets3 |
|
Equipment |
|
|
|
|
|
Wcapital4 |
|
Creditors |
|
LTDebt1 |
|
Long Term Loan |
|
FAssets4 |
|
Land |
|
|
|
|
|
Wcapital5 |
|
Other CA |
|
FAssets5 |
|
Other FA |
|
|
|
|
|
Wcapital6 |
|
Other CL |
|
|
|
|
|
|
|
|
|
|
|
|
|
>> End of Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|