ITECH1100 - Understanding Digital Revolution - Shirt Scene Automation

This assignment focuses on automating business processes for the Shirt Scene company using Microsoft Excel. The tasks include setting up an e-portfolio for staff members, calculating operating costs based on staff salaries and utility expenses, analyzing order history through pivot charts to visualize manufacturing costs and quote amounts over time, differentiating quote amounts by staff members using pie charts, generating price consistency estimates based on material sizes and types, and making decisions on production based on product popularity and stock availability. The assignment demonstrates the application of Excel formulas, pivot tables, and data visualization techniques to solve business problems and improve decision-making processes. The provided solution covers each task in detail, including the formulas and charts used to analyze the data and present the findings.