AC505_EN_Col92_FV_Part_A4 (第11页)

第 429 页 / 共 537 页

AC505 Lesson: Costing Models

RowNo. Type De- Ob- Quan- Unit Activa- Price

scrip- ject tity tion

tion

1 Vari- 890000 PUMP## Active .25

able

item

5. Createrows2through5inthetemplateusingthefollowinginformation:

Thequantityof material isbasedonthenumber of pumpstobeinstalled.

Thematerialsarerequiredtoperformconnectionsatthecustomersite. Two

connectionsofeachmaterialisrequiredfortheinletandoutletofthepump.

The materials required arebased on the type of connection thecustomer

uses,eitherSanclampconnectionsorAcmetreadconnections. Formulasfor

thequantityandactivationsarerequiredinthetemplate.

Row Type De- Object Quantity Unit Acti- Price

No. scrip- vation

tion

2 Mate- 100- PUMP## PC CON-

rial 260/1000 *2 NECT##

3 Mate- 100- PUMP## PC CON-

rial 261/1000 *2 NECT##

4 Mate- 100- PUMP## PC CON-

rial 250/1000 *2 NECT##

5 Mate- 100- PUMP## PC CON-

rial 251/1000 *2 NECT##

Note: Toaddnewrows,clicktheAppendRowicon.

6. Createrow6inthetemplateusingthefollowinginformation:

Thedistancetothecustomersiteisusedtodetermineiftheemployeecanuse

theirpersonalvehicletotransporttheinstallationtoolstothecustomersite.

Thecompanydecidestosetalimitof500KMasthebasisforemployeesto

usetheir personal vehicles. If thecustomer’ssiteisfarther than500KM,

costs such as airfare to the closest airport to the customer, shipment of

installationstools,andavehiclerentalshouldbedetermined. Astandardrate

of$0.31perKMisusedtocalculatepersonalvehicletravelcosts.

Aformulaforquantityandactivation isrequired.

Continued on next page

401

RowNo.	Type	De- scrip- tion	Ob- ject	Quan- tity	Unit	Activa- tion	Price
1	Vari- able item		890000	PUMP##		Active	.25

Row No.	Type	Object	Quantity	Unit	Acti- vation
2	Mate- rial	100- 260/1000	PUMP## *2	PC	CON- NECT##
3	Mate- rial	100- 261/1000	PUMP## *2	PC	CON- NECT##
4	Mate- rial	100- 250/1000	PUMP## *2	PC	CON- NECT##
5	Mate- rial	100- 251/1000	PUMP## *2	PC	CON- NECT##

第 430 页 / 共 537 页

Unit11: EasyCostPlanning AC505

Row Type De- Object Quan- Unit Activa- Price

No. script- tity tion

ion

6 Vari- 474210/KM DIST## KM DIST## .31

able

item

7. Createrow7inthetemplateusingthefollowinginformation:

Thecompanydeterminedthattheaveragetimerequiredtoinstallpumpsis

approximately4.5hoursforeachpump. Basedonthenumberofpumpsto

beinstalled,thesystemshouldcalculatethetotaltimeandlabourcosts. If

thetotaltimeexceedsthestandardworkinghoursof7.5,thecompanyalso

wantsto calculate per diem and hotel costs.

A quantity formula is required.

Row Type De- Ob- Quan- Unit Activa- Price

No. scrip- ject tity tion

tion

7 Cost Cen- 4220/ PUMP Active

ter/Activity 1421 ##

type

8. Createrow8inthetemplateusingthefollowinginformation:

Theperdiemcostsarebasedonastandardrateof65.00EURperday. The

companywantsthecostingmodeltocalculatethenumberofperdiemdays

based on the total timecalculated for the labor rounded up tothe nearest

whole number.

Aquantity, activation,andpriceformulaisrequired.

Row Type De- Object Quan- Unit Acti- Price

No. scrip- tity vation

tion

8 Vari- 474250/ Ceil DAY Active DIEM##

