Integrated Margin Planning Excel files include:
Imp_dimensional_data.xls—Master data elements that populate the model dimensions
Products—Members of the Product hierarchy and their relationships
Geographies—Members of the Geography hierarchy and their relationships
Customers—Members of the Customer hierarchy and their relationships
Plants—Members of the Plant hierarchy and their relationships. Also defined is the associated geography and local currency for each plant.
DCs—Members of the Distribution Center hierarchy and their relationships
TransportModes—Members of the Transport Mode hierarchy and their relationships
BOM—Bill of Materials relationships, including parent, child, and Quantity Per Assembly (QPA)
Imp_datafeeds.xls—Details on the transactional data elements that can be fed into the model. It is expected that this data will be obtained from source ERP systems.
Financial_Plan—Data for the top-down annual operating plan
Demand_Plan—Data for the demand plan quantity input (This data can come from a demand planning tool.)
Shipped_sales_orders—Data for shipped sales orders
Open_sales_orders—Data for open sales orders
Inventory—Latest inventory snapshot
WIP—Latest Work-In-Progress snapshot
Inventory_DC—Latest inventory snapshot for Distribution Centers
WIP_DC—Latest Work-In-Progress snapshot for Distribution Centers
Imp_assumptions.xls—Forward-looking assumptions driving the model. The data for these assumptions can be sourced from external systems or maintained within Integrated Margin Planning.
Currency_Exchange—Time-phased currency exchange rates
Overhead_Expenses—Time-phased assumptions on R&D expenses and SG&A expense ratios
Inflation—Time-phased assumptions on inflation rates by region
Market_Size—Time-phased assumptions on total addressable market and market growth rates by product family and geography
Product_ASP—Time-phased assumptions on product Average Selling Price (ASP) by finished good, customer, geography, and time
Transport_Details—Time-phased assumptions on mode mix percent across different transport modes between plant and DC. It also captures the transport lead times.
Transport_Cost—Time-phased assumptions on transport cost per unit for each product from each plant to each Distribution Center by individual transport mode
Plant_Sourcing—Time-phased assumptions on plant sourcing percentage by each product family and DC
DC_Sourcing—Time-phased assumptions on sourcing percent for each geography from each DC
Labor_Rates—Time-phased assumptions on labor rates per hour in local currency for each plant
Labor_Details—Time-phased assumptions on labor hours per unit produced by product and plant
Capacity—Time-phased assumptions on available capacity per week by product family and plant
Material_Details—Time-phased assumptions on unit cost and manufacturing/procurement lead times by part and plant
Plant_Overhead_Expenses—Time-phased assumptions on plant overhead expenses per month