Attachment_4,_Cost_Breakout_Amend_0003.xls
XLS spreadsheet 387 KB Posted
- Solicitation number
- HDEC08-17-R-0010
- Issued by
-
Defense Commissary Agency
About this file
Revised Cost Breakout
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment_2,_PWS_as_of_April_21,_2017.doc.docx | DOCX document | |
| HDEC08-17-R-0010-0002.docx | DOCX document | |
| Attachment_1,_DD_Form_1707_as_of_April_19,_2017.doc | DOC document | |
| HDEC08-17-R-0010.docx | DOCX document | |
| Attachment_3,_CBA.pdf | ||
| Attachment_4,_Cost_Breakout.xls | XLS spreadsheet | |
| Attachment_5,_Technical_Capability.doc | DOC document | |
| Attachment_1,_DD_Form_1707.doc | DOC document | |
| HDEC08-17-R-0010.doc | DOC document | |
| Attachment_8,_Bereavement_Leave_Certification.docx | DOCX document | |
| Attachment_6,_TDWS-DLS.xls | XLS spreadsheet | |
| Attachment_2,_PWS.doc | DOC 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 4 |
| HDEC08-17-R-0010 0003 |
| 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. |
Printing Instructions
| Attachment 4 | |||||
| BASIC INSTRUCTIONS | HDEC08-17-R-0010 | ||||
| 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 , RSHA, and Custodial | |
| GRAND_TOTALS | Fit Columns to Page | None | Landscape | 5 year totals of Shelf Stocking , RSHA, and Custoidal | |
| 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
| Attachment 4 | Attachment 4 | Attachment 4 | Attachment 4 | |||||||||||||||||||
| SOLICITATION NUMBER: | HDEC08-17-R-0010 0003 | SOLICITATION NUMBER: | HDEC08-17-R-0010 0003 | SOLICITATION NUMBER: | HDEC08-17-R-0010 0003 | SOLICITATION NUMBER: | HDEC08-17-R-0010 0003 | |||||||||||||||
| COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | |||||||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | |||||||||||||||||||
| Shelf Stocking Operations Work Sheet | Shelf Stocking Operations Work Sheet | Shelf Stocking Operations Work Sheet | Shelf Stocking Operations Work Sheet | |||||||||||||||||||
| Direct Labor | Contractor Proposed Pension | Contractor Proposed | DOLLAR TOTALS | |||||||||||||||||||
| (Leads will receive $1.00/per hour above the wage rates for the classification of the employees | (The labor categories below are SAMPLES) | Shelf Stocking Supplies & Equipment | ================ | |||||||||||||||||||
| that they lead) | CBA | |||||||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | (Schedule A - $3.25/hour per Bargaining Union Employee) | $3.25 | (The elements listed below are SAMPLES and are not considered | ||||||||||||||||
| = | = | = | = | = | a requirement of the solicitation.) | |||||||||||||||||
| Stockers | 0 | $17.31 | $0 | COST ELEMENT | DOLLARS | |||||||||||||||||
| Lead Worker | 0 | $18.31 | $0 | = | = | |||||||||||||||||
| Project Manager (Non-Bargaining Unit Employee) | 0 | $0.00 | $0 | Hours + | Extended | Qty. | Unit/ | Extended | DIRECT LABOR | $0 | ||||||||||||
| 0 | 0.00 | $0 | Labor Categories | Holidays/Sick/Vacation | Price | Elements | Yearly | Price | Price | DIRECT LABOR HEALTH & WELFARE | $0 | |||||||||||
| 0 | 0.00 | $0 | = | = | = | = | = | = | = | = | = | = | = | = | = | = | ||||||
| 0 | 0.00 | $0 | Stockers | 0 | $0.00 | Blades, Carton Cutter | 0 | 0.00 | $0.00 | SUB-TOTAL | $0 | |||||||||||
| - | - | - | - | Lead Worker | 0 | $0.00 | Cutter, Carton | 0 | 0.00 | $0.00 | ||||||||||||
| TOTALS | 0 | $0 | 0 | $0.00 | Dispenser, Tape | 0 | 0.00 | 0.00 | HOLIDAYS/SICK/VACATIONS | $0 | ||||||||||||
| = | = | = | = | 0 | $0.00 | Safety Shoes | 0 | 0.00 | 0.00 | HOL & VAC. HEALTH & WELFARE | $0 | |||||||||||
| Indirect Labor Hours (Non-Working) | 0 | $0.00 | Tape Masking | 0 | 0.00 | 0.00 | = | = | ||||||||||||||
| = | 0 | $0.00 | Back Brace | 0 | 0.00 | 0.00 | SUB-TOTAL | $0 | ||||||||||||||
| Direct Labor Hours (Productive/Working) | 0 | Cart, Bushel | 0 | 0.00 | 0.00 | |||||||||||||||||
| = | Cart, Stocking | 0 | 0.00 | 0.00 | FRINGES | $0 | ||||||||||||||||
| Pallet Jacks | 0 | 0.00 | 0.00 | |||||||||||||||||||
| = | = | = | = | = | = | 0 | 0.00 | 0.00 | PENSION | $0 | ||||||||||||
| TOTALS | 0 | $0.00 | 0 | 0.00 | 0.00 | |||||||||||||||||
| Direct Labor Health and Welfare | = | = | = | = | = | = | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0 | |||||||||||
| 0 | 0.00 | 0.00 | - | |||||||||||||||||||
| H&W | H&W | 0 | 0.00 | 0.00 | SUB-TOTAL | $0 | ||||||||||||||||
| COST ELEMENT | Hours | Rates | Cost | 0 | 0.00 | 0.00 | = | |||||||||||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | G&A | 0.00% | $0 | ||||||||||||
| Stockers | 0 | $4.11 | $0 | 0 | 0.00 | 0.00 | ||||||||||||||||
| Lead Worker | 0 | $4.11 | $0 | = | = | = | = | = | = | PROFIT | 0.00% | $0 | ||||||||||
| Project Manager (Non-Bargaining Unit Employee) | 0 | $0.00 | $0 | TOTALS | 0 | 0.00 | $0.00 | |||||||||||||||
| 0 | $0.00 | $0 | = | = | = | = | = | = | = | |||||||||||||
| 0 | $0.00 | $0 | GRAND TOTAL | $0 | ||||||||||||||||||
| 0 | $0.00 | $0 | = | = | = | = | ||||||||||||||||
| - | - | - | - | ANNUAL CASES | 356,124 | |||||||||||||||||
| TOTALS | 0 | $0 | = | = | = | |||||||||||||||||
| = | = | = | = | CASE PRICE | $0.0000 | |||||||||||||||||
| = | = | = | ||||||||||||||||||||
| Holidays, Sick and Vacations | ||||||||||||||||||||||
| Holidays, Sick, | ||||||||||||||||||||||
| Sick/ | Vacations | |||||||||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||||||||
| = | = | = | = | = | ||||||||||||||||||
| Stockers | 10 | 0 | $0.00 | (Work hours divided by ((2080 hours- | ||||||||||||||||||
| Lead Worker | 10 | 0 | $0.00 | (Holidays/Sick+ Vacations)*8))) * | ||||||||||||||||||
| Project Manager (Non-Bargaining Unit Employee) | 0 | 0 | $0.00 | ((Closed Holidays*8*Hourly rate)+ | ||||||||||||||||||
| 0 | 0 | $0.00 | (Holidays worked*8*Hourly rate* time & half))+ | |||||||||||||||||||
| 0 | 0 | $0.00 | (Work Hours divided by(2080-((Holidays/Sick+ | |||||||||||||||||||
| 0 | 0 | $0.00 | Vacations)*8)))*(Vacations *8*Hourly rate) | |||||||||||||||||||
| - | - | - | - | |||||||||||||||||||
| TOTALS | 20 | $0 | ||||||||||||||||||||
| = | = | = | = | |||||||||||||||||||
| Holidays and Vacations Health & Welfare | ||||||||||||||||||||||
| Holidays/Sick/ | H&W | H&W | ||||||||||||||||||||
| COST ELEMENT | Vacations | Rates | Cost | |||||||||||||||||||
| = | = | = | = | = | ||||||||||||||||||
| Stockers | 0 | $4.11 | $0 | |||||||||||||||||||
| Lead Worker | 0 | $4.11 | $0 | |||||||||||||||||||
| 0 | $0.00 | $0 | ||||||||||||||||||||
| 0 | $0.00 | $0 | ||||||||||||||||||||
| 0 | $0.00 | $0 | ||||||||||||||||||||
| 0 | $0.00 | $0 | ||||||||||||||||||||
| - | - | - | - | |||||||||||||||||||
| TOTALS | 0 | $0 | ||||||||||||||||||||
| = | = | = | = | |||||||||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||||||||
| = | = | = | = | = | = | |||||||||||||||||
| DIRECT LABOR COST | $0 | |||||||||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $0 | |||||||||||||||||||||
| HOLIDAYS/SICK/VACATION | $0 | |||||||||||||||||||||
| PENSION | $0 | |||||||||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0 | |||||||||||||||||||||
| - | - | - | - | - | - | |||||||||||||||||
| SUBTOTAL | $0 | |||||||||||||||||||||
| = | = | = | = | = | = | |||||||||||||||||
| FICA | X | 7.65% | = | $0 | ||||||||||||||||||
| FUTA | X | 0.00% | = | $0 | ||||||||||||||||||
| SUTA | X | 0.00% | = | $0 | ||||||||||||||||||
| Workman's Compensation | X | 0.00% | = | $0 | ||||||||||||||||||
| Employer's Liability | X | 0.00% | = | $0 | ||||||||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0 | ||||||||||||||||||
| Other | X | 0.00% | = | $0 | ||||||||||||||||||
| Other | X | 0.00% | = | $0 | ||||||||||||||||||
| - | - | - | - | - | - | |||||||||||||||||
| TOTAL FRINGES | $0 | |||||||||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
RSH
| Attachment 4 | Attachment 4 | Attachment 4 | Attachment 4 | |||||||||||||||||||
| SOLICITATION NUMBER: | HDEC08-17-R-0010 0003 | SOLICITATION NUMBER: | HDEC08-17-R-0010 0003 | SOLICITATION NUMBER: | HDEC08-17-R-0010 0003 | SOLICITATION NUMBER: | HDEC08-17-R-0010 0003 | |||||||||||||||
| COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | |||||||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | |||||||||||||||||||
| R/S/H Operations Work Sheet | R/S/H Operations Work Sheet | R/S/H Operations Work Sheet | R/S/H Operations Work Sheet | |||||||||||||||||||
| Direct Labor | Contractor Proposed Pension | Contractor Proposed | DOLLAR TOTALS | |||||||||||||||||||
| (Leads will receive $1.00/per hour above the wage rates for the classification of the employees | (The labor categories below are SAMPLES) | R/S/H Supplies & Equipment | ================ | |||||||||||||||||||
| that they lead) | CBA | |||||||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | (Schedule A - $3.25/hour per Bargaining Union Employee) | $3.25 | (The elements listed below are SAMPLES and are not to be considered | ||||||||||||||||
| = | = | = | = | = | a requirement of the solicitation.) | |||||||||||||||||
| Warehouse Specialist | 0 | $17.31 | $0 | COST ELEMENT | DOLLARS | |||||||||||||||||
| Lead Worker | 0 | $18.31 | $0 | = | = | |||||||||||||||||
| Project Manager (Non-Bargaining Unit Employee) | 0 | $0.00 | $0 | Hours + | Extended | Qty. | Unit/ | Extended | DIRECT LABOR | $0 | ||||||||||||
| 0 | $0.00 | $0 | Labor Categories | Holidays/Sick/Vacation | Price | Elements | Yearly | Price | Price | DIRECT LABOR HEALTH & WELFARE | $0 | |||||||||||
| 0 | $0.00 | $0 | = | = | = | = | = | = | = | = | = | = | = | = | = | = | ||||||
| 0 | $0.00 | $0 | Warehouse Specialist | 0 | $0.00 | Blades, Carton Cutter | 0 | 0.00 | $0.00 | SUB-TOTAL | $0 | |||||||||||
| - | - | - | - | Lead Worker | 0 | $0.00 | Cutter, Carton | 0 | 0.00 | $0.00 | ||||||||||||
| TOTALS | 0 | $0 | 0 | $0.00 | Dispenser, Tape | 0 | 0.00 | 0.00 | HOLIDAYS/SICK/VACATIONS | $0 | ||||||||||||
| = | = | = | = | 0 | $0.00 | Safety Shoes | 0 | 0.00 | 0.00 | HOL & VAC. HEALTH & WELFARE | $0 | |||||||||||
| Indirect Labor Hours (Non-Working) | 0 | 0 | $0.00 | Tape Masking | 0 | 0.00 | 0.00 | = | = | |||||||||||||
| = | 0 | $0.00 | Back Brace | 0 | 0.00 | 0.00 | SUB-TOTAL | $0 | ||||||||||||||
| Direct Labor Hours (Productive/Working) | 0 | Cart, Bushel | 0 | 0.00 | 0.00 | |||||||||||||||||
| = | Cart, Stocking | 0 | 0.00 | 0.00 | FRINGES | $0 | ||||||||||||||||
| Pallet Jacks | 0 | 0.00 | 0.00 | |||||||||||||||||||
| 0 | 0.00 | 0.00 | PENSION | $0 | ||||||||||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||||||||
| Direct Labor Health and Welfare | = | = | = | = | = | = | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0 | |||||||||||
| TOTALS | 0 | $0.00 | 0 | 0.00 | 0.00 | - | ||||||||||||||||
| H&W | H&W | = | = | = | = | = | = | 0 | 0.00 | 0.00 | SUB-TOTAL | $0 | ||||||||||
| COST ELEMENT | Hours | Rates = | Cost | 0 | 0.00 | 0.00 | = | |||||||||||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | G&A | 0.00% | $0 | ||||||||||||
| Warehouse Specialist | 0 | $4.11 | $0 | 0 | 0.00 | 0.00 | ||||||||||||||||
| Lead Worker | 0 | $4.11 | $0 | 0 | 0.00 | 0.00 | PROFIT | 0.00% | $0 | |||||||||||||
| Project Manager (Non-Bargaining Unit Employee) | 0 | $0.00 | $0 | 0 | 0.00 | 0.00 | ||||||||||||||||
| 0 | $0.00 | $0 | 0 | 0.00 | 0.00 | = | = | |||||||||||||||
| 0 | $0.00 | $0 | 0 | 0.00 | 0.00 | GRAND TOTAL | $0 | |||||||||||||||
| 0 | $0.00 | $0 | 0 | 0.00 | 0.00 | = | = | = | = | |||||||||||||
| - | - | - | - | 0 | 0.00 | 0.00 | = | = | = | |||||||||||||
| TOTALS | 0 | $0 | 0 | 0.00 | 0.00 | MO. PRICE | $0 | |||||||||||||||
| = | = | = | = | 0 | 0.00 | 0.00 | = | = | = | |||||||||||||
| Holidays and Vacations | 0 | 0.00 | 0.00 | |||||||||||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||||||||
| Holidays, Sick, | 0 | 0.00 | 0.00 | |||||||||||||||||||
| Sick/ | Vacations | 0 | 0.00 | 0.00 | ||||||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | 0 | 0.00 | 0.00 | ||||||||||||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||||||||
| Warehouse Specialist | 10 | 0 | $0.00 | (Work hours divided by ((2080 hours- | 0 | 0.00 | 0.00 | |||||||||||||||
| Lead Worker | 10 | 0 | $0.00 | (Holidays/Sick+ Vacations)*8))) * | = | = | = | = | = | |||||||||||||
| Project Manager (Non-Bargaining Unit Employee) | 0 | 0 | $0.00 | ((Closed Holidays*8*Hourly rate)+ | TOTALS | 0 | $0.00 | |||||||||||||||
| 0 | 0 | $0.00 | (Holidays worked*8*Hourly rate* time & half))+ | = | = | = | = | = | = | |||||||||||||
| 0 | 0 | $0.00 | (Work Hours divided by(2080-((Holidays/Sick+ | |||||||||||||||||||
| 0 | 0 | $0.00 | Vacations)*8)))*(Vacations *8*Hourly rate) | |||||||||||||||||||
| - | - | - | - | |||||||||||||||||||
| TOTALS | 20 | $0 | ||||||||||||||||||||
| = | = | = | = | |||||||||||||||||||
| Holidays and Vacations Health & Welfare | ||||||||||||||||||||||
| Holidays/Sick/ | H&W | H&W | ||||||||||||||||||||
| COST ELEMENT | Vacations | Rates | Cost | |||||||||||||||||||
| = | = | = | = | = | ||||||||||||||||||
| Warehouse Specialist | 0 | $4.11 | $0 | |||||||||||||||||||
| Lead Worker | 0 | $4.11 | $0 | |||||||||||||||||||
| Project Manager (Non-Bargaining Unit Employee) | 0 | $0.00 | $0 | |||||||||||||||||||
| 0 | $0.00 | $0 | ||||||||||||||||||||
| 0 | $0.00 | $0 | ||||||||||||||||||||
| 0 | $0.00 | $0 | ||||||||||||||||||||
| - | - | - | - | |||||||||||||||||||
| TOTALS | 0 | $0 | ||||||||||||||||||||
| = | = | = | = | |||||||||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||||||||
| = | = | = | = | = | = | |||||||||||||||||
| DIRECT LABOR COST | $0 | |||||||||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $0 | |||||||||||||||||||||
| HOLIDAYS/SICK/VACATION | $0 | |||||||||||||||||||||
| PENSION | $0 | |||||||||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0 | |||||||||||||||||||||
| - | - | - | - | - | - | |||||||||||||||||
| SUBTOTAL | $0 | |||||||||||||||||||||
| = | = | = | = | = | = | |||||||||||||||||
| FICA | X | 7.65% | = | $0 | ||||||||||||||||||
| FUTA | X | 0.00% | = | $0 | ||||||||||||||||||
| SUTA | X | 0.00% | = | $0 | ||||||||||||||||||
| Workman's Compensation | X | 0.00% | = | $0 | ||||||||||||||||||
| Employer's Liability | X | 0.00% | = | $0 | ||||||||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0 | ||||||||||||||||||
| Other | X | 0.00% | = | $0 | ||||||||||||||||||
| Other | X | 0.00% | = | $0 | ||||||||||||||||||
| - | - | - | - | - | - | |||||||||||||||||
| TOTAL FRINGES | $0 | |||||||||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Custodial
| Attachment 4 | Attachment 4 | Attachment 4 | Attachment 4 | |||||||||||||||||||
| SOLICITATION NUMBER: | HDEC08-17-R-0010 0003 | SOLICITATION NUMBER: | HDEC08-17-R-0010 0003 | SOLICITATION NUMBER: | HDEC08-17-R-0010 0003 | SOLICITATION NUMBER: | HDEC08-17-R-0010 0003 | |||||||||||||||
| COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | |||||||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | |||||||||||||||||||
| Custodial Operations Work Sheet | Custodial Operations Work Sheet | Custodial Operations Work Sheet | Custodial Operations Work Sheet | |||||||||||||||||||
| Direct Labor | Contractor Proposed Pension | Contractor Proposed | DOLLAR TOTALS | |||||||||||||||||||
| (Leads will receive $1.00/per hour above the wage rates for the classification of the employees | (The labor categories below are SAMPLES) | Custodial Supplies & Equipment | ================ | |||||||||||||||||||
| that they lead) | CBA | |||||||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | (Schedule A - $3.25/hour per Bargaining Union Employee) | $3.25 | (The elements listed below are SAMPLES and are not to be considered | ||||||||||||||||
| = | = | = | = | = | a requirement of the solicitation.) | |||||||||||||||||
| Custodian | 0 | $16.15 | $0 | COST ELEMENT | DOLLARS | |||||||||||||||||
| Lead Worker | 0 | $17.15 | $0 | = | = | |||||||||||||||||
| Project Manager (Non-Bargaining Unit Employee) | 0 | $0.00 | $0 | Hours + | Extended | Qty. | Unit/ | Extended | DIRECT LABOR | $0 | ||||||||||||
| 0 | $0.00 | $0 | Labor Categories | Holidays/Sick/Vacation | Price | Elements | Yearly | Price | Price | DIRECT LABOR HEALTH & WELFARE | $0 | |||||||||||
| 0 | $0.00 | $0 | = | = | = | = | = | = | = | = | = | = | = | = | = | = | ||||||
| 0 | $0.00 | $0 | Custodian | 0 | $0.00 | Bowl, Cleaner | 0 | 0.00 | $0.00 | SUB-TOTAL | $0 | |||||||||||
| - | - | - | - | Lead Worker | 0 | $0.00 | Cartridges | 0 | 0.00 | $0.00 | ||||||||||||
| TOTALS | 0 | $0 | 0 | $0.00 | Cleaner, Carpet | 0 | 0.00 | 0.00 | HOLIDAYS/SICK/VACATIONS | $0 | ||||||||||||
| = | = | = | = | 0 | $0.00 | Cleaner, Compound | 0 | 0.00 | 0.00 | HOL & VAC. HEALTH & WELFARE | $0 | |||||||||||
| Indirect Labor Hours (Non-Working) | 0 | 0 | $0.00 | Cleaner, Glass | 0 | 0.00 | 0.00 | = | = | |||||||||||||
| = | 0 | $0.00 | Cleaner, Neutral | 0 | 0.00 | 0.00 | SUB-TOTAL | $0 | ||||||||||||||
| Direct Labor Hours (Productive/Working) | 0 | Disinfectant | 0 | 0.00 | 0.00 | |||||||||||||||||
| = | Dust Cloths | 0 | 0.00 | 0.00 | FRINGES | $0 | ||||||||||||||||
| Dust Mop Heads | 0 | 0.00 | 0.00 | |||||||||||||||||||
| Floor Finish | 0 | 0.00 | 0.00 | PENSION | $0 | |||||||||||||||||
| Floor Sealer | 0 | 0.00 | 0.00 | |||||||||||||||||||
| Direct Labor Health and Welfare | = | = | = | = | = | = | Floor Stripper | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0 | ||||||||||
| TOTALS | 0 | $0.00 | Gloves | 0 | 0.00 | 0.00 | - | |||||||||||||||
| H&W | H&W | = | = | = | = | = | = | Gloves, Latex | 0 | 0.00 | 0.00 | SUB-TOTAL | $0 | |||||||||
| COST ELEMENT | Hours | Rates = | Cost | Kintowel Wiper | 0 | 0.00 | 0.00 | = | ||||||||||||||
| = | = | = | = | = | LiquidLive | 0 | 0.00 | 0.00 | G&A | 0.00% | $0 | |||||||||||
| Custodian | 0 | $4.11 | $0 | Masks | 0 | 0.00 | 0.00 | |||||||||||||||
| Lead Worker | 0 | $4.11 | $0 | Mop Head, Wet | 0 | 0.00 | 0.00 | PROFIT | 0.00% | $0 | ||||||||||||
| Project Manager (Non-Bargaining Unit Employee) | 0 | $0.00 | $0 | Neutralizer | 0 | 0.00 | 0.00 | |||||||||||||||
| 0 | $0.00 | $0 | Pads, Aqua 27" | 0 | 0.00 | 0.00 | = | = | ||||||||||||||
| 0 | $0.00 | $0 | Pads, Buffing | 0 | 0.00 | 0.00 | GRAND TOTAL | $0 | ||||||||||||||
| 0 | $0.00 | $0 | Pads, Doodle Bug | 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||||
| - | - | - | - | Polish, Furniture | 0 | 0.00 | 0.00 | MONTHLY PRICE | $0 | |||||||||||||
| TOTALS | 0 | $0 | Polish, Metal | 0 | 0.00 | 0.00 | = | = | = | |||||||||||||
| = | = | = | = | Propane | 0 | 0.00 | 0.00 | |||||||||||||||
| Rain Suit | 0 | 0.00 | 0.00 | |||||||||||||||||||
| Holidays and Vacations | Respirators | 0 | 0.00 | 0.00 | ||||||||||||||||||
| Holidays, Sick, | Retainer | 0 | 0.00 | 0.00 | ||||||||||||||||||
| Sick/ | Vacations | Safety Shoes | 0 | 0.00 | 0.00 | |||||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | Sanitizer, Compound D2 | 0 | 0.00 | 0.00 | |||||||||||||||
| = | = | = | = | = | Soap, Hand, Liquid | 0 | 0.00 | 0.00 | ||||||||||||||
| Custodian | 10 | 0 | $0.00 | (Work hours divided by ((2080 hours- | Sponges | 0 | 0.00 | 0.00 | ||||||||||||||
| Lead Worker | 10 | 0 | $0.00 | (Holidays/Sick+ Vacations)*8))) * | Spray Bottle | 0 | 0.00 | 0.00 | ||||||||||||||
| Project Manager (Non-Bargaining Unit Employee) | 0 | 0 | $0.00 | ((Closed Holidays*8*Hourly rate)+ | Spray Bottle Trigger | 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0 | $0.00 | (Holidays worked*8*Hourly rate* time & half))+ | Spray Buff | 0 | 0.00 | 0.00 | |||||||||||||||
| 0 | 0 | $0.00 | (Work Hours divided by(2080-((Holidays/Sick+ | Toilet Tissue, 96rl | 0 | 0.00 | 0.00 | |||||||||||||||
| 0 | 0 | $0.00 | Vacations)*8)))*(Vacations *8*Hourly rate) | Towels, Pop-Up | 0 | 0.00 | 0.00 | |||||||||||||||
| - | - | - | - | Trash Liners, Lg | 0 | 0.00 | 0.00 | |||||||||||||||
| TOTALS | 20 | $0 | Trash Liners, Sm | 0 | 0.00 | 0.00 | ||||||||||||||||
| = | = | = | = | Vaccuum Belts | 0 | 0.00 | 0.00 | |||||||||||||||
| Visors | 0 | 0.00 | 0.00 | |||||||||||||||||||
| Holidays and Vacations Health & Welfare | Battery Charger | 0 | 0.00 | 0.00 | ||||||||||||||||||
| Buffer, High Speed | 0 | 0.00 | 0.00 | |||||||||||||||||||
| Holidays/Sick/ | H&W | H&W | Burnisher High Speed | 0 | 0.00 | 0.00 | ||||||||||||||||
| COST ELEMENT | Vacations | Rates | Cost | Burnisher, 21" Propane | 0 | 0.00 | 0.00 | |||||||||||||||
| = | = | = | = | = | Caddy, Maid | 0 | 0.00 | 0.00 | ||||||||||||||
| Custodian | 0 | $4.11 | $0 | Carpet Extractor | 0 | 0.00 | 0.00 | |||||||||||||||
| Lead Worker | 0 | $4.11 | $0 | Floor Scrubber, Low Speed | 0 | 0.00 | 0.00 | |||||||||||||||
| 0 | $0.00 | $0 | Scrubber, 20" | 0 | 0.00 | 0.00 | ||||||||||||||||
| 0 | $0.00 | $0 | Scrubber, Auto | 0 | 0.00 | 0.00 | ||||||||||||||||
| 0 | $0.00 | $0 | Vacuum, Wet/Dry | 0 | 0.00 | 0.00 | ||||||||||||||||
| 0 | $0.00 | $0 | Washer, Pressure | 0 | 0.00 | 0.00 | ||||||||||||||||
| - | - | - | - | 0 | 0.00 | 0.00 | ||||||||||||||||
| TOTALS | 0 | $0 | 0 | 0.00 | 0.00 | |||||||||||||||||
| = | = | = | = | 0 | 0.00 | 0.00 | ||||||||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||||||||
| FRINGE CALCULATIONS | = | = | = | = | = | = | ||||||||||||||||
| TOTALS | 0 | $0 | ||||||||||||||||||||
| COST ELEMENT | DOLLARS | = | = | = | = | = | = | |||||||||||||||
| = | = | = | = | = | = | |||||||||||||||||
| DIRECT LABOR COST | $0 | |||||||||||||||||||||
| DIRECT HEALTH & WELFARE COST | $0 | |||||||||||||||||||||
| HOLIDAYS/SICK/VACATION | $0 | |||||||||||||||||||||
| PENSION | $0 | |||||||||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0 | |||||||||||||||||||||
| - | - | - | - | - | - | |||||||||||||||||
| SUBTOTAL | $0 | |||||||||||||||||||||
| = | = | = | = | = | = | |||||||||||||||||
| FICA | X | 7.65% | = | $0 | ||||||||||||||||||
| FUTA | X | 0.00% | = | $0 | ||||||||||||||||||
| SUTA | X | 0.00% | = | $0 | ||||||||||||||||||
| Workman's Compensation | X | 0.00% | = | $0 | ||||||||||||||||||
| Employer's Liability | X | 0.00% | = | $0 | ||||||||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0 | ||||||||||||||||||
| Other | X | 0.00% | = | $0 | ||||||||||||||||||
| Other | X | 0.00% | = | $0 | ||||||||||||||||||
| - | - | - | - | - | - | |||||||||||||||||
| TOTAL FRINGES | $0 | |||||||||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Year Totals
| Attachment 4 | ||
| SOLICITATION NUMBER: | HDEC08-17-R-0010 0003 | |
| COMMISSARY: | USAF Academy, Colorado | |
| CONTRACTOR NAME: | ||
| BASE YEAR GRAND TOTALS | ||
| DOLLAR TOTALS | ||
| ================ | ||
| COST ELEMENT | DOLLARS | |
| = | = | |
| DIRECT LABOR | $0 | |
| DIRECT HEALTH & WELFARE | $0 | |
| = | = | |
| TOTAL | $0 | |
| HOLIDAYS/SICK/VACATIONS | $0 | |
| HOL & VAC. HEALTH & WELFARE | $0 | |
| = | = | |
| TOTAL | $0 | |
| FRINGES CALCULATIONS | $0 | |
| PENSION | $0 | |
| SUPPLIES & EQUIPMENT | $0 | |
| SUB-TOTAL | $0 | |
| G&A | $0 | |
| PROFIT | $0 | |
| = | = | |
| GRAND TOTAL | $0 | |
| = | = |
Click Here to Print
5 Yr. Totals
| Attachment 4 | ||||||
| SOLICITATION NUMBER: | HDEC08-17-R-0010 0003 | |||||
| COMMISSARY: | USAF Academy, Colorado | |||||
| 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 | 0 | 0 | 0 | 0 | 0 |
| DIRECT HEALTH & WELFARE | 0 | 0 | 0 | 0 | 0 | 0 |
| = | = | = | = | = | = | = |
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 |
| HOLIDAYS/SICK/VACATIONS | 0 | 0 | 0 | 0 | 0 | 0 |
| HOL & VAC. HEALTH & WELFARE | 0 | 0 | 0 | 0 | 0 | 0 |
| = | = | = | = | = | = | = |
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 |
| FRINGES CALCULATIONS | 0 | 0 | 0 | 0 | 0 | 0 |
| PENSION | 0 | 0 | 0 | 0 | 0 | 0 |
| SUPPLIES & EQUIPMENT | 0 | 0 | 0 | 0 | 0 | 0 |
| SUB-TOTAL | 0 | 0 | 0 | 0 | 0 | 0 |
| G&A | 0 | 0 | 0 | 0 | 0 | 0 |
| PROFIT | 0 | 0 | 0 | 0 | 0 | 0 |
| = | = | = | = | = | = | = |
| GRAND TOTAL | 0 | 0 | 0 | 0 | 0 | 0 |
| = | = | = | = | = | = | = |
| Attachment 4 | ||||||
| SOLICITATION NUMBER: | HDEC08-17-R-0010 0003 | |||||
| COMMISSARY: | USAF Academy, Colorado | |||||
| 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 HEALTH & WELFARE | 0.00% | 0.00% | 0.00% | 0.00% | ||
| = | = | = | = | = | = | |
| TOTAL | ||||||
| HOLIDAYS & VACATIONS | 0.00% | 0.00% | 0.00% | 0.00% | ||
| HOL & VAC. HEALTH & WELFARE | 0.00% | 0.00% | 0.00% | 0.00% | ||
| = | = | = | = | = | = | |
| TOTAL | ||||||
| FRINGES | 0.00% | 0.00% | 0.00% | 0.00% | ||
| PENSION | 0.00% | 0.00% | 0.00% | 0.00% | ||
| EQUIPMENT & SUPPLIES | 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
Stockers Loaded Wage Rate
| Attachment 4 | Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||||||
| SOLICITATION NUMBER: | HDEC08-17-R-0010 | SOLICITATION NUMBER: | HDEC08-17-R-0010 | SOLICITATION NUMBER: | HDEC08-17-R-0010 | SOLICITATION NUMBER: | HDEC08-17-R-0010 | ||||||||||||||
| COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | ||||||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||||||
| Stockers Loaded Wage Rate Work Sheet | Stockers Loaded Wage Rate Work Sheet | Stockers Loaded Wage Rate Work Sheet | Stockers Loaded Wage Rate Work Sheet | ||||||||||||||||||
| Direct Labor | Contractor Proposed Pension | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||||||
| (The labor categories below are SAMPLES) | Shelf Stocking Supplies & Equipment | ================ | |||||||||||||||||||
| CBA | |||||||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | (Schedule A - $3.25/hour per Bargaining Union Employee) | $3.25 | (The elements listed below are SAMPLES and are not considered | |||||||||||||||
| = | = | = | = | = | a requirement of the solicitation.) | ||||||||||||||||
| Stockers | 1 | $17.31 | $17.31 | COST ELEMENT | DOLLARS | ||||||||||||||||
| = | = | ||||||||||||||||||||
| Hours + | Extended | Qty. | Unit/ | Extended | DIRECT LABOR | $17.31 | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | Labor Categories | Holiday/Sick/Vacation | Price | Elements | Yearly | Price | Price | DIRECT LABOR HEALTH & WELFARE | $4.11 | ||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | = | = | = | = | = | = | = | = | = | = | = | = | = | = | |||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | Stockers | 1 | $3.38 | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | SUB-TOTAL | $21.42 | ||||||||||||
| - | - | - | - | are not included in the loaded | 0 | 0.00 | $0.00 | ||||||||||||||
| TOTALS | 1 | $17.31 | rate for Store Worker I | 0 | 0.00 | 0.00 | HOLIDAYS/SICK/VACATIONS | $0.93 | |||||||||||||
| = | = | = | = | 0 | 0.00 | 0.00 | HOL & VAC. HEALTH & WELFARE | $0.16 | |||||||||||||
| Indirect Labor Hours (Non-Working) | 0 | 0.00 | 0.00 | = | = | ||||||||||||||||
| = | 0 | 0.00 | 0.00 | SUB-TOTAL | $1.10 | ||||||||||||||||
| Direct Labor Hours (Productive/Working) | 1 | 0 | 0.00 | 0.00 | |||||||||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.98 | ||||||||||||||||
| 0 | 0.00 | 0.00 | |||||||||||||||||||
| = | = | = | = | = | = | 0 | 0.00 | 0.00 | PENSION | $3.38 | |||||||||||
| TOTALS | $1.04 | $3.38 | 0 | 0.00 | 0.00 | ||||||||||||||||
| Direct Labor Health and Welfare | = | = | = | = | = | = | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||
| 0 | 0.00 | 0.00 | - | ||||||||||||||||||
| H&W | H&W | 0 | 0.00 | 0.00 | SUB-TOTAL | $27.88 | |||||||||||||||
| COST ELEMENT | Hours | Rates | Cost | 0 | 0.00 | 0.00 | = | ||||||||||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||||||
| Stockers | 1 | $4.11 | $4.11 | 0 | 0.00 | 0.00 | |||||||||||||||
| = | = | = | = | = | = | PROFIT | 0.00% | $0.00 | |||||||||||||
| TOTALS | 0 | 0.00 | $0.00 | ||||||||||||||||||
| = | = | = | = | = | = | = | |||||||||||||||
| GRAND TOTAL | $27.88 | ||||||||||||||||||||
| = | = | = | |||||||||||||||||||
| - | - | - | - | ||||||||||||||||||
| TOTALS | 1 | $4.11 | |||||||||||||||||||
| = | = | = | = | ||||||||||||||||||
| Holidays, Sick and Vacations | |||||||||||||||||||||
| Holidays, Sick, | |||||||||||||||||||||
| Sick/ | Vacations | ||||||||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | ||||||||||||||||||
| = | = | = | = | = | |||||||||||||||||
| Stockers | 10 | 0 | $0.93 | (Work hours divided by ((2080 hours- | |||||||||||||||||
| $0.00 | (Holidays/Sick+ Vacations)*8))) * | ||||||||||||||||||||
| $0.00 | ((Closed Holidays*8*Hourly rate)+ | ||||||||||||||||||||
| $0.00 | (Holidays worked*8*Hourly rate* time & half))+ | ||||||||||||||||||||
| $0.00 | (Work Hours divided by(2080-((Holidays/Sick+ | ||||||||||||||||||||
| $0.00 | Vacations)*8)))*(Vacations *8*Hourly rate) | ||||||||||||||||||||
| - | - | - | - | ||||||||||||||||||
| TOTALS | 10 | $0.93 | |||||||||||||||||||
| = | = | = | = | ||||||||||||||||||
| Holidays and Vacations Health & Welfare | |||||||||||||||||||||
| Holidays/Sick/ | H&W | H&W | |||||||||||||||||||
| COST ELEMENT | Vacations | Rates | Cost | ||||||||||||||||||
| = | = | = | = | = | |||||||||||||||||
| Stockers | 0 | $4.11 | $0.16 | ||||||||||||||||||
| - | - | - | - | ||||||||||||||||||
| TOTALS | 0 | $0.16 | |||||||||||||||||||
| = | = | = | = | ||||||||||||||||||
| FRINGE CALCULATIONS | |||||||||||||||||||||
| COST ELEMENT | DOLLARS | ||||||||||||||||||||
| = | = | = | = | = | = | ||||||||||||||||
| DIRECT LABOR COST | $17.31 | ||||||||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $4.11 | ||||||||||||||||||||
| HOLIDAYS/SICK/VACATION | $0.93 | ||||||||||||||||||||
| PENSION | $3.38 | ||||||||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0.16 | ||||||||||||||||||||
| - | - | - | - | - | - | ||||||||||||||||
| SUBTOTAL | $25.90 | ||||||||||||||||||||
| = | = | = | = | = | = | ||||||||||||||||
| FICA | X | 7.65% | = | $1.98 | |||||||||||||||||
| 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.98 | ||||||||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Lead Stockers Loaded Wage Rate
| Attachment 4 | Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||||||
| SOLICITATION NUMBER: | HDEC08-17-R-0010 | SOLICITATION NUMBER: | HDEC08-17-R-0010 | SOLICITATION NUMBER: | HDEC08-17-R-0010 | SOLICITATION NUMBER: | HDEC08-17-R-0010 | ||||||||||||||
| COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | ||||||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||||||
| Lead Stockers Loaded Wage Rate Work Sheet | Lead Stockers Loaded Wage Rate Work Sheet | Lead Stockers Loaded Wage Rate Work Sheet | Lead Stockers Loaded Wage Rate Work Sheet | ||||||||||||||||||
| Direct Labor | Contractor Proposed Pension | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||||||
| (The labor categories below are SAMPLES) | Shelf Stocking Supplies & Equipment | ================ | |||||||||||||||||||
| CBA | |||||||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | (Schedule A - $3..25/hour per Bargaining Union Employee) | $3.25 | (The elements listed below are SAMPLES and are not considered | |||||||||||||||
| = | = | = | = | = | a requirement of the solicitation.) | ||||||||||||||||
| Lead Stockers | 1 | $18.31 | $18.31 | COST ELEMENT | DOLLARS | ||||||||||||||||
| = | = | ||||||||||||||||||||
| Hours + | Extended | Qty. | Unit/ | Extended | DIRECT LABOR | $18.31 | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | Labor Categories | Holiday/Sick/Vacation | Price | Elements | Yearly | Price | Price | DIRECT LABOR HEALTH & WELFARE | $4.11 | ||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | = | = | = | = | = | = | = | = | = | = | = | = | = | = | |||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | Lead Stockers | 1 | $3.38 | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | SUB-TOTAL | $22.42 | ||||||||||||
| - | - | - | - | are not included in the loaded | 0 | 0.00 | $0.00 | ||||||||||||||
| TOTALS | 1 | $18.31 | rate for Store Worker I | 0 | 0.00 | 0.00 | HOLIDAYS/SICK/VACATIONS | $0.99 | |||||||||||||
| = | = | = | = | 0 | 0.00 | 0.00 | HOL & VAC. HEALTH & WELFARE | $0.16 | |||||||||||||
| Indirect Labor Hours (Non-Working) | 0 | 0.00 | 0.00 | = | = | ||||||||||||||||
| = | 0 | 0.00 | 0.00 | SUB-TOTAL | $1.15 | ||||||||||||||||
| Direct Labor Hours (Productive/Working) | 1 | 0 | 0.00 | 0.00 | |||||||||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $2.06 | ||||||||||||||||
| 0 | 0.00 | 0.00 | |||||||||||||||||||
| = | = | = | = | = | = | 0 | 0.00 | 0.00 | PENSION | $3.38 | |||||||||||
| TOTALS | $1.04 | $3.38 | 0 | 0.00 | 0.00 | ||||||||||||||||
| Direct Labor Health and Welfare | = | = | = | = | = | = | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||
| 0 | 0.00 | 0.00 | - | ||||||||||||||||||
| H&W | H&W | 0 | 0.00 | 0.00 | SUB-TOTAL | $29.02 | |||||||||||||||
| COST ELEMENT | Hours | Rates | Cost | 0 | 0.00 | 0.00 | = | ||||||||||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||||||
| Lead Stockers | 1 | $4.11 | $4.11 | 0 | 0.00 | 0.00 | |||||||||||||||
| = | = | = | = | = | = | PROFIT | 0.00% | $0.00 | |||||||||||||
| TOTALS | 0 | 0.00 | $0.00 | ||||||||||||||||||
| = | = | = | = | = | = | = | |||||||||||||||
| GRAND TOTAL | $29.02 | ||||||||||||||||||||
| = | = | = | |||||||||||||||||||
| - | - | - | - | ||||||||||||||||||
| TOTALS | 1 | $4.11 | |||||||||||||||||||
| = | = | = | = | ||||||||||||||||||
| Holidays, Sick and Vacations | |||||||||||||||||||||
| Holidays, Sick, | |||||||||||||||||||||
| Sick/ | Vacations | ||||||||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | ||||||||||||||||||
| = | = | = | = | = | |||||||||||||||||
| Lead Stockers | 10 | 0 | $0.99 | (Work hours divided by ((2080 hours- | |||||||||||||||||
| $0.00 | (Holidays/Sick+ Vacations)*8))) * | ||||||||||||||||||||
| $0.00 | ((Closed Holidays*8*Hourly rate)+ | ||||||||||||||||||||
| $0.00 | (Holidays worked*8*Hourly rate* time & half))+ | ||||||||||||||||||||
| $0.00 | (Work Hours divided by(2080-((Holidays/Sick+ | ||||||||||||||||||||
| $0.00 | Vacations)*8)))*(Vacations *8*Hourly rate) | ||||||||||||||||||||
| - | - | - | - | ||||||||||||||||||
| TOTALS | 10 | $0.99 | |||||||||||||||||||
| = | = | = | = | ||||||||||||||||||
| Holidays and Vacations Health & Welfare | |||||||||||||||||||||
| Holidays/Sick/ | H&W | H&W | |||||||||||||||||||
| COST ELEMENT | Vacations | Rates | Cost | ||||||||||||||||||
| = | = | = | = | = | |||||||||||||||||
| Lead Stockers | 0 | $4.11 | $0.16 | ||||||||||||||||||
| - | - | - | - | ||||||||||||||||||
| TOTALS | 0 | $0.16 | |||||||||||||||||||
| = | = | = | = | ||||||||||||||||||
| FRINGE CALCULATIONS | |||||||||||||||||||||
| COST ELEMENT | DOLLARS | ||||||||||||||||||||
| = | = | = | = | = | = | ||||||||||||||||
| DIRECT LABOR COST | $18.31 | ||||||||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $4.11 | ||||||||||||||||||||
| HOLIDAYS/SICK/VACATION | $0.99 | ||||||||||||||||||||
| PENSION | $3.38 | ||||||||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0.16 | ||||||||||||||||||||
| - | - | - | - | - | - | ||||||||||||||||
| SUBTOTAL | $26.95 | ||||||||||||||||||||
| = | = | = | = | = | = | ||||||||||||||||
| FICA | X | 7.65% | = | $2.06 | |||||||||||||||||
| 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.06 | ||||||||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Warehouse Spec Loaded Wage
| Attachment 4 | Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||||||
| SOLICITATION NUMBER: | HDEC08-17-R-0010 | SOLICITATION NUMBER: | HDEC08-17-R-0010 | SOLICITATION NUMBER: | HDEC08-17-R-0010 | SOLICITATION NUMBER: | HDEC08-17-R-0010 | ||||||||||||||
| COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | ||||||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||||||
| Warehouse Specialist Loaded Wage Rate Work Sheet | Warehouse Specialist Loaded Wage Rate Work Sheet | Warehouse Specialist Loaded Wage Rate Work Sheet | Warehouse Specialist Loaded Wage Rate Work Sheet | ||||||||||||||||||
| Direct Labor | Contractor Proposed Pension | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||||||
| (The labor categories below are SAMPLES) | Shelf Stocking Supplies & Equipment | ================ | |||||||||||||||||||
| CBA | |||||||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | (Schedule A - $3.25/hour per Bargaining Union Employee) | $3.25 | (The elements listed below are SAMPLES and are not considered | |||||||||||||||
| = | = | = | = | = | a requirement of the solicitation.) | ||||||||||||||||
| Warehouse Specialist | 1 | $17.31 | $17.31 | COST ELEMENT | DOLLARS | ||||||||||||||||
| = | = | ||||||||||||||||||||
| Hours + | Extended | Qty. | Unit/ | Extended | DIRECT LABOR | $17.31 | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | Labor Categories | Holiday/Sick/Vacation | Price | Elements | Yearly | Price | Price | DIRECT LABOR HEALTH & WELFARE | $4.11 | ||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | = | = | = | = | = | = | = | = | = | = | = | = | = | = | |||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | Warehouse Specialist | 1 | $3.38 | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | SUB-TOTAL | $21.42 | ||||||||||||
| - | - | - | - | are not included in the loaded | 0 | 0.00 | $0.00 | ||||||||||||||
| TOTALS | 1 | $17.31 | rate for Store Worker I | 0 | 0.00 | 0.00 | HOLIDAYS/SICK/VACATIONS | $0.93 | |||||||||||||
| = | = | = | = | 0 | 0.00 | 0.00 | HOL & VAC. HEALTH & WELFARE | $0.16 | |||||||||||||
| Indirect Labor Hours (Non-Working) | 0 | 0.00 | 0.00 | = | = | ||||||||||||||||
| = | 0 | 0.00 | 0.00 | SUB-TOTAL | $1.10 | ||||||||||||||||
| Direct Labor Hours (Productive/Working) | 1 | 0 | 0.00 | 0.00 | |||||||||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.98 | ||||||||||||||||
| 0 | 0.00 | 0.00 | |||||||||||||||||||
| = | = | = | = | = | = | 0 | 0.00 | 0.00 | PENSION | $3.38 | |||||||||||
| TOTALS | $1.04 | $3.38 | 0 | 0.00 | 0.00 | ||||||||||||||||
| Direct Labor Health and Welfare | = | = | = | = | = | = | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||
| 0 | 0.00 | 0.00 | - | ||||||||||||||||||
| H&W | H&W | 0 | 0.00 | 0.00 | SUB-TOTAL | $27.88 | |||||||||||||||
| COST ELEMENT | Hours | Rates | Cost | 0 | 0.00 | 0.00 | = | ||||||||||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||||||
| Warehouse Specialist | 1 | $4.11 | $4.11 | 0 | 0.00 | 0.00 | |||||||||||||||
| = | = | = | = | = | = | PROFIT | 0.00% | $0.00 | |||||||||||||
| TOTALS | 0 | 0.00 | $0.00 | ||||||||||||||||||
| = | = | = | = | = | = | = | |||||||||||||||
| GRAND TOTAL | $27.88 | ||||||||||||||||||||
| = | = | = | |||||||||||||||||||
| - | - | - | - | ||||||||||||||||||
| TOTALS | 1 | $4.11 | |||||||||||||||||||
| = | = | = | = | ||||||||||||||||||
| Holidays, Sick and Vacations | |||||||||||||||||||||
| Holidays, Sick, | |||||||||||||||||||||
| Sick/ | Vacations | ||||||||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | ||||||||||||||||||
| = | = | = | = | = | |||||||||||||||||
| Warehouse Specialist | 10 | 0 | $0.93 | (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.93 | |||||||||||||||||||
| = | = | = | = | ||||||||||||||||||
| Holidays and Vacations Health & Welfare | |||||||||||||||||||||
| Holidays/Sick/ | H&W | H&W | |||||||||||||||||||
| COST ELEMENT | Vacations | Rates | Cost | ||||||||||||||||||
| = | = | = | = | = | |||||||||||||||||
| Warehouse Specialist | 0 | $4.11 | $0.16 | ||||||||||||||||||
| - | - | - | - | ||||||||||||||||||
| TOTALS | 0 | $0.16 | |||||||||||||||||||
| = | = | = | = | ||||||||||||||||||
| FRINGE CALCULATIONS | |||||||||||||||||||||
| COST ELEMENT | DOLLARS | ||||||||||||||||||||
| = | = | = | = | = | = | ||||||||||||||||
| DIRECT LABOR COST | $17.31 | ||||||||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $4.11 | ||||||||||||||||||||
| HOLIDAYS/SICK/VACATION | $0.93 | ||||||||||||||||||||
| PENSION | $3.38 | ||||||||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0.16 | ||||||||||||||||||||
| - | - | - | - | - | - | ||||||||||||||||
| SUBTOTAL | $25.90 | ||||||||||||||||||||
| = | = | = | = | = | = | ||||||||||||||||
| FICA | X | 7.65% | = | $1.98 | |||||||||||||||||
| 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.98 | ||||||||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Lead Warehouse Spec Loaded Wage
| Attachment 4 | Attachment 4 | Attachment 4 | Attachment 4 | |||||||||||||||||||
| SOLICITATION NUMBER: | HDEC08-17-R-0010 | SOLICITATION NUMBER: | HDEC08-17-R-0010 | SOLICITATION NUMBER: | HDEC08-17-R-0010 | SOLICITATION NUMBER: | HDEC08-17-R-0010 | |||||||||||||||
| COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | |||||||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | |||||||||||||||||||
| Lead Warehouse Specialist Loaded Wage Rate | Lead Warehouse Specialist Loaded Wage Rate | Lead Warehouse Specialist Loaded Wage Rate | Lead Warehouse Specialist Loaded Wage Rate | |||||||||||||||||||
| Work Sheet | Work Sheet | Work Sheet | Work Sheet | |||||||||||||||||||
| Direct Labor | Contractor Proposed Pension | Contractor Proposed | DOLLAR TOTALS | |||||||||||||||||||
| (The labor categories below are SAMPLES) | Shelf Stocking Supplies & Equipment | ================ | ||||||||||||||||||||
| CBA | ||||||||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | (Schedule A - $3.25/hour per Bargaining Union Employee) | $3.25 | (The elements listed below are SAMPLES and are not considered | ||||||||||||||||
| = | = | = | = | = | a requirement of the solicitation.) | |||||||||||||||||
| Lead Warehouse Specialist | 1 | $18.31 | $18.31 | COST ELEMENT | DOLLARS | |||||||||||||||||
| = | = | |||||||||||||||||||||
| Hours + | Extended | Qty. | Unit/ | Extended | DIRECT LABOR | $18.31 | ||||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | Labor Categories | Holiday/Sick/Vacation | Price | Elements | Yearly | Price | Price | DIRECT LABOR HEALTH & WELFARE | $4.11 | |||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | = | = | = | = | = | = | = | = | = | = | = | = | = | = | ||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | Lead Warehouse Specialist | 1 | $3.38 | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | SUB-TOTAL | $22.42 | |||||||||||||
| - | - | - | - | are not included in the loaded | 0 | 0.00 | $0.00 | |||||||||||||||
| TOTALS | 1 | $18.31 | rate for Store Worker I | 0 | 0.00 | 0.00 | HOLIDAYS/SICK/VACATIONS | $0.99 | ||||||||||||||
| = | = | = | = | 0 | 0.00 | 0.00 | HOL & VAC. HEALTH & WELFARE | $0.16 | ||||||||||||||
| Indirect Labor Hours (Non-Working) | 0 | 0.00 | 0.00 | = | = | |||||||||||||||||
| = | 0 | 0.00 | 0.00 | SUB-TOTAL | $1.15 | |||||||||||||||||
| Direct Labor Hours (Productive/Working) | 1 | 0 | 0.00 | 0.00 | ||||||||||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $2.06 | |||||||||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||||||||
| = | = | = | = | = | = | 0 | 0.00 | 0.00 | PENSION | $3.38 | ||||||||||||
| TOTALS | $1.04 | $3.38 | 0 | 0.00 | 0.00 | |||||||||||||||||
| Direct Labor Health and Welfare | = | = | = | = | = | = | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | |||||||||||
| 0 | 0.00 | 0.00 | - | |||||||||||||||||||
| H&W | H&W | 0 | 0.00 | 0.00 | SUB-TOTAL | $29.02 | ||||||||||||||||
| COST ELEMENT | Hours | Rates | Cost | 0 | 0.00 | 0.00 | = | |||||||||||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | ||||||||||||
| Lead Warehouse Specialist | 1 | $4.11 | $4.11 | 0 | 0.00 | 0.00 | ||||||||||||||||
| = | = | = | = | = | = | PROFIT | 0.00% | $0.00 | ||||||||||||||
| TOTALS | 0 | 0.00 | $0.00 | |||||||||||||||||||
| = | = | = | = | = | = | = | ||||||||||||||||
| GRAND TOTAL | $29.02 | |||||||||||||||||||||
| = | = | = | ||||||||||||||||||||
| - | - | - | - | |||||||||||||||||||
| TOTALS | 1 | $4.11 | ||||||||||||||||||||
| = | = | = | = | |||||||||||||||||||
| Holidays, Sick and Vacations | ||||||||||||||||||||||
| Holidays, Sick, | ||||||||||||||||||||||
| Sick/ | Vacations | |||||||||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||||||||
| = | = | = | = | = | ||||||||||||||||||
| Lead Warehouse Specialist | 10 | 0 | $0.99 | (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.99 | ||||||||||||||||||||
| = | = | = | = | |||||||||||||||||||
| Holidays and Vacations Health & Welfare | ||||||||||||||||||||||
| Holidays/Sick/ | H&W | H&W | ||||||||||||||||||||
| COST ELEMENT | Vacations | Rates | Cost | |||||||||||||||||||
| = | = | = | = | = | ||||||||||||||||||
| Lead Warehouse Specialist | 0 | $4.11 | $0.16 | |||||||||||||||||||
| - | - | - | - | |||||||||||||||||||
| TOTALS | 0 | $0.16 | ||||||||||||||||||||
| = | = | = | = | |||||||||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||||||||
| = | = | = | = | = | = | |||||||||||||||||
| DIRECT LABOR COST | $18.31 | |||||||||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $4.11 | |||||||||||||||||||||
| HOLIDAYS/SICK/VACATION | $0.99 | |||||||||||||||||||||
| PENSION | $3.38 | |||||||||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0.16 | |||||||||||||||||||||
| - | - | - | - | - | - | |||||||||||||||||
| SUBTOTAL | $26.95 | |||||||||||||||||||||
| = | = | = | = | = | = | |||||||||||||||||
| FICA | X | 7.65% | = | $2.06 | ||||||||||||||||||
| 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.06 | |||||||||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Custodian Loaded Wage Rate
| Attachment 4 | Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||||||
| SOLICITATION NUMBER: | HDEC08-17-R-0010 | SOLICITATION NUMBER: | HDEC08-17-R-0010 | SOLICITATION NUMBER: | HDEC08-17-R-0010 | SOLICITATION NUMBER: | HDEC08-17-R-0010 | ||||||||||||||
| COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | ||||||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||||||
| Custodian Loaded Wage Rate Work Sheet | Custodian Loaded Wage Rate Work Sheet | Custodian Loaded Wage Rate Work Sheet | Custodian Loaded Wage Rate Work Sheet | ||||||||||||||||||
| Direct Labor | Contractor Proposed Pension | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||||||
| (The labor categories below are SAMPLES) | Shelf Stocking Supplies & Equipment | ================ | |||||||||||||||||||
| CBA | |||||||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | (Schedule A - $3.25/hour per Bargaining Union Employee) | $3.25 | (The elements listed below are SAMPLES and are not considered | |||||||||||||||
| = | = | = | = | = | a requirement of the solicitation.) | ||||||||||||||||
| Custodian | 1 | $16.15 | $16.15 | COST ELEMENT | DOLLARS | ||||||||||||||||
| = | = | ||||||||||||||||||||
| Hours + | Extended | Qty. | Unit/ | Extended | DIRECT LABOR | $16.15 | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | Labor Categories | Holiday/Sick/Vacation | Price | Elements | Yearly | Price | Price | DIRECT LABOR HEALTH & WELFARE | $4.11 | ||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | = | = | = | = | = | = | = | = | = | = | = | = | = | = | |||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | Custodian | 1 | $3.38 | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | SUB-TOTAL | $20.26 | ||||||||||||
| - | - | - | - | are not included in the loaded | 0 | 0.00 | $0.00 | ||||||||||||||
| TOTALS | 1 | $16.15 | rate for Store Worker I | 0 | 0.00 | 0.00 | HOLIDAYS/SICK/VACATIONS | $0.87 | |||||||||||||
| = | = | = | = | 0 | 0.00 | 0.00 | HOL & VAC. HEALTH & WELFARE | $0.16 | |||||||||||||
| Indirect Labor Hours (Non-Working) | 0 | 0.00 | 0.00 | = | = | ||||||||||||||||
| = | 0 | 0.00 | 0.00 | SUB-TOTAL | $1.04 | ||||||||||||||||
| Direct Labor Hours (Productive/Working) | 1 | 0 | 0.00 | 0.00 | |||||||||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.89 | ||||||||||||||||
| 0 | 0.00 | 0.00 | |||||||||||||||||||
| = | = | = | = | = | = | 0 | 0.00 | 0.00 | PENSION | $3.38 | |||||||||||
| TOTALS | $1.04 | $3.38 | 0 | 0.00 | 0.00 | ||||||||||||||||
| Direct Labor Health and Welfare | = | = | = | = | = | = | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||
| 0 | 0.00 | 0.00 | - | ||||||||||||||||||
| H&W | H&W | 0 | 0.00 | 0.00 | SUB-TOTAL | $26.56 | |||||||||||||||
| COST ELEMENT | Hours | Rates | Cost | 0 | 0.00 | 0.00 | = | ||||||||||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||||||
| Custodian | 1 | $4.11 | $4.11 | 0 | 0.00 | 0.00 | |||||||||||||||
| = | = | = | = | = | = | PROFIT | 0.00% | $0.00 | |||||||||||||
| TOTALS | 0 | 0.00 | $0.00 | ||||||||||||||||||
| = | = | = | = | = | = | = | |||||||||||||||
| GRAND TOTAL | $26.56 | ||||||||||||||||||||
| = | = | = | |||||||||||||||||||
| - | - | - | - | ||||||||||||||||||
| TOTALS | 1 | $4.11 | |||||||||||||||||||
| = | = | = | = | ||||||||||||||||||
| Holidays, Sick and Vacations | |||||||||||||||||||||
| Holidays, Sick, | |||||||||||||||||||||
| Sick/ | Vacations | ||||||||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | ||||||||||||||||||
| = | = | = | = | = | |||||||||||||||||
| Custodian | 10 | 0 | $0.87 | (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.87 | |||||||||||||||||||
| = | = | = | = | ||||||||||||||||||
| Holidays and Vacations Health & Welfare | |||||||||||||||||||||
| Holidays/Sick/ | H&W | H&W | |||||||||||||||||||
| COST ELEMENT | Vacations | Rates | Cost | ||||||||||||||||||
| = | = | = | = | = | |||||||||||||||||
| Custodian | 0 | $4.11 | $0.16 | ||||||||||||||||||
| - | - | - | - | ||||||||||||||||||
| TOTALS | 0 | $0.16 | |||||||||||||||||||
| = | = | = | = | ||||||||||||||||||
| FRINGE CALCULATIONS | |||||||||||||||||||||
| COST ELEMENT | DOLLARS | ||||||||||||||||||||
| = | = | = | = | = | = | ||||||||||||||||
| DIRECT LABOR COST | $16.15 | ||||||||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $4.11 | ||||||||||||||||||||
| HOLIDAYS/SICK/VACATION | $0.87 | ||||||||||||||||||||
| PENSION | $3.38 | ||||||||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0.16 | ||||||||||||||||||||
| - | - | - | - | - | - | ||||||||||||||||
| SUBTOTAL | $24.68 | ||||||||||||||||||||
| = | = | = | = | = | = | ||||||||||||||||
| FICA | X | 7.65% | = | $1.89 | |||||||||||||||||
| 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.89 | ||||||||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Lead Custodian Loaded Wage Rate
| Attachment 4 | Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||||||
| SOLICITATION NUMBER: | HDEC08-17-R-0010 | SOLICITATION NUMBER: | HDEC08-17-R-0010 | SOLICITATION NUMBER: | HDEC08-17-R-0010 | SOLICITATION NUMBER: | HDEC08-17-R-0010 | ||||||||||||||
| COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | COMMISSARY: | USAF Academy, Colorado | ||||||||||||||
| CONTRACTOR NAME: | 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 | Lead Custodian Loaded Wage Rate Work Sheet | ||||||||||||||||||
| Direct Labor | Contractor Proposed Pension | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||||||
| (The labor categories below are SAMPLES) | Shelf Stocking Supplies & Equipment | ================ | |||||||||||||||||||
| CBA | |||||||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | (Schedule A - $3.25/hour per Bargaining Union Employee) | $3.25 | (The elements listed below are SAMPLES and are not considered | |||||||||||||||
| = | = | = | = | = | a requirement of the solicitation.) | ||||||||||||||||
| Lead Custodian | 1 | $17.15 | $17.15 | COST ELEMENT | DOLLARS | ||||||||||||||||
| = | = | ||||||||||||||||||||
| Hours + | Extended | Qty. | Unit/ | Extended | DIRECT LABOR | $17.15 | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | Labor Categories | Holiday/Sick/Vacation | Price | Elements | Yearly | Price | Price | DIRECT LABOR HEALTH & WELFARE | $4.11 | ||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | = | = | = | = | = | = | = | = | = | = | = | = | = | = | |||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | Lead Custodian | 1 | $3.38 | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | SUB-TOTAL | $21.26 | ||||||||||||
| - | - | - | - | are not included in the loaded | 0 | 0.00 | $0.00 | ||||||||||||||
| TOTALS | 1 | $17.15 | rate for Store Worker I | 0 | 0.00 | 0.00 | HOLIDAYS/SICK/VACATIONS | $0.93 | |||||||||||||
| = | = | = | = | 0 | 0.00 | 0.00 | HOL & VAC. HEALTH & WELFARE | $0.16 | |||||||||||||
| Indirect Labor Hours (Non-Working) | 0 | 0.00 | 0.00 | = | = | ||||||||||||||||
| = | 0 | 0.00 | 0.00 | SUB-TOTAL | $1.09 | ||||||||||||||||
| Direct Labor Hours (Productive/Working) | 1 | 0 | 0.00 | 0.00 | |||||||||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.97 | ||||||||||||||||
| 0 | 0.00 | 0.00 | |||||||||||||||||||
| = | = | = | = | = | = | 0 | 0.00 | 0.00 | PENSION | $3.38 | |||||||||||
| TOTALS | $1.04 | $3.38 | 0 | 0.00 | 0.00 | ||||||||||||||||
| Direct Labor Health and Welfare | = | = | = | = | = | = | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||
| 0 | 0.00 | 0.00 | - | ||||||||||||||||||
| H&W | H&W | 0 | 0.00 | 0.00 | SUB-TOTAL | $27.70 | |||||||||||||||
| COST ELEMENT | Hours | Rates | Cost | 0 | 0.00 | 0.00 | = | ||||||||||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||||||
| Lead Custodian | 1 | $4.11 | $4.11 | 0 | 0.00 | 0.00 | |||||||||||||||
| = | = | = | = | = | = | PROFIT | 0.00% | $0.00 | |||||||||||||
| TOTALS | 0 | 0.00 | $0.00 | ||||||||||||||||||
| = | = | = | = | = | = | = | |||||||||||||||
| GRAND TOTAL | $27.70 | ||||||||||||||||||||
| = | = | = | |||||||||||||||||||
| - | - | - | - | ||||||||||||||||||
| TOTALS | 1 | $4.11 | |||||||||||||||||||
| = | = | = | = | ||||||||||||||||||
| Holidays, Sick and Vacations | |||||||||||||||||||||
| Holidays, Sick, | |||||||||||||||||||||
| Sick/ | Vacations | ||||||||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | ||||||||||||||||||
| = | = | = | = | = | |||||||||||||||||
| Lead Custodian | 10 | 0 | $0.93 | (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.93 | |||||||||||||||||||
| = | = | = | = | ||||||||||||||||||
| Holidays and Vacations Health & Welfare | |||||||||||||||||||||
| Holidays/Sick/ | H&W | H&W | |||||||||||||||||||
| COST ELEMENT | Vacations | Rates | Cost | ||||||||||||||||||
| = | = | = | = | = | |||||||||||||||||
| Lead Custodian | 0 | $4.11 | $0.16 | ||||||||||||||||||
| - | - | - | - | ||||||||||||||||||
| TOTALS | 0 | $0.16 | |||||||||||||||||||
| = | = | = | = | ||||||||||||||||||
| FRINGE CALCULATIONS | |||||||||||||||||||||
| COST ELEMENT | DOLLARS | ||||||||||||||||||||
| = | = | = | = | = | = | ||||||||||||||||
| DIRECT LABOR COST | $17.15 | ||||||||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $4.11 | ||||||||||||||||||||
| HOLIDAYS/SICK/VACATION | $0.93 | ||||||||||||||||||||
| PENSION | $3.38 |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .