In
this age of computer viruses, usually hidden in subversive macros,
major disruptions to LAN and disk performance are minimized. Although,
not using macros makes the design process more difficult (you cannot
sort by one formula) and somewhat larger in disk space requirements.
It does, however, provide a clean, no worry concept to getting accurate
project results that will keep your business in the financial black,
or as in BidPro/TrakPro lingo,
in the green.
BidPro, TrakPro and LaborPro were
designed for any product/service related project. CablePro and ConduitPro are
for designed for cabling/electrical contractors, universities and end-users
who want to "scope" a project.
BidPro was
designed to provide solutions to contractors & end-user with the
following similar questions:
1. |
What
are our costs and how will they affect sell price? |
2. |
How
do we competitively bid a project? |
3. |
We
are under a time constraint, how long will this project take to
complete? |
4. |
We
have overtime and premium time estimated for this job, how do we
address this in the bid sell price? |
5. |
The
customer wants a complete material list of the project. Do we need
to retype all our product information without showing the pricing? |
6. |
Our
warehouse person needs a material list for the project. Can he
have a list without cost and sell prices on it? |
7. |
What
do we forecast to management about our project? |
8. |
The
customer wants additional work done, what labor sell rate do we
quote? |
9. |
We
don’t want to markup all the material at the same percentage, can
we markup each material items individually? |
10. |
The
customer has given us a desired price they want to pay for our
product/service; can we afford to sell it at that price? |
11. |
We
work 4 days per week and 10 hours per day, not the usual 5 day/8hour.
How will this affect the calculated project duration? |
12. |
Our
company wants to sell our product/service for a specific gross
margin, is the associated sell price in the ballpark of other competitors? |
13. |
How
do we track contract versus actual variances for material, labor
and other costs? |
14. |
Did
the estimator define all project costs properly? |
15. |
We
want to buy a tool; can we afford it on this project and still
make our numbers? |
16. |
How
much profit did we make on this project? |
17. |
We
know a similar project will take 5 days to complete; can we set
the labor pool to finish this project in 5 days? |
18. |
The
customer wants digital pictures for a project, which we will need
to buy. How do I charge the customer for just the camera cost and
not markup the item? |
TrakPro was designed
to provide solutions to contractors & end-user with the following
similar questions:
1. |
What
are our costs by category and how will they affect our profit? |
2. |
We
have contract revisions, how will this affect our bottom-line? |
3. |
Our
burden and premium rates have gone up since the bid process, how
do we address this in the actual cost to bid comparison? |
4. |
Can
we see one sheet to easily ascertain project status? |
5. |
How
will our Estimate-to-complete (EMT) affect the current actual and
final costs? |
6. |
We
needed to use an employee (one time) who wasn't bid on the project,
do we need to add him to our database of workers? |
7. |
What
do we forecast to management about our project? |
8. |
How
do we distinguish between regular hour worked, overtime, doubletime
and premium time? |
9. |
Do
you breakdown all workhours (regular, overtime, doubletime and
premium) by category? |
10. |
How
do we track contract versus actual variances for material, labor
and other costs? |
11. |
Did
the estimator define all project costs properly? |
12. |
We
want to buy a tool; can we afford it on this project and still
make our numbers? |
13. |
How
much profit did we make on this project? |
14. |
How
accurately did we forecast costs, profit and labor rates? |
15. |
Management
wants to know what it will take to finish the job. How do we forecast
this and provide an accurate profit margin? |
16. |
Considering
costs-to-date and final costs, how much should we have billed the
customer? |
17. |
What
is our current cash position? |
18. |
The
customer wants a T & M rate for similar projects, what should
we quote? |
19. |
The
customer has paid a specific material dollar amount before with
a competitor, how do we structure our sell price and gross margins
to remain competitive? |
20. |
We
quoted the customer a specific labor rate per hour that is different
than our actual, how do we maintain our profit margin? |
You
can use either package independently of the other. However, most of
the intended efficiencies are gained from the combination of bidding
a project at a specific labor rate, hours, and material cost and then
tracking that contract cost to actual.
LaborPro can
track up to 50 workers by your fiscal calendar. Each worker is identified
by name and all hours worked are tracked to the customer desired workweek.
Customer-set attendance excuses (ill, bereavement, family, tardy, holiday
etc.) are tracked by individual and for overall evaluation.
1. |
How
well did a worker perform to the desired workweek this year? What
were his attendance excuses? |
2. |
What
were the average hours per week of each individual and overall? |
3. |
Who
are my top 5 performers and my worst performer? |
4. |
Is
there one easy chart to ascertain how each worker performed to
my requirements? Yes |
5. |
Can
we include figures on workhours and attendance reasons from prior
years? Yes |
CablePro was
designed for the cabling/electrical contractor. It can also be used
by financial overseers to ascertain project liabilities and estimator
accuracy. End users can plug in their requirements to get a cost and
anticipated contract costs prior to Bid Requests.
1. |
We
have 50 duplex faceplates (V/D), 34 quads (3V,1D), 28 sixplex (2V,2D,2F)
and 10 duplex fiber (10F). What will this costs us to install by
a typical contractor? |
2. |
Our
basic designs needs to have a 20% growth factor at the patch panels
and blocks, can we easily do this? Yes |
3. |
We
have some split voice locations, does CablePro know how to handle
this in the count and costs? Yes |
4. |
We
need a total count of all our faceplates and the hole (slots) counts
as well as the number of available extra slots for future installations,
can CablePro do this? Yes |
5. |
What
if all the cables go to patch panels and not blocks, how to we
handle the panel counts? |
6. |
I
need the exact price of each group of faceplates and the overall
cost of an average faceplate, help? |
7. |
Do
you list the total product count and associated cost/sell price? Yes |
8. |
Can
we add intrinsic items to the list that you do not have listed
on CablePro? Yes |
9. |
CablePro
lists the amount of time to pull six copper cables (4pair - 152')
as 93 minutes, we estimate it takes us 2 hours. Can we change your
baselines? Yes, you can change all baselines |
ConduitPro was
designed for the cabling/electrical contractor and calculates the conduit
size required to fit a certain number of cables (by cable outside diameter
and number of cables). Bend radius and trough cable fill can also be
evaluated.
1. |
How
many cables of a known outside diameter will fit into a standard
EMT conduit? |
2. |
How many cables
of a known outside diameter will fit into a known ID conduit? |
3. |
How many cables
will fit into a conduit that has existing cables? |
4. |
What is the
minimum bend radius of a conduit? |
5. |
How many cable
will fit into a known trough size (length & width) and still
be to code? |
6. |
What are the
maximum cables that will fit in a known trough? |
7. |
What is the
maximum pull strength a cable or multiple cables (i.e., 50-pair
Cat3) |
8. |
What is the
maximum density packing of known cables in a known conduit assuming
no bends? NASA packaging |
9. |
What is the
OD of AWG cable sizes 3/0 to 47? 0.4096" and
0.001397" |
(click
below to see more info & order product)
|