Attachment_4_-_Sample_Monthly_Mgt_Reports.xls
XLS spreadsheet 43 KB Posted
- Attached to
- UHT Milk Europe & Turkey
- Solicitation number
- SPE303-17-R-0002
About this file
Attachment 4 - Sample Monthly Management Reports
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment__No.3-Items_Schedule-Offer_Sheets.xlsx | XLSX spreadsheet | |
| Attachment_No.1_-Commercial_item_description_for_Drinking_Milk_and_Milk_Products.docx | DOCX document | |
| Solicitation_(SOW)_-_SPE30317R0002.docx | DOCX document | |
| Attachment_No._2_Delivery_Locations.docx | DOCX 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
Sheet1
ATTACHMENT NO. 4
Customer Use
| Customer Monthly Sales January 1, through January 31 20XX | ||||
| Customer DODAAC | Name | # Deliveries | Quantity_sold | Total_sales |
| W1234 | DFAC Heidelberg | 8 | 48 | 532.00 |
| W2345 | DFAC Kleber Kaserne | 8 | 155 | 2,189.00 |
| W3456 | DFAC Ramstein | 6 | 69 | 699.00 |
| W4567 | DFAC Vogelwegh | 4 | 128 | 1,825.93 |
| W5678 | DFAC Sembach | 4 | 70 | 789.00 |
| W6789 | DFAC UK | 1 | 12 | 222.00 |
| W0123 | DFAC Mannheim | 8 | 162 | 4,163.07 |
| TOTAL | 644 | 10,420.00 |
DLA-G Customer Sales Report
#1 Fill Rate
| Customer Fill Rate January 1, through January 31 20XX | ||||||
| Customer_id | Name | Quantity ordered | Quanity received | Dollar Value Ordered | Dollar Value Received | Fill Rate |
| W1234 | DFAC Heidelberg | 48 | 48 | 532 | 532.00 | 100.00 |
| W2345 | DFAC Kleber Kaserne | 155 | 155 | 2,189 | 2,189.00 | 100.00 |
| W3456 | DFAC Ramstein | 69 | 69 | 699 | 699.00 | 100.00 |
| W4567 | DFAC Vogelwegh | 133 | 128 | 1,699 | 1,825.93 | 96.25 |
| W5678 | DFAC Sembach | 71 | 70 | 674 | 789.00 | 98.60 |
| W6789 | DFAC UK | 12 | 12 | 222 | 222.00 | 100.00 |
| W0123 | DFAC Mannheim | 162 | 162 | 4,163 | 4,163.07 | 100.00 |
| TOTAL | 650 | 644 | 10,178 | 10,420 | 99.08% |
DLA-G Customer Sales Report
#2 Financial Status
| Accounts Payable Status January 31, 20XX | ||||||||
| Customer | Name | 1-14 days | 15-21 days | 22-30 days | 31-45 days | 46-59 days | Above 60 days | |
| W1234 | DFAC Heidelberg | 241.00 | .00 | .00 | .00 | .00 | .00 | 241.00 |
| W2345 | DFAC Kleber Kaserne | 432.00 | .00 | .00 | .00 | .00 | .00 | 432.00 |
| W3456 | DFAC Ramstein | 889.00 | 385.00 | .00 | .00 | 78.00 | .00 | 1,352.00 |
| W4567 | DFAC Vogelwegh | -341.00 | 156.00 | .00 | .00 | .00 | .00 | -185.00 |
| W5678 | DFAC Sembach | 621.00 | .00 | 196.00 | .00 | .00 | 817.00 | |
| W6789 | DFAC UK | 391.00 | .00 | 288.00 | .00 | 91.00 | .00 | 770.00 |
| W0123 | DFAC Mannheim | |||||||
| 2,233.00 | 541.00 | 484.00 | .00 | 169.00 | .00 | 3,427.00 |
DLA-G Customer Sales Report
#3 descending dollar - Item use
| All items use January 1, through 31, 20XX | ||||||
| Stock Number | Description | Number of Deliveries | Quantity Sold | UOM | Ave Price Each | Total Sales |
| 8910-01-E12-….. | e.g. UHT Milk white 200 ml | 80 | 160 | CS | $ 9.74 | 1,558.40 |
| 40 | 52 | CS | $ 10.04 | 522.08 | ||
| 86 | 172 | CS | $ 17.06 | 2,934.32 | ||
| 72 | 98 | CS | $ 17.58 | 1,722.84 | ||
| 94 | 179 | CS | $ 17.84 | 3,193.36 | ||
| 102 | 165 | CS | $ 39.36 | 6,494.40 | ||
| 88 | 160 | CS | $ 42.10 | 6,736.00 | ||
| 78 | 200 | CS | $ 39.36 | 7,872.00 | ||
| 640 | 1,186 | $ 31,033.40 |
DLA-G Customer Sales Report
Customer Service Log
| Customer Service Report Period January 1, through 31 20XX | |
| Date | 1/2/14 |
| Customer | W1235 |
| Incident | Customer called they were shorted 3 cases of yogurt |
| Continued | |
| Result | 3 cases taken off invoice customer will re-order for next delivery |
| Continued | |
| Date | 1/12/14 |
| Customer | W2345 |
| Incident | |
| Continued | |
| Result | |
| Continued | |
| Date | 1/12/14 |
| Customer | W3456 |
| Incident | |
| Continued | |
| Result | |
| Continued |
DLA-G Customer Sales Report
Sheet2
Sheet3
Sheet4
Sheet5
File details come from the government source that posted it. Updated .