task is to identify and correct these discrepancies in the spread sheet. report, because your supervisor has expressed concerns that there are discrepancies. These could be related For this task you are provided with the spreadsheet file "SITXINV004 Assessment 2 Task 2 The figures in these reports are different to the figures in the actual calculation spread sheet. Therefore your You are required to check the data that has been entered in this spread sheet based on the latest stock discrepancy and correct the figures so that all the figures tally with the final totals in each report. to the price of the stock item or the quantity of the stock item. You need to identify the correct stock impact on the total figures as well as the availability of these stock items in relation to maintaining and You need to write a brief summary report to explain the potential reasons for these discrepancies and how Open the spreadsheet and identify all missing values in the opening stock column in each tab (Fridge. 2. Complete the opening stock values based on any movements (Invoice = delivered, Out= used) or movement this needs to be calculated before entering the missing value in the opening stock column, i.e. if closing shows 6 and invoice shows 5, then the opening stock would have been 1. You will now based on the closing stock values, i.e. if the closing value shows 5 and there were no movements. then enter 5 in the opening stock column where the value was missing. If there was a stock notice that most entries you made have corrected the values in the discrepancy columns to 0 Go to the tab "Fridge" and investigate the reasons for the discrepancies in Rows 8, 38, 83 and 89. Go List 3 factors you would investigate where a value in the discrepancy column shows a negative. controlling stock Freezer and Dry Store). to the tab "Dry Store" and investigate Row 65. What are the likely problems that have resulted in these faults? Correct these faults according to your 6. Go to the tab "Consolidated Total" and calculate how your adjustments from Question 5 above have findings by adjusting the relevant values, if possible. affected the totals for each storage area and the total sum. LEMON GRASS 3 4 5 Unit Assessment Pack SITXINV004-Control Stock Example 2 Task 2 Error in data entry (wrong numbers, decimals in wrong place, opening balance not entered, stock issued but it Key points to consider are: was actually invoice) The following examples will assist you in your task. 1 Example 1 yellow]. No stock was received (invoice) or issued (out), therefore you would enter the value of the closing For example an error could relate to the fact that the original opening stock was not entered as highlighted [in stock in the opening stock column. Item Description Unit 100G Unit $ $ 6.00 Supplier oning Invoice Out Sub- Total 0 Closing 1 Closing $ S 6.00 Discrepancy

dis orepancy 1. Openezer and Dry Store) 6. Go to the tab "Consolidated Total" and calculate how your adjustments from Question 5 above have and the total sum cere Key points to consider was actualy invoice) The following examples will assist you in your task Example 1 For example an error could relate to the fact that the original opening stock was not entered as hightighted lin Example 2