This assessment task addresses the following learning outcomes from the module specification:- Use a range of established techniques to initiate and undertake critical analysis of information, and to propose solutions to problems arising from that analysis. – Critically evaluate the appropriateness of different approaches to solve logistics problems both manually and through the use of a computer package. – Effectively analyse the results generated, test alternative scenarios where appropriate and assess their relevance to the project objective.Assessment briefQuestion 1 (30 Marks) A supermarket has recorded sales for product A in the past 50 months. The data is provided in Q1-SalesData.1920.xls file, available on Brightspace under: BIT2015>Assessment>Final Assessment>Data Files.a. Use the Moving Average method to forecast the sales for the next month. Explain your approach in detail. (10 marks) b. Use Single Exponential Smoothing (SES) to forecast the sales for the next month. Explain your approach in detail. (10 marks) c. Analyse the graphical representation of your data before and after applying Moving Average method and Single Exponential Smoothing (SES) method and explain what it shows. (10 marks)2Question 2 (20 Marks)A producer purchases a component used in the manufacturing of its products directly from the supplier. The production operation requires 20,000 components annually. Assume that the ordering cost is 20 per order, the unit cost is 2 per component and the annual holding cost is 20% of the value of the inventory. The company has 250 working days per year and a lead time of five days. Answer and explain the following inventory policy questions:a. Calculate the Economic Order Quantity (EOQ) and explain your answer. (6 marks) b. Calculate the Re-Order Point (ROP). (3 marks) c. Determine the total annual costs associated with your recommended EOQ. (3 marks) d. If holding costs were to increase to 35%, what would be the effect on EOQ, ROP and total annual costs? Explain your answer in detail. (8 marks)Question 3 (30 Marks)A wholesaler whose headquarters are in London is planning on opening a new DC in Manchester. The new DC will supply five outlet stores in the Greater Manchester area. The coordinates for these five outlet stores and the demand of each one of these outlets per year are presented in Q3-Facility location.1920.xls file, BIT2015>Assessment>Final Assessment>Data Files. The wholesaler wants to determine the location (X and Y coordinates) of the new DC that minimises the total distance travelled from this new DC to all outlet locations.a. At what centre-of-gravity coordinates should the new store be located? Explain the solution method and the results. (20 marks) b. The outlet stores are each projected to grow by 15% in the next year. How will this influence the new DCs location (coordinates)? Explain your answer. (10 marks)Question 4 (20 marks)a. In an ERP SAP system, explain the relationship between each of the following pairs of key elements of the fulfilment process(10 marks) : – Quotations and Sales Orders – Deliveries and Billing Documentsb. Explain why Material Master is one of the most complex types of data in SAP ERP system? (10 marks)3You are advised to: Avoid description of the content of material referred to critical evaluation is required where specified.
