Attachment 3 Volume I - Cost Breakout - Tyndall AFB.XLS
XLS spreadsheet 259 KB Posted
- Attached to
- Tyndall AFB Shelf Stocking, Receiving/Storage/Holding Area (RSHA), and Custodial Operations
- Solicitation number
- HDEC08-21-R-0005
- Issued by
-
Defense Commissary Agency
About this file
This document contains a cost proposal template and instructions for responding to a solicitation for shelf stocking, receiving/storage/holding area, and custodial operations services at Tyndall Air Force Base Commissary in Panama City, Florida. The solicitation seeks to furnish all supervision, personnel, equipment, and supplies necessary to perform the specified services in accordance with the stated performance work statement. Offerors must submit their cost proposals using the provided template, which includes worksheets for direct labor costs, supplies and equipment, fringe benefits, overhead rates, and profit margins. The template also includes instructions and named ranges for printing the cost breakdown.
View the file
Other files
Show all 16
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
Cost Breakout
| Attachment 3 |
| HDEC0821R0005 |
| VOLUME I |
| COST BREAKOUT |
| Offerors are required to submit their cost breakout in accordance with provision |
| 52.215-4509, "Proposal Submission," paragraph (b)(4), located in Section L of the |
| solicitation. |
| The tabs below contain worksheets for Shelf Stocking, Custodial, Receiving/Storage Holding |
| Area, Yearly Totals, and 5 Year totals as well as Printing Instructions for these worksheets. |
| The worksheets for Shelf Stocking, Custodial, and Receiving/Storage/Holding Area |
| contain "sample" occupational titles and the applicable minimum wage rates. |
&C
Printing Instructions
| BASIC INSTRUCTIONS | ||||
| This icon and/or disk contains the required forms and formats for submitting proposals in response to the | ||||
| solicitation. Some of the forms have protected formats and cells, however the necessary inputs are "unprotected" | ||||
| and may be changed as needed to adequately reflect your proposal. Formulas are included where appropriate | ||||
| to automatically generate various computations. The offer is ultimately responsible for the accuracy of all calculations. | ||||
| If there are calculation differences between the hard copy and the computer files, the hard copy shall take precedence. | ||||
| PRINTING PARAMETERS | ||||
| In order to print these spreadsheets you must use print ranges and titles as they are described in your | ||||
| software manual. The ranges have been defined and named. The range names are listed below. | ||||
| Range Names | Size | Titles | Orientation | Topics |
| SS_PAGE1 | Fit Columns to Page | B:A1..B:A8 | Portrait | Shelf Stocking Direct Labor, Health & Welfare Sheet |
| SS_PAGE2 | Fit Columns to Page | B:A1..B:A8 | Portrait | Shelf Stocking Holidays & Vacations Sheet |
| SS_PAGE3 | Fit Columns to Page | B:A1..B:A8 | Portrait | Shelf Stocking Fringe Calculations Sheet |
| SS_PAGE4 | Fit Columns to Page | B:I1..B:I19 | Portrait | Shelf Stocking Supplies & Equipment Sheet |
| SS_PAGE5 | Fit Columns to Page | None | Portrait | Shelf Stocking Summary Sheet |
| CS_PAGE1 | Fit Columns to Page | C:A1..C:A8 | Portrait | Custodial Direct Labor, Health & Welfare Sheet |
| CS_PAGE2 | Fit Columns to Page | C:A1..C:A8 | Portrait | Custodial Holidays & Vacations Sheet |
| CS_PAGE3 | Fit Columns to Page | C:A1..C:A8 | Portrait | Custodial Fringe Calculations Sheet |
| CS_PAGE4 | Fit Columns to Page | C:I1..C:I19 | Portrait | Custodial Supplies & Equipment Sheet |
| CS_PAGE5 | Fit Columns to Page | None | Portrait | Custodial Summary Sheet |
| WH_PAGE1 | Fit Columns to Page | D:A1..D:A8 | Portrait | RSH Direct Labor, Health & Welfare Sheet |
| WH_PAGE2 | Fit Columns to Page | D:A1..D:A8 | Portrait | RSH Holidays & Vacations Sheet |
| WH_PAGE3 | Fit Columns to Page | D:A1..D:A8 | Portrait | RSH Fringe Calculations Sheet |
| WH_PAGE4 | Fit Columns to Page | D:I1..D:I19 | Portrait | RSH Supplies & Equipment Sheet |
| WH_PAGE5 | Fit Columns to Page | None | Portrait | RSH Summary Sheet |
| GRANDS | Fit Columns to Page | None | Portrait | Totals of Shelf Stocking , Custodial, and RSHA |
| GRAND_TOTALS | Fit Columns to Page | None | Landscape | 5 year totals of Shelf Stocking , Custodial, and RSHA |
| You may also use the macro "Print1" to print a group of pages. Make the sheet you wish to print active. Run the macro and it will print | ||||
| the group of spreadsheets for you. This macro currently works only in Excel. The macro can also be activated by pressing the Print | ||||
| button on each sheet. |
Shelf Stocking
| SOLICITATION NUMBER: | HDEC0821R0005 | SOLICITATION NUMBER: | HDEC0821R0005 | SOLICITATION NUMBER: | HDEC0821R0005 | ||||||||||||
| COMMISSARY: | Tyndall AFB | COMMISSARY: | Tyndall AFB | COMMISSARY: | Tyndall AFB | ||||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | |||||||||||||||
| Shelf Stocking Operations Work Sheet | Shelf Stocking Operations Work Sheet | Shelf Stocking Operations Work Sheet | |||||||||||||||
| Direct Labor | Contractor Proposed | DOLLAR TOTALS | |||||||||||||||
| Shelf Stocking Supplies & Equipment | ================ | ||||||||||||||||
| WDR | |||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | (The elements listed below are SAMPLES and are not considered | |||||||||||||
| = | = | = | = | = | a requirement of the solicitation.) | ||||||||||||
| Store Worker/FDS | 0 | 13.97 | $0.00 | COST ELEMENT | DOLLARS | ||||||||||||
| Lead Store Worker | 0 | 15.09 | $0.00 | = | = | ||||||||||||
| Project Manager | 0 | 0.00 | $0.00 | Qty. | Unit/ | Extended | ` | DIRECT LABOR | $0.00 | ||||||||
| 0 | 0.00 | $0.00 | Elements | Yearly | Price | Price | HEALTH & WELFARE | $0.00 | |||||||||
| 0 | 0.00 | $0.00 | = | = | = | = | = | = | = | = | |||||||
| 0 | 0.00 | $0.00 | Blades, Carton Cutter | 0 | 0.00 | $0.00 | SUB-TOTAL | $0.00 | |||||||||
| - | - | - | - | Cutter, Carton | 0 | 0.00 | $0.00 | ||||||||||
| TOTALS | 0 | $0 | Dispenser, Tape | 0 | 0.00 | $0.00 | HOLIDAYS, SICK & VACATIONS | $0.00 | |||||||||
| = | = | = | = | Safety Shoes | 0 | 0.00 | $0.00 | HOL, SICK & VAC. HEALTH & WELFARE | $0.00 | ||||||||
| Indirect Labor Hours (Non-Working) | 0 | Tape Masking | 0 | 0.00 | $0.00 | = | = | ||||||||||
| = | Back Brace | 0 | 0.00 | $0.00 | SUB-TOTAL | $0.00 | |||||||||||
| Direct Labor Hours (Productive/Working) | 0 | Cart, Bushel | 0 | 0.00 | $0.00 | ||||||||||||
| = | Cart, Stocking | 0 | 0.00 | $0.00 | FRINGES | $0.00 | |||||||||||
| Pallet Jacks | 0 | 0.00 | $0.00 | ||||||||||||||
| Direct Labor Health Fund & Pension | 0 | 0.00 | $0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | 0 | 0.00 | $0.00 | - | |||||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | $0.00 | SUB-TOTAL | $0.00 | |||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension Rates | 0 | 0.00 | $0.00 | = | ||||||||||
| = | = | = | = | = | 0 | 0.00 | $0.00 | G&A | 0.00% | $0.00 | |||||||
| Store Worker/FDS | 0 | 9.82 | $0.00 | 0 | 0.00 | $0.00 | |||||||||||
| Lead Store Worker | 0 | 9.82 | $0.00 | 0 | 0.00 | $0.00 | PROFIT | 0.00% | $0.00 | ||||||||
| Project Manager | 0 | 9.82 | $0.00 | 0 | 0.00 | $0.00 | |||||||||||
| 0 | 9.82 | $0.00 | 0 | 0.00 | $0.00 | = | = | ||||||||||
| 0 | 9.82 | $0.00 | 0 | 0.00 | $0.00 | GRAND TOTAL | $0.00 | ||||||||||
| 0 | 9.82 | $0.00 | 0 | 0.00 | $0.00 | = | = | = | = | ||||||||
| - | - | - | - | 0 | 0.00 | $0.00 | ANNUAL CASES | 328,500 | |||||||||
| TOTALS | 0 | $0 | 0 | 0.00 | $0.00 | = | = | = | |||||||||
| = | = | = | = | 0 | 0.00 | $0.00 | CASE PRICE | 0.0000 | |||||||||
| Holidays, Sick, and Vacations | 0 | 0.00 | $0.00 | = | = | = | |||||||||||
| 0 | 0.00 | $0.00 | |||||||||||||||
| Holidays/ | 0 | 0.00 | $0.00 | ||||||||||||||
| Sick/ | Sick/Vacations | 0 | 0.00 | $0.00 | NOTE: The G&A percentage should include costs assosited with the Safety Efficiency Award ($75 | ||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | 0 | 0.00 | $0.00 | annually per employee). | ||||||||||
| = | = | = | = | = | 0 | 0.00 | $0.00 | ||||||||||
| Store Worker/FDS | 10 | 0 | $0.00 | ( (Holidays + Vacations) * 8) | 0 | 0.00 | $0.00 | ||||||||||
| Lead Store Worker | 10 | 0 | $0.00 | times Work Hours | = | = | = | = | = | = | |||||||
| Project Manager | 10 | 0 | $0.00 | divided by ( 2080 hours - | TOTALS | 0 | $0.00 | ||||||||||
| 10 | 0 | $0.00 | ( (Holidays + Vacations) * 8) ) | = | = | = | = | = | = | ||||||||
| 10 | 0 | $0.00 | times the hourly rate | ||||||||||||||
| 10 | 0 | $0.00 | in each category | ||||||||||||||
| - | - | - | - | ||||||||||||||
| TOTALS | 60 | $0 | |||||||||||||||
| = | = | = | = | ||||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | |||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | |||||||||||||||||
| Holidays/Sick/ | |||||||||||||||||
| Vacations | Health Fund/ | H&W/Health Fund/ | |||||||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension | ||||||||||||||
| = | = | = | = | = | |||||||||||||
| Store Worker/FDS | 0 | 9.82 | $0.00 | ||||||||||||||
| Lead Store Worker | 0 | 9.82 | $0.00 | ||||||||||||||
| Project Manager | 0 | 9.82 | $0.00 | ||||||||||||||
| 0 | 9.82 | $0.00 | |||||||||||||||
| 0 | 9.82 | $0.00 | |||||||||||||||
| 0 | 9.82 | $0.00 | |||||||||||||||
| - | - | - | - | ||||||||||||||
| TOTALS | 0 | $0.00 | |||||||||||||||
| = | = | = | = | ||||||||||||||
| FRINGE CALCULATIONS | |||||||||||||||||
| COST ELEMENT | DOLLARS | ||||||||||||||||
| = | = | = | = | = | = | ||||||||||||
| DIRECT LABOR | $0.00 | ||||||||||||||||
| DIRECT LABOR HEALTH & WELFARE | $0.00 | ||||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $0.00 | ||||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE | $0.00 | ||||||||||||||||
| - | - | - | - | - | - | ||||||||||||
| SUBTOTAL | $0.00 | ||||||||||||||||
| = | = | = | = | = | = | ||||||||||||
| FICA | X | 7.65% | = | $0.00 | |||||||||||||
| FUTA | X | 0.00% | = | $0.00 | |||||||||||||
| SUTA | X | 0.00% | = | $0.00 | |||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | |||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | |||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | |||||||||||||
| Other | X | 0.00% | = | $0.00 | |||||||||||||
| Other | X | 0.00% | = | $0.00 | |||||||||||||
| - | - | - | - | - | - | ||||||||||||
| TOTAL FRINGES | $0.00 | ||||||||||||||||
| = | = | = | = | = | = |
RSH
| SOLICITATION NUMBER: | HDEC0821R0005 | SOLICITATION NUMBER: | HDEC0821R0005 | SOLICITATION NUMBER: | HDEC0821R0005 | |||||||||||
| COMMISSARY: | Tyndall AFB | COMMISSARY: | Tyndall AFB | COMMISSARY: | Tyndall AFB | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| R/S/H Operations Work Sheet | R/S/H Operations Work Sheet | R/S/H Operations Work Sheet | ||||||||||||||
| Direct Labor | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||
| R/S/H Supplies & Equipment | ================ | |||||||||||||||
| WDR | ||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | (The elements listed below are SAMPLES and are not to be considered | ||||||||||||
| = | = | = | = | = | a requirement of the solicitation.) | |||||||||||
| Forklift Operator | 0 | 17.98 | $0.00 | COST ELEMENT | DOLLARS | |||||||||||
| Lead Forklift Operator | 0 | 19.25 | $0.00 | = | = | |||||||||||
| Project Manager | 0 | 0.00 | $0.00 | Qty. | Unit/ | Extended | DIRECT LABOR | 0.00 | ||||||||
| 0 | 0.00 | $0.00 | Elements | Yearly | Price | Price | HEALTH & WELFARE | 0.00 | ||||||||
| 0 | 0.00 | $0.00 | = | = | = | = | = | = | = | = | ||||||
| 0 | 0.00 | $0.00 | Blades, Carton Cutter | 0 | 0.00 | $0.00 | SUB-TOTAL | 0.00 | ||||||||
| - | - | - | - | Cutter, Carton | 0 | 0.00 | $0.00 | |||||||||
| TOTALS | 0 | $0.00 | Dispenser, Tape | 0 | 0.00 | 0.00 | HOLIDAYS, SICK & VACATIONS | 0.00 | ||||||||
| = | = | = | = | Safety Shoes | 0 | 0.00 | 0.00 | HOL, SICK & VAC. HEALTH & WELFARE | 0.00 | |||||||
| Indirect Labor Hours (Non-Working) | 0 | Tape Masking | 0 | 0.00 | 0.00 | = | = | |||||||||
| = | Back Brace | 0 | 0.00 | 0.00 | SUB-TOTAL | 0.00 | ||||||||||
| Direct Labor Hours (Productive/Working) | 0 | Cart, Bushel | 0 | 0.00 | 0.00 | |||||||||||
| = | Cart, Stocking | 0 | 0.00 | 0.00 | FRINGES | 0.00 | ||||||||||
| Pallet Jacks | 0 | 0.00 | 0.00 | |||||||||||||
| Direct Labor Health Fund & Pension | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | 0.00 | |||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | - | ||||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | 0.00 | SUB-TOTAL | 0.00 | ||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension Rates | 0 | 0.00 | 0.00 | = | |||||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | G&A | 0.00% | 0.00 | ||||||
| Forklift Operator | 0 | 9.82 | $0.00 | 0 | 0.00 | 0.00 | ||||||||||
| Lead Forklift Operator | 0 | 9.82 | $0.00 | 0 | 0.00 | 0.00 | PROFIT | 0.00% | 0.00 | |||||||
| Project Manager | 0 | 9.82 | $0.00 | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 9.82 | $0.00 | 0 | 0.00 | 0.00 | = | = | |||||||||
| 0 | 9.82 | $0.00 | 0 | 0.00 | 0.00 | GRAND TOTAL | 0.00 | |||||||||
| 0 | 9.82 | $0.00 | 0 | 0.00 | 0.00 | = | = | = | = | |||||||
| - | - | - | - | 0 | 0.00 | 0.00 | MO. PRICE | 0.00 | ||||||||
| TOTALS | 0 | $0.00 | 0 | 0.00 | 0.00 | = | = | = | ||||||||
| = | = | = | = | 0 | 0.00 | 0.00 | ||||||||||
| Holidays, Sick, and Vacations | 0 | 0.00 | 0.00 | |||||||||||||
| 0 | 0.00 | 0.00 | NOTE: The G&A percentage should include costs assosited with the Safety Efficiency Award ($75 | |||||||||||||
| Holidays/ | 0 | 0.00 | 0.00 | annually per employee). | ||||||||||||
| Sick/ | Sick/Vacations | 0 | 0.00 | 0.00 | ||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | 0 | 0.00 | 0.00 | ||||||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Forklift Operator | 10 | 0 | $0.00 | ( (Holidays + Vacations) * 8) | 0 | 0.00 | 0.00 | |||||||||
| Lead Forklift Operator | 10 | 0 | $0.00 | times Work Hours | = | = | = | = | = | |||||||
| Project Manager | 10 | 0 | $0.00 | divided by ( 2080 hours - | TOTALS | 0 | $0.00 | |||||||||
| 10 | 0 | $0.00 | ( (Holidays + Vacations) * 8) ) | = | = | = | = | = | = | |||||||
| 10 | 0 | $0.00 | times the hourly rate | |||||||||||||
| 10 | 0 | $0.00 | in each category | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 60 | $0 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | ||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | H&W/Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Forklift Operator | 0 | 9.82 | $0.00 | |||||||||||||
| Lead Forklift Operator | 0 | 9.82 | $0.00 | |||||||||||||
| Project Manager | 0 | 9.82 | $0.00 | |||||||||||||
| 0 | 9.82 | $0.00 | ||||||||||||||
| 0 | 9.82 | $0.00 | ||||||||||||||
| 0 | 9.82 | $0.00 | ||||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.00 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR | $0.00 | |||||||||||||||
| DIRECT LABOR HEALTH & WELFARE | $0.00 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $0.00 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE | $0.00 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $0.00 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $0.00 | ||||||||||||
| FUTA | X | 0.00% | = | $0.00 | ||||||||||||
| SUTA | X | 0.00% | = | $0.00 | ||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | ||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| - | - | - | - | - | - | |||||||||||
| TOTAL FRINGES | $0.00 | |||||||||||||||
| = | = | = | = | = | = |
Custodial
| SOLICITATION NUMBER: | HDEC0821R0005 | SOLICITATION NUMBER: | HDEC0821R0005 | SOLICITATION NUMBER: | HDEC0821R0005 | |||||||||||
| COMMISSARY: | Tyndall AFB | COMMISSARY: | Tyndall AFB | COMMISSARY: | Tyndall AFB | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| Custodial Operations Work Sheet | Custodial Operations Work Sheet | Custodial Operations Work Sheet | ||||||||||||||
| Direct Labor | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||
| Custodial Supplies & Equipment | ================ | |||||||||||||||
| WDR | ||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | (The elements listed below are SAMPLES and are not to be considered | ||||||||||||
| = | = | = | = | = | a requirement of the solicitation.) | |||||||||||
| Custodian | 0 | 13.97 | $0.00 | COST ELEMENT | DOLLARS | |||||||||||
| Lead Custodian | 0 | 15.25 | $0.00 | = | = | |||||||||||
| Project Manager | 0 | 0.00 | $0.00 | Qty. | Unit/ | Extended | DIRECT LABOR | 0.00 | ||||||||
| 0 | 0.00 | $0.00 | Elements | Yearly | Price | Price | HEALTH & WELFARE | 0.00 | ||||||||
| 0 | 0.00 | $0.00 | = | = | = | = | = | = | = | = | ||||||
| 0 | 0.00 | $0.00 | Bowl, Cleaner | 0 | 0.00 | $0.00 | SUB-TOTAL | 0.00 | ||||||||
| - | - | - | - | Cartridges | 0 | 0.00 | $0.00 | |||||||||
| TOTALS | 0 | $0.00 | Cleaner, Carpet | 0 | 0.00 | 0.00 | HOLIDAYS, SICK & VACATIONS | 0.00 | ||||||||
| = | = | = | = | Cleaner, Compound | 0 | 0.00 | 0.00 | HOL, SICK & VAC. HEALTH & WELFARE | 0.00 | |||||||
| Indirect Labor Hours (Non-Working) | 0 | Cleaner, Glass | 0 | 0.00 | 0.00 | = | = | |||||||||
| = | Cleaner, Neutral | 0 | 0.00 | 0.00 | SUB-TOTAL | 0.00 | ||||||||||
| Direct Labor Hours (Productive/Working) | 0 | Disinfectant | 0 | 0.00 | 0.00 | |||||||||||
| = | Dust Cloths | 0 | 0.00 | 0.00 | FRINGES | 0.00 | ||||||||||
| Dust Mop Heads | 0 | 0.00 | 0.00 | |||||||||||||
| Direct Labor Health Fund & Pension | Floor Finish | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | 0.00 | ||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | Floor Sealer | 0 | 0.00 | 0.00 | - | |||||||||||
| Health Fund/ | Health Fund/ | Floor Stripper | 0 | 0.00 | 0.00 | SUB-TOTAL | 0.00 | |||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension Rates | Gloves | 0 | 0.00 | 0.00 | = | ||||||||
| = | = | = | = | = | Gloves, Latex | 0 | 0.00 | 0.00 | G&A | 0.00% | 0.00 | |||||
| Custodian | 0 | 9.82 | $0.00 | Kintowel Wiper | 0 | 0.00 | 0.00 | |||||||||
| Lead Custodian | 0 | 9.82 | $0.00 | LiquidLive | 0 | 0.00 | 0.00 | PROFIT | 0.00% | 0.00 | ||||||
| Project Manager | 0 | 9.82 | $0.00 | Masks | 0 | 0.00 | 0.00 | |||||||||
| 0 | 9.82 | $0.00 | Mop Head, Wet | 0 | 0.00 | 0.00 | = | = | ||||||||
| 0 | 9.82 | $0.00 | Neutralizer | 0 | 0.00 | 0.00 | GRAND TOTAL | 0.00 | ||||||||
| 0 | 9.82 | $0.00 | Pads, Aqua 27" | 0 | 0.00 | 0.00 | = | = | = | = | ||||||
| - | - | - | - | Pads, Buffing | 0 | 0.00 | 0.00 | MONTHLY PRICE | 0.00 | |||||||
| TOTALS | 0 | $0.00 | Pads, Doodle Bug | 0 | 0.00 | 0.00 | = | = | = | |||||||
| = | = | = | = | Polish, Furniture | 0 | 0.00 | 0.00 | |||||||||
| Holidays, Sick, and Vacations | Polish, Metal | 0 | 0.00 | 0.00 | ||||||||||||
| Propane | 0 | 0.00 | 0.00 | NOTE: The G&A percentage should include costs assosited with the Safety Efficiency Award ($75 | ||||||||||||
| Holidays/ | Rain Suit | 0 | 0.00 | 0.00 | annually per employee). | |||||||||||
| Sick/ | Sick/Vacations | Respirators | 0 | 0.00 | 0.00 | |||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | Retainer | 0 | 0.00 | 0.00 | |||||||||
| = | = | = | = | = | Safety Shoes | 0 | 0.00 | 0.00 | ||||||||
| Custodian | 10 | 0 | $0.00 | ( (Holidays + Vacations) * 8) | Sanitizer, Compound D2 | 0 | 0.00 | 0.00 | ||||||||
| Lead Custodian | 10 | 0 | $0.00 | times Work Hours | Soap, Hand, Liquid | 0 | 0.00 | 0.00 | ||||||||
| Project Manager | 10 | 0 | $0.00 | divided by ( 2080 hours - | Sponges | 0 | 0.00 | 0.00 | ||||||||
| 10 | 0 | $0.00 | ( (Holidays + Vacations) * 8) ) | Spray Bottle | 0 | 0.00 | 0.00 | |||||||||
| 10 | 0 | $0.00 | times the hourly rate | Spray Bottle Trigger | 0 | 0.00 | 0.00 | |||||||||
| 10 | 0 | $0.00 | in each category | Spray Buff | 0 | 0.00 | 0.00 | |||||||||
| - | - | - | - | Toilet Tissue, 96rl | 0 | 0.00 | 0.00 | |||||||||
| TOTALS | 60 | $0 | Towels, Pop-Up | 0 | 0.00 | 0.00 | ||||||||||
| = | = | = | = | Trash Liners, Lg | 0 | 0.00 | 0.00 | |||||||||
| Trash Liners, Sm | 0 | 0.00 | 0.00 | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | Vaccuum Belts | 0 | 0.00 | 0.00 | ||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | Visors | 0 | 0.00 | 0.00 | ||||||||||||
| Holidays/Sick/ | Battery Charger | 0 | 0.00 | 0.00 | ||||||||||||
| Vacations | Health Fund/ | H&W/Health Fund/ | Buffer, High Speed | 0 | 0.00 | 0.00 | ||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension | Burnisher High Speed | 0 | 0.00 | 0.00 | |||||||||
| = | = | = | = | = | Burnisher, 21" Propane | 0 | 0.00 | 0.00 | ||||||||
| Custodian | 0 | 9.82 | $0.00 | Caddy, Maid | 0 | 0.00 | 0.00 | |||||||||
| Lead Custodian | 0 | 9.82 | $0.00 | Carpet Extractor | 0 | 0.00 | 0.00 | |||||||||
| Project Manager | 0 | 9.82 | $0.00 | Floor Scrubber, Low Speed | 0 | 0.00 | 0.00 | |||||||||
| 0 | 9.82 | $0.00 | Scrubber, 20" | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 9.82 | $0.00 | Scrubber, Auto | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 9.82 | $0.00 | Vacuum, Wet/Dry | 0 | 0.00 | 0.00 | ||||||||||
| - | - | - | - | Washer, Pressure | 0 | 0.00 | 0.00 | |||||||||
| TOTALS | 0 | $0.00 | 0 | 0.00 | 0.00 | |||||||||||
| = | = | = | = | 0 | 0.00 | 0.00 | ||||||||||
| = | = | = | = | = | = | |||||||||||
| TOTALS | $0.00 | |||||||||||||||
| FRINGE CALCULATIONS | = | = | = | = | = | = | ||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR | $0.00 | |||||||||||||||
| DIRECT LABOR HEALTH & WELFARE | $0.00 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $0.00 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE | $0.00 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $0.00 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $0.00 | ||||||||||||
| FUTA | X | 0.00% | = | $0.00 | ||||||||||||
| SUTA | X | 0.00% | = | $0.00 | ||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | ||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| - | - | - | - | - | - | |||||||||||
| TOTAL FRINGES | $0.00 | |||||||||||||||
| = | = | = | = | = | = |
Year Totals
| SOLICITATION NUMBER: | HDEC0821R0005 | |
| COMMISSARY: | Tyndall AFB | |
| CONTRACTOR NAME: | ||
| BASE YEAR GRAND TOTALS | ||
| DOLLAR TOTALS | ||
| ================ | ||
| COST ELEMENT | DOLLARS | |
| = | = | |
| DIRECT LABOR | 0.00 | |
| DIRECT LABOR HEALTH & WELFARE | 0.00 | |
| = | = | |
| TOTAL | 0.00 | |
| HOLIDAYS, SICK & VACATIONS | 0.00 | |
| HOL, SICK & VAC. HEALTH & WELFARE | 0.00 | |
| = | = | |
| TOTAL | 0.00 | |
| FRINGE CALCULATIONS | 0.00 | |
| SUPPLIES & EQUIPMENT | 0.00 | |
| SUB-TOTAL | 0.00 | |
| G&A | 0.00 | |
| PROFIT | 0.00 | |
| = | = | |
| GRAND TOTAL | 0.00 | |
| = | = |
5 Yr. Totals
| SOLICITATION NUMBER: | HDEC0821R0005 | |||||
| COMMISSARY: | Tyndall AFB | |||||
| CONTRACTOR NAME: | ||||||
| GRAND TOTALS | ||||||
| BASE YEAR | OPTION 1 | OPTION 2 | OPTION 3 | OPTION 4 | GRAND | |
| COST ELEMENT | DOLLARS | DOLLARS | DOLLARS | DOLLARS | DOLLARS | TOTALS |
| = | = | = | = | = | = | = |
| DIRECT LABOR | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| DIRECT LABOR HEALTH & WELFARE | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| = | = | = | = | = | = | = |
| TOTAL | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| HOLIDAYS, SICK & VACATIONS | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| HOL, SICK & VAC. HEALTH & WELFARE | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| = | = | = | = | = | = | = |
| TOTAL | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FRINGE CALCULATIONS | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| SUPPLIES & EQUIPMENT | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| SUB-TOTAL | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| G&A | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| PROFIT | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| = | = | = | = | = | = | = |
| GRAND TOTAL | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| = | = | = | = | = | = | = |
| SOLICITATION NUMBER: | HDEC0821R0005 | |||||
| COMMISSARY: | Tyndall AFB | |||||
| CONTRACTOR NAME: | ||||||
| ESCALATION FACTORS | ||||||
| OPTION 1 | OPTION 2 | OPTION 3 | OPTION 4 | |||
| COST ELEMENT | DOLLARS | DOLLARS | DOLLARS | DOLLARS | ||
| = | = | = | = | = | = | |
| DIRECT LABOR | 0.00% | 0.00% | 0.00% | 0.00% | ||
| DIRECT LABOR HEALTH & WELFARE | 0.00% | 0.00% | 0.00% | 0.00% | ||
| = | = | = | = | = | = | |
| TOTAL | ||||||
| HOLIDAYS AND VACATIONS | 0.00% | 0.00% | 0.00% | 0.00% | ||
| HOLIDAYS AND VACATIONS. HEALTH & WELFARE | 0.00% | 0.00% | 0.00% | 0.00% | ||
| = | = | = | = | = | = | |
| TOTAL | ||||||
| FRINGE CALCULATIONS | 0.00% | 0.00% | 0.00% | 0.00% | ||
| SUPPLIES & EQUIPMENT | 0.00% | 0.00% | 0.00% | 0.00% | ||
| SUB-TOTAL | ||||||
| G&A | 0.00% | 0.00% | 0.00% | 0.00% | ||
| PROFIT | 0.00% | 0.00% | 0.00% | 0.00% | ||
| = | = | = | = | = | = | |
| GRAND TOTAL | ||||||
| = | = | = | = | = | = |
Store Worker-FDS Wage Rate
| SOLICITATION NUMBER: | HDEC0821R0005 | SOLICITATION NUMBER: | HDEC0821R0005 | SOLICITATION NUMBER: | HDEC0821R0005 | |||||||||||
| COMMISSARY: | Tyndall AFB | COMMISSARY: | Tyndall AFB | COMMISSARY: | Tyndall AFB | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| Store Worker/FDS Loaded Wage Rate Work Sheet | Store Worker/FDS Loaded Wage Rate Work Sheet | Store Worker/FDS Loaded Wage Rate Work Sheet | ||||||||||||||
| Direct Labor | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||
| Shelf Stocking Supplies & Equipment | ================ | |||||||||||||||
| WD | ||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Store Worker/FDS | 1 | 13.97 | $13.97 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $13.97 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $9.82 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| Qty. | Unit/ | Extended | SUB-TOTAL | $23.79 | ||||||||||||
| - | - | - | - | Elements | Yearly | Price | Price | |||||||||
| TOTALS | 1 | $13.97 | = | = | = | = | = | = | HOLIDAYS, SICK & VACATIONS | $0.75 | ||||||
| = | = | = | = | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | HOL, SICK & VAC. HEALTH & WELFARE | $0.39 | |||||||
| Indirect Labor Hours (Non-Working) | are not included in the loaded | 0 | 0.00 | $0.00 | = | = | ||||||||||
| = | rate for Store Worker I | 0 | 0.00 | 0.00 | SUB-TOTAL | $1.14 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | 0 | 0.00 | 0.00 | ||||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.91 | |||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| Direct Labor Health Fund & Pension | 0 | 0.00 | 0.00 | - | ||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $26.84 | |||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension Rates | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Store Worker/FDS | 1 | 9.82 | $9.82 | 0 | 0.00 | 0.00 | PROFIT | 0.00% | $0.00 | |||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | = | = | ||||||||||||
| 0 | 0.00 | 0.00 | GRAND TOTAL | $26.84 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | = | = | = | = | = | = | ||||||||||
| - | - | - | - | TOTALS | $0.00 | |||||||||||
| TOTALS | 1 | $9.82 | = | = | = | = | = | |||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Store Worker/FDS | 10 | 0 | $0.75 | |||||||||||||
| (Work hours divided by ((2080 hours- | ||||||||||||||||
| (Holidays/Sick+ Vacations)*8))) * | ||||||||||||||||
| ((Closed Holidays*8*Hourly rate)+ | ||||||||||||||||
| (Holidays worked*8*Hourly rate* time & half))+ | ||||||||||||||||
| 0 | (Work Hours divided by(2080-((Holidays/Sick+ | |||||||||||||||
| - | - | - | - | Vacations)*8)))*(Vacations *8*Hourly rate) | ||||||||||||
| TOTALS | 10 | $0.75 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | ||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | H&W/Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Store Worker/FDS | 0.04 | 9.82 | $0.39 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.39 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $13.97 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $9.82 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $0.75 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE | $0.39 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $24.93 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $1.91 | ||||||||||||
| FUTA | X | 0.00% | = | $0.00 | ||||||||||||
| SUTA | X | 0.00% | = | $0.00 | ||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | ||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| - | - | - | - | - | - | |||||||||||
| TOTAL FRINGES | $1.91 | |||||||||||||||
| = | = | = | = | = | = |
Lead Store Worker Loaded Wage
| SOLICITATION NUMBER: | HDEC0821R0005 | SOLICITATION NUMBER: | HDEC0821R0005 | SOLICITATION NUMBER: | HDEC0821R0005 | |||||||||||
| COMMISSARY: | Tyndall AFB | COMMISSARY: | Tyndall AFB | COMMISSARY: | Tyndall AFB | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| Lead Store Worker Loaded Wage Rate Work Sheet | Lead Store Worker Loaded Wage Rate Work Sheet | Lead Store Worker Loaded Wage Rate Work Sheet | ||||||||||||||
| Direct Labor | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||
| R/S/H Supplies & Equipment | ================ | |||||||||||||||
| WD | ||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Lead Store Worker | 1 | 15.09 | $15.09 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $15.09 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $9.82 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $24.91 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $15.09 | Elements | Yearly | Price | Price | HOLIDAYS, SICK & VACATIONS | $0.81 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOL, SICK & VAC. HEALTH & WELFARE | $0.39 | |||||
| Indirect Labor Hours (Non-Working) | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | = | = | ||||||||||
| = | are not included in the loaded | 0 | 0.00 | $0.00 | SUB-TOTAL | $1.20 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Forklift Operator | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.57 | |||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| Direct Labor Health Fund & Pension | 0 | 0.00 | 0.00 | - | ||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $27.68 | |||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension Rates | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Lead Store Worker | 1 | 9.82 | $9.82 | 0 | 0.00 | 0.00 | PROFIT | 0.00% | $0.00 | |||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | = | = | ||||||||||||
| 0 | 0.00 | 0.00 | GRAND TOTAL | $27.68 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $9.82 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Lead Store Worker | 10 | 0 | $0.81 | |||||||||||||
| (Work hours divided by ((2080 hours- | ||||||||||||||||
| (Holidays/Sick+ Vacations)*8))) * | ||||||||||||||||
| ((Closed Holidays*8*Hourly rate)+ | ||||||||||||||||
| (Holidays worked*8*Hourly rate* time & half))+ | ||||||||||||||||
| (Work Hours divided by(2080-((Holidays/Sick+ | ||||||||||||||||
| - | - | - | - | Vacations)*8)))*(Vacations *8*Hourly rate) | ||||||||||||
| TOTALS | 10 | $0.81 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | ||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | H&W/Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Lead Store Worker | 0.04 | 9.82 | $0.39 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.39 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $15.09 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $4.22 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $0.81 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE | $0.39 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $20.51 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $1.57 | ||||||||||||
| FUTA | X | 0.00% | = | $0.00 | ||||||||||||
| SUTA | X | 0.00% | = | $0.00 | ||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | ||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| - | - | - | - | - | - | |||||||||||
| TOTAL FRINGES | $1.57 | |||||||||||||||
| = | = | = | = | = | = |
Forklift Operator Loaded Wage
| SOLICITATION NUMBER: | HDEC0821R0005 | SOLICITATION NUMBER: | HDEC0821R0005 | SOLICITATION NUMBER: | HDEC0821R0005 | |||||||||||
| COMMISSARY: | Tyndall AFB | COMMISSARY: | Tyndall AFB | COMMISSARY: | Tyndall AFB | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| Forklift Operator Loaded Wage Rate Work Sheet | Forklift Operator Loaded Wage Rate Work Sheet | Forklift Operator Loaded Wage Rate Work Sheet | ||||||||||||||
| Direct Labor | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||
| R/S/H Supplies & Equipment | ================ | |||||||||||||||
| WD | ||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Forklift Operator | 1 | 17.98 | $17.98 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $17.98 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $9.82 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $27.80 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $17.98 | Elements | Yearly | Price | Price | HOLIDAYS, SICK & VACATIONS | $0.97 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOL, SICK & VAC. HEALTH & WELFARE | $0.39 | |||||
| Indirect Labor Hours (Non-Working) | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | = | = | ||||||||||
| = | are not included in the loaded | 0 | 0.00 | $0.00 | SUB-TOTAL | $1.36 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Forklift Operator | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.80 | |||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| Direct Labor Health Fund & Pension | 0 | 0.00 | 0.00 | - | ||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $30.96 | |||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension Rates | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Forklift Operator | 1 | 9.82 | $9.82 | 0 | 0.00 | 0.00 | PROFIT | 0.00% | $0.00 | |||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | = | = | ||||||||||||
| 0 | 0.00 | 0.00 | GRAND TOTAL | $30.96 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $9.82 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Forklift Operator | 10 | 0 | $0.97 | |||||||||||||
| (Work hours divided by ((2080 hours- | ||||||||||||||||
| (Holidays/Sick+ Vacations)*8))) * | ||||||||||||||||
| ((Closed Holidays*8*Hourly rate)+ | ||||||||||||||||
| (Holidays worked*8*Hourly rate* time & half))+ | ||||||||||||||||
| (Work Hours divided by(2080-((Holidays/Sick+ | ||||||||||||||||
| - | - | - | - | Vacations)*8)))*(Vacations *8*Hourly rate) | ||||||||||||
| TOTALS | 10 | $0.97 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | ||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | H&W/Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Forklift Operator | 0.04 | 9.82 | $0.39 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.39 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $17.98 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $4.22 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $0.97 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE | $0.39 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $23.56 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $1.80 | ||||||||||||
| FUTA | X | 0.00% | = | $0.00 | ||||||||||||
| SUTA | X | 0.00% | = | $0.00 | ||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | ||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| - | - | - | - | - | - | |||||||||||
| TOTAL FRINGES | $1.80 | |||||||||||||||
| = | = | = | = | = | = |
Lead Forklift Op Loaded Wage
| SOLICITATION NUMBER: | HDEC0821R0005 | SOLICITATION NUMBER: | HDEC0821R0005 | SOLICITATION NUMBER: | HDEC0821R0005 | |||||||||||
| COMMISSARY: | Tyndall AFB | COMMISSARY: | Tyndall AFB | COMMISSARY: | Tyndall AFB | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| Forklift Operator Loaded Wage Rate Work Sheet | Forklift Operator Loaded Wage Rate Work Sheet | Forklift Operator Loaded Wage Rate Work Sheet | ||||||||||||||
| Direct Labor | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||
| R/S/H Supplies & Equipment | ================ | |||||||||||||||
| WD | ||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Lead Forklift Operator | 1 | 19.25 | $19.25 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $19.25 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $9.82 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $29.07 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $19.25 | Elements | Yearly | Price | Price | HOLIDAYS, SICK & VACATIONS | $1.04 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOL, SICK & VAC. HEALTH & WELFARE | $0.39 | |||||
| Indirect Labor Hours (Non-Working) | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | = | = | ||||||||||
| = | are not included in the loaded | 0 | 0.00 | $0.00 | SUB-TOTAL | $1.43 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Forklift Operator | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.90 | |||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| Direct Labor Health Fund & Pension | 0 | 0.00 | 0.00 | - | ||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $32.40 | |||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension Rates | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Lead Forklift Operator | 1 | 9.82 | $9.82 | 0 | 0.00 | 0.00 | PROFIT | 0.00% | $0.00 | |||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | = | = | ||||||||||||
| 0 | 0.00 | 0.00 | GRAND TOTAL | $32.40 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $9.82 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Lead Forklift Operator | 10 | 0 | $1.04 | |||||||||||||
| (Work hours divided by ((2080 hours- | ||||||||||||||||
| (Holidays/Sick+ Vacations)*8))) * | ||||||||||||||||
| ((Closed Holidays*8*Hourly rate)+ | ||||||||||||||||
| (Holidays worked*8*Hourly rate* time & half))+ | ||||||||||||||||
| (Work Hours divided by(2080-((Holidays/Sick+ | ||||||||||||||||
| - | - | - | - | Vacations)*8)))*(Vacations *8*Hourly rate) | ||||||||||||
| TOTALS | 10 | $1.04 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | ||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | H&W/Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Lead Forklift Operator | 0.04 | 9.82 | $0.39 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.39 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $19.25 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $4.22 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $1.04 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE | $0.39 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $24.90 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $1.90 | ||||||||||||
| FUTA | X | 0.00% | = | $0.00 | ||||||||||||
| SUTA | X | 0.00% | = | $0.00 | ||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | ||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| - | - | - | - | - | - | |||||||||||
| TOTAL FRINGES | $1.90 | |||||||||||||||
| = | = | = | = | = | = |
Custodian Loaded Wage Rate
| SOLICITATION NUMBER: | HDEC0821R0005 | SOLICITATION NUMBER: | HDEC0821R0005 | SOLICITATION NUMBER: | HDEC0821R0005 | |||||||||||
| COMMISSARY: | Tyndall AFB | COMMISSARY: | Tyndall AFB | COMMISSARY: | Tyndall AFB | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| Custodian Loaded Wage Rate Work Sheet | Custodian Loaded Wage Rate Work Sheet | Custodian Loaded Wage Rate Work Sheet | ||||||||||||||
| Direct Labor | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||
| Custodial Supplies & Equipment | ================ | |||||||||||||||
| WD | ||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Custodian | 1 | 13.97 | $13.97 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $13.97 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $9.82 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $23.79 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $13.97 | Elements | Yearly | Price | Price | HOLIDAYS, SICK & VACATIONS | $0.75 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOL, SICK & VAC. HEALTH & WELFARE | $0.39 | |||||
| Indirect Labor Hours (Non-Working) | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | = | = | ||||||||||
| = | are not included in the loaded | 0 | 0.00 | $0.00 | SUB-TOTAL | $1.14 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Janitor | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.91 | |||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| Direct Labor Health Fund & Pension | 0 | 0.00 | 0.00 | - | ||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $26.84 | |||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension Rates | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Custodian | 1 | 9.82 | $9.82 | 0 | 0.00 | 0.00 | PROFIT | 0.00% | $0.00 | |||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | = | = | ||||||||||||
| 0 | 0.00 | 0.00 | GRAND TOTAL | $26.84 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $9.82 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Custodian | 10 | 0 | $0.75 | |||||||||||||
| (Work hours divided by ((2080 hours- | ||||||||||||||||
| (Holidays/Sick+ Vacations)*8))) * | ||||||||||||||||
| ((Closed Holidays*8*Hourly rate)+ | ||||||||||||||||
| (Holidays worked*8*Hourly rate* time & half))+ | ||||||||||||||||
| (Work Hours divided by(2080-((Holidays/Sick+ | ||||||||||||||||
| - | - | - | - | Vacations)*8)))*(Vacations *8*Hourly rate) | ||||||||||||
| TOTALS | 10 | $0.75 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | ||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | H&W/Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Custodian | 0.04 | 9.82 | $0.39 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.39 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $13.97 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $9.82 | |||||||||||||||
| HOLIDAYS/SICK/VACATION | $0.75 | |||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0.39 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $24.93 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $1.91 | ||||||||||||
| FUTA | X | 0.00% | = | $0.00 | ||||||||||||
| SUTA | X | 0.00% | = | $0.00 | ||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | ||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| - | - | - | - | - | - | |||||||||||
| TOTAL FRINGES | $1.91 | |||||||||||||||
| = | = | = | = | = | = |
Lead Custodian Loaded Wage
| SOLICITATION NUMBER: | HDEC0821R0005 | SOLICITATION NUMBER: | HDEC0821R0005 | SOLICITATION NUMBER: | HDEC0821R0005 | |||||||||||
| COMMISSARY: | Tyndall AFB | COMMISSARY: | Tyndall AFB | COMMISSARY: | Tyndall AFB | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| Lead Custodian Loaded Wage Rate Work Sheet | Lead Custodian Loaded Wage Rate Work Sheet | Lead Custodian Loaded Wage Rate Work Sheet | ||||||||||||||
| Direct Labor | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||
| Custodial Supplies & Equipment | ================ | |||||||||||||||
| WD | ||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Lead Custodian | 1 | 15.25 | $15.25 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $15.25 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $9.82 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $25.07 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $15.25 | Elements | Yearly | Price | Price | HOLIDAYS, SICK & VACATIONS | $0.82 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOL, SICK & VAC. HEALTH & WELFARE | $0.39 | |||||
| Indirect Labor Hours (Non-Working) | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | = | = | ||||||||||
| = | are not included in the loaded | 0 | 0.00 | $0.00 | SUB-TOTAL | $1.21 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Janitor | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $2.01 | |||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| Direct Labor Health Fund & Pension | 0 | 0.00 | 0.00 | - | ||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $28.29 | |||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension Rates | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Lead Custodian | 1 | 9.82 | $9.82 | 0 | 0.00 | 0.00 | PROFIT | 0.00% | $0.00 | |||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | = | = | ||||||||||||
| 0 | 0.00 | 0.00 | GRAND TOTAL | $28.29 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $9.82 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Lead Custodian | 10 | 0 | $0.82 | |||||||||||||
| (Work hours divided by ((2080 hours- | ||||||||||||||||
| (Holidays/Sick+ Vacations)*8))) * | ||||||||||||||||
| ((Closed Holidays*8*Hourly rate)+ | ||||||||||||||||
| (Holidays worked*8*Hourly rate* time & half))+ | ||||||||||||||||
| (Work Hours divided by(2080-((Holidays/Sick+ | ||||||||||||||||
| - | - | - | - | Vacations)*8)))*(Vacations *8*Hourly rate) | ||||||||||||
| TOTALS | 10 | $0.82 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | ||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | H&W/Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Lead Custodian | 0.04 | 9.82 | $0.39 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.39 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $15.25 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $9.82 | |||||||||||||||
| HOLIDAYS/SICK/VACATION | $0.82 | |||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0.39 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $26.28 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $2.01 | ||||||||||||
| FUTA | X | 0.00% | = | $0.00 | ||||||||||||
| SUTA | X | 0.00% | = | $0.00 | ||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | ||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| - | - | - | - | - | - | |||||||||||
| TOTAL FRINGES | $2.01 | |||||||||||||||
| = | = | = | = | = | = |
File details come from the government source that posted it. Updated .