Allocations in SAP Controlling

Allocations in SAP Controlling 1. Introduction and Background

Allocations are an important part of every implementation implementat ion using cost center accounting. acco unting. This paper should help to make the right choice of allocation using best practices and show how to configure the SAP system. This paper primarily focuses on cost center allocations of actual costs. It is recommended that as far as possible po ssible the basis of plan allocations should be the same sa me as for actual allocations to ensure consistency of o f data. In our implementation experience, t he most common type of allocation is assessment . This type of o f allocation will be described in more detail. 2. Best Practices

Allocation is the apportionment of costs based on an estimate rather than a direct measurement. Financial accounting requires that all costs of manufacturing be included in valuing inventory and cost of sales. If the cost co st system is being used to value inventory for financial reporting, some allocation must be made to individual products. This allocation can be done based on units produced or inputs, such as labor or machine hours. Allocation of overhead and other indirect costs is a necessary evil of financial accounting. For decision making purposes, though, all allocated ocated cost are often irrelevant. Allocation of overhead costs (e.g. accounting, human resources, etc.) to product line or product specific cost centers should be kept as simple as possible, if it is only an estimate to all allocate ocate costs. co sts. It is necessary to make sure there is direct relationship between additional add itional costs and additional produced products. p roducts. Any allocations could be misleading or o r distort decision making, if the relationship between output and overhead costs co sts is not proportional. If all the management accounting acco unting system is doing is taking the pool poo l of overhead expenses and assigning it to units of output, li little ttle is accomplished. For example, overhead is often allocated based on direct labor hours. This is convenient, but does it reflect the actual relationship relationship between activity and expenses? For companies with multiple services or products, different processes will lead to different relationships between labor and overhead. And what about abou t other factors such as machine time, volume (short or long runs), or materials? Without the effort to uncover the true relationship between activity and cost, the time spent devising allocation formulas will succeed in spreading overhead costs, but will say nothing about what actually caused them or how you can control them. Most companies have a large pool of expenses that do not appear directly related to the level of production or sales. In many companies this may even be the vast majority of expenses, including manufacturing overhead, such as wages wage s for supervisors and inspectors, power, maintenance, insurance and rent. All selling, administrative, and interest expenses are also in this group. They often represent 60%, 80%, even 95% of a company's expenditures. They also are not as fixed as is often assumed. Although one o ne additional unit of output won't change what is spent in the short term on rent, insurance, or supervisors, these expenses can change and do bear

Trusted by over 1 million members

Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.





a relationship to activities. Three months, a year, or five years may pass, but all expenses become variable at some point. Since most management decisions involve some long-term commitment of resources - space, people, p eople, marketing - the impact on "fixed" costs beco mes very relevant. While the relationship maybe hard to spot, most overhead costs are driven by specific products pro ducts and activities. The number of accounting accou nting clerks, purchasing agents, or warehouse personnel is often related to volume. Because managers are allocated a portion of overhead, much of which arises in other departments and is considered beyond the line managers' control, no one is held accountable for overhead. Managers have an incentive to reduce their direct costs on which overhead expense is allocated, but no incentive to reduce overhead itself. Overhead is indeed controllable and the accounting system must reflect this. As mentioned earlier, ear lier, if overhead expenses can be traced to the products or services that give rise to t hem, they should be. If not, recognize that not all expenses need to be allocated. If there is really no relationshi re lationship p between a product or service and an overhead expense, an allocation serves little purpose. To budget and control these expenses separately is a better option, rather rat her than create the illusion that volume or production efficiencies can change them. If the cost of the human resource department is independent of or o r too costly to trace to individual products, prod ucts, it is better to establish an operating budget and holding the department manager responsible respo nsible for it. Perhaps it is possible to develop measures such as cost per applicant to measure efficiency. If costs change, t he results are reported for just the department; the difference does not have to be absorbed by other departments or individual products. The same holds true for companies compa nies that like to allocate a portion of all corporate expenses to division or product lines to create pro forma P&Ls. Although the allocation may ensure that all the costs of business are reported, it ends up assigning the costs to departments that have no control over them and the allocation is unrelated to the source of o f the expense. The important thing is not to ignore the expenses or the line mangers held responsible for them. Overhead is too large to simply vanish in a series of allocations. The accounting system must ensure accountability for the level of overhead and it must be aligned with what the managers can actually control. y

y

y y

Clearly

the benefits of management accounting acco unting information information must be weighed we ighed against the cost of collecting and compili co mpiling ng the information. There is no single way to allocate costs, but some relationships will stand out as logical. For example: Power can be tied t ied to the number of machine hours a product requires. a llocated ocated fi first rst to departments depart ments based on square footage Expenses for the building can be all and then to any products produced in that department.