able DAY (PUMP##

item

9. Createrow9inthetemplateusingthefollowinginformation:

Continued on next page

402

Row No.	Type	De- script- ion	Object	Quan- tity	Unit	Activa- tion	Price
6	Vari- able item		474210/KM	DIST##	KM	DIST##	.31

Row No.	Type	De- scrip- tion	Ob- ject	Quan- tity	Unit	Activa- tion	Price
7	Cost Cen- ter/Activity type		4220/ 1421	PUMP ##		Active

Row No.	Type	De- scrip- tion	Object	Quan- tity	Unit	Acti- vation	Price
8	Vari- able item		474250/ DAY	Ceil (PUMP##	DAY	Active	DIEM##

第 431 页 / 共 537 页

AC505 Lesson: Costing Models

Ifthedistancetothecustomersiteisgreaterthan500KM,hotelcostsshould

becalculated. Theplanner should enter thedailycost ofthehotel, which

shouldbemultipliedbythenumberofdaysrequired. Thenumberofdays

shouldbecalculatedbasedonthetotallabortimeroundeduptothenearest

whole number.

Aquantity, activationandpriceformulaisrequired.

Row Type De- Object Quan- Unit Activa- Price

No. script- tity tion

ion

9 Vari- 474220/ Ceil DAY PUMP## HO-

able DAY (PUMP## TEL##

item

10. Createrow10inthetemplateusingthefollowinginformation:

Ifthedistancetothecustomersiteisgreaterthan500KM,theplannershould

enterthereturnairfaretotheairportnearestthecustomersite.

An activation and price formulais required.

Row Type De- Ob- Quan- Unit Activa- Price

No. script- ject tity tion

ion

10 Variable 474240 1 DIST## AIR##

item

11. Createrow11inthetemplateusingthefollowinginformation:

Ifthedistancetothecustomersiteisgreaterthan500KM,theinstallation

toolsshouldbeshippedtothecustomersitepriortoinstallation. Theplanner

shouldenterthecostofshippingthetoolstothecustomersiteandreturning

the tools back to the company.

An activation and price formulais required.

Row Type De- Object Quan- Unit Activa- Price

No. script- tity tion

ion

11 Variable 476900 2 DIST## SHIP##

item

12. Createrow12inthetemplateusingthefollowinginformation:

Continued on next page

403

Row No.	Type	De- script- ion	Object	Quan- tity	Unit	Activa- tion	Price
9	Vari- able item		474220/ DAY	Ceil (PUMP#	DAY #	PUMP##	HO- TEL##

Row No.	Type	De- script- ion	Ob- ject	Quan- tity	Unit	Activa- tion	Price
10	Variable item		474240	1		DIST##	AIR##

Row No.	Type	De- script- ion	Object	Quan- tity	Unit	Activa- tion	Price
11	Variable item		476900	2		DIST##	SHIP##

第 432 页 / 共 537 页

Unit11: EasyCostPlanning AC505

Ifthedistancetothecustomerisgreaterthan500KM,theemployeeshould

rentavehiclefortheinstallationperiod. Thenumberofdaysforwhichthe

vehicleisrequiredshouldbecalculatedbasedonthetotaltimerequiredto

installthepumpsroundeduptothenearestwholenumber.

Aquantity, activationandpriceformulaisrequired.

Row Type De- Ob- Quan- Unit Ac- Price

No. scrip- ject tity tiva-

tion tion

12 Variable 475000/Ceil DAY DIST##RENT##

item DAY (PUMP##

Select Save and Back.

404

Row No.	Type	De- scrip- tion	Ob- ject	Quan- tity	Unit	Ac- tiva- tion	Price
12	Variable item		475000 DAY	/Ceil (PUMP##	DAY	DIST#	#RENT##

第 433 页 / 共 537 页

AC505 Lesson: Costing Models

Solution 17: Creating a Costing Model and

Template

Task:

Create an Easy Cost Planning costing model.

1. EnterControllingarea1000ifpromptedforcontrollingarea.

Inthe“ModelMaintenance”screen,clickthe“CreateModel”icon.

FieldNameorDataType Values

Costing Model Group##

Name Group##Installpumpsmodel

Enterthecostingmodelandname. ClickContinue.

Youshouldnow see the Group##costing model in the header screen, the

namethatyoucreatedandthatisvalidforallobjects.

a) CreateanEasyCost Planningcostingmodel.

Accounting→Controlling→ProductCostControlling→Product

CostPlanning→EasyCostPlanning&ExecutionServices→Edit

CostingModel (transaction code CKCM)

EnterControllingarea1000,ifpromptedforcontrollingarea.

Inthe“ModelMaintenance”screen,selectthe“CreateModel”icon.

FieldNameorDataType Values

Costing Model Group##

Name Group##Installpumpsmodel

Enterthecostingmodelandname. Select“Continue”.

Youshouldnowseethe“Group##”costingmodelintheheaderscreen,

thenamethatyoucreatedandthatisvalidforallobjects.

2. Youdeterminedthatyouneedseveralcharacteristicsforthecostingmodel.

Youwantthecostplannertoenterthenumberofpumpstobeinstalledand

usethisquantityinthecostingmodeltodeterminecosts. Youalsorequire

characteristicsfor theentry of costs such as airfareif thecustomer isnot

withina500KMoftheplant,shipmentcosttodelivertheinstallationtools

and materialsto the customer site, employee per diem costs, hotel costs,

and truck rental, if required.

Continued on next page

405

FieldNameorDataType	Values
Costing Model	Group##
Name	Group##Installpumpsmodel

FieldNameorDataType	Values
Costing Model	Group##
Name	Group##Installpumpsmodel

第 434 页 / 共 537 页

Unit11: EasyCostPlanning AC505

Installation materials should be determined based on the kind of pump

connection the customer uses.

Inthelower part of theModel Maintenance screen (WorkArea), yousee

the tableto create andenter characteristics for the costingmodel. Create

the following characteristics:

FieldNameorDataType Values

Characteristic PUMP##

Description Numberofpumpstoinstall

CharacteristicGroup T-##

Data Type Numeric

Numberof characters 5

Decimal places 0

Unit of measure PC

Template Willdefaultuponselectingenter

EXP.Display 0 No exponent

Value Assignment Single

NegativeValueAllowed No

Entry Required Yes

Save the characteristic.

Charateristic CON- DIST## DIEM## HO-

NECT## TEL##

Description Typeofpump Distance Daily Hotel

connection to meal per room

customer diem cost

site per

night

CHARS.Group T-## T-## T-## T-##

Data Type CHAR NUM CURR CURR

NumberofChar. 5 7 7 7

Decimal Place 1 2 2

Unit of Measure/ km EUR EUR

currency

Continued on next page

406

FieldNameorDataType	Values
Characteristic	PUMP##
Description	Numberofpumpstoinstall
CharacteristicGroup	T-##
Data Type	Numeric
Numberof characters	5
Decimal places	0
Unit of measure	PC
Template	Willdefaultuponselectingenter
EXP.Display	0 No exponent
Value Assignment	Single
NegativeValueAllowed	No
Entry Required	Yes

Charateristic	CON- NECT##	DIST##	DIEM##	HO- TEL##
Description	Typeofpump connection	Distance to customer site	Daily meal per diem	Hotel room cost per night
CHARS.Group	T-##	T-##	T-##	T-##
Data Type	CHAR	NUM	CURR	CURR
NumberofChar.	5	7	7	7
Decimal Place		1	2	2
Unit of Measure/ currency		km	EUR	EUR

第 435 页 / 共 537 页

AC505 Lesson: Costing Models

Template Willdefault Will Will Will

default default default

Exp. Display 0 No 0 No 0 No 0 No

Exponent Exponent Exponent Expo-

nent

ValueAssignment Single Single Single Single

Interval Values No No No No

NegativeValueAllowed No No

Restrictable No No

EntryRequired Yes Yes No No

Values Tab - Char. ACME 65.00

ValueandDescription SANCP

Create these additional characterisitics

Character- AIR## SHIP## RENT##

istic

Description Airfare to Cost of shipping Van Rental per

customer tools day

CHARS. T-## T-## T-##

Group

DataType CURR CURR CURR

Number of 7 7 7

Char.

Decimal 2 2 2

Place

UnitofMea- EUR EUR EUR

sure/cur-

rency

Template Willdefault Will default Will default

Exp. Display 0NoExponent 0NoExponent 0NoExponent

Continued on next page

407

Template	Willdefault	Will default	Will default	Will default
Exp. Display	0 No Exponent	0 No Exponent	0 No Exponent	0 No Expo- nent
ValueAssignment	Single	Single	Single	Single
Interval Values NegativeValueAllowed Restrictable	No	No	No No No	No No No
EntryRequired	Yes	Yes	No	No
Values Tab - Char. ValueandDescription	ACME SANCP		65.00

Character- istic	AIR##	SHIP##	RENT##
Description	Airfare to customer	Cost of shipping tools	Van Rental per day
CHARS. Group	T-##	T-##	T-##
DataType	CURR	CURR	CURR
Number of Char.	7	7	7
Decimal Place	2	2	2
UnitofMea- sure/cur- rency	EUR	EUR	EUR
Template	Willdefault	Will default	Will default
Exp. Display	0NoExponent	0NoExponent	0NoExponent

第 436 页 / 共 537 页

Unit11: EasyCostPlanning AC505

Value Single Single Single

Assignment

Interval No No No

Values

No No No

Negative

No No No

Value

Allowed

Restrictable

Entry No No No

Required

a) Click the “Create characteristic” icon.

Enter the characteristic PUMP##.

PressEntertocontinueenteringthedataforthecharacteristic.

FieldNameorDataType Values

Characteristic PUMP##

Description Numberofpumpstoinstall

CharacteristicGroup T-##

Data Type Numeric

Numberofcharacters 5

Decimal places 0

Unit of measure PC

Template Willdefaultuponselectingenter

EXP.Display 0 No exponent

Value Assignment Single

NegativeValueAllowed No

Entry Required Yes

Save the characteristic.

Remain in the Characteristic screen and create the additional

characteristics for the costing model.

Select the Values tab to enter the characteristic-defined values as

noted in the chart.

Continued on next page

408

Value Assignment	Single	Single	Single
Interval Values Negative Value Allowed Restrictable	No No No	No No No	No No No
Entry Required	No	No	No

FieldNameorDataType	Values
Characteristic	PUMP##
Description	Numberofpumpstoinstall
CharacteristicGroup	T-##
Data Type	Numeric
Numberofcharacters	5
Decimal places	0
Unit of measure	PC
Template	Willdefaultuponselectingenter
EXP.Display	0 No exponent
Value Assignment	Single
NegativeValueAllowed	No
Entry Required	Yes

第 437 页 / 共 537 页

AC505 Lesson: Costing Models

Characteristic CON- DIST## DIEM## HOTEL##

NECT##

Description Type of Distance Daily Hotel room

pump to cus- meal per cost per

connection tomer diem night

site

CHARS.Group T-## T-## T-## T-##

Data Type CHAR NUM CURR CURR

NumberofChar. 5 7 7 7

DecimalPlace 1 2 2

Unit of Mea- km EUR EUR

sure/currency

Template Will Will Will Willdefault

default default default

Exp. Display 0 No 0NoEx- 0 No 0 No

Exponent ponent Exponent Exponent

ValueAssignment Single Single Single Single

IntervalValues No No

Negative Value No No No No

Allowed

No No

Restrictable

EntryRequired Yes Yes No No

Values Tab - ACME 65.00

Char. Value and SANCP

Description

Create these additional characteristics

Characteristic AIR## SHIP## RENT##

Description Airfare to Cost of VanRental

customer shippingtools perday

CHARS. Group T-## T-## T-##

Data Type CURR CURR CURR

Numberof Char. 7 7 7

Decimal Place 2 2 2

Continued on next page

409

Characteristic	CON- NECT##	DIST##	DIEM##	HOTEL##
Description	Type of pump connection	Distance to cus- tomer site	Daily meal per diem	Hotel room cost per night
CHARS.Group	T-##	T-##	T-##	T-##
Data Type	CHAR	NUM	CURR	CURR
NumberofChar.	5	7	7	7
DecimalPlace		1	2	2
Unit of Mea- sure/currency		km	EUR	EUR
Template	Will default	Will default	Will default	Willdefault
Exp. Display	0 No Exponent	0NoEx- ponent	0 No Exponent	0 No Exponent
ValueAssignment	Single	Single	Single	Single
IntervalValues Negative Value Allowed Restrictable	No	No	No No No	No No No
EntryRequired	Yes	Yes	No	No
Values Tab - Char. Value and Description	ACME SANCP		65.00

Characteristic	AIR##	SHIP##	RENT##
Description	Airfare to customer	Cost of shippingtools	VanRental perday
CHARS. Group	T-##	T-##	T-##
Data Type	CURR	CURR	CURR
Numberof Char.	7	7	7
Decimal Place	2	2	2

第 438 页 / 共 537 页

Unit11: EasyCostPlanning AC505

Unit of Measure/cur- EUR EUR EUR

rency

Template Will Willdefault Will

default default

Exp. Display 0 No 0NoExponent 0 No

Exponent Exponent

ValueAssignment Single Single Single

Interval Values No No No

NegativeValueAllowed No No No

Restrictable No No No

EntryRequired No No No

Savethecharacteristicsandreturntothemodelmaintenancescreen.

3. Arrangethecharacteristicsinthemodelinthefollowingorder:

Characteristic Name

PUMP##

CONNECT##

DIST##

DIEM##

HOTEL##

AIR##

SHIP##

RENT##

Continued on next page

410

Unit of Measure/cur- rency	EUR	EUR	EUR
Template	Will default	Willdefault	Will default
Exp. Display	0 No Exponent	0NoExponent	0 No Exponent
ValueAssignment	Single	Single	Single
Interval Values NegativeValueAllowed Restrictable	No No No	No No No	No No No
EntryRequired	No	No	No

Characteristic Name
PUMP##
CONNECT##
DIST##
DIEM##
HOTEL##
AIR##
SHIP##
RENT##

第 439 页 / 共 537 页

AC505 Lesson: Costing Models

Save your costing model.

a) Inthe“CharacteristicName”column,usethedropdowntoselectthe

characteristicorenterthecharacteristicintherowsintheorderlisted

in the chart below.

Characteristic Name

Characterisitc Name

PUMP##

CONNECT##

DIST##

DIEM##

HOTEL##

AIR##

SHIP##

RENT##

Save the costing model.

4. Create the costing model template. Select Define the derivation rules

(template).

InthedialogueboxSelectionof ReferenceObjectacceptthedefault#All

Objects.

Thisopensthetemplateareawhereyoucannowdefinevariouscostingrows.

Definetheobject,quantityformulas,activationformulas,andtheprice.

Enterthetemplatedescription“Installpumpscostmodel”.

Inthefirstrow,createavariableitemtodeterminethenumberofpumpsto

install.

Definethefirstrowwiththefollowinginformation:

Continued on next page

411

Characterisitc Name
PUMP##
CONNECT##
DIST##
DIEM##
HOTEL##
AIR##
SHIP##
RENT##

第 440 页 / 共 537 页

Unit11: EasyCostPlanning AC505

RowNo. Type De- Ob- Quan- Unit Activa- Price

scrip- ject tity tion

tion

1 Vari- 890000 PUMP## Active .25

able

item

a) IntheCostingModel screen, select the “Define the derivation rules

(template)” line.

InthefirstrowintheTypecolumn,selectObjectType“Variableitem”.

IntheObjectcolumn,usethedropdownboxtoentercostelement=

890000. LeavetheBaseUnitofMeasureblank.

Double-clickthefirstrowintheQuantitycolumntoopentheformula

creation part of the screen.

IntheFunctionsforLinetypeareaofthescreen,scrolldowntillyou

find the characteristic PUMP##.

Double-clickorselectanddragthecharacteristictotheformulaarea.

Click the Confirm Quantity icon.

ThecharacteristicPUMP##shouldnowappearinthefirstrowinthe

Quantity column.

IntheActivatecolumn,choosethedropdownboxandselectACTIVE.

DoubleclickinthePricecolumn,enter.25. SelectConfirmPrice.

The first row is now complete.

5. Createrows2through5inthetemplateusingthefollowinginformation:

Thequantityofmaterial isbasedonthenumber of pumpstobeinstalled.

Thematerialsarerequiredtoperformconnectionsatthecustomersite. Two

connectionsofeachmaterialisrequiredfortheinletandoutletofthepump.

The materials required are based on thetype of connection the customer

uses,eitherSanclampconnectionsorAcmetreadconnections. Formulasfor

thequantityandactivationsarerequiredinthetemplate.

Continued on next page

412

RowNo.	Type	De- scrip- tion	Ob- ject	Quan- tity	Unit	Activa- tion	Price
1	Vari- able item		890000	PUMP##		Active	.25

第 441 页 / 共 537 页

AC505 Lesson: Costing Models

Row Type De- Object Quantity Unit Acti- Price

No. scrip- vation

tion

2 Mate- 100- PUMP## PC CON-

rial 260/1000 *2 NECT##

3 Mate- 100- PUMP## PC CON-

rial 261/1000 *2 NECT##

4 Mate- 100- PUMP## PC CON-

rial 250/1000 *2 NECT##

5 Mate- 100- PUMP## PC CON-

rial 251/1000 *2 NECT##

Note: Toaddnewrows,clicktheAppendRowicon.

• For rows2 to 5, proceed as follows:

Intheobjectcolumn,single-clickthedrop-downicontoopenthe

dialogueboxthatisusedtoentertheMaterialNumberandPlant.

For the Object, you should now see the following formula in

the formula area of the screen:

Plant=‘1000’andMaterial_number=‘100-260’.

• Formaterialrows2to5,settheQuantityformulaasfollows:

Double-clickthequantitycolumnforthematerialrow.

IntheFunctionsforLinetypeareaofthescreen, scrolldownto

thecharacteristicPUMP##. Double-clickorselectanddragto

the formula area.

Intheformulaareaofthescreen,clickthe*icon.

Placethecursorintheformulaafterthe*andenteraspaceand

the number 2.

The formula should now be:

PUMP## * 2

Click the Confirm Quantity icon to copy the formula to the

column row.

Repeat thisprocess for rows 2 to 5.

• Set the Activation formula for the first two rows 2 and 3 and

materials100-260and100-261asfollows:

Continued on next page

413

Row No.	Type	Object	Quantity	Unit	Acti- vation
2	Mate- rial	100- 260/1000	PUMP## *2	PC	CON- NECT##
3	Mate- rial	100- 261/1000	PUMP## *2	PC	CON- NECT##
4	Mate- rial	100- 250/1000	PUMP## *2	PC	CON- NECT##
5	Mate- rial	100- 251/1000	PUMP## *2	PC	CON- NECT##

第 442 页 / 共 537 页

Unit11: EasyCostPlanning AC505

Double-clicktheactivationcolumnforthematerialrow.

In the Functions for Linetype area of the screen, scroll down

to thecharacteristicCONNECT##. Double-clickorselectand

drag to the formula area.

Intheformulaareaofthescreen,clickthe=icon.

Placethecursorafterthe=signintheformulaandenteraspace

followedby‘SANCP’ insinglequotes.

Click the Confirm Activation icon to copy the formula to the

column row.

• Set the Activation formula for the next two rows 4 and 5 and

materials 100-250 and 100-251.

Double-clicktheactivationcolumnforthematerialrow.

In the Functions for Linetype area of the screen, scroll down

to thecharacteristicCONNECT##. Double-clickorselectand

drag to the formula area.

Intheformulaareaofthescreen,clickthe=icon.

Placethecursorafterthe=signintheformulaandenteraspace

followedby ACME in single quotes.

Click the Confirm Activation icon to copy the formula to the

column row.

6. Createrow6inthetemplateusingthefollowinginformation:

Thedistancetothecustomersiteisusedtodetermineiftheemployeecanuse

theirpersonalvehicletotransporttheinstallationtoolstothecustomersite.

Thecompanydecidestosetalimitof500KMasthebasisforemployeesto

usetheir personalvehicles. Ifthecustomer’ssiteisfarther than500KM,

costs such as airfare to the closest airport to the customer, shipment of

installationstools,andavehiclerentalshouldbedetermined. Astandardrate

of$0.31perKMisusedtocalculatepersonalvehicletravelcosts.

Aformulaforquantityandactivationisrequired.

Continued on next page

414

第 443 页 / 共 537 页

AC505 Lesson: Costing Models

Row Type De- Object Quan- Unit Activa- Price

No. script- tity tion

ion

6 Vari- 474210/KM DIST## KM DIST## .31

able

item

a) Click the Append Row icon.

IntherowintheTypecolumn,selectObjectTypeas“Variableitem”.

IntheObjectcolumn,clickthedropdownicontoselectcostelement=

474210and BaseUnitof Measure=“KM”.

Double-click the row in the Quantity column to open the formula

creation part of the screen.

In the Functions for Linetype area of the screen, scroll down to the

characteristic DIST##.

Double-clickorselectanddragtotheformulaarea.

Click the Confirm Quantity icon.

ThecharacteristicDIST##shouldnowappearinthefirstrowunderthe

Quantity column.

Double-click the Activation column to open the formula creation

portion of the screen.

In the Functions for Linetype area of the screen, scroll down to the

characteristic DIST##.

Double-click or select and drag to theformula area. In the formula

area,placethecursoraftertheDIST##andclickthe<=LessThanor

Equalto)icon. Placethecursorafterthe<=,insertaspace,andenter

