The Management of a Bottling Service: Modelling Schedules to Optimise Capacity
Purpose The purpose of this research is to explore the feasibility of building a bottling plant in the East Midlands region to serve micro-breweries in this region. A capacity planning and scheduling analysis shall be undertaken to help realise the goal. Recommendations from the analysis will be mad...
| Main Author: | |
|---|---|
| Format: | Dissertation (University of Nottingham only) |
| Language: | English |
| Published: |
2013
|
| Online Access: | https://eprints.nottingham.ac.uk/26762/ |
| _version_ | 1848793241330122752 |
|---|---|
| author | Tsapo, Otsile \olebogeng |
| author_facet | Tsapo, Otsile \olebogeng |
| author_sort | Tsapo, Otsile \olebogeng |
| building | Nottingham Research Data Repository |
| collection | Online Access |
| description | Purpose
The purpose of this research is to explore the feasibility of building a bottling plant in the East Midlands region to serve micro-breweries in this region. A capacity planning and scheduling analysis shall be undertaken to help realise the goal. Recommendations from the analysis will be made on how best to schedule capacity of the plant.
Design/Methodology/Approach
To achieve the goal, a scheduling model shall be built to help optimise capacity. The model shall use quantitative data obtained from observations, a survey and meetings with the stakeholder. Qualitative data will be used to beef up the recommendations with data from the industry.
Findings
A linear programming model was created using some techniques from the Vehicle Routing Problem. The model was solved on Excel Solver to find the schedule that best optimises capacity.
Value
A model was created using techniques from Vehicle Routing Problem and linear programming. To my knowledge, this has not been done before. All formulas are retained in the model making it user friendly.
Keywords
Capacity planning, capacity strategies, scheduling, Vehicle Routing Problem, Linear programming. |
| first_indexed | 2025-11-14T18:57:10Z |
| format | Dissertation (University of Nottingham only) |
| id | nottingham-26762 |
| institution | University of Nottingham Malaysia Campus |
| institution_category | Local University |
| language | English |
| last_indexed | 2025-11-14T18:57:10Z |
| publishDate | 2013 |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | nottingham-267622017-10-19T13:40:37Z https://eprints.nottingham.ac.uk/26762/ The Management of a Bottling Service: Modelling Schedules to Optimise Capacity Tsapo, Otsile \olebogeng Purpose The purpose of this research is to explore the feasibility of building a bottling plant in the East Midlands region to serve micro-breweries in this region. A capacity planning and scheduling analysis shall be undertaken to help realise the goal. Recommendations from the analysis will be made on how best to schedule capacity of the plant. Design/Methodology/Approach To achieve the goal, a scheduling model shall be built to help optimise capacity. The model shall use quantitative data obtained from observations, a survey and meetings with the stakeholder. Qualitative data will be used to beef up the recommendations with data from the industry. Findings A linear programming model was created using some techniques from the Vehicle Routing Problem. The model was solved on Excel Solver to find the schedule that best optimises capacity. Value A model was created using techniques from Vehicle Routing Problem and linear programming. To my knowledge, this has not been done before. All formulas are retained in the model making it user friendly. Keywords Capacity planning, capacity strategies, scheduling, Vehicle Routing Problem, Linear programming. 2013-12-31 Dissertation (University of Nottingham only) NonPeerReviewed application/pdf en https://eprints.nottingham.ac.uk/26762/1/The_Management_of_a_Bottling_Service_-_Modelling_Schedules_to_Optimise_Capacity.pdf Tsapo, Otsile \olebogeng (2013) The Management of a Bottling Service: Modelling Schedules to Optimise Capacity. [Dissertation (University of Nottingham only)] (Unpublished) |
| spellingShingle | Tsapo, Otsile \olebogeng The Management of a Bottling Service: Modelling Schedules to Optimise Capacity |
| title | The Management of a Bottling Service: Modelling Schedules to Optimise Capacity |
| title_full | The Management of a Bottling Service: Modelling Schedules to Optimise Capacity |
| title_fullStr | The Management of a Bottling Service: Modelling Schedules to Optimise Capacity |
| title_full_unstemmed | The Management of a Bottling Service: Modelling Schedules to Optimise Capacity |
| title_short | The Management of a Bottling Service: Modelling Schedules to Optimise Capacity |
| title_sort | management of a bottling service: modelling schedules to optimise capacity |
| url | https://eprints.nottingham.ac.uk/26762/ |