Calculate the excel spread sheet file for stocktake -discrepancies . Summary report on discrepancies and how to control these . In this task you need to refer to following stocktake report files

PART B: STOCKTAKE - DISCREPANCIES Openin Item Description Unit Unit $ Supplier Invoice Out Sub-Total Closing BAGUETTE 1/2 52 BOX 29.83 PETERS BARRAMUNDI KG 2 13.8 SHANES BERRIES KG 2 8.5 PETERS 2 2 BLACK MUSSELS KG 10.5 SHANES 2 5 7 DINNER ROLLS 160 10 BOX 32.77 PETERS A 4 DUCK RAVIOLI KG 31 ANDREWS 16 15 FILO PASTRY 275G 10 4.05 PETERS 3 3 GELATOS 5LTR GOOD 32.5 FOODS 2 2 GREEN PRAWNS 2KG 2 21/25 29.5 SHANES 8 8 HASH BROWNS 19 2kg 6.75 PETERS 12 ICE CREAM 12 5 LTR 12 16.9 PETERS 6 6 7 INDIVIDUAL SLICE EACH RED 1.8 FUNNEL JAP SCALLOPS 77 77 KG 77 40 SHANES 8 15 7 16 LOBSTER 500G KG 12 59.59 SHANES 7 3 4 MORP SOUR EACH DOUGH 3.4 10 25 35 35 PARTY PIES 72S BOX 23.84 PETERS 3 3 PEAS 2KG 4.1 PETERS 3 3 PUFF PASTRY 1KG SHEETS 4 PETERS 5 5 10 SARA LEE 2.3KG LASAGNE 12.7 PETERS 1 SMOKED KIPPERS 5KG 14.95 0.5 SPINACH 0.5 BOX 0.5 TRIANGLES 24 0.2 SQUID TUBES 0.2 KG 0.2 9.8 SHANES 2 2 STEAK FRIES 5KG 2 10.65 PETERS 0 TURKISH BREAD 20 BOX 48 PETERS 0.5 SPRING ROLL 0.5 1.5 PASTRY 250G 1.95 PETERS 28 28 28 Assessment Task SITXINV004 Control stock Page 12 of 17 DUCK SHANKS 2KG GOOD 2 2 2 VENISON RACKS KG 40 2.9 2.9 2.9 INDIVIDUAL TARTS EACH 2.2 SNOWS 63 19 82 80 QUAIL EACH 4.25 48 48 48 SALT PEPPER REDFUNNE SQUID 13.75 SMOKED DUCK KG 32 2.3 2.3 1.2 TURKEY BUFFE kq 8.5 ANDREWS 5.5 5.5 5.5