Supply Chain Modelling: Formulation using excel

The centre has four floors with five rooms. Rooms 1-3 are for children under the age of 3. Room 4 is mainly for children at the age of 3 but this room has some 4-year-old children moed in due to a transition to a kindergarten. Room 5 is mainly for children at the age of 4. However, some 5-year-old children still attend because they are waiting for a term to open in a kindergarten. According to the Assistant Coordinator, the current numbers of children attending each day in each room and the maximum room capacities are summarised in the table below Room 1 Room 2 Room 3 Room 4 Room 5 Max Capacity 12 Age