+61480015851
6LO506: Supply Chain System Modelling - University of Derby - Report Writing Assessment Answer
Download Solution
Order New Solution
Internal Code: C_AI_DCFA_AFI
Code: 6LO506
Supply Chain System Modelling Report Writing Assessment Answer
Assignment Task: scenario: Astrella Beer Company (ABC) is based in Catalonia, a region of Spain. The company has two factories producing beer at Berga and Lleida. The beer is exported by a company called Beer Online Delivery Guaranteed Yesterday (BODGY) via two distributions centres at Barcelona and Valencia. From these distributions centres the beer is exported to the Italian ports of Genoa, Rome, Naples, Palermo, Cagliari and Bari. Task 1:- What might be the benefits to (ABC) and/or (BODGY) by using Enterprise Resource Planning systems in their operations. Discuss the specific benefits for the companies producing and distributing the beer.
- BODGY wants to use cloud based technologies to improve the efficiency of its deliveries. From factory to distribution centres, from distribution centres to ports and onwards to consumers in Italy. What are the advantages of this technology when delivering products to customers.
- Discuss what problems may occur when implementing a cloud based system. How might the business overcome these problems?
- Assuming that there is no stock initially at the start of the year. Draw a graph and annotate it to show the daily amount of inventory stored in the warehouse for one year based on batches of 100 units.
- Calculate the current annual cost of holding the beer and the annual set-up costs based on batches of 100 units and calculate the economic batch quantity using the formula EBQ= (6 marks)
- If Pedro adopts the economic batch quantity when producing beer. Then discuss how Pedro should manage this change in production method, for example who should he liaise with to implement this change? What changes would have to be considered if the size of the batches produced are increased. Conversely what changes would have to be considered if the size of the batches produced are increased. Draw graphs showing the total costs to support your answers.
- Choose any 10 cities that are within 1500Km of Barcelona.Using the spreadsheet ‘Q4 European Cities’ and starting at Barcelona plan a route using ‘The Travevalling salesman Algorithmn’ that starts at Barcelona and visits all 10 of your cities. Clearly state the total minimum distance and the order in which the cities are visited. Screenshot your spreadsheet and reveal your formulae explaining how the program works.
- Discuss how ‘The Travelling Salesperson Algoritmn’ can be adapted to deliver beer as quickly as possible to 30 hotels in Catalonia. What information would be needed? Discuss how the spreadsheet could be adapted to give the minimum time taken to deliver to the 20 of these hotels that had placed orders that day. Screenshot an example of your spreadsheet.
This 6LO506: Supply Chain System Modelling Assessment has been solved by our Management experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.