Attachment 3 - Volume I - Cost Breakout - CBA.XLS
XLS spreadsheet 307 KB Posted
- Attached to
- McGuire AFB Shelf Stocking, Receiving/Storage/Holding Area (RSHA), Custodial, and CLICK2GO Services
- Solicitation number
- HDEC08-20-R-0013
- Issued by
-
Defense Commissary Agency
About this file
This document contains cost breakout templates and instructions for responding to Solicitation Number HDEC08-20-R-0013 issued by the Defense Commissary Agency for shelf stocking, receiving, storage, holding area, custodial, and CLICK2GO services at McGuire Air Force Base. The templates require proposed costs to be entered for direct labor, health and pension benefits, holidays and vacations, fringe expenses, supplies and equipment, G&A costs, and profit for performing shelf stocking, receiving/storage/holding area, and custodial operations. Loaded hourly wage rate worksheets are also included for order fillers, shelf stockers, forklift operators, material handlers, and custodians. The templates calculate totals for base year and five option year periods and include cells to enter escalation percentages for the option years.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| HDEC08-20-R-0013 AMEND 0001.pdf | ||
| Attachment 5 - TDWS DLS - McGuire AFB.XLS | XLS spreadsheet | |
| Attachment 1 - McGuire AFB PWS Dated 12.16.2020 Addendum - CLICK2GO.DOCX | DOCX document | |
| Attachment 2 - WD 2020-0244 Revison 2 dated 12.3.2020 (CBA).pdf | ||
| Attachment 7 - Bereavement Leave Certification.doc | DOC document | |
| Attachment 4 - Volume II Technical Capability and Personnel.doc | DOC document | |
| Attachment 6 - Volume III Past Performance Information.doc | DOC document | |
| HDEC08.20.R.0013.pdf | ||
| Attachment 1 - McGuire AFB PWS Dated 12.16.2020.doc | DOC document |
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-0013 |
| 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: | HDEC08-20-R-0013 | SOLICITATION NUMBER: | HDEC08-20-R-0013 | SOLICITATION NUMBER: | HDEC08-20-R-0013 | ||||||||||||
| COMMISSARY: | McGuire Air Force Base | COMMISSARY: | McGuire Air Force Base | COMMISSARY: | McGuire Air Force Base | ||||||||||||
| 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 | 19.63 | $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 FUND & 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 | Dispenser, Tape | 0 | 0.00 | $0.00 | HOLIDAYS, SICK & VACATIONS | $0.00 | |||||||||
| = | = | = | = | Safety Shoes | 0 | 0.00 | $0.00 | HOL, SICK & VAC. HEALTH FUND & 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 Fund & Pension | 0 | 0.00 | $0.00 | EQUIPMENT & SUPPLIES | $0.00 | ||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension Rate 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 Cost | 0 | 0.00 | $0.00 | = | ||||||||||
| = | = | = | = | = | 0 | 0.00 | $0.00 | G&A | 0.00% | $0.00 | |||||||
| Store Worker I | 0 | 8.10 | $0.00 | 0 | 0.00 | $0.00 | |||||||||||
| Project Manager | 0 | 8.10 | $0.00 | 0 | 0.00 | $0.00 | PROFIT | 0.00% | $0.00 | ||||||||
| 0 | 8.10 | $0.00 | 0 | 0.00 | $0.00 | ||||||||||||
| 0 | 8.10 | $0.00 | 0 | 0.00 | $0.00 | = | = | ||||||||||
| 0 | 8.10 | $0.00 | 0 | 0.00 | $0.00 | GRAND TOTAL | $0.00 | ||||||||||
| 0 | 8.10 | $0.00 | 0 | 0.00 | $0.00 | = | = | = | = | ||||||||
| - | - | - | - | 0 | 0.00 | $0.00 | ANNUAL CASES | 1,439,256 | |||||||||
| 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 Rate for all employees not covered by the CBA. | |||||||||||||||||
| Holidays/Sick/ | |||||||||||||||||
| Vacations | Health Fund/ | Health Fund/ | |||||||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | ||||||||||||||
| = | = | = | = | = | |||||||||||||
| Store Worker I | 0 | 8.10 | $0.00 | ||||||||||||||
| Project Manager | 0 | 8.10 | $0.00 | ||||||||||||||
| 0 | 8.10 | $0.00 | |||||||||||||||
| 0 | 8.10 | $0.00 | |||||||||||||||
| 0 | 8.10 | $0.00 | |||||||||||||||
| 0 | 8.10 | $0.00 | |||||||||||||||
| - | - | - | - | ||||||||||||||
| TOTALS | 0 | $0.00 | |||||||||||||||
| = | = | = | = | ||||||||||||||
| FRINGE CALCULATIONS | |||||||||||||||||
| COST ELEMENT | DOLLARS | ||||||||||||||||
| = | = | = | = | = | = | ||||||||||||
| DIRECT LABOR | $0.00 | ||||||||||||||||
| DIRECT LABOR HEALTH FUND & PENSION | $0.00 | ||||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $0.00 | ||||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH FUND & 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
RSH
| SOLICITATION NUMBER: | HDEC08-20-R-0013 | SOLICITATION NUMBER: | HDEC08-20-R-0013 | SOLICITATION NUMBER: | HDEC08-20-R-0013 | |||||||||||
| COMMISSARY: | McGuire Air Force Base | COMMISSARY: | McGuire Air Force Base | COMMISSARY: | McGuire Air Force Base | |||||||||||
| 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 | 21.42 | $0.00 | COST ELEMENT | DOLLARS | |||||||||||
| Warehouse | 0 | 21.42 | $0.00 | = | = | |||||||||||
| Material Handler | 0 | 16.94 | $0.00 | Qty. | Unit/ | Extended | DIRECT LABOR | 0.00 | ||||||||
| Project Manager | 0 | 0.00 | $0.00 | Elements | Yearly | Price | Price | HEALTH FUND & 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, SICK & VACATIONS | 0.00 | ||||||||
| = | = | = | = | Safety Shoes | 0 | 0.00 | 0.00 | HOL, SICK & VAC. HEALTH FUND & 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 Fund & Pension | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | 0.00 | |||||||||||
| NOTE: Insert the appropriate Health Fund/Pension Rate 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 Cost | 0 | 0.00 | 0.00 | = | |||||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | G&A | 0.00% | 0.00 | ||||||
| Forklift Operator | 0 | 8.10 | $0.00 | 0 | 0.00 | 0.00 | ||||||||||
| Warehouse | 0 | 8.10 | $0.00 | 0 | 0.00 | 0.00 | PROFIT | 0.00% | 0.00 | |||||||
| Material Handler | 0 | 8.10 | $0.00 | 0 | 0.00 | 0.00 | ||||||||||
| Project Manager | 0 | 8.10 | $0.00 | 0 | 0.00 | 0.00 | = | = | ||||||||
| 0 | 8.10 | $0.00 | 0 | 0.00 | 0.00 | GRAND TOTAL | 0.00 | |||||||||
| 0 | 8.10 | $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 | 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 Rate for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Forklift Operator | 0 | 8.10 | $0.00 | |||||||||||||
| Warehouse | 0 | 8.10 | $0.00 | |||||||||||||
| Material Handler | 0 | 8.10 | $0.00 | |||||||||||||
| Project Manager | 0 | 8.10 | $0.00 | |||||||||||||
| 0 | 8.10 | $0.00 | ||||||||||||||
| 0 | 8.10 | $0.00 | ||||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.00 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR | $0.00 | |||||||||||||||
| DIRECT LABOR HEALTH FUND & PENSION | $0.00 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $0.00 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH FUND & 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-0013 | SOLICITATION NUMBER: | HDEC08-20-R-0013 | SOLICITATION NUMBER: | HDEC08-20-R-0013 | |||||||||||
| COMMISSARY: | McGuire Air Force Base | COMMISSARY: | McGuire Air Force Base | COMMISSARY: | McGuire Air Force Base | |||||||||||
| 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 | 16.04 | $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 FUND & 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, SICK & VACATIONS | 0.00 | ||||||||
| = | = | = | = | Cleaner, Compound | 0 | 0.00 | 0.00 | HOL, SICK & VAC. HEALTH FUND & 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 Fund & Pension | Floor Finish | 0 | 0.00 | 0.00 | EQUIPMENT & SUPPLIES | 0.00 | ||||||||||
| NOTE: Insert the appropriate Health Fund/Pension Rate 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 Cost | Gloves | 0 | 0.00 | 0.00 | = | ||||||||
| = | = | = | = | = | Gloves, Latex | 0 | 0.00 | 0.00 | G&A | 0.00% | 0.00 | |||||
| Custodian | 0 | 8.10 | $0.00 | Kintowel Wiper | 0 | 0.00 | 0.00 | |||||||||
| Project Manager | 0 | 8.10 | $0.00 | LiquidLive | 0 | 0.00 | 0.00 | PROFIT | 0.00% | 0.00 | ||||||
| 0 | 8.10 | $0.00 | Masks | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 8.10 | $0.00 | Mop Head, Wet | 0 | 0.00 | 0.00 | = | = | ||||||||
| 0 | 8.10 | $0.00 | Neutralizer | 0 | 0.00 | 0.00 | GRAND TOTAL | 0.00 | ||||||||
| 0 | 8.10 | $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 Rate 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/ | Health Fund/ | Buffer, High Speed | 0 | 0.00 | 0.00 | ||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | Burnisher High Speed | 0 | 0.00 | 0.00 | |||||||||
| = | = | = | = | = | Burnisher, 21" Propane | 0 | 0.00 | 0.00 | ||||||||
| Custodian | 0 | 8.10 | $0.00 | Caddy, Maid | 0 | 0.00 | 0.00 | |||||||||
| Project Manager | 0 | 8.10 | $0.00 | Carpet Extractor | 0 | 0.00 | 0.00 | |||||||||
| 0 | 8.10 | $0.00 | Floor Scrubber, Low Speed | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 8.10 | $0.00 | Scrubber, 20" | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 8.10 | $0.00 | Scrubber, Auto | 0 | 0.00 | 0.00 | ||||||||||
| 0 | 8.10 | $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 FUND & PENSION | $0.00 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $0.00 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH FUND & 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-0013 | |
| COMMISSARY: | McGuire Air Force Base | |
| CONTRACTOR NAME: | ||
| BASE YEAR GRAND TOTALS | ||
| DOLLAR TOTALS | ||
| ================ | ||
| COST ELEMENT | DOLLARS | |
| = | = | |
| DIRECT LABOR | 0.00 | |
| HEALTH FUND & PENSION | 0.00 | |
| = | = | |
| SUB-TOTAL | 0.00 | |
| HOLIDAYS, SICK & VACATIONS | 0.00 | |
| HOL, SICK & VAC. HEALTH FUND & PENSION | 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
2 Yr. Totals
| SOLICITATION NUMBER: | HDEC08-20-R-0013 | |||||
| COMMISSARY: | McGuire Air Force Base | |||||
| 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 |
| HEALTH FUND & 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, SICK & VACATIONS | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| HOL, SICK & VAC. HEALTH FUND & PENSION | 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-20-R-0013 | |||||
| COMMISSARY: | McGuire Air Force Base | |||||
| 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
Order Filler Loaded Wage
| Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC08-20-R-0013 | SOLICITATION NUMBER: | HDEC08-20-R-0013 | SOLICITATION NUMBER: | HDEC08-20-R-0013 | |||||||||||
| COMMISSARY: | McGuire Air Force Base | COMMISSARY: | McGuire Air Force Base | COMMISSARY: | McGuire Air Force Base | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| Order Filler Loaded Wage Rate Work Sheet | Order Filler Loaded Wage Rate Work Sheet | Order Filler Loaded Wage Rate Work Sheet | ||||||||||||||
| Direct Labor | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||
| Shelf Stocking Supplies & Equipment | ================ | |||||||||||||||
| WD | ||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Order Filler | 1 | 20.07 | $20.07 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $20.07 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | HEALTH FUND & PENSION | $8.10 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| Qty. | Unit/ | Extended | SUB-TOTAL | $28.17 | ||||||||||||
| - | - | - | - | Elements | Yearly | Price | Price | |||||||||
| TOTALS | 1 | $20.07 | = | = | = | = | = | = | HOLIDAYS, SICK & VACATIONS | $1.08 | ||||||
| = | = | = | = | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | HOL, SICK & VAC. HEALTH FUND & PENSION | $0.00 | |||||||
| 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.08 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | 0 | 0.00 | 0.00 | ||||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $2.24 | |||||||||||
| 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 Rate for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $31.49 | |||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Order Filler | 1 | 8.10 | $8.10 | 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.49 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | = | = | = | = | = | = | ||||||||||
| - | - | - | - | TOTALS | $0.00 | |||||||||||
| TOTALS | 1 | $8.10 | = | = | = | = | = | |||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Order Filler | 10 | 0 | $1.08 | |||||||||||||
| (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.08 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | ||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension Rate for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Order Filler | 0.0 | 8.10 | $0.00 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.00 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR | $20.07 | |||||||||||||||
| DIRECT LABOR HEALTH FUND & PENSION | $8.10 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $1.08 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH FUND & PENSION | $0.00 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $29.25 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $2.24 | ||||||||||||
| 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.24 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Store Worker I Loaded Wage Rate
| Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC08-20-R-0013 | SOLICITATION NUMBER: | HDEC08-20-R-0013 | SOLICITATION NUMBER: | HDEC08-20-R-0013 | |||||||||||
| COMMISSARY: | McGuire Air Force Base | COMMISSARY: | McGuire Air Force Base | COMMISSARY: | McGuire Air Force Base | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| Shelf Worker I Loaded Wage Rate Work Sheet | Shelf Worker I Loaded Wage Rate Work Sheet | Shelf 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 | 19.63 | $19.63 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $19.63 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | HEALTH FUND & PENSION | $8.10 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| Qty. | Unit/ | Extended | SUB-TOTAL | $27.73 | ||||||||||||
| - | - | - | - | Elements | Yearly | Price | Price | |||||||||
| TOTALS | 1 | $19.63 | = | = | = | = | = | = | HOLIDAYS, SICK & VACATIONS | $1.06 | ||||||
| = | = | = | = | Supplies and Equipment Costs | 0 | 0.00 | $0.00 | HOL, SICK & VAC. HEALTH FUND & PENSION | $0.00 | |||||||
| 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.06 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | 0 | 0.00 | 0.00 | ||||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $2.20 | |||||||||||
| 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 Rate for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $30.99 | |||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Store Worker I | 1 | 8.10 | $8.10 | 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.99 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | = | = | = | = | = | = | ||||||||||
| - | - | - | - | TOTALS | $0.00 | |||||||||||
| TOTALS | 1 | $8.10 | = | = | = | = | = | |||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Store Worker I | 10 | 0 | $1.06 | |||||||||||||
| (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.06 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | ||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension Rate for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Store Worker I | 0.0 | 8.10 | $0.00 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.00 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR | $19.63 | |||||||||||||||
| DIRECT LABOR HEALTH FUND & PENSION | $8.10 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $1.06 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH FUND & PENSION | $0.00 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $28.79 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $2.20 | ||||||||||||
| 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.20 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
FO-Warehouse Loaded Wage
| Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC08-20-R-0013 | SOLICITATION NUMBER: | HDEC08-20-R-0013 | SOLICITATION NUMBER: | HDEC08-20-R-0013 | |||||||||||
| COMMISSARY: | McGuire Air Force Base | COMMISSARY: | McGuire Air Force Base | COMMISSARY: | McGuire Air Force Base | |||||||||||
| 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/Warehouse | 1 | 21.42 | $21.42 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $21.42 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | HEALTH FUND & PENSION | $8.10 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $29.52 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $21.42 | Elements | Yearly | Price | Price | HOLIDAYS, SICK & VACATIONS | $1.16 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOL, SICK & VAC. HEALTH FUND & PENSION | $0.00 | |||||
| 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.16 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Forklift Operator | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $2.05 | |||||||||||
| 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 Rate for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $32.73 | |||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Forklift Operator/Warehouse | 1 | 8.10 | $8.10 | 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 | $32.73 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $8.10 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Forklift Operator/Warehouse | 10 | 0 | $1.16 | |||||||||||||
| (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.16 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | ||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension Rate for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Forklift Operator/Warehouse | 0 | 8.10 | $0.00 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.00 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR | $21.42 | |||||||||||||||
| DIRECT LABOR HEALTH FUND & PENSION | $4.22 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $1.16 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH FUND & PENSION | $0.00 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $26.80 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $2.05 | ||||||||||||
| 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.05 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Material Handler Loaded Wage
| Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC08-20-R-0013 | SOLICITATION NUMBER: | HDEC08-20-R-0013 | SOLICITATION NUMBER: | HDEC08-20-R-0013 | |||||||||||
| COMMISSARY: | McGuire Air Force Base | COMMISSARY: | McGuire Air Force Base | COMMISSARY: | McGuire Air Force Base | |||||||||||
| 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 | 16.94 | $16.94 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $16.94 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | HEALTH FUND & PENSION | $8.10 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $25.04 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $16.94 | Elements | Yearly | Price | Price | HOLIDAYS, SICK & VACATIONS | $0.91 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOL, SICK & VAC. HEALTH FUND & PENSION | $0.00 | |||||
| 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.91 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Forklift Operator | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.69 | |||||||||||
| 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 Rate for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $27.64 | |||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Material Handler | 1 | 8.10 | $8.10 | 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 | $27.64 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $8.10 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Material Handler | 10 | 0 | $0.91 | |||||||||||||
| (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.91 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | ||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension Rate for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Material Handler | 0 | 8.10 | $0.00 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.00 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR | $16.94 | |||||||||||||||
| DIRECT LABOR HEALTH FUND & PENSION | $4.22 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $0.91 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH FUND & PENSION | $0.00 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $22.07 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $1.69 | ||||||||||||
| 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.69 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
Custodian Loaded Wage Rate
| Attachment 4 | Attachment 4 | Attachment 4 | ||||||||||||||
| SOLICITATION NUMBER: | HDEC08-20-R-0013 | SOLICITATION NUMBER: | HDEC08-20-R-0013 | SOLICITATION NUMBER: | HDEC08-20-R-0013 | |||||||||||
| COMMISSARY: | McGuire Air Force Base | COMMISSARY: | McGuire Air Force Base | COMMISSARY: | McGuire Air Force Base | |||||||||||
| CONTRACTOR NAME: | CONTRACTOR NAME: | CONTRACTOR NAME: | ||||||||||||||
| Custodian Loaded Wage Rate Work Sheet | Custodian Loaded Wage Rate Work Sheet | Custodian Loaded Wage Rate Work Sheet | ||||||||||||||
| Direct Labor | Contractor Proposed | DOLLAR TOTALS | ||||||||||||||
| Custodial Supplies & Equipment | ================ | |||||||||||||||
| WD | ||||||||||||||||
| COST ELEMENT | Hours X | Rates = | Labor Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Custodian | 1 | 16.04 | $16.04 | COST ELEMENT | DOLLARS | |||||||||||
| = | = | |||||||||||||||
| NOTE: A QUANTITY OF 1 HAS BEEN ENTERED TO | DIRECT LABOR | $16.04 | ||||||||||||||
| CALCULATE THE LOADED HOURLY RATE. PROCEED | HEALTH FUND & PENSION | $8.10 | ||||||||||||||
| TO ENTER FRINGE, G&A, AND PROFIT PERCENTAGES | = | = | ||||||||||||||
| SUB-TOTAL | $24.14 | |||||||||||||||
| - | - | - | - | Qty. | Unit/ | Extended | ||||||||||
| TOTALS | 1 | $16.04 | Elements | Yearly | Price | Price | HOLIDAYS, SICK & VACATIONS | $0.87 | ||||||||
| = | = | = | = | = | = | = | = | = | = | HOL, SICK & VAC. HEALTH FUND & PENSION | $0.00 | |||||
| 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.87 | ||||||||||
| Direct Labor Hours (Productive/Working) | 1 | rate for Janitor | 0 | 0.00 | 0.00 | |||||||||||
| = | 0 | 0.00 | 0.00 | FRINGES | $1.91 | |||||||||||
| 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 Rate for all employees not covered by the CBA. | 0 | 0.00 | 0.00 | SUB-TOTAL | $26.92 | |||||||||||
| Health Fund/ | Health Fund/ | 0 | 0.00 | 0.00 | = | |||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | 0 | 0.00 | 0.00 | G&A | 0.00% | $0.00 | |||||||
| = | = | = | = | = | 0 | 0.00 | 0.00 | |||||||||
| Custodian | 1 | 8.10 | $8.10 | 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 | $26.92 | ||||||||||||
| 0 | 0.00 | 0.00 | = | = | = | = | ||||||||||
| 0 | 0.00 | 0.00 | ||||||||||||||
| - | - | - | - | = | = | = | = | = | = | |||||||
| TOTALS | 1 | $8.10 | TOTALS | $0.00 | ||||||||||||
| = | = | = | = | = | = | = | = | = | ||||||||
| Holidays, Sick, and Vacations | ||||||||||||||||
| Holidays/ | ||||||||||||||||
| Sick/ | Sick/Vacations | |||||||||||||||
| COST ELEMENT | Holidays | Vacations | Dollars | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Custodian | 10 | 0 | $0.87 | |||||||||||||
| (Work hours divided by ((2080 hours- | ||||||||||||||||
| (Holidays/Sick+ Vacations)*8))) * | ||||||||||||||||
| ((Closed Holidays*8*Hourly rate)+ | ||||||||||||||||
| (Holidays worked*8*Hourly rate* time & half))+ | ||||||||||||||||
| (Work Hours divided by(2080-((Holidays/Sick+ | ||||||||||||||||
| - | - | - | - | Vacations)*8)))*(Vacations *8*Hourly rate) | ||||||||||||
| TOTALS | 10 | $0.87 | ||||||||||||||
| = | = | = | = | |||||||||||||
| Holidays, Sick, and Vacations Health Fund & Pension | ||||||||||||||||
| NOTE: Insert the appropriate Health Fund/Pension Rate for all employees not covered by the CBA. | ||||||||||||||||
| Holidays/Sick/ | ||||||||||||||||
| Vacations | Health Fund/ | Health Fund/ | ||||||||||||||
| COST ELEMENT | Hours X | Pension Rates = | Pension Cost | |||||||||||||
| = | = | = | = | = | ||||||||||||
| Custodian | 0 | 8.10 | $0.00 | |||||||||||||
| - | - | - | - | |||||||||||||
| TOTALS | 0 | $0.00 | ||||||||||||||
| = | = | = | = | |||||||||||||
| FRINGE CALCULATIONS | ||||||||||||||||
| COST ELEMENT | DOLLARS | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| DIRECT LABOR | $16.04 | |||||||||||||||
| DIRECT LABOR HEALTH FUND & PENSION | $8.10 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS | $0.87 | |||||||||||||||
| HOLIDAYS, SICK, AND VACATIONS HEALTH FUND & PENSION | $0.00 | |||||||||||||||
| - | - | - | - | - | - | |||||||||||
| SUBTOTAL | $25.01 | |||||||||||||||
| = | = | = | = | = | = | |||||||||||
| FICA | X | 7.65% | = | $1.91 | ||||||||||||
| 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.91 | |||||||||||||||
| = | = | = | = | = | = |
Click Here to Print
File details come from the government source that posted it. Updated .