3.1.4. The Processing Department (PD) worker [henceforth to be referred to as PD Worker] retrieves a is currently being utilized. To add 1 unit, the PD Worker will need to take the foliowmg actions: pumptruck from the PD Pump Truck area and goes to the SD area. The PD Worker retrieves the 1: Retrieve 1 unit of Coffee Beans from Temp Storage Processing Tracking Ledger sheet and places 20 units of product onto the pump truck, bringing 2: Add 1 unit of Coffee Beans to the machine's hopper the units to the main PD floor's temporary storage area. The pumptruckis immediately returned 3: Process unit through the machinery to the PD Pump Truck area, and the PD Worker updates the stockroom inventorv to reflect the 4: Remove the processed unit from machinery and transfer the processed unit of coffee units removed. beans into the transfer bin The PD Worker next calibrates the 'Huller machine\" and will step through a repetitive set of 5: Record processing resultis! in Processing Tracking Ledger sheet steps wherein the PD Worker will need to add 1 unit of product at a time to the machine that 5: piece transfer bin in temporary storage 208 After the 'Huller Machine' processes each unit there, will be an amount of waste produced, which the machine automatically separated from the product. This waste must be discarded In the nearby waste bin. After all of the 20 units have been processed, this waste bin will need to be emptied in the outdoor dumpster. PD Worker will proceed to calibrate the \"Cleaning Machine,' stepping through the identical steps as outlined within the 'Huller machine' actiiiity with only one additional step now added. After steps 1 A 6 has been completed, PD Worker will be required to check the Cleaning Machine for any areas where the machine may have become clogged. If the machine is clogged, then FD Worker will utilize a power washer for clearing out any blockages. The cleaning cycle takes roughly 27minutes, upon completion the worker will doubleecheck to ensure that the machine has been properly cleansed, if it remains clogged then the blockage cleaning cycle will repeat, else, the PD Worker will continue through the process of cleaning the coffee beans. Upon completion of cleaning, a member from the Roasting Department [henceforth to be referred to as RD Worker] will retrieve a 1|}gram sample from each of the units\" transfer bins. This sample will be added to the Grading Machine, which will automatically test the coffee beans for acidity levels, quality and various other measures. Once the Grading Machine has provided the results, a letter grade will be assigned to the corresponding coffee bean ZDKg unit. The ergram sample is then dumped into the nearby waste bin. This process will continue until all 20 units have been tested. After Grading, the RD Worker, will preheat the roasting machine and begin the same steps as outlined within the 'Huller machine\" activity. After the roasting has been completed, the Packaging and Sales Department IPSD] Worker [henceforth to be referred to as the PSD Worker] Will retrieve 1 unit of roasted beans at a time, 20 units total, and add them to the conveyor belt. PSD Worker will next turn on the packaging machine and insert an empty lKg bag for packaging. The machine will slowly autoefeed beans into the packaging bag, once the bag is filled, the PSD Worker will turn off the packaging machine as it would continually add more beans if not shut down. The PSD Worker will use the 'sealer' to seal the 1kg bag of finished product and place it on the sales storage shelves. The PSD Worker will continue these steps until 20): 1kg bags have been filled, at which point the PSD Worker will update the Processing Tracking Ledger Sheet. Once all 20 units of coffee beans have been processed, the PSD Worker will update Inventory following the same steps as depicted in the earlier SD activity. 209 . Secondary: CBR Executive team Wants to see sale projections and forecasts Wants to see OPEX as a live metric Sources of Data: Each production employee will be required to manually log their activities through Excel on Microsoft Office 365. This process will occur every time a 'batch' order has been completed. Sales data is automated by the eCommerce system, which will automatically record all sales records to a SQL Server Database. The TPS backend will seamlessly update the Sales Database as needed and will not require any direct interaction from any employee. All data files accessed by CARE are located BUILDING A PRODUCTION MONITORING DASHBOARD centrally on the organization's SharePoint Data Server which is a separate system from Microsoft's Office 365 Server system. All data CBR has identified a few areas of focus that will be stored on the SharePoint Data Server, need to be addressed and monitored through and all Managers will utilize an application the construction of a Business Intelligence called Microsoft Teams available from the 3. 2.1.2 (BI) visualization system that CBR has named Office 365 Server to access Production Logs and Control Awareness Reporting Engine, or CARE: Sales Records. Excel (available on the Microsoft Monitoring Production B2C Sales and production levels Office 365 Server system) is used to open the Logistics and Shipping spreadsheets. Forecasting and Analytics Managers will have access to productivity Through elicitation efforts with Mr. Raul Ichine, output records per employee, through Raul Ichine, VP of Operations, has identified a significant concern regarding the following items have been identified as Microsoft Teams, and will maintain the his ability for oversight of multiple production locations. Mr. Ichine fears he primary concerns: following rights: will no longer have a consistent overview of production operations as he o Looking to measure daily production rates, Add new data records cannot be at two different sites at the same time and is seeking a meaningful seeing 30-days of production at any time. Update, modify and append existing data solution. In order to support Mr. Ichine in the execution of his responsibilities, o Month-to-month comparison of production (time logged) Research & Development Analyst Billy Bob has been tasked with drafting a with trend lines Delete records (logged) dashboard design that will address Mr. Ichine's concerns: o Tracking of inventory levels and sales rate to Share Excel spreadsheet access with ensure only in-demand products are restocked - Lauthorized personnel OWS Go to Settings to activate Windows. 234 235