Write a report, which should be limited to 2000 words, assuming to be submitted to chief
executives of the company on the problems you have found based on the data available.
You may determine the structure of the report, but it should have an executive summary in
the first page and the main body of the report starts with an introduction and ends with
conclusions. It may help to think about the following issues.
• What are the different types of waste which can be found from the data?
• How many types of work order of PCBs are there? How much is the price of each
type (in sale) and how much is the materials cost? (You may assume that the
materials cost takes 25% of the sales price.)
• What could be the reasons for each type of waste? What are the relationships among
different types of waste?
• What do you think is the major problem at the company? And why?
(( The data of six-month sales and production can be found in an Excel file))