Attachment 3 Volume I Cost Breakout MacDill AFB HDEC0820R0024.XLS
XLS spreadsheet 314 KB Posted
- Solicitation number
- HDEC0820R0024
- Issued by
-
Defense Commissary Agency
About this file
This file contains cost breakout worksheets and instructions for submitting proposals in response to solicitation number HDEC0820R0024 issued by the Defense Commissary Agency. The solicitation seeks shelf stocking, receiving, storage, holding area, and custodial operations at the MacDill AFB Commissary located in Tampa, Florida. Offerors must submit their cost proposals using the provided worksheets for shelf stocking, custodial, and receiving/storage/holding area operations. The worksheets include sample occupational titles and wage rates and calculations for direct labor, health and welfare benefits, holidays and vacations, fringes, supplies and equipment, overhead, and profit. Additional attachments provide loaded hourly wage rate worksheets for sample occupations including shelf stocker, forklift operator, warehouse specialist, material handler, and janitor.
View the file
Other files
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Cost Breakout
| Attachment 3 |
| HDEC0820R0024 |
| VOLUME I |
| COST BREAKOUT |
| Offerors are required to submit their cost breakout in accordance with provision |
| 52.215-4509, "Proposal Submission," paragraph (b)(4), located in Section L of the |
| solicitation. |
| The tabs below contain worksheets for Shelf Stocking, Custodial, Receiving/Storage Holding |
| Area, Yearly Totals, and 5 Year totals as well as Printing Instructions for these worksheets. |
| The worksheets for Shelf Stocking, Custodial, and Receiving/Storage/Holding Area |
| contain "sample" occupational titles and the applicable minimum wage rates. |
&C
Printing Instructions
| BASIC INSTRUCTIONS | ||||
| This icon and/or disk contains the required forms and formats for submitting proposals in response to the | ||||
| solicitation. Some of the forms have protected formats and cells, however the necessary inputs are "unprotected" | ||||
| and may be changed as needed to adequately reflect your proposal. Formulas are included where appropriate | ||||
| to automatically generate various computations. The offer is ultimately responsible for the accuracy of all calculations. | ||||
| If there are calculation differences between the hard copy and the computer files, the hard copy shall take precedence. | ||||
| PRINTING PARAMETERS | ||||
| In order to print these spreadsheets you must use print ranges and titles as they are described in your | ||||
| software manual. The ranges have been defined and named. The range names are listed below. | ||||
| Range Names | Size | Titles | Orientation | Topics |
| SS_PAGE1 | Fit Columns to Page | B:A1..B:A8 | Portrait | Shelf Stocking Direct Labor, Health & Welfare Sheet |
| SS_PAGE2 | Fit Columns to Page | B:A1..B:A8 | Portrait | Shelf Stocking Holidays & Vacations Sheet |
| SS_PAGE3 | Fit Columns to Page | B:A1..B:A8 | Portrait | Shelf Stocking Fringe Calculations Sheet |
| SS_PAGE4 | Fit Columns to Page | B:I1..B:I19 | Portrait | Shelf Stocking Supplies & Equipment Sheet |
| SS_PAGE5 | Fit Columns to Page | None | Portrait | Shelf Stocking Summary Sheet |
| CS_PAGE1 | Fit Columns to Page | C:A1..C:A8 | Portrait | Custodial Direct Labor, Health & Welfare Sheet |
| CS_PAGE2 | Fit Columns to Page | C:A1..C:A8 | Portrait | Custodial Holidays & Vacations Sheet |
| CS_PAGE3 | Fit Columns to Page | C:A1..C:A8 | Portrait | Custodial Fringe Calculations Sheet |
| CS_PAGE4 | Fit Columns to Page | C:I1..C:I19 | Portrait | Custodial Supplies & Equipment Sheet |
| CS_PAGE5 | Fit Columns to Page | None | Portrait | Custodial Summary Sheet |
| WH_PAGE1 | Fit Columns to Page | D:A1..D:A8 | Portrait | RSH Direct Labor, Health & Welfare Sheet |
| WH_PAGE2 | Fit Columns to Page | D:A1..D:A8 | Portrait | RSH Holidays & Vacations Sheet |
| WH_PAGE3 | Fit Columns to Page | D:A1..D:A8 | Portrait | RSH Fringe Calculations Sheet |
| WH_PAGE4 | Fit Columns to Page | D:I1..D:I19 | Portrait | RSH Supplies & Equipment Sheet |
| WH_PAGE5 | Fit Columns to Page | None | Portrait | RSH Summary Sheet |
| GRANDS | Fit Columns to Page | None | Portrait | Totals of Shelf Stocking , Custodial, and RSHA |
| GRAND_TOTALS | Fit Columns to Page | None | Landscape | 5 year totals of Shelf Stocking , Custodial, and RSHA |
| You may also use the macro "Print1" to print a group of pages. Make the sheet you wish to print active. Run the macro and it will print | ||||
| the group of spreadsheets for you. This macro currently works only in Excel. The macro can also be activated by pressing the Print | ||||
| button on each sheet. |
Shelf Stocking
| SOLICITATION NUMBER: | HDEC0820R0012 | SOLICITATION NUMBER: | HDEC0820R0012 | SOLICITATION NUMBER: | HDEC0820R0012 | ||||||||||||
| COMMISSARY: | MacDill AFB | COMMISSARY: | MacDill AFB | COMMISSARY: | MacDill 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 | 12.61 | $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 Fund & Pension | 0 | 0.00 | $0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | 0 | 0.00 | $0.00 | - | |||||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | $0.00 | SUB-TOTAL | $0.00 | |||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension Rates | 0 | 0.00 | $0.00 | = | ||||||||||
| = | = | = | = | = | 0 | 0.00 | $0.00 | G&A | 0.00% | $0.00 | |||||||
| Store Worker I | 0 | 8.25 | $0.00 | 0 | 0.00 | $0.00 | |||||||||||
| Project Manager | 0 | 8.25 | $0.00 | 0 | 0.00 | $0.00 | PROFIT | 0.00% | $0.00 | ||||||||
| 0 | 8.25 | $0.00 | 0 | 0.00 | $0.00 | ||||||||||||
| 0 | 8.25 | $0.00 | 0 | 0.00 | $0.00 | = | = | ||||||||||
| 0 | 8.25 | $0.00 | 0 | 0.00 | $0.00 | GRAND TOTAL | $0.00 | ||||||||||
| 0 | 8.25 | $0.00 | 0 | 0.00 | $0.00 | = | = | = | = | ||||||||
| - | - | - | - | 0 | 0.00 | $0.00 | ANNUAL CASES | 2,112,000 | |||||||||
| 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 Fund & Pension | |||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | |||||||||||||||||
| Holidays/Sick/ | |||||||||||||||||
| Vacations | Health Fund/ | H&W/Health Fund/ | |||||||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension | ||||||||||||||
| = | = | = | = | = | |||||||||||||
| Store Worker I | 0 | 8.25 | $0.00 | ||||||||||||||
| Project Manager | 0 | 8.25 | $0.00 | ||||||||||||||
| 0 | 8.25 | $0.00 | |||||||||||||||
| 0 | 8.25 | $0.00 | |||||||||||||||
| 0 | 8.25 | $0.00 | |||||||||||||||
| 0 | 8.25 | $0.00 | |||||||||||||||
| - | - | - | - | ||||||||||||||
| TOTALS | 0 | $0.00 | |||||||||||||||
| = | = | = | = | ||||||||||||||
| FRINGE CALCULATIONS | |||||||||||||||||
| COST ELEMENT | DOLLARS | ||||||||||||||||
| = | = | = | = | = | = | ||||||||||||
| DIRECT LABOR | $0.00 | ||||||||||||||||
| DIRECT LABOR HEALTH & WELFARE | $0.00 | ||||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $0.00 | ||||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE | $0.00 | ||||||||||||||||
| - | - | - | - | - | - | ||||||||||||
| SUBTOTAL | $0.00 | ||||||||||||||||
| = | = | = | = | = | = | ||||||||||||
| FICA | X | 7.65% | = | $0.00 | |||||||||||||
| FUTA | X | 0.00% | = | $0.00 | |||||||||||||
| SUTA | X | 0.00% | = | $0.00 | |||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | |||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | |||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | |||||||||||||
| Other | X | 0.00% | = | $0.00 | |||||||||||||
| Other | X | 0.00% | = | $0.00 | |||||||||||||
| - | - | - | - | - | - | ||||||||||||
| TOTAL FRINGES | $0.00 | ||||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
RSH
| SOLICITATION NUMBER: | HDEC0820R0012 | SOLICITATION NUMBER: | HDEC0820R0012 | SOLICITATION NUMBER: | HDEC0820R0012 | |||||||||||
| COMMISSARY: | MacDill AFB | COMMISSARY: | MacDill AFB | COMMISSARY: | MacDill AFB | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| R/S/H Operations Work Sheet | R/S/H Operations Work Sheet | R/S/H Operations Work Sheet | ||||||||||||||
| Direct Labor | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||
| R/S/H Supplies & Equipment | ================ | |||||||||||||||
| WDR | ||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | (The elements listed below are SAMPLES and are not to be considered | ||||||||||||
| = | = | = | = | = | a requirement of the solicitation.) | |||||||||||
| Forklift Operator | 0 | 19.27 | $0.00 | COST ELEMENT | DOLLARS | |||||||||||
| Warehouse Specialist | 0 | 19.27 | $0.00 | = | = | |||||||||||
| Material Handler | 0 | 12.61 | $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 Fund & Pension | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | 0.00 | |||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | - | ||||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | 0.00 | SUB-TOTAL | 0.00 | ||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension Rates | 0 | 0.00 | 0.00 | = | |||||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | G&A | 0.00% | 0.00 | ||||||
| Forklift Operator | 0 | 8.25 | $0.00 | 0 | 0.00 | 0.00 | ||||||||||
| Warehouse Specialist | 0 | 8.25 | $0.00 | 0 | 0.00 | 0.00 | PROFIT | 0.00% | 0.00 | |||||||
| Material Handler | 0 | 8.25 | $0.00 | 0 | 0.00 | 0.00 | ||||||||||
| Project Manager | 0 | 8.25 | $0.00 | 0 | 0.00 | 0.00 | = | = | ||||||||
| 0 | 8.25 | $0.00 | 0 | 0.00 | 0.00 | GRAND TOTAL | 0.00 | |||||||||
| 0 | 8.25 | $0.00 | 0 | 0.00 | 0.00 | = | = | = | = | |||||||
| - | - | - | - | 0 | 0.00 | 0.00 | MO. PRICE | 0.00 | ||||||||
| TOTALS | 0 | $0.00 | 0 | 0.00 | 0.00 | = | = | = | ||||||||
| = | = | = | = | 0 | 0.00 | 0.00 | ||||||||||
| Holidays, Sick, and Vacations | 0 | 0.00 | 0.00 | |||||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| Holidays/ | 0 | 0.00 | 0.00 | |||||||||||||
| Sick/ | Sick/Vacations | 0 | 0.00 | 0.00 | ||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | 0 | 0.00 | 0.00 | ||||||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Forklift Operator | 10 | 0 | $0.00 | ( (Holidays + Vacations) * 8) | 0 | 0.00 | 0.00 | |||||||||
| Warehouse Specialist | 10 | 0 | $0.00 | times Work Hours | = | = | = | = | = | |||||||
| Material Handler | 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 Fund & Pension | ||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | H&W/Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Forklift Operator | 0 | 8.25 | $0.00 | |||||||||||||
| Warehouse Specialist | 0 | 8.25 | $0.00 | |||||||||||||
| Material Handler | 0 | 8.25 | $0.00 | |||||||||||||
| Project Manager | 0 | 8.25 | $0.00 | |||||||||||||
| 0 | 8.25 | $0.00 | ||||||||||||||
| 0 | 8.25 | $0.00 | ||||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.00 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR | $0.00 | |||||||||||||||
| DIRECT LABOR HEALTH & WELFARE | $0.00 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $0.00 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE | $0.00 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $0.00 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $0.00 | ||||||||||||
| FUTA | X | 0.00% | = | $0.00 | ||||||||||||
| SUTA | X | 0.00% | = | $0.00 | ||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | ||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| - | - | - | - | - | - | |||||||||||
| TOTAL FRINGES | $0.00 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Custodial
| SOLICITATION NUMBER: | HDEC0820R0012 | SOLICITATION NUMBER: | HDEC0820R0012 | SOLICITATION NUMBER: | HDEC0820R0012 | |||||||||||
| COMMISSARY: | MacDill AFB | COMMISSARY: | MacDill AFB | COMMISSARY: | MacDill AFB | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| Custodial Operations Work Sheet | Custodial Operations Work Sheet | Custodial Operations Work Sheet | ||||||||||||||
| Direct Labor | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||
| Custodial Supplies & Equipment | ================ | |||||||||||||||
| WDR | ||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | (The elements listed below are SAMPLES and are not to be considered | ||||||||||||
| = | = | = | = | = | a requirement of the solicitation.) | |||||||||||
| Custodian | 0 | 13.15 | $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 Fund & Pension | Floor Finish | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | 0.00 | ||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | Floor Sealer | 0 | 0.00 | 0.00 | - | |||||||||||
| Health Fund/ | Health Fund/ | Floor Stripper | 0 | 0.00 | 0.00 | SUB-TOTAL | 0.00 | |||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension Rates | Gloves | 0 | 0.00 | 0.00 | = | ||||||||
| = | = | = | = | = | Gloves, Latex | 0 | 0.00 | 0.00 | G&A | 0.00% | 0.00 | |||||
| Custodian | 0 | 8.25 | $0.00 | Kintowel Wiper | 0 | 0.00 | 0.00 | |||||||||
| Project Manager | 0 | 8.25 | $0.00 | LiquidLive | 0 | 0.00 | 0.00 | PROFIT | 0.00% | 0.00 | ||||||
| 0 | 8.25 | $0.00 | Masks | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 8.25 | $0.00 | Mop Head, Wet | 0 | 0.00 | 0.00 | = | = | ||||||||
| 0 | 8.25 | $0.00 | Neutralizer | 0 | 0.00 | 0.00 | GRAND TOTAL | 0.00 | ||||||||
| 0 | 8.25 | $0.00 | Pads, Aqua 27" | 0 | 0.00 | 0.00 | = | = | = | = | ||||||
| - | - | - | - | Pads, Buffing | 0 | 0.00 | 0.00 | MONTHLY PRICE | 0.00 | |||||||
| TOTALS | 0 | $0.00 | Pads, Doodle Bug | 0 | 0.00 | 0.00 | = | = | = | |||||||
| = | = | = | = | Polish, Furniture | 0 | 0.00 | 0.00 | |||||||||
| Holidays, Sick, and Vacations | Polish, Metal | 0 | 0.00 | 0.00 | ||||||||||||
| Propane | 0 | 0.00 | 0.00 | |||||||||||||
| Holidays/ | Rain Suit | 0 | 0.00 | 0.00 | ||||||||||||
| Sick/ | Sick/Vacations | Respirators | 0 | 0.00 | 0.00 | |||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | Retainer | 0 | 0.00 | 0.00 | |||||||||
| = | = | = | = | = | Safety Shoes | 0 | 0.00 | 0.00 | ||||||||
| Custodian | 10 | 0 | $0.00 | ( (Holidays + Vacations) * 8) | Sanitizer, Compound D2 | 0 | 0.00 | 0.00 | ||||||||
| Project Manager | 10 | 0 | $0.00 | times Work Hours | Soap, Hand, Liquid | 0 | 0.00 | 0.00 | ||||||||
| 10 | 0 | $0.00 | divided by ( 2080 hours - | Sponges | 0 | 0.00 | 0.00 | |||||||||
| 10 | 0 | $0.00 | ( (Holidays + Vacations) * 8) ) | Spray Bottle | 0 | 0.00 | 0.00 | |||||||||
| 10 | 0 | $0.00 | times the hourly rate | Spray Bottle Trigger | 0 | 0.00 | 0.00 | |||||||||
| 10 | 0 | $0.00 | in each category | Spray Buff | 0 | 0.00 | 0.00 | |||||||||
| - | - | - | - | Toilet Tissue, 96rl | 0 | 0.00 | 0.00 | |||||||||
| TOTALS | 60 | $0 | Towels, Pop-Up | 0 | 0.00 | 0.00 | ||||||||||
| = | = | = | = | Trash Liners, Lg | 0 | 0.00 | 0.00 | |||||||||
| Trash Liners, Sm | 0 | 0.00 | 0.00 | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | Vaccuum Belts | 0 | 0.00 | 0.00 | ||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | Visors | 0 | 0.00 | 0.00 | ||||||||||||
| Holidays/Sick/ | Battery Charger | 0 | 0.00 | 0.00 | ||||||||||||
| Vacations | Health Fund/ | H&W/Health Fund/ | Buffer, High Speed | 0 | 0.00 | 0.00 | ||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension | Burnisher High Speed | 0 | 0.00 | 0.00 | |||||||||
| = | = | = | = | = | Burnisher, 21" Propane | 0 | 0.00 | 0.00 | ||||||||
| Custodian | 0 | 8.25 | $0.00 | Caddy, Maid | 0 | 0.00 | 0.00 | |||||||||
| Project Manager | 0 | 8.25 | $0.00 | Carpet Extractor | 0 | 0.00 | 0.00 | |||||||||
| 0 | 8.25 | $0.00 | Floor Scrubber, Low Speed | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 8.25 | $0.00 | Scrubber, 20" | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 8.25 | $0.00 | Scrubber, Auto | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 8.25 | $0.00 | Vacuum, Wet/Dry | 0 | 0.00 | 0.00 | ||||||||||
| - | - | - | - | Washer, Pressure | 0 | 0.00 | 0.00 | |||||||||
| TOTALS | 0 | $0.00 | 0 | 0.00 | 0.00 | |||||||||||
| = | = | = | = | 0 | 0.00 | 0.00 | ||||||||||
| = | = | = | = | = | = | |||||||||||
| TOTALS | $0.00 | |||||||||||||||
| FRINGE CALCULATIONS | = | = | = | = | = | = | ||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR | $0.00 | |||||||||||||||
| DIRECT LABOR HEALTH & WELFARE | $0.00 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $0.00 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE | $0.00 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $0.00 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $0.00 | ||||||||||||
| FUTA | X | 0.00% | = | $0.00 | ||||||||||||
| SUTA | X | 0.00% | = | $0.00 | ||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | ||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| - | - | - | - | - | - | |||||||||||
| TOTAL FRINGES | $0.00 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Year Totals
| SOLICITATION NUMBER: | HDEC0820R0012 | |
| COMMISSARY: | MacDill AFB | |
| CONTRACTOR NAME: | ||
| BASE YEAR GRAND TOTALS | ||
| DOLLAR TOTALS | ||
| ================ | ||
| COST ELEMENT | DOLLARS | |
| = | = | |
| DIRECT LABOR | 0.00 | |
| DIRECT LABOR HEALTH & WELFARE | 0.00 | |
| = | = | |
| TOTAL | 0.00 | |
| HOLIDAYS, SICK & VACATIONS | 0.00 | |
| HOL, SICK & VAC. HEALTH & WELFARE | 0.00 | |
| = | = | |
| TOTAL | 0.00 | |
| FRINGE CALCULATIONS | 0.00 | |
| SUPPLIES & EQUIPMENT | 0.00 | |
| SUB-TOTAL | 0.00 | |
| G&A | 0.00 | |
| PROFIT | 0.00 | |
| = | = | |
| GRAND TOTAL | 0.00 | |
| = | = |
Click Here to Print
5 Yr. Totals
| SOLICITATION NUMBER: | HDEC0820R0012 | |||||
| COMMISSARY: | MacDill AFB | |||||
| CONTRACTOR NAME: | ||||||
| GRAND TOTALS | ||||||
| BASE YEAR | OPTION 1 | OPTION 2 | OPTION 3 | OPTION 4 | GRAND | |
| COST ELEMENT | DOLLARS | DOLLARS | DOLLARS | DOLLARS | DOLLARS | TOTALS |
| = | = | = | = | = | = | = |
| DIRECT LABOR | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| DIRECT LABOR HEALTH & WELFARE | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| = | = | = | = | = | = | = |
| TOTAL | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| HOLIDAYS, SICK & VACATIONS | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| HOL, SICK & VAC. HEALTH & WELFARE | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| = | = | = | = | = | = | = |
| TOTAL | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FRINGE CALCULATIONS | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| SUPPLIES & EQUIPMENT | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| SUB-TOTAL | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| G&A | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| PROFIT | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| = | = | = | = | = | = | = |
| GRAND TOTAL | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| = | = | = | = | = | = | = |
| SOLICITATION NUMBER: | HDEC0820R0012 | |||||
| COMMISSARY: | MacDill 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
| Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC0820R0012 | SOLICITATION NUMBER: | HDEC0820R0012 | SOLICITATION NUMBER: | HDEC0820R0012 | |||||||||||
| COMMISSARY: | MacDill AFB | COMMISSARY: | MacDill AFB | COMMISSARY: | MacDill 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 | 12.61 | $12.61 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $12.61 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $8.25 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| Qty. | Unit/ | Extended | SUB-TOTAL | $20.86 | ||||||||||||
| - | - | - | - | Elements | Yearly | Price | Price | |||||||||
| TOTALS | 1 | $12.61 | = | = | = | = | = | = | HOLIDAYS, SICK & VACATIONS | $0.68 | ||||||
| = | = | = | = | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | HOL, SICK & VAC. HEALTH & WELFARE | $0.33 | |||||||
| Indirect Labor Hours (Non-Working) | are not included in the loaded | 0 | 0.00 | $0.00 | = | = | ||||||||||
| = | rate for Store Worker I | 0 | 0.00 | 0.00 | SUB-TOTAL | $1.01 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | 0 | 0.00 | 0.00 | ||||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.67 | |||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| Direct Labor Health Fund & Pension | 0 | 0.00 | 0.00 | - | ||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $23.54 | |||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension Rates | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Store Worker I | 1 | 8.25 | $8.25 | 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 | $23.54 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | = | = | = | = | = | = | ||||||||||
| - | - | - | - | TOTALS | $0.00 | |||||||||||
| TOTALS | 1 | $8.25 | = | = | = | = | = | |||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Store Worker I | 10 | 0 | $0.68 | |||||||||||||
| (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.68 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | ||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | H&W/Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Store Worker I | 0.04 | 8.25 | $0.33 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.33 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $12.61 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $8.25 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $0.68 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE | $0.33 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $21.87 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $1.67 | ||||||||||||
| 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.67 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Forklift Operator Loaded Wage
| Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC0820R0012 | SOLICITATION NUMBER: | HDEC0820R0012 | SOLICITATION NUMBER: | HDEC0820R0012 | |||||||||||
| COMMISSARY: | MacDill AFB | COMMISSARY: | MacDill AFB | COMMISSARY: | MacDill 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 | 19.27 | $19.27 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $19.27 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $8.25 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $27.52 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $19.27 | Elements | Yearly | Price | Price | HOLIDAYS, SICK & VACATIONS | $1.04 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOL, SICK & VAC. HEALTH & WELFARE | $0.33 | |||||
| Indirect Labor Hours (Non-Working) | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | = | = | ||||||||||
| = | are not included in the loaded | 0 | 0.00 | $0.00 | SUB-TOTAL | $1.37 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Forklift Operator | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.90 | |||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| Direct Labor Health Fund & Pension | 0 | 0.00 | 0.00 | - | ||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $30.79 | |||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension Rates | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Forklift Operator | 1 | 8.25 | $8.25 | 0 | 0.00 | 0.00 | PROFIT | 0.00% | $0.00 | |||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | = | = | ||||||||||||
| 0 | 0.00 | 0.00 | GRAND TOTAL | $30.79 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $8.25 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Forklift Operator | 10 | 0 | $1.04 | |||||||||||||
| (Work hours divided by ((2080 hours- | ||||||||||||||||
| (Holidays/Sick+ Vacations)*8))) * | ||||||||||||||||
| ((Closed Holidays*8*Hourly rate)+ | ||||||||||||||||
| (Holidays worked*8*Hourly rate* time & half))+ | ||||||||||||||||
| (Work Hours divided by(2080-((Holidays/Sick+ | ||||||||||||||||
| - | - | - | - | Vacations)*8)))*(Vacations *8*Hourly rate) | ||||||||||||
| TOTALS | 10 | $1.04 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | ||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | H&W/Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Forklift Operator | 0.04 | 8.25 | $0.33 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.33 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $19.27 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $4.22 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $1.04 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE | $0.33 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $24.86 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $1.90 | ||||||||||||
| FUTA | X | 0.00% | = | $0.00 | ||||||||||||
| SUTA | X | 0.00% | = | $0.00 | ||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | ||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| - | - | - | - | - | - | |||||||||||
| TOTAL FRINGES | $1.90 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Warehouse Spec Loaded Wage
| Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC0820R0012 | SOLICITATION NUMBER: | HDEC0820R0012 | SOLICITATION NUMBER: | HDEC0820R0012 | |||||||||||
| COMMISSARY: | MacDill AFB | COMMISSARY: | MacDill AFB | COMMISSARY: | MacDill 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 | 19.27 | $19.27 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $19.27 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $8.25 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $27.52 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $19.27 | Elements | Yearly | Price | Price | HOLIDAYS, SICK & VACATIONS | $1.04 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOL, SICK & VAC. HEALTH & WELFARE | $0.33 | |||||
| Indirect Labor Hours (Non-Working) | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | = | = | ||||||||||
| = | are not included in the loaded | 0 | 0.00 | $0.00 | SUB-TOTAL | $1.37 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Forklift Operator | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.90 | |||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| Direct Labor Health Fund & Pension | 0 | 0.00 | 0.00 | - | ||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $30.79 | |||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension Rates | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Warehouse Specialist | 1 | 8.25 | $8.25 | 0 | 0.00 | 0.00 | PROFIT | 0.00% | $0.00 | |||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | = | = | ||||||||||||
| 0 | 0.00 | 0.00 | GRAND TOTAL | $30.79 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $8.25 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Warehouse Specialist | 10 | 0 | $1.04 | |||||||||||||
| (Work hours divided by ((2080 hours- | ||||||||||||||||
| (Holidays/Sick+ Vacations)*8))) * | ||||||||||||||||
| ((Closed Holidays*8*Hourly rate)+ | ||||||||||||||||
| (Holidays worked*8*Hourly rate* time & half))+ | ||||||||||||||||
| (Work Hours divided by(2080-((Holidays/Sick+ | ||||||||||||||||
| - | - | - | - | Vacations)*8)))*(Vacations *8*Hourly rate) | ||||||||||||
| TOTALS | 10 | $1.04 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | ||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | H&W/Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Warehouse Specialist | 0.04 | 8.25 | $0.33 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.33 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $19.27 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $4.22 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $1.04 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE | $0.33 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $24.86 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $1.90 | ||||||||||||
| FUTA | X | 0.00% | = | $0.00 | ||||||||||||
| SUTA | X | 0.00% | = | $0.00 | ||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | ||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| - | - | - | - | - | - | |||||||||||
| TOTAL FRINGES | $1.90 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Material Handler Loaded Wage
| Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC0820R0012 | SOLICITATION NUMBER: | HDEC0820R0012 | SOLICITATION NUMBER: | HDEC0820R0012 | |||||||||||
| COMMISSARY: | MacDill AFB | COMMISSARY: | MacDill AFB | COMMISSARY: | MacDill 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 | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Warehouse Specialist | 1 | 12.61 | $12.61 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $12.61 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $8.25 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $20.86 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $12.61 | Elements | Yearly | Price | Price | HOLIDAYS, SICK & VACATIONS | $0.68 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOL, SICK & VAC. HEALTH & WELFARE | $0.33 | |||||
| Indirect Labor Hours (Non-Working) | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | = | = | ||||||||||
| = | are not included in the loaded | 0 | 0.00 | $0.00 | SUB-TOTAL | $1.01 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Forklift Operator | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.36 | |||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| Direct Labor Health Fund & Pension | 0 | 0.00 | 0.00 | - | ||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $23.23 | |||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension Rates | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Warehouse Specialist | 1 | 8.25 | $8.25 | 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 | $23.23 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $8.25 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Warehouse Specialist | 10 | 0 | $0.68 | |||||||||||||
| (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.68 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | ||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | H&W/Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Warehouse Specialist | 0.04 | 8.25 | $0.33 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.33 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $12.61 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $4.22 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $0.68 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH & WELFARE | $0.33 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $17.84 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $1.36 | ||||||||||||
| 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.36 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Janitor Loaded Wage Rate
| Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC0820R0012 | SOLICITATION NUMBER: | HDEC0820R0012 | SOLICITATION NUMBER: | HDEC0820R0012 | |||||||||||
| COMMISSARY: | MacDill AFB | COMMISSARY: | MacDill AFB | COMMISSARY: | MacDill 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 | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Custodian | 1 | 13.15 | $13.15 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $13.15 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE | $8.25 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $21.40 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $13.15 | Elements | Yearly | Price | Price | HOLIDAYS, SICK & VACATIONS | $0.71 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOL, SICK & VAC. HEALTH & WELFARE | $0.33 | |||||
| Indirect Labor Hours (Non-Working) | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | = | = | ||||||||||
| = | are not included in the loaded | 0 | 0.00 | $0.00 | SUB-TOTAL | $1.04 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Janitor | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.72 | |||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| Direct Labor Health Fund & Pension | 0 | 0.00 | 0.00 | - | ||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $24.16 | |||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension Rates | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Custodian | 1 | 8.25 | $8.25 | 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 | $24.16 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $8.25 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Custodian | 10 | 0 | $0.71 | |||||||||||||
| (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.71 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | ||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension rates for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | H&W/Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates | Pension | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Custodian | 0.04 | 8.25 | $0.33 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.33 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR COST | $13.15 | |||||||||||||||
| DIRECT HEALTH & WELFARE COSTS | $8.25 | |||||||||||||||
| HOLIDAYS/SICK/VACATION | $0.71 | |||||||||||||||
| HOLIDAYS AND VACATIONS HEALTH & WELFARE | $0.33 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $22.44 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $1.72 | ||||||||||||
| 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.72 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
File details come from the government source that posted it. Updated .