Please provide the template and formulas.

Build a pro forma P\&L template which will enable users to run scenario analyses. Use data from tab TABLES as your baseline. Users want to be able to pick any customer(s) and/or sku(s), and then input different assumptions (volume, mix, discount, rebate \%) to analyze impact on net sales, gross profit, and gross margin. \begin{tabular}{|lllll|} \hline \multicolumn{3}{l}{ PRODUCT TABLE } & & \\ Category & SKU & Description & List Price & COGS \\ \hline Basic & B425 & Chain, 1/2 HP, 1 Light & $125 & ($55) \\ Basic & B525 & Belt, 1/2 HP, 1 Light & $150 & ($70) \\ Basic & B625 & Belt, 3/4 HP, 1 Light & $200 & ($100) \\ & & & & \\ Comfort & C430 & Chain, 1/2 HP, 2 Light & $138 & ($65) \\ Comfort & C530 & Belt, 1/2 HP, 2 Light & $165 & ($81) \\ Comfort & C630 & Belt, 3/4 HP, 2 Light & $220 & ($116) \\ Elite & E440 & Belt, 1/2 HP, 2 Light, Wi-Fi & $185 & ($95) \\ Elite & E540 & Belt, 3/4 HP, 2 Light, Wi-Fi & $240 & ($130) \\ Elite & E640 & Wall-Mount, Wi-Fi & $350 & ($193) \\ \hline \end{tabular} Build a pro forma P\&L template which will enable users to run scenario analyses. Use data from tab TABLES as your baseline. Users want to be able to pick any customer(s) and/or sku(s), and then input different assumptions (volume, mix, discount, rebate \%) to analyze impact on net sales, gross profit, and gross margin. \begin{tabular}{|lllll|} \hline \multicolumn{3}{l}{ PRODUCT TABLE } & & \\ Category & SKU & Description & List Price & COGS \\ \hline Basic & B425 & Chain, 1/2 HP, 1 Light & $125 & ($55) \\ Basic & B525 & Belt, 1/2 HP, 1 Light & $150 & ($70) \\ Basic & B625 & Belt, 3/4 HP, 1 Light & $200 & ($100) \\ & & & & \\ Comfort & C430 & Chain, 1/2 HP, 2 Light & $138 & ($65) \\ Comfort & C530 & Belt, 1/2 HP, 2 Light & $165 & ($81) \\ Comfort & C630 & Belt, 3/4 HP, 2 Light & $220 & ($116) \\ Elite & E440 & Belt, 1/2 HP, 2 Light, Wi-Fi & $185 & ($95) \\ Elite & E540 & Belt, 3/4 HP, 2 Light, Wi-Fi & $240 & ($130) \\ Elite & E640 & Wall-Mount, Wi-Fi & $350 & ($193) \\ \hline \end{tabular}