Attachment___19_Repair_WO's_Historical_Data.xlsx
XLSX spreadsheet 18 KB Posted
- Attached to
- Domestic Appliance Repair
- Solicitation number
- W564KV16R0033
About this file
Repair WO's Historical Data
View the file
Other files
Show all 35
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
Data Set 1 Attachment # 21 Repair WO's Historical Data Set 1
| Completed WO's for 13 Sep 12 thru 12 Sep 13 | Average WO's per month in Base Yr | Completed WO's for 13 Sep 13 thru 12 Sep 14 | Average WO's per month in 1st Opt. Yr | Completed WO's for 13 Sep 14 thru 12 Mar 15 | Average WO's per month in 2nd Opt. Yr | |
| Grafenwoehr Area: this Area includes Ansbach, Garmisch, Grafenwoehr, Vilseck and Hohenfels | 12497 | 1041 | 12573 | 1048 | 4400 | 733 |
| Rheinland-Pfalz Area: this Area includes Wiesbaden, Baumholder and KMC Area | 8321 | 693 | 8556 | 713 | 2718 | 453 |
| Stuttgart Area: this Area includes Stuttgart only | 3322 | 277 | 4978 | 415 | 2752 | 459 |
| Benelux Area: this Area includes Schinnen and Chievres | 3127 | 261 | 4210 | 351 | 1853 | 309 |
| Italy Area: this Area includes Vicenza and Livorno | 3745 | 312 | 4432 | 369 | 2601 | 434 |
| TOTAL WO's | 31012 | 2584 | 34749 | 2896 | 14324 | 2387 |
Data Set 2
| Attachment # 21 Repair WO's Historical Data Set 2 |
| Work Order Time Analysis - Current |
Germany 1NOV12-31DEC15
| Appliance Group | Work Orders | Sum of ActualTime | Average of ActualTime | Basic Rate Time | Total Average Time |
| Dishwasher | 8153 | 3958.60 | 0.49 | 0.5 | 0.99 |
| Dryer | 22961 | 16459.30 | 0.72 | 0.5 | 1.22 |
| Freezer | 31 | 28.00 | 0.90 | 0.5 | 1.40 |
| Ice Machine | 52 | 31.00 | 0.60 | 0.5 | 1.10 |
| Range electric | 6666 | 3419.20 | 0.51 | 0.5 | 1.01 |
| Range gas | 16 | 2.80 | 0.18 | 0.5 | 0.68 |
| Refrigerator | 11313 | 7013.70 | 0.62 | 0.5 | 1.12 |
| Washer | 21592 | 14090.81 | 0.65 | 0.5 | 1.15 |
Benelux 1NOV12-31DEC15
| Appliance Group | Work Orders | Sum of ActualTime | Average of ActualTime | Basic Rate Time | Total Average Time |
| Dishwasher | 711 | 176.50 | 0.25 | 0.5 | 0.75 |
| Dryer | 3965 | 1492.62 | 0.38 | 0.5 | 0.88 |
| Freezer | 197 | 73.40 | 0.37 | 0.5 | 0.87 |
| Range electric | 538 | 115.60 | 0.21 | 0.5 | 0.71 |
| Range gas | 132 | 49.50 | 0.38 | 0.5 | 0.88 |
| Refrigerator | 2296 | 850.79 | 0.37 | 0.5 | 0.87 |
| Washer | 4362 | 1209.31 | 0.28 | 0.5 | 0.78 |
Italy 1NOV12-31DEC15
| Appliance Group | Work Orders | Sum of ActualTime | Average of ActualTime | Basic Rate Time | Total Average Time |
| Dishwasher | 1570 | 933.40 | 0.59 | 0.5 | 1.09 |
| Dryer | 4270 | 3207.60 | 0.75 | 0.5 | 1.25 |
| Freezer | 82 | 82.80 | 1.01 | 0.5 | 1.51 |
| Range electric | 254 | 155.80 | 0.61 | 0.5 | 1.11 |
| Range gas | 1005 | 744.10 | 0.74 | 0.5 | 1.24 |
| Refrigerator | 2616 | 2061.90 | 0.79 | 0.5 | 1.29 |
| Washer | 4538 | 3013.10 | 0.66 | 0.5 | 1.16 |
| All Customer Not at Home removed |
| Bad Data Removed = 6% |
File details come from the government source that posted it. Updated .