500 in single quotes EG ‘500’.

ClicktheConfirmActivationicontocopytheformulatothecolumn

row.

Double-clicktherowinthePRICEcolumntoopentheformulacreation

part of the screen.

Intheformulaportionofthescreen,enterthepriceas.31.

ClicktheConfirmPriceicontocopythepriceformulatotherow.

7. Createrow7inthetemplateusingthefollowinginformation:

Continued on next page

415

Row No.	Type	De- script- ion	Object	Quan- tity	Unit	Activa- tion	Price
6	Vari- able item		474210/KM	DIST##	KM	DIST##	.31

第 444 页 / 共 537 页

Unit11: EasyCostPlanning AC505

Thecompanydeterminedthattheaveragetimerequiredtoinstallpumpsis

approximately4.5hoursforeachpump. Basedonthenumberofpumpsto

beinstalled,thesystemshouldcalculatethetotaltimeandlabourcosts. If

thetotaltimeexceedsthestandardworkinghoursof7.5,thecompanyalso

wantsto calculate per diem and hotel costs.

A quantity formula is required.

Row Type De- Ob- Quan- Unit Activa- Price

No. scrip- ject tity tion

tion

7 Cost Cen- 4220/ PUMP Active

ter/Activity 1421 ##

type

a) Click the Append Row icon.

