This assignment focuses on automating and analyzing the business processes of "Dress Frenzy", a custom dress-making company. The solution begins by calculating operational costs, including employee wages, insurance, and utilities, using provided employee work schedules and pay rates. It then analyzes order information, including sales data, using charts and graphs to visualize trends in order prices and monthly sales, identifying peak months and correlating sales with profits. Furthermore, the assignment automates the quote generation process based on material and size selections, streamlining the order process. Finally, it automates the manufacturing process initiation based on order popularity and availability, optimizing resource allocation. The solution utilizes Excel formulas and data visualization techniques to provide insights into the business's performance and improve operational efficiency.
![[object Object]](/_next/static/media/star-bottom.7253800d.svg)
