University of Sydney industry consulting project · Winter 2025
Client communication and requirements clarification · Excel calculator development (approximately 90%)
Tools: Microsoft Excel · Microsoft PowerPoint
My work began with observing the production process and collecting information for the model during a factory visit. I examined manual activities including foam casting, cutting and mould handling, and worked with the team to bring the site observations into assumptions about mould use, process flow and layout spacing.
I completed approximately 90% of the Excel calculator development, building calculations to estimate production rates, allocate workers and identify bottlenecks. I used functions including IFS, MIN and MAX to identify the slowest process steps and estimate staffing needs. This connected the individual tasks to the production rate of the whole line and allowed the team to examine different operating configurations.
The team’s MMS covered 1-, 6- and 10-tile batch configurations under manual and automation scenarios. Users could adjust staffing, shifts, material prices and production targets, then compare daily output, worker and mould requirements, operating costs and storage needs. We also used Gantt charts to examine the timing of mould preparation, pouring and demoulding, linking the production estimate to the feasibility of the mould cycle.
In the report’s illustrated 10-tile scenario, with one eight-hour shift per day, the manual configuration used 21 workers per shift and calculated an output of 1,420 tiles per day. The automation configuration used two workers per shift and calculated 1,060 tiles per day. For the model’s 50,000-tile target, the corresponding production times were 36 and 48 working days.
In this automation scenario, cutting and measurement limited the capacity of the line. The model connected this bottleneck to staffing and mould availability, helping users examine how changes to the process would affect output. Together with its cost and storage calculations, it provided a basis for comparing production setups and delivery times against a defined target.
I was also responsible for communicating with the client to clarify and confirm their requirements, connecting their production-planning ideas to the questions the model needed to answer. In a mock presentation, I helped explain the User Starting Page and operating-cost overview. I also worked with the team to revise the presentation and report, using PowerPoint to communicate the inputs, results and production choices. We brought the Excel MMS, user guidance, process flow diagram and scenario analysis together in the team report.
