Build a Warehouse Shift Roster and Staffing Plan in Excel

<p>Farhan Ansari runs operations at Konkan Fulfilment's warehouse in Bhiwandi, near Mumbai: thirty pickers, packers and loaders on three shifts around the clock, a time clock that exports punches, and online brands whose order volumes jump when the festive sales begin. Across five lessons you build his whole planning cycle in your own personal workbook. You turn clock punches into paid hours (including the night shifts that end the next morning), work out overtime after 48 hours at double pay, convert an order forecast into pickers needed per shift with capacity maths and ROUNDUP, and hold the roster against the need with COUNTIFS and INDEX/MATCH, catching the people who left and the packers who aren't pickers. Every lesson then hands the same job to your AI (Copilot, ChatGPT, Claude or Gemini) and shows you how to catch its mistakes, including the American overtime rules it may assume. In the capstone your agent does the whole cycle for the festive-sale week, and you prove it right.</p>

Tools: Time Arithmetic and MOD, XLOOKUP, SUMIFS and COUNTIFS, MIN and MAX, ROUNDUP, INDEX and MATCH, Mixed References, Excel Tables and Remove Duplicates, Conditional Formatting and Charts, AI Assistants for Excel