Data Input Validation

4 What You Should Produce4.1 Main ReportYour report should review the current situation of the Students’ Union Shop queueing systemand suggest ways of improving the service level. You must give a convincing argument tosupport the improvements you are suggesting, e.g. by showing the cost-benefit of adding anextra cashier in terms of staff utilisation and customer waiting time.4.2 Technical Report and Spreadsheet ModelProduce a multi-server queueing model using Excel, which could be used by the Students’Union Shop management team for evaluation of their performance using the data providedor any new data that becomes available in a similar format. The model should be supportedby technical documentation, which should give details of the analysis method used, include adescription of how it was implemented in a spreadsheet and a brief description of how to usethe spreadsheet.If there is any further information you believe to be essential, make a realisticassumption and explain clearly what you have done.4.3 Length of ReportsThe Students’ Union Shop management team are very busy and so value concise reports. Eachreport should be no more than 10 pages and the total number of pages should not exceed 15.Marking:Note that this assignment is deliberately open-ended and initiative will be rewarded. Theassignment will be marked out of 100, with the marks allocated as follows:• 35 marks are available for the main report, broken down as follows:– Clarity (15 marks)– Accuracy (10 marks)– Technical content (10 marks)• 65 marks are available for the technical report and spreadsheet, broken down as follows:– Report (technical content and documentation) (20 marks)– Usability, data input validation (15 marks)– Functionality (20 marks)– Initiative/creativity (10 marks)