You have just joined the staff of the XYZ Manufacturing Company (XYZ, for short). XYZ manufactures just one product, the gizmo. It comes in two sizes, the mini-gizmo and the magna-gizmo. Both are hard to manufacture, and as a result, the company closely monitors rejected units. The company has three locations, each of which generates both the mini and the magna-gizmos. You are automating the weekly production reports so 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 reject mini-gizmo is $1.75. The cost for a reject magna-gizmo is $3.50. Respond fully 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 make the summary report. Describe the method for doing this. prepare down a sample formula to total the number of mini-gizmos produced by the whole company in a week.
2) 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 header with the date and your name to each page. What is the simplest way to do this? Describe the process.