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