Please help using excel

Rationing is known at allocation of scarce resources (lean) Allocate after - Identifying a shortage - Identifying the most important customer - Level of demand - The customer who would run out first (run-out / stock - out time) - Inventory - Usage - Lead time Allocation - Tools Allocation - Tools that help - Smaller Lot Sizes - 5-S - Sort - Straighten - Sweep - Standardize - Sustain - Risk Pooling - consolidating / pooling inventory across warehouses - System Inventory approach - what's in the value stream to make your finished product - Quality - Conformance to specs - Containerization / Packaging Allocation-Case Study Dept A - can make 100h/s per day. They run 1 shift Dept B - can make 100h/s per day. They run 1 shift Housing Dept makes both the X and Y housing - it can make 400 housings combined per day Housing Beginning Inventory (Works 1 shift per day) - X=300 - Y=100 Deliverable - Allocate to keep all customers running. How would you schedule housings, h/s, and transportation to customers How would you add capacity