Task No$.$ "Reference WBS$"$ Task Brief Label Task Full Description Duration $($D$)$ Earliest Start $($ES$)$ Earliest Finish $($EF$)$ Task Starts After

Start

$11\mathrm{.}1\mathrm{.}1\mathrm{.}3$ Analyse historical sales data Analyse historical sales data to calculated $\%$ revenue by product mix for each Sales region $505$

$21\mathrm{.}1\mathrm{.}1\mathrm{.}2$ Estimate Revenue by Region Run CRM report to obtain target revenue for each Sales region $505$

$31\mathrm{.}1\mathrm{.}2\mathrm{.}2$ Average Discount by Product Run CRM report to obtain historical average discount by product $202$

$41\mathrm{.}1\mathrm{.}1\mathrm{.}2$ Validate Revenue by Region Contact Regional Sales GMs to validate CRM figures $8513$ After Task $2$

$51\mathrm{.}1\mathrm{.}1\mathrm{.}1$ Calculate Total Revenue by Product Multiply Validated Regional Sales figures by historical $\%$ by Region then sum$-$up to get Total Revenue by Product $31316$ After Task $1$ and Task $3$

$61\mathrm{.}1\mathrm{.}2\mathrm{.}1$ List Price by Product Obtain List Price by Product from Finance $404$

$71\mathrm{.}1\mathrm{.}2$ Customer Price by Product Customer Price by Product $549$ After Task $3$ and Task $6$

$81\mathrm{.}1\mathrm{.}1$ Calculate Annual Units by Product Calculate Annual Units by Product $=$ Revenue by Product $/$ Customer Price by Product $61622$ After Task $5$ and Task $7$

$91\mathrm{.}1\mathrm{.}3$ BoM By Product Download Bill of Material By Product from ERP system $404$

$101\mathrm{.}2\mathrm{.}2$ Unadjusted Phase$-$in percent Obtain Phase$-$in percent $($converts annual to weekly demand$)$ from Finance $202$

$111\mathrm{.}2\mathrm{.}1$ Holiday & Shut$-$down schedule Obtain Holiday & Shut$-$down schedule from Operations $303$

$121\mathrm{.}2$ Adjusted Phase$-$in percent Remove holidays and shut$-$down dates from Phase$-$in percent $($converts annual to weekly demand$)437$ After Task $10$ and Task $11$

$131\mathrm{.}1$ Annual demand for parts Calculate Annual demand for parts $=$Annual Units by Product X BoM by Product $42226$ After Task $8$ and Task $9$

$141\mathrm{.}0$ Weekly demand for parts Calculate Weekly demand for parts based on Annual demand and Adjusted Phase$-$in percent $32629$ After Task $12$ and Task $13$

Create a