SITXINV401 Control stock
Assessment 2 – Stocktake Calculations
STUDENT NAME:
STUDENT ID: (if applicable)
DOB:
ASSESSMENT DATE:
STUDENT DECLARATION: ? I certify that this is my own work.
STUDENT’S SIGNATURE:
-----------------------------------------------------------------------------------------------------------------------------------------------------------
ASSESSOR’S NAME:
ASSESSOR’S COMMENTS:
(if applicable)
? SATISFACTORY ? NOT YET SATISFACTORY
ASSESSOR’S SIGNATURE:
DATE:
ASSESSMENT INSTRUCTIONS
Please complete the student details section.
This Assessment task contains 3 parts (PART A, B and C)
This assessment is one form of assessment type that is used to collect evidence and will count towards gaining competence toward this unit.
To demonstrate competence each task must be answered by the student.
If more space is required for any answer then student can attach a separate page containing their name, assessment date, unit title unit code and the assessment task number and attach this page with the current assessment task before submission.
When you have completed all the questions check your work before submitting.
Please note once the assessor has marked your work they will provide you with feedback. Based on the feedback if you are required to resubmit any question/s then you must complete those question/s by adding more information.
You will be required to complete other relevant assessment tasks for this unit.
Evidence Submission
PART A – Stocktake - Calculate and submit the excel spread sheet file for Stocktake in soft copy and print and submit a hard copy, write you name date unit code and unit title on the print out.
PART B –- Stocktake – Discrepancies - Calculate and submit the excel spread sheet file for Stocktake Discrepancies in soft copy and print and submit a hard copy, write you name date unit code and unit title on the print out. Also submit your summary report on the discrepancies and how to control these.
PART C - Stock Re-Ordering - Calculate and submit the excel spread sheet file for Stocktake Discrepancies in soft copy and print and submit a hard copy, write you name date unit code and unit title on the print out.
Assessment 2 CASE STUDY
Stock Control – Club Futura
You have been recruited as a new assistant to the purchasing officer at the Futura club. As a part of your new role you are required to perform calculation to check the accuracy of the stock records and the costs, analyse stock records and identify any discrepancies and report to your supervisor.
For this task you are provided with the following file - SITXINV401 CS Stockake.xlsx – excel spread sheet file that provides you with the data on the stock.
PART A - Stocktake
You are provided with the following figures about the stock on hand for certain items. You need to enter these figures into your stocktake sheet (refer and use the above excel spread sheet) to perform calculations so that you can establish the value of the individual stock items as well as provide a total value of all stock items on hand.
PART B – Stocktake Report - Discrepancies
For this task you are provided with the spreadsheet “SITXINV401CS Task 2 Part B_WB”.
1. Open the spreadsheet and identify all missing values in the opening stock column in each tab (Fridge, Freezer and Dry Store).
2. Complete the opening stock values based on any movements (Invoice = delivered, Out = used) or 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 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 notice that most entries you made have corrected the values in the discrepancy columns to 0
3. List 3 factors you would investigate where a value in the discrepancy column shows a negative.
4. Go to the tab “Fridge” and investigate the reasons for the discrepancies in Rows 8, 38, 83 and 89. Go to the tab “Dry Store” and investigate Row 65.
5. What are the likely problems that have resulted in these faults? Correct these faults according to your findings by adjusting the relevant values, if possible.
6. Go to the tab “Consolidated Total” and calculate how your adjustments from Question 5 above have affected the totals for each storage area and the total sum.
Key points to consider are:
Error in data entry (wrong numbers, decimals in wrong place, opening balance not entered, stock issued but it was actually 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 highlighted [in yellow]. No stock was received (invoice) or issued (out), therefore you would enter the value of the closing stock in the opening stock column.
Item Description Unit Unit $ Supplier Opening Invoice Out Sub-Total Closing Closing $ Discrepancy
LEMON GRASS 100G $ 6.00 0 1 $ 6.00 1
Example 2
An item shows in the opening balance 0.5 boxes and 0.5 boxes in the sub-total, but 1.5 boxes in the closing balance, then this would require you to check whether there was an invoice. If not then you could check on the last stocktake and if that shows that the value there showed 0.5 boxes, then the value 1.5 likely is to be 0.5 boxes. As you have no prior documentation you would highlight this but make no changes.
Item Description Unit Unit $ Supplier Opening Invoice Out Sub-Total Closing Closing $ Discrepancy
BOCCONCINI BOX $ 35.00 PETERS 0.5 0.5 1.5 $ 52.50 1
Example 3
Any items which show a negative discrepancy need to be investigated whether a theft has occurred (consider chocolates, alcohol, prime cuts etc.), the opening balance was incorrect or an item was actually invoice rather than out or vice versa.
Item Description Unit Unit $ Supplier Opening Invoice Out Sub-Total Closing Closing $ Discrepancy
MINTS 9KG BOX $ 69.00 EWH 0.5 0.5 0.2 $ 13.80 -0.3
PART C – Stocktake – Stock Re-Ordering
You are required to enter the stock data and perform calculations to check the available stock on hand so that you can calculate the total cost that you would need to spend on the reordering of these stock items. Then write a summary report on the stock items that are fast moving and slow moving items to indicate the usage.
Refer to the following table to complete this task. You are required to enter the following figures in the excel spread sheet that you are provided (file name – SITXINV401 CS Assessment 2, PART C.xlsx)
Items Specification Weight /kg/l/unit Price Stock on hand Minimum Level Maximum Level Order required
Dry Goods SOH
Salt Rock 1.000 kg $ 0.80 2 3 6 3
Pasta Fettuccine 0.375 Packet $ 1.10 3 10 24 20
Tomatoes Canned 0.375 Can $ 0.78 16 24 48 20
Soy Sauce 0.500 L $ 2.80 20 2 6 0
Dairy
Cream Thickened 0.600 L $ 1.52 20 10 40 10
Milk Full cream 1.000 L $ 1.18 4 6 20 10
Butter Salted 0.500 kg $ 1.82 6 10 40 10
Butter Unsalted 0.500 kg $ 2.23 10 6 12 0
Cheese Cheddar 1.000 kg $ 8.55 8 1 4 0
Seafood
Trout Whole - 300g 1.000 each $ 3.20 16 15 30 10
Prawns Cooked Medium 1.000 kg $ 18.50 12 3 8 0
Oysters Pacific shucked 1.000 Dozen $ 6.80 24 24 48 10
Poultry & Meat
Lamb Rack - 6 rib 1.000 each $ 4.80 15 20 40 15
Beef Tenderloin 1.000 kg $ 18.00 20 10 25 0
Pork Cutlet - 250g 1.000 each $ 2.60 25 20 40 0
Kangaroo Rump - denuded 1.000 kg $ 14.00 16 10 30 10
Fruit & Vegetables
Lettuce Butter 1.000 each $ 1.60 36 6 24 0
Tomatoes Roma 1.000 kg $ 2.80 4 4 12 6
Potatoes Desiree 1.000 kg $ 1.25 40 20 50 0
Apples Granny Smith 1.000 kg $ 1.89 5 4 10 5
Mangoes Fresh 1.000 each $ 1.80 16 20 60 20
GET ANSWERS / LIVE CHAT