supply chain and logistics questions

how to develop a spreadsheet?

The factory in Victoria produces a variefy of goods basod on orders from cliants. It owns beveral machines which require machine operators to manage. In the next production period, the production manager has chosen to use five stations to fulliw the orders. Eased on the types of orders and machines, the productian managor has deterrined the minimum ramber of machine operators at each station across the five days as shown below. Due to the nature of the orders, all machine operators are on contracts that will last until the end of the production period. Each machine operator will be required to work 12 hours por day. To reduce fatigue, risks and decreased pertormance, thoy will be working only four days per week. The salary will be $25.71 per hour. The machine operators will work at the same station until the end of the contract. The production marnger has complod a fist od 20 machine operators ts be recruhed for the red production period as thown in the table below. The manager also manaly anarged the station lot each cperator 10 be working on. The manager is, however, not confident in the arrangement above and would like to ask you to do the following tasks betore starting the recruitment. - Develop a spreadsheet model that automatically arranges the machine operators assigned to each station for the next production period. - Highlight the differences in the arrangements done by the production manager and by your spreadsheet model. - Make sensible recommendations based on the findings. - Document how you developed the spreadsheet model in the report in case the requirements need to be changed in the future