Skip to main content
Skip table of contents

New Columns 'Total Cost' and 'Profit %' Added in Order Item Grid and Labor Grid

Reference No: 29030

Details

Support for the Total Cost Column and Profit % is provided in the Order Item Grid and the Labor Grid.

The Cost / Unit and the Overhead Cost can be edited by performing a double-click in the Orders with the Item line comprising of the Status as Rent, Sub Rent, Sell, S-Assign, P-AssignMisc., and Labor applied on RT Cost, OT Cost, and DT Cost. The Overhead Cost field and the Cost / Unit field cannot be edited for the Order with the Item line comprising of the Status as S-Assign and P-Assign.

The same is explained by providing various Scenarios for each Item Status in the below Sample Workflow.

Sample Workflow
Scenario 1: Total Cost of the Item with the Status as Rent

Day-Week-Month Pricing is Disabled

Prerequisites

Perform the following the steps:

  1. Select the Maintenance module.

  2. Create an Item [SITEM#1].

  3. Define the Pricing for the Item [SITEM#1], as shown in Figure 1.0.

Figure 1.0 Pricing defined for the Item [SITEM#1]

 

  1. Select OK.

  2. Exit the Maintenance module.

Steps:

  1. Select the Account module and tag a Company [EVERGREEN AV RENTALS].

  2. Create a Rental Reservation Order [ORDER-956] for 2 days duration.

  3. Add the Item [SITEM#1] with Qty as 2 to the Rental Reservation Order [ORDER-956], as shown in Figure 1.1.

Figure 1.1 ORD-956 Rental Reservation Order

 

  1. The Total Cost column displays the total cost as 640.00 for the Item [SITEM#1].

  2. Total Cost is calculated as the (Cost [150.00] * Item Qty. [2.00] * Duration [2 Days]) + Overhead Cost [20.00] * Item Qty. [2.00]. The same is described in the following Table 1.0.

Table 1.0 Total Cost Calculations

Calculations

Result

Cost [150.00] * Item Qty. [2.00] * Duration [2 Days]

600.00

Overhead Cost [20.00] * Item Qty. [2.00]

40.00

Total Cost is 600.00 + 40.00

640.00

 

The Overhead Cost is applicable only on the Qty. and not on the Duration.

  1. The Profit % column displays as 46.67%  for the Item [SITEM#1].

  2. The Profit % is calculated as (Charge - Cost / Charge)*100. The same is described in the following Table 1.1.

Table 1.1 Profit % Calculations

Calculations

Result

Charge

1200.00

Charge - Cost is 1200.00 - 640.00

560.00

Charge - Cost / Charge is 560.00/1200.00*100

46.67

Profit %

46.67%

 

  1. Select the Cost tab of the Rental Reservation Order [ORDER-956] and click the Refresh button to view the Total Cost [640.00], Profit (Margin) [560.00] , and Profit % [46.67%], as shown inthe below Figure 1.2.

Figure 1.2 ORD-956 Rental Reservation Order - Cost tab

  1. Select the Item [SITEM#1] line, perform a right-click and select the Edit option. The Item line Edit window with the Cost / Unit [150.00] and Overhead Cost [20.00] is displayed, as shown in Figure 1.3.

Figure 1.3 The Item [SITEM#1] line Edit window

 

  1. Modify the Overhead Cost to 10.00 and click OK.

  2. Select the Cost tab of the Rental Reservation Order [ORDER-956] and click the Refresh button to view the Total Cost [620.00], Profit (Margin) [580.00] , and Profit % [48.33%], as shown in the below Figure 1.4.

Figure 1.4 ORD-956 Rental Reservation Order - Cost tab displaying the modified values

  1. Save and Exit the Rental Reservation Order [ORDER-956].

For a Non-Serial Kit, when the package header cost is edited, the cost is distributed to the child Items within the Non-Serial Kit based on the previous ratio. Also, if any child Item within the Non-Serial Kit is linked to a Purchase Order, the Cost field is disabled.

Day-Week-Month Pricing is Enabled

Prerequisites

Perform the following the steps:

  1. Select the Maintenance module.

  2. Create an Item [SITEM#B].

  3. Define the Daily Pricing for the Item [SITEM#B], as shown in Figure 1.5.

Figure 1.5 Daily Pricing defined for the Item [SITEM#B]

  1. Define the Weekly Pricing for the Item [SITEM#B], as shown in Figure 1.6.

Figure 1.6 Weekly Pricing defined for the Item [SITEM#B]

  1. Define the Monthly Pricing for the Item [SITEM#B], as shown in Figure 1.7.

Figure 1.7 Monthly Pricing defined for the Item [SITEM#B]

  1. Select OK.

  2. Exit the Item [SITEM#B] window and Maintenance module.

Steps

  1. Select the Account module and tag a Company [EVERGREEN AV RENTALS].

  2. Create a Rental Reservation Order [ORD-377] for 28 days duration.

  3. Add the Item [SITEM#B] with Qty as 2 to the Rental Reservation Order [ORD-377], as shown in Figure 1.8.

Figure 1.8 ORD-377 Rental Reservation Order

  1. The Total Cost column displays the total cost as 1820.00 for the Item [SITEM#B].

  2. Total Cost is calculated as the (Cost [100.00] * Item Qty. [2.00] * Days In Month [9 Days]) + Overhead Cost [10.00] * Item Qty. [2.00]. The same is described in the following Table 1.2.

Table 1.2 Total Cost Calculations

Calculations

Result

Cost [100.00] * Item Qty. [2.00] * Days in Month [9 Days]

1800.00

Overhead Cost [10.00] * Item Qty. [2.00]

20.00

Total Cost is 1800.00 + 20.00

1820.00

The Overhead Cost is applicable only on the Qty. and not on the Duration.

  1. The Profit % column displays as -1.11%  for the Item [SITEM#B].

  2. The Profit % is calculated as (Charge - Cost / Charge)*100. The same is described in the following Table 1.3.

Table 1.3 Profit % Calculations

Calculations

Result

Charge

1800.00

Charge - Cost is 1800.00 - 1820.00

-20.00

Charge - Cost / Charge is -20.00/1800.00*100

-1.11%

Profit %

-20 (-1%)

  1. Select the Cost tab of the Rental Reservation Order [ORDER-377] and click the Refresh button to view the Total Cost [1820.00], Profit (Margin) [-20 (-1%)] , and Profit % [-20 (-1%)], as shown in the below Figure 1.9.

Figure1.9 ORD-377 Rental Reservation Order - Cost tab

  1. Select the Item [SITEM#B] line, perform a right-click and select the Edit option. The Item line Edit window with the Cost / Unit [32.14] and Overhead Cost [10.00] is displayed, as shown in Figure 1.10.

Figure1.10 The Item [SITEM#B] line Edit window

  1. Click OK.

  2. Save and Exit the Rental Reservation Order [ORDER-377].

You cannot edit the Cost / Unit and the Overhead Cost for an Item or a Kit with the Rent Action when the Day-Week-Month Pricing check box is enabled.

Scenario 2: Total Cost of the Item with the Status as Sell

Prerequisites

Perform the following the steps:

  1. Select the Maintenance module.

  2. Create an Item [ITEM#1].

  3. Define the Av. Cost for the Item [ITEM#1], as shown in Figure 2.0.

Figure 2.0 Av.Cost for the Item [ITEM#1]

  1. Select OK.

  2. Exit the Maintenance module.

Steps

  1. Select the Account module and tag a Company [EVERGREEN AV RENTALS].

  2. Create a Rental Reservation Order [ORDER-957] for 2 days duration.

  3. Add the Item [ITEM#1] with Qty as 2 to the Rental Reservation Order [ORDER-957] and modify the Action drop-down as Sell, as shown in Figure 2.1.  

Figure 2.1 ORD-957 Rental Reservation Order

  1. The Total Cost column displays the total cost as 400.00 for the Item [ITEM#1].

  2. Total Cost is calculated as the (Av. Cost [200.00] * Item Qty. [2.00]).  The same is described in the following Table 2.0.

Table 2.0 Total Cost Calculations - Sell

Component

Value

Av. Cost

200.00

Item Qty.

2.00

Total Cost

400.00

  1. Select the Cost tab of the Rental Reservation Order [ORDER-957] and click the Refresh button to view the Total Cost [400.00], as shown in the below Figure 2.2.

Figure 2.2 ORD-957 Rental Reservation Order - Cost tab

  1. Select the Item [ITEM#1] line, perform a right-click and select the Edit option. The Item line Edit window with the Cost / Unit [200.00] is displayed, as shown in Figure 2.3.

Figure 2.3 The Item [ITEM#1] line Sale Edit window before modifying

  1. Modify the Cost / Unit to 300.00 and enter the Overhead Cost as 10.00 and click OK, as shown in Figure 2.4.

Figure 2.4 The Item [ITEM#1] line Sale Edit window after modifying

  1. The Total Cost is calculated as the (Av. Cost [200.00] * Item Qty. [2.00]) + Overhead Cost [10.00].

  2. Select the Cost tab of the Rental Reservation Order [ORDER-957] and click the Refresh button to view the Total Cost [600.00], as shown inthe below Figure 2.5.

Figure 2.5 ORD-957 Rental Reservation Order - Cost tab displaying the modified values

  1. Save and Exit the Rental Reservation Order [ORDER-957].

Scenario 3: Total Cost of the Item with the Status as Sub Rent

Day-Week-Month Pricing is Disabled

Prerequisites

Perform the following the steps:

  1. Select the Maintenance module.

  2. Create an Item [SITEM#2]

  3. Define the Pricing for the Item [SITEM#2], as shown in Figure 3.0

Figure 3.0 Pricing defined for the Item [SITEM#1]

  1. Select OK.

  2. Exit the Maintenance module.

Steps

  1. Select the Account module and tag a Company [EVERGREEN AV RENTALS].

  2. Create a Rental Reservation Order [ORDER-958] for 2 days duration.

  3. Add the Item [SITEM#2] with Qty as 2 to the Rental Reservation Order [ORDER-958], as shown in Figure 3.1.

Figure 3.1 ORD-958 Rental Reservation Order

  1. The Total Cost column displays the total cost as 640.00 for the Item [SITEM#2].

  2. Select the Item [SITEM#2] line, perform a right-click and select the Assign option. The Assign window is displayed.

  3. Select the Sub-Rental radio button and click OK. The Assign Vendor dialog box is displayed.

  4. Select the Assign Later radio button and click OK. The Item [SITEM#2] line Status gets modified to Sub Rent, as shown in Figure 3.2.

Figure 3.2 ORD-958 Rental Reservation Order - Sub Rent

  1. Total Cost is calculated as the (Cost [150.00] * Item Qty. [2.00] * Duration [2 Days]) + Overhead Cost [20.00] * Item Qty. [2.00]. The same is described in the following Table 3.0.

Table 3.0 Total Cost Calculations

Calculations

Result

Cost [150.00] * Item Qty. [2.00] * Duration [2 Days]

600.00

Overhead Cost [20.00] * Item Qty. [2.00]

40.00

Total Cost is 600.00 + 40.00

640.00

The Overhead Cost is applicable only on the Qty. and not on the Duration.

  1. The Profit % column displays as 46.67%  for the Item [SITEM#2].

  2. The Profit % is calculated as (Charge - Cost / Charge)*100. The same is described in the following Table 3.1.

Table 3.1 Profit % Calculations

Calculations

Result

Charge

1200.00

Charge - Cost is 1200.00 - 640.00

560.00

Charge - Cost / Charge is 560.00/1200.00*100

46.67

Profit %

46.67%

  1. Select the Cost tab of the Rental Reservation Order [ORDER-958] and click the Refresh button to view the Total Cost [640.00], Profit (Margin) [560.00], and Profit % [46.67%], as shown in the below Figure 3.3.

Figure3.3 ORD-958 Rental Reservation Order - Cost tab

  1. Select the Item [SITEM#2] line, perform a right-click and select the Edit option. The Item line Edit window with the Cost / Unit [150.00] and Overhead Cost [20.00] is displayed, as shown in Figure 3.4.

Figure 3.4 The Item [SITEM#2] line Edit window

  1. Modify the Overhead Cost to 10.00 and click OK.

  2. Select the Cost tab of the Rental Reservation Order [ORDER-958] and click the Refresh button to view the Total Cost [640.00], Profit (Margin) [560.00] , and Profit % [47.0%], as shown in the below Figure 3.5.

Figure 3.5 ORD-958 Rental Reservation Order - Cost tab displaying the modified values

  1. Save and Exit the Rental Reservation Order [ORDER-958].

Day-Week-Month Pricing is Enabled

Prerequisites

Perform the following the steps:

  1. Select the Maintenance module.

  2. Create an Item [SITEM#C]

  3. Define the Daily Pricing for the Item [SITEM#C], as shown in Figure 3.6.

Figure 3.6 Daily Pricing defined for the Item [SITEM#C]

  1. Define the Weekly Pricing for the Item [SITEM#C], as shown in Figure 3.7.

Figure 3.7 Weekly Pricing defined for the Item [SITEM#C]

  1. Define the Monthly Pricing for the Item [SITEM#C], as shown in Figure 3.8.

Figure 3.8 Monthly Pricing defined for the Item [SITEM#C]

  1. Exit the Item [SITEM#C] window and the  Maintenance module.

Steps

  1. Select the Account module and tag a Company [EVERGREEN AV RENTALS].

  2. Create a Rental Reservation Order [ORD-378] for 28 days duration.

  3. Add the Item [SITEM#C] with Qty as 2 to the Rental Reservation Order [ORD-378], as shown in Figure 3.9.

Figure 3.9 ORD-378 Rental Reservation Order

  1. The Total Cost column displays the total cost as 1820.00 for the Item [SITEM#C].

  2. Select the Item [SITEM#C] line, perform a right-click and select the Assign option. The Assign window is displayed.

  3. Select the Sub-Rental radio button and click OK. The Assign Vendor dialog box is displayed.

  4. Select the Assign Later radio button and click OK. The Item [SITEM#C] line Status gets modified to Sub Rent, as shown in Figure 3.10.

Figure 3.10 ORD-378 Rental Reservation Order - Sub Rent

  1. Total Cost is calculated as the (Cost [100.00] * Item Qty. [2.00] * Days In Month [9 Days]) + Overhead Cost [10.00] * Item Qty. [2.00]. The same is described in the following Table 3.2.

Table 3.2 Total Cost Calculations

Calculations

Result

Cost [100.00] * Item Qty. [2.00] * Days in Month [9 Days]

1800.00

Overhead Cost [10.00] * Item Qty. [2.00]

20.00

Total Cost is 1800.00 + 20.00

1820.00

The Overhead Cost is applicable only on the Qty. and not on the Duration.

  1. The Profit % column displays as -1.11%  for the Item [SITEM#B].

  2. The Profit % is calculated as (Charge - Cost / Charge)*100. The same is described in the following Table 3.3.

Table 3.3 Profit % Calculations

Calculations

Result

Charge

1800.00

Charge - Cost is 1800.00 - 1820.00

-20.00

Charge - Cost / Charge is -20.00/1800.00*100

-1.0%

Profit %

-20 (-1%)

 

  1. Select the Cost tab of the Rental Reservation Order [ORDER-378] and click the Refresh button to view the Total Cost [1820.00], Profit (Margin) [-20 (-1%)] , and Profit % [-1.0%], as shown in the below Figure 3.11.

Figure 3.11 ORD-378 Rental Reservation Order - Cost tab

  1. Select the Item [SITEM#C] line, perform a right-click and select the Edit option. The Item line Edit window with the Cost / Unit [32.14] and Overhead Cost [10.00] is displayed, as shown in Figure 3.12.

Figure 3.12 The Item [SITEM#C] line Edit window

  1. Modify the Overhead Cost to 20.00 and click OK.

  2. Select the Cost tab of the Rental Reservation Order [ORDER-378] and click the Refresh button to view the Total Cost [1840.00] and Profit % [-40(-2%)], as shown in Figure 3.13.

Figure 3.12 ORD-378 Rental Reservation Order - Cost tab displaying the modified values

  1. Save and Exit the Rental Reservation Order [ORDER-378].

Scenario 4: Total Cost of the Item with the Status as S-Assign

Prerequisites

Perform the following the steps:

  1. Select the Maintenance module.

  2. Create an Item [SITEM#3].

  3. Define the Pricing for the Item [SITEM#3], as shown in Figure 4.0.

Figure 4.0 Pricing defined for the Item [SITEM#3]

  1. Select OK.

  2. Exit the Maintenance module.

Steps

  1. Select the Account module and tag a Company [EVERGREEN AV RENTALS].

  2. Create a Rental Reservation Order [ORDER-969] for 2 days duration.

  3. Add the Item [SITEM#3] with Qty as 2 to the Rental Reservation Order [ORDER-969], as shown in Figure 4.1.

Figure 4.1 ORD-969 Rental Reservation Order

  1. The Total Cost column displays the total cost as 640.00 for the Item [SITEM#3].

  2. Select the Item [SITEM#3] line, perform a right-click and select the Assign option. The Assign window is displayed.

  3. Select the Sub-Rental radio button and click OK. The Assign Vendor dialog box is displayed.

  4. Select the User Assign radio button and click OK. The Purchase Order dialog box is displayed.

  5. Select Create New Purchase Order radio button. The Supplier window is displayed.

  6. Select the Supplier [UBS] and click OK.

  7. The Purchase Order [PO-088] is created and displayed. Exit the Purchase Order [PO-088] window.

The Amount provided in the Purchase Order [PO-088] is considered as the Total Cost.

  1. The Item [SITEM#3] line Status gets modified to S-Assign, as shown in Figure 4.2.

Figure 4.2 ORD-969 Rental Reservation Order with Item [SITEM#3] line Status as S-Assign

  1. Total Cost is calculated as the (Cost [150.00] * Item Qty. [2.00] * Duration [2 Days]) * Item Qty. [2.00]. The same is described in the following Table 4.0.

Table 4.0 Total Cost Calculations

Calculations

Result

Cost [150.00] * Item Qty. [2.00] * Duration [2 Days]

600.00

Total Cost is 600.00

600.00

  1. Select the Cost tab of the Rental Reservation Order [ORDER-969] and click the Refresh button to view the Total Cost [600.00], as shown in the below Figure 4.3.

Figure 4.3 ORD-969 Rental Reservation Order - Cost tab

  1. Select the Item [SITEM#3] line, perform a right-click and select the Edit option. The Item line Edit window with the Cost / Unit [300.00] and Overhead Cost [0.00] is displayed, as shown in Figure 4.4.

Figure 4.4 The Item [SITEM#3] line Edit window

  1. Save and Exit the Rental Reservation Order [ORDER-969].

The Cost / Unit  field and the Overhead Cost field cannot be edited by right clicking a S-Assign Item line > Edit . The Overhead Cost is not considered for the Order with the Item line Status as S-Assign.

Scenario 5: Total Cost of the Item with the Status as P-Assign

Prerequisites

Perform the following the steps:

  1. Select the Maintenance module.

  2. Create an Item [SITEM#4]

  3. Define the Av. Cost for the Item [SITEM#4], as shown in Figure 5.0.

Figure 5.0 Pricing defined for the Item [SITEM#4]

  1. Select OK.

  2. Exit the Maintenance module.

Steps

  1. Select the Account module and tag a Company [EVERGREEN AV RENTALS].

  2. Create a Rental Reservation Order [ORDER-971] for 2 days duration.

  3. Add the Item [SITEM#4] with Qty as 2 to the Rental Reservation Order [ORDER-971] and modify the Action drop-down as Sell, as shown in Figure 5.1.

Figure 5.1 ORD-971 Rental Reservation Order

  1. The Total Cost column displays the total cost as 400.00 for the Item [SITEM#4].

  2. Select the Item [SITEM#4] line, perform a right-click and select the Assign option. The Assign window is displayed.

  3. Select the Purchase radio button and click OK. The Assign Vendor dialog box is displayed.

  4. Select the User Assign radio button and click OK. The Purchase Order dialog box is displayed.

  5. Select Create New Purchase Order radio button. The Supplier window is displayed.

  6. Select the Supplier [UBS] and click OK.

  7. The Purchase Order [PO-087] is created and displayed. Enter the Unit Price [200.00] and the Amount is calculated as 400.00. Exit the Purchase Order [PO-087] window.

The Amount provided in the Purchase Order [PO-087] is considered as the Total Cost.

  1. The Item [SITEM#4] line Status gets modified to P-Assign with the Total Cost [400.00], as shown in Figure 5.2.

Figure 5.2 ORD-971 Rental Reservation Order with Item [SITEM#4] line Status as P-Assign

  1. Total Cost is calculated as the (Av. Cost [200.00] * Item Qty. [2.00]). The same is described in the following Table 5.0.

Table5.0 Total Cost Calculations

Calculations

Result

Av. Cost

200.00

Item Qty.

2.00

Total Cost 200.00 *2.00

400.00

The Overhead Cost is not applicable for the Item that is for Sale.

  1. Select the Cost tab of the Rental Reservation Order [ORDER-971] and click the Refresh button to view the Total Cost [400.00], as shown in the below Figure 5.3.

Figure 5.3 ORD-971 Rental Reservation Order - Cost tab

  1. Select the Item [SITEM#4] line, perform a right-click and select the Edit option. The Item line Edit window with the Cost / Unit [200.00] and Overhead Cost [0.00] is displayed, as shown in Figure 5.4.

Figure 5.4 The Item [SITEM#4] line Edit window

  1. Save and Exit the Rental Reservation Order [ORDER-971].

The Cost / Unit  field and the Overhead Cost field cannot be edited by right clicking a P-Assign Item line > Edit . The Overhead Cost is not considered for the Order with the Item line Status as P-Assign.

Scenario 6: Total Cost for Misc Charges

Prerequisites

Perform the following the steps:

  1. Select the Maintenance module > Items tab > Misc Charges tab.

  2. Create a Misc Charge [FREIGHTCHRGS].

  3. Define the Pricing for the Misc Charge [FREIGHTCHRGS], as shown in Figure 6.0.

Figure 6.0 Pricing defined for the Misc Charge [FREIGHTCHRGS]

  1. Select OK.

  2. Exit the Maintenance module.

Steps

  1. Select the Account module and tag a Company [EVERGREEN AV RENTALS].

  2. Create a Rental Reservation Order [ORDER-959] for 2 days duration.

  3. Select the Search menu > Misc Charges option. The Search Items window is displayed.  

  4. Search and add the Misc Charge [FREIGHTCHRGS] with Qty as 3 to the Rental Reservation Order [ORDER-959], as shown in Figure 6.1.

Figure 6.1 ORD-959 Rental Reservation Order

  1. The Total Cost column displays the total cost as 255.00 for the Misc Charge [FREIGHTCHRGS].

  2. Total Cost is calculated as the (Cost [75.00] + Overhead Cost [10.00] * Item Qty. [3.00]. The same is described in the following Table 6.0.

Table 6.0 Total Cost Calculations

Calculations

Result

Cost [75.00] + Overhead Cost [10.00] * Item Qty. [3.00]

255.00

Total Cost

255.00

 

The Overhead Cost is applicable only on the Qty. and not on the Duration.

  1. The Profit % column displays as 43.33%  for the Misc Charge [FREIGHTCHRGS].

  2. The Profit % is calculated as (Charge - Cost / Charge)*100. The same is described in the following Table 6.1.

Table 6.1 Profit % Calculations

Calculations

Result

Charge

450.00

Charge - Cost is 450.00 - 255.00

195.00

Charge - Cost / Charge is 195.00/450.00*100

43.33%

Profit %

43.33%

 

  1. Select the Cost tab of the Rental Reservation Order [ORDER-959] and click the Refresh button to view the Total Cost [255.00], Profit (Margin) [195.00] , and Profit % [43.33%], as shown in the below Figure 6.2.

Figure 6.2 ORD-959 Rental Reservation Order - Cost tab

  1. Select the Misc Charge [FREIGHTCHRGS] line, perform a right-click and select the Edit option. The Item line Edit window with the Freight/ Misc Cost [75.00], Overhead Cost [10.00], and Markup % [76.47] is displayed, as shown in Figure 6.3.

Figure 6.3 Misc Charge [FREIGHTCHRGS] line Edit window

  1. Modify the Overhead Cost to 5.00 and click OK.

  2. Select the Cost tab of the Rental Reservation Order [ORDER-959] and click the Refresh button to view the Total Cost [240.00], Profit (Margin) [210.00] , and Profit % [47%], as shown in the below Figure 6.4.

Figure 6.4 ORD-959 Rental Reservation Order - Cost tab displaying the modified values

  1. Save and Exit the Rental Reservation Order [ORDER-959].

Scenario 7: Total Cost for Labor

The Cost / Unit and the Overhead Cost can be edited by performing a double-click in the Labor applied on RT Cost, OT Cost, and DT Cost.

Labor RT Cost

Prerequisites

Perform the following the steps:

  1. Select the Maintenance module > Items tab > Labor tab.

  2. Create a Labor Position [LP#1].

  3. Define the Pricing for the Labor Position [LP#1], as shown in Figure 7.0.

Figure7.0 Pricing defined for the Labor Position [LP#1]

  1. Select OK.

  2. Exit the Maintenance module.

Steps

  1. Select the Account module and tag a Company [EVERGREEN AV RENTALS].

  2. Create a Rental Reservation Order [ORDER-964] for 2 days duration.

  3. Select the Search menu > Labor option. The Search Items window is displayed.  

  4. Search and add the Labor Position [LP#1] with Qty as 2 to the Rental Reservation Order [ORDER-964], as shown in Figure 7.1.

Figure7.1 ORD-964 Rental Reservation Order

  1. The Total Cost column displays the total cost as 800.00 for the Labor Position [LP#1].

  2. Total Cost is calculated as the (Cost [350.00] + Overhead Cost [50.00] * Item Qty. [2.00]). The same is described in the following Table 7.0.

Table7.0 Total Cost Calculations

Calculations

Result

Cost [350.00] + Overhead Cost [50.00] * Item Qty. [2.00]

800.00

Total Cost

800.00

The Overhead Cost is applicable only on the Qty. and not on the Duration.

  1. The Profit % column displays as 20.00%  for the Labor Position [LP#1].

  2. The Profit % is calculated as (Charge - Cost / Charge)*100. The same is described in the following Table 7.1.

Table7.1 Profit % Calculations

Calculations

Result

Charge

1000.00

Charge - Cost is 1000.00 - 800.00

200.00

Charge - Cost / Charge is 200.00/1000.00*100

20.00%

Profit %

20.00%

  1. Select the Cost tab of the Rental Reservation Order [ORDER-964] and click the Refresh button to view the Total Cost [800.00], Profit (Margin) [200.00] , and Profit % [20.00%], as shown in the below Figure 7.2.

Figure7.2 ORD-964 Rental Reservation Order - Cost tab

  1. Select the Labor Position [LP#1] line, perform a right-click and select the Edit option. The Labor Cost window with the RT Unit Cost [400.00] is displayed, as shown in Figure 7.3.

Figure7.3 Labor Position [LP#1] - Labor Cost window

  1. Enter the RT Unit Cost as 200.00 and RT Overhead Cost as 25.00 and click OK, as shown in Figure 7.4.

Figure7.4 Labor Position [LP#1] - Labor Cost window with modified RT Unit Cost and RT Overhead Cost

  1. Select the Cost tab of the Rental Reservation Order [ORDER-964] and click the Refresh button to view the Total Cost [450.00], Profit (Margin) [550.00] , and Profit % [55.00%], as shown in the below Figure 7.5.

Figure7.5 ORD-964 Rental Reservation Order - Cost tab displaying the modified values

  1. Save and Exit the Rental Reservation Order [ORDER-964].

Labor OT Cost

Prerequisites

Perform the following the steps:

  1. Select the Maintenance module > Items tab > Labor tab.

  2. Create a Labor Position [LP#2].

  3. Define the Pricing for the Labor Position [LP#2], as shown in Figure 7.6.

Figure7.6 Pricing defined for the Labor Position [LP#2]

  1. Select OK.

  2. Exit the Maintenance module.

Steps

  1. Select the Account module and tag a Company [EVERGREEN AV RENTALS].

  2. Create a Rental Reservation Order [ORDER-967] for 2 days duration.

  3. Select the Search menu > Labor option. The Search Items window is displayed.  

  4. Search and add the Labor Position [LP#2] with Qty as 2 to the Rental Reservation Order [ORDER-967], as shown in Figure 7.7.

Figure7.7 ORD-967 Rental Reservation Order

  1. The Total Cost column displays the total cost as 580.00 for the Labor Position [LP#2].

  2. Total Cost is calculated as the (Cost [250.00] + Overhead Cost [40.00] * Item Qty. [2.00]). The same is described in the following Table 7.2.

Table7.2 Total Cost Calculations

Calculations

Result

Cost [250.00] + Overhead Cost [40.00] * Item Qty. [2.00]

580.00

Total Cost

580.00

The Overhead Cost is applicable only on the Qty. and not on the Duration.

  1. The Profit % column displays as 28.00%  for the Labor Position [LP#1].

  2. The Profit % is calculated as (Charge - Cost / Charge)*100. The same is described in the following Table 7.3.

Table7.3 Profit % Calculations

Calculations

Result

Charge

800.00

Charge - Cost is 800.00 - 580.00

220.00

Charge - Cost / Charge is 220.00/800.00*100

28.00%

Profit %

28.00%

  1. Select the Cost tab of the Rental Reservation Order [ORDER-967] and click the Refresh button to view the Total Cost [580.00], Profit (Margin) [220.00] , and Profit % [28.00%], as shown in the below Figure 7.8.

Figure7.8 ORD-967 Rental Reservation Order - Cost tab

  1. Select the Labor Position [LP#2] line, perform a right-click and select the Edit option. The Labor Cost  window with the OT Unit Cost [290.00] is displayed, as shown in Figure 7.9.

Figure7.9 Labor Position [LP#2] - Labor Cost window

  1. Enter the OT Unit Cost as 200.00 and RT Overhead Cost as 25.00 and click OK, as shown in Figure 7.10.

Figure7.10 Labor Position [LP#2] - Labor Cost window with modified OT Unit Cost and OT Overhead Cost

  1. Select the Cost tab of the Rental Reservation Order [ORDER-967] and click the Refresh button to view the Total Cost [340.00], Profit (Margin) [460.00] , and Profit % [58.00%], as shown in the below Figure 7.11.

Figure7.11 ORD-967 Rental Reservation Order - Cost tab displaying the modified values

  1. Save and Exit the Rental Reservation Order [ORDER-967].

Labor DT Cost

Prerequisites

Perform the following the steps:

  1. Select the Maintenance module > Items tab > Labor tab.

  2. Create a Labor Position [LP#3].

  3. Define the Pricing for the Labor Position [LP#3], as shown in Figure 7.12.

Figure7.12 Pricing defined for the Labor Position [LP#3]

  1. Select OK.

  2. Exit the Maintenance module.

Steps

  1. Select the Account module and tag a Company [EVERGREEN AV RENTALS].

  2. Create a Rental Reservation Order [ORDER-968] for 2 days duration.

  3. Select the Search menu > Labor option. The Search Items window is displayed.  

  4. Search and add the Labor Position [LP#3] with Qty as 2 to the Rental Reservation Order [ORDER-968], as shown in Figure 7.13.

Figure7.13 ORD-968 Rental Reservation Order

  1. The Total Cost column displays the total cost as 640.00 for the Labor Position [LP#3].

  2. Total Cost is calculated as the (Cost [275.00] + Overhead Cost [45.00] * Item Qty. [2.00]). The same is described in the following Table 7.4.

Table7.4 Total Cost Calculations

Calculations

Result

Cost [275.00] + Overhead Cost [45.00] * Item Qty. [2.00]

640.00

Total Cost

640.00

The Overhead Cost is applicable only on the Qty. and not on the Duration.

  1. The Profit % column displays as 28.00%  for the Labor Position [LP#1].

  2. The Profit % is calculated as (Charge - Cost / Charge)*100. The same is described in the following Table 7.5.

Table7.5 Profit % Calculations

Calculations

Result

Charge

750.00

Charge - Cost is 750.00 - 640.00

110.00

Charge - Cost / Charge is 110.00/750.00*100

15.00%

Profit %

15.00%

  1. Select the Cost tab of the Rental Reservation Order [ORDER-968] and click the Refresh button to view the Total Cost [580.00], Profit (Margin) [220.00] , and Profit % [28.00%], as shown in the below Figure 7.14.

Figure7.14 ORD-968 Rental Reservation Order - Cost tab

  1. Select the Labor Position [LP#3] line, perform a right-click and select the Edit option. The Labor Cost  window with the DT Unit Cost [320.00] is displayed, as shown in Figure 7.15.

Figure7.15 Labor Position [LP#3] - Labor Cost window

  1. Enter the OT Unit Cost as 130.00 and RT Overhead Cost as 15.00 and click OK, as shown in Figure 7.16.

Figure7.16 Labor Position [LP#3] - Labor Cost window with modified OT Unit Cost and OT Overhead Cost

  1. Select the Cost tab of the Rental Reservation Order [ORDER-968] and click the Refresh button to view the Total Cost [290.00], Profit (Margin) [460.00] , and Profit % [61.00%], as shown inthe below Figure 7.17.

Figure7.17 ORD-968 Rental Reservation Order - Cost tab displaying the modified values

  1. Save and Exit the Rental Reservation Order [ORDER-968].

  1. If the Multi Currency option in the Configuration module is enabled, the Site Total Cost column is displayed in the Item line and Labor line of the Order. All the Cost related fields can be edited in the Transaction Currency.

  2. The actions mentioned above are applicable for the following types of Orders:

  • Quote

  • Rental Reservation Order

  • Sale Order

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.