You have decided to develop a worksheet for each manufacturing facility manager to submit each week. It must show total production and revenue as well as total scrap and cost for each product for the week. Production of more than 25,000 magna-gizmos in a week succeeds the facility manager for a bonus. Describe how you will set this up so that the managers enter only the number of units for each product's production as well as rejects. There must be an indicator of some kind if the bonus is earned