In the row in the Type column, select Object Type as “Cost

Center/Activity” type.

In the Object column, use the drop down icon to select cost center

= 4220and Activity type=“1421”. Arangeof valuesisdisplayed.

ChoosecurrentyearPumpProductionWageHours.

Double-click the row in the Quantity column to open the formula

creation part of the screen.

In the Functions for Linetype areaof the screen, scroll down to the

characteristic PUMP##.

Double-clickorselectanddragtotheformulaarea. Placethecursor

afterthePUMP##andclickthe*(multiply)icon. Placethecursorafter

the * and insert a space followed by 4.5. The formula should now

read as: PUMP## * 4.5.

Click the Confirm Quantity icon.

ThecharacteristicPUMP##shouldnowappearintherowunderthe

quantity column.

Fromthedrop-downlistintheActivationcolumn,chooseACTIVE.

8. Createrow8inthetemplateusingthefollowinginformation:

Theperdiemcostsarebasedonastandardrateof65.00EURperday. The

companywantsthecostingmodeltocalculatethenumberofperdiemdays

based on the total timecalculated for the labor rounded up tothe nearest

whole number.

Aquantity, activation,andpriceformulaisrequired.

Continued on next page

416

Row No.	Type	De- scrip- tion	Ob- ject	Quan- tity	Unit	Activa- tion	Price
7	Cost Cen- ter/Activity type		4220/ 1421	PUMP ##		Active

