WBS 2'3 HMP Inventory

1
WBS 2.3 HMP Inventory

• Erica Gralla
• Sarah Shull
• September 8-9, 2005
• egralla_at_mit.edu, sshull_at_mit.edu

Interplanetary Supply Chain Management and
Logistics Architectures
2
Background

• Challenges for HMP Logistics
• Organized last-minute
• Ever-changing schedules (weather, flights,
  funding)
• Items left on base over the winter are not
  tracked carefully

3
Inventory Goals

• Our Goals
• Provide an inventory of items and implement a
  tracking system for items during the field season
  and over the winter
• Catalog classes and sub-classes of supply in the
  field to obtain a complete inventory and
  relational database of a Mars-analog research
  base on Earth

4
Inventory Procedures

• Inventoried the following locations
• Bathroom Tents
• MIT Tent
• Office Tent (inc. Medical Supplies)
• Research Tent
• Core Tent
• Mess Tent (inc. food)
• Greenhouse
• Comm/Systems Tent
• Humvee
• Outdoor Camp Equipment
• Tagged items with RFID and barcodes

HMP Research Station Layout
5
Excel Inventory Spreadsheet

• Tabs for various inventory collections (e.g.
  food, mess tent, medical)

6
Results

• Outcomes
• gt2300 items were cataloged in an excel
  spreadsheet
• 400 of these added to the relational database
  on-site for RFID tracking (MIT tent, Mess tent)

• Listed the following attributes for each item
• Supply Class
• Name, Description
• Priority Level
• Hazard Type, Hazard Level
• Perishability Type, Perishability Units,
  Perishable Parameter
• Usage Rate Type, Usage Rate
• Origin Type, Owner, Storage Environment
• Packaging, Handling
• Mass Units Type, Mass, Size Units Type, Volume
• Cost/Value, Number of Items
• Location, Case ID, and Electronic Product Code
  (EPC)/Barcode.

7
Example Use Cases

• How many items in each supply class?
• What percent of camp equipment is owned by each
  participating organization?
• What is the fuel availability on base, and where
  is it located?

8
Inventory by Supply Class
Food
Comm
Health
Science
9
Inventory by Owner
MIT
SFU
HMP
CSA
10
Example On-Site Analysis - Fuel
11
Mars Analog

• How analogous is HMP to Martian and Lunar bases,
  in terms of logistics?
• Obvious differences include
• HMP uses in-situ water resources
• More frequent flights (resupply)
• Relative luxury in cooking/eating arrangements
• Compare estimates based on Draper/MIT CER surface
  demand models

12
Comparison to CER-based Estimates

• HMP waste collection system is simple, and
  depends largely on trash bags
• HMP has several seasons worth of food
  stockpiled, and a wide variety of kitchen
  equipment (accumulated over many seasons)

13
Summary

• Established a near-complete inventory of HMP base
  camp
• Validated the supply classes for Moon/Mars
  exploration
• Provided usable baseline for planning upcoming
  2006 field season
• e.g. cook knows what food and supplies are
  on-base
• Populated relational database to enable RFID
  tracking
• e.g. how much printer paper is in the MIT tent?
• Developed procedures for full-scale inventory and
  tracking of all supplies on an Arctic, Lunar or
  Martian base