IdealWare Online Users Manual

SP2-07-09 S/P PROCESSING
31571 Sales Order Entry, Misc. Simulated Job Costing

 

PURPOSE

 

The sales order entry program can be used to simulate job costing. A sale generated in the sale order entry program can be considered to be a job with the following components:

  1. Description of the job.
  2. Labour sales$.
  3. Product sales$.
  4. Labour cost$.

 

PROCEDURE

 

In general, you can simulate job costing by the following steps.

  1. Enter a description line paragraph indicating the nature of the work, for example: garage installation.
  2. Enter product sale lines for materials and flag them as "print hold".
  3. Enter service product sale lines for labour and related sales$ and flag them as "print hold".
  4. Enter extra cost product lines for labour and related cost$, entering the supplier code(s) of the supplier(s) performing the labour or installation as well as the cost amount(s).

This results in a sales order with the following characteristics.

  1. The invoice document will print only the description line paragraph and the order totals.
  2. Thus the customer does not see the product and service details and extensions for individual sales$ and cost$.
  3. The picking list and shipping documents will print all of the details for shipping purposes.
  4. The extra cost lines will decrease the gross profit of the sale and the costs will be booked as accruals in the accrued payables system. The G/L is affected by a DEBIT to the expense account, as found on product group, and a CREDIT to accrued payables, for the specified costing supplier(s).

EXAMPLE SIMULATED JOB COSTING ORDER

 

Step 1: Initialize the sale and create the header as for any sale, in this example a charge sale.

 

Example Sales Order Header Screen display:

┌────────────────────────────────────────────────────────────────────────────────┐
│Nov05/07              ***** SALE ORDER HEADER ENTRY *****             TERM: Tc  â”‚
│────────────────────────────────────────────────────────────────────────────────│
│SMAN   SUPER USER (SUPER)     ORDERED DATE Nov05/07                             â”‚
│ORDER# 01-A100005             TO-SHIP DATE Nov05/07                             â”‚
│DOCUM  CHARGE SALE            TO-SHIP TIME                                      â”‚
│TYPE   CHARGE-CURRENT         SHIPPED DATE 00000000                             â”‚
│────────────────────────────────────────────────────────────────────────────────│
│BILL-TO  WESTVAN  SORT WESTVAN          SHIP-TO  WESTVAN  CONTRACT              â”‚
│NAME     WEST VANCOUVER MUNICIPALITY    NAME     WEST VANCOUVER MUNICIPALITY    â”‚
│ADDR1    123 - 17 STREET                ADDR1    123 - 17 STREET                â”‚
│ADDR2                                   ADDR2                                   â”‚
│CITY     WEST VANCO   AREA              CITY     WEST VANCO   AREA              â”‚
│PROV     BC           PS CD V6V 2D3     PROV     BC           PS CD V6V 2D3     â”‚
│PH#      604-926-9876                   PH#      604-926-9876                   â”‚
│FAX#     604-926-9877                   FAX#     604-926-9877                   â”‚
│────────────────────────────────────────────────────────────────────────────────│
│OPER SUPER      CN SHIP PICK UP         CASH TOTAL            SUB-TOT       .00 â”‚
│LEV R PST Y GST Y  SHIPPING INFO N      AMT PAID              P.S.T.        .00 â”‚
│PST CODE           SHIPDOC PRT'D N      AMT OWING             G.S.T.        .00 â”‚
│CONT               INVOICE PRT'D N      DEP REQ'D             DLVRY         .00 â”‚
│PO#  12345         COMPLETE      N HOLD COD METHOD            TOTAL         .00 â”‚
│────────────────────────────────────────────────────────────────────────────────│
│** SELECT MAIN OPTION (F12 FOR OPTIONS); CR TO EXIT SALE: ______                â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘

 

Step 2: Enter the first detail line as an appropriate description. At the PRODUCT field of the first LINE press [F2] to change the LINE TYPE to D (DESCRIPTION). When complete press [F4].

 

0010  INSTALLATION OF OUTSIDE DECK AT CITY

      HALL MATERIALS AND LABOUR

 

Step 3: Enter the first product line.

 

0020  2X6 PRESSURE TREATED DECKING   3,000.00  LIN       7.50  PCE     1,875.00

          250/12

 

Step 4: Enter service product sale lines, for example for labour sales$.

 

