Attachment_4 _Volume_I _Cost_Breakout.xls
XLS spreadsheet 372 KB Posted
- Solicitation number
- HDEC08-15-R-0019
- Issued by
-
Defense Commissary Agency
About this file
Attachment 4 Volume I Cost Breakout
View the file
Other files
Show all 11
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-15-R-0019 |
| VOLUME I |
| COST BREAKOUT |
| Offerors are required to submit their cost breakout in accordance with provision |
| 52.215-4509, "Proposal Submission," paragraph (b)(4), located in Section L of the |
| solicitation. |
| The tabs below contain worksheets for Shelf Stocking, Custodial, Receiving/Storage Holding |
| Area, Yearly Totals, and 5 Year totals as well as Printing Instructions for these worksheets. |
| The worksheets for Shelf Stocking, Custodial, and Receiving/Storage/Holding Area |
| contain "sample" occupational titles and the applicable minimum wage rates. |
&C
Printing Instructions
| BASIC INSTRUCTIONS | ||||
| This icon and/or disk contains the required forms and formats for submitting proposals in response to the | ||||
| solicitation. Some of the forms have protected formats and cells, however the necessary inputs are "unprotected" | ||||
| and may be changed as needed to adequately reflect your proposal. Formulas are included where appropriate | ||||
| to automatically generate various computations. The offer is ultimately responsible for the accuracy of all calculations. | ||||
| If there are calculation differences between the hard copy and the computer files, the hard copy shall take precedence. | ||||
| PRINTING PARAMETERS | ||||
| In order to print these spreadsheets you must use print ranges and titles as they are described in your | ||||
| software manual. The ranges have been defined and named. The range names are listed below. | ||||
| Range Names | Size | Titles | Orientation | Topics |
| SS_PAGE1 | Fit Columns to Page | B:A1..B:A8 | Portrait | Shelf Stocking Direct Labor, Health & Welfare Sheet |
| SS_PAGE2 | Fit Columns to Page | B:A1..B:A8 | Portrait | Shelf Stocking Holidays & Vacations Sheet |
| SS_PAGE3 | Fit Columns to Page | B:A1..B:A8 | Portrait | Shelf Stocking Fringe Calculations Sheet |
| SS_PAGE4 | Fit Columns to Page | B:I1..B:I19 | Portrait | Shelf Stocking Supplies & Equipment Sheet |
| SS_PAGE5 | Fit Columns to Page | None | Portrait | Shelf Stocking Summary Sheet |
| CS_PAGE1 | Fit Columns to Page | C:A1..C:A8 | Portrait | Custodial Direct Labor, Health & Welfare Sheet |
| CS_PAGE2 | Fit Columns to Page | C:A1..C:A8 | Portrait | Custodial Holidays & Vacations Sheet |
| CS_PAGE3 | Fit Columns to Page | C:A1..C:A8 | Portrait | Custodial Fringe Calculations Sheet |
| CS_PAGE4 | Fit Columns to Page | C:I1..C:I19 | Portrait | Custodial Supplies & Equipment Sheet |
| CS_PAGE5 | Fit Columns to Page | None | Portrait | Custodial Summary Sheet |
| WH_PAGE1 | Fit Columns to Page | D:A1..D:A8 | Portrait | RSH Direct Labor, Health & Welfare Sheet |
| WH_PAGE2 | Fit Columns to Page | D:A1..D:A8 | Portrait | RSH Holidays & Vacations Sheet |
| WH_PAGE3 | Fit Columns to Page | D:A1..D:A8 | Portrait | RSH Fringe Calculations Sheet |
| WH_PAGE4 | Fit Columns to Page | D:I1..D:I19 | Portrait | RSH Supplies & Equipment Sheet |
| WH_PAGE5 | Fit Columns to Page | None | Portrait | RSH Summary Sheet |
| GRANDS | Fit Columns to Page | None | Portrait | Totals of Shelf Stocking , Custodial,RSH and Residual Grocery |
| 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. |
&RATTACHMENT 4
Shelf Stocking
| SOLICITATION NUMBER: | HDEC08-15-R-0019 | SOLICITATION NUMBER: | HDEC08-15-R-0019 | SOLICITATION NUMBER: | HDEC08-15-R-0019 | ||||||||||||
| COMMISSARY: | Laughlin AFB Commissary | COMMISSARY: | Laughlin AFB Commissary | COMMISSARY: | Laughlin AFB Commissary | ||||||||||||
| 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 | 10.23 | $0.00 | COST ELEMENT | DOLLARS | ||||||||||||
| Project Manager | 0 | 0.00 | $0.00 | = | = | ||||||||||||
| 0 | 0.00 | $0.00 | Qty. | Unit/ | Extended | ` | DIRECT LABOR | $0.00 | |||||||||
| 0 | 0.00 | $0.00 | Elements | Yearly | Price | Price | HEALTH & WELFARE | $0.00 | |||||||||
| 0 | 0.00 | $0.00 | = | = | = | = | = | = | = | = | |||||||
| 0 | 0.00 | $0.00 | Blades, Carton Cutter | 0 | 0.00 | $0.00 | SUB-TOTAL | $0.00 | |||||||||
| - | - | - | - | Cutter, Carton | 0 | 0.00 | $0.00 | ||||||||||
| TOTALS | 0 | $0.00 | Dispenser, Tape | 0 | 0.00 | $0.00 | HOLIDAYS & VACATIONS | $0.00 | |||||||||
| = | = | = | = | Safety Shoes | 0 | 0.00 | $0.00 | HOL & 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.02 | $0.00 | 0 | 0.00 | $0.00 | |||||||||||
| Project Manager | 0 | 4.02 | $0.00 | 0 | 0.00 | $0.00 | PROFIT | 0.00% | $0.00 | ||||||||
| 0 | 4.02 | $0.00 | 0 | 0.00 | $0.00 | ||||||||||||
| 0 | 4.02 | $0.00 | 0 | 0.00 | $0.00 | = | = | ||||||||||
| 0 | 4.02 | $0.00 | 0 | 0.00 | $0.00 | GRAND TOTAL | $0.00 | ||||||||||
| 0 | 4.02 | $0.00 | 0 | 0.00 | $0.00 | = | = | = | = | ||||||||
| - | - | - | - | 0 | 0.00 | $0.00 | ANNUAL CASES | 53,412 | |||||||||
| TOTALS | 0 | $0.00 | 0 | 0.00 | $0.00 | = | = | = | |||||||||
| = | = | = | = | 0 | 0.00 | $0.00 | CASE PRICE | 0.0000 | |||||||||
| Holidays and Vacations | 0 | 0.00 | $0.00 | = | = | = | |||||||||||
| 0 | 0.00 | $0.00 | |||||||||||||||
| Holidays | 0 | 0.00 | $0.00 | ||||||||||||||
| 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.00 | |||||||||||||||
| = | = | = | = | ||||||||||||||
| Holidays and Vacations Health & Welfare | |||||||||||||||||
| Holidays | |||||||||||||||||
| Vacations | H&W | H&W | |||||||||||||||
| COST ELEMENT | Hours X | Rates = | Cost | ||||||||||||||
| = | = | = | = | = | |||||||||||||
| Store Worker I | 0 | 4.02 | $0.00 | ||||||||||||||
| Project Manager | 0 | 4.02 | $0.00 | ||||||||||||||
| 0 | 4.02 | $0.00 | |||||||||||||||
| 0 | 4.02 | $0.00 | |||||||||||||||
| 0 | 4.02 | $0.00 | |||||||||||||||
| 0 | 4.02 | $0.00 | |||||||||||||||
| - | - | - | - | ||||||||||||||
| TOTALS | 0 | $0.00 | |||||||||||||||
| = | = | = | = | ||||||||||||||
| FRINGE CALCULATIONS | |||||||||||||||||
| COST ELEMENT | DOLLARS | ||||||||||||||||
| = | = | = | = | = | = | ||||||||||||
| DIRECT LABOR | $0.00 | ||||||||||||||||
| DIRECT LABOR HEALTH & WELFARE | $0.00 | ||||||||||||||||
| HOLIDAYS AND VACATIONS | $0.00 | ||||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0.00 | ||||||||||||||||
| - | - | - | - | - | - | ||||||||||||
| SUBTOTAL | $0.00 | ||||||||||||||||
| = | = | = | = | = | = | ||||||||||||
| FICA | X | 7.65% | = | $0.00 | |||||||||||||
| FUTA | X | 0.00% | = | $0.00 | |||||||||||||
| SUTA | X | 0.00% | = | $0.00 | |||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | |||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | |||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | |||||||||||||
| Other | X | 0.00% | = | $0.00 | |||||||||||||
| Other | X | 0.00% | = | $0.00 | |||||||||||||
| - | - | - | - | - | - | ||||||||||||
| TOTAL FRINGES | $0.00 | ||||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
RSH
| SOLICITATION NUMBER: | HDEC08-15-R-0019 | SOLICITATION NUMBER: | HDEC08-15-R-0019 | SOLICITATION NUMBER: | HDEC08-15-R-0019 | |||||||||||
| COMMISSARY: | Laughlin AFB Commissary | COMMISSARY: | Laughlin AFB Commissary | COMMISSARY: | Laughlin AFB Commissary | |||||||||||
| 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 Handler | 0 | 10.58 | $0.00 | COST ELEMENT | DOLLARS | |||||||||||
| Forklift Operator | 0 | 12.22 | $0.00 | = | = | |||||||||||
| Warehouse Specialist | 0 | 12.22 | $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 & VACATIONS | 0.00 | ||||||||
| = | = | = | = | Safety Shoes | 0 | 0.00 | 0.00 | HOL & 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 Handler | 0 | 4.02 | $0.00 | 0 | 0.00 | 0.00 | ||||||||||
| Forklift Operator | 0 | 4.02 | $0.00 | 0 | 0.00 | 0.00 | PROFIT | 0.00% | 0.00 | |||||||
| Warehouse Specialist | 0 | 4.02 | $0.00 | 0 | 0.00 | 0.00 | ||||||||||
| Project Manager | 0 | 4.02 | $0.00 | 0 | 0.00 | 0.00 | = | = | ||||||||
| 0 | 4.02 | $0.00 | 0 | 0.00 | 0.00 | GRAND TOTAL | 0.00 | |||||||||
| 0 | 4.02 | $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 and Vacations | 0 | 0.00 | 0.00 | |||||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| Holidays | 0 | 0.00 | 0.00 | |||||||||||||
| Vacations | 0 | 0.00 | 0.00 | |||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | 0 | 0.00 | 0.00 | ||||||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Material Handler | 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.00 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays and Vacations Health & Welfare | ||||||||||||||||
| Holidays | ||||||||||||||||
| Vacations | H&W | H&W | ||||||||||||||
| COST ELEMENT | Hours X | Rates = | Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Material Handler | 0 | 4.02 | $0.00 | |||||||||||||
| Forklift Operator | 0 | 4.02 | $0.00 | |||||||||||||
| Warehouse Specialist | 0 | 4.02 | $0.00 | |||||||||||||
| Project Manager | 0 | 4.02 | $0.00 | |||||||||||||
| 0 | 4.02 | $0.00 | ||||||||||||||
| 0 | 4.02 | $0.00 | ||||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.00 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR | $0.00 | |||||||||||||||
| DIRECT LABOR HEALTH & WELFARE | $0.00 | |||||||||||||||
| HOLIDAYS AND VACATIONS | $0.00 | |||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0.00 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $0.00 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $0.00 | ||||||||||||
| FUTA | X | 0.00% | = | $0.00 | ||||||||||||
| SUTA | X | 0.00% | = | $0.00 | ||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | ||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| - | - | - | - | - | - | |||||||||||
| TOTAL FRINGES | $0.00 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Custodial
| SOLICITATION NUMBER: | HDEC08-15-R-0019 | SOLICITATION NUMBER: | HDEC08-15-R-0019 | SOLICITATION NUMBER: | HDEC08-15-R-0019 | |||||||||||
| COMMISSARY: | Laughlin AFB Commissary | COMMISSARY: | Laughlin AFB Commissary | COMMISSARY: | Laughlin AFB Commissary | |||||||||||
| 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 (Excluding RSHA, Meat Custodial & Outside Areas) | 0 | 10.53 | $0.00 | COST ELEMENT | DOLLARS | |||||||||||
| Janitor, Meat Custodial Operations | 0 | 10.53 | $0.00 | = | = | |||||||||||
| Janitor, RSHA Custodial Operations (Including Outside Areas) | 0 | 10.53 | $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 | 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 & VACATIONS | 0.00 | ||||||||
| = | = | = | = | Cleaner, Compound | 0 | 0.00 | 0.00 | HOL & 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 (Excluding RSHA, Meat Custodial & Outside Areas) | 0 | 4.02 | $0.00 | Kintowel Wiper | 0 | 0.00 | 0.00 | |||||||||
| Janitor, Meat Custodial Operations | 0 | 4.02 | $0.00 | LiquidLive | 0 | 0.00 | 0.00 | PROFIT | 0.00% | 0.00 | ||||||
| Janitor, RSHA Custodial Operations (Including Outside Areas) | 0 | 4.02 | $0.00 | Masks | 0 | 0.00 | 0.00 | |||||||||
| Project Manager | 0 | 4.02 | $0.00 | Mop Head, Wet | 0 | 0.00 | 0.00 | = | = | |||||||
| 0 | 4.02 | $0.00 | Neutralizer | 0 | 0.00 | 0.00 | GRAND TOTAL | 0.00 | ||||||||
| 0 | 4.02 | $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 and Vacations | Polish, Metal | 0 | 0.00 | 0.00 | ||||||||||||
| Propane | 0 | 0.00 | 0.00 | |||||||||||||
| Holidays | Rain Suit | 0 | 0.00 | 0.00 | ||||||||||||
| 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 (Excluding RSHA, Meat Custodial & Outside Areas) | 10 | 0 | $0.00 | ( (Holidays + Vacations) * 8) | Sanitizer, Compound D2 | 0 | 0.00 | 0.00 | ||||||||
| Janitor, Meat Custodial Operations | 10 | 0 | $0.00 | times Work Hours | Soap, Hand, Liquid | 0 | 0.00 | 0.00 | ||||||||
| Janitor, RSHA Custodial Operations (Including Outside Areas) | 10 | 0 | $0.00 | divided by ( 2080 hours - | Sponges | 0 | 0.00 | 0.00 | ||||||||
| Project Manager | 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.00 | 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 and Vacations Health & Welfare | Vaccuum Belts | 0 | 0.00 | 0.00 | ||||||||||||
| Visors | 0 | 0.00 | 0.00 | |||||||||||||
| Holidays | 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 (Excluding RSHA, Meat Custodial & Outside Areas) | 0 | 4.02 | $0.00 | Caddy, Maid | 0 | 0.00 | 0.00 | |||||||||
| Janitor, Meat Custodial Operations | 0 | 4.02 | $0.00 | Carpet Extractor | 0 | 0.00 | 0.00 | |||||||||
| Janitor, RSHA Custodial Operations (Including Outside Areas) | 0 | 4.02 | $0.00 | Floor Scrubber, Low Speed | 0 | 0.00 | 0.00 | |||||||||
| Project Manager | 0 | 4.02 | $0.00 | Scrubber, 20" | 0 | 0.00 | 0.00 | |||||||||
| 0 | 4.02 | $0.00 | Scrubber, Auto | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 4.02 | $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 AND VACATIONS | $0.00 | |||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0.00 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $0.00 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $0.00 | ||||||||||||
| FUTA | X | 0.00% | = | $0.00 | ||||||||||||
| SUTA | X | 0.00% | = | $0.00 | ||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | ||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| - | - | - | - | - | - | |||||||||||
| TOTAL FRINGES | $0.00 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Year Totals
| SOLICITATION NUMBER: | HDEC08-15-R-0019 | |
| COMMISSARY: | Laughlin AFB Commissary | |
| 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 AND VACATIONS | 0.00 | |
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | 0.00 | |
| = | = | |
| TOTAL | 0.00 | |
| FRINGE CALCULATIONS | 0.00 | |
| SUPPLIES & EQUIPMENT | 0.00 | |
| SUB-TOTAL | 0.00 | |
| G&A | 0.00 | |
| PROFIT | 0.00 | |
| = | = | |
| GRAND TOTAL | 0.00 | |
| = | = |
Click Here to Print
5 Yr. Totals
| SOLICITATION NUMBER: | HDEC08-15-R-0019 | |||||
| COMMISSARY: | Laughlin AFB Commissary | |||||
| 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 AND VACATIONS | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| = | = | = | = | = | = | = |
| TOTAL | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FRINGE CALCULATIONS | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| SUPPLIES & EQUIPMENT | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| SUB-TOTAL | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| G&A | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| PROFIT | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| = | = | = | = | = | = | = |
| GRAND TOTAL | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| = | = | = | = | = | = | = |
| SOLICITATION NUMBER: | HDEC08-15-R-0019 | |||||
| COMMISSARY: | Laughlin AFB Commissary | |||||
| CONTRACTOR NAME: | ||||||
| ESCALATION FACTORS | ||||||
| OPTION 1 | OPTION 2 | OPTION 3 | OPTION 4 | |||
| COST ELEMENT | DOLLARS | DOLLARS | DOLLARS | DOLLARS | ||
| = | = | = | = | = | = | |
| DIRECT LABOR | 0.00% | 0.00% | 0.00% | 0.00% | ||
| DIRECT LABOR HEALTH & WELFARE | 0.00% | 0.00% | 0.00% | 0.00% | ||
| = | = | = | = | = | = | |
| TOTAL | ||||||
| HOLIDAYS AND VACATIONS | 0.00% | 0.00% | 0.00% | 0.00% | ||
| HOLIDAYS AND VACATIONS. HEALTH & WELFARE | 0.00% | 0.00% | 0.00% | 0.00% | ||
| = | = | = | = | = | = | |
| TOTAL | ||||||
| FRINGE CALCULATIONS | 0.00% | 0.00% | 0.00% | 0.00% | ||
| SUPPLIES & EQUIPMENT | 0.00% | 0.00% | 0.00% | 0.00% | ||
| SUB-TOTAL | ||||||
| G&A | 0.00% | 0.00% | 0.00% | 0.00% | ||
| PROFIT | 0.00% | 0.00% | 0.00% | 0.00% | ||
| = | = | = | = | = | = | |
| GRAND TOTAL | ||||||
| = | = | = | = | = | = |
Click Here to Print
Shelf Stocker Loaded Wage Rate
| Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC08-15-R-0019 | SOLICITATION NUMBER: | HDEC08-15-R-0019 | SOLICITATION NUMBER: | HDEC08-15-R-0019 | |||||||||||
| COMMISSARY: | Laughlin AFB Commissary | COMMISSARY: | Laughlin AFB Commissary | COMMISSARY: | Laughlin AFB Commissary | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| Store Worker I - Loaded Wage Rate Work Sheet | Store Worker I - Loaded Wage Rate Work Sheet | Store Worker I - 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 | $10.23 | $10.23 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $10.23 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $4.02 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| Qty. | Unit/ | Extended | SUB-TOTAL | $14.25 | ||||||||||||
| - | - | - | - | Elements | Yearly | Price | Price | |||||||||
| TOTALS | 1 | $10.23 | = | = | = | = | = | = | HOLIDAYS/SICK/VACATIONS | $0.55 | ||||||
| = | = | = | = | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | HOL & VAC. HEALTH & WELFARE | $0.16 | |||||||
| 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.71 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | 0 | 0.00 | 0.00 | ||||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.14 | |||||||||||
| 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.11 | ||||||||||||
| 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.02 | $4.02 | 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.11 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | = | = | = | = | = | = | ||||||||||
| - | - | - | - | TOTALS | $0.00 | |||||||||||
| TOTALS | 1 | $4.02 | = | = | = | = | = | |||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick and Vacations | ||||||||||||||||
| Holidays, Sick, | ||||||||||||||||
| Sick/ | Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Store Worker I | 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))+ | ||||||||||||||||
| 0 | (Work Hours divided by(2080-((Holidays/Sick+ | |||||||||||||||
| - | - | - | - | Vacations)*8)))*(Vacations *8*Hourly rate) | ||||||||||||
| TOTALS | 10 | $0.55 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays and Vacations Health & Welfare | ||||||||||||||||
| Holidays/Sick/ | H&W | H&W | ||||||||||||||
| COST ELEMENT | Vacations | Rates | Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Store Worker I | 0.0 | $4.02 | $0.16 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.16 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $10.23 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $4.02 | |||||||||||||||
| HOLIDAYS/SICK/VACATION | $0.55 | |||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0.16 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $14.96 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $1.14 | ||||||||||||
| 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.14 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
WS Loaded Wage Rate
| Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC08-15-R-0019 | SOLICITATION NUMBER: | HDEC08-15-R-0019 | SOLICITATION NUMBER: | HDEC08-15-R-0019 | |||||||||||
| COMMISSARY: | Laughlin AFB Commissary | COMMISSARY: | Laughlin AFB Commissary | COMMISSARY: | Laughlin AFB Commissary | |||||||||||
| 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 | $12.22 | $12.22 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $12.22 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $4.02 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $16.24 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $12.22 | Elements | Yearly | Price | Price | HOLIDAYS/SICK/VACATIONS | $0.66 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOL & VAC. HEALTH & WELFARE | $0.16 | |||||
| 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.82 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Forklift Operator and/or Warehouse Specialist | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.31 | |||||||||||
| 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 | $18.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 | |||||||||
| Warehouse Specialist | 1 | $4.02 | $4.02 | 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 | $18.37 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $4.02 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick and Vacations | ||||||||||||||||
| Holidays, Sick, | ||||||||||||||||
| Sick/ | Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Warehouse Specialist | 10 | 0 | $0.66 | |||||||||||||
| (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.66 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays and Vacations Health & Welfare | ||||||||||||||||
| Holidays/Sick/ | H&W | H&W | ||||||||||||||
| COST ELEMENT | Vacations | Rates | Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Warehouse Specialist | 0 | $4.02 | $0.16 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.16 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $12.22 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $4.02 | |||||||||||||||
| HOLIDAYS/SICK/VACATION | $0.66 | |||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0.16 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $17.06 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $1.31 | ||||||||||||
| 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.31 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
FO Loaded Wage Rate
| Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC08-15-R-0019 | SOLICITATION NUMBER: | HDEC08-15-R-0019 | SOLICITATION NUMBER: | HDEC08-15-R-0019 | |||||||||||
| COMMISSARY: | Laughlin AFB Commissary | COMMISSARY: | Laughlin AFB Commissary | COMMISSARY: | Laughlin AFB Commissary | |||||||||||
| 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 | $12.22 | $12.22 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $12.22 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $4.02 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $16.24 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $12.22 | Elements | Yearly | Price | Price | HOLIDAYS/SICK/VACATIONS | $0.66 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOL & VAC. HEALTH & WELFARE | $0.16 | |||||
| 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.82 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Forklift Operator and/or Warehouse Specialist | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.31 | |||||||||||
| 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 | $18.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 | |||||||||
| Forklift Operator | 1 | $4.02 | $4.02 | 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 | $18.37 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $4.02 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick and Vacations | ||||||||||||||||
| Holidays, Sick, | ||||||||||||||||
| Sick/ | Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Forklift Operator | 10 | 0 | $0.66 | |||||||||||||
| (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.66 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays and Vacations Health & Welfare | ||||||||||||||||
| Holidays/Sick/ | H&W | H&W | ||||||||||||||
| COST ELEMENT | Vacations | Rates | Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Forklift Operator | 0 | $4.02 | $0.16 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.16 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $12.22 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $4.02 | |||||||||||||||
| HOLIDAYS/SICK/VACATION | $0.66 | |||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0.16 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $17.06 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $1.31 | ||||||||||||
| 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.31 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Material Handler Loaded Wage
| Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC08-15-R-0019 | SOLICITATION NUMBER: | HDEC08-15-R-0019 | SOLICITATION NUMBER: | HDEC08-15-R-0019 | |||||||||||
| COMMISSARY: | Laughlin AFB Commissary | COMMISSARY: | Laughlin AFB Commissary | COMMISSARY: | Laughlin AFB Commissary | |||||||||||
| 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 | $10.58 | $10.58 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $10.58 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $4.02 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $14.60 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $10.58 | Elements | Yearly | Price | Price | HOLIDAYS/SICK/VACATIONS | $0.57 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOL & VAC. HEALTH & WELFARE | $0.16 | |||||
| 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.73 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Material Handler | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.17 | |||||||||||
| 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.51 | ||||||||||||
| 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.02 | $4.02 | 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.51 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $4.02 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick and Vacations | ||||||||||||||||
| Holidays, Sick, | ||||||||||||||||
| Sick/ | Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Material Handler | 10 | 0 | $0.57 | |||||||||||||
| $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.57 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays and Vacations Health & Welfare | ||||||||||||||||
| Holidays/Sick/ | H&W | H&W | ||||||||||||||
| COST ELEMENT | Vacations | Rates | Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Material Handler | 0 | $4.02 | $0.16 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.16 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $10.58 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $4.02 | |||||||||||||||
| HOLIDAYS/SICK/VACATION | $0.57 | |||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0.16 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $15.33 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $1.17 | ||||||||||||
| 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.17 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Janitor Loaded Wage Rate
| Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC08-15-R-0019 | SOLICITATION NUMBER: | HDEC08-15-R-0019 | SOLICITATION NUMBER: | HDEC08-15-R-0019 | |||||||||||
| COMMISSARY: | Laughlin AFB Commissary | COMMISSARY: | Laughlin AFB Commissary | COMMISSARY: | Laughlin AFB Commissary | |||||||||||
| 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.53 | $10.53 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $10.53 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $4.02 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $14.55 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $10.53 | Elements | Yearly | Price | Price | HOLIDAYS/SICK/VACATIONS | $0.57 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOL & VAC. HEALTH & WELFARE | $0.16 | |||||
| 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.73 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Janitor | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.17 | |||||||||||
| 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.45 | ||||||||||||
| 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.02 | $4.02 | 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.45 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $4.02 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick and Vacations | ||||||||||||||||
| Holidays, Sick, | ||||||||||||||||
| Sick/ | Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Janitor | 10 | 0 | $0.57 | |||||||||||||
| (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.57 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays and Vacations Health & Welfare | ||||||||||||||||
| Holidays/Sick/ | H&W | H&W | ||||||||||||||
| COST ELEMENT | Vacations | Rates | Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Janitor | 0 | $4.02 | $0.16 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.16 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $10.53 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $4.02 | |||||||||||||||
| HOLIDAYS/SICK/VACATION | $0.57 | |||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0.16 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $15.28 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $1.17 | ||||||||||||
| 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.17 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
File details come from the government source that posted it. Updated .