Project Description:
Analyze some excel spreadsheets with our deliveries on it: Please include the warehouse location addresses and all of the delivery locations, time and date of delivery.
Report Data: What are your primary questions? I want you to get as many answers from my work as possible.
Deliveries per day: What methods were used to make deliveries? Truck, bike, scooter, motorbike, auto-ricksha, Express mail, snail mail, other
Avg per week: Please specify the start of each week date and the finish of each week date. Middle East weeks start on Saturday. I need to be aware of all details to do best work.
Morning time slots deliveries/Afternoon time slot: Do you have each day broken down into multiple time slots? Note that deliveries with a short travel time can be dispatched on a frequency greater than long travel time destinations.
Busiest to Quietest days: Please advise the time and date that the orders were placed. Each delivery zone may need to have unique cut off times for same day delivery.
Revenue: Total sales typically characterized by revenue is irrelevant if you do not have a sufficient profit for the sales generated. The most important number you need to track is gross profit ( sales less cost of goods sold equals gross profit ). From gross profit you will typically need to pay rent, lights, phone, administrative non-direct labor costs. After all costs of sales and expenses, the amount left after all costs and expenses is net income before interest, taxs