Hello,
I am working on a maths problem for a bulk liquid business idea and I am trying to find a compelling way to show a solution in Excel.
The business would consider buying storage units for liquid product and this storage is very expensive and I am looking to find the smallest amount of storage that the business can get away with, without ever completely filling up the storage units (as then the factory would have to shutdown). The product is taken from the storage by trucks, an average truck lifts 23 MT of liquid at a time.
Production from the factory is averages 275 tonnes a day...however it is volatile with a max of 550 MT and sometimes it is offline for other reasons.
The plan would be to schedule truck liftings basis the average which would be (275/23) = 12 (rounded) trucks a day (365) and it would take 2 business days to adjust the amount of required trucks up or down to take into account peaks / dips in production.
A quote to build 2500 tonnes of storage proved sub-economic, so I would like the number to be closer to 1000 tonnes, but I need an algorithm to prove that the factory will be able to operate 365 without interruption.
Does anyone have any ideas on a smart way to show the solution? Ideally visually so that I can use that in my answer to justify a capital investment for the project?
Thanks!
Sean
I am working on a maths problem for a bulk liquid business idea and I am trying to find a compelling way to show a solution in Excel.
The business would consider buying storage units for liquid product and this storage is very expensive and I am looking to find the smallest amount of storage that the business can get away with, without ever completely filling up the storage units (as then the factory would have to shutdown). The product is taken from the storage by trucks, an average truck lifts 23 MT of liquid at a time.
Production from the factory is averages 275 tonnes a day...however it is volatile with a max of 550 MT and sometimes it is offline for other reasons.
The plan would be to schedule truck liftings basis the average which would be (275/23) = 12 (rounded) trucks a day (365) and it would take 2 business days to adjust the amount of required trucks up or down to take into account peaks / dips in production.
A quote to build 2500 tonnes of storage proved sub-economic, so I would like the number to be closer to 1000 tonnes, but I need an algorithm to prove that the factory will be able to operate 365 without interruption.
Does anyone have any ideas on a smart way to show the solution? Ideally visually so that I can use that in my answer to justify a capital investment for the project?
Thanks!
Sean