CablePro Design

CablePro Design

The CablePro is a Microsoft© hosted Excel™ spreadsheet program that will assist anyone interested in pricing horizontal communications cabling. The design sheets list installation parameters that will enable any company to evaluate contractor bids or decide budget parameters for capital appropriation requests. Pricing is based on individual company labor rates and includes installation, termination, test and documentation. Use these customized results to define project budgets or compare contractor bids with CablePro results. Product material quantity, cost, average faceplate cost/sell price, return-on-investment (ROI) and gross profit margin (GPM) are calculated for Voice/Data/Fiber cabling projects.

The CablePro workbook incorporates four (4) topic-planning sheets: Horizontal Parameters, Faceplate Layout, Pricing and Option.

Typical inputs include time to setup/pull copper and fiber cable in a minutes format. Termination and documentation times are also included.

In this manner, CablePro will know that

250-2V (2 voice) cables will take (54 x 250 = 13,500 minutes) 225 hours.

Many installers miss the cost of installing hangers. CablePro will allow you to custom-calculate the the base count and cost easily. If very specific routes are required, simply set the parameters to zero (0) and CablePro will ignore the hanger calculations.

You may also designate the type of voice and data cable. The associated costs of each can be input (in a cost per foot basis) so CablePro will know that 250-2V (152 feet average) will have 76,000 feet of Cat5e cable.

The Faceplate Layout is designed to accommodate all combinations of connectors in a faceplate with up to 6 holes. The user may select voice, data and fiber connectors by simply entering quantities of each configuration. Total material counts for faceplates, jacks, cabling and panels will be calculated.

CablePro Faceplate Sheet Input

CablePro will calculate that you will need (1) 96-fiber jack patch panel, (2) 300-pair voice block and (1) 96-port data patch panel.

CablePro will also provide a count of jacks (or pairs) available above the required quantity to quote adds to the customer.

CablePro - # of Terminations, Jacks available and cable length

The Pricing Sheet can display all 83 combinations of connector configurations and display single item costs, sell price and extended sell price.

CablePro will show the cost and sell price for material and labor. All financial people will like the fact that profit dollars, gross margin and Return-on-Investment (ROI) will help them "flash" sales figures.

Go to typical horizontal cabling example

The Option Sheet can provide additional lines of user information, quantity and pricing that will automatically transfer to the pricing sheet calculations.