Ravi Sir's Cards › Excel
Manufacturing Production Planning System in Excel (card 1 of 2)
Revision card 1 for Manufacturing Production Planning System in Excel: Planned finish date: =WORKDAY.INTL(F5,I5-1,11) gives 06-10-2026; Machine hours per day: =B10*$B$4*$B$5 gives 13.6; Order number: ="SO-"&(100+ROW()-4) gives SO-101. Includes an example data table.
Read card text
What this card says
1 for Manufacturing Production Planning System in Excel: Planned finish date: =WORKDAY.INTL(F5,I5-1,11) gives 06-10-2026
Machine hours per day: =B10*$B$4*$B$5 gives 13.6
Order number: ="SO-"&(100+ROW()-4) gives SO-101. Includes an
Example
data table
Learn this in the lesson: Manufacturing Production Planning System in Excel: Machine Hours, Planned Finish Date, Progress, Rejects and Machine Load