You have decided to develop a worksheet for each manufacturing facility manager to submit each week. It should show total production and revenue, and total scrap and cost for each product for the week, if a facility drops below 5,000 units of production on the mini-gizmo, the production number should be highlighted in yellow. Explain, how you will set this up so that the managers enter only the number of units for each product's production and rejects.