第 445 页 / 共 537 页

AC505 Lesson: Costing Models

Row Type De- Object Quan- Unit Acti- Price

No. scrip- tity vation

tion

8 Vari- 474250/ Ceil DAY Active DIEM##

able DAY (PUMP##

item

a) Click the Append Row icon.

IntherowintheTypecolumn,selectObjectTypeas“Variableitem”.

IntheObjectcolumn, usethedropdownicontoselectcost element

=474250and BaseUnit ofMeasure=DAY.

Double-click the row in the Quantity column to open the formula

creation part of the screen.

Createaformulaasfollows: =Ceil(PUMP##*4.5/7.5)

In the Functions for Linetype area of the screen, scroll down to the

mathematical function Ceil.

Double-clickorselectanddrag“CEIL”totheformulaarea.

Place the cursor after CEIL in the formula area and click the open

bracket icon (.

PlacethecursoraftertheopenbracketandintheFunctionsforLinetype

areaofthescreen,scrolldowntothecharacteristicPUMP##.

Double-clickorselectanddragtotheformulaarea. Placethecursor

after thePUMP## and click the * (multiply) icon. Place thecursor

afterthe*andinsertaspacefollowedby4.5. Clickthe/(divide)icon

and insert a space followed by 7.5. Click the ) closing bracket icon

and the Confirm Quantity icon.

Fromthedrop-downlistintheActivationcolumn,chooseActive.

Double-clicktherowinthePRICEcolumntoopentheformulacreation

part of the screen.

In the Functions for Linetype area of the screen, scroll down to

the characteristic DIEM##. Double-click or select and drag the

characteristic to the formula area.

Click the Confirm Price icon.

9. Createrow9inthetemplateusingthefollowinginformation:

Continued on next page

417

Row No.	Type	De- scrip- tion	Object	Quan- tity	Unit	Acti- vation	Price
8	Vari- able item		474250/ DAY	Ceil (PUMP##	DAY	Active	DIEM##

第 446 页 / 共 537 页

Unit11: EasyCostPlanning AC505

Ifthedistancetothecustomersiteisgreaterthan500KM,hotelcostsshould

becalculated. The planner should enter thedaily cost of thehotel, which

shouldbemultipliedbythenumberofdaysrequired. Thenumberofdays

shouldbecalculatedbasedonthetotallabortimeroundeduptothenearest

whole number.

Aquantity, activationandpriceformulaisrequired.

Row Type De- Object Quan- Unit Activa- Price

No. script- tity tion

ion

9 Vari- 474220/ Ceil DAY PUMP## HO-

able DAY (PUMP## TEL##

item

a) Click the Append Row icon.

IntherowintheTypecolumn,selectObjectTypeas“Variableitem”.

IntheObjectcolumn, usethedropdownicontoselect costelement

=474220andBaseUnit ofMeasure=DAY.

Double-click the row in the Quantity column to open the formula

creation part of the screen.

Createaformulaasfollows: =Ceil(PUMP##*4.5/7.5).

In the Functions for Linetype areaof the screen, scroll down to the

mathematical function Ceil.

Double-clickorselectanddrag“CEIL”totheformulaarea.

Placethecursor after CEIL intheformula area andclickthe( open

bracket icon.

PlacethecursoraftertheopenbracketandintheFunctionsforLinetype

areaofthescreen,scrolldowntothecharacteristicPUMP##.

Double-clickorselectanddragtotheformulaarea. Placethecursor

after the PUMP## and click the * (multiply) icon. Place the cursor

afterthe*andinsertaspacefollowedby4.5. Clickthe/(divide)icon

andinsert aspace followed by 7.5. Clickthe ) closing bracket icon

and the Confirm Quantity icon.

Double-clicktheActivationcolumnfortherowtocreatetheformula

for activation.

In the Functions for Linetype areaof the screen, scroll down to the

characteristic DIST##.

Continued on next page

418

Row No.	Type	De- script- ion	Object	Quan- tity	Unit	Activa- tion	Price
9	Vari- able item		474220/ DAY	Ceil (PUMP#	DAY #	PUMP##	HO- TEL##

第 447 页 / 共 537 页

AC505 Lesson: Costing Models

PlacethecursorintheformulaareaafterDIST##. Clickthe>(greater

than)iconandinsertaspacefollowedby500insinglequotes.

Click the Confirm Activation icon.

Double-clicktherowinthePRICEcolumntoopentheformulacreation

part of the screen.

In the Functions for Linetype area of the screen, scroll down to the

characteristic HOTEL##.

Click the Confirm Price icon.

10. Createrow10inthetemplateusingthefollowinginformation:

Ifthedistancetothecustomersiteisgreaterthan500KM,theplannershould

enterthereturnairfaretotheairportnearestthecustomersite.

An activation and price formulais required.

Continued on next page

419

第 448 页 / 共 537 页

Unit11: EasyCostPlanning AC505

Row Type De- Ob- Quan- Unit Activa- Price

No. script- ject tity tion

ion

10 Variable 474240 1 DIST## AIR##

item

a) Click the Append Row icon.

IntherowintheTypecolumn,selectObjectTypeas“Variableitem”.

IntheObjectcolumn,usethedropdownicontoselectcostelement=

474240andBaseUnitofMeasure=leaveblank.

Double-click the row in the Quantity column to open the formula

creation part of the screen.

Enter the quantity as 1.

Click the Confirm Quantity icon.

Double-clicktheActivationcolumnfortherowtocreatetheformula

for activation.

In the Functions for Linetype areaof the screen, scroll down to the

characteristicDIST##. Double-clickorselectanddragtotheformula

area.

PlacethecursorintheformulaareaafterDIST##,clickthe>(greater

than)icon,andinsertaspacefollowedby500insinglequotes.

Click the Confirm Activation icon.

Double-clicktherowinthePRICEcolumntoopentheformulacreation

part of the screen.

In the Functions for Linetype areaof the screen, scroll down to the

characteristicAIR##. Double-clickorselectanddragtotheformula

area.

Click the Confirm Price icon.

11. Createrow11inthetemplateusingthefollowinginformation:

Ifthedistancetothecustomersiteisgreaterthan500KM,theinstallation

toolsshouldbeshippedtothecustomersitepriortoinstallation. Theplanner

shouldenterthecostofshippingthetoolstothecustomersiteandreturning

the tools back to the company.

An activation and priceformula isrequired.

Continued on next page

420

Row No.	Type	De- script- ion	Ob- ject	Quan- tity	Unit	Activa- tion	Price
10	Variable item		474240	1		DIST##	AIR##

第 449 页 / 共 537 页

AC505 Lesson: Costing Models

Row Type De- Object Quan- Unit Activa- Price

No. script- tity tion

ion

11 Variable 476900 2 DIST## SHIP##

item

a) Click the Append Row icon.

