Primark Case Study

Decent Essays
Primark Company Background Primark is part of Associated British Foods (ABF), a diversified international food, ingredients and retail group. Primark has almost 200 stores across Ireland, the UK, Spain, Netherlands, Germany, Belgium and Portugal. Primark’s annual turnover accounts for a significant proportion of ABF’s revenues and profit. Today, Primark specializes in clothing, while marketing primarily to fashion-conscious customers that want value for their money. Important business principles for Primark include respecting human rights and setting guidelines for appropriate conditions of employment in its suppliers ' factories. Primark has over 600 major suppliers in 16…show more content…
Audit Process Table

The table above depicts the overall auditing process. Each time an audit has been conducted it has been given a unique audit ID number so it is easier to lookup. The table also shows the manufacturing sites, which must be audited with a manufacturing ID as well as auditor ID. There is a start date and end date as well as a project price for the audit process. This table can be connected to the manufacturing sites table by linking manufacture ID. Unapproved Sites Query This table clearly depicts which manufacturing sites have not been approved. It shows which sites have no been approved by the manufacturer ID as well the country which it is located and the size of the site. This query is linked to the manufacturing sites table by the manufacturing ID. By only showing unapproved sites this enables a simple means of looking up which sites must still be audited. Auditors in Budget Query This table shows which auditors and under which affiliation will be most cost efficient for each manufacturing site. When designing this query we used the criteria of under $400 to show us which auditors were in Primark’s price range. All audit processes under $400 will be used and will ultimately save Primark a significant amount of money. All Data Query

The following data is from our final query that contains most of our data from each table so it can easily be transferred to excel. The data
Get Access