Logistical Estimate Workbook (LEW version 11.6) 2 May 11

1. Logistical Estimate Workbook (LEW version 11.6)2 May 11 MAJ Damian Green, Programmer

2. Purpose • To provide logistical planners with a starting point for planning in support of Brigade Combat Team operations. • It provides an estimateon the supportability of a mission and a point of departure for more detailed planning • Expected users: Support Operations Officers, BCT/BN S4, Medical Operations Officers and their NCOs.

3. Capabilities CORE Capabilities Stand Alone OPTEMPO Ground Maint CL III(B) Concrete-HESCO Aviation Maint CL I, Water, Ice Trash Planning Factors Current Set FOB-COP-PB Construction CL V Force Ratio Calculator General Supplies Medical Trans

4. Shortfalls of the Program • It doesn’t know your current ‘true’ situation. The estimates provided are mathematical calculations based on historical averages. • LEW isn’t on your staff. In the end you have to be able to defend your estimate. LEW

5. Information about LEW • Built by LTC (R) David Sales, Support Operations Course instructor at FT Lee, VA (late 1990s) to fill a void for a simple calculator for mission analysis. • Improvements based on comments from the field. • damian.green@us.army.mil or david.sales@janusresearch.com • Posted on: • AKO files (https://www.kc.army.mil/book/groups/logistics-estimation-workbook-lew) • BCKS (LOGNET, BCKS S3/XO and SAMS net) • https://forums.bcks.army.mil/secure/CommunityBrowser.aspx?id=1 • Army approved planners: • CL I, II, II(P), III(B), IV, V, VIII, IX - OPLOG Planner – CASCOM • Medical- Benchmark Rate Structure – HRC

6. Logistical Estimate Workbook (LEW)Practical Exercise

7. LEW Capabilities Type of Operation CL II, III(P), IV, VI, IX, Mail CL I, Water, Ice Medical CL VIII FOB/COP Construction Trans Trash Concrete CL V Maint CL III(B) RSOI Defense Offense Stability The intent of this slide show is to provide a framework to understand the full capabilities of the LEW program in the context of a plausible scenario. The green buttons have been fleshed out, while the white cells are place holders. Use the buttons above if you want to skip around in the presentation or just move thru the slides to see how the information was gathered.

8. Situation: • Angola fractionalizing – Negative impact to Congo, Namibia, Botswana • Government of Angola (GOA) retains limited control of its nation. It has lost portions of its countryside & large portions of armed forces • Angola supported by China (military + economic) and Russia (economic) • US sees opportunity to reassert influence on southern African continent • US capacity is stretched thin due to other commitments • Army – Iraq, Afghanistan • Marines – Strategic Reserve • South African has pledged a brigade from its National Defence Force (SANDF) to be part of the coalition • African Union primarily peacekeeping force (willing to play a part following stabilization) • The Gov’t of Angola invited US forces to assist them stabilizing their country. US has deployed a HBCT in addition to other enablers to the region to assist the government in controlling currently ungoverned spaces.

9. Information about Angola A night picture of the Luanda Bay, in Angola. Nearly 30 years of civil war have destroyed industrial infrastructures, road and rail networks. The streets are full of four-wheel drive vehicles and scooters (petrol is obviously cheap) and traffic literally paralyses the city. When it rains, the streets themselves are often flooded due to a lack of pipes to accommodate and drain rain water. 90% of its population, which still lives in conditions of abject poverty. The national life expectancy is 41 years for men and 40 for women, the infant mortality rate is 145 out of every 1000, and illiteracy is very high, especially among women and in rural areas. The country ranks in the 160th place (out of 177) in the Human Development Report published by the United Nations in 2005.

10. 3-3 ID Task Organization The BSTB + HHT/BDE are supported by an organic maintenance and support platoon. The BSB provides it with it’s backup logistical support • Task Org Changes • + Aviation Company TF • + Forward Surgical Team • + BDE Logistics Support Team • + M1 Engine Repair Team • + Mortuary Affairs Team • + EOD Team • Changes to OPTEMPO • Personnel • +100 Military • +50 Civilians • Equipment • + 4x AH-64 • + 4x CH-47 • + 2x HH-60 • + 4x M978 • + 24x M1151 gun trucks • + 2x MRAP • + 5x LMTV • + 6x 10K forklifts • + 4x 50K water bags • + 4x 50K fuel bags Forward Support Companies (FSC) X 3-3 ID HHT BSTB BSB 1-15 IN 2-69 AR 3-1 CAV 1-10 FA BSTB 203 BSB F 203 E 203 D 203 G 203 HQ PLT HQ Section DFAC Distribution PLT CLIII/Water General Supply Section CL V Section Maintenance Platoon Service and Recovery Maintenance Section 2-5x Maintenance Support Tms FSC’s are assigned to the Brigade Support Battalion and then given a command relationship to its support battalion (i.e. attached, OPCON, TACON). They are the primary support for that battalion. Each of the FSC’s are organized exactly the same. The difference between them is the amount of equipment and personnel based on the type of unit that they support. HHC 203 A 203 B 203 C 203 HQ Section DFAC Command Group S1 (Personnel) Unit Ministry Team S2 (Intelligence) S3 (Operations) S4 (Supply/Maint) S6 (Signal) SPO (Logistical Support Coordination) CSSAMO (STAMIS) HQ Section Distribution PLT Fuel/Water PLT Fuel Section Water Purification Supply PLT CL IX Section General Supply Section Ammunition Transfer / Holding Point Section HQ Section Shop Office Movement Security PLT Service and Recovery Mechanical Maintenance PLT Ground Support PLT Armament DSESTS Missile Ground Support Equipment Electronics Maintenance HQ Section Treatment PLT Laboratory Dental X-Ray Patient Hold Pharmacy Mental Health Preventative Medicine Evacuation PLT BDE Medical Supply

11. 3-3 ID Current Set This worksheet is designed to be printed and used as a memory jogger during mission analysis and while using this program. It includes most of the sustainment functions and the doctrinal capabilities for the unit selected. For example, based on the task organization changes, I’ve put some comments off to the side. Programmer Note: These notes won’t change any underlying formulas or calculations. To make those changes you need to update either the OPTEMPO or Planning worksheets.

12. OPTEMPO Worksheet • Programmer Note: • Body armor status added based on discussion on changing perception of US forces amongst the population. • Mental health calculations brought in based on perceived need • NBC status now calculates individual water requirement Fuel – Tracks consume by hours, Wheels by distance, Helicopters by flight hours. Remember the time assumes 100% of your vehicles are driving, so take that into consideration, by reducing the average times/distance EPW + Civilians – If you think you’ll be responsible for multiple days, you have to continue to fill out more cells to the right. DNBI Rate – Find the nearest or most similar country Opposition Factor – Must use the Combat Power Ratio worksheet and should work with an S2/S3 to figure it out

13. 1 2 Based on the attachments to the BCT, add in the additional 150 people. This impacts all consumption factors. Select from the drop down box the type of unit that you want to analyze for. Enter in changes to the MTOE organization in the yellow cells 3 Add in the additional equipment that the program tracks into the yellow cells. If you already have 2 items and you receive 2 more, pull 4 in the yellow cell. If you don’t have some of this equipment put a 0 in the yellow cell. The assumption is that the unit starts at 100% fill for personnel and equipment. • Programmer Note: • Green cells have CL V data calculations • Red cells are the MTOE #’s for the unit selected • Yellow cells allow you to override the defaults

14. Concept of OperationsPhase I- Deployment • 7 days- Equipment is loaded at FT Benning, GA onto rail cars and shipped to Savanna, GA. • 4 days- A RO/RO (roll-on/roll-off) vessel is loaded with the task organized brigade combat team’s vehicles, equipment and supplies. • 6.5 days- The vessel travels 6,800 nautical miles to the port at Launda, Angola (24 knots speed = 44 kph) • 30 hour flight (incl. ground time)- Personnel move from FT Benning, GA’s Lawson Army Airfield to Luanda De Fevereiro Airport in Angola via 12x Commercial Reserve Air Fleet (CRAF) B-747 aircraft. (Stops at Guyana and Brazil) • Starting Point Facts: • Unit has 100% MTOE personnel and equipment. • Logistical vehicles aren’t armored (not enough in inventory and the perceived threat isn’t high enough) • Battalions were allocated 3x 20’ containters each for equipment. Rest of gear was combat loaded on individual vehicles. • BSB received 4x 20’ containers of CL IX parts (engines, transmissions, etc…) to augment the Authorized Stockage List (ASL) from Army Materiel Command (AMC) • Planning weight for the aircraft is 400 lbs per person • Personnel will fly when vessel is 3 days from arrival at SPOD. Relevant logistical information CL I (food/water): Soldiers have 2x DOS on them (consumption starts upon arrival in Angola (aircrew provides meals enroute). Bulk water tanks and blivets are empty. CL III(B): Vehicles ship with 75-50% in individual fuel tanks, fuel tankers are purged CL V: Soldiers will fly with force protection ammunition. Vehicles won’t be combat configured for safety reasons. CL II, III(P), IV, VI, VIII and IX: Authorized stockages are at 100% fill, have completed a review of ASL prior to notification.

15. Concept of OperationsPhase II- RSOI Reception: Staging: Onward Movement: Integration: Expected enemy threat during phase: Low Relevant logistical information CL V: Soldiers fly with force protection ammunition only. Unit Basic Load (UBL) arrives on a separate vessel. CL I: Rations are on the boat that brought the unit’s equipment. Plan to draw them during RSOI and receive the rest by SUS BDE unit distribution. Potable Water: The BSB’s Preventive Medicine Officer has certified a local bulk water point near the SPOD to allow us to top off prior to convoy operations. Medical: There is a Combat Support Hospital (CSH) getting established during the same time that we’re arriving. They have established a Troop Medical Clinic and have placed some of their medics at the various nodes to support our onward movement.

16. Maintenance (Ground and Air)RSOI- Day 1-5 1 The number of pieces of equipment is pulled from the OPTEMPO sheet. You can set the starting operational readiness rate. Use the plus box to expand out which level the equipment is repairable at. The recovery plan for this example would be like vehicle tow forward from the SPOD to the maneuver battalion’s assembly area. Once there, the Forward Support Company’s (FSC) would position 1x M88 to each maneuver company to support recovery back to the Unit Maintenance Collection Point (UMCP). Evacuation from the UMCP to the BSA is likely to be by M88’s, since the task organization didn’t include Heavy Equipment Transports (HET). This will also prove to be a challenge for evacuation back to the SPOD for shipment to the United States for sustainment level repairs. B/203 provides repair of Line Repairable Units (LRU) for the M1 / M2 fleet / M109A6 vehicles from the BSA using its DSESTS. The missile contact team will respond on-call from the BSA out to the UMCP. Engine + transmissions will be swapped out using a Full Up Power Pack (FUPP), of which the brigade has 4. The broken FUPP will be brought back via convoy and repaired by the M1 Engine Repair Team at the BSA (historically this could be a couple of days). • Programmer Note: • The program can’t tell you the fault (mobility, firepower, communication, catastrophic, etc…), nor how it happened. • Onsite/FMT and UMCP = fixed in the same column (however long you set the column for – in this example 24 hours) • UMCP/BSA (Longer Repair) = fixed in the next column regardless of time. • Consider EAB + Non-repairable for controlled exchange or cannibalization. Ensure policy matches the need. Assumptions: We’re not expected any CL VII major end item replacements for at least 30-60 days and the ship will be scheduled based on requirements.

17. CL III(B)RSOI- Day 1 (Initial Top-off) To determine how much full you need to prepare the vehicles as they come off the boat go thru the following steps: 2 CL III(B): Change all of the percent fills to reflect that only the individual vehicles fuel tanks will have between 50-75% fill. All other fuel assets will have to be filled upon arrival at the port. 1 OPTEMPO: 1. Enter in the number of hours that tracked vehicles are going to be running (cross country, secondary roads and tactical idle) 2. Enter the average distance that wheeled vehicles will travel 3. Enter the expected flight hours for helicopters and UAS (Unmanned Aerial Systems) 3 CL III(B): Based on the vehicle types, % fill and expected usage, the projected consumption is 35,464 gallons for RSOI. This doesn’t include the need to fill up the vehicle fuel tanks, fuel tankers and fuel bags which is another 464,099 gallons (obviously you don’t want to fill the fuel bags until they are set up at the BSA location). Programmer Note: Bulk fuel storage is a new capability. If the cell is greyed out, the BSB’s fixed storage tanks aren’t set-up • Decisions: • Where is the fuel coming from? • Host nation (fuel sample testing required especially since you’re using it for aircraft) Assumptions: RSOI fuel consumption includes movement of vehicles to staging area. No intra-theater training events Aircraft fuel consumption includes a test flight

18. CL III(B)RSOI- Day 1 (Initial Top-off) 1 CL III(B): Program-ism: Fuel must come into the program thru the Sustainment BDE to Brigade Support Battalion cells. Since the BSB’s fuel bags aren’t set up at this time (user selects “No”), all fuel needs to go to the fuel trucks. This will make them over 100% fill, until you move the fuel out. The BSB fuel tankers then conduct a DS to ORG refill as well as a DS to individual fuel tanks. A stand-alone tool to help you understand operational reach for your force is below. One variation of it requires the vehicles fuel tank capacity, cruising speed and fuel consumption data. By looking at your highest consumer (i.e. M1A2 Abrams Tank) you can state your forces operational reach without a fuel resupply. Programmer Note: The bulk fuel storage doesn’t automatically dump the fuel when you say that your bags aren’t set up after you’ve have previously had fuel in them. What is your plan to empty them before shutting down? Assumptions: Host nation provides bulk and retail fuel at the staging area. Fuel bags won’t be set up until the BSB arrives at its final destination.

19. CL III(B)RSOI- Day 2-5 (Convoy Operations) x SUS 1 OPTEMPO: Convoys will travel 300 km from SPOD via the northern route to the AO over the period of 4 days. Once units arrive in the AO they will conduct limited patrolling to gain situational awareness and to establish local security. CL III(B): Fuel from the previous column provides the starting on-hand fuel balance. Conducting mission analysis, IF you didn’t conduct another resupply to the individual vehicles they would be at 11% fill upon completion of the convoy, and out of fuel sometime the next day. Assumptions: Refueling during the convoy will be by-exception. Fuel tankers will travel with each convoy but the plan is that the top-off occurs upon arrival.

20. Brigade Support Area (BSA) • Planning considerations: • Outside of city, ideally uninhabited • Near airstrip (only need access to in emergency) • Water source inside or adjacent to perimeter • Interior roads if possible. • Commander’s Guidance • Consolidate all rear units into a single perimeter based on road network, … B/203 AVN TF BSTB A/203 C/203 BDE TOC BSB TOC BSTB TOC 3-1 CAV FSC + ALOC 2-69 FSC + ALOC 1-15 FSC + ALOC ROWPU 1-10 FSC + ALOC

21. CL III(B)RSOI- Day 2-5 (Convoy Operations) 1 CL III(B): Start at the bottom of the worksheet and work upwards. The solution below is one way to solve this requirement. Our convoy plan had the BSB fuelers move out on the 1st convoy day. This allowed them to refuel vehicles at the destination, which also allowed the org fuelers to remain at 100% fill. Doctrinally the BSB remains forward and receives fuel pushed to it, so we need to coordinate for a SUS BDE resupply. Let’s assume that they only have enough fuelers to push us a maximum of 19x 5K tankers on the first day, so we ask for our 1st resupply to refill our DS tankers. Then next day, we have coordinated for the Sus BDE to fill the bag farm. On final day of convoy operations / local security operations we have to fill up the maneuver battalions as they prepare to move to their defensive position. The SUS BDE has confirmed that they aren’t able to bring 100% of our requirement but are bringing 91,500 but the end of the day. Assumptions: The BSB bulk fuel bags will be set up upon arrival in AO but it will take a day to build up the berms, set the bags, lines and pumps in place before they can be filled.

22. This tool assumes that all vehicles in a group have the same fuel requirement or will get the same amount of fuel. Enter your data in the blue cells CL III(B)ROM Tool (Stand Alone) This example assumes that we’re conducting a ROM for all M1, M2, M3 vehicles of an HBCT, topping them off when they are at 50% fill. The program assumes that you’ll bring in the vehicles based on the # of fuel points NOT necessarily by unit integrity. Fill in the cells that describe your ROM site. If you have a time constraint enter in the # of minutes that you’ve been given to see if you can issue enough fuel in time.

23. Medical RSOI- Day 1-5 (Port Ops, Convoy and Local Ops) 1 • OPTEMPO: • For every column enter: • Surprise Factor: Ability of enemy to surprise you at tactical level • Pattern of Operation: Status of defenders front • Weather: Poor weather reduces casualties on both sides • Terrain: More constricted terrain reduces casualties • OPTEMPO/Environmental Stressors: Mental health factor • Individual Stressors: Mental health factor • For entire workbook enter: • Operational location: Find the closest location to get your DNBI rate • Overall type of operation: • Opposition Factor: Get this by using the Force Ratio Calculator (next slide) • Sophistication Factor: Determine how much more CAS, artillery or better weapons you have over the enemy • Level of unit: Helps determine CL VIII consumption • Quality of Unit: Decreases mental health issues • Body Armor status: Changes the KIA/WIA rate Assumptions: Nigeria DNBI rates should be similar to Angola. We won’t pick up civilians or EPWs that we’ll have to medically treat until we start Local Ops phase. We’ll pass them on to the local authorities.

24. Force Ratio Calculator • Enemy Operational Timeline: • Can’t resume attack for 8 days • Believes that they can defeat the US forces in their zone. • Perceives weakness based on US performance in other areas in world and how told by local propaganda. T: Protect northern flank of main effort P: II II • Located towards the last worksheet • Enter in friendly (left) and enemy (right) combat forces on the worksheet • This step requires a conversation with the BDE S2 and S3 as to how the unit is going to be task organized as well as the expected enemy capabilities. • Example of how to customize: • 4x AH-64 = 16% of an Atk Helo Bn (24x AH-64). • 1 Combined Arms Battalion (CAB) = ½ of an Infantry and half of an armor battalion. So 2x CAB’s equal 100% of one each. Put this result on the OPTEMPO worksheet. Impacts casualty rates. T: Seize Ballundo airfield P:

25. Medical RSOI- Day 1-5 (Port Ops, Convoy and Local Ops) 1 Medical: Red cells are the book answer for casualty rates per day. Override the result using the yellow cell. Plus boxes expand to show the US vs EPW casualties to force you to consider guard requirements at your medical treatment locations. Since the Brigade Support Medical Company is uploaded and moving to the BSA, these casualties must be treated by someone else. These casualties exceed the BSMC’s patient hold capability (beds, tentage, nurses, medics, equipment sets). Need to come up with a plan to increase capability or evacuate the patients Program Assumptions: Uses an attrition algorithm developed by Colonel Trevor N. Dupuy, USA (Ret), with a variety of additional modifications to the calculation. The greatest deviation was 41%, the least deviation was less than 0.5% comparing the programs results against multiple wars fought from 1805-1989, with over 45% of the battle casualties estimated to within 5%. Assumptions: Accidents at the port, during convoy operations and in the area of operations will lead to some deaths (KIA) throughout the task force. Additionally expect that some Soldiers will become separated from the force and become captured. Given the distance to Angola from the United States, the planners have a 240-bed CSH (Corps Support Hospital) established at the SPOD. Theater evacuation policy is set to 20 days. Expect to receive 1st flight of replacements in 15 days.

26. Medical RSOI- Day 3-5 (Local Ops) 1 BSB BSTB Medical: Customize the number of Air Ambulances available based on the brigade’s task organization. Set the average # of patients that will be evacuated per trip by vehicle type. Huge decision when you have to ground evacuate over long distances with limited number of platforms. Set the number too low and you’ll have to make more trips, set the number too high and your ambulances are waiting to make the trip. Either setting can lead to a higher died of wounds rate [not a current capability of the program- you have to bring this out]. Given the short distances to the Battalion Aid Stations (BAS), the extended route back to the CSH which is at the SPOD, we’re not going to have C/203 push out an Ambulance Exchange Point (AXP) but rather use the 6x M997’s for ground evac to level III. Also we’re going to push out the 6x M113’s each BAS for evac to the BSMC. The picture to the right shows the planned layout of evacuation platforms for the brigade along with distances to the next level of care. 30km 5x M113 Amb + 1x C/203 M113 15km 6x M113 Amb + 1x C/203 M113 12km 3x M997 Amb + 1x C/203 M113 20km 6x M113 Amb + 1x C/203 M113 300km 2x UH-60 2x M113 Amb 6x M997 Amb Assumptions: All MEDEVAC aircraft pass their test flights within 36 hours after downloading from the ship and are available for missions in support of the Local Ops (from day 3-onward). Aircraft will base out of the Brigade Support Area (BSA). One aircraft will fly to BAS and onward to the CSH, while the second will fly from the BSA to the CSH.

27. Medical RSOI- Day 3-5 (Local Ops) – Company to Level I 1 Medical: The casualty numbers at the top are a roll-up of US and EPW’s. Litter and ambulatory numbers are based on historical averages. Since this is a brigade roll-up, I’ve averaged the distance that the maneuver companies will be from their BAS. I figure that over time companies will push further away from the BAS. Also assumed that the average rate of march would remain the same over this terrain. Note that as the battlespace expands, the ground evacuation time increases by more than double. Need to figure out how patients are going to be stabilized for the more than hour drive to the battalion surgeon and physician’s assistant. [Note the program doesn’t consider splitting the BAS into a forward and main aid station- but you could by decreasing the distance to the BAS]. According to the math you don’t have an ground evacuation shortfall and therefore don’t need to plan for non-standard CASEVAC. Programmer Note: You don’t have to analyze every column. Pick the critical events or times. Also, these columns aren’t like fuel. Each one can be looked at independent of the previous column’s result. For this example I’ve ignored Port Ops and Convoy Ops Assumptions: Company medics are forward with the maneuver companies, have PROFIS surgeons in each BAS and that there is a ground evacuation route from the companies to the BAS.

28. Medical RSOI- Day 3-5 (Local Ops) – Level I to Level II/III 1 Medical: Since we’re not going to evacuate from the BAS to an AXP but rather use ground and air evacuation from the BAS, scroll down to the From AXP section. [assume that the AXP is at the BAS] Based on the 1st medical slide standard, 1x UH-60 MEDEVAC will fly from the BSA to the BAS pickup patients that require level III care and fly them to the CSH. As you can see, this flight will push the helicopters to their maximum flight times, with a refueling required at the SPOD before returning to the BSA. [The program thinks that aircraft can fly throughout the time period without rest. If a crew is expected to fly 12 hours in a 24 hour day, manually adjust the number of trips to 3 to make the plan sustainable.] The remainder of the patients will be ground evacuated to the BSMC using the forward positioned M113 ambulances. Based on the math, again we don’t have a shortfall in evacuation. Assumptions: CSH has a MEDEVAC LZ/PZ established. Part of the AVN TF has fuel and maintenance capability at or vicinity the CSH’s location.

29. Medical RSOI- Day 3-5 (Local Ops) – Level II to III 1 Medical: Enter the distance to the CSH from the BSMC. Based on the 1st medical slide standard, the remaining 1x UH-60 MEDEVAC will fly from the BSA, in support of the BSMC and the Forward Surgical Team (FST) and fly patients to the CSH once they are stabilized. Again consider the flight times and reduce the total trips available to provide for crew rest, in order to provide a sustainable plan. The remainder of the patients will be ground evacuated from the BSMC to the CSH using the 6x M997 ambulances. Based on the math, again we don’t have a shortfall in evacuation. However, look at the round trip time of 20 hours, 30 minutes. Keeping patients stabilized for that length of time will be a challenge. We could mitigate this by asking the CSH to forward position some of their capability, plan for 1-2 of the CH-47’s to backhaul patients or request fixed wing assets to fly into the small airport outside of the BSA to support evacuation. Assumptions:

30. Medical RSOI- Day 3-5 (Local Ops) – CL VIII 1 Medical: Default number of patients per Medical Equipment Set (MES) before it must be replenished / tools sterilized. Medics + BAS – Role I The table breaks down the expected usage of the trauma and sick call MES. Resupply comes via ambulance backhaul from either the BSMC at the BSA or via UH-60 flying from the CSH. BSMC – Role II Breakdown for the MES for the medical company. The company has a CL VIII section which provides resupply to itself as well as the brigade’s BAS’. The movement of CL VIII is by either logistical convoys or by ambulance backhaul. FST – Stabilize for treatment to Level III Doctrine: Able to handle 72 hours of continuous operations or up to 30 patients before resupply. They provide their own tent but require power, patient hold support, in addition to life support from the BSMC. Given the projected casualties, expect that the FST will need to be resupplied and either augmented to increase their capacity or risk assumed that patients may die in transit because there wasn’t enough time to stabilize them prior to transport. Programmer Note: Based on the concept of support already provided you can assume that most of the medical supplies consumed in the first column wouldn’t be from your formation. Assumptions: Requests for resupply will be via Blue Force Tracker (BFT), Harris radio, FM or paper requests until units get established. It will transition to the medical STAMIS using unit’s VSAT or CPN.

31. CL I, Water, IceRSOI- Day 1-5 (Initial Top-off, Convoy and Local Ops) 1 CL I-Water-Ice: Soldiers will draw (supply point) during RSOI 4x days of supply (DOS) of MREs and bottled water. FSC’s and the BSB will draw another 1x DOS each. Total of 6x DOS of MRE’s. The next resupply will pushed to the BSB in the AO. Local food is off-limits (expect some to eat it and get sick- which will impact your DNBI rates). The proposed BSA has access to fresh water that will need to be purified prior to consumption. The BSB water purification soldiers will travel with the 1st convoy to get established. They require 24 hours upon arrival to certify the water for consumption. The potable water produced by the ROWPU is automatically dumped into the unit’s Fixed Water Storage Capacity (next slide) Assumptions: Not taking casualty losses into account when calculating CL I, water and ice requirements. Better to have those supplies on hand. CL I: The command has low expectations on food support (i.e. MREs daily for 30 days is acceptable). Water: Local water source is certified for consumption or can be purified by Field Sanitation Teams (chlorine, iodine tables). Ice: Since we’re deploying in the month of June the ice requirement is non-existent. Units have their own refrigeration capability for special requirements (i.e. blood / plasma).

32. CL I, Water, IceRSOI- Day 1-5 (Initial Top-off, Convoy and Local Ops) Programmer Note: The program doesn’t dump out water when you decide to relocate the bags. The best I can provide you with is a greyed out cell when you select “No”. 1 CL I-Water-Ice: All water that enters thru the BSB (either ROWPU, fixed storage bags or mobile storage bags) In order to fill up the BSB’s fixed storage bags we need the SUST BDE to push at least 150,000 of potable water. Bags are set up by the middle of day 3 (start of local ops) in order to take water from ROWPU Assumptions: Bottled water will be the primary water source for Soldier consumption. Host nation water source(s) can handle increased requirement (but are at the port). Unit doesn’t have additional water tanks for non-potable water requirements, thus all water used must be potable. Soldiers will use bottled water if they don’t have the bulk water on-hand for “other than drinking requirements”, unless you have a well disciplined unit.

33. CL VRSOI- Day 1-5 (Initial Top-off, Convoy and Local Ops) 1 CL V RSR-CSR (By System): This worksheet brings the # of each weapon systems from the OPTEMPO worksheet and then determines the amount of CL V each one shoots based on time, type of operation and intensity. The CL V RSR / CSR rolls up by single DODIC to the CL V (Rollup) worksheet. This new worksheet allows you to see your total weight / cube / net explosive weight for the CL V. This is the NEW baseline for CL V transportation requirements. Assumptions: No controlled supply rates (CSR). If you did have one you can enter in the CSR and the program will do the math for you to show when you’re going to run out of that DODIC.

34. General SuppliesRSOI- Day 1-5 1 General Supplies: Breakdown of the major classes of supply based on the CASCOM’s planning branches latest data. The lbs per pallet data came from OPLOG Planner’s raw data tables. All this is telling you is that IF you had requested replenishment for these consumed supplies, this is how much transportation assets you’d require to move it. Reality for this situation is that you wouldn’t have planned to ship out or receive any CL II, mail, CL VI. You’d only have asked for limited amounts of CL IX (fix the deadline faults), CL IV barrier and construction you need once you start the Local Ops columns. Changes on this column reflect on the Trans worksheet on how many pallets the higher supported unit will have to haul forward to the unit being analyzed. Assumptions: Mail will be flown in no less than every 15-30 days. Alternate means will be pursued to move it quicker

35. CL IV Barrier PlanningRSOI- Day 3-5 (Local Ops) 1 General Supplies: This plus box is directly underneath the CL IV (Barrier) data. The top section shows the various standardized packages (would have to be built by the unit). If you want to change a package just update the blue data fields. Enter the number of packages by column. The row below will calculate the amount of materials by type, which you would provide to your higher HQ. [The program doesn’t override the historical lbs/man planning factor] Assumptions: CL IV materials are in theater or on the vessel bringing in the unit’s equipment.

36. TransportationRSOI (Day 1-5) 1 Trans: This worksheet attempts to summarize the big ticket movements that are happening by day. It is broken down by vehicle type and any special requirements (i.e. refrigeration, human remains, replacements, maintenance evacuation, water, fuel). Assumptions:

37. TransportationRSOI (Day 1-5) Right now the header information is there as a reminder. It doesn’t tie into the information below 1 Trans: Enter in your constraints for convoy operations for your reference. We’ve received from higher 6x 10K forklifts. We’ve provided 1 each to each FSC (note from change to task organization and OPTEMPO page). Since we didn’t get an additional lowboy (trailer) for each of them, the BSB’s will have to flip back to the SPOD to pick theirs up. [Impact: minimal since we can conduct flatrack exchanges]. Remember the level of unit that your analyzing for. In this case the trucks shown are both the FSCs and the A Co (Distro) from the BSB. Assumptions: FSC’s have competent and licensed forklift operators 2 Build your convoy for the column. Enter the # of vehicles apportioned to convoy operations, the average distance they have to travel and rate of march.

38. Synch Matrix Template Enter the starting data (start date, sunrise, sunset, Zulu-hour, H-Hour) for the time that the synch matrix’s 1st column represents White cells are the more important pieces of information from the previous worksheets. If you think other information should be here, email me (damian.green@us.army.mil) You can pick your top 7 critical systems (vehicles or aircraft) to show their ending OR rate per column. The program will provide you with 21 columns worth of a plan (IF you fill out the data on the worksheets) This column is for your starting information (i.e. just before your operation starts how is your unit positioned to support? The colors for the percentages, if you disagree with them, can be changed on the worksheet that the data come from.

39. FOB / COP /PB ConstructionStability Operations 1 FOB/COP Construction: The standards came from the Sandbook (used by CENTCOM for base camp planning). This is a stand alone tool to help plan out the requirements for a tent life support area without contractor support. You can take it to the next level by breaking down your population by grade before you run this calculation. Potential Layout: 4x GP Mediums surrounded by 12’ T-walls, with SCUD bunkers at entranceway

40. FOB / COP /PB ConstructionStability Operations 1 FOB/COP Construction: It is amazing how much waste water US forces produce on a daily basis if provided the water. Have your FOB mayor check out the equipment you’re using and validate the gallons per flush, flow rate on the showers, etc… These calculations will provide a guide as to how much waste water will need to be ‘disposed of’. The program breaks out the grey and black water. It assumes you’ll use an evaporation bed. Enter in the average precipitation and evaporation rate for the month. Programmer Note: It was extremely difficult to get the data for evaporation rates. The default number is from a site in Egypt during the summer.

41. FOB / COP /PB ConstructionStability Operations 1 FOB/COP Construction: HVAC calculations is a standalone calculator to help estimate the HVAC requirements for a since structure. Modify the blue cells for each unique tent/building to determine its requirements. The above example is for a GP large tent with a liner and built-on wooden door, in Iraq. Below this tool is another that can help you figure out how much of a heat load you are generating per structure.

42. TrashDay 1-End of Mission 1 Trash: This is a stand along calculator to help you understand the amount of trash a US force generates in the course of building or maintaining a Forward Operating Base / Combat Outpost. The statistics are based on OIF III and V studies. Based on this data, your dumpster requirements are provided, to help you write a statement of work. Experience shows that burn pits at forward locations need to be covered and re-dug every 2-4 months. Coordinate this requirement thru the BDE engineer cell. Also given the poor nature of the country, we’re going to establish a contract with the local to sort and remove recyclable items.

43. ConcreteStability Operations 1 Concrete: This is a stand along calculator to help you plan for the movement of concrete. This tool was created for Iraq based on the concrete products being produced there. You’ll need to revalidate the weights and dimensions. Concrete can consume all of your logistical trucks and therefore needs to be planned as a deliberate operation. If a cell is red, don’t attempt to up or download it using that piece of equipment or you run the risk of damaging the MHE. This calculator will provide you the number of pieces of each type of concrete based on a distance to cover. Once you have the requirement, plug it into the “req to move” cell or just plug in the requirement directly. Next you need to allocate trucks to haul the concrete. This table tells you the capacity for each truck type, as well as the number that you have in your organization. Remember to touch only the trucks you can task and leave some to move other supplies on the battlefield. The final table lets you know how far you are to completing the movement task.

44. Questions / Comments / Issues MAJ Damian Green damian.green@us.army.mil Or post your comment on BCKS (LOGNET or S3/XO net)