This assignment analyzes the "Shirt Zombie" case study, focusing on automating business processes and visualizing data using Excel. The solution begins by calculating the annual operating costs, considering employee salaries, replacement worker expenses, insurance, and utilities. The analysis then delves into sales data, creating histograms and graphs to understand price ranges, manufacturing costs, and daily quote amounts. Further, the assignment involves automating the quoting process based on historical sales data, taking into account shirt size and material. Finally, the solution extends this table to automate production decisions based on inventory status and popularity, optimizing resource allocation and minimizing waste. The work demonstrates the application of data analysis and automation techniques to improve business efficiency and decision-making.
![[object Object]](/_next/static/media/star-bottom.7253800d.svg)
