logistic case study

Logistics Case ABC is an upcoming logistics company .The company offers air cargo services from Bangalore Airport office to 10 international locations and vice versa. They can handle cargo up to 40 kilos in a single consignment. The company offers three kinds of services-normal, express & platinum. Normal Service consists of consignment delivery using air cargo services offered by scheduled airlines. Express Delivery consist of consignment consist of consignment delivery using cargo aircraft of DHL. Platinum service is a premium service which involves usage of the exclusive Boeing cargo aircraft of ABC limited. The consumer has to pay for the consignment based on the weight of the package and the distance. The invoice amount is Rs 20 per kilogram for every air mile in the normal service. Express service will cost 1.5 times the normal rate & platinum service thrice the normal rate. The distance from Bangalore to other locations (in air miles) are as follows City Distance London 1700 Barcelona 1400 New York 3100 Mexico City 3300 Sydney 2600 Tokyo 2800 Christchurch 3050 Moscow 2900 Montreal 2450 Cairo 1700 Bookings from Bangalore are done in Indian Currency, bookings from other locations to Bangalore are billed in US$ which has to be converted to Indian rs( 1$=45 Rupees). Since the major airports are congested, the aircraft has to hover around the airport for sometime before given clearance to land. Hence the company charges congestion charges for consignments booked to certain airports. The charges (if applicable) are given below. Airport Code Congestin Charges Applicable Congestion charge London LD N Barcelona BL Yes 15% of invoice amount New York NY N Mexico City MX N Sydney SD Yes 18% of invoice amount Tokyo TK No Christchurch CS Yes 15% of invoice amount Moscow MS Yes 10% of invoice amount Montreal MT Yes 20% of invoice amount Cairo CR No The congestion charges will vary according from time to time and the system should have the flexibility of accommodating new rates easily Tokyo and New York will have a special tax of 20$ on every consignment booked to these two cities. A Customer can book multiple consignments in one go subject to maximum bookings of 4 at one time. It can to the same city or different cities. The user of the application should be provided an option to enter the customer details and shipping address. The Customer should be able to view his booking details at a later stage. The administrator should be able to search and pull out reports on 1) Bookings done at each airport office 2) Revenue at each airport office 3) Total revenue at any given point .