Attachment R1 - UltraMod Instructions.pdf
PDF 182 KB Posted
- Attached to
- 2023 Light Duty Vocational Trucks
- Solicitation number
- 47QMCA22R0014
- Issued by
-
GSA Federal Acquisition Service
About this file
This document is a draft solicitation for light duty vocational trucks to be issued by the General Services Administration Federal Acquisition Service. The solicitation seeks proposals for the procurement of various light duty trucks to be awarded in 2023. Offerors must submit proposals through AutoBid by September 12, 2022. Eligible products include trucks below 10,000 pounds gross vehicle weight. The solicitation requires trucks to meet vocational application needs for tasks such as utility services and landscaping. Pricing must be submitted using commercial terms and standard configurations.
View the file
Other files
Show all 45
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
ULTRAMOD
Spreadsheet
CONTENTS: PAGE:
USING ULTRAMOD
INTRODUCTION
Section 1 – IDENTIFICATION INFORMATION
Section 2 – CHASSIS SPECIFICATIONS BEFORE
MODIFICATIONS
Section 3 – NEW WHEELBASE AND/OR
ADDITIONAL AXLE(S)
Section 4 – ADDED COMPONENTS
Section 5 – RESULTS
Section 6 – EXAMPLES ............................................................. 6–15
GLOSSARY .............................................................................. 16–26
ULTRAMOD
Spreadsheet
USING ULTRAMOD. First, make a copy of ULTRAMOD under another name for data entry. Your ULTRAMOD disk should remain a master without being used to make calculations. Copies of the ULTRAMOD spreadsheets could be saved under customers’ names to perform the calculations.
Before data is entered, some of the Cells will contain the message “ERR” or “0.00” or “#VALUE!” or “#NAME?”. That indicates that the Cell is a formula that depends on data from other Cells that has not been entered. As the information is entered into the other Cells, numbers will appear in these Cells.
Print only Cells A2 through F58. Intermediate calculations are performed in Columns G through K (they are necessary for the calculation process, but do not contain output information).
Data is input in the shaded boxes and output is shown at the bottom of the spreadsheet. The two exceptions are the Chassis “HOR–CG”/Cell B28, and Chassis “Weight”/Cell D28. Data is automatically inserted into Cells B28 and D28 from spreadsheet calculations above.
Complete instructions and figure calculations are included in this booklet. Input forms for organizing the necessary information are also enclosed. If you have any problems using ULTRAMOD, call the National Truck Equipment Association’s (NTEA) Technical Services Department at 1-800-441-6832.
Enclosed is the ULTRAMOD spreadsheet, a useful software package for calculating the weight distribution of a truck, includ-ing additional axles or wheelbase modifi-cation. Wheelbase changes can be the result of moving axles or frame modifica-tions. ULTRAMOD’s easy-to-follow steps lead you through the required process for calculating weight distributions based on these measurements. ULTRAMOD allows you to generate necessary engineering data quickly and efficiently and warns of axle and vehicle overloading conditions.
Please note that ULTRAMOD is NOT an independent software package. It relies on spreadsheet programs such as Microsoft Excel. Attempts to run ULTRAMOD without a spreadsheet program will be unsuccessful.
Copies of ULTRAMOD are formatted in Microsoft Excel.
National Truck
Equipment Association
37400 Hills Tech Drive Farmington Hills, MI 48331-3414
1-800-441-NTEA
(248)489-7090 • FAX (248)489-8590
info@ntea.com • www.ntea.com
1ULTRAMOD Spreadsheet
2 ULTRAMOD Spreadsheet
Note: The accuracy of these calculations depends on the
CENTER OF GRAVITY AND WEIGHT DISTRIBUTION
WHEELBASE CHANGES OR AUXILIARY AXLE INSTALLATION
4/23/02
(C) Copyright Toner Associates 2002
A B C D E F
VEHICLE: Front GAWR (lbs.) Rear GAWR (lbs.) GVWR (lbs.)
B4 C4 D4
Chassis Components Before Modification
Original Wheelbase: B7 inches
Cab to Axle/Trunion: B8 inches
Number of Original Rear Axle(s): B9
Front Weight (lbs.) Rear Weight (lbs.) Total Weight (lbs.)
Base Chassis Weights B12 C12 0
New Wheelbase and/or Additional Axle(s)
New Wheelbase, or enter original if not altering (inches) Axle Weight (lbs.)
Desired Axle Load for weight
Proportioning (lbs.)
Gross Axle Weight Rating
(lbs.)
Data for Original Rear Axle(s): B16 C16 D16 E16
Additional Axles Axle Number 1: B19 C19 D19 E19 Axle Number 2: B20 C20 D20 E20 Axle Number 3: B21 C21 D21 E21 Axle Number 4: B22 C22 D22 E22 Axle Number 5: B23 C23 D23 E23
Added Components Component
CHASSIS #VALUE! C28 #VALUE!
A29 B29 C29 D29 A30 B30 C30 D30 A31 B31 C31 D31 A32 B32 C32 D32 A33 B33 C33 D33 A34 B34 C34 D34 A35 B35 C35 D35 A36 B36 C36 D36 A37 B37 C37 D37 A38 B38 C38 D38 A39 B39 C39 D39 A40 B40 C40 D40 A41 B41 C41 D41 A42 B42 C42 D42 A43 B43 C43 D43 A44 B44 C44 D44 A45 B45 C45 D45 A46 B46 C46 D46
DESIRED PAYLOAD B47 C47 D47
Total Weight: #VALUE! #VALUE!
Horizontal CG: #VALUE! inches
Vertical CG: #VALUE! inches
Rear Axles Proportioned for Capacity % of Total Vehicle Weight
Front Weight (lbs.): #VALUE! #VALUE! % Weight on Front: #VALUE!
Total Rear Weight (lbs.): #VALUE! % Weight on All Rear: #VALUE!
Original Rear Axle(s) Wt. (lbs.) Axle 1 Wt. (lbs.) Axle 2 Wt. (lbs.) Axle 3 Wt. (lbs.) Axle 4 Wt. (lbs.) Axle 5 Wt. (lbs.)
#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
#VALUE!
GVWR should not be increased unless an FMVSS 121 analysis is performed.
See instruction manual for additional information.
accuracy of the input data.
A4-A5
#VALUE!
Horizontal CG (inches) Vertical CG (inches) Weight (lbs.)
#VALUE! #VALUE! #VALUE! #VALUE!
Note: The accuracy of these calculations depends on the accuracy of the input data.
The following instructions are broken into five sections, each covering a specific portion of the ULTRAMOD spreadsheet.
Each section explains the necessary data that must be entered for the program to make proper calculations. Three com-pleted figures follow these five sections.
The reference points for all horizontal measurements are the front axle of the chassis. Refer to the diagram at left for an illustration of the reference points. For the chassis, dimensions are positive from the front axle to the rear and negative forward of the front axle. An example of a negative horizontal center of gravity (CG) dimension would be the horizontal CG for a winch mounted on the front bumper. These reference points are used throughout all sections.
The following information must be gathered prior to running
ULTRAMOD:
• Chassis Front Gross Axle Weight Rating (FGAWR)
• Chassis Rear Gross Axle Weight Rating (RGAWR)
• Chassis Gross Vehicle Weight Rating (GVWR)
• Chassis Original Wheelbase
• Chassis Cab to Axle
• Chassis Curb Weight on the
Front Axle
• Chassis Curb Weight on the
Rear Axle
• Component Weights and
Locations (e.g. body, hoist, additional axles, etc.)
• Desired Payload
• Gross Axle Weight Rating
(GAWR), Weight, and Location for the Additional Axles (if additional axles added).
The Worksheet included with this manual can be used to gather and record this necessary information.
Introduction
Truck CA
Truck WB
Truck Cargo CG
3ULTRAMOD Spreadsheet
D
CENTER OF GRAVITY AND WEIGHT DISTRIBUTION
WHEELBASE CHANGES OR AUXILIARY AXLE INSTALLATION
4/16/02
(C) Copyright Toner Associates 2002
A B C E
VEHICLE: Front GAWR (lbs.) Rear GAWR (lbs.) GVWR (lbs.)
B4 C4 D4 GVWR should increased unless an FMVSS 121 analysis is performed.
See instruction manual for additional info
A4-A5
F not be rmation.
IDENTIFICATION INFORMATION. A description of the vehicle or customer name can be entered in Cells A4 and A5. The chassis FGAWR is entered in Cell B4. The chassis RGAWR is entered in Cell C4. The total chassis GVWR is entered in Cell D4. The information in Cells B4 and D4 will be used to determine if either the vehicle FGAWR or GVWR are exceeded.
Warning: If you raise the vehicle GVWR, you are responsible for assuring that the vehicle meets all applicable Federal Motor Vehicle Safety Standards (FMVSS). If you plan on raising the GVWR of a vehicle after adding an additional axle, one of the following should be done:
1) Get a letter from the chassis manufacturer stating the new GVWR with the additional axle added and instruc-tions on how the new axle is to be mounted and added to the braking system, or
2) Retest the vehicle to all applicable FMVSS’s including braking (FMVSS 121 for air braked vehicles, FMVSS 105 for hydraulically braked vehicles) that includes dynamic and parking brake system tests, assuring the vehicle frame strength is sufficient to support the new GVWR and assuming all responsibility as the chassis manufacturer.
Check State, Local and Federal Weight Laws to assure you are not exceeding their maximum vehicle weight restrictions.
Section 1
Section 2
CHASSIS SPECIFICATIONS BEFORE MODIFICATIONS. The vehicle’s original wheelbase measured in inches is entered in Cell B7. The original cab to axle/trunnion (CA/CT) in inches is entered in Cell B8 and the number of original rear axles is entered in Cell B9.
The base chassis weight in pounds is added next. The front base chassis weight for the vehicle is entered in Cell B12. The rear base chassis weight is added in Cell C12. The total base chassis weight is calculated and appears in Cell D12.
D
A B C E
Chassis Components Before Modification
Original Wheelbase: B7 inches
Cab to Axle/Trunion: B8 inches
Number of Original Rear Axle(s): B9
Front Weight (lbs.) Rear Weight (lbs.) Total Weight (lbs.)
Base Chassis Weights B12 C12 0
Note: The accuracy of these calculations depends on the accuracy of the input data.
F
4 ULTRAMOD Spreadsheet
NEW WHEELBASE AND/OR ADDITIONAL AXLE(S). This section is used to change the existing wheel-base and/or add additional axles. Even if the original wheelbase is not changed, the “Data for Original Axle(s)” section must be completed for the spreadsheet to work. First the original wheelbase must be entered in Cell B16 or, if the original wheelbase is being changed, the new wheelbase is entered. Next, the rear axle assembly weight is entered in Cell C16. (Normally a single rear axle will weigh approximately 2,500 lbs. and a tandem axle will weigh approximately 5,000 lbs. Consult the chassis manufacturers’ literature for the actual axle assembly weight.) Next, the desired axle load for weight proportioning is entered in Cell D16 (this is the weight that you want to be carried on the axle/s). Next, the GAWR is entered in Cell E16. This will be used in determining if an axle is overloaded. Note: Do not specify a desired axle load that is greater than the gross axle weight rating.
The next section is for any additional axles you want to add (up to five additional axles can be added). The location of the additional axle (pusher or tag) is measured from the center of the front (steering) axle. The location of Additional Axle Number One is entered in Cell B19. The weight of the additional axle, including suspension, tires and wheels are added in Cell C19. The desired load to be carried on the additional axle is added in Cell D19. The GAWR for the additional axle is added in Cell E19. The additional axle’s GAWR will be based on the lowest rating of the axle, tire and rim, or the suspension components. The GAWR will be used in checking for axle overloading. If more than one axle is added, the steps above are to be repeated for Additional Axle Numbers Two through Five.
Section 3
D
A B C E
New Wheelbase and/or Additional Axle(s)
New Wheelbase, or enter original if not altering (inches)
Weight of Original Rear/Additional Axle(s)
(lbs.)
Desired Axle Load for weight
Proportioning (lbs.)
Gross Axle Weight Rating
(lbs.)
Data for Original Rear Axle(s): B16 C16 D16 E16
Additional Axles Axle Number 1: B19 C19 D19 E19 Axle Number 2: B20 C20 D20 E20 Axle Number 3: B21 C21 D21 E21 Axle Number 4: B22 C22 D22 E22 Axle Number 5: B23 C23 D23 E23
5ULTRAMOD Spreadsheet
ADDED COMPONENTS. All Horizontal CG measurements must be taken from the same reference point, normally the center of the front axle. All Vertical CG measurements must be taken from the same reference point, normally the ground. Horizontal CG information is necessary to successfully calculate the weight distribution.
The Vertical CG information is optional (it typically can be used to compare the chassis manufacturer’s allowable limit for conformity to FMVSS 105 or FMVSS 121).
In this section, the additional equipment that will be installed on the truck chassis is entered. The chassis Horizontal CG and weight are automatically calculated in Cells B28 and D28, respectively, from data previously entered in the spreadsheet. The Vertical CG for the chassis (if used) is added in Cell C28.
Cells A29 through D46 are used for entering the data of other components such as body, bumper, hoists, lift gates, snowplows, winch, etc. Cells A29 through A46 are used for naming the added component. The Horizontal CG for each added component is entered in Cells B29 through B46 with the reference point being the front axle.
Components toward the rear would have a positive dimension while components added in front of the front axle would have a negative dimension (for example, a front mount winch). Cells C29 through C46 are for vertical center of gravity of the added component. Cells D29 through D46 are for the component weights.
Cells A47 through D47 are for payload data. The payload Horizontal CG is entered in Cell B47. The body Horizontal CG can be used for the payload Horizontal CG for water level loading in a uniform body (e.g., dump body, van body, grain body, etc.). The Vertical CG (if desired) is entered in Cell C47. The desired payload weight is entered in Cell D47.
Section 4
D
A B C E
Added Components Component
CHASSIS #VALUE! C28 #VALUE!
A29 B29 C29 D29 A30 B30 C30 D30 A31 B31 C31 D31 A32 B32 C32 D32 A33 B33 C33 D33 A34 B34 C34 D34 A35 B35 C35 D35 A36 B36 C36 D36 A37 B37 C37 D37 A38 B38 C38 D38 A39 B39 C39 D39 A40 B40 C40 D40 A41 B41 C41 D41 A42 B42 C42 D42 A43 B43 C43 D43 A44 B44 C44 D44 A45 B45 C45 D45 A46 B46 C46 D46
DESIRED PAYLOAD B47 C47 D47
Horizontal CG (inches) Vertical CG (inches) Weight (lbs.)
6 ULTRAMOD Spreadsheet
RESULTS. First, the Total Weight for the vehicle and payload (if added) is calculated and displayed in Cell D48.
If the total weight exceeds the vehicle GVWR, a note stating “Warning - Vehicle Overloaded!” will display on the total weight line. Next, the Horizontal CG of the completed vehicle will be displayed in Cell B49. The Vertical CG of the completed vehicle (if data is added) will be displayed in Cell B50.
Next, the Front Weight of the completed vehicle is shown in Cell B52. If the Front GAWR is exceeded, a note stating “Warning - Axle Overloaded!” will be displayed next to the front axle weight.
The percentage of total vehicle weight front and rear is displayed in Cells E52 and E53.
Next, the total rear axle weight for the vehicle is displayed in Cell B53. This weight includes the total weight on the original rear axle/s and the weight on any additional axles that have been added. The rear weight for the original rear axles and any additional axle is displayed in Cells A56 through F56 respectively. If any rear GAWR is exceeded, a note stating “Warning – Axle Overloaded!” will appear below the specific axle.
If any of the Warning notes are displayed, corrective action must be taken. Either a reduction of payload, change of wheelbase, addition of an axle, removal of an added component, or other corrective action must be taken. The National Highway Traffic Safety Administration has noted in an interpretation that vehicle or axle overloading may constitute a safety defect.
Section 5 D
A B C E
Horizontal CG: #VALUE! inches
Vertical CG: #VALUE! inches
Rear Axles Proportioned for Capacity % of Total Vehicle Weight
Front Weight (lbs.): #VALUE! #VALUE! % Weight on Front: #VALUE!
Total Rear Weight (lbs.): #VALUE! % Weight on All Rear: #VALUE!
Original Rear Axle(s) Wt. (lbs.) Axle 1 Wt. (lbs.) Axle 2 Wt. (lbs.) Axle 3 Wt. (lbs.) Axle 4 Wt. (lbs.)
#VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
#VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE!
F
Axle 5 Wt. (lbs.)
#VALUE!
#VALUE!
Total Weight:
Section 6 EXAMPLES. The following examples cover three different body and equipment applications.
Example #1. This example, in two parts, shows a completed weight distribution spreadsheet for a 20’ platform body added to a chassis cab without any changes in wheelbase or additional axles. It demonstrates the programs’ ability to check for overloading of an axle or vehicle. Example 1A shows the front axle in an overloaded condition and Example 1B shows how lowering the payload by 3,000 lbs. (from 12,500 lbs. to 9,500 lbs.) eliminates the overloading on the front axle.
Example #2. This example, in two parts, shows a completed weight distribution spreadsheet for a 20’ van body added to a chassis cab and a 55” wheelbase extension. Example 2A shows the rear axle overloaded with the front axle weight at less than half of its 12,000-lb. FGAWR. Example 2B shows that by lengthening the wheelbase 55”, the rear axle is no longer overloaded and nearly 6,000 lbs. of weight is transferred to the front axle.
Example #3. This example, in four parts, shows a completed weight distribution spreadsheet for a 14 yd. dump body added to a chassis cab, with a lift axle added and the wheelbase changed for proper weight distribution.
Example 3A shows the original rear axle overloaded. Example 3B shows the wheelbase being changed to 217”, with the rear axle still overloaded. Example 3C shows the addition of a 13,000-lb. lift axle with a desired axle load of 10,000 lbs. and a weight of 1,700 lbs. — also, the wheelbase needed to be changed to 224” to accommodate the additional axle, but the total vehicle weight now exceeds the GVWR by 1,490 lbs. Example 3D shows the payload reduced by 1,500 lbs. to prevent the total weight from exceeding the GVWR. The additional axle weight of 1,700 lbs.
required the payload to be reduced by 1,500 lbs.
7ULTRAMOD Spreadsheet
Truck CA
Truck WB
Truck Body CG
260"
186"
317"
197"
54.5"
Driver & Passenger
CG
Example 1A
This example, in two parts, shows a completed weight distribution spreadsheet for a 20’ platform body added to a chassis cab without any changes in wheelbase or additional axles.
It demonstrates the program’s ability to check for overloading of an axle or vehicle. Example 1A shows the front axle in an overloaded condition.
Section 6 continued
D calculations d Note: The acc accuracy of the input data.
CENTER OF GRAVITY AND WEIGHT DISTRIBUTION
WHEELBASE CHANGES OR AUXILIARY AXLE INSTALLATION
5/10/02
(C) Copyright Toner Associates 2002
A B C E
VEHICLE: Front GAWR (lbs.) Rear GAWR (lbs.) GVWR (lbs.)
9,000 17,500 26,000
Chassis Components Before Modification
Original Wheelbase: 260.0 inches
Cab to Axle/Trunion: 186.0 inches
Number of Original Rear Axle(s): 1
Front Weight (lbs.) Rear Weight (lbs.) Total Weight (lbs.)
Base Chassis Weights 5,599 3,770 9,369
New Wheelbase and/or Additional Axle(s)
New Wheelbase, or enter original if not altering (inches)
Weight of Original Rear/Additional Axle(s)
(lbs.)
Desired Axle Load for weight
Proportioning (lbs.)
Gross Axle Weight Rating
(lbs.)
Data for Original Rear Axle(s): 260.0 2,500 17,500 17,500
Additional Axles Axle Number 1:
Axle Number 2:
Axle Number 3:
Axle Number 4:
Axle Number 5:
Added Components Component
CHASSIS 104.6 9,369
Driver/Passenger 54.5 300 20' Flatbed Body 197.0 3,500 Rear Bumper 317.0 320
DESIRED PAYLOAD 197.0 12,500
Total Weight: 25,989
Horizontal CG: 163.5" Vertical CG: 0.0"
Rear Axles Proportioned for Capacity % of Total Vehicle Weight
Front Weight (lbs.): 9,643 Warning-Axle Overload!
% Weight on Front: 37.1%
Total Rear Weight (lbs.): 16,346 % Weight on All Rear: 62.9%
Original Rear Axle(s) Wt. (lbs.) Axle 1 Wt. (lbs.) Axle 2 Wt. (lbs.) Axle 3 Wt. (lbs.) Axle 4 Wt. (lbs.)
16,346 0 0 0 0 e
2003 Ford F-650 Reg Cab 4x2
Horizontal CG
GVWR should not be
121 analysis is performed.
See instruction manual for additional information.
Note: The accuracy of these calculations depends on the accuracy of the input data.
F
Axle 5 Wt. (lbs.)
pends on the increased unless an FMVSS uracy of these
9,000 17,500 26,000 5,599 3,770
2,500 17,500 17,500
54.5
3,500
12,500
B4 Front GAWR: __________________________ lbs.
C4 Rear GAWR: ___________________________ lbs.
D4 GVWR: _______________________________ lbs.
B7 Original WB: ____________________________ in.
B8 Original CA: ____________________________ in.
B9 # of original rear axles: _____________________ B12 Base Chassis Weight (front): _____________ lbs.
C12 Base Chassis Weight (rear): _____________ lbs.
B16 New Chassis WB: _______________________ in.
(same as original if unchanged) C16 Weight of Chassis Rear Axles: ___________ lbs.
D16 Desired Axle Load (rear): _______________ lbs.
E16 GAWR (rear): _________________________ lbs.
B19 Additional Axle #1 WB: _________________ in.
C19 Additional Axle #1 wt: _________________ lbs.
D19 Additional Axle #1 Desired Load: _______ lbs.
E19 Additional Axle #1 GAWR: _____________ lbs.
B20 Additional Axle #2 WB: _________________ in.
C20 Additional Axle #2 wt: _________________ lbs.
D20 Additional Axle #2 Desired Load: _______ lbs.
E20 Additional Axle #2 GAWR: _____________ lbs.
B21 Additional Axle #3 WB: _________________ in.
C21 Additional Axle #3 wt: _________________ lbs.
D21 Additional Axle #3 Desired Load: _______ lbs.
E21 Additional Axle #3 GAWR: _____________ lbs.
B22 Additional Axle #4 WB: _________________ in.
C22 Additional Axle #4 wt: _________________ lbs.
D22 Additional Axle #4 Desired Load: _______ lbs.
E22 Additional Axle #4 GAWR: _____________ lbs.
B23 Additional Axle #5 WB: _________________ in.
C23 Additional Axle #5 wt: _________________ lbs.
D23 Additional Axle #5 Desired Load: ______ lbs.
E23 Additional Axle #5 GAWR: _____________ lbs.
C27 Chassis Vert-GC: _______________________ in.
B28 Added Component Hor-CG: _____________ in.
C28 Added Component Vert-CG: _____________ in.
D28 Added Component wt: _________________ lbs.
B29 Added Component Hor-CG: _____________ in.
C29Added Component Vert-CG: _____________ in.
D29 Added Component wt: _________________ lbs.
B30 Added Component Hor-CG: _____________ in.
C30 Added Component Vert-CG: _____________ in.
D30 Added Component wt: _________________ lbs.
B31 Added Component Hor-CG: _____________ in.
C31 Added Component Vert-CG: _____________ in.
D31 Added Component wt: _________________ lbs.
B32 Added Component Hor-CG: _____________ in.
C32 Added Component Vert-CG: _____________ in.
D32 Added Component wt: _________________ lbs.
B33-45 Added Component Hor-CG: __________ in.
C33-45 Added Component Vert-CG: __________ in.
D33-45 Added Component wt: ______________ lbs.
B46 Payload Hor-CG: _______________________ in.
C46 Payload Vert-CG: _______________________ in.
D46 Payload wt: __________________________ lbs.
8 ULTRAMOD Spreadsheet
9,000 17,500 26,000 5,599 3,770
2,500 17,500 17,500
54.5
3,500
9,500
Truck CA
Truck WB
Truck Body CG
260"
186"
317"
197"
54.5"
Driver & Passenger
CG
Example 1B
This example, in two parts, shows a completed weight distribution spreadsheet for a 20’ platform body added to a chassis cab without any changes in wheelbase or additional axles.
It demonstrates the program’s ability to check for overloading of an axle or vehicle. Example 1B shows how lowering the payload by 3,000 lbs. (from 12,500 lbs.
to 9,500 lbs.) eliminates overloading the front axle.
B4 Front GAWR: __________________________ lbs.
C4 Rear GAWR: ___________________________ lbs.
D4 GVWR: _______________________________ lbs.
B7 Original WB: ____________________________ in.
B8 Original CA: ____________________________ in.
B9 # of original rear axles: _____________________ B12 Base Chassis Weight (front): _____________ lbs.
C12 Base Chassis Weight (rear): _____________ lbs.
B16 New Chassis WB: _______________________ in.
(same as original if unchanged) C16 Weight of Chassis Rear Axles: ___________ lbs.
D16 Desired Axle Load (rear): _______________ lbs.
E16 GAWR (rear): _________________________ lbs.
B19 Additional Axle #1 WB: _________________ in.
C19 Additional Axle #1 wt: _________________ lbs.
D19 Additional Axle #1 Desired Load: _______ lbs.
E19 Additional Axle #1 GAWR: _____________ lbs.
B20 Additional Axle #2 WB: _________________ in.
C20 Additional Axle #2 wt: _________________ lbs.
D20 Additional Axle #2 Desired Load: _______ lbs.
E20 Additional Axle #2 GAWR: _____________ lbs.
B21 Additional Axle #3 WB: _________________ in.
C21 Additional Axle #3 wt: _________________ lbs.
D21 Additional Axle #3 Desired Load: _______ lbs.
E21 Additional Axle #3 GAWR: _____________ lbs.
B22 Additional Axle #4 WB: _________________ in.
C22 Additional Axle #4 wt: _________________ lbs.
D22 Additional Axle #4 Desired Load: _______ lbs.
E22 Additional Axle #4 GAWR: _____________ lbs.
B23 Additional Axle #5 WB: _________________ in.
C23 Additional Axle #5 wt: _________________ lbs.
D23 Additional Axle #5 Desired Load: _______ lbs.
E23 Additional Axle #5 GAWR: _____________ lbs.
C27 Chassis Vert-GC: _______________________ in.
B28 Added Component Hor-CG: _____________ in.
C28 Added Component Vert-CG: _____________ in.
D28 Added Component wt: _________________ lbs.
B29 Added Component Hor-CG: _____________ in.
C29Added Component Vert-CG: _____________ in.
D29 Added Component wt: _________________ lbs.
B30 Added Component Hor-CG: _____________ in.
C30 Added Component Vert-CG: _____________ in.
D30 Added Component wt: _________________ lbs.
B31 Added Component Hor-CG: _____________ in.
C31 Added Component Vert-CG: _____________ in.
D31 Added Component wt: _________________ lbs.
B32 Added Component Hor-CG: _____________ in.
C32 Added Component Vert-CG: _____________ in.
D32 Added Component wt: _________________ lbs.
B33-45 Added Component Hor-CG: __________ in.
C33-45 Added Component Vert-CG: __________ in.
D33-45 Added Component wt: ______________ lbs.
B46 Payload Hor-CG: _______________________ in.
C46 Payload Vert-CG: _______________________ in.
D46 Payload wt: __________________________ lbs.
Section 6 continued
Note: The accuracy of these calculations depends on the
WHEELBASE CHANGES OR AUXILIARY AXLE INSTALLATION
CENTER OF GRAVITY AND WEIGHT DISTRIBUTION 5/10/02
(C) Copyright Toner Associates 2002
A B C D E F
VEHICLE: Front GAWR (lbs.) Rear GAWR (lbs.) GVWR (lbs.)
9,000 17,500 26,000
Chassis Components Before Modification Original Wheelbase: 260.0 inches
Cab to Axle/Trunion: 186.0 inches
Number of Original Rear Axle(s): 1
Front Weight (lbs.) Rear Weight (lbs.) Total Weight (lbs.)
Base Chassis Weights 5,599 3,770 9,369
New Wheelbase and/or Additional Axle(s)
New Wheelbase, or enter original if not altering (inches)
Weight of Original Rear/Additional Axle(s)
(lbs.)
Desired Axle Load for weight
Proportioning (lbs.)
Gross Axle Weight Rating
(lbs.)
Data for Original Rear Axle(s): 260.0 2,500 17,500 17,500
Additional Axles Axle Number 1:
Axle Number 2:
Axle Number 3:
Axle Number 4:
Axle Number 5:
Added Components Component
CHASSIS 104.6 9,369
Driver/Passenger 54.5 300 20' Flatbed Body 197.0 3,500 Rear Bumper 317.0 320
DESIRED PAYLOAD 197.0 9,500
Total Weight: 22,989
Horizontal CG: 159.2" Vertical CG: 0.0"
Rear Axles Proportioned for Capacity % of Total Vehicle Weight
Front Weight (lbs): 8,916 % Weight on Front: 38.8%
Total Rear Weight (lbs): 14,073 % Weight on All Rear: 61.2%
Original Rear Axle(s) Wt. (lbs.) Axle 1 Wt. (lbs.) Axle 2 Wt. (lbs.) Axle 3 Wt. (lbs.) Axle 4 Wt. (lbs.)
14,073 0 0 0 0 0
2003 Ford F-650 Reg Cab 4x2
GVWR should not be increased unless an FMVSS 121 analysis is performed.
See instruction manual for additional information.
accuracy of the input data.
Note: The accuracy of these calculations depends on the accuracy of the input data.
Axle 5 Wt. (lbs.)
9ULTRAMOD Spreadsheet
12,000 21,000 33,000 6,222 3,577
2,500 20,000 21,000
4,000
17,500
Note: The accuracy of these calculations depends on the accuracy of the input data.
increased unless an FMVSS 121 analysis is performed.
See instruction manual for additional information.
CENTER OF GRAVITY AND WEIGHT DISTRIBUTION
WHEELBASE CHANGES OR AUXILIARY AXLE INSTALLATION
5/13/02
(C) Copyright Toner Associates 2002
A B C D E F
VEHICLE: Front GAWR (lbs.) Rear GAWR (lbs.) GVWR (lbs.)
12,000 21,000 33,000
Chassis Components Before Modification
Original Wheelbase: 191.0 inches
Cab to Axle/Trunion: 120.0 inches
Number of Original Rear Axle(s): 1
Front Weight (lbs.) Rear Weight (lbs.) Total Weight (lbs.)
Base Chassis Weights 6,222 3,577 9,799
New Wheelbase and/or Additional Axle(s)
New Wheelbase, or enter original if not altering (inches)
Weight of Original Rear/Additional Axle(s)
(lbs.)
Desired Axle Load for weight
Proportioning (lbs.)
Gross Axle Weight Rating
(lbs.)
Data for Original Rear Axle(s): 191.0 2,500 20,000 21,000
Additional Axles Axle Number 1:
Axle Number 2:
Axle Number 3:
Axle Number 4:
Axle Number 5:
Added Components Component
CHASSIS 69.7 9,799
Driver/Passenger 58.0 300 20' Van Body 194.0 4,000 Rear Bumper 314.0 250
DESIRED PAYLOAD 194.0 17,500
Total Weight: 31,849
Horizontal CG: 155.4" Vertical CG: 0.0"
Rear Axles Proportioned for Capacity % of Total Vehicle Weight
Front Weight (lbs.): 5,932 % Weight on Front: 18.6%
Total Rear Weight (lbs.): 25,917 % Weight on All Rear: 81.4%
Original Rear Axle(s) Wt. (lbs.) Axle 1 Wt. (lbs.) Axle 2 Wt. (lbs.) Axle 3 Wt. (lbs.)
25,917 0 0 0 0 0
Warning-Axle Overload !
GVWR should not be 2003 Kenworth T300 Reg Cab 4x2
Axle 4 Wt. (lbs.) Axle 5 Wt. (lbs.)
This example, in two parts, shows a completed weight distribution spreadsheet for a 20’ van body added to a chassis cab and a 55” wheelbase extension. Example 2A shows the rear axle overloaded with the front axle loaded to less than half of its 12,000-lb. FGAWR prior to extension of the wheelbase.
Example 2A
B4 Front GAWR: __________________________ lbs.
C4 Rear GAWR: ___________________________ lbs.
D4 GVWR: _______________________________ lbs.
B7 Original WB: ____________________________ in.
B8 Original CA: ____________________________ in.
B9 # of original rear axles: _____________________ B12 Base Chassis Weight (front): _____________ lbs.
C12 Base Chassis Weight (rear): _____________ lbs.
B16 New Chassis WB: _______________________ in.
(same as original if unchanged) C16 Weight of Chassis Rear Axles: ___________ lbs.
D16 Desired Axle Load (rear): _______________ lbs.
E16 GAWR (rear): _________________________ lbs.
B19 Additional Axle #1 WB: _________________ in.
C19 Additional Axle #1 wt: _________________ lbs.
D19 Additional Axle #1 Desired Load: _______ lbs.
E19 Additional Axle #1 GAWR: _____________ lbs.
B20 Additional Axle #2 WB: _________________ in.
C20 Additional Axle #2 wt: _________________ lbs.
D20 Additional Axle #2 Desired Load: _______ lbs.
E20 Additional Axle #2 GAWR: _____________ lbs.
B21 Additional Axle #3 WB: _________________ in.
C21 Additional Axle #3 wt: _________________ lbs.
D21 Additional Axle #3 Desired Load: _______ lbs.
E21 Additional Axle #3 GAWR: _____________ lbs.
B22 Additional Axle #4 WB: _________________ in.
C22 Additional Axle #4 wt: _________________ lbs.
D22 Additional Axle #4 Desired Load: _______ lbs.
E22 Additional Axle #4 GAWR: _____________ lbs.
B23 Additional Axle #5 WB: _________________ in.
C23 Additional Axle #5 wt: _________________ lbs.
D23 Additional Axle #5 Desired Load: _______ lbs.
E23 Additional Axle #5 GAWR: _____________ lbs.
C27 Chassis Vert-GC: _______________________ in.
B28 Added Component Hor-CG: _____________ in.
C28 Added Component Vert-CG: _____________ in.
D28 Added Component wt: _________________ lbs.
B29 Added Component Hor-CG: _____________ in.
C29 Added Component Vert-CG: _____________ in.
D29 Added Component wt: _________________ lbs.
B30 Added Component Hor-CG: _____________ in.
C30 Added Component Vert-CG: _____________ in.
D30 Added Component wt: _________________ lbs.
B31 Added Component Hor-CG: _____________ in.
C31 Added Component Vert-CG: _____________ in.
D31 Added Component wt: _________________ lbs.
B32 Added Component Hor-CG: _____________ in.
C32 Added Component Vert-CG: _____________ in.
D32 Added Component wt: _________________ lbs.
B33-45 Added Component Hor-CG: __________ in.
C33-45 Added Component Vert-CG: __________ in.
D33-45 Added Component wt: ______________ lbs.
B46 Payload Hor-CG: _______________________ in.
C46 Payload Vert-CG: _______________________ in.
D46 Payload wt: __________________________ lbs.
Section 6 continued
Truck Body CG 194"
314" Bumper
191" WB
120" CA
58"
Driver & Passenger
CG
10 ULTRAMOD Spreadsheet
12,000 21,000 33,000 6,222 3,577
2,500 20,000 21,000
4,000
17,500
Example 2B
This example, in two parts, shows a completed weight distribution spreadsheet for a 20’ van body added to a chassis cab and a 55” wheelbase extension. Example 2B shows by lengthening the wheelbase 55”, the rear axle is no longer overloaded, and nearly 6,000 lbs. of weight has been transferred to the front axle.
B4 Front GAWR: __________________________ lbs.
C4 Rear GAWR: ___________________________ lbs.
D4 GVWR: _______________________________ lbs.
B7 Original WB: ____________________________ in.
B8 Original CA: ____________________________ in.
B9 # of original rear axles: _____________________ B12 Base Chassis Weight (front): _____________ lbs.
C12 Base Chassis Weight (rear): _____________ lbs.
B16 New Chassis WB: _______________________ in.
(same as original if unchanged) C16 Weight of Chassis Rear Axles: ___________ lbs.
D16 Desired Axle Load (rear): _______________ lbs.
E16 GAWR (rear): _________________________ lbs.
B19 Additional Axle #1 WB: _________________ in.
C19 Additional Axle #1 wt: _________________ lbs.
D19 Additional Axle #1 Desired Load: _______ lbs.
E19 Additional Axle #1 GAWR: _____________ lbs.
B20 Additional Axle #2 WB: _________________ in.
C20 Additional Axle #2 wt: _________________ lbs.
D20 Additional Axle #2 Desired Load: _______ lbs.
E20 Additional Axle #2 GAWR: _____________ lbs.
B21 Additional Axle #3 WB: _________________ in.
C21 Additional Axle #3 wt: _________________ lbs.
D21 Additional Axle #3 Desired Load: _______ lbs.
E21 Additional Axle #3 GAWR: _____________ lbs.
B22 Additional Axle #4 WB: _________________ in.
C22 Additional Axle #4 wt: _________________ lbs.
D22 Additional Axle #4 Desired Load: _______ lbs.
E22 Additional Axle #4 GAWR: _____________ lbs.
B23 Additional Axle #5 WB: _________________ in.
C23 Additional Axle #5 wt: _________________ lbs.
D23 Additional Axle #5 Desired Load: _______ lbs.
E23 Additional Axle #5 GAWR: _____________ lbs.
C27 Chassis Vert-GC: _______________________ in.
B28 Added Component Hor-CG: _____________ in.
C28 Added Component Vert-CG: _____________ in.
D28 Added Component wt: _________________ lbs.
B29 Added Component Hor-CG: _____________ in.
C29 Added Component Vert-CG: _____________ in.
D29 Added Component wt: _________________ lbs.
B30 Added Component Hor-CG: _____________ in.
C30 Added Component Vert-CG: _____________ in.
D30 Added Component wt: _________________ lbs.
B31 Added Component Hor-CG: _____________ in.
C31 Added Component Vert-CG: _____________ in.
D31 Added Component wt: _________________ lbs.
B32 Added Component Hor-CG: _____________ in.
C32 Added Component Vert-CG: _____________ in.
D32 Added Component wt: _________________ lbs.
B33-45 Added Component Hor-CG: __________ in.
C33-45 Added Component Vert-CG: __________ in.
D33-45 Added Component wt: ______________ lbs.
B46 Payload Hor-CG: _______________________ in.
C46 Payload Vert-CG: _______________________ in.
D46 Payload wt: __________________________ lbs.
Section 6 continued
GVWR should not be increased unless an FMVSS 121 analysis is performed.
See instruction manual for additional information.
Note: The accuracy of these calculations depends on the accuracy of the input data.
CENTER OF GRAVITY AND WEIGHT DISTRIBUTION
WHEELBASE CHANGES OR AUXILIARY AXLE INSTALLATION
5/13/02
(C) Copyright Toner Associates 2002
A B C D E F
VEHICLE: Front GAWR (lbs.) Rear GAWR (lbs.) GVWR (lbs.)
12,000 21,000 33,000
Chassis Components Before Modification
Original Wheelbase: 191.0 inches
Cab to Axle/Trunion: 120.0 inches
Number of Original Rear Axle(s): 1
Front Weight (lbs.) Rear Weight (lbs.) Total Weight (lbs.)
Base Chassis Weights 6,222 3,577 9,799
New Wheelbase and/or Additional Axle(s)
New Wheelbase, or enter original if not altering (inches)
Weight of Original Rear/Additional Axle(s)
(lbs.)
Desired Axle Load for weight
Proportioning (lbs.)
Gross Axle Weight Rating
(lbs.)
Data for Original Rear Axle(s): 256.0 2,500 20,000 21,000
Additional Axles Axle Number 1:
Axle Number 2:
Axle Number 3:
Axle Number 4:
Axle Number 5:
Added Components Component
CHASSIS 86.3 9,799
Driver/Passenger 58.0 300 20' Van Body 194.0 4,000 Rear Bumper 314.0 250
DESIRED PAYLOAD 194.0 17,500
Total Weight: 31,849
Horizontal CG: 160.5" Vertical CG: 0.0"
Rear Axles Proportioned for Capacity % of Total Vehicle Weight
Front Weight (lbs.): 11,878 % Weight on Front: 37.3%
Total Rear Weight (lbs.): 19,971 % Weight on All Rear: 62.7%
Original Rear Axle(s) Wt. (lbs.) Axle 1 Wt. (lbs.) Axle 2 Wt. (lbs.) Axle 3 Wt. (lbs.)
19,971 0 0 0 0 0
2003 Kenworth T300 Reg Cab 4x2
Truck Body CG 194"
314" Bumper new WB 256"
58"
Driver &
11ULTRAMOD Spreadsheet
16,000 40,000 56,000 7,116 6,789
5,000 34,000 40,000
6,500
35,000
Note: The accuracy of these calculations depends on the accuracy of the input data.
GVWR should not be increased unless an FMVSS 121 analysis is performed.
See instruction manual for additional information.
CENTER OF GRAVITY AND WEIGHT DISTRIBUTION
WHEELBASE CHANGES OR AUXILIARY AXLE INSTALLATION
5/10/02
(C) Copyright Toner Associates 2002
A B C D E F
VEHICLE: Front GAWR (lbs.) Rear GAWR (lbs.) GVWR (lbs.)
16,000 40,000 56,000
Chassis Components Before Modification
Original Wheelbase: 195.0 inches
Cab to Axle/Trunion: 120.0 inches
Number of Original Rear Axle(s): 2
Front Weight (lbs.) Rear Weight (lbs.) Total Weight (lbs.)
Base Chassis Weights 7,116 6,789 13,905
New Wheelbase and/or Additional Axle(s)
New Wheelbase, or enter original if not altering (inches)
Weight of Original Rear/Additional Axle(s)
(lbs.)
Desired Axle Load for weight
Proportioning (lbs.)
Gross Axle Weight Rating
(lbs.)
Data for Original Rear Axle(s): 195.0 5,000 34,000 40,000
Additional Axles Axle Number 1:
Axle Number 2:
Axle Number 3:
Axle Number 4:
Axle Number 5:
Added Components Component
CHASSIS 95.2 13,905
Driver/Passenger 65.0 300 14 Yd. Dump Body 180.0 6,500 Tarp 75.0 85
DESIRED PAYLOAD 180.0 35,000
Total Weight: 55,790
Horizontal CG: 158.1" Vertical CG: 0.0"
Rear Axles Proportioned for Capacity % of Total Vehicle Weight
Front Weight (lbs.): 10,561 % Weight on Front: 18.9%
Total Rear Weight (lbs.): 45,229 % Weight on All Rear: 81.1%
Original Rear Axle(s) Wt. (lbs.) Axle 1 Wt. (lbs.) Axle 2 Wt. (lbs.) Axle 3 Wt. (lbs.)
45,229 0 0 0 0 0
2003 International 7400 Reg Cab 6x4
Example 3A
B4 Front GAWR: __________________________ lbs.
C4 Rear GAWR: ___________________________ lbs.
D4 GVWR: _______________________________ lbs.
B7 Original WB: ____________________________ in.
B8 Original CA: ____________________________ in.
B9 # of original rear axles: _____________________ B12 Base Chassis Weight (front): _____________ lbs.
C12 Base Chassis Weight (rear): _____________ lbs.
B16 New Chassis WB: _______________________ in.
(same as original if unchanged) C16 Weight of Chassis Rear Axles: ___________ lbs.
D16 Desired Axle Load (rear): _______________ lbs.
E16 GAWR (rear): _________________________ lbs.
B19 Additional Axle #1 WB: _________________ in.
C19 Additional Axle #1 wt: _________________ lbs.
D19 Additional Axle #1 Desired Load: _______ lbs.
E19 Additional Axle #1 GAWR: _____________ lbs.
B20 Additional Axle #2 WB: _________________ in.
C20 Additional Axle #2 wt: _________________ lbs.
D20 Additional Axle #2 Desired Load: _______ lbs.
E20 Additional Axle #2 GAWR: _____________ lbs.
B21 Additional Axle #3 WB: _________________ in.
C21 Additional Axle #3 wt: _________________ lbs.
D21 Additional Axle #3 Desired Load: _______ lbs.
E21 Additional Axle #3 GAWR: _____________ lbs.
B22 Additional Axle #4 WB: _________________ in.
C22 Additional Axle #4 wt: _________________ lbs.
D22 Additional Axle #4 Desired Load: _______ lbs.
E22 Additional Axle #4 GAWR: _____________ lbs.
B23 Additional Axle #5 WB: _________________ in.
C23 Additional Axle #5 wt: _________________ lbs.
D23 Additional Axle #5 Desired Load: _______ lbs.
E23 Additional Axle #5 GAWR: _____________ lbs.
C27 Chassis Vert-GC: _______________________ in.
B28 Added Component Hor-CG: _____________ in.
C28 Added Component Vert-CG: _____________ in.
D28 Added Component wt: _________________ lbs.
B29 Added Component Hor-CG: _____________ in.
C29 Added Component Vert-CG: _____________ in.
D29 Added Component wt: _________________ lbs.
B30 Added Component Hor-CG: _____________ in.
C30 Added Component Vert-CG: _____________ in.
D30 Added Component wt: _________________ lbs.
B31 Added Component Hor-CG: _____________ in.
C31 Added Component Vert-CG: _____________ in.
D31 Added Component wt: _________________ lbs.
B32 Added Component Hor-CG: _____________ in.
C32 Added Component Vert-CG: _____________ in.
D32 Added Component wt: _________________ lbs.
B33-45 Added Component Hor-CG: __________ in.
C33-45 Added Component Vert-CG: __________ in.
D33-45 Added Component wt: ______________ lbs.
B46 Payload Hor-CG: _______________________ in.
C46 Payload Vert-CG: _______________________ in.
D46 Payload wt: __________________________ lbs.
Section 6 continued
Body CG180"
195"WB
120"CA
75" Tarp
65"
Driver & Passenger
CG
This example, in four parts, shows a completed weight distribution spreadsheet for a 14 yd. dump body added to a chassis cab, with a lift axle and a wheelbase change.
Example 3A shows the rear axle overloaded in the vehicle’s original configuration.
12 ULTRAMOD Spreadsheet
40,000 56,000 7,116 6,789
5,000 34,000 40,000
6,500
35,000
GVWR should not be increased unless an FMVSS 121 analysis is performed.
See instruction manual for additional information.
Note: The accuracy of these calculations depends on the accuracy of the input data.
CENTER OF GRAVITY AND WEIGHT DISTRIBUTION
WHEELBASE CHANGES OR AUXILIARY AXLE INSTALLATION
5/10/02
(C) Copyright Toner Associates 2002
A B C D E F
VEHICLE: Front GAWR (lbs.) Rear GAWR (lbs.) GVWR (lbs.)
16,000 40,000 56,000
Chassis Components Before Modification Original Wheelbase: 195.0 inches
Cab to Axle/Trunion: 120.0 inches
Number of Original Rear Axle(s): 2
Front Weight (lbs.) Rear Weight (lbs.) Total Weight (lbs.)
Base Chassis Weights 7,116 6,789 13,905
New Wheelbase and/or Additional Axle(s)
New Wheelbase, or enter original if not altering (inches)
Weight of Original Rear/Additional Axle(s)
(lbs.)
Desired Axle Load for weight
Proportioning (lbs.)
Gross Axle Weight Rating
(lbs.)
Data for Original Rear Axle(s): 217.0 5,000 34,000 40,000
Additional Axles Axle Number 1:
Axle Number 2:
Axle Number 3:
Axle Number 4:
Axle Number 5:
Added Components Component
CHASSIS 103.1 13,905
Driver/Passenger 65.0 300 14 Yd. Dump Body 180.0 6,500 Tarp 75.0 85
DESIRED PAYLOAD 180.0 35,000
Total Weight: 55,790
Horizontal CG: 160.1" Vertical CG: 0.0"
Rear Axles Proportioned for Capacity % of Total Vehicle Weight
Front Weight (lbs.): 14,639 % Weight on Front: 26.2%
Total Rear Weight (lbs.): 41,151 % Weight on All Rear: 73.8%
Original Rear Axle(s) Wt. (lbs.) Axle 1 Wt. (lbs.) Axle 2 Wt. (lbs.) Axle 3 Wt. (lbs.) Axle 4 Wt. (lbs.)
41,151 0 0 0 0 0
Axle 5 Wt. (lbs.)
Example 3B
This example, in four parts, shows a completed weight distribution spreadsheet for a 14 yd. dump body added to a chassis cab, with a lift axle and a wheelbase change.
Example 3B shows the wheelbase changed to 217”, with the rear axle still over-loaded.
Section 6 continued
B4 Front GAWR: __________________________ lbs.
C4 Rear GAWR: ___________________________ lbs.
D4 GVWR: _______________________________ lbs.
B7 Original WB: ____________________________ in.
B8 Original CA: ____________________________ in.
B9 # of original rear axles: _____________________ B12 Base Chassis Weight (front): _____________ lbs.
C12 Base Chassis Weight (rear): _____________ lbs.
B16 New Chassis WB: _______________________ in.
(same as original if unchanged) C16 Weight of Chassis Rear Axles: ___________ lbs.
D16 Desired Axle Load (rear): _______________ lbs.
E16 GAWR (rear): _________________________ lbs.
B19 Additional Axle #1 WB: _________________ in.
C19 Additional Axle #1 wt: _________________ lbs.
D19 Additional Axle #1 Desired Load: _______ lbs.
E19 Additional Axle #1 GAWR: _____________ lbs.
B20 Additional Axle #2 WB: _________________ in.
C20 Additional Axle #2 wt: _________________ lbs.
D20 Additional Axle #2 Desired Load: _______ lbs.
E20 Additional Axle #2 GAWR: _____________ lbs.
B21 Additional Axle #3 WB: _________________ in.
C21 Additional Axle #3 wt: _________________ lbs.
D21 Additional Axle #3 Desired Load: _______ lbs.
E21 Additional Axle #3 GAWR: _____________ lbs.
B22 Additional Axle #4 WB: _________________ in.
C22 Additional Axle #4 wt: _________________ lbs.
D22 Additional Axle #4 Desired Load: _______ lbs.
E22 Additional Axle #4 GAWR: _____________ lbs.
B23 Additional Axle #5 WB: _________________ in.
C23 Additional Axle #5 wt: _________________ lbs.
D23 Additional Axle #5 Desired Load: _______ lbs.
E23 Additional Axle #5 GAWR: _____________ lbs.
C27 Chassis Vert-GC: _______________________ in.
B28 Added Component Hor-CG: _____________ in.
C28 Added Component Vert-CG: _____________ in.
D28 Added Component wt: _________________ lbs.
B29 Added Component Hor-CG: _____________ in.
C29 Added Component Vert-CG: _____________ in.
D29 Added Component wt: _________________ lbs.
B30 Added Component Hor-CG: _____________ in.
C30 Added Component Vert-CG: _____________ in.
D30 Added Component wt: _________________ lbs.
B31 Added Component Hor-CG: _____________ in.
C31 Added Component Vert-CG: _____________ in.
D31 Added Component wt: _________________ lbs.
B32 Added Component Hor-CG: _____________ in.
C32 Added Component Vert-CG: _____________ in.
D32 Added Component wt: _________________ lbs.
B33-45 Added Component Hor-CG: __________ in.
C33-45 Added Component Vert-CG: __________ in.
D33-45 Added Component wt: ______________ lbs.
B46 Payload Hor-CG: _______________________ in.
C46 Payload Vert-CG: _______________________ in.
D46 Payload wt: __________________________ lbs.
Body CG180"
217" new WB
75" Tarp
65"
Driver &
13ULTRAMOD Spreadsheet
40,000 56,000 7,116 6,789
5,000 34,000 40,000 1,700 10,000 13,000
6,500
35,000
Axle 4 Wt. (lbs.) Axle 5 Wt. (lbs.)
0 0
GVWR should not be increased unless an FMVSS 121 analysis is performed.
See instruction manual for additional information.
Note: The accuracy of these calculations depends on the accuracy of the input data.
CENTER OF GRAVITY AND WEIGHT DISTRIBUTION
WHEELBASE CHANGES OR AUXILIARY AXLE INSTALLATION
5/13/02
(C) Copyright Toner Associates 2002
A B C D E F
VEHICLE: Front GAWR (lbs.) Rear GAWR (lbs.) GVWR (lbs.)
16,000 40,000 56,000
Chassis Components Before Modification
Original Wheelbase: 195.0 inches
Cab to Axle/Trunion: 120.0 inches
Number of Original Rear Axle(s): 2
Front Weight (lbs.) Rear Weight (lbs.) Total Weight (lbs.)
Base Chassis Weights 7,116 6,789 13,905
New Wheelbase and/or Additional Axle(s)
New Wheelbase, or enter original if not altering (inches)
Weight of Original Rear/Additional Axle(s)
(lbs.)
Desired Axle Load for weight
Proportioning (lbs.)
Gross Axle Weight Rating
(lbs.)
Data for Original Rear Axle(s): 224.0 5,000 34,000 40,000
Additional Axles Axle Number 1: 170.0 1,700 10,000 13,000 Axle Number 2:
Axle Number 3:
Axle Number 4:
Axle Number 5:
Added Components Component
CHASSIS 112.6 15,605
Driver/Passenger 65.0 300 14 Yd. Dump Body 180.0 6,500 Tarp 75.0 85
DESIRED PAYLOAD 180.0 35,000
Total Weight: 57,490 Warning-Vehicle Overload!
Horizontal CG: 161.0" Vertical CG: 0.0"
Rear Axles Proportioned for Capacity % of Total Vehicle Weight
Front Weight (lbs.): 13,784 % Weight on Front: 24.0%
Total Rear Weight (lbs.): 43,706 % Weight on All Rear: 76.0%
Original Rear Axle(s) Wt. (lbs.) Axle 1 Wt. (lbs.) Axle 2 Wt. (lbs.) Axle 3 Wt. (lbs.)
33,773 9,933 0 0
This example, in four parts, shows a completed weight distribution spreadsheet for a 14
yd. dump body added to a chassis cab, with a lift axle and a wheelbase change. Example 3C shows the addition of a 13,000-lb. lift axle with a desired axle load of 10,000 lbs. and a weight of 1,700 lb. Also the wheelbase needed to be changed to 224” because of the additional axle, but the total vehicle weight now exceeds the GVWR by 1,490 lbs.
Example 3CSection 6 continued
B4 Front GAWR: __________________________ lbs.
C4 Rear GAWR: ___________________________ lbs.
D4 GVWR: _______________________________ lbs.
B7 Original WB: ____________________________ in.
B8 Original CA: ____________________________ in.
B9 # of original rear axles: _____________________ B12 Base Chassis Weight (front): _____________ lbs.
C12 Base Chassis Weight (rear): _____________ lbs.
B16 New Chassis WB: _______________________ in.
(same as original if unchanged) C16 Weight of Chassis Rear Axles: ___________ lbs.
D16 Desired Axle Load (rear): _______________ lbs.
E16 GAWR (rear): _________________________ lbs.
B19 Additional Axle #1 WB: _________________ in.
C19 Additional Axle #1 wt: _________________ lbs.
D19 Additional Axle #1 Desired Load: _______ lbs.
E19 Additional Axle #1 GAWR: _____________ lbs.
B20 Additional Axle #2 WB: _________________ in.
C20 Additional Axle #2 wt: _________________ lbs.
D20 Additional Axle #2 Desired Load: _______ lbs.
E20 Additional Axle #2 GAWR: _____________ lbs.
B21 Additional Axle #3 WB: _________________ in.
C21 Additional Axle #3 wt: _________________ lbs.
D21 Additional Axle #3 Desired Load: _______ lbs.
E21 Additional Axle #3 GAWR: _____________ lbs.
B22 Additional Axle #4 WB: _________________ in.
C22 Additional Axle #4 wt: _________________ lbs.
D22 Additional Axle #4 Desired Load: _______ lbs.
E22 Additional Axle #4 GAWR: _____________ lbs.
B23 Additional Axle #5 WB: _________________ in.
C23 Additional Axle #5 wt: _________________ lbs.
D23 Additional Axle #5 Desired Load: _______ lbs.
E23 Additional Axle #5 GAWR: _____________ lbs.
C27 Chassis Vert-GC: _______________________ in.
B28 Added Component Hor-CG: _____________ in.
C28 Added Component Vert-CG: _____________ in.
D28 Added Component wt: _________________ lbs.
B29 Added Component Hor-CG: _____________ in.
C29 Added Component Vert-CG: _____________ in.
D29 Added Component wt: _________________ lbs.
B30 Added Component Hor-CG: _____________ in.
C30 Added Component Vert-CG: _____________ in.
D30 Added Component wt: _________________ lbs.
B31 Added Component Hor-CG: _____________ in.
C31 Added Component Vert-CG: _____________ in.
D31 Added Component wt: _________________ lbs.
B32 Added Component Hor-CG: _____________ in.
C32 Added Component Vert-CG: _____________ in.
D32 Added Component wt: _________________ lbs.
B33-45 Added Component Hor-CG: __________ in.
C33-45 Added Component Vert-CG: __________ in.
D33-45 Added Component wt: ______________ lbs.
B46 Payload Hor-CG: _______________________ in.
C46 Payload Vert-CG: _______________________ in.
D46 Payload wt: __________________________ lbs.
Body CG180"
224"
170" new WB
Additional Axle
75" Tarp
65"
Driver &
14 ULTRAMOD Spreadsheet
Body CG180"
224"
170" new WB
Additional Axle
75" Tarp
65"
Driver & Passenger
CG
16,000 40,000 56,000 7,116 6,789
5,000 34,000 40,000 1,700 10,000 13,000
6,500
33,500
Example 3D
This example, in four parts, shows a completed weight distribution spreadsheet for a 14 yd.
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .