Using excel, re$-$create the provided Project Viability Model. For this part create both tables on the same excel sheet. Label the

sheet tab as part $1.$ The first table on the sheet will be the Project Viability Model: INPUT. Match all of the values listed below.

This table does not have any formulas.

After you have created this table, then right below it you will create the Project Viability Model: Rate table. This table should

include IF$/$THEN formulas for each of the potential columns ranging from No to Yes. This includes the $5$ cells across for all $15$

factors. If nothing is entered in the cell then nothing will happen but the formula should be in each cell and working correctly,

linking back to table $1.$ An example formula for cell E$26$ below would be $=$IF$($E$5>0,$$C$5/3,).$ This takes the weight of $3$ for factor

$1$ and divides it by the average potential weighting of $3$ and multiplies it by what $($if anything$)$ was entered in E$5$ above. For the

cell below it E$27$ you would adjust the formula to $=$IF$($E$6>0,$$C$6/3,).$ In the table below, E$27$ has this formula but no number is

entered because there is no entry above. All cells should have a formula whether there is an entry or not to create a working

table. Additionally, include the sum function for each column to get initial weighted total all the way across and totaled. Then

use the product function to apply the potential weighting to each initial weighting all the way across and totaled. Then for the

final cell $$DMAIC Viability Score$$ divide the Final Weight Totals by the Initial Weight Totals. This completes Part $1$ on the Part $1$

tab in excel.

FMGT $53500$ Quality and Productivity in Industry an