You have just joined the staff of the XYZ Manufacturing Company (XYZ, for short). XYZ manufactures only one product, the gizmo. This comes in two sizes, the mini-gizmo and the magna-gizmo. Both are hard to manufacture, and as a result, the company closely monitors refused units. The company consists of three locations, each of which produces both the mini and the magna-gizmos. You are automating the weekly production reports in such a way that you can simply compute total production for the whole company each week.

The mini-gizmo is priced at $3.25 per unit. The magna-gizmo is priced at $7.00 per unit. The unit cost for a refused mini-gizmo is $1.75. The cost for a refused magna-gizmo is $3.50. Respond completely to the given problems regarding this task:

1) The managers will e-mail their weekly reports to you on Monday of the given week. You will then generate the summary report. Describe the process for doing this. Give a sample formula to total the number of mini-gizmos generated by the whole company in a week.

2) Each week, you will represent the combined report to your boss, who wants to see both the summary and the individual sheets for each location. You wish for to add a header with the date and your name to each page. What is the simplest way to do this? Describe the process.