You have been recently employed as an accountant for Laurel Pty Ltd, an Australia manufacturer of car parts. The CEO, Mr Laurel, is looking to expand the business in the coming years and is seeking some advice from you.

Mt Laurel is concerned about some areas of the expenditure process and has asked you to analyse their processes for inventory management, from purchase to when it is used in the manufacturing process. Additionally, as Laurel Pty Ltd are looking to further evolve their business, Mr Laurel is seeking advice on the introduction of Business Intelligence (BI) and digital dashboards. To assist you in your review, Mr Laurel has prepared a summary of key information, which will be available in Interact.

Using the information provided to you, prepare a business report to Mr Laurel, the CEO, addressing the following:

1. Identification of:
   1. internal control weaknesses relating to Laurel Pty Ltds inventory management and expenditure process; (2.5 marks)
   2. the impact these weaknesses could have on the organisation; and (2.5 marks)
   3. specific internal controls which could be implemented by Laurel Pty Ltd in the coming months to mitigate the weakness posed by the internal control weaknesses you have identified. Note that they do not want theoretical controls suggested. You need to include practical controls that they can implement. (5 marks)
2. A analysis of how the introduction of business intelligence could impact on the organisation, taking into account:
   1. What is BI, including a discussion on digital dashboards? (3 marks)
   2. How will the use of BI and digital dashboards impact on Laurel Pty Ltd, including a consideration of the following areas: (4 marks)
      1. Management decision making; and
      2. Efficiency of the manufacturing process.

All parts of question 1 must be answered a table in your report. Answer this question using the following headings:

Internal Control Weakness	Impact of the weakness	Control to mitigate the weakness

3 marks will be awarded for the presentation of your report. This includes use of appropriate grammar and spelling, application of APA referencing and a report prepared in line with the presentation requirements below.

Senario for this question is as follows,

ACC539 201960 ASSESSMENT ITEM 3 Page 1 of 2

LAUREL PTY LTD EXPENDITURE AND INVENTORY MANAGEMENT

I have made some notes below to assist you with your review. I have captured the key details for Laurel Pty Ltd (Laurel), not absolutely everything in relation to our expenditure and inventory management processes. The process is a pretty rigorous one, but I am concerned about the increasing inventory costs. If we are going to grow our business in the coming years, we need to resolve any issues now before we expand. I look forward to receiving your thoughts on our expenditure and inventory management processes and the introduction of Business Intelligence here at Laurel. Good luck with your review. James Laurel CEO, Laurel Pty Ltd

OVERVIEW

Laurel is a large listed company, based here in Australia. We manufacture car parts for several major car brands, and ship these parts to manufacturers and retailers in Australia and around the world. A majority of our inventory is sourced here in Australia although a small number of components needs to be imported. I notice that our inventory costs have been slowly increasing which concerns me. Maybe this is due to changes in the exchange rate? Our headquarters and admin offices are located in Brisbane, Queensland. Our processing plant where all of our production, shipping and receiving is conducted is located in northern New South Wales.

PURCHASING

Our processing plant has 5 Department Heads who are responsible for all inventory purchases. When they think required inventory is getting low, they raise a purchase requisition (PR), which the system sends it through to the purchasing team in our Brisbane offices. The Purchasing team consists of 2 full time and 2 part time purchasing clerks (clerk). When a PR is received, it is logged into a queue and actioned by the next available clerk. Upon receiving a PR, the clerk is expected to review the contents of the PR to check that the request details are reasonable and that it has come from one of the Department Heads. Once they have reviewed the PR, the clerk selects a supplier based on who the items was last ordered from and raises a purchase order (PO). The system emails the PO to three locations: 1. the clerk who raised the PO. The clerk then emails the PO to the supplier. 2. the Department Head who raised the PR. 3. the receiving team. This lets them know what they should expect to receive and makes their process easier, especially when they are really busy. At the end of every week, the purchasing team have three oversight functions. They are responsible for:

ACC539 201960 ASSESSMENT ITEM 3 Page 2 of 2

1. Reviewing any POs which have been outstanding for more than 2 weeks to determine why they are still outstanding. I have been informed by the team that this is sometimes due to errors by others in the team.

2. Reviewing any discrepancies highlighted by the system as a result of differences between the inventory received and inventory ordered based on the PO and the receiving report (see receiving department details below).

3. Reviewing any discrepancies between the supplier invoice, the PO and the receiving report (see accounts payable notes below).

Sometimes there is an overlap between processes 2 and 3, as a supplier may have sent us an invoice before one of the clerks has had a chance to follow up discrepancies between the PO and the receiving report. This only occurs when we are really busy and has only inconvenienced a couple of suppliers.

RECEIVING DEPARTMENT

There should be 6 people in our receiving team, however, we have only had 3 receiving officers for the last 18 months. This hasnt been too much of an issue, although I have noticed that the team have worked a lot of overtime over this period of time. The receiving department gets a copy of each PO. When inventory is received, a receiving officer matches the items received to the PO in the system. Once a delivery has been matched, the receiving officer submits the details into the system and a receiving report is generated. Any differences between the inventory received and those on the PO are automatically flagged in the system and followed up at a later date by the purchasing team, as noted above. The inventory received is then stored in the warehouse until required in production.

INVENTORY MANAGEMENT

The warehouse team are very efficient and effective. They never take leave and have the warehouse running like clockwork. All inventory is stored based on the manufacturing process it belongs to. If there are ever any discrepancies, they notify the Department Heads immediately so more inventory can be ordered if necessary.

ACCOUNTS PAYABLE

When a tax invoice is received from a vendor, the accounts payable team (AP) match it to the PO and receiving report. Where there is a match, the invoice is included in the appropriate payment run and paid via electronic transfer prior to its due date. Where there is a discrepancy, the AP clerk flags this in the system which is later followed up by the purchasing clerks, as noted above. All payment runs are reviewed and approved by the AP manager before any payments are made. We are really strict regarding this as I have read a lot regarding fraud and how frequently it occurs when businesses make cash payments. The AP manager review the amounts paid in each payment run to the supporting documentation prior to approving the payment run. No payments can be made without the approval of the AP manager. When she is on leave, one of the AP clerks steps up into this role so we do not miss a payment run.