Attachment 3 - Cost Breakout Worksheet for Edwards AFB Commissary (HDEC0....xls
XLS spreadsheet 291 KB Posted
- Attached to
- Shelf Stocking, Receiving/Storage/Holding Area (RSHA), and Custodial Services - Edwards AFB Commissary
- Solicitation number
- HDEC08-20-R-0016
- Issued by
-
Defense Commissary Agency
About this file
This document package includes a solicitation for shelf stocking, receiving, storage, holding area, and custodial services at Edwards Air Force Base Commissary located near Lancaster, California. The Defense Commissary Agency is soliciting proposals for these services with the site visit and pre-proposal conference tentatively scheduled for June 4, 2020. The period of performance and pricing terms are not specified. The solicitation includes templates for offerors to submit pricing details for direct labor, fringe benefits, supplies and equipment, G&A, and profit for shelf stocking, RSHA, and custodial operations. It also provides loaded hourly wage rate worksheets for sample occupational categories.
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 |
| HDEC08-20-R-0016 |
| 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. |
Shelf Stocking
| SOLICITATION NUMBER: | HDEC08-20-R-0016 | SOLICITATION NUMBER: | HDEC08-20-R-0016 | SOLICITATION NUMBER: | HDEC08-20-R-0016 | ||||||||||||
| COMMISSARY: | Edwards AFB, CA | COMMISSARY: | Edwards AFB, CA | COMMISSARY: | Edwards AFB, CA | ||||||||||||
| 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 | ================ | ||||||||||||||||
| CBA | |||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | (The elements listed below are SAMPLES and are not considered | |||||||||||||
| = | = | = | = | = | a requirement of the solicitation.) | ||||||||||||
| Store Worker/FDS | 0 | 20.78 | $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 | DIRECT LABOR HEALTH & WELFARE and PENSION | $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 | HOLIDAYS / VACATIONS - HEALTH & WELFARE AND PENSION | $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 and Pension | 0 | 0.00 | $0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| H&W $3.10 | 0 | 0.00 | $0.00 | = | = | ||||||||||||
| Pension | H&W | 0 | 0.00 | $0.00 | TOTAL | $0.00 | |||||||||||
| COST ELEMENT | Hours X | $3.75 | Cost | 0 | 0.00 | $0.00 | |||||||||||
| = | = | = | = | = | 0 | 0.00 | $0.00 | G&A | 0.00% | $0.00 | |||||||
| Store Worker/FDS | 0 | 6.85 | $0.00 | 0 | 0.00 | $0.00 | |||||||||||
| Project Manager | 0 | 0.00 | $0.00 | 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 | 0 | 0.00 | $0.00 | = | = | ||||||||||
| 0 | 0.00 | $0.00 | 0 | 0.00 | $0.00 | GRAND TOTAL | $0.00 | ||||||||||
| 0 | 0.00 | $0.00 | 0 | 0.00 | $0.00 | = | = | = | = | ||||||||
| - | - | - | - | 0 | 0.00 | $0.00 | ANNUAL CASES | 176,652 | |||||||||
| TOTALS | 0 | $0.00 | 0 | 0.00 | $0.00 | = | = | = | |||||||||
| = | = | = | = | 0 | 0.00 | $0.00 | CASE PRICE | 0.0000 | |||||||||
| 0 | 0.00 | $0.00 | = | = | = | ||||||||||||
| Holidays and Vacations | 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/FDS | 10 | 0 | $0.00 | ( (Holidays + Vacations) * 8) | 0 | 0.00 | $0.00 | ||||||||||
| Project Manager | 0 | 0 | $0.00 | times Work Hours | = | = | = | = | = | = | |||||||
| 0 | 0 | $0.00 | divided by ( 2080 hours - | TOTALS | 0 | $0.00 | |||||||||||
| 0 | 0 | $0.00 | ( (Holidays + Vacations) * 8) ) | = | = | = | = | = | = | ||||||||
| 0 | 0 | $0.00 | times the hourly rate | ||||||||||||||
| 0 | 0 | $0.00 | in each category | ||||||||||||||
| - | - | - | - | ||||||||||||||
| TOTALS | 10 | $0.00 | |||||||||||||||
| = | = | = | = | ||||||||||||||
| Holidays / Vacations - Health & Welfare and Pension | |||||||||||||||||
| Holidays | H&W $3.10 | ||||||||||||||||
| Vacations | Pension | H&W | |||||||||||||||
| COST ELEMENT | Hours X | $3.75 | Cost | ||||||||||||||
| = | = | = | = | = | |||||||||||||
| Store Worker/FDS | 0 | 6.85 | $0.00 | ||||||||||||||
| Project Manager | 0 | 0.00 | $0.00 | ||||||||||||||
| 0 | 0.00 | $0.00 | |||||||||||||||
| 0 | 0.00 | $0.00 | |||||||||||||||
| 0 | 0.00 | $0.00 | |||||||||||||||
| 0 | 0.00 | $0.00 | |||||||||||||||
| - | - | - | - | ||||||||||||||
| TOTALS | 0 | $0.00 | |||||||||||||||
| = | = | = | = | ||||||||||||||
| FRINGE CALCULATIONS | |||||||||||||||||
| COST ELEMENT | DOLLARS | ||||||||||||||||
| = | = | = | = | = | = | ||||||||||||
| DIRECT LABOR | $0.00 | ||||||||||||||||
| DIRECT LABOR HEALTH & WELFARE and PENSION | $0.00 | ||||||||||||||||
| HOLIDAYS AND VACATIONS | $0.00 | ||||||||||||||||
| HOLIDAYS / VACATIONS - HEALTH & WELFARE AND PENSION | $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
RSHA
| SOLICITATION NUMBER: | HDEC08-20-R-0016 | SOLICITATION NUMBER: | HDEC08-20-R-0016 | SOLICITATION NUMBER: | HDEC08-20-R-0016 | |||||||||||
| COMMISSARY: | Edwards AFB, CA | COMMISSARY: | Edwards AFB, CA | COMMISSARY: | Edwards AFB, CA | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| RSHA Operations Work Sheet | RSHA Operations Work Sheet | RSHA Operations Work Sheet | ||||||||||||||
| Direct Labor | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||
| R/S/H Supplies & Equipment | ================ | |||||||||||||||
| CBA | ||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | (The elements listed below are SAMPLES and are not to be considered | ||||||||||||
| = | = | = | = | = | a requirement of the solicitation.) | |||||||||||
| Warehouse | 0 | 20.78 | $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 | DIRECT LABOR HEALTH & WELFARE and PENSION | 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 | HOLIDAYS / VACATIONS - HEALTH & WELFARE AND PENSION | 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 and Pension | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | 0.00 | |||||||||||
| H&W $3.10 | 0 | 0.00 | 0.00 | = | = | |||||||||||
| Pension | H&W | 0 | 0.00 | 0.00 | TOTAL | 0.00 | ||||||||||
| COST ELEMENT | Hours X | $3.75 | Cost | 0 | 0.00 | 0.00 | ||||||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | G&A | 0.00% | 0.00 | ||||||
| Warehouse | 0 | 6.85 | $0.00 | 0 | 0.00 | 0.00 | ||||||||||
| Project Manager | 0 | 0.00 | $0.00 | 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 | 0 | 0.00 | 0.00 | = | = | |||||||||
| 0 | 0.00 | $0.00 | 0 | 0.00 | 0.00 | GRAND TOTAL | 0.00 | |||||||||
| 0 | 0.00 | $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 | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| Holidays and Vacations | 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 | |||||||||
| Warehouse | 10 | 0 | $0.00 | ( (Holidays + Vacations) * 8) | 0 | 0.00 | 0.00 | |||||||||
| Project Manager | 10 | 0 | $0.00 | times Work Hours | = | = | = | = | = | |||||||
| 0 | 0 | $0.00 | divided by ( 2080 hours - | TOTALS | 0 | $0.00 | ||||||||||
| 0 | 0 | $0.00 | ( (Holidays + Vacations) * 8) ) | = | = | = | = | = | = | |||||||
| 0 | 0 | $0.00 | times the hourly rate | |||||||||||||
| 0 | 0 | $0.00 | in each category | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 20 | $0.00 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays / Vacations - Health & Welfare and Pension | ||||||||||||||||
| Holidays | H&W $3.10 | |||||||||||||||
| Vacations | Pension | H&W | ||||||||||||||
| COST ELEMENT | Hours X | $3.75 | Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Warehouse | 0 | 6.85 | $0.00 | |||||||||||||
| Project Manager | 0 | 0.00 | $0.00 | |||||||||||||
| 0 | 0.00 | $0.00 | ||||||||||||||
| 0 | 0.00 | $0.00 | ||||||||||||||
| 0 | 0.00 | $0.00 | ||||||||||||||
| 0 | 0.00 | $0.00 | ||||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.00 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR | $0.00 | |||||||||||||||
| DIRECT LABOR HEALTH & WELFARE and PENSION | $0.00 | |||||||||||||||
| HOLIDAYS AND VACATIONS | $0.00 | |||||||||||||||
| HOLIDAYS / VACATIONS - HEALTH & WELFARE AND PENSION | $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-20-R-0016 | SOLICITATION NUMBER: | HDEC08-20-R-0016 | SOLICITATION NUMBER: | HDEC08-20-R-0016 | |||||||||||
| COMMISSARY: | Edwards AFB, CA | COMMISSARY: | Edwards AFB, CA | COMMISSARY: | Edwards AFB, CA | |||||||||||
| 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 | ================ | |||||||||||||||
| CBA | ||||||||||||||||
| 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 | 19.45 | $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 | DIRECT LABOR HEALTH & WELFARE and PENSION | 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 | HOLIDAYS / VACATIONS - HEALTH & WELFARE AND PENSION | 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 and Pension | Floor Finish | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | 0.00 | ||||||||||
| H&W $3.10 | Floor Sealer | 0 | 0.00 | 0.00 | = | = | ||||||||||
| Pension | H&W | Floor Stripper | 0 | 0.00 | 0.00 | TOTAL | 0.00 | |||||||||
| COST ELEMENT | Hours X | $3.75 | Cost | Gloves | 0 | 0.00 | 0.00 | |||||||||
| = | = | = | = | = | Gloves, Latex | 0 | 0.00 | 0.00 | G&A | 0.00% | 0.00 | |||||
| Custodian | 0 | 6.85 | $0.00 | Kintowel Wiper | 0 | 0.00 | 0.00 | |||||||||
| Project Manager | 0 | 0.00 | $0.00 | LiquidLive | 0 | 0.00 | 0.00 | PROFIT | 0.00% | 0.00 | ||||||
| 0 | 0.00 | $0.00 | Masks | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 0.00 | $0.00 | Mop Head, Wet | 0 | 0.00 | 0.00 | = | = | ||||||||
| 0 | 0.00 | $0.00 | Neutralizer | 0 | 0.00 | 0.00 | GRAND TOTAL | 0.00 | ||||||||
| 0 | 0.00 | $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 | |||||||||
| Polish, Metal | 0 | 0.00 | 0.00 | |||||||||||||
| Holidays and Vacations | 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 | ||||||||
| Custodian | 10 | 0 | $0.00 | ( (Holidays + Vacations) * 8) | Sanitizer, Compound D2 | 0 | 0.00 | 0.00 | ||||||||
| Project Manager | 0 | 0 | $0.00 | times Work Hours | Soap, Hand, Liquid | 0 | 0.00 | 0.00 | ||||||||
| 0 | 0 | $0.00 | divided by ( 2080 hours - | Sponges | 0 | 0.00 | 0.00 | |||||||||
| 0 | 0 | $0.00 | ( (Holidays + Vacations) * 8) ) | Spray Bottle | 0 | 0.00 | 0.00 | |||||||||
| 0 | 0 | $0.00 | times the hourly rate | Spray Bottle Trigger | 0 | 0.00 | 0.00 | |||||||||
| 0 | 0 | $0.00 | in each category | Spray Buff | 0 | 0.00 | 0.00 | |||||||||
| - | - | - | - | Toilet Tissue, 96rl | 0 | 0.00 | 0.00 | |||||||||
| TOTALS | 10 | $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 / Vacations - Health & Welfare and Pension | Vaccuum Belts | 0 | 0.00 | 0.00 | ||||||||||||
| Visors | 0 | 0.00 | 0.00 | |||||||||||||
| Holidays | H&W $3.10 | Battery Charger | 0 | 0.00 | 0.00 | |||||||||||
| Vacations | Pension | H&W | Buffer, High Speed | 0 | 0.00 | 0.00 | ||||||||||
| COST ELEMENT | Hours X | $3.75 | Cost | Burnisher High Speed | 0 | 0.00 | 0.00 | |||||||||
| = | = | = | = | = | Burnisher, 21" Propane | 0 | 0.00 | 0.00 | ||||||||
| Custodian | 0 | 6.85 | $0.00 | Caddy, Maid | 0 | 0.00 | 0.00 | |||||||||
| Project Manager | 0 | 0.00 | $0.00 | Carpet Extractor | 0 | 0.00 | 0.00 | |||||||||
| 0 | 0.00 | $0.00 | Floor Scrubber, Low Speed | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 0.00 | $0.00 | Scrubber, 20" | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 0.00 | $0.00 | Scrubber, Auto | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 0.00 | $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 and PENSION | $0.00 | |||||||||||||||
| HOLIDAYS AND VACATIONS | $0.00 | |||||||||||||||
| HOLIDAYS / VACATIONS - HEALTH & WELFARE AND PENSION | $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-20-R-0016 | |
| COMMISSARY: | Edwards AFB, CA | |
| CONTRACTOR NAME: | ||
| BASE YEAR GRAND TOTALS | ||
| DOLLAR TOTALS | ||
| ================ | ||
| COST ELEMENT | DOLLARS | |
| = | = | |
| DIRECT LABOR | 0.00 | |
| DIRECT LABOR HEALTH & WELFARE and PENSION | 0.00 | |
| = | = | |
| SUB-TOTAL | 0.00 | |
| HOLIDAYS & VACATIONS | 0.00 | |
| HOLIDAYS / VACATIONS - HEALTH & WELFARE AND PENSION | 0.00 | |
| = | = | |
| SUB-TOTAL | 0.00 | |
| FRINGE CALCULATIONS | 0.00 | |
| SUPPLIES & EQUIPMENT | 0.00 | |
| = | = | |
| TOTAL | 0.00 | |
| G&A | 0.00 | |
| PROFIT | 0.00 | |
| = | = | |
| GRAND TOTAL | 0.00 | |
| = | = |
Click Here to Print
5 Yr. Totals
| SOLICITATION NUMBER: | HDEC08-20-R-0016 | |||||
| COMMISSARY: | Edwards AFB, CA | |||||
| 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 and PENSION | 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 |
| HOLIDAYS & VACATIONS | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| HOLIDAYS / VACATIONS - HEALTH & WELFARE AND PENSION | 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 |
| 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 |
| = | = | = | = | = | = | = |
| 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-20-R-0016 | |||||
| COMMISSARY: | Edwards AFB, CA | |||||
| 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% | ||
| = | = | = | = | = | = | |
| SUB-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% | ||
| = | = | = | = | = | = | |
| SUB-TOTAL | ||||||
| FRINGE CALCULATIONS | 0.00% | 0.00% | 0.00% | 0.00% | ||
| SUPPLIES & EQUIPMENT | 0.00% | 0.00% | 0.00% | 0.00% | ||
| = | = | = | = | = | = | |
| 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
Store Worker Loaded Wage Rate
| Attachment 3 | Attachment 3 | Attachment 3 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC08-20-R-0016 | SOLICITATION NUMBER: | HDEC08-20-R-0016 | SOLICITATION NUMBER: | HDEC08-20-R-0016 | |||||||||||
| COMMISSARY: | Edwards AFB, CA | COMMISSARY: | Edwards AFB, CA | COMMISSARY: | Edwards AFB, CA | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| Store Worker Loaded Wage Rate Work Sheet | Store Worker Loaded Wage Rate Work Sheet | Store Worker Loaded Wage Rate Work Sheet | ||||||||||||||
| Direct Labor | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||
| Shelf Stocking Supplies & Equipment | ================ | |||||||||||||||
| CBA | ||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Store Worker/FDS | 1 | $20.78 | $20.78 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $20.78 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE and PENSION | $6.85 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| Qty. | Unit/ | Extended | SUB-TOTAL | $27.63 | ||||||||||||
| - | - | - | - | Elements | Yearly | Price | Price | |||||||||
| TOTALS | 1 | $20.78 | = | = | = | = | = | = | HOLIDAYS/SICK/VACATIONS | $1.12 | ||||||
| = | = | = | = | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | HOLIDAYS / VACATIONS - HEALTH & WELFARE AND PENSION | $0.27 | |||||||
| 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.40 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | 0 | 0.00 | 0.00 | ||||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $2.22 | |||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| Direct Labor Health and Welfare and Pension | 0 | 0.00 | 0.00 | = | = | |||||||||||
| H&W $3.10 | 0 | 0.00 | 0.00 | TOTAL | $31.25 | |||||||||||
| Pension | H&W | 0 | 0.00 | 0.00 | ||||||||||||
| COST ELEMENT | Hours | $3.75 | Cost | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Store Worker | 1 | 6.85 | $6.85 | 0 | 0.00 | 0.00 | PROFIT | 0.00% | $0.00 | |||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | = | = | ||||||||||||
| 0 | 0.00 | 0.00 | GRAND TOTAL | $31.25 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | = | = | = | = | = | = | ||||||||||
| - | - | - | - | TOTALS | $0.00 | |||||||||||
| TOTALS | 1 | $6.85 | = | = | = | = | = | |||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick and Vacations | ||||||||||||||||
| Holidays, Sick, | ||||||||||||||||
| Sick/ | Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Store Worker | 10 | 0 | $1.12 | |||||||||||||
| (Work hours divided by ((2080 hours- | ||||||||||||||||
| (Holidays/Sick+ Vacations)*8))) * | ||||||||||||||||
| ((Closed Holidays*8*Hourly rate)+ | ||||||||||||||||
| (Holidays worked*8*Hourly rate* time & half))+ | ||||||||||||||||
| 0 | (Work Hours divided by(2080-((Holidays/Sick+ | |||||||||||||||
| - | - | - | - | Vacations)*8)))*(Vacations *8*Hourly rate) | ||||||||||||
| TOTALS | 10 | $1.12 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays and Vacations Health & Welfare and Pension | ||||||||||||||||
| H&W $3.10 | ||||||||||||||||
| Holidays/Sick/ | Pension | H&W | ||||||||||||||
| COST ELEMENT | Vacations | $3.75 | Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Store Worker | 0.0 | 6.85 | $0.27 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.27 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR | $20.78 | |||||||||||||||
| DIRECT LABOR HEALTH & WELFARE and PENSION | $6.85 | |||||||||||||||
| HOLIDAYS AND VACATIONS | $1.12 | |||||||||||||||
| HOLIDAYS / VACATIONS - HEALTH & WELFARE AND PENSION | $0.27 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $29.03 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $2.22 | ||||||||||||
| FUTA | X | 0.00% | = | $0.00 | ||||||||||||
| SUTA | X | 0.00% | = | $0.00 | ||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | ||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| - | - | - | - | - | - | |||||||||||
| TOTAL FRINGES | $2.22 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Warehouse Loaded Wage Rate
| Attachment 3 | Attachment 3 | Attachment 3 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC08-20-R-0016 | SOLICITATION NUMBER: | HDEC08-20-R-0016 | SOLICITATION NUMBER: | HDEC08-20-R-0016 | |||||||||||
| COMMISSARY: | Edwards AFB, CA | COMMISSARY: | Edwards AFB, CA | COMMISSARY: | Edwards AFB, CA | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| Warehouse Worker Loaded Wage Rate Work Sheet | Warehouse Worker Loaded Wage Rate Work Sheet | Warehouse Worker Loaded Wage Rate Work Sheet | ||||||||||||||
| Direct Labor | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||
| R/S/H Supplies & Equipment | ================ | |||||||||||||||
| CBA | ||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Warehouse Worker | 1 | $20.78 | $20.78 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $20.78 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE and PENSION | $6.85 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $27.63 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $20.78 | Elements | Yearly | Price | Price | HOLIDAYS/SICK/VACATIONS | $1.12 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOLIDAYS / VACATIONS - HEALTH & WELFARE AND PENSION | $0.27 | |||||
| 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.40 | ||||||||||
| 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 | $2.22 | |||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| Direct Labor Health and Welfare and Pension | 0 | 0.00 | 0.00 | = | = | |||||||||||
| H&W $3.10 | 0 | 0.00 | 0.00 | TOTAL | $31.25 | |||||||||||
| Pension | H&W | 0 | 0.00 | 0.00 | ||||||||||||
| COST ELEMENT | Hours | $3.75 | Cost | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Warehouse Worker | 1 | 6.85 | $6.85 | 0 | 0.00 | 0.00 | PROFIT | 0.00% | $0.00 | |||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | = | = | ||||||||||||
| 0 | 0.00 | 0.00 | GRAND TOTAL | $31.25 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $6.85 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick and Vacations | ||||||||||||||||
| Holidays, Sick, | ||||||||||||||||
| Sick/ | Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Warehouse Worker | 10 | 0 | $1.12 | |||||||||||||
| (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.12 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays and Vacations Health & Welfare and Pension | ||||||||||||||||
| H&W $3.10 | ||||||||||||||||
| Holidays/Sick/ | Pension | H&W | ||||||||||||||
| COST ELEMENT | Vacations | $3.75 | Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Warehouse Worker | 0 | $6.85 | $0.27 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.27 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR | $20.78 | |||||||||||||||
| DIRECT LABOR HEALTH & WELFARE and PENSION | $6.85 | |||||||||||||||
| HOLIDAYS AND VACATIONS | $1.12 | |||||||||||||||
| HOLIDAYS / VACATIONS - HEALTH & WELFARE AND PENSION | $0.27 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $29.03 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $2.22 | ||||||||||||
| FUTA | X | 0.00% | = | $0.00 | ||||||||||||
| SUTA | X | 0.00% | = | $0.00 | ||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | ||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| - | - | - | - | - | - | |||||||||||
| TOTAL FRINGES | $2.22 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Janitor Loaded Wage Rate
| Attachment 3 | Attachment 3 | Attachment 3 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC08-20-R-0016 | SOLICITATION NUMBER: | HDEC08-20-R-0016 | SOLICITATION NUMBER: | HDEC08-20-R-0016 | |||||||||||
| COMMISSARY: | Edwards AFB, CA | COMMISSARY: | Edwards AFB, CA | COMMISSARY: | Edwards AFB, CA | |||||||||||
| 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 | ================ | |||||||||||||||
| CBA | ||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Custodian | 1 | $19.45 | $19.45 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $19.45 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | DIRECT LABOR HEALTH & WELFARE and PENSION | $6.85 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $26.30 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $19.45 | Elements | Yearly | Price | Price | HOLIDAYS/SICK/VACATIONS | $1.05 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOLIDAYS / VACATIONS - HEALTH & WELFARE AND PENSION | $0.27 | |||||
| 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.32 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Janitor | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $2.11 | |||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| Direct Labor Health and Welfare and Pension | 0 | 0.00 | 0.00 | = | = | |||||||||||
| H&W $3.10 | 0 | 0.00 | 0.00 | TOTAL | $29.74 | |||||||||||
| Pension | H&W | 0 | 0.00 | 0.00 | ||||||||||||
| COST ELEMENT | Hours | $3.75 | Cost | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Custodian | 1 | 6.85 | $6.85 | 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 | $29.74 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $6.85 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick and Vacations | ||||||||||||||||
| Holidays, Sick, | ||||||||||||||||
| Sick/ | Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Custodian | 10 | 0 | $1.05 | |||||||||||||
| (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.05 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays and Vacations Health & Welfare and Pension | ||||||||||||||||
| H&W $3.10 | ||||||||||||||||
| Holidays/Sick/ | Pension | H&W | ||||||||||||||
| COST ELEMENT | Vacations | $3.75 | Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Custodian | 0 | 6.85 | $0.27 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.27 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR | $19.45 | |||||||||||||||
| DIRECT LABOR HEALTH & WELFARE and PENSION | $6.85 | |||||||||||||||
| HOLIDAYS AND VACATIONS | $1.05 | |||||||||||||||
| HOLIDAYS / VACATIONS - HEALTH & WELFARE AND PENSION | $0.27 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $27.62 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $2.11 | ||||||||||||
| FUTA | X | 0.00% | = | $0.00 | ||||||||||||
| SUTA | X | 0.00% | = | $0.00 | ||||||||||||
| Workman's Compensation | X | 0.00% | = | $0.00 | ||||||||||||
| Employer's Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Comprehensive General Liability | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| Other | X | 0.00% | = | $0.00 | ||||||||||||
| - | - | - | - | - | - | |||||||||||
| TOTAL FRINGES | $2.11 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
File details come from the government source that posted it. Updated .