0030  INSTALLATION SERVICES              1.00  INST  2,400.00  INSTL   2,400.00

 

Step 5: Enter extra cost product lines, for example for labour cost$, and indicate the supplier code of the supplier that is doing the labour or installation as well as the cost amount.

 

0040  INSTALLATION COSTS                 1.00  INST       .00  INSTL        .00

      PO1: QUICK

      PO2: 1,200.00/INSTL

 

The example job costing order now looks like the following.


Example Sales Order Entry Detail Screen display:

┌────────────────────────────────────────────────────────────────────────────────┐
│Nov05/07              ***** SALE ORDER DETAIL ENTRY *****             TERM: Tc  â”‚
│────────────────────────────────────────────────────────────────────────────────│
│01-A100005  WESTVAN    SUB:  4,275.00  PST: 299.25  GST: 299.25  TOT:  4,873.50 â”‚
│────────────────────────────────────────────────────────────────────────────────│
│LINE  PRODUCT                        QUANTITY  OF       PRICE  PER    EXTENSION â”‚
│────────────────────────────────────────────────────────────────────────────────│
│0010  INSTALLTION OF OUTSIDE DECK AT CITY                                       â”‚
│      HALL MATERIALS AND LABOUR                                                 â”‚
│0020  2X6 PRESSURE TREATED DECKING   3,000.00  LIN       7.50  PCE     1,875.00 â”‚
│       250/12                                                                   â”‚
│0030  INSTALLATION SERVICES              1.00  INSTL 2,400.00  INSTL   2,400.00 â”‚
│0040  INSTALLATION COSTS                 1.00  INSTL      .00  INSTL        .00 â”‚
│      PO1: QUICK                                                                â”‚
│      PO2: 1,200.00/INSTL                                                       â”‚
│0050  _______________                                                           â”‚
│                                                                                â”‚
│                                                                                â”‚
│──────────────────────────< CURRENT LINE INFORMATION >──────────────────────────│
│0050  CODE:INSTALL      TYP:P  DISC:N  PST:Y  GST:Y  SHIP:PU  FROM:01  PRT:N    â”‚
│────────────────────────────────────────────────────────────────────────────────│
│                                                                                â”‚
│────────────────────────────────────────────────────────────────────────────────│
│F2=LINE TYPE, F3=LINE CONTROL, F4=EXIT, F8=EXIT & PRINT, F12=OTHER OPTIONS      â”‚
│ENTER PRODUCT CODE OR ENTER QTY FOLLOWED BY '*' FOLLOWED BY PRODUCT CODE.       â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘

 

The resultant Invoice, Picking List and Order Registers follow.

  



                            I d e a l   C o m p u t e r   G r o u p
                            _______________________________________

                                200, 3680 East Hastings Street
                                    Vancouver B.C., V5K 2A9
                          PHONE: (604) 298-9077  FAX: (604) 298-6377
                              *** CHARGE INVOICE - REPRINT #1 ***
                             (PRINTED: Sat, Nov 06 2007 at 00:00)               PAGE: 1

Bill-to: WESTVAN                           Ship-to: WESTVAN
         WEST VANCOUVER MUNICIPALITY                WEST VANCOUVER MUNICIPALITY
         123 - 17 STREET                            123 - 17 STREET
         WEST VANCOUVER, BC, V6V 2D3                WEST VANCOUVER, BC, V6V 2D3
         604-926-9876                               604-926-9876

-----------------------------------------------------------------------------------------------
Ordered Date:   Fri, Nov 05, 2007    Cust P.O.#: 12345
Invoice Number: 01-A100005           Cust Gst#:                  Ship Via:
Salesperson:    SUPER USER           Cust Pst#:                  Unload:
Company GST#:   11848 5416           Cust Terms: NET
-----------------------------------------------------------------------------------------------
    Description                     Code               Quantity Shipped   Price       Extension
-----------------------------------------------------------------------------------------------

    INSTALLATION OF OUTSIDE DECK AT CITY
    HALL: MATERIALS AND LABOUR
DLY 2X6 PRESSURE TREATED DECKING    DECK                    3,000 LIN      7.50/PCE    1,875.00
        250/12
DLY INSTALLATION SERVICES           INSTALL                     1 INST 2,400.00/INSTL  2,400.00