Many allocations proceed in a step-down manner. For example, some portion of building costs may be allocated to a quality assurance department. These costs, added to wages in the department, are then allocated to several different assembly and packaging departments. Next total costs for these areas are all a llocated ocated to products. In many companies labor hours are the t he basis of allocation. This scheme makes sense when production pro duction is labor intensive; however, as processes have gotten increasingly automated, many such allocations have become outdated. The best allocation scheme is one that traces costs as closely as possible possible to their source. The best way to do so is using activity based costing (ABC). One of the most recent developments in management accounting acco unting is the field of activity based costing. ABC is a management accounting approach that t hat traces all indirect costs, including administrative costs, back to the products that generated them. This practice recognizes the problems traditional cost systems have with allocating overhead and a nd with ignoring selling and administrative expenses, even though these may vary with sales or production volume. Management accounting and correct co rrect allocation methods are critical for internal decision making and control over the organization. 3.

Options and Type of Allocations This section describes different types of allocations and their main purpo se. Most allocations are used at period end. Period end allocations are procedures pro cedures which handle indirect allocation methods. Indirect allocation methods do not have ha ve the exchange of o f activities which are used as the basis for co st allocation, but instead have user defined de fined keys such as percentage rates, flat amounts, statistical statistical key figures, or posted amounts. These type of allocations are usually carried out after all the primary postings for a relevant period have been made. In addition to month end allocations there is one important method of o f allocat allocation ion that will happen during the month. Each internal activity is valuated to determi det ermine ne the costs co sts for business events (e.g. Internal cost allocation)

The following allocation methods are available for cost center accounting: 2.1 Direct Internal Activity Allocation

Internal cost allocation is used in cost center accounting. It involves measuring, entering and allocating of internal services performed. In order to use direct internal cost allocation the system requires relevant allocation bases which can be measured and used to allocate costs. These bases are known in SAP as activity types (e.g. quality control hours, maintenance hours ). The costs are allocated when operations are confirmed co nfirmed or activities recorded. This is a transaction -based allocation method, it does happen during the month for every transaction using act ivi ivity ty types that is posted in cost center accounting. To obtain the costs the system multiplies the activity quant ity produced by the activity price (determined for an activity). You can either set the activity rate manually when you plan p lan the activity or let the system compute it automatically auto matically.. This utili ut ility ty is





This type of allocation will be mainly used for production related cost centers, because it is not always possible to determine activities and activity rates for service and o verhead cost centers as well as determine the use of o f activities in these cost centers. 2.2 Indirect Activity Allocation

Indirect activity allocation is a tool for automatically auto matically allocat allocating ing plan and actual activities. Unlike direct activity allocation you use self-determined keys to allocate activities. Prior to allocation a fixed activity network is generated and valuat ion executed iteratively using it for allocation. 2.3 Calculation of Imputed Costs

Imputed costs are costs which need to be handled differently in cost center accounting and financial accounting. For example, operating costs which can be shown in financial accounting on an annual basis should be shown within management accounting on a monthly basis. Thus the process of distributing irregularly irregularly incurred expenses evenly over a number of periods is known as imputed cost calculation. 2.4 Distribution

It is a method of allocating costs from one cost center to other cost co st centers. It allocates all costs on one primary cost element to the same primary cost element on o n different cost centers. All information about the distributing posting, for example details on sender and receiver is documented in the cost accounting document. Advantages: y

Original cost element on the allocated a llocated costs is retained on receiver cost center

Disadvantages: y

y

Total on the original o riginal (sender ) cost center is 0, due to using the original cost element for allocation More records are generated in the system

2.5 Assessment

It is a method of allocating cots cot s from one cost center to other cost centers. This method does not allocate using the primary cost element but t ransfers costs using using and assessment (secondary) cost element. Therefore details of the original cost e lements will not be shown on the receiver rece iver cost element. This method allows grouping together to gether of different primary and secondary cost





y

y

y

Original costs remain on the cost center. So it is possible to report on just the primary costs. Data in the system is grouped grou ped together, for example material costs can be put to one assessment cost element. This method can allocate both primary and secondary cost elements on a cost center.

Disadvantages: y

The receiver cost element cannot identify the primary cost element.

4. Comparison of Allocation Types





5. Creation of an Assessment Cycle in the System

Assessment is the allocation method that is used most to all allocate ocate costs, because it shows allocated costs on another cost co st element. The advantage of o f this method is that reporting can still be done on the original cost center of all costs before allocat allocation. ion. Allocation rules (cycles) are defined once in a year and can then be run on a monthly basis. A cycle groups together diff d ifferent erent sender-receiver relationships which are defined de fined in segments. Separate allocation cycles must be created for allocating plan and actual costs, although the cycles my be copied form each other. y y y

