The file's text, extracted by GovTribe without its formatting.
Cost Breakout
| Amendment 0002 |
| Attachment 4 | |
| HDEC08-17-R-0006 | |
| 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
| 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
| Amendment 0002 | | | | |
| SOLICITATION NUMBER: | HDEC08-17-R-0006 | SOLICITATION NUMBER: | HDEC08-17-R-0006 | SOLICITATION NUMBER: | HDEC08-17-R-0006 |
| COMMISSARY: | Vance AFB | COMMISSARY: | Vance AFB | COMMISSARY: | Vance AFB |
| CONTRACTOR NAME: | | CONTRACTOR NAME: | | CONTRACTOR NAME: | |
Shelf Stocking Operations Work Sheet Shelf Stocking Operations Work Sheet Shelf Stocking Operations Work Sheet
| Direct Labor | | | | | | Contractor Proposed | | | | | | | | DOLLAR TOTALS | | | |
| | | | | | Shelf Stocking Supplies & Equipment | | | | | | | | ================ | | | |
| | | WDR | | | | | | | | | | | | | | |
| COST ELEMENT | | Hours X | Rates = | Labor Cost | | (The elements listed below are SAMPLES and are not considered | | | | | | | | | | | |
| = | = | = | = | = | | a requirement of the solicitation.) | | | | | | | | | | | |
| Store Worker I | | 0 | 13.94 | $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 |
| | | | | | | | | 0 | 0.00 | $0.00 | | | | | | - |
| | | H&W | H&W | | | | | 0 | 0.00 | $0.00 | | SUB-TOTAL | | | | $0.00 |
| COST ELEMENT | | Hours X | Rates = | Cost | | | | | 0 | 0.00 | $0.00 | | | | | | = |
| = | = | = | = | = | | | | | 0 | 0.00 | $0.00 | | G&A | 0.00% | | | $0.00 |
| Store Worker I | | 0 | 4.27 | $0.00 | | | | | 0 | 0.00 | $0.00 | | | | | | |
| Project Manager | | 0 | 4.27 | $0.00 | | | | | 0 | 0.00 | $0.00 | | PROFIT | 0.00% | | | $0.00 |
| | 0 | 4.27 | $0.00 | | | | | 0 | 0.00 | $0.00 | | | | | | |
| | 0 | 4.27 | $0.00 | | | | | 0 | 0.00 | $0.00 | | = | | | | = |
| | 0 | 4.27 | $0.00 | | | | | 0 | 0.00 | $0.00 | | GRAND TOTAL | | | | $0.00 |
| | 0 | 4.27 | $0.00 | | | | | 0 | 0.00 | $0.00 | | = | | = | = | = |
| - | - | - | | - | | | | | 0 | 0.00 | $0.00 | | | | ANNUAL CASES | | 88,692 |
| 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 | | | | | | |
| Store Worker I | | 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 | | | | | | | | | | | | | | | | | |
| | Holidays/Sick/ | | |
| | Vacations | H&W | H&W |
| COST ELEMENT | | Hours X | Rates = | Cost |
| = | = | = | = | = |
| Store Worker I | | 0 | 4.27 | $0.00 |
| Project Manager | | 0 | 4.27 | $0.00 |
| | 0 | 4.27 | $0.00 |
| | 0 | 4.27 | $0.00 |
| | 0 | 4.27 | $0.00 |
| | 0 | 4.27 | $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, 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
| Amendment 0002 | | | | |
| SOLICITATION NUMBER: | HDEC08-17-R-0006 | SOLICITATION NUMBER: | HDEC08-17-R-0006 | SOLICITATION NUMBER: | HDEC08-17-R-0006 |
| COMMISSARY: | Vance AFB | COMMISSARY: | Vance AFB | COMMISSARY: | Vance AFB |
| CONTRACTOR NAME: | | CONTRACTOR NAME: | | CONTRACTOR NAME: | |
| R/S/H Operations Work Sheet | | R/S/H Operations Work Sheet | | R/S/H Operations Work Sheet | |
| Direct Labor | | | | | | | Contractor Proposed | | | | | DOLLAR TOTALS | | | | |
| | | | | | R/S/H Supplies & Equipment | | | | | | ================ | | | | |
| | | WDR | | | | | | | | | | | | | |
| COST ELEMENT | | Hours X | Rates = | Labor Cost | | (The elements listed below are SAMPLES and are not to be considered | | | | | | | | | | |
| = | = | = | = | = | | a requirement of the solicitation.) | | | | | | | | | | |
| Material Handling Laborer | | 0 | 11.10 | $0.00 | | | | | | | | COST ELEMENT | | | | DOLLARS |
| Forklift Operator | | 0 | 15.25 | $0.00 | | | | | | | | = | | | | = |
| Warehouse Specialist | | 0 | 15.25 | $0.00 | | | | | Qty. | Unit/ | Extended | DIRECT LABOR | | | | 0.00 |
| Project Manager | | 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 |
| | | | | | | | | 0 | 0.00 | 0.00 | | | | | - |
| | | H&W | H&W | | | | | 0 | 0.00 | 0.00 | SUB-TOTAL | | | | 0.00 |
| COST ELEMENT | | Hours X | Rates = | Cost | | | | | 0 | 0.00 | 0.00 | | | | | = |
| = | = | = | = | = | | | | | 0 | 0.00 | 0.00 | G&A | 0.00% | | | 0.00 |
| Material Handling Laborer | | 0 | 4.27 | $0.00 | | | | | 0 | 0.00 | 0.00 | | | | | |
| Forklift Operator | | 0 | 4.27 | $0.00 | | | | | 0 | 0.00 | 0.00 | PROFIT | 0.00% | | | 0.00 |
| Warehouse Specialist | | 0 | 4.27 | $0.00 | | | | | 0 | 0.00 | 0.00 | | | | | |
| Project Manager | | 0 | 4.27 | $0.00 | | | | | 0 | 0.00 | 0.00 | = | | | | = |
| | 0 | 4.27 | $0.00 | | | | | 0 | 0.00 | 0.00 | GRAND TOTAL | | | | 0.00 |
| | 0 | 4.27 | $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 | | | | | |
| Material Handling Laborer | | 10 | 0 | $0.00 | ( (Holidays + Vacations) * 8) | | | | 0 | 0.00 | 0.00 | | | | | |
| Forklift Operator | | 10 | 0 | $0.00 | times Work Hours | = | = | = | = | | = | | | | | |
| Warehouse Specialist | | 10 | 0 | $0.00 | divided by ( 2080 hours - | TOTALS | | | 0 | | $0.00 | | | | | |
| Project Manager | | 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 | | | | | | | | | | | | | | | | |
| | Holidays/Sick/ | | |
| | Vacations | H&W | H&W |
| COST ELEMENT | | Hours X | Rates = | Cost |
| = | = | = | = | = |
| Material Handling Laborer | | 0 | 4.27 | $0.00 |
| Forklift Operator | | 0 | 4.27 | $0.00 |
| Warehouse Specialist | | 0 | 4.27 | $0.00 |
| Project Manager | | 0 | 4.27 | $0.00 |
| | 0 | 4.27 | $0.00 |
| | 0 | 4.27 | $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, 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 |
| = | = | = | = | = | = |
Print
Custodial
| Amendment 0002 | | | | |
| SOLICITATION NUMBER: | HDEC08-17-R-0006 | SOLICITATION NUMBER: | HDEC08-17-R-0006 | SOLICITATION NUMBER: | HDEC08-17-R-0006 |
| COMMISSARY: | Vance AFB | COMMISSARY: | Vance AFB | COMMISSARY: | Vance AFB |
| CONTRACTOR NAME: | | CONTRACTOR NAME: | | CONTRACTOR NAME: | |
| Custodial Operations Work Sheet | | Custodial Operations Work Sheet | | Custodial Operations Work Sheet | |
| Direct Labor | | | | | | Contractor Proposed | | | | | | DOLLAR TOTALS | | | | |
| | | | | | Custodial Supplies & Equipment | | | | | | ================ | | | | |
| | | WDR | | | | | | | | | | | | | |
| COST ELEMENT | | Hours X | Rates = | Labor Cost | | (The elements listed below are SAMPLES and are not to be considered | | | | | | | | | | |
| = | = | = | = | = | | a requirement of the solicitation.) | | | | | | | | | | |
| Janitor | | 0 | 10.20 | $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 |
| | | | | | Floor Sealer | | | 0 | 0.00 | 0.00 | | | | | - |
| | | H&W | H&W | | Floor Stripper | | | 0 | 0.00 | 0.00 | SUB-TOTAL | | | | 0.00 |
| COST ELEMENT | | Hours X | Rates = | Cost | | Gloves | | | 0 | 0.00 | 0.00 | | | | | = |
| = | = | = | = | = | | Gloves, Latex | | | 0 | 0.00 | 0.00 | G&A | 0.00% | | | 0.00 |
| Janitor | | 0 | 4.27 | $0.00 | | Kintowel Wiper | | | 0 | 0.00 | 0.00 | | | | | |
| Project Manager | | 0 | 4.27 | $0.00 | | LiquidLive | | | 0 | 0.00 | 0.00 | PROFIT | 0.00% | | | 0.00 |
| | 0 | 4.27 | $0.00 | | Masks | | | 0 | 0.00 | 0.00 | | | | | |
| | 0 | 4.27 | $0.00 | | Mop Head, Wet | | | 0 | 0.00 | 0.00 | = | | | | = |
| | 0 | 4.27 | $0.00 | | Neutralizer | | | 0 | 0.00 | 0.00 | GRAND TOTAL | | | | 0.00 |
| | 0 | 4.27 | $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 | | | | | |
| Janitor | | 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 | | | | | |
| | | | | | Visors | | | 0 | 0.00 | 0.00 | | | | | |
| | Holidays/Sick/ | | | | Battery Charger | | | 0 | 0.00 | 0.00 | | | | | |
| | Vacations | H&W | H&W | | 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 | | | | | |
| Janitor | | 0 | 4.27 | $0.00 | | Caddy, Maid | | | 0 | 0.00 | 0.00 | | | | | |
| Project Manager | | 0 | 4.27 | $0.00 | | Carpet Extractor | | | 0 | 0.00 | 0.00 | | | | | |
| | 0 | 4.27 | $0.00 | | Floor Scrubber, Low Speed | | | 0 | 0.00 | 0.00 | | | | | |
| | 0 | 4.27 | $0.00 | | Scrubber, 20" | | | 0 | 0.00 | 0.00 | | | | | |
| | 0 | 4.27 | $0.00 | | Scrubber, Auto | | | 0 | 0.00 | 0.00 | | | | | |
| | 0 | 4.27 | $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, 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 |
| = | = | = | = | = | = |
Print
Year Totals
| Amendment 0002 |
| SOLICITATION NUMBER: | HDEC08-17-R-0006 |
| COMMISSARY: | Vance AFB |
| CONTRACTOR NAME: | |
| BASE YEAR GRAND TOTALS | |
| DOLLAR TOTALS |
| ================ |
| COST ELEMENT | DOLLARS |
| = | = |
| DIRECT LABOR | 0.00 |
| DIRECT LABOR HEALTH & WELFARE | 0.00 |
| = | = |
| TOTAL | 0.00 |
| HOLIDAYS, SICK & VACATIONS | 0.00 |
| HOL, SICK & VAC. HEALTH & WELFARE | 0.00 |
| = | = |
| TOTAL | 0.00 |
FRINGE CALCULATIONS 0.00
SUPPLIES & EQUIPMENT 0.00
SUB-TOTAL 0.00
G&A 0.00
PROFIT 0.00
Print
5 Yr. Totals
| Amendment 0002 |
| SOLICITATION NUMBER: | HDEC08-17-R-0006 |
| COMMISSARY: | Vance AFB |
| CONTRACTOR NAME: | |
| GRAND TOTALS |
| BASE YEAR | OPTION 1 | OPTION 2 | OPTION 3 | OPTION 4 | GRAND |
| COST ELEMENT | DOLLARS | DOLLARS | DOLLARS | DOLLARS | DOLLARS | TOTALS |
| = | = | = | = | = | = | = |
| DIRECT LABOR | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| DIRECT LABOR HEALTH & WELFARE | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| = | = | = | = | = | = | = |
| TOTAL | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| HOLIDAYS, SICK & VACATIONS | | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| HOL, SICK & VAC. HEALTH & WELFARE | | 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: | HDEC08-17-R-0006 | | | | |
| COMMISSARY: | Vance AFB | | | | |
| CONTRACTOR NAME: | | | | | |
| ESCALATION FACTORS | | | | |
| | OPTION 1 | OPTION 2 | OPTION 3 | OPTION 4 |
| COST ELEMENT | | DOLLARS | DOLLARS | DOLLARS | DOLLARS |
| = | = | = | = | = | = |
| DIRECT LABOR | | 0.00% | 0.00% | 0.00% | 0.00% |
| DIRECT LABOR HEALTH & WELFARE | | 0.00% | 0.00% | 0.00% | 0.00% |
| = | = | = | = | = | = |
| TOTAL | | | | | |
| HOLIDAYS AND VACATIONS | | 0.00% | 0.00% | 0.00% | 0.00% |
| HOLIDAYS AND VACATIONS. HEALTH & WELFARE | | 0.00% | 0.00% | 0.00% | 0.00% |
| = | = | = | = | = | = |
| TOTAL | | | | | |
| FRINGE CALCULATIONS | | 0.00% | 0.00% | 0.00% | 0.00% |
| SUPPLIES & EQUIPMENT | | 0.00% | 0.00% | 0.00% | 0.00% |
| SUB-TOTAL | | | | | |
| G&A | | 0.00% | 0.00% | 0.00% | 0.00% |
| PROFIT | | 0.00% | 0.00% | 0.00% | 0.00% |
| = | = | = | = | = | = |
| GRAND TOTAL | | | | | |
| = | = | = | = | = | = |
Click Here to Print
Shelf Stocker Loaded Wage Rate
| Amendment 0002 | | | | |
| Attachment 4 | | Attachment 4 | | Attachment 4 |
| SOLICITATION NUMBER: | HDEC08-17-R-0006 | SOLICITATION NUMBER: | HDEC08-17-R-0006 | SOLICITATION NUMBER: | HDEC08-17-R-0006 |
| COMMISSARY: | Vance AFB | COMMISSARY: | Vance AFB | COMMISSARY: | Vance AFB |
| 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 | | | | | | | | | | | |
| = | = | = | = | = | | | | | | | | | | | |
| Store Worker I | | 1 | 13.94 | $13.94 | | | | | | | COST ELEMENT | | | | DOLLARS |
| | | | | | | | | | | = | | | | = |
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | | | | | | | | | | | DIRECT LABOR | | | | $13.94 |
| CALCULATE THE LOADED HOURLY RATE. PROCEED | | | | | | | | | | | DIRECT LABOR HEALTH & WELFARE | | | | $4.27 |
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | | | | | | | | | | | = | | | | = |
| | | | | | | | Qty. | Unit/ | Extended | SUB-TOTAL | | | | $18.21 |
| - | - | - | | - | Elements | | | Yearly | Price | Price | | | | | |
| TOTALS | | 1 | | $13.94 | = | = | = | = | = | = | HOLIDAYS, SICK & VACATIONS | | | | $0.75 |
| = | = | = | | = | Supplies and Equipment Costs | | | 0 | 0.00 | $0.00 | HOL, SICK & VAC. HEALTH & WELFARE | | | | $0.17 |
| 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 | | | | $0.92 |
| Direct Labor Hours (Productive/Working) | | 1 | | | | | | 0 | 0.00 | 0.00 | | | | | |
| | = | | | | | | 0 | 0.00 | 0.00 | FRINGES | | | | $1.46 |
| | | | | | | | 0 | 0.00 | 0.00 | | | | | |
| | | | | | | | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | | | | $0.00 |
| Direct Labor Health and Welfare | | | | | | | | 0 | 0.00 | 0.00 | | | | | - |
| | | | | | | | 0 | 0.00 | 0.00 | SUB-TOTAL | | | | $20.60 |
| | | H&W | H&W | | | | 0 | 0.00 | 0.00 | | | | | = |
| COST ELEMENT | | Hours | Rates | Cost | | | | 0 | 0.00 | 0.00 | G&A | 0.00% | | | $0.00 |
| = | = | = | = | = | | | | 0 | 0.00 | 0.00 | | | | | |
| Store Worker I | | 1 | 4.27 | $4.27 | | | | 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 | | | | $20.60 |
| | | | | | | | 0 | 0.00 | 0.00 | = | | = | = | = |
| 0 | | | | | = | = | = | = | = | = | | | | | |
| - | - | - | | - | TOTALS | | | | | $0.00 | | | | | |
| TOTALS | | 1 | | $4.27 | = | = | = | = | = | | | | | | |
| = | = | = | | = | | | | | | | | | | | |
| Holidays, Sick, and Vacations | | | | | |
| | | | Holidays/ | |
| | | Sick/ | Sick/Vacations | |
| COST ELEMENT | | Holidays | Vacations | Dollars | |
| = | = | = | = | = | |
| Store Worker I | | 10 | 0 | $0.75 | |
| | | | | (Work hours divided by ((2080 hours- |
| | | | | (Holidays/Sick+ Vacations)*8))) * |
| | | | | ((Closed Holidays*8*Hourly rate)+ |
| | | | | (Holidays worked*8*Hourly rate* time & half))+ |
| 0 | | | | | (Work Hours divided by(2080-((Holidays/Sick+ |
| - | - | - | | - | Vacations)*8)))*(Vacations *8*Hourly rate) |
| TOTALS | | 10 | | $0.75 | |
| = | = | = | | = | |
| Holidays, Sick, and Vacations Health & Welfare | | | | |
| | Holidays/Sick/ | | |
| | Vacations | H&W | H&W |
| COST ELEMENT | | Hours X | Rates | Cost |
| = | = | = | = | = |
| Store Worker I | | 0.0 | 4.27 | $0.17 |
FRINGE CALCULATIONS
| COST ELEMENT | | | | | DOLLARS |
| = | = | = | = | = | = |
| DIRECT LABOR COST | | | | | $13.94 |
| DIRECT HEALTH & WELFARE COSTS | | | | | $4.27 |
| HOLIDAYS, SICK AND VACATIONS | | | | | $0.75 |
| HOLIDAYS, SICK, VACATIONS HEALTH & WELFARE | | | | | $0.17 |
| - | - | - | - | - | - |
| SUBTOTAL | | | | | $19.13 |
| = | = | = | = | = | = |
| FICA | X | 7.65% | | = | $1.46 |
| 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.46 |
| = | = | = | = | = | = |
Print
Material Handler Loaded Wage
| Amendment 0002 | | | | |
| Attachment 4 | | Attachment 4 | | Attachment 4 |
| SOLICITATION NUMBER: | HDEC08-17-R-0006 | SOLICITATION NUMBER: | HDEC08-17-R-0006 | SOLICITATION NUMBER: | HDEC08-17-R-0006 |
| COMMISSARY: | Vance AFB | COMMISSARY: | Vance AFB | COMMISSARY: | Vance AFB |
| CONTRACTOR NAME: | | CONTRACTOR NAME: | | CONTRACTOR NAME: | |
MATERIAL HANDLER LOADED WAGE RATE WORK SHEET MATERIAL HANDLER LOADED WAGE RATE WORK SHEET MATERIAL HANDLER LOADED WAGE RATE WORK SHEET
| Direct Labor | | | | | Contractor Proposed | | | | | | | DOLLAR TOTALS | | | |
| | | | | R/S/H Supplies & Equipment | | | | | | | ================ | | | |
| | | WD | | | | | | | | | | | | |
| COST ELEMENT | | Hours X | Rates = | Labor Cost | | | | | | | | | | | |
| = | = | = | = | = | | | | | | | | | | | |
| Material Handler | | 1 | 11.10 | $11.10 | | | | | | | COST ELEMENT | | | | DOLLARS |
| | | | | | | | | | | = | | | | = |
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | | | | | | | | | | | DIRECT LABOR | | | | $11.10 |
| CALCULATE THE LOADED HOURLY RATE. PROCEED | | | | | | | | | | | DIRECT LABOR HEALTH & WELFARE | | | | $4.27 |
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | | | | | | | | | | | = | | | | = |
| | | | | | | | | | | SUB-TOTAL | | | | $15.37 |
| - | - | - | | - | | | | Qty. | Unit/ | Extended | | | | | |
| TOTALS | | 1 | | $11.10 | Elements | | | Yearly | Price | Price | HOLIDAYS, SICK & VACATIONS | | | | $0.60 |
| = | = | = | | = | = | = | = | = | = | = | HOL, SICK & VAC. HEALTH & WELFARE | | | | $0.17 |
| 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 | | | | $0.77 |
| Direct Labor Hours (Productive/Working) | | 1 | | | rate for Material Handler | | | 0 | 0.00 | 0.00 | | | | | |
| | = | | | | | | 0 | 0.00 | 0.00 | FRINGES | | | | $1.23 |
| | | | | | | | 0 | 0.00 | 0.00 | | | | | |
| | | | | | | | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | | | | $0.00 |
| Direct Labor Health and Welfare | | | | | | | | 0 | 0.00 | 0.00 | | | | | - |
| | | | | | | | 0 | 0.00 | 0.00 | SUB-TOTAL | | | | $17.37 |
| | | H&W | H&W | | | | 0 | 0.00 | 0.00 | | | | | = |
| COST ELEMENT | | Hours | Rates | Cost | | | | 0 | 0.00 | 0.00 | G&A | 0.00% | | | $0.00 |
| = | = | = | = | = | | | | 0 | 0.00 | 0.00 | | | | | |
| Material Handler | | 1 | 4.27 | $4.27 | | | | 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 | | | | $17.37 |
| | | | | | | | 0 | 0.00 | 0.00 | = | | = | = | = |
| | | | | | | | 0 | 0.00 | 0.00 | | | | | |
| - | - | - | | - | = | = | = | = | = | = | | | | | |
| TOTALS | | 1 | | $4.27 | TOTALS | | | | | $0.00 | | | | | |
| = | = | = | | = | = | = | = | = | = | | | | | | |
| Holidays, Sick, and Vacations | | | | | |
| | | | Holidays/ | |
| | | Sick/ | Sick/Vacations | |
| COST ELEMENT | | Holidays | Vacations | Dollars | |
| = | = | = | = | = | |
| Material Handler | | 10 | 0 | $0.60 | |
| | | | $0.00 | (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+ |
| - | - | - | | - | Vacations)*8)))*(Vacations *8*Hourly rate) |
| TOTALS | | 10 | | $0.60 | |
| = | = | = | | = | |
| Holidays, Sick, and Vacations Health & Welfare | | | | |
| | Holidays/Sick/ | | |
| | Vacations | H&W | H&W |
| COST ELEMENT | | Hours X | Rates | Cost |
| = | = | = | = | = |
| Material Handler | | 0 | 4.27 | $0.17 |
FRINGE CALCULATIONS
| COST ELEMENT | | | | | DOLLARS |
| = | = | = | = | = | = |
| DIRECT LABOR COST | | | | | $11.10 |
| DIRECT HEALTH & WELFARE COSTS | | | | | $4.27 |
| HOLIDAYS, SICK AND VACATIONS | | | | | $0.60 |
| HOLIDAYS, SICK, VACATIONS HEALTH & WELFARE | | | | | $0.17 |
| - | - | - | - | - | - |
| SUBTOTAL | | | | | $16.14 |
| = | = | = | = | = | = |
| FICA | X | 7.65% | | = | $1.23 |
| 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.23 |
| = | = | = | = | = | = |
Print
Forklift Operator Loaded Wage
| Amendment 0002 | | | | |
| Attachment 4 | | Attachment 4 | | Attachment 4 |
| SOLICITATION NUMBER: | HDEC08-17-R-0006 | SOLICITATION NUMBER: | HDEC08-17-R-0006 | SOLICITATION NUMBER: | HDEC08-17-R-0006 |
| COMMISSARY: | Vance AFB | COMMISSARY: | Vance AFB | COMMISSARY: | Vance AFB |
| CONTRACTOR NAME: | | CONTRACTOR NAME: | | CONTRACTOR NAME: | |
Forklift Operator Loaded Wage Rate Work Sheet Forklift Operator Loaded Wage Rate Work Sheet Forklift Operator Loaded Wage Rate Work Sheet
| Direct Labor | | | | | Contractor Proposed | | | | | | | DOLLAR TOTALS | | | |
| | | | | R/S/H Supplies & Equipment | | | | | | | ================ | | | |
| | | WD | | | | | | | | | | | | |
| COST ELEMENT | | Hours X | Rates = | Labor Cost | | | | | | | | | | | |
| = | = | = | = | = | | | | | | | | | | | |
| Forklift Operator | | 1 | 15.25 | $15.25 | | | | | | | COST ELEMENT | | | | DOLLARS |
| | | | | | | | | | | = | | | | = |
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | | | | | | | | | | | DIRECT LABOR | | | | $15.25 |
| CALCULATE THE LOADED HOURLY RATE. PROCEED | | | | | | | | | | | DIRECT LABOR HEALTH & WELFARE | | | | $4.27 |
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | | | | | | | | | | | = | | | | = |
| | | | | | | | | | | SUB-TOTAL | | | | $19.52 |
| - | - | - | | - | | | | Qty. | Unit/ | Extended | | | | | |
| TOTALS | | 1 | | $15.25 | Elements | | | Yearly | Price | Price | HOLIDAYS, SICK & VACATIONS | | | | $0.82 |
| = | = | = | | = | = | = | = | = | = | = | HOL, SICK & VAC. HEALTH & WELFARE | | | | $0.17 |
| 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 | | | | $0.99 |
| Direct Labor Hours (Productive/Working) | | 1 | | | rate for Forklift Operator | | | 0 | 0.00 | 0.00 | | | | | |
| | = | | | | | | 0 | 0.00 | 0.00 | FRINGES | | | | $1.57 |
| | | | | | | | 0 | 0.00 | 0.00 | | | | | |
| | | | | | | | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | | | | $0.00 |
| Direct Labor Health and Welfare | | | | | | | | 0 | 0.00 | 0.00 | | | | | - |
| | | | | | | | 0 | 0.00 | 0.00 | SUB-TOTAL | | | | $22.08 |
| | | H&W | H&W | | | | 0 | 0.00 | 0.00 | | | | | = |
| COST ELEMENT | | Hours | Rates | Cost | | | | 0 | 0.00 | 0.00 | G&A | 0.00% | | | $0.00 |
| = | = | = | = | = | | | | 0 | 0.00 | 0.00 | | | | | |
| Forklift Operator | | 1 | 4.27 | $4.27 | | | | 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 | | | | $22.08 |
| | | | | | | | 0 | 0.00 | 0.00 | = | | = | = | = |
| | | | | | | | 0 | 0.00 | 0.00 | | | | | |
| - | - | - | | - | = | = | = | = | = | = | | | | | |
| TOTALS | | 1 | | $4.27 | TOTALS | | | | | $0.00 | | | | | |
| = | = | = | | = | = | = | = | = | = | | | | | | |
| Holidays, Sick, and Vacations | | | | | |
| | | | Holidays/ | |
| | | Sick/ | Sick/Vacations | |
| COST ELEMENT | | Holidays | Vacations | Dollars | |
| = | = | = | = | = | |
| Forklift Operator | | 10 | 0 | $0.82 | |
| | | | | (Work hours divided by ((2080 hours- |
| | | | | (Holidays/Sick+ Vacations)*8))) * |
| | | | | ((Closed Holidays*8*Hourly rate)+ |
| | | | | (Holidays worked*8*Hourly rate* time & half))+ |
| | | | | (Work Hours divided by(2080-((Holidays/Sick+ |
| - | - | - | | - | Vacations)*8)))*(Vacations *8*Hourly rate) |
| TOTALS | | 10 | | $0.82 | |
| = | = | = | | = | |
| Holidays, Sick, and Vacations Health & Welfare | | | | |
| | Holidays/Sick/ | | |
| | Vacations | H&W | H&W |
| COST ELEMENT | | Hours X | Rates | Cost |
| = | = | = | = | = |
| Forklift Operator | | 0 | 4.27 | $0.17 |
FRINGE CALCULATIONS
| COST ELEMENT | | | | | DOLLARS |
| = | = | = | = | = | = |
| DIRECT LABOR COST | | | | | $15.25 |
| DIRECT HEALTH & WELFARE COSTS | | | | | $4.27 |
| HOLIDAYS, SICK AND VACATIONS | | | | | $0.82 |
| HOLIDAYS, SICK, VACATIONS HEALTH & WELFARE | | | | | $0.17 |
| - | - | - | - | - | - |
| SUBTOTAL | | | | | $20.51 |
| = | = | = | = | = | = |
| FICA | X | 7.65% | | = | $1.57 |
| FUTA | X | 0.00% | | = | $0.00 |
| SUTA | X | 0.00% | | = | $0.00 |
| Workman's Compensation | X | 0.00% | | = | $0.00 |
| Employer's Liability | X | 0.00% | | = | $0.00 |
| Comprehensive General Liability | X | 0.00% | | = | $0.00 |
| Other | X | 0.00% | | = | $0.00 |
| Other | X | 0.00% | | = | $0.00 |
| - | - | - | - | - | - |
| TOTAL FRINGES | | | | | $1.57 |
| = | = | = | = | = | = |
Print
Warehouse Spec Loaded Wage Rate
| Amendment 0002 | | | | |
| Attachment 4 | | Attachment 4 | | Attachment 4 |
| SOLICITATION NUMBER: | HDEC08-17-R-0006 | SOLICITATION NUMBER: | HDEC08-17-R-0006 | SOLICITATION NUMBER: | HDEC08-17-R-0006 |
| COMMISSARY: | Vance AFB | COMMISSARY: | Vance AFB | COMMISSARY: | Vance AFB |
| 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
| Direct Labor | | | | | Contractor Proposed | | | | | | | DOLLAR TOTALS | | | |
| | | | | R/S/H Supplies & Equipment | | | | | | | ================ | | | |
| | | WD | | | | | | | | | | | | |
| COST ELEMENT | | Hours X | Rates = | Labor Cost | | | | | | | | | | | |
| = | = | = | = | = | | | | | | | | | | | |
| Warehouse Specialist | | 1 | 15.25 | $15.25 | | | | | | | COST ELEMENT | | | | DOLLARS |
| | | | | | | | | | | = | | | | = |
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | | | | | | | | | | | DIRECT LABOR | | | | $15.25 |
| CALCULATE THE LOADED HOURLY RATE. PROCEED | | | | | | | | | | | DIRECT LABOR HEALTH & WELFARE | | | | $4.27 |
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | | | | | | | | | | | = | | | | = |
| | | | | | | | | | | SUB-TOTAL | | | | $19.52 |
| - | - | - | | - | | | | Qty. | Unit/ | Extended | | | | | |
| TOTALS | | 1 | | $15.25 | Elements | | | Yearly | Price | Price | HOLIDAYS, SICK & VACATIONS | | | | $0.82 |
| = | = | = | | = | = | = | = | = | = | = | HOL, SICK & VAC. HEALTH & WELFARE | | | | $0.17 |
| 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 | | | | $0.99 |
| Direct Labor Hours (Productive/Working) | | 1 | | | rate for Forklift Operator | | | 0 | 0.00 | 0.00 | | | | | |
| | = | | | | | | 0 | 0.00 | 0.00 | FRINGES | | | | $1.57 |
| | | | | | | | 0 | 0.00 | 0.00 | | | | | |
| | | | | | | | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | | | | $0.00 |
| Direct Labor Health and Welfare | | | | | | | | 0 | 0.00 | 0.00 | | | | | - |
| | | | | | | | 0 | 0.00 | 0.00 | SUB-TOTAL | | | | $22.08 |
| | | H&W | H&W | | | | 0 | 0.00 | 0.00 | | | | | = |
| COST ELEMENT | | Hours | Rates | Cost | | | | 0 | 0.00 | 0.00 | G&A | 0.00% | | | $0.00 |
| = | = | = | = | = | | | | 0 | 0.00 | 0.00 | | | | | |
| Warehouse Specialist | | 1 | 4.27 | $4.27 | | | | 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 | | | | $22.08 |
| | | | | | | | 0 | 0.00 | 0.00 | = | | = | = | = |
| | | | | | | | 0 | 0.00 | 0.00 | | | | | |
| - | - | - | | - | = | = | = | = | = | = | | | | | |
| TOTALS | | 1 | | $4.27 | TOTALS | | | | | $0.00 | | | | | |
| = | = | = | | = | = | = | = | = | = | | | | | | |
| Holidays, Sick, and Vacations | | | | | |
| | | | Holidays/ | |
| | | Sick/ | Sick/Vacations | |
| COST ELEMENT | | Holidays | Vacations | Dollars | |
| = | = | = | = | = | |
| Warehouse Specialist | | 10 | 0 | $0.82 | |
| | | | | (Work hours divided by ((2080 hours- |
| | | | | (Holidays/Sick+ Vacations)*8))) * |
| | | | | ((Closed Holidays*8*Hourly rate)+ |
| | | | | (Holidays worked*8*Hourly rate* time & half))+ |
| | | | | (Work Hours divided by(2080-((Holidays/Sick+ |
| - | - | - | | - | Vacations)*8)))*(Vacations *8*Hourly rate) |
| TOTALS | | 10 | | $0.82 | |
| = | = | = | | = | |
| Holidays, Sick, and Vacations Health & Welfare | | | | |
| | Holidays/Sick/ | | |
| | Vacations | H&W | H&W |
| COST ELEMENT | | Hours X | Rates | Cost |
| = | = | = | = | = |
| Warehouse Specialist | | 0 | 4.27 | $0.17 |
FRINGE CALCULATIONS
| COST ELEMENT | | | | | DOLLARS |
| = | = | = | = | = | = |
| DIRECT LABOR COST | | | | | $15.25 |
| DIRECT HEALTH & WELFARE COSTS | | | | | $4.27 |
| HOLIDAYS, SICK AND VACATIONS | | | | | $0.82 |
| HOLIDAYS, SICK, VACATIONS HEALTH & WELFARE | | | | | $0.17 |
| - | - | - | - | - | - |
| SUBTOTAL | | | | | $20.51 |
| = | = | = | = | = | = |
| FICA | X | 7.65% | | = | $1.57 |
| FUTA | X | 0.00% | | = | $0.00 |
| SUTA | X | 0.00% | | = | $0.00 |
| Workman's Compensation | X | 0.00% | | = | $0.00 |
| Employer's Liability | X | 0.00% | | = | $0.00 |
| Comprehensive General Liability | X | 0.00% | | = | $0.00 |
| Other | X | 0.00% | | = | $0.00 |
| Other | X | 0.00% | | = | $0.00 |
| - | - | - | - | - | - |
| TOTAL FRINGES | | | | | $1.57 |
| = | = | = | = | = | = |
Print
Janitor Loaded Wage Rate
| Amendment 0002 | | | | |
| Attachment 4 | | Attachment 4 | | Attachment 4 |
| SOLICITATION NUMBER: | HDEC08-17-R-0006 | SOLICITATION NUMBER: | HDEC08-17-R-0006 | SOLICITATION NUMBER: | HDEC08-17-R-0006 |
| COMMISSARY: | Vance AFB | COMMISSARY: | Vance AFB | COMMISSARY: | Vance AFB |
| 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 | | | | | | | | | | | |
| = | = | = | = | = | | | | | | | | | | | |
| Janitor | | 1 | 10.20 | $10.20 | | | | | | | COST ELEMENT | | | | DOLLARS |
| | | | | | | | | | | = | | | | = |
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | | | | | | | | | | | DIRECT LABOR | | | | $10.20 |
| CALCULATE THE LOADED HOURLY RATE. PROCEED | | | | | | | | | | | DIRECT LABOR HEALTH & WELFARE | | | | $4.27 |
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | | | | | | | | | | | = | | | | = |
| | | | | | | | | | | SUB-TOTAL | | | | $14.47 |
| - | - | - | | - | | | | Qty. | Unit/ | Extended | | | | | |
| TOTALS | | 1 | | $10.20 | Elements | | | Yearly | Price | Price | HOLIDAYS, SICK & VACATIONS | | | | $0.55 |
| = | = | = | | = | = | = | = | = | = | = | HOL, SICK & VAC. HEALTH & WELFARE | | | | $0.17 |
| 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 | | | | $0.72 |
| Direct Labor Hours (Productive/Working) | | 1 | | | rate for Janitor | | | 0 | 0.00 | 0.00 | | | | | |
| | = | | | | | | 0 | 0.00 | 0.00 | FRINGES | | | | $1.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 | | | | | - |
| | | | | | | | 0 | 0.00 | 0.00 | SUB-TOTAL | | | | $16.35 |
| | | H&W | H&W | | | | 0 | 0.00 | 0.00 | | | | | = |
| COST ELEMENT | | Hours | Rates | Cost | | | | 0 | 0.00 | 0.00 | G&A | 0.00% | | | $0.00 |
| = | = | = | = | = | | | | 0 | 0.00 | 0.00 | | | | | |
| Janitor | | 1 | 4.27 | $4.27 | | | | 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 | | | | $16.35 |
| | | | | | | | 0 | 0.00 | 0.00 | = | | = | = | = |
| | | | | | | | 0 | 0.00 | 0.00 | | | | | |
| - | - | - | | - | = | = | = | = | = | = | | | | | |
| TOTALS | | 1 | | $4.27 | TOTALS | | | | | $0.00 | | | | | |
| = | = | = | | = | = | = | = | = | = | | | | | | |
| Holidays, Sick, and Vacations | | | | | |
| | | | Holidays/ | |
| | | Sick/ | Sick/Vacations | |
| COST ELEMENT | | Holidays | Vacations | Dollars | |
| = | = | = | = | = | |
| Janitor | | 10 | 0 | $0.55 | |
| | | | | (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.55 | |
| = | = | = | | = | |
| Holidays, Sick, and Vacations Health & Welfare | | | | |
| | Holidays/Sick/ | | |
| | Vacations | H&W | H&W |
| COST ELEMENT | | Hours X | Rates | Cost |
| = | = | = | = | = |
| Janitor | | 0 | 4.27 | $0.17 |
FRINGE CALCULATIONS
| COST ELEMENT | | | | | DOLLARS |
| = | = | = | = | = | = |
| DIRECT LABOR COST | | | | | $10.20 |
| DIRECT HEALTH & WELFARE COSTS | | | | | $4.27 |
| HOLIDAYS, SICK AND VACATIONS | | | | | $0.55 |
| HOLIDAYS, SICK, VACATIONS HEALTH & WELFARE | | | | | $0.17 |
| - | - | - | - | - | - |
| SUBTOTAL | | | | | $15.19 |
| = | = | = | = | = | = |
| FICA | X | 7.65% | | = | $1.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 | | | | | $1.16 |
| = | = | = | = | = | = |
Print