Appendix_16_-_Financial_Reports.pdf

FINANCIAL REPORTING

Contractor shall provide real-time financial reporting of the data indicated in the example’s below.

Weekly Financial Reporting - The contractor shall provide a weekly reports to DeCA/LEEF, in Microsoft Excel format, sent via e-mail to DeCA/LEEF, GSA CO and GSA PM containing the following information:

Store number, Store name, TI (Technical Instruction) number, Call-In Date, Statement of Objective (48 characters max.), Priority, System, Diagnosis Fee, Proposal cost, Acceptance date, Acceptance amount, Total cost, Cancellation date, Completion date, and DD250 date, Object Class Code (See Appendix 11), and Solution comments (48 characters max.). All dates shall be DD/MM/YY format.

There shall be one line for each TI. Stored numbers shall always be designated DODDACs assigned to that site (see Appendix 1). Each TI will proceed through five or six stages of data entry depending on whether it is executed or canceled. Each report shall include all TIs completed during the current billing period and all pending TIs. If a TI is cancelled it shall be considered completed. When a TI is cancelled, the OCC code shall remain the same. TI number shall not contain any dashes.

Store # Store Name TI # Call-In Date Statement of Objective System Priority Proposal Date Diagnosis Fee 120 Davis-Monthan AFB, AZ 120PF1376 07/21/2014 warehouse doors to store need to be replaced wi 21 2 07/21/2014 123 Fairchild AFB, WA 123PF1322 08/01/2014 Roll up ramp door #5 - binding and not working 06 2 08/22/2012 128 Ft Lewis, WA 128UM1662 08/30/2013 Condensatiopn build up on 2-1 szgd2-13 24 2 09/11/2013 115 Air Force Academy, CO 115UM1606 03/01/2013 sliding baggers doors not working today. 21 2 03/07/2013 115 Air Force Academy, CO 115UM1767 10/21/2013 Motor burnt out on balor. Needs to be fixed 21 2 10/23/2013 140 Mountain Home AFB, ID 140UM1496 06/25/2013 install Danfoss overlay. 24 2 09/23/2013 123 Fairchild AFB, WA 123PF1368 09/20/2012 DANFOSS UPGRADE 24 2 10/22/2012 118 Buckley AFB, CO 118UM1742 11/20/2013 need generator to supply entire commissary on F 09 2 133 Holloman AFB, NM 133UM1324 11/04/2011 Heat reclaim tank needs to be replaced 17 2 11/08/2011 146 Yuma MCAS, AZ 146PF1397 09/05/2012 Replace chiller condensor barrel 24 2 09/27/2012 141 Offutt AFB, NE 141UM1692 05/20/2013 the pins in bailer snapped and need to be repai 21 2 07/11/2013 133 Holloman AFB, NM 133UM1732 08/15/2013 upgrade the security system at Holloman AFB 21 2 08/15/2013 126 Ft Huachuca, AZ 126PF1536 11/15/2012 system keeps bouncing up and down. Need to repl 24 1 12/21/2012 120 Davis-Monthan AFB, AZ 120UM1553 03/04/2014 Steps leading down to rear parking lot need to 21 2 03/04/2014

Weekley Project Financial Report Example

Proposal Cost Accept. Date Acceptance Amount Total Cost Cancel Date Complete Date DD 250 Date OCC 2511 OCC 2512 OCC 2514 OCC 2516 $37,300.85 $0.00 $0.00 $7,403.31 $0.00 $0.00 $8,060.52 03/24/2014 $8,060.52 $8,060.52 $8,527.87 10/15/2013 $8,527.87 $8,527.87 10/28/2013 10/29/2013 $3,077.08 10/31/2013 $3,077.08 $3,077.08 11/26/2013 11/26/2013

$76,986.40 04/09/2014 $76,986.40 $76,986.40 $54,592.59 04/09/2014 $54,592.59 $54,592.59

$15,157.58 05/22/2014 $15,157.58 $15,157.58 $54,969.13 10/22/2013 $54,969.13 $54,969.13 02/27/2014 02/27/2014 $1,998.64 11/26/2013 $1,998.64 $1,998.64 11/26/2013 11/27/2013 $9,440.20 10/23/2013 $9,440.20 $9,440.20 01/27/2014 01/28/2014

$119,770.16 11/11/2013 $119,770.16 $119,770.16 03/22/2014 02/19/2014 $20,712.22 $0.00 $0.00

