Attachment 3 - Volume I - Cost Breakout.xls
XLS spreadsheet 256 KB Posted
- Solicitation number
- HDEC08-21-R-0010
- Issued by
-
Defense Commissary Agency
About this file
This document contains templates and instructions for submitting cost proposals in response to solicitation number HDEC08-21-R-0010 issued by the Defense Commissary Agency. The solicitation seeks shelf stocking, receiving, storage, and custodial operations services at the Fort Bragg North Commissary. The templates include worksheets for direct labor, fringe benefits, supplies and equipment, holidays and vacations, health and welfare, and overhead costs for shelf stockers, forklift operators, and janitors. Instructions are provided on printing the templates according to defined ranges. The templates contain sample occupational titles and wage rates for cost estimation purposes and require contractors to populate them with their proposed pricing.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| HDEC08-21-R-0010.pdf | ||
| Amendment 0005.pdf | ||
| Amendment 0004.pdf | ||
| Amendment 0001.pdf | ||
| Amendment 0003.pdf | ||
| Attachment 4 - Volume II - Technical Capability and Personnel.doc | DOC document | |
| Attachment 2 - Collective Bargaining Agreement (CBA).pdf | ||
| solicitation.pdf | ||
| Attachment 6 - Past Performance Information.doc | DOC document | |
| Attachment 7 - Bereavement Leave Certification Form.doc | DOC document | |
| Attachment 5 - Typical Daily Work Schedule and Direct Labor Summary.xlsx | XLSX spreadsheet | |
| Attachment 1 - Fort Bragg North Commissary PWS dtd 06..8.2021.docx | DOCX document |
Show all 12
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 |
| HDEC0821R0010 |
| 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: | HDEC0821R0010 | SOLICITATION NUMBER: | HDEC0821R0010 | SOLICITATION NUMBER: | HDEC0821R0010 | ||||||||||||
| COMMISSARY: | Fort Bragg North | COMMISSARY: | Fort Bragg North | COMMISSARY: | Fort Bragg North | ||||||||||||
| 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.) | ||||||||||||
| Stocker/FDS | 0 | 19.00 | $0.00 | COST ELEMENT | DOLLARS | ||||||||||||
| Project Manager | 0 | 0.00 | $0.00 | = | = | ||||||||||||
| 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 & Welfare | 0 | 0.00 | $0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA. | 0 | 0.00 | $0.00 | - | |||||||||||||
| H&W/Benefit Fund/ | H&W/Benefit Fund/ | 0 | 0.00 | $0.00 | SUB-TOTAL | $0.00 | |||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | 0 | 0.00 | $0.00 | = | ||||||||||
| = | = | = | = | = | 0 | 0.00 | $0.00 | G&A | 0.00% | $0.00 | |||||||
| Stocker/FDS | 0 | 8.50 | $0.00 | 0 | 0.00 | $0.00 | |||||||||||
| Project Manager | 0 | 8.50 | $0.00 | 0 | 0.00 | $0.00 | PROFIT | 0.00% | $0.00 | ||||||||
| 0 | 8.50 | $0.00 | 0 | 0.00 | $0.00 | ||||||||||||
| 0 | 8.50 | $0.00 | 0 | 0.00 | $0.00 | = | = | ||||||||||
| 0 | 8.50 | $0.00 | 0 | 0.00 | $0.00 | GRAND TOTAL | $0.00 | ||||||||||
| 0 | 8.50 | $0.00 | 0 | 0.00 | $0.00 | = | = | = | = | ||||||||
| - | - | - | - | 0 | 0.00 | $0.00 | ANNUAL CASES | 870,408 | |||||||||
| 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 | |||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | 0 | 0.00 | $0.00 | |||||||||||
| = | = | = | = | = | 0 | 0.00 | $0.00 | ||||||||||
| Stocker/FDS | 10 | 0 | $0.00 | ( (Holidays + Vacations) * 8) | 0 | 0.00 | $0.00 | ||||||||||
| Project Manager | 10 | 0 | $0.00 | times Work Hours | = | = | = | = | = | = | |||||||
| 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 & Welfare | |||||||||||||||||
| NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA. | |||||||||||||||||
| Holidays/Sick/ | |||||||||||||||||
| Vacations | H&W/Benefit Fund/ | H&W/Benefit Fund/ | |||||||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | ||||||||||||||
| = | = | = | = | = | |||||||||||||
| Stocker/FDS | 0 | 8.50 | $0.00 | ||||||||||||||
| Project Manager | 0 | 8.50 | $0.00 | ||||||||||||||
| 0 | 8.50 | $0.00 | |||||||||||||||
| 0 | 8.50 | $0.00 | |||||||||||||||
| 0 | 8.50 | $0.00 | |||||||||||||||
| 0 | 8.50 | $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 | ||||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
RSH
| SOLICITATION NUMBER: | HDEC0821R0010 | SOLICITATION NUMBER: | HDEC0821R0010 | SOLICITATION NUMBER: | HDEC0821R0010 | |||||||||||
| COMMISSARY: | Fort Bragg North | COMMISSARY: | Fort Bragg North | COMMISSARY: | Fort Bragg North | |||||||||||
| 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 | 19.66 | $0.00 | COST ELEMENT | DOLLARS | |||||||||||
| Project Manager | 0 | 0.00 | $0.00 | = | = | |||||||||||
| 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 & Welfare | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | 0.00 | |||||||||||
| NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | - | ||||||||||||
| H&W/Benefit Fund/ | H&W/Benefit Fund/ | 0 | 0.00 | 0.00 | SUB-TOTAL | 0.00 | ||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | 0 | 0.00 | 0.00 | = | |||||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | G&A | 0.00% | 0.00 | ||||||
| Forklift Operator | 0 | 8.50 | $0.00 | 0 | 0.00 | 0.00 | ||||||||||
| Project Manager | 0 | 8.50 | $0.00 | 0 | 0.00 | 0.00 | PROFIT | 0.00% | 0.00 | |||||||
| 0 | 8.50 | $0.00 | 0 | 0.00 | 0.00 | |||||||||||
| 0 | 8.50 | $0.00 | 0 | 0.00 | 0.00 | = | = | |||||||||
| 0 | 8.50 | $0.00 | 0 | 0.00 | 0.00 | GRAND TOTAL | 0.00 | |||||||||
| 0 | 8.50 | $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 | ||||||||||||||
| Holidays/ | 0 | 0.00 | 0.00 | |||||||||||||
| 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 | |||||||||
| Project Manager | 10 | 0 | $0.00 | times Work Hours | = | = | = | = | = | |||||||
| 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 & Welfare | ||||||||||||||||
| NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | H&W/Benefit Fund/ | H&W/Benefit Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Forklift Operator | 0 | 8.50 | $0.00 | |||||||||||||
| Project Manager | 0 | 8.50 | $0.00 | |||||||||||||
| 0 | 8.50 | $0.00 | ||||||||||||||
| 0 | 8.50 | $0.00 | ||||||||||||||
| 0 | 8.50 | $0.00 | ||||||||||||||
| 0 | 8.50 | $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 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Custodial
| SOLICITATION NUMBER: | HDEC0821R0010 | SOLICITATION NUMBER: | HDEC0821R0010 | SOLICITATION NUMBER: | HDEC0821R0010 | |||||||||||
| COMMISSARY: | Fort Bragg North | COMMISSARY: | Fort Bragg North | COMMISSARY: | Fort Bragg North | |||||||||||
| 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 | 18.76 | $0.00 | COST ELEMENT | DOLLARS | |||||||||||
| Project Manager | 0 | 0.00 | $0.00 | = | = | |||||||||||
| 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 & Welfare | Floor Finish | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | 0.00 | ||||||||||
| NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA. | Floor Sealer | 0 | 0.00 | 0.00 | - | |||||||||||
| H&W/Benefit Fund/ | H&W/Benefit Fund/ | Floor Stripper | 0 | 0.00 | 0.00 | SUB-TOTAL | 0.00 | |||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | Gloves | 0 | 0.00 | 0.00 | = | ||||||||
| = | = | = | = | = | Gloves, Latex | 0 | 0.00 | 0.00 | G&A | 0.00% | 0.00 | |||||
| Custodian | 0 | 8.50 | $0.00 | Kintowel Wiper | 0 | 0.00 | 0.00 | |||||||||
| Project Manager | 0 | 8.50 | $0.00 | LiquidLive | 0 | 0.00 | 0.00 | PROFIT | 0.00% | 0.00 | ||||||
| 0 | 8.50 | $0.00 | Masks | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 8.50 | $0.00 | Mop Head, Wet | 0 | 0.00 | 0.00 | = | = | ||||||||
| 0 | 8.50 | $0.00 | Neutralizer | 0 | 0.00 | 0.00 | GRAND TOTAL | 0.00 | ||||||||
| 0 | 8.50 | $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 | |||||||||||||
| Holidays/ | Rain Suit | 0 | 0.00 | 0.00 | ||||||||||||
| 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 | ||||||||
| Project Manager | 10 | 0 | $0.00 | times Work Hours | Soap, Hand, Liquid | 0 | 0.00 | 0.00 | ||||||||
| 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 & Welfare | Vaccuum Belts | 0 | 0.00 | 0.00 | ||||||||||||
| NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA. | Visors | 0 | 0.00 | 0.00 | ||||||||||||
| Holidays/Sick/ | H&W/Benefit Fund/ | H&W/Benefit Fund/ | Battery Charger | 0 | 0.00 | 0.00 | ||||||||||
| Vacations | Pension Rates = | Pension Cost | Buffer, High Speed | 0 | 0.00 | 0.00 | ||||||||||
| COST ELEMENT | Hours X | Rates = | Cost | Burnisher High Speed | 0 | 0.00 | 0.00 | |||||||||
| = | = | = | = | = | Burnisher, 21" Propane | 0 | 0.00 | 0.00 | ||||||||
| Custodian | 0 | 8.50 | $0.00 | Caddy, Maid | 0 | 0.00 | 0.00 | |||||||||
| Project Manager | 0 | 8.50 | $0.00 | Carpet Extractor | 0 | 0.00 | 0.00 | |||||||||
| 0 | 8.50 | $0.00 | Floor Scrubber, Low Speed | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 8.50 | $0.00 | Scrubber, 20" | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 8.50 | $0.00 | Scrubber, Auto | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 8.50 | $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 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Year Totals
| SOLICITATION NUMBER: | HDEC0821R0010 | |
| COMMISSARY: | Fort Bragg North | |
| 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 | |
| = | = |
Click Here to Print
5 Yr. Totals
| SOLICITATION NUMBER: | HDEC0821R0010 | |||||
| COMMISSARY: | Fort Bragg North | |||||
| 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: | HDEC0821R0010 | |||||
| COMMISSARY: | Fort Bragg North | |||||
| 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 | ||||||
| = | = | = | = | = | = |
Click Here to Print
Shelf Stocker Loaded Wage Rate
| Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC0821R0010 | SOLICITATION NUMBER: | HDEC0821R0010 | SOLICITATION NUMBER: | HDEC0821R0010 | |||||||||||
| COMMISSARY: | Fort Bragg North | COMMISSARY: | Fort Bragg North | COMMISSARY: | Fort Bragg North | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| Shelf Stocker Loaded Wage Rate Work Sheet | Shelf Stocker Loaded Wage Rate Work Sheet | Shelf Stocker Loaded Wage Rate Work Sheet | ||||||||||||||
| Direct Labor | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||
| Shelf Stocking Supplies & Equipment | ================ | |||||||||||||||
| WD | ||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Stocker/FDS | 1 | 19.00 | $19.00 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $19.00 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $8.50 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| Qty. | Unit/ | Extended | SUB-TOTAL | $27.50 | ||||||||||||
| - | - | - | - | Elements | Yearly | Price | Price | |||||||||
| TOTALS | 1 | $19.00 | = | = | = | = | = | = | HOLIDAYS, SICK & VACATIONS | $1.03 | ||||||
| = | = | = | = | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | HOL, SICK & VAC. HEALTH & WELFARE | $0.00 | |||||||
| 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.03 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | 0 | 0.00 | 0.00 | ||||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $2.18 | |||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| Direct Labor Health and Welfare | 0 | 0.00 | 0.00 | - | ||||||||||||
| NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $30.71 | |||||||||||
| H&W/Benefit Fund/ | H&W/Benefit Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours | Pension Rates = | Pension Cost | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Stocker/FDS | 1 | 8.50 | $8.50 | 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.71 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | = | = | = | = | = | = | ||||||||||
| - | - | - | - | TOTALS | $0.00 | |||||||||||
| TOTALS | 1 | $8.50 | = | = | = | = | = | |||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Stocker/FDS | 10 | 0 | $1.03 | |||||||||||||
| (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 | $1.03 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health & Welfare | ||||||||||||||||
| NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | H&W/Benefit Fund/ | H&W/Benefit Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Stocker/FDS | 0.0 | 8.50 | $0.00 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.00 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $19.00 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $8.50 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $1.03 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE | $0.00 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $28.53 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $2.18 | ||||||||||||
| 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.18 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Forklift Operator Loaded Wage
| Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC0821R0010 | SOLICITATION NUMBER: | HDEC0821R0010 | SOLICITATION NUMBER: | HDEC0821R0010 | |||||||||||
| COMMISSARY: | Fort Bragg North | COMMISSARY: | Fort Bragg North | COMMISSARY: | Fort Bragg North | |||||||||||
| 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 | 19.66 | $19.66 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $19.66 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $8.50 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $28.16 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $19.66 | Elements | Yearly | Price | Price | HOLIDAYS, SICK & VACATIONS | $1.06 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOL, SICK & VAC. HEALTH & WELFARE | $0.00 | |||||
| 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.06 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Forklift Operator | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.93 | |||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| Direct Labor Health and Welfare | 0 | 0.00 | 0.00 | - | ||||||||||||
| NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $31.15 | |||||||||||
| H&W/Benefit Fund/ | H&W/Benefit Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours | Pension Rates = | Pension Cost | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Forklift Operator | 1 | 8.50 | $8.50 | 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 | $31.15 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $8.50 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Forklift Operator | 10 | 0 | $1.06 | |||||||||||||
| (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.06 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health & Welfare | ||||||||||||||||
| NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | H&W/Benefit Fund/ | H&W/Benefit Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Forklift Operator | 0 | 8.50 | $0.00 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.00 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $19.66 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $4.50 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $1.06 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE | $0.00 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $25.22 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $1.93 | ||||||||||||
| 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.93 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Janitor Loaded Wage Rate
| Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC0821R0010 | SOLICITATION NUMBER: | HDEC0821R0010 | SOLICITATION NUMBER: | HDEC0821R0010 | |||||||||||
| COMMISSARY: | Fort Bragg North | COMMISSARY: | Fort Bragg North | COMMISSARY: | Fort Bragg North | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| Janitor Loaded Wage Rate Work Sheet | Janitor Loaded Wage Rate Work Sheet | Janitor Loaded Wage Rate Work Sheet | ||||||||||||||
| Direct Labor | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||
| Custodial Supplies & Equipment | ================ | |||||||||||||||
| WD | ||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Custodian | 1 | 18.76 | $18.76 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $18.76 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $8.50 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $27.26 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $18.76 | Elements | Yearly | Price | Price | HOLIDAYS, SICK & VACATIONS | $1.01 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOL, SICK & VAC. HEALTH & WELFARE | $0.00 | |||||
| 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.01 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Janitor | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $2.16 | |||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| Direct Labor Health and Welfare | 0 | 0.00 | 0.00 | - | ||||||||||||
| NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $30.43 | |||||||||||
| H&W/Benefit Fund/ | H&W/Benefit Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours | Pension Rates = | Pension Cost | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Custodian | 1 | 8.50 | $8.50 | 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.43 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $8.50 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Custodian | 10 | 0 | $1.01 | |||||||||||||
| (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.01 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health & Welfare | ||||||||||||||||
| NOTE: Insert the appropriate H&W/Annual Benefit Fund/Pension Rate for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | H&W/Benefit Fund/ | H&W/Benefit Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Custodian | 0 | 8.50 | $0.00 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.00 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $18.76 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $8.50 | |||||||||||||||
| HOLIDAYS/SICK/VACATION | $1.01 | |||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0.00 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $28.27 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $2.16 | ||||||||||||
| 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.16 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
File details come from the government source that posted it. Updated .