Cost Code/Cost Type Report
JC-1063
Overview
This Extended Solution to the Job Cost module creates a new report (see Specific Purpose
Rule) that details Material Cost and Selling Price for all Cost Types except Labor and
Overhead. Labor and Overhead costs are summarized by regular, overtime and double-time
hours as well as Selling price.
Installation
Before installing this Extended Solution, please verify that the version level(s) printed on the
CD label are the same as the version level(s) of the MAS 90 MAS 200 module(s) you are
using. For further information, please see the Upgrades and Compatibility section below.
Check your Shipping Manifest for a complete list of Extended Solutions shipped.
For detailed installation instructions, please refer to the Sage website at:
http://support.sagesoftware.com/mas/extended_solutions/main.cfm
Installing Your Extended Solutions under Windows
From a CD
If you have the autorun function turned on for your PC, the installation program will start up
automatically. If not, find the autorun.exe file on your CD-ROM drive and double-click it to
start the installation program. Follow the on-screen instructions.
From the Sage FTP site
When your Extended Solution is ready to be downloaded, you will receive an email from
‘[email protected]’ telling you that it is ready. The email will contain the
Customer Name, Cross Reference, a case-sensitive Password, a link via which you can
download your Extended Solution, instructions and a Shipping Manifest. If you have any
problems with this order, please email
[email protected]
and we will assist
you during normal business hours.
Extended Solutions Control Center
Installing any Extended Solution will add an Extended Solutions Control Center to the MAS
90 MAS 200 Library Master Utilities menu. When you open the Control Center, the following
options will be available:
• Extended Solutions Manuals
• Remove Extended Solutions
• Unlock Extended Solutions
• Merge Installation Files
Setup
Once the disk is installed, you will need to access the Job Cost Setup menu option screen.
After the option screens have been displayed, a Setup screen for this Extended Solution will
appear. Check the ‘Enable Extended Solution’ box to activate this Extended Solution (Figure
1). The manual for this Extended Solution, if it has been installed, can be viewed by clicking
the ‘Manual’ button next to the ‘Enable Extended Solution’ check box. It can also be viewed
via the Extended Solutions Control Center (see Installation, above).
Figure 1
Answer the following prompts:
OVERTIME CODE: Specify the Overtime code you wish to use. The Overtime code defines
what the first digit of the cost code should be for the OT Hours column.
DOUBLETIME CODE: Specify the Doubletime code you wish to use. The Doubletime code
defines what the first digit of the cost code should be for the DT Hours column.
LABOR ONLY AND FULL COST CODE SORT: Check this box to allow labor transactions only in
the detail section of the report to print as a break title and sort by the entire cost code, and
to exclude overhead in Labor Selling Price in the summary section.
You should visit this Setup screen after each upgrade or reinstallation of this Extended
Solution.
Operation
If you did not check the ‘Labor Only and Full Cost Code Sort’ box in Setup, the report sorts
by Job Number, Cost Code, Cost Type (except Labor and Overhead), and Transaction Date.
Labor and Overhead Cost Types are handled differently from other Cost Types. Labor is
sorted by the last two digits of the cost code within a job; therefore, it will sort as ‘0XX’.
Due to this special sorting, the cost code sub-totals in the body of the report may not match
the cost code subtotals at the end of the report. Overhead does not print individual line
items but is included in Totals by Cost Type and Totals by Cost Code. Overhead totals are
included with labor totals. Note that labor sorts to the top in each cost code listing.
Figure 2
The report is selected by a range of Job Numbers or a list of up to five Job Numbers, a range
of Job Types and Job Statuses.
The report prints sub-totals for each cost type grouping (see Labor and Overhead exceptions
listed above) and Cost Code (including the labor that sorts with it). The sub-totals will
include Margins (calculated as: 1 minus (Total Cost divided by Total Bill Amount) times 100),
Total Cost and Total Bill Amount.
At the end of the Job the totals by Cost Type then Cost Code will print.
In the Detail section, labor lines will be calculated as follows: Cost Type ‘L’ (Labor) if
a Percentage Markup, calculates Selling Price (Bill Amount), as Cost of Labor times
(1 plus Overhead Rate) times (1 plus Markup Percent).
In the Summary section, the selling price will be calculated as the standard MAS 90
MAS 200 price.
RUN DATE: 11/01/93 San Juan Marina PAGE: 1
SYS DATE: 04/07/93 COST CODE/COST TYPE REPORT TIME: 04:33 PM JOB NUMBER: USN1-000 CLIENT NAME: DAVIDSON IMPORTS
SALES PERSON: 0001 CLIENT ACC. NUMBER: 00-0000001 TAX EXP #: 123456789012345 OVERHEAD RATE: 25.00% 000-000-000 Drydocking
ACTIVITY LABOR REG OT DT SELLING DATE HOURS HOURS HOURS PRICE 04/07/93 000000001 25 JC COMMENT .00 2,334.00 .00 233,400.00 04/07/93 0000001 LABOR, 4/07/93, NT. .00 12.00 .00 1,200.00 04/07/93 0000002 CREW 1 O.T. .00 25.00 .00 1,375.00 04/07/93 0000003 CREW 2 O.T. .00 33.00 .00 1,815.00 04/07/93 0000010 REFERENCE DAVE WILKENS 33.00 .00 .00 1,155.00 04/07/93 0000009 25. JIM DEAVERS .00 .00 12.25 428.75 04/07/93 0000010 REFERENCE DAVE WILKENS .00 .00 12.00 420.00 04/08/93 0000009 37.5 JIM DEAVERS .00 33.00 .00 825.00 ---
Labor SUBTOTAL: 33.00 2,556.00 24.25 245,018.75 ---
ACTIVITY SOURCE / VENDOR / ID MATERIAL COST SELLING DATE PRICE
04/07/93 JC 0000001 72 LBS ALUMINUM 216.00 324.00 ---
Aluminum SUBTOTAL: 216.00 324.00 ---
ACTIVITY SOURCE / VENDOR / ID MATERIAL COST SELLING DATE PRICE
04/07/93 JC 0000001 POWER WASHER 62.50 165.00 --- Equipment SUBTOTAL: 62.50 165.00 ---
ACTIVITY SOURCE / VENDOR / ID MATERIAL COST SELLING DATE PRICE
04/07/93 JC 0000001 MARINE SUPPLIES 300.00 900.00 --- Marine SUBTOTAL: 300.00 900.00 ---
ACTIVITY SOURCE / VENDOR / ID MATERIAL COST SELLING DATE PRICE
04/07/93 JC 0000001 ARC WELDING 243.00 729.00
Figure 3
RUN DATE: 06/25/97 EDWARDSON ELECTRIC COMPANY PAGE: 1 SYS DATE: 06/23/97 COST CODE/COST TYPE REPORT TIME: 07:24 PM JOB NUMBER: TEST CLIENT NAME: Adams & Hanks
SALES PERSON: 0100 CLIENT ACC. NUMBER: 01-A&H TAX EXP #: OVERHEAD RATE: 0.00% 100-010-000 Underground Work - Digging
ACTIVITY LABOR REG OT DT SELLING DATE HOURS HOURS HOURS PRICE 05/05/95 010001005 001069 .00 3.00 .00 150.00 05/05/95 010001015 001070 .00 9.00 .00 450.00 --- Labor SUBTOTAL: 0.00 12.00 0.00 600.00 ---
ACTIVITY SOURCE / VENDOR / ID MATERIAL COST SELLING DATE PRICE 05/22/95 JC 0002024 125.00 131.25 --- Equipment SUBTOTAL: 125.00 131.25 --- SELLING MARGINS COST PRICE ---
