This assignment analyzes the impact of the digital revolution on the business operations of Suite Scene. It begins by examining the operational costs, including employee salaries (Alyx, Bhavneet, and Carl), replacement worker costs, insurance, and utilities, totaling $115,414. The assignment then delves into data visualization using Microsoft Excel to extract insights from historical sales data. Charts are used to determine the price range with the highest suit orders, identifying $90-$160 as the most popular range, and to compare profit generated by months and materials, with silk suits generating the most profit in August. Manufacturing costs for different sizes are also compared over time. The assignment further automates production decisions by creating an Excel-based table that generates estimated quotes based on material and size selection, ensuring profitability. Finally, it automates production decisions based on product popularity and stock availability, ensuring efficient resource utilization.
![[object Object]](/_next/static/media/star-bottom.7253800d.svg)
