Build a Black Friday Inventory and Prep Checklist for a Small Online Store

You are an ecommerce operations planner who helps small online stores get ready for Black Friday and Cyber Monday without running out of best sellers or overselling stock they do not have. Black Friday is about six weeks away, and I want a practical inventory and prep checklist built around my real numbers. Use only the data I give you. Do not invent sales figures, growth rates, supplier lead times, or platform features. If something is missing, mark it [NEEDS INPUT] and list it as a question at the end.

Store name, platform, and what we sell: [STORE]
Top 10 products with current stock on hand: [STOCK]
Units sold per product last Black Friday week, or in a normal recent week if we have no Black Friday history: [SALES HISTORY]
Supplier or manufacturer lead time for each top product, and minimum order quantities: [LEAD TIMES]
Planned Black Friday offer (discount, bundle, free shipping threshold, gift with purchase): [OFFER]
Fulfillment setup (we pack ourselves, a 3PL, print on demand, dropship) and how many orders per day we can pack: [FULFILLMENT]
Budget available for extra inventory: [BUDGET]
Carriers we use and the holiday shipping cutoff dates I already know: [SHIPPING]

Requirements:
1. Using [STOCK] and [SALES HISTORY], show a simple table per product with stock on hand, a cautious, expected, and strong demand scenario, and the gap to reorder. Show the formula you used so I can change the assumptions myself. Do not present any scenario as a forecast you are sure of.
2. Using [LEAD TIMES], mark the last safe reorder date for each product so stock arrives before Black Friday. Flag any product where that date has already passed.
3. If [BUDGET] cannot cover every gap, rank which products to restock first and explain why in one line each (margin, bundle role, best seller).
4. Suggest how to handle low stock items: low stock badges, limited quantity bundles, preorders, or pulling them from the offer. Tell me to check which of these my platform actually supports before planning on it.
5. Build a week by week checklist from now until Cyber Monday covering inventory counts, product page updates, shipping cutoff messaging, packaging supplies, customer service macros, and a backup plan if a supplier is late.
6. Using [FULFILLMENT], estimate whether my packing capacity can handle each demand scenario, and suggest simple ways to add capacity if it cannot.
7. Remind me to confirm carrier holiday cutoff dates directly with each carrier in [SHIPPING] instead of relying on last year's dates.
8. End with a one page "Black Friday morning" checklist for the day itself.

Deliverables:
1. Product demand and reorder table with formulas
2. Reorder deadline list with flags
3. Restock priority list if budget is limited
4. Week by week prep checklist
5. Black Friday morning checklist and a list of [NEEDS INPUT] questions