数据分析代写 | ITLS6008 2020 S2 Take-Home Quiz Instructions

这个作业是根据给定的公司现况进行运营和市场分析
ITLS6008 2020 S2 Take-Home Quiz Instructions

Take-home Quiz Case Description:
Apromo Trading (http://apromotrading.com.au/about-apromo.php) is a small-to-medium sized
business headquartered in Sydney. They supply European ingredients and semi-finished products to
chocolate manufacturers, premium hotels and patisseries in Australia. They also supply gourmet food
and packaged confectionery to department stores, confectionery retailers, independent grocers and
delicatessens in Australia and New Zealand. The company has a small team of full-time staff in both
Sydney and Melbourne (http://apromotrading.com.au/our-team.php).
The company has one warehouse in Sydney and a newer one in Melbourne
(http://apromotrading.com.au/facilities.php). Assume both warehouses have approximately equal
storage capacity. The warehouse operations are supported by dozens of part-time workers. The
warehouses maintain areas at different temperatures based on the requirements for different product
ranges. Temperatures are monitor and logged in line with HACCP food safety certification
requirements.
The company imports two shipping containers and various plane shipments every week, and processes
approximately 150 orders per day. Its delivery vans that are fully refrigerated and all temperatures are
recorded at the time of delivery to ensure the products arrive in optimum condition. The vans service
the CBD and inner suburbs daily and outlying areas weekly. Deliveries to regional customers are done
via the dedicated cold chain freight company Kerry Logistics. Customers can also collect their orders from
thewarehouses.
With increasing order volumes, the company requires a system that will scale with growth and provide
real-time item-level visibility, keep track of regulatory and food safety certification compliance. The
existing warehouse management processes are manually recorded and prone to data entry errors. This
leads to problems in order completion, lack of adequate visibility into items in stock and delays in order
completion.
ITLS6008 2020 S2 Take-Home Quiz Instructions
3
The company needs a WMS, but solutions from market leaders such as SAP are cost prohibitive and
more complex than necessary for the company’s operations. You have been hired as a supply chain
specialist to design a scalable solution without requiring additional software investments. Given your
training at the University of Sydney, you have been asked by your manager to design the solution using
SQL Server Express.
You have been provided with some Excel data files by your manager to develop and test your solution
and have been asked to create additional dummy data for demonstrating the system’s capabilities. The
Excel files contain the following data:
– Distributors and retailers for Apromo Trading.
– Ingredients and food service products carried by Apromo Trading.
– Retail products carried by Apromo Trading.
Your WMS database design should include tables, data, a diagram and queries.
You will need to create dummy (i.e., fake/placeholder data for testing purposes – this is common practice
in operational database design) for tables that are necessary for your design but for which you have not
received any data from your manager. In the Word document, you need to report any queries you used
for creating dummy data.