Hi, Can you help me to solve these tables in the excel?
Complete the spreadsheet by using the correct formulas to fill in the missing data.
1.In the "Ordering Raw Data" table complete the "Equiv Litre per Crate/Carton" column In the "Ordering Raw Data" table complete the "Supplier Price per unit" and "Retail Sale price per unit" columns.
2.In the "Milk Products" table complete the "Supplier Price per unit" column.
3.In the "Customer Order (week32) review" table complete the "Total Orders 2017 (W32)".
4.Complete the milk production table
The formulas required to reveal the missing data include Vlookup, Countif and Sum. Absolute addressing is also required.
I just want to know how to do it I don't want to use the tutor's work as mine
EDEK)' insert PageLayoul Farmulas Date Review View E UMP W32 data belore 2018 Develapel vegan: .. v v A v = = *9. ' v v v ' 3'5 'Id-tl' Emmauva ' Ii?! cum ' Callbri (Brady) 1D A A 4/ HI 5.; Wrap Tm Custom 0 M Q Q 1: l El iii W 2? Pasta 67 Farm" 3 1 g v - 3 2 3 Merge a. Center . $ v % 13-" w $33323: Loggia 33:25 insert Delete Format 4' may _ imp P9 3 r - A B C D E F G I J K L M N 1 Milk ORDERS Over Week 32 [Aug 7-14] - 2017 2 3 Ordering raw data Custamlsed button - We: mutt Ila. unlls pn- Equhr Bins pu- SWluPu m WinI your chelce. 4 [W32] Code Intifada" mulamn. Customer Pu Unll: Per Unit 5 5/08/1017 WM 9 ' Coles Express ' 6 W08f2017 A2 9 BF Mllk Prod nets Table 7 7mf1017 FM 24 Coles Express Wholesale Cost 8 7mgj2017 LF 1.! Gales Express Code Product Duuhnu ninja-man mm] per Unit 'I'nhl Mai Sale 9 7mf2017 RF 9 (Sales Express WM Whale Milk 9 2 S 1.76 10 7f08f2017 UM 12 7eleven RF Reduce Fat Milk 9 2 S 2.22 11 7708/2017 WM 9 BP A2 Special Milk 9 2 S 3.32 12 BIOSJ'2017 LF 18 7eleven FM Flanmured Milk 24 0.6 S 2.61 13 8/081'1017 RF 9 Blil's mllkbar SM Skim milk 12 1 S 1.92 14 $08,101? UM 12 (Sales Express UM UHT Milk 12 1 S 135 15 BIOS/2017 WM 9 Coles Express LF Lactose Free Milk 18 1 S 2.13 16 9mf2017 RF 9 Televen Organic Milk 18 1 S 2.45 17 9'08} 2017 RF 9 Gales Express 18 9mf2017 WM 9 7e Leve n 19 9:081:01? WM 9 BP 20 10/08/2017 A 2 9 Coles Express Cusmmer: Specic 96 p rlee ' 21 10mf2017 CM 1.! (Sales Express premlums [null] 96 22 10/08/2017 RF 9 7eleven } Coles Express 6 23 10/081201? RF 9 BP IP 12 24 10mf2017 SM 12 BP Teleuen 16 25 10/08/2017 WM 9 7eleven Bill's mllkbar 20 25 mica/2017 WM 9 Bill's milkbar 27 11mf2017 A 2 9 7eleven 333333333: 25 11f08f1017 FM 24 7eleven NI praducnn - MI Ilns nest, pres-1t Ind melon-d future) 29 11f08f2017 FM 24 BP LIES Mm LINE Mm Projected Lib'd 30 11f08f1017 FM 24 BP Product Dachon MIMI-6] m1?) [Wim] 31 11f08f2017 RF 9 BP WM Whale Milk 0.95 182.81 32 11f08f2017 RF 9 Gales Express RF Reduce Fat Milk 0.8 140.63 4 p Sheet 1 + 125% ____+ E UMP W32 data before 2018 Formulas Date Review View Developer . gm 'Caliurl {Brady} v 10 v AA Av = = 507 v HI - 5.; Wrap Tm ' Custom v' Copy v Pasta '7 Farm" 3 I U v - 1: g Merges. Cant-r v s v % 3 fig '93 Earmal Lewis; 33:25 lnsen Belem Forum a Char ' SEE: P9 3 r - l J K l. M N a F a R 5 T U I w 1 2 i 4 5 6 7 8 m Dam Total Customer Order [wackzl review 9 Whole Mllk 1a Reduce Fat Mlllr . ' 11 Speclal Mlllc . Gales Express 15 12 Flavoured Mllk . EP 10 13 Sklm mllk ' 7eleven 11 14 UHIMlllr . _ Elll'smllkbar 5 15 Lame Free Mlllr ' Tours 11 16 Organlc Mllk 1'." 18 I? 1'] 20 Molnar: Sped: 9: price ' 21 premium: [mini] 96 22 Cele. Expras s 23 BP 12 24 'felzven 16 25 Blll's milkbar 20 26 27 Insert Graphl here : 20162018custamer order reviewand projection 28 29 m WNW "III! Drdlrld lih'll mud "cull-MI ,\ 30 cu- rrodun Damn nun (WEI-.2016) ("132-20111 [WEI-2018} 31 WM Whale Mllk 0.95 152.51 ' ' 32 RF Reduce Fat Mllk 0.3 100.69 33 A1 Speclal mm: 0.95 10.31 I :5 34 FM Flavoured Mllk 0.9 1.01.25 5. u. .l... .h "-9 f A 4 p Sheet 1 + Ready 13 El JJ p + 117%
