7LO510 Supply Chain System Modelling | My Assignment Tutor

University of Derby Derby Business SchoolIn-course Assignment Specification  Module Code and Title: 7LO510 Supply Chain System Modelling  Assignment No. and Title: Portfolio  Assessment Tutor:  Paul DaleWeighting Towards Module Grade:  100%Date Set  17/02/21  Hand-In Deadline Date:  Wednesday 19/05/21 11:59 p.m.  Level of Collaboration: NONE/INDIVIDUAL  Module content The module will focus on a management sciences approach to model building/problem-solving and the evaluation of results generated through analysis. Modelling processes will be enhanced through the use of professional standard software, for example Xpressive.               Linear Programming and Applications             Network Optimisation             Project Planning and Project Appraisal             Queueing Theory   Learning Outcomes covered in this Assignment:   Evaluate critically the necessity for quantitative analysis in the strategic context.Apply appropriate quantitative theory and methods to a supply chain scenario to aid decision making in a strategic context.Critically evaluate the results of such an analysis and new knowledge learnt in the business context.Criteria for Assessment:   See grading criteria attached   Supply Chain System Modelling Portfolio (100%) Submission Date: Wednesday 19th May 2021 11:59pm Coursework Task. Case Study: Quality Quorn Ltd (QQ). Quality Quorn Ltd. (QQ) makes high quality food products and has three manufacturing outlets in the UK at Derby, Manchester and London. The company has recently expanded its production and ships quorn products from two ports Harwich and Southampton. The product is supplied to 5 different warehouses across Europe in Rotterdam, Berlin, Munich, Stuttgart and Paris. The quorn is sourced from locally approved producers. Other ingredients are sourced from a range of suppliers, in total Quality Quorn Ltd. (QQ) has 40 different suppliers across the country. The food products are prepared and packaged in the manufacturing outlets. The pre-prepared meals are prepared on site and packaged ready for transportation to supermarket distribution centres. Supermarkets place orders electronically which are then processed and Quality Quorn ship products directly to the supermarket distribution centres from their factories based in Derby, Manchester and London. The frozen quorn is packaged in plastic bags of various sizes for transhipment to the European warehouses via the ports of Harwich and Southampton. Task 1: (20 marks)   Quality Quorn Ltd. (QQ) plans to make a new product called the Quorn Premier and it is expected to increase demand significantly. The product is designed for sale in the UK and will contain all the vitamins specified by the product design and development team. A list of the ingredients is listed below;  Total mas(g)Vitamin B1 (units)Vitamin C (units)Cost (p)Beef Flavouring (per mg)0.001105Emulsifier (per g)13106Mixed herbs (per mg)0.00150500.5Quorn (per g)100.50.05Egg albumen (per g)1000.02 Figure 1: The price and vitamin content of each ingredient for Quorn Premier.   The product Quorn Premier must weigh 250g exactly. There must be more than 50 units of vitamin B1 and more than 100 units of vitamin C. There must be exactly 3 mg of beef flavouring and at least 10g of emulsifier. The amount of quorn must be three times higher than the amount of egg albumen to have the right texture.   The management would like to select the quantity of each ingredient for the product that would minimise the cost while keeping strictly to the above requirements. Formulate the constraints as a linear programming problem; identifying the resource constraints, the fixed requirement constraints and the optimising function. (5 marks)Solve the linear programming model using an excel spreadsheet. (5)Interpret and discuss the optimum solution. For example, relaxing which constraints would result in a more cost-effective product? (5)Discuss how linear programming could be applied in the workplace. (5)             Task 2: (20 marks)   The frozen quorn distribution network for Quality Quorn Ltd. (QQ) is shown below in tabular form. Haulage cost (£)ManchesterDerbyLondonHarwich£11£10£3Southampton£9£8£8Monthly production (pallets)7001000800 Figure 2. Shows the road haulage costs per pallet from the factories to the ports. Shipping and haulage cost (£)RotterdamBerlinMunichStuttgartParisHarwich£3£9£8.80£7£6.60Southampton£8£12£9.90£7£3Monthly demand (pallets)600800550200350 Figure 3. The shipping cost plus haulage costs from the ports to the European warehouses. Draw a network for the company’s transport network. Identify the supply nodes, transhipment nodes and demand nodes in this network. Use this transhipment network to model the problem using an Excel spreadsheet to find the minimum total cost and how many pallets should be shipped down each route. Assume unlimited capacity at this stage (5)How much flows through the ports of Harwich and Southampton? The maximum that can flow through any distribution centre is 1250 pallets.What is the new minimum cost? (5) It is now proposed to start exporting via Grimsby. The cost of haulage and shipping from each manufacturing outlet to Grimsby is given and the shipping and haulage cost to European warehouses are given below in pounds. Is opening a new export channel via Grimsby cost effective? If so suggest the optimum operating capacity and run several simulations to support your answer and discuss the implication for your supply chain network. (5) Haulage cost (£)ManchesterDerbyLondonGrimsby£10£8£14 Figure 4. The cost of transporting a pallet from Grimsby to the European warehouse. Shipping and haulage cost (£)RotterdamBerlinMunichStuttgartParisGrimsby£4.40£6£8.50£6.50£10.20 Figure 5. The cost of transporting a pallet from Grimsby to the European warehouse. Discuss and give examples of how transportation costs can impact on a company’s business strategy. (5)             Task 3: (20 marks)   The export centre at Grimsby is now being planned. The management want the export centre to be completed within 40 weeks. The task is divided into 14 activities below. TaskDescriptionTime (days)Immediately preceding taskResourcesAExcavate10–2BFoundations15A2CBreeze block5B2DWater and electrical services7A2EBricklaying10B2FRoof4C&E2GWindows and doors3E2HInterior plumbing2E2IExterior painting4G2JWallboard and plastering7H2KElectrical work4G&J2LFlooring3J2MInterior painting5K2NExterior fitting2F2OInterior fitting2M2 Figure 6. The number of weeks required and the immediately preceding activities Use critical Microsoft Project to determine the minimum time taken to complete the build. Identify the critical activities. (5 marks)The tasks A-O have been allocated to following teams; Ground works, Erection, Plumbing, Painting, Electrical, Fitting and Plastering. TeamTaskCost per person per weekGround worksA,B1000ErectionC,E,F,J900Plumbing/electricalD,H,K500PaintingI,M300FittingG,L,N,O500 Figure 7. Task allocation and the weekly cost of a team being on site. TeamTeam membersGround worksAdam and AmyErectionBrian, BeePlumbing/electricalColin, KarenPaintingDuncan,DianeFittingEdward, Ellie Figure 8. Team members. TeamExtra cost of reducing time taken per hour (£)Ground works30Erection25Plumbing/electrical15Painting10Fitting15 Figure 9 The hourly extra overtime cost of a team. Using the information in figures 7, 8 and 9, allocate the people as a resource and attach each  person to a task. Draw a resource histogram to show who is required on site and when and calculate the overall project time if there are only two people in each team. Calculate the cost of the project assuming each person works a 40 hour week. Discuss any issues concerning extra staff or costs. The length of time needed to complete each task can be reduced by allocating extra resources. Discuss feasible strategies for reducing the total project time to 50 days.  (5) Discuss how Microsoft Project or similar critical path analysis software could help a firm to plan activities. (5)             Task 4: (20 marks)  Quality Quorn Ltd. would like to simulate the arrival of vehicles arriving at its manufacturing plant in Derby.            Time between arrivals1020304050Frequency  30%25%20%15%10% Figure   9. The current arrival interval of vehicles at Derby. Unloading time at goods inwards  10203040  Frequency  10%25%45%20% Figure 10.  The predicted unloading times given by goods inwards at Derby. Use the Excel spreadsheet simulate the arrival of 200 vehicles and investigate the average waiting time of a vehicle, assuming the vehicles arrive one at a time. (5 marks)The goods inwards manager wants every vehicle to be unloaded in 20 minutes. If this could be achieved what effect would it have on waiting times? (5)  If the 20 minutes is not feasible return to the original unloading times but now there were two unloading bays and two lorries could be unloaded simultaneously, repeat the simulation in task (a) for 200 vehicles and report the new expected wait time. Would it be better to fix the unloading time as 20 minutes or build a second bay? Critically evaluate the two scenarios. (5) Task 5: (20 marks) In order to fulfil the requirements of your Personal Development Plan (PDP) you must include a personal reflection on the process of managing your learning on this module. This is to be included at the end of your assignment and to be between 350 and 500 words in length. (20 marks)  You are expected to use appropriate problem solving software, Excel or Xpressive. In addition underpin your arguments with reference to models and concepts from the module and your wider reading.    Penalty for Late Submission[JD1]    Usually a late submission will incur a penalty. You can request a late submission with the following steps; log in to Udo, click the modules and results tab, then find this module and click late submission and give details about why your submission is late and submit the request. This request will be assessed. If successful you will avoid receiving the minimum mark for a late submission. Alternatively you can request Exceptional Extenuating Circumstances (EEC) (available via their Udo account) which should be agreed before the Deadline Date. The EEC will be treated in line with the University’s policies and procedures.   This is an individual assignment   Submission Requirements The assignment in total for all 5 tasks will need to be 3,000 words ± 10% in length and submitted in electronic form in UDO. Detail information about how to electronically submit the assignment can be found at http://www.derby.ac.uk/esub 7LO510 Supply Chain System Modelling ASSESSMENT Marking criteria: Coursework A COURSEWORK 100% of total module. % markGrade Descriptors These are typical characteristics of the quality of work associated with each grade. The descriptors are illustrative only and for guidance only. They are not comprehensive, and will need contextualisation within individual courses to reflect the academic discipline concerned.Category90-100%    Excellent   Meets all criteria in 80-89% range below, plus demonstrates exceptional ability and insight, indicating the highest level of technical competence; work is virtually flawless and has potential to influence the forefront of the subject and may be of publishable/exhibitable quality.  Relevant generic skills are demonstrated at the highest possible standard.     Exceptional achievement distinguishable even amongst the best quality work and deserving of the highest possible marks within the Distinction grade.  Distinction80-89%Excellent   High to very high standard work with most of the following features:  authoritative subject knowledge; a high level of critical analysis and evaluation; incisive original thinking;  commendable originality;  exceptionally well researched, with a very high level of technical competence;  high quality presentation;  impressive clarity of ideas;  excellent coherence and logic.  Work is close to the forefront of the subject and may be close to publishable or exhibitable quality.  Relevant generic skills are demonstrated at a very high level.  Referencing is consistently used, complete and accurate.  Only trivial or very minor errors.    Very high quality work worthy of a high Distinction grade mark.   Distinction70-79%Excellent   Authoritative, current subject knowledge;   excellent critical analysis and evaluation – including dealing with ambiguity in the data;  significant originality;  well researched with a high level of technical competence – work is accurate and extensively supported by appropriate evidence;  excellent presentation; commendable clarity of ideas;  thoughtful and effective presentation;  very strong sense of coherence and logic;  relevant generic skills are demonstrated at a high level; referencing is excellent– consistently used, complete and accurate; a small number of misunderstandings/minor errors only.    High quality work deserving of a Distinction grade.   Distinction60-69%Very good   Work is well-developed and coherent;  demonstrates sound, current subject knowledge; a very good level of critical analysis and evaluation;  some evidence of original thinking or originality;  well researched;  no significant errors in the application of concepts or appropriate techniques;  a very good standard of presentation;  ideas generally clear and coherent;  relevant generic skills are demonstrated at a very good level;  referencing is very good;  minor errors and misunderstandings only, possibly with some deficiencies in presentation.    Well above pass standard and worthy of a Merit grade.   Merit50-59%  Good/Satisfactory     Has achieved intended learning outcomes as evidenced by the following features. Satisfactory subject knowledge;  a fair level of critical analysis and evaluation;  the work is generally sound but tends towards the factual or derivative, and there may be minimal evidence of original thinking or originality;  adequately researched;  a sound standard of presentation;  ideas fairly clear and coherent;  some significant errors and misunderstandings, possibly shown by conceptual gaps or limited use of appropriate techniques;  relevant generic skills are generally at a satisfactory level;  referencing is generally accurate;  some weakness in style or presentation.    Satisfactory overall – a clear pass  Pass  40-49%Unsatisfactory     Has narrowly failed to achieve intended learning outcomes as evidenced by the following features.  Satisfactory subject knowledge to some extent;  some sound aspects but some of the following weaknesses are evident:  factual errors;  conceptual gaps;  inadequate critical analysis and evaluation;  little evidence of originality;  not well researched – limited use of appropriate techniques;  presentation does not meet the standard required;  ideas unclear and/or incoherent;  some significant errors and misunderstandings;  relevant generic skills unsatisfactory to some extent;  referencing may be inadequate.     Work is unsatisfactory but shows potential for achieving learning outcomes if feedback is addressed. – Marginal fail   Marginal Fail  5-39%Very Poor   Has failed to achieve intended learning outcomes in several critical respects.  Will have some or all of the following features to varying extent:  inadequate subject knowledge;  factual errors;  conceptual gaps;  minimal/no awareness of relevant issues and theory;  limited/no use of appropriate techniques;  standard of presentation unacceptable;  ideas confused and/or incoherent – work lacks sound development;  a poor critical analysis and evaluation;  no evidence of originality;  inadequately researched;  some serious misunderstandings and errors;  quality of relevant generic skills does not meet the requirements of the task.      A clear fail well short of the pass standard     Fail  1-4%Nothing of Merit Nothing of value is contained in the submitted work.  The work presents information that is irrelevant and unconnected to the task;  no evident awareness of appropriate principles, theories, evidence or techniques       NS  Non-submission No work has been submitted.    Z  Academic offence notation Applies to proven instances of academic offence.    [JD1]I wonder if you could put this after the assignment brief


Leave a Reply

Your email address will not be published. Required fields are marked *