A - (TCO 1) 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. Production of more than 25,000 magna-gizmos in a week, qualifies the facility manager for a bonus. Explain how you will set this up so that the managers enter only the number of units for each product痴 production and rejects. There should be an indicator of some kind if the bonus is earned. B - (TCO 5) The managers will e-mail their weekly reports to you on Monday of the following week. You will then produce the summary report. Explain the process for doing this. Give a sample formula to total the cost of mini-gizmo rejects for the entire company for the week. C - (TCO 5) Each week, you will present the combined report to your boss, who wants to see both the summary and the individual sheets for each location. You want to add a custom footer with the date and your name to each page. What is the easiest way to do this? Explain the process. D - (TCO 3) Describe the graph that you would create to accompany the report in Part C. Include formatting considerations to make important facts stand out. (Points: 40)