(04) Quantity-Based Method 

Use

The quantity-based method can be used for sales orders.

With quantity-based results analysis, you can calculate the costs affecting net income on the basis of the invoiced quantity.

The invoiced quantity can be the standard for the percentage of completion (POC) of the order if:

Prerequisites

You have planned costs and quantities.

Choose a results analysis method in simplified Customizing for Product Cost by Sales Order under Period-End Closing ® Results Analysis ® Valuation Method.

Features

POC = Q(a) / Q(p)

C(PA) = POC * C(p) = Q(a) / Q(p) * C(p)

R(PA) = R(a)

The revenue affecting net income equals the actual revenue. The costs affecting net income are equal to the planned costs multiplied by the invoiced quantities divided by the planned quantity. The costs affecting net income can be passed to CO-PA together with the revenue affecting net income.

If the actual costs are greater than the costs affecting net income, the system creates capitalized costs.

If the actual costs are less than the costs affecting net income, the system creates reserves for unrealized costs.

Inventory values and reserves for unrealized costs can be transferred to FI and EC-PCA when you settle.

The planned values determine how the cost of sales is calculated:

This method differs from the revenue-based method (method 01) in that the quantity specified in the invoice is used as a basis for valuation, rather than the revenue calculated by means of pricing.

In the standard system, the planned quantity equals the quantity in the sales order item.

If you have calculated the planned costs in a sales order cost estimate, the order quantity is the lot size of the cost estimate. If you have calculated the planned costs in the standard cost estimate for the material, the costs are converted to the order quantity. This also converts the costs that are independent of the lot size.

The quantity-based method can also be applied to other objects if you make the appropriate setting in the Expert Mode of the valuation method in the Quantity base field.

Example

You have planned revenues of USD 200,000 and costs of USD 120,000 for your sales order. The order quantity is 100 units.

Period 01

In period 01 you have actual costs of USD 20,000. You have not billed the customer. In results analysis, the system calculates the following data:

You then settle the capitalized costs to FI and EC-PCA.

The following values are reported in CO-PA:

Profitability Analysis

Actual revenue

0

Calculated cost of sales

0

Profit

0

The income statement shows the following values:

Income Statement

Expense

Revenue

Actual costs 20,000

Capitalized costs 20,000

20,000

20,000

Period 02

In period 02 the actual costs increase to USD 80,000. You deliver to your customer and send him a milestone invoice for USD 100,000. The invoiced quantity is 40 units. The order is partially delivered and partially billed. In results analysis, the system calculates the following data:

You then settle the following:

The following values are reported in CO-PA:

Profitability Analysis

Actual revenue

100,000

Calculated cost of sales

48,000

Profit

52,000

The income statement shows the following values:

Income Statement

Expense

Revenue

Actual costs 80,000

Actual revenue 100,000

Profit 52,000

Capitalized costs 32,000

132,000

132,000

Period 03

In period 03 the actual costs increase to USD 90,000. You deliver a second amount to your customer and send him a second milestone billing for USD 90,000. The total revenue is USD 190,000. The invoiced quantity is 40 units. The order is partially delivered and partially billed. In results analysis, the system calculates the following data:

You then settle the following:

The following values are reported in CO-PA:

Profitability Analysis

Actual revenue

190,000

Calculated cost of sales

96,000

Profit

94,000

The income statement shows the following values:

Income Statement

Expense

Revenue

Actual costs 90,000

Actual revenue 190,000

Reserves for unrealized costs 6,000

 

Profit 94,000

 

190,000

190,000

Period 04

In period 04 the actual costs increase to USD 130,000. You deliver the remaining goods and send the customer the final invoice for USD 10,000. The invoiced quantity is 20 units. The total revenue is USD 200,000. The order is now fully delivered and fully invoiced.

In results analysis, the system calculates the following data:

You then settle the following:

The following values are reported in CO-PA:

Profitability Analysis

Actual revenue

200,000

Calculated cost of sales

130,000

Profit

70,000

The income statement shows the following values:

Income Statement

Expense

Revenue

Actual costs 130,000

Actual revenue 200,000

Profit 70,000

 

200,000

200,000

The order has a total profit of USD 70,000.