-----------------------------------------------------------------------------------------------
NO REFUNDS OR EXCHANGES UNLESS ACCOMPANIED BY THIS INVOICE.              SUB-TOTAL:    4,275.00
                                                                         P.S.T.:         299.25
                                                                         G.S.T.:         299.25
CUSTOMER SIGNATURE: _______________________________________              BALANCE DUE:  4,873.50









                            I d e a l   C o m p u t e r   G r o u p
                            _______________________________________

                                200, 3680 East Hastings Street
                                    Vancouver B.C., V5K 2A9
                          PHONE: (604) 298-9077  FAX: (604) 298-6377
                           *** DELIVERY PICKING LIST - ORIGINAL ***
                             (PRINTED: Sun, Nov 07 2007 at 09:07)               PAGE: 1
Bill-to: WESTVAN                           Ship-to: WESTVAN
         WEST VANCOUVER MUNICIPALITY                WEST VANCOUVER MUNICIPALITY
         123 - 17 STREET                            123 - 17 STREET
         WEST VANCOUVER, BC, V6V 2D3                WEST VANCOUVER, BC, V6V 2D3
         604-926-9876                               604-926-9876
-----------------------------------------------------------------------------------------------
Ordered Date:   Sat, Nov 06, 2007    Cust P.O.#: 12345
Invoice Number: 01-A100005           Cust Gst#:                  Ship Via:
Salesperson:    SUPER USER           Cust Pst#:                  Unload:
Company GST#:   11848 5416           Cust Terms:                 Ship Date:    Fri, Nov 05, 1999
                                                                 ___________________________
-----------------------------------------------------------------------------------------------
    Description                     Quantity Ordered   Quantity Shipped     Code
-----------------------------------------------------------------------------------------------

    INSTALLTION OF OUTSIDE DECK AT CITY
    HALL: MATERIALS AND LABOUR
DLY 2X6 PRESSURE TREATED DECKING       3,000 LIN       ____________________ DECK
                                    250/12
DLY INSTALLATION SERVICES                  1 INSTL              1 INSTL     INSTALL












-----------------------------------------------------------------------------------------------

CUSTOMER SIGNATURE: _____________________________________________________________
 (GOODS/RECEIVED)




                                                       Ideal Computer Group
Nov07/07  09:14:10                                                                                                       PAGE: 1
                                             ORDER DETAIL REGISTER - BATCH: 01VO0003
                                 FOR STORE '01' CHARGE SALES, WITH ORDERED DATES OF Sat Nov 06/07
-----------------------------------------------------------------------------------------------------------------------------------
SEQ TP PRODUCT      SH DESCRIPTION                                QTY PER  PRICE PER    TOTAL     COST PER     COST    PROFIT    %
-----------------------------------------------------------------------------------------------------------------------------------
ORDER NO: 01-A100005  CUSTOMER: (WESTVAN,)                                  SALESMAN: SUPER   ORDERED: Nov05/99

010      INSTALLTION OF OUTSIDE DECK AT CITY
         HALL: MATERIALS AND LABOUR
020 P  DECK         01 2X6 PRESSURE TREATED DECKING
             SHIPPED:  250/12                                   3000 LIN    7.50 PCE  1875.00 N   6.15 PCE  1537.50    337.50   99.0
030 P  INSTALL      01 INSTALLATION SERVICES                       1 INS 2400.00 INS  2400.00 N    .00 INS      .00   2400.00  999.0
040 P  INSTALL      01 INSTALLATION COSTS
                       PO1: QUICK
                       PO2: 1,200.00/INSTL                         1 INS     .00 INS      .00 N1   .00 INS  1200.00       .00     .0
                                                                                     --------              --------  --------
                                                                                      4275.00               2737.50   1537.50   35.9
    PT                 PROVINCIAL SALES TAX                                            299.25                   .00
    GT                 G.S.T.                                                          299.25                   .00
                                                                                     --------
              ORDER TOTALS:                                                           4873.50
-----------------------------------------------------------------------------------------------------------------------------------
                                                                                     --------
BATCH TOTALS:                                                                         4873.50
                                                                                     ========



                                                        Ideal Computer Group
Nov07/07  09:14:10                                                                                                         PAGE: 1
                                              ORDER SUMMARY REGISTER - BATCH: 01VO0003
                                  FOR STORE '01' CHARGE SALES, WITH ORDERED DATES OF Sat Nov 06/07
