A start-up entrepreneur has deployed a network of vending machines (VM) in Singapore. He is looking at the operational analysis of his business to determine the size of the technician team required to support the VM network he has deployed all around Singapore.

The primary role of the technicians is to carry out unscheduled maintenance, such as attending to an empty coin reservoir whenever it cannot provide sufficient change to the users.

You are an analyst designing a spreadsheet model that will allow him to carry out the analysis and decision-making. You are reminded to design your spreadsheet in a user- friendly way to facilitate usage. There must be clear and distinct inputs and outputs to the spreadsheet for analysis purposes.

To begin the analysis, you need to implement the minimum change model to determine the number of coins required for a given change amount. The minimum change model will evaluate the least number of coins required for a given change amount.

You can assume that the coin denomination in Singapore comes in $1.00, $0.50, $0.20, and $0.10. For a change amount of $0.70, the minimum change model will recommend the coin combination of 1 x $0.50 and 1 x $0.20 (and not 1 x $0.50 + 2 x $0.10).

Make use of existing Excel functions to implement a model to calculate the minimum coin combination required for a given change amount.

Using your model to generate test cases for change amounts in the range of $0.10, $0.20, ..., $5.00.