A delivery area management system for assigning, to deliverymen, delivery data indicating that gas cylinders should be delivered on a predetermined delivery due date at a specific delivery base, comprising:
- a deliveryman data storage unit that stores a delivery base identification code, a deliveryman identification code, a deliverable count of gas cylinders, and a surplus assignment coefficient;
- a delivery data storage unit that stores a delivery base identification code, a customer ID, a postal code, a delivery due date, and an exchange count;
- a leave data storage unit that stores a delivery base identification code, a deliveryman identification code, a scheduled leave date, and a leave type indicating an all-day off or a half-day off;
- data obtaining unit that
- extracts, on the basis of a specific delivery base identification code, deliveryman data from the deliveryman data storage unit,
- obtains the deliverable count of each deliveryman on the basis of the extracted deliveryman data,
- calculates, on the basis of the extracted deliveryman data, a surplus assignable count for each deliveryman according to a first formula
- Surplus assignable count=(surplus assignment coefficient−1)*deliverable count,
- calculates a total deliverable count of the specific delivery base by summing the deliverable count of each deliveryman,
- calculates a total surplus assignable count of the specific delivery base by summing the surplus assignable count of each deliveryman, and
- extracts delivery data from the delivery data storage unit on the basis of the specific delivery base identification code and the predetermined delivery due date, and obtains a total delivery count by summing the exchange count of the extracted delivery data;
- leave managing unit that
- extracts leave data from the leave data storage unit on the basis of the specific delivery base identification code and the predetermined delivery due date,
- if the leave type of the extracted leave data indicates an all-day off, removes deliveryman data including a deliveryman identification code matching a deliveryman identification code included in the leave data from the extracted deliveryman data, and
- if the leave type of the extracted leave data indicates a half-day off, halves the deliverable count of deliveryman data including a deliveryman identification code matching a deliveryman identification code included in the leave data in the extracted deliveryman data;
- count assigning unit that
- compares the total deliverable count and the total delivery count,
- if the total delivery count is less than or equal to the total deliverable count, calculates an assigned count for each deliveryman according to a second formula
- Assigned count=total delivery count/total deliverable count*deliverable count of deliveryman,
- if the total delivery count is greater than the total deliverable count, calculates a tentative assigned count for each deliveryman according to a third formula
- Tentative assigned count={(total delivery count−total deliverable count)/total surplus assignable count*surplus assignable count of deliveryman}+deliverable count of deliveryman,
- if the tentative assigned count is greater than (the surplus assignable count+deliverable count of the deliveryman), sets the assigned count of the deliverymen to (the surplus assignable count+deliverable count of the deliveryman),
- if the tentative assigned count is less than or equal to than (the surplus assignable count+deliverable count of the deliveryman), sets the assigned count of the deliveryman to the tentative assigned count;
- and
- delivery data assigning unit that
- sorts the extracted delivery data on the basis of the postal code of the delivery data, and
- assigns the delivery data to a deliveryman according to the assigned count of the deliveryman.