------------------------------------------------------------------------------------------------------------------------------------
ORDER      SHIP-TO  BILL-TO        SUB      PRICE                                         ORDER    PAYMENT   SHIPPED  ORD  CONTS'MAN
NUMBER      CODE     CODE         TOTAL   DISCOUNT    CARTAGE     P.S.T.     G.S.T.       TOTAL   DISCOUNT    DATE   STAT  NO.  CODE
------------------------------------------------------------------------------------------------------------------------------------
01-A100005 WESTVAN  WESTVAN    4,275.00        .00        .00     299.25     299.25    4,873.50        .00  Nov06/99  SO       SUPER
                              ---------  ---------  ---------  ---------  ---------   ---------  ---------
RECORDS: 1                     4,275.00        .00        .00     299.25     299.25    4,873.50        .00
                              =========  =========  =========  =========  =========   =========  =========




                                                        Ideal Computer Group
Nov07/07  09:14:10                                                                                                         PAGE: 1
                                       ORDER GROSS PROFIT SUMMARY REGISTER - BATCH: 01VO0003
                                  FOR STORE '01' CHARGE SALES, WITH ORDERED DATES OF Sat Nov 06/07
------------------------------------------------------------------------------------------------------------------------------------
ORDER      SHIP-TO  SMAN                            LESS       NET        PLUS       LESS       LESS       LESS       NET
NUMBER      CODE    CODE     TOTAL$     SALES$    OTHER$      SALES$      EXCH$      COST$     EXTRA$   PMT DIS$    PROFIT$      GP%
------------------------------------------------------------------------------------------------------------------------------------
01-A100005 WESTVAN  SUPER   4873.50    4275.00        .00    4275.00        .00    1537.50    1200.00        .00    1537.50    35.97
                          ---------  ---------  ---------  ---------  ---------  ---------  ---------  ---------  ---------   ------
RECORDS: 1                  4873.50    4275.00        .00    4275.00        .00    1537.50    1200.00        .00    1537.50    35.97
                          =========  =========  =========  =========  =========  =========  =========  =========  =========   ======



                                             Ideal Computer Group
Nov07/07  09:14:10                                                                                  PAGE: 1
                                ORDER PRODUCT SALES SUMMARY - BATCH: 01VO0003
                       FOR STORE '01' CHARGE SALES, WITH ORDERED DATES OF Sat Nov 06/07
--------------------------------------------------------------------------------------------------------------
PRODUCT                                         STANDARD      SALES       COST
 CODE           DESCRIPTION                     QUANTITY     DOLLARS     DOLLARS      PROFIT      MARGIN
--------------------------------------------------------------------------------------------------------------
INSTALL         INSTALLATION SERVICES               1.00    2,400.00         .00    2,400.00      100.00
INSTALL         INSTALLATION COSTS                  1.00         .00    1,200.00         .00        0.00
DECK            2X6 PRESSURE TREATED DECK 12    3,000.00    1,875.00    1,537.50      337.50       18.00
                                              ----------  ----------  ----------  ----------  ----------
                                                3,002.00    4,275.00    2,737.50    1,537.50       35.97
                                              ==========  ==========  ==========  ==========  ==========




                          Ideal Computer Group
 Nov07/07  09:14:10                                               PAGE: 1
                     GENERAL LEDGER POSTING SUMMARY

 SOURCE CODE: 01           BATCH NUMBER: 0003           G/L DATE: Nov06/07
-------------------------------------------------------------------------
  ACCOUNT     ACCOUNT                                DEBIT          CREDIT
    CODE        NAME                                 AMOUNT         AMOUNT
-------------------------------------------------------------------------

01-01-1200     ACCOUNTS RECEIVABLE                 4,873.50
01-01-1300     INVENTORY                                          1,537.50
01-01-2100     ACCRUED LIABILITIES CONTROL                        1,200.00
01-01-2300     G.S.T. PAYABLE                                       299.25
01-01-2350     P.S.T. PAYABLE                                       299.25
01-01-4000     SALES REVENUE                                      4,275.00
01-01-5000     COST OF GOODS SOLD                  1,537.50
01-01-6525     INSTALLATION COSTS                  1,200.00
                                               ------------   ------------
                                                   7,611.00       7,611.00
                                               ============   ============