Cost of Goods Calculation in Cost Sheets

Top  Previous  Next

The following are rules should be noted when working with cost sheets in contracts and deliveries.

 

For Lump Sums:

When a Lump Sum cost item is added in a contract cost sheet and one or more partial deliveries are done, Agiblocks adds separate portions of that lump sum for each delivery line to the cost sheet, not one overall lump sum.
Adding more delivery lines later to that delivery for that same contract, results in additional portions from that lump sum.

 

For Percentages:

When a Percentage cost item is added in a contract cost sheet and one or more partial deliveries is done, Agiblocks adds separate percentage cost items for each delivery line, each of them calculated over their own amount, not over the total amount of all these delivery lines combined.
Adding more delivery lines later to that delivery for that same contract, results in additional percentage lines per delivery line.

 

Cost Item Grouping

The Master data set-up for cost items enables you to view the gross margin on the sale delivery cost sheet. The default term “Goods” is configured, but this can be adjusted to any name. Goods are allocated to the Gross Margin section. The total amount of the cost sheet from the incoming side of the delivery becomes the Goods lump sum.

 

Cost of Goods in the Multi-Currency Situation

The COG for all types of deliveries is posted to the financial system as a lump sum.

When the cost sheet for the outgoing side of any delivery is created, the costs of the cost sheet on the incoming side of the delivery are displayed in original currency and in company currency. This total is added as Goods to the newly created cost sheet of the outgoing side of the delivery.
Any conversion to company currency will be done using the currency rates as known for the realization date. This realization date is typically the transaction date for the delivery of the purchased goods, except when the goods get priced on a later date, in which case it will be that later pricing date. For a sale this means that each of these Goods cost items will results in separate accruals.
Whenever the costs sheet on the incoming side is updated, the Goods item in the cost sheet on the outgoing side is also updated by recalculating the total on the incoming side with the new data.
As a result the costs sheets on the outgoing side has two values for the goods cost item: a budget and an actual value.
The budget (cost items entered in cost sheets) is updated by the actual costs (invoices allocated to these cost items). The actual total will initially be equal to the budget. Each cost item that contributes to the total is replaced step by step with an actual value, resulting in a gradual adjustment of the actual total: each adjustment of the actual total amount for goods must results in a corrective accrual.
Note that there are special rules for displaying the Goods item that was added to the costs sheet of the outgoing side (sales/storage):
On the individual cost sheet and on cost analysis screen for that outgoing delivery (sales/storage) individual cost items from the incoming side are not shown.
On the overall logistic cost sheet the reverse applies: the Goods added to the cost sheet of the outgoing delivery is NOT shown. Instead, the transport costs sheet shows all the individual cost items of all deliveries in that transport. (The costs sheets of incoming side could contain Goods items of their own, which would be shown in the overall cost sheet as part their of their individual items).
·        

Accruals

When the Purchase is executed, accruals are created for the purchase amounts. When the Sale is executed, accruals are created for the sale amounts. When the Purchase invoice is created, it reverses the previously created accrual and creates a new accrual for the new amount. This causes a change in the total of the Purchase cost sheet, which prompts an update in the Sales cost sheet. The Sales accrual is then updated accordingly.