Milk Orders Over Week 10, 2020 Student: Brad | Subject: INF100 Milk Ordering Raw Data Date of Order (W2) Product No. units per crate/carton Equiv Litres per crate/carton. 4/03/2020 7/03/2020 3/03/2020 4/03/2020 6/03/2020 WM 9 2/03/2020 WM 9 3/03/2020 WM 9 5/03/2020 WM 9 7/03/2020 WM 9 8/03/2020 WM 9 2/03/2020 WM 9 3/03/2020 WM 9 6/03/2020 WM 9 7/03/2020 UM 12 18 Code WM 9 WM 9 WM 9 WM RF 36 RF 36 RE 36 Coles Express $ 2.56 $ 9 2/03/2020 UM 12 18 3/03/2020 UM 12 6/03/2020 UM 12 3/03/2020 RF 9 36 3/03/2020 RF 9 36 4/03/2020 9 2/03/2020 9 3/03/2020 9 Customer 45 Uncle Bob's milkbar $ 2.14 45 Uncle Bob's milkbar $ 2.14 45 7eleven $ 2.14 45 7eleven $ 2.14 45 7eleven $ 2.14 45 Coles Express $ 2.14 45 Coles Express 45 45 Coles Express Coles Express $ 2.14 45 45 Coles Express $ 2.14 BP 45 BP 45 BP Uncle Bob's milkbar $ 2.21 7eleven 2.21 18 Coles Express $ 2.21 18 BP Uncle Bob's milkbar $ 2.56 7eleven 7eleven $ 2.56 Coles Express $ 2.56 Supplier Price Per Unit $ 2.14 $ 2.14 $ 2.14 $ 2.14 $ 2.14 $ $ 2.21 $ 2.56 Retail Sale Per Unit $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
6/03/2020 FM 24 5/03/2020 5/03/2020 8/03/2020 7/03/2020 5/03/2020 6/03/2020 4/03/2020 3/03/2020 2/03/2020 6/03/2020 7/03/2020 5/03/2020 A2 4/03/2020 A2 9 27 8/03/2020 A2 9 27 8/03/2020 7/03/2020 18 13.5 4/03/2020 OM FM 24 FM 24 FM 24 SM 12 SM 12 SM 12 SM 12 LF 18 LF 18 LF 18 A2 9 9 A2 9 OM 18 13.5 12 Coles Express 12 BP $ 2.73 12 BP $ 2.73 12 BP $ 2.73 36 7eleven $ 2.87 36 Coles Express $ 2.87 36 Coles Express $ 2.87 36 BP 27 7eleven $ 3.46 27 Coles Express $ 3.46 27 Coles Express $ 3.46 27 Uncle Bob's milkbar $ 4.07 27 7eleven $ 4.07 Coles Express $ 4.07 Coles Express $ 4.07 27 BP 7eleven $ 4.37 Coles Express $ 4.37 Litres Ordered (W10-2019) $ 2.73 $ 2.87 $ 4.07 $ 3.02 $ 2.99 $ 2.99 $ 2.99 $ 3.19 $ 3.17 $ 3.17 $ 3.14 $ 3.84 $ 3.82 $ 3.82 $ 4.78 $ 4.53 $ 4.50 $ 4.50 $ 4.45 $ 4.86 $ 4.84 Total Orders LF OM 25 20 19 15 15 10 5 0 Coles Expres Total Orde Litres Ordered (W10-2020)
WM Milk Product Code RF A2 FM SM DUM OLF OM Milk Product Code A2 FM SM UM OLF OM WM RF Wholesale Cost and Supplier Price Wholesale Cost per Unit 90 Supplier Price Per Unit Supplier Price Per Crat 80 70 65.56 60 50 DOLLARS 40 36.64 34.40 30 19.27 20 23.07 10 2.03 2.14 0 Whole Milk WM 2.43 2.56 Reduce Fat Milk RF 3.77 4.07 Special Milk A2 2.45 2.73 Flavoured Milk FM