This project focuses on automating the quoting process for Garment World, a company with three employees: Audrey, Barry, and Cheryl. The assignment involves analyzing sales data, calculating operational costs (including wages, insurance, and utilities), and visualizing profit trends using charts and graphs in Excel. The goal is to use Excel functions, such as AVERAGEIFS, to automate the generation of quotes based on material and size selections. Furthermore, the project includes the development of a decision-making table that considers material popularity and availability to optimize production decisions and maximize profit. The project demonstrates the application of data analysis and IT solutions to streamline business processes and improve decision-making within the garment industry. The student's work provides a comprehensive analysis of the company's operations, sales data, and potential for automation, demonstrating the practical application of data analysis and IT solutions to improve efficiency and profitability.
![[object Object]](/_next/static/media/star-bottom.7253800d.svg)
