Inject Solutions, LLC is a provider of finished plastic molding injection products to different industries. Inject Solutions works primarily with customers in the automobile, medical devices, and consumer toy manufacturing industries. With a fleet of 13 injection molding machines, Inject Solutions produces custom components for large manufacturers to use in their finished products. Inject Solutions has been operating 24-7 trying to meet its customer demands. As a result, the production supervisor for Inject Solutions, Natalie Ritter, wants an analysis of maintenance, downtime, and related costs.
1. Using the dataset for Inject Solutions, provide the following analyses for Natalie:
a. Number of unplanned shutdowns by machine type
b. Scheduled maintenance cost, shutdown repair cost, and total maintenance cost by product
2. How might Natalie Ritter use the preceding analyses?