Spreadsheet: 186136d1349939338-delivery-scheduling-delivery-scheduling
Sheet: Scratch

Revenue source: |  |  |  |  |  |  |  |  |  | Supplier
Number of clients |  |  |  |  |  |  |  |  |  | 51 [NAME] A 768726
Trip fee |  |  |  |  |  |  |  |  |  | Starting Point | Starting Point | Starting Point | Starting Point | Starting Point
Volume of products |  | (Difference between cost and sales price) |  |  |  |  |  |  |  | 738 [NAME] | 738 [NAME] | 738 [NAME] | 738 [NAME] | 738 [NAME]
 |  |  |  |  |  |  |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday
Cost source: |  |  |  |  |  |  |  |  |  | 15 Benoi Rd 629888 | 202 Ang Mo Kio Ave 3 560202 | Tuas South Ave 8 637558 | 15 Benoi Rd 629888 | 1001 Yishun Industrial Park A 768743
ERP(?) |  |  |  |  |  |  |  |  |  | 50 Gul Rd 629351 | 347 Ang Mo Kio Ave 3 560347 | 50 Gul Rd 629351 | 50 Gul Rd 629351 | 51 [NAME] A 768726
Distance travelled per trip |  |  |  |  |  |  |  |  |  | 139 Woodlands Industrial Park E5 757506 | 127 Toa Payoh Lor 1 310127 | 139 Woodlands Industrial Park E5 757506 | 2 Benoi Place 629924 | 738 [NAME]
Number of trips |  |  |  |  |  |  |  |  |  | 21 Woodlands Industrial Park E1 757720 | 745 Geylang Rd 389653 | 21 Woodlands Industrial Park E1 757720 | 11 Senoko Way 758032
 |  |  |  |  |  |  |  |  |  | 21 Marsiling Lane 730021 | 524 Hougang Ave 6 530524 | 10 Admiralty Street 757695 | 51 [NAME] A 768726
Variables: |  |  |  |  |  |  |  |  |  | 113 Marsiling Rise 730133 | 322 Hougang Ave 5 530322 | 16 Tagore Lane 787476 | 347 Sembawang Rd 758355
Frequency of trips per week |  |  |  |  |  |  |  |  |  | 211 Marsiling Crescent 730211 | 51 [NAME] A 768726 | 22 Sin Ming Road 570022 | 33 Sembawang Rd 779084
Duration of each delivery trip (i.e. number of stops) |  |  |  |  |  |  |  |  |  | 51 [NAME] A 768726 | 807 [NAME] 760807 | 1 Clover Way 579077 | 202 Ang Mo Kio Ave 3 560202
Vehicle capacity |  |  |  |  |  |  |  |  |  | 11 Senoko Way 758032 | 51 [NAME] A 768726 | 51 [NAME] A 768726 | 347 Ang Mo Kio Ave 3 560347
Number of vehicles |  |  |  |  |  |  |  |  |  | 20 Senoko Loop 758153 | 738 [NAME] | 738 [NAME] | 51 [NAME] A 768726
Number of delivery personnel |  |  |  |  |  |  |  |  |  | 19 Woodlands Sector 1 738080 |  |  | 738 [NAME]
Type of employment (full-time/part-time) -> cost of employees |  |  |  |  |  |  |  |  |  | 171 Yishun Ave 7 760171
 |  |  |  |  |  |  |  |  |  | 51 [NAME] A 768726
 |  |  |  |  |  |  |  |  |  | 738 [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Volume | Place
Questions to ask: |  |  |  |  |  |  |  |  |  | Canteen |  |  |  | Selling Price | Cost Price |  | 15 Benoi Rd 629888 | 25
Start Time and End Time |  |  |  |  |  |  |  |  |  | [NAME] | 6 | bag | [NAME] | 18 | 16 |  | 50 Gul Rd 629351 | 25
In what circumstances to increase customers (lower price?) ==> identify relationship between demand and price |  |  |  |  |  |  |  |  |  | Plastic Bag | 50 | packets | 40ea | 0.5 | 0.4 |  | 139 Woodlands Industrial Park E5 757506 | 25
More specific details of each location |  |  |  |  |  |  |  |  |  | Spoon | 3 | box | 2000ea | 20 | 16 |  | 21 Woodlands Industrial Park E1 757720 | 25
 |  |  |  |  |  |  |  |  |  | Plate | 6 | packets | [NAME] | 15 | 13 |  | 11 Senoko Way 758032 | 25
 |  |  |  |  |  |  |  |  |  | [NAME] | 5 | bag | 350g | 2.5 | 2 |  | 20 Senoko Loop 758153 | 25
 |  |  |  |  |  |  |  |  |  | [NAME] | 3 | bag | 40ea | 8 | 6 |  | 19 Woodlands Sector 1 738080 | 25
Price Strategy |  |  |  |  |  |  |  |  |  | Straws | 2 | bag | 2.5kg | 10 | 8 |  | 21 Marsiling Lane 730021 | 5
Route Optimization |  |  |  |  |  |  |  |  |  | [NAME] | 20 | bag | [NAME] | 3.5 | 3.2 |  | 113 Marsiling Rise 730133 | 5
Fleet Expansion? |  |  |  |  |  |  |  |  |  | [NAME] | 20 | bag | [NAME] |  |  |  | 211 Marsiling Crescent 730211 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 171 Yishun Ave 7 760171 | 15
 |  |  |  |  |  |  |  |  |  | Coffeeshop |  |  |  |  |  |  | 51 [NAME] A 768726 | -100
 |  |  |  |  |  |  |  |  |  | Chopsticks | 10 | bag | 100ea | 0.9 | 0.75
 |  |  |  |  |  |  |  |  |  | Plastic Container | 10 | bag | 100ea | 13 | 12
 |  |  |  |  |  |  |  |  |  | Spoon | 10 | box | 2000ea | 20 | 16
 |  |  |  |  |  |  |  |  |  | Noodle bag | 10 | bag | [NAME] | 10 | 8
 |  |  |  |  |  |  |  |  |  | straws | 2 | bag | 2.5kg | 10 | 8
 |  |  |  |  |  |  |  |  |  | coffee bag | 20 | bag | [NAME] | 3.5 | 3.2
 |  |  |  |  |  |  |  |  |  | drink bag | 20 | bag | [NAME]
 |  |  |  |  |  |  |  |  |  | Shipyard
 |  |  |  |  |  |  |  |  |  | Roti Prata Paper | 5 | bag | 200pcs | 3 | 2.7 | 5
 |  |  |  |  |  |  |  |  |  | Indian Paper | 5 | bag | 200pcs | 5.4 | 5