Hi, I'm working on a project and I would need to create a excel sheet that shows a forecasting plan for the trucks delivery.
Lets say I will need to deliver 1000 Tons of steel on 10 June, i need a sheet easliy to calculate how many trucks and days are needs for this delivery.(Assume maximum weight restriction for each truck is 15 Tons). I hope you can help me to create a sheet where I can just input the total weight (tons) and most importantly how many days needed.
Also, if I have 2 deliveries "A" + "B". "A" is weighted 5 tons and "B is weighted 3 tons. Is there a way excel would know these two deliveries can use 1 truck for deliver?
I have total of 8 trucks for delvier rebar steel to construction site everyday, and I need to find a way to forecast my deliveries.
22 freelancere byder i gennemsnit $127 på dette job
Dear SIr, I've been a statistician for more than 10 years. I could make a model or formula for you to forecast the truck delivery. Best regards Iswadi