Which objects have to all allocate ocate costs (senders)? Where are the costs co sts to be allocated to (receivers)? Which costs or activities are to be all a llocated? ocated?

Actual / plan costs y

On what basis are the costs co sts or activities to be allocated (tracing factors)?

Fixed amounts, fixed percentages, fixed portions (similar (similar to fixed percentage, with the exception that the amount is not limi limited ted to 100. The sender base is derived from the total of the receiver tracing factors), variable portions (amounts are allocated based o n postings in the database one the following types: cost elements, versions, activity types, statistical key figures)







A negative tracing factor can occur within the system if the tracing factors are not defined as fixed values or percentages, but are derived from objects such as statistical key figures or activity types. The problem arises only if one portion of the receivers has positive tracing factors and another portions has negative tracing trac ing factors. If the negative values are not scaled, then t hen not only the sender is credited. Receivers with negative values are also credited and receivers rece ivers with positive tracing factors are debited by a larger amount. Example:

Sender cost center (CC 1) allocates $1000 to 2 receivers rece ivers (CC 2, CC 3). The tracing factors (e.g. statistical key figures or activities) posted for the receivers are:+100 for CC 2, -90 for CC 3. The sender base is the total of o f the tracing factors: +100 - 90 = 10. Without scaling of the tracing factors the a ll llocated ocated amounts a mounts are calculated as follows: y y y

2 receives $1000 * (+100)/10 = $10000 CC 3 receives $1000 * (-90)/10 = $-9000 CC 3 is thus credited with $9000 at the expense of CC2. CC

The scaling process works as follows: 1. The lowest tracing factor is set to 0. 2. The other tracing factors are increased accordingly.





allocated, it may have an impact on runtime of the cycles. Depending on the sizes of the created cycles the runtime could be an issue. Object currency If this field is set all the sender values in the o bject currency are computed separately separate ly and distributed in separate fields. This facility only functions when the object currency of all objects is the same because no translation will take place during processing. If this indicator is not set it will result in the object ob ject currency being determined by the contro lli lling ng area currency. Transaction currency In indicating the transaction currency posted sender values are computed separately and the t he receiver is updated in the posted po sted transaction currency. In setting this indicator the allocation will create more records for each receiver and sender relationship. If you don't set this t his indicator the allocations will be carried out using the controlling area currency. 5.1 Segments

A segment is a way of o f grouping together related sender-receiver relationships. Each segment defines the cost elements and cost co st centers to be allocated. The receivers rece ivers can be cost centers, orders or WBS elements. Each segment has to have one o ne assessment cost element assigned. Sender cost centers, where the values to be allocated are calculated using the same rules, and the corresponding receiver cost centers, where the tracing factors are determined using the same rules, are combined in a segment. The segments are processed sequentially sequent ially during an allocation run. Sender values

Sender values are either actual or planned. If not the total amount, but a fixed predefined amount or percentage should be allocated it can be defined here.





receivers. The percentage value must not exceed 100. Where the percentage value is less than 100 the remainder stays on the sender. Fixed Portions - the value form the sender is allocated according to the total number o f receiver portions. Unlike the percentage allocation the value can be a maximum of 999.99. Allocation Base The use of allocation base only o nly arises of the tracing factor '1' - variable var iable portions is chosen. Then it is important to decide which of o f the field groups will be used to make the t he most meaningful allocation. If the field group entered is incorrect it may override any selection criteria chosen (e.g. if the field group actual costs is used but with a statistical key figure entered in the selection criteria the statistical key figure will be ignored. The a llocation will be made on the basis of actual costs present on the receivers.) Use of Statistical Key Figures in Assessments

There are two types of o f statistical statistical key figures within SAP: a fixed value and total value key ke y figure. y

y

The fixed value key figure (type 1) indicates that a key figure is fixed from the initial month for all subsequent months of o f the current fiscal year. A total value key figure (type 2) indicates that the amount of o f the key figure is set for the respective month and not carried forward to the subsequent months.

Statistical key figures can be incorporated incorpo rated in assessment cycles when the allocation is based on ratios like headcount square footage, telephone units etc. 6.

Processing Allocations

Cycles

can be processed directly on-line or as a background job. They can be processed in a test mode or an updated upd ated mode and with/without a detailed d etailed list list display. Usually allocation allocat ion cycles are processed at the end of each month for the period that has to be financially closed. The use of background jobs is recommended however it is imperative that these jobs are

Allocations in SAP Controlling

Recommend Documents