IntherowintheTypecolumn,selectObjectTypeas“Variableitem”.

IntheObjectcolumn,usethedropdownboxtoselectcostelement=

476900andBaseUnitofMeasure=leaveblank.

Double-click the row in the Quantity column to open the formula

creation part of the screen.

Enter the quantity as 2.

Click the Confirm Quantity icon.

Double-clicktheActivationcolumnfortherowtocreatetheformula

for activation.

In the Functions for Linetype area of the screen, scroll down to the

characteristicDIST##. Double-clickorselectanddragtotheformula

area.

PlacethecursorintheformulaareaafterDIST##,choosethe>(greater

than)icon,andinsertaspacefollowedby500insinglequotes.

Click the Confirm Activation icon.

Double-clicktherowinthePRICEcolumntoopentheformulacreation

part of the screen.

In the Functions for Linetype area of the screen, scroll down to the

characteristicSHIP##. Double-clickorselectanddragtotheformula

area.

Click the Confirm Price icon.

12. Createrow12inthetemplateusingthefollowinginformation:

Ifthedistancetothecustomerisgreaterthan500KM,theemployeeshould

rentavehiclefortheinstallationperiod. Thenumberofdaysforwhichthe

vehicleisrequiredshouldbecalculatedbasedonthetotaltimerequiredto

