Production costs – FINANCIAL MODELS

To fill in the tables SIGN UP or LOG IN with your credentials. Your input data will not be visible to other users.

Fill in the table using:

+New Entry
Edit after clicking on the row you want to modify
Delete

For % fields, enter the percentage figure without the % symbol. Some fields allow for one or two decimal places. For example, for the VAT field, if the rate is 22% enter 22.00

Materials and consumables

wdt_ID	userid	Description	VAT % on purchase if applicable	Unit cost YEAR1	Quantity purchased YEAR1	Stock end of YEAR1	Check on stock quantities YEAR1	Unit cost YEAR2	Quantity purchased YEAR2	Stock end of YEAR2	Check on stock quantities YEAR2	Unit cost YEAR3	Quantity purchased YEAR3	Stock end of YEAR3	Check on stock quantities YEAR3	Unit cost YEAR4	Quantity purchased YEAR4	Stock end of YEAR4	Check on stock quantities YEAR4	Unit cost YEAR5	Quantity purchased YEAR5	Stock end of YEAR5	Check on stock quantities YEAR5

Production personnel

Enter the number of FTE (Full-Time Equivalents) employed each year. Should any of them work for only part of the year, use decimals. For example, for an employee working 6 months enter 0.5; for an employee working the whole year enter 1

wdt_ID	userid	Employee description	Yearly gross salary	Bonus % of gross salary	Social charges employer, %	Pension annual accrual, % of gross salary	FTE number YEAR1	FTE number YEAR2	FTE number YEAR3	FTE number YEAR4	FTE number YEAR5

Contract labor, external productions, O&M

wdt_ID	userid	Cost description	YEAR1	YEAR2	YEAR3	YEAR4	YEAR5

Tangible assets used for production

Enter the purchase cost in the year the asset is acquired. The model assumes that the asset is placed into use in that same year, with a full year depreciation.