OCC 2519 OCC 2521 OCC 2522 OCC 2575 OCC 3148 OCC 3250 Solution $0.00 there are multiple doors that are cracked or br $0.00 Roll up door is damaged and binds while in use.

$8,060.52 Condensation build up on 2-1 FZGD2-13 $8,527.87 sliding baggers doors not working today.

$3,077.08 Motor burnt out on baler. Needs to be fixed

$76,986.40 Danfoss overlay $54,592.59 Request for Danfoss Overlay Upgrade need generator to supply entire commissary on F $15,157.58 Rack #3 heat reclaim tank is leaking refrigeran $54,969.13 The chiller evaporator barrel shell popped hole

$1,998.64 the pins in bailer snapped and need to be repai $9,440.20 upgrade the security system at Holloman AFB

$119,770.16 REFRIGERATION SYS NT WRKNG PROPERLY

system kee $0.00 Install concrete ramp..for ADA

Store # Store Name TI # Call-In Date Statement of Objective System Priority 068 Newport NSB, RI 068UM2012 10/16/2013 sink in produce has a hole in and has come unat 21 2 072 Quantico MCCDC, VA 072UM3794 10/20/2013 The cash office was told the socket was bad. N 09 2 070 Fort Belvoir, VA 070EM6997 10/28/2013 System #2 ICGD 1-13 24 1 049 Fort Detrick, MD 049UM4433 10/30/2013 49RTU-5 gas heat will not stay on-bad icy B and 17 2 043 Bolling AFB, DC 043UM6135 10/22/2013 SMP MATERIAL 21 2 068 Newport NSB, RI 068UM2025 10/30/2013 handles broken to the walk in freezer where mea 21 2 043 Bolling AFB, DC 043UM6149 11/04/2013 The electrical outlet next to the hand sink is 09 2 052 Forest Glen, MD 052UM4333 10/12/2013 Roof is leaking in deli area and in aisle 13. W 21 2 053 Bangor ANGB, ME 053UM4175 10/29/2013 The produce dock leveler needs a work order don 21 2 070 Fort Belvoir, VA 070UM7011 11/20/2013 SMP MATERIAL 21 2 070 Fort Belvoir, VA 070UM7025 11/30/2013 Baggers area womens bathroom sink needs repaire 21 2 070 Fort Belvoir, VA 070UM7026 11/30/2013 Register 11,15,16,27 need flasher fixed. Switch 21 2 046 Aberdeen PG, MD 046UM5000 10/30/2013 Would like the King Fisher Transmitter replaced 13 2 071 Fort Myer, VA 071UM3894 12/12/2013 lighting for the crawl space- lighting needs to 21 2

Weekley Financial Report Example

Proposal Date Diagnosis Fee Proposal Cost Accept. Date Acceptance Amount Total Cost Cancel Date Complete Date DD 250 Date OCC 2511 OCC 2512 10/17/2013 $1.00 $0.00 $1.00 10/17/2013 10/20/2013 $1.00 $0.00 $1.00 10/20/2013 10/28/2013 $1.00 $0.00 $1.00 10/28/2013 10/30/2013 $1.00 $0.00 $1.00 10/30/2013 10/23/2013 $164.90 10/24/2013 $164.90 $164.90 11/04/2013 $1.00 $0.00 $1.00 11/04/2013 11/05/2013 $1.00 $0.00 $1.00 11/05/2013 10/18/2013 $10,635.66 $0.00 $0.00 11/12/2013 $1.00 $0.00 $1.00 11/13/2013 11/22/2013 $1.00 $0.00 $1.00 11/22/2013 12/02/2013 $1.00 $0.00 $1.00 12/02/2013 12/02/2013 $1.00 $0.00 $1.00 12/02/2013 12/13/2013 $1.00 $0.00 $1.00 12/13/2013 12/13/2013 $1.00 $0.00 $1.00 12/13/2013

OCC 2514 OCC 2516 OCC 2519 OCC 2521 OCC 2522 OCC 2575 OCC 3148 OCC 3250 Solution $1.00 $1.00 $1.00 $1.00

$164.90 SMP MATERIAL

$1.00 $1.00 $0.00 Roof is leaking in deli area and in aisle 13 $1.00 Hydraulic dock leveler not operation properly.

$1.00 $1.00 $1.00