silve meal in excel 1

Use Excel to develop a tool that will generate planned order releases using the Silver-Meal heuristic. This tool should be able to accept the following inputs: • Up to 30 periods of demand requirements • Unit holding cost parameters • Order/setup cost parameters The tool should be capable of yielding the following outputs: • Planned order releases • Total holding costs over the planning horizon • Total ordering costs over the planning horizon One dataset that will be used to test your tool for correctness is provided in the file hw4_test_data.xlsx on Canvas (Modules->Reference Material).