installthepumpsroundeduptothenearestwholenumber.

Aquantity, activationandpriceformulaisrequired.

Continued on next page

421

Row No.	Type	De- script- ion	Object	Quan- tity	Unit	Activa- tion	Price
11	Variable item		476900	2		DIST##	SHIP##

第 450 页 / 共 537 页

Unit11: EasyCostPlanning AC505

Row Type De- Ob- Quan- Unit Ac- Price

No. scrip- ject tity tiva-

tion tion

12 Variable 475000/Ceil DAY DIST##RENT##

item DAY (PUMP##

Continued on next page

422

Row No.	Type	De- scrip- tion	Ob- ject	Quan- tity	Unit	Ac- tiva- tion	Price
12	Variable item		475000 DAY	/Ceil (PUMP##	DAY	DIST#	#RENT##

第 451 页 / 共 537 页

AC505 Lesson: Costing Models

Select Save and Back.

a) Click the Append Row icon.

IntherowintheTypecolumn,selectObjectTypeas“Variableitem”.

IntheObjectcolumn,usethedropdownboxtoselectcostelement=

475000 andBaseUnit of Measure=DAY.

Double-click the row in the Quantity column to open the formula

creation part of the screen.

Createaformulaasfollows: =Ceil(PUMP##*4.5/7.5).

In the Functions for Linetype area of the screen, scroll down to the

mathematical function Ceil.

Double-clickorselectanddrag“CEIL”totheformulaarea.

Place the cursor after CEIL in the formula area and click the open

bracket icon (.

PlacethecursoraftertheopenbracketandintheFunctionsforLinetype

areaofthescreen,scrolldowntothecharacteristicPUMP##.

Double-clickorselectanddragtotheformulaarea. Placethecursor

after the PUMP## and click the* (multiply) icon. Place you’re the

cursorafterthe*andinsertaspacefollowedby4.5. Clickthe/(divide)

icon. space7.5clicktheclosingbracket icon).

Click the Confirm Quantity icon.

Double-clicktheActivationcolumnfortherowtocreatetheformula

for activation.

In the Functions for Linetype area of the screen, scroll down to the

characteristicDIST##. Double-clickorselectanddragtotheformula

area.

PlacethecursorintheformulaareaafterDIST##,clickthe>(greater

than)icon,andinsertaspacefollowedby500insinglequotes.

Click the Confirm Activation icon.

Double-clicktherowinthePRICEcolumntoopentheformulacreation

part of the screen.

In the Functions for Linetype area of the screen, scroll down to the

characteristicRENT##. Double-clickorselectanddragtotheformula

area.

Click the Confirm Price icon.

b) Select Save and then Back.

423

第 452 页 / 共 537 页

Unit11: EasyCostPlanning AC505

Lesson Summary

You should now be able to:

• Describetheapplicationoptionsofeasycostplanning

• Createacostingmodeltodefineaplanningscreen

• Createcharacteristics for easy cost planning

• Create a costing template for a costing model

• Createandapplyformulasinthecostingtemplate

424

第 453 页 / 共 537 页

AC505 Lesson: Cost Estimate

Lesson: Cost Estimate

Lesson Overview

This lesson explains how to create an ad hoc cost estimate using an easy

cost-planning template. It alsoexplainshow touseexecution servicesto enter

commitments and actual costs.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Createanadhoccostestimateusinganeasycostplanningtemplate

• Useexecutionservicestoentercommitmentsandactualcosts

Business Example

Your company offers installation servicesfor the pumps it sells. You need the

capabilitytocreateanadhoccost estimatetodeterminethecostsforcustomer

installation.

Ad hoc Cost Estimates

Figure 189: AdhocCostEstimate Usingthe Costing Model

Ifyouwanttoplancostswithoutmakingtheeffortofcreatingaplanningobjectin

thesystem,youcancreateanadhoccostestimatetoobtainquickresults.

Youcanalsouseadhoccostestimatestotestthecostingmodel.

425

第 454 页 / 共 537 页

Unit11: EasyCostPlanning AC505

Ifyouwanttouseaplanningformforthecostestimate, youneedtodefinethe

planning formin thesystem. UnderWith Planning Form, enter the(technical)

nameofaplanningformdirectly andchooseCreate.

Ifnoplanningformisdisplayedintheworklistarea(forexample, becauseyou

havenotyetcreatedanadhoccostestimate), underSubjectAreachooseeither

All Planning Formsor anotherrole-specificworklist.

Tosearchforaplanningform,enterasearchtermandchooseFind. Thesystem

searches in the names and descriptions for the planning forms in your logon

language.

Figure 190: Additional Data

Beforeyoucanplancosts, youneedtodefineacostingvariantinCustomizing

for the ad hoc cost estimate.

You needtoenteratleast aCompanyCodeor Plant.

You may also enter the appropriateprofit center.

Youcanentertheappropriatecostingdatesorusethedefaultcostingdatesbased

onthesettingforDateControlinthecostingvariant.

426