FFE Initial Cash Modeling - Sequel

Purchase window. Limits the months this SKU is ordered from the supplier. Leave either blank for no limit. The window gates on the order month (opening month minus lead time), so a SKU you stop buying in, say, July still supplies later openings whose orders were placed by July — and their receipts, revenue, and buy/sell payments keep flowing forward on the normal lead-time and payment schedule. Months are inclusive: “Buy until July 2026” means July is the last month you place an order.

Payment milestones. Set when cash actually moves for this SKU — separate from when revenue and COGS are booked. Split into Buy (cash out to the supplier, a % of landed cost × units) and Sell (cash in from the customer, a % of sale price × units). Each side should total 100%. A milestone lands relative to an anchor, shifted by its ± offset (days or months; net-30 = 1 month):
• Buy “at order” = opening month − lead time (when you place the PO); “at receipt” = the opening month (when goods arrive).
• Sell “from opening” = the location opening / delivery month.
Examples — Buy: Deposit 30% at order + Final 70% at receipt pays 30% up front when the PO is placed and 70% on delivery. Sell: Deposit 50% from opening −30 + Final 50% from opening +30 collects half a month before the store opens and half a month after.

Purchase window. Limits the months this SKU is ordered from the supplier. Leave either blank for no limit. The window gates on the order month (opening month minus lead time), so a SKU you stop buying in, say, July still supplies later openings whose orders were placed by July — and their receipts, revenue, and buy/sell payments keep flowing forward on the normal lead-time and payment schedule. Months are inclusive: “Buy until July 2026” means July is the last month you place an order.

Payment milestones. Set when cash actually moves for this SKU — separate from when revenue and COGS are booked. Split into Buy (cash out to the supplier, a % of landed cost × units) and Sell (cash in from the customer, a % of sale price × units). Each side should total 100%. A milestone lands relative to an anchor, shifted by its ± offset (days or months; net-30 = 1 month):
• Buy “at order” = opening month − lead time (when you place the PO); “at receipt” = the opening month (when goods arrive).
• Sell “from opening” = the location opening / delivery month.
Examples — Buy: Deposit 30% at order + Final 70% at receipt pays 30% up front when the PO is placed and 70% on delivery. Sell: Deposit 50% from opening −30 + Final 50% from opening +30 collects half a month before the store opens and half a month after.

Purchase window. Limits the months this SKU is ordered from the supplier. Leave either blank for no limit. The window gates on the order month (opening month minus lead time), so a SKU you stop buying in, say, July still supplies later openings whose orders were placed by July — and their receipts, revenue, and buy/sell payments keep flowing forward on the normal lead-time and payment schedule. Months are inclusive: “Buy until July 2026” means July is the last month you place an order.

Payment milestones. Set when cash actually moves for this SKU — separate from when revenue and COGS are booked. Split into Buy (cash out to the supplier, a % of landed cost × units) and Sell (cash in from the customer, a % of sale price × units). Each side should total 100%. A milestone lands relative to an anchor, shifted by its ± offset (days or months; net-30 = 1 month):
• Buy “at order” = opening month − lead time (when you place the PO); “at receipt” = the opening month (when goods arrive).
• Sell “from opening” = the location opening / delivery month.
Examples — Buy: Deposit 30% at order + Final 70% at receipt pays 30% up front when the PO is placed and 70% on delivery. Sell: Deposit 50% from opening −30 + Final 50% from opening +30 collects half a month before the store opens and half a month after.

Purchase window. Limits the months this SKU is ordered from the supplier. Leave either blank for no limit. The window gates on the order month (opening month minus lead time), so a SKU you stop buying in, say, July still supplies later openings whose orders were placed by July — and their receipts, revenue, and buy/sell payments keep flowing forward on the normal lead-time and payment schedule. Months are inclusive: “Buy until July 2026” means July is the last month you place an order.

Payment milestones. Set when cash actually moves for this SKU — separate from when revenue and COGS are booked. Split into Buy (cash out to the supplier, a % of landed cost × units) and Sell (cash in from the customer, a % of sale price × units). Each side should total 100%. A milestone lands relative to an anchor, shifted by its ± offset (days or months; net-30 = 1 month):
• Buy “at order” = opening month − lead time (when you place the PO); “at receipt” = the opening month (when goods arrive).
• Sell “from opening” = the location opening / delivery month.
Examples — Buy: Deposit 30% at order + Final 70% at receipt pays 30% up front when the PO is placed and 70% on delivery. Sell: Deposit 50% from opening −30 + Final 50% from opening +30 collects half a month before the store opens and half a month after.

Purchase window. Limits the months this SKU is ordered from the supplier. Leave either blank for no limit. The window gates on the order month (opening month minus lead time), so a SKU you stop buying in, say, July still supplies later openings whose orders were placed by July — and their receipts, revenue, and buy/sell payments keep flowing forward on the normal lead-time and payment schedule. Months are inclusive: “Buy until July 2026” means July is the last month you place an order.

Payment milestones. Set when cash actually moves for this SKU — separate from when revenue and COGS are booked. Split into Buy (cash out to the supplier, a % of landed cost × units) and Sell (cash in from the customer, a % of sale price × units). Each side should total 100%. A milestone lands relative to an anchor, shifted by its ± offset (days or months; net-30 = 1 month):
• Buy “at order” = opening month − lead time (when you place the PO); “at receipt” = the opening month (when goods arrive).
• Sell “from opening” = the location opening / delivery month.
Examples — Buy: Deposit 30% at order + Final 70% at receipt pays 30% up front when the PO is placed and 70% on delivery. Sell: Deposit 50% from opening −30 + Final 50% from opening +30 collects half a month before the store opens and half a month after.

Purchase window. Limits the months this SKU is ordered from the supplier. Leave either blank for no limit. The window gates on the order month (opening month minus lead time), so a SKU you stop buying in, say, July still supplies later openings whose orders were placed by July — and their receipts, revenue, and buy/sell payments keep flowing forward on the normal lead-time and payment schedule. Months are inclusive: “Buy until July 2026” means July is the last month you place an order.

Payment milestones. Set when cash actually moves for this SKU — separate from when revenue and COGS are booked. Split into Buy (cash out to the supplier, a % of landed cost × units) and Sell (cash in from the customer, a % of sale price × units). Each side should total 100%. A milestone lands relative to an anchor, shifted by its ± offset (days or months; net-30 = 1 month):
• Buy “at order” = opening month − lead time (when you place the PO); “at receipt” = the opening month (when goods arrive).
• Sell “from opening” = the location opening / delivery month.
Examples — Buy: Deposit 30% at order + Final 70% at receipt pays 30% up front when the PO is placed and 70% on delivery. Sell: Deposit 50% from opening −30 + Final 50% from opening +30 collects half a month before the store opens and half a month after.

Purchase window. Limits the months this SKU is ordered from the supplier. Leave either blank for no limit. The window gates on the order month (opening month minus lead time), so a SKU you stop buying in, say, July still supplies later openings whose orders were placed by July — and their receipts, revenue, and buy/sell payments keep flowing forward on the normal lead-time and payment schedule. Months are inclusive: “Buy until July 2026” means July is the last month you place an order.

Payment milestones. Set when cash actually moves for this SKU — separate from when revenue and COGS are booked. Split into Buy (cash out to the supplier, a % of landed cost × units) and Sell (cash in from the customer, a % of sale price × units). Each side should total 100%. A milestone lands relative to an anchor, shifted by its ± offset (days or months; net-30 = 1 month):
• Buy “at order” = opening month − lead time (when you place the PO); “at receipt” = the opening month (when goods arrive).
• Sell “from opening” = the location opening / delivery month.
Examples — Buy: Deposit 30% at order + Final 70% at receipt pays 30% up front when the PO is placed and 70% on delivery. Sell: Deposit 50% from opening −30 + Final 50% from opening +30 collects half a month before the store opens and half a month after.

Purchase window. Limits the months this SKU is ordered from the supplier. Leave either blank for no limit. The window gates on the order month (opening month minus lead time), so a SKU you stop buying in, say, July still supplies later openings whose orders were placed by July — and their receipts, revenue, and buy/sell payments keep flowing forward on the normal lead-time and payment schedule. Months are inclusive: “Buy until July 2026” means July is the last month you place an order.

Payment milestones. Set when cash actually moves for this SKU — separate from when revenue and COGS are booked. Split into Buy (cash out to the supplier, a % of landed cost × units) and Sell (cash in from the customer, a % of sale price × units). Each side should total 100%. A milestone lands relative to an anchor, shifted by its ± offset (days or months; net-30 = 1 month):
• Buy “at order” = opening month − lead time (when you place the PO); “at receipt” = the opening month (when goods arrive).
• Sell “from opening” = the location opening / delivery month.
Examples — Buy: Deposit 30% at order + Final 70% at receipt pays 30% up front when the PO is placed and 70% on delivery. Sell: Deposit 50% from opening −30 + Final 50% from opening +30 collects half a month before the store opens and half a month after.

Purchase window. Limits the months this SKU is ordered from the supplier. Leave either blank for no limit. The window gates on the order month (opening month minus lead time), so a SKU you stop buying in, say, July still supplies later openings whose orders were placed by July — and their receipts, revenue, and buy/sell payments keep flowing forward on the normal lead-time and payment schedule. Months are inclusive: “Buy until July 2026” means July is the last month you place an order.

Payment milestones. Set when cash actually moves for this SKU — separate from when revenue and COGS are booked. Split into Buy (cash out to the supplier, a % of landed cost × units) and Sell (cash in from the customer, a % of sale price × units). Each side should total 100%. A milestone lands relative to an anchor, shifted by its ± offset (days or months; net-30 = 1 month):
• Buy “at order” = opening month − lead time (when you place the PO); “at receipt” = the opening month (when goods arrive).
• Sell “from opening” = the location opening / delivery month.
Examples — Buy: Deposit 30% at order + Final 70% at receipt pays 30% up front when the PO is placed and 70% on delivery. Sell: Deposit 50% from opening −30 + Final 50% from opening +30 collects half a month before the store opens and half a month after.

Purchase window. Limits the months this SKU is ordered from the supplier. Leave either blank for no limit. The window gates on the order month (opening month minus lead time), so a SKU you stop buying in, say, July still supplies later openings whose orders were placed by July — and their receipts, revenue, and buy/sell payments keep flowing forward on the normal lead-time and payment schedule. Months are inclusive: “Buy until July 2026” means July is the last month you place an order.

Payment milestones. Set when cash actually moves for this SKU — separate from when revenue and COGS are booked. Split into Buy (cash out to the supplier, a % of landed cost × units) and Sell (cash in from the customer, a % of sale price × units). Each side should total 100%. A milestone lands relative to an anchor, shifted by its ± offset (days or months; net-30 = 1 month):
• Buy “at order” = opening month − lead time (when you place the PO); “at receipt” = the opening month (when goods arrive).
• Sell “from opening” = the location opening / delivery month.
Examples — Buy: Deposit 30% at order + Final 70% at receipt pays 30% up front when the PO is placed and 70% on delivery. Sell: Deposit 50% from opening −30 + Final 50% from opening +30 collects half a month before the store opens and half a month after.

Purchase window. Limits the months this SKU is ordered from the supplier. Leave either blank for no limit. The window gates on the order month (opening month minus lead time), so a SKU you stop buying in, say, July still supplies later openings whose orders were placed by July — and their receipts, revenue, and buy/sell payments keep flowing forward on the normal lead-time and payment schedule. Months are inclusive: “Buy until July 2026” means July is the last month you place an order.

Payment milestones. Set when cash actually moves for this SKU — separate from when revenue and COGS are booked. Split into Buy (cash out to the supplier, a % of landed cost × units) and Sell (cash in from the customer, a % of sale price × units). Each side should total 100%. A milestone lands relative to an anchor, shifted by its ± offset (days or months; net-30 = 1 month):
• Buy “at order” = opening month − lead time (when you place the PO); “at receipt” = the opening month (when goods arrive).
• Sell “from opening” = the location opening / delivery month.
Examples — Buy: Deposit 30% at order + Final 70% at receipt pays 30% up front when the PO is placed and 70% on delivery. Sell: Deposit 50% from opening −30 + Final 50% from opening +30 collects half a month before the store opens and half a month after.

Purchase window. Limits the months this SKU is ordered from the supplier. Leave either blank for no limit. The window gates on the order month (opening month minus lead time), so a SKU you stop buying in, say, July still supplies later openings whose orders were placed by July — and their receipts, revenue, and buy/sell payments keep flowing forward on the normal lead-time and payment schedule. Months are inclusive: “Buy until July 2026” means July is the last month you place an order.

Payment milestones. Set when cash actually moves for this SKU — separate from when revenue and COGS are booked. Split into Buy (cash out to the supplier, a % of landed cost × units) and Sell (cash in from the customer, a % of sale price × units). Each side should total 100%. A milestone lands relative to an anchor, shifted by its ± offset (days or months; net-30 = 1 month):
• Buy “at order” = opening month − lead time (when you place the PO); “at receipt” = the opening month (when goods arrive).
• Sell “from opening” = the location opening / delivery month.
Examples — Buy: Deposit 30% at order + Final 70% at receipt pays 30% up front when the PO is placed and 70% on delivery. Sell: Deposit 50% from opening −30 + Final 50% from opening +30 collects half a month before the store opens and half a month after.