View the step-by-step solution to:

# 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 '

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- SWlu—Pﬂu m Win—I your chelce.
4 [W32] Code Intifada&quot; 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 Duuhﬂnu 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: Speciﬁc 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 praducﬂnn - 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 Dachﬂon 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 Earmaﬁl 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 [wackﬂzl 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'.&quot;
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 : 2016—2018custamer 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 &quot;-9 f A 4 p Sheet 1 +
Ready 13 El JJ — —p— + 117%

Data Review View E UMP W32 data beiure 2018 Developer = _ .9 . . n—u E Aumsum v
. _ vv pﬂ- EJWfapTﬂll Custom H. bi. LLﬂ' CH. El. El. Elm&quot; awf.
Paste : : : ; Margaﬂ. cantor . 5 v % \$3323: 31\$; 33:25 \nsun Delete Format 4’ my _ am? pg v H 1 J K L M N G 5 T U W
13 SM sum. mm: 12 1 5 1.92 I] s 7elmn 11
14 uM LIHT Milk 12 1 5 1.115 12 s EHl‘s mllkhar 5
15 LF Lactose Fm Mllk 1a 1 5 2.13 16 5 Total; n.
16 DM Organlt MI”: 13 1 5 2.45 22 s
17
18 I?
19
20 Bummer: Speﬁh‘)‘ prim ‘
21 premium: [yeti] 9G
22 ms Extras 6
2; BF 12
24 Televen 16
25 Bill‘s milkhar 2|]
26
2? insert Graph 1 here .- 20152018 customer order review and projection
28
29 Medan mhw litres Ordered litres Ordered Preterm-dunes ,\
30 Code m Description nun (wan-amen [mm—2011] nun-1018]
;1 WM Whole Milk 0.95 132.31 ‘
;2 RF Reduce Fat Milk 03 1441.63
;; A2 Speclzl Mllk 0.95 70.31
;4 FM ﬂavoured Milk 0.9 101.25
35 SM Sk‘m MIN: 0.? 37.50
36 UM UHT MHk 0.5 37.50
3'.&quot; LF Lactose Fm Mllk 0.6 i2.19
35 OM Organlc MHk 0.75 23.13
39 Tank no.“
40 insert Graph 2 here .- 20152018 miik production review and projection
41
42
43
44
45
46
4?
48 4 p Sheet 1 + Ready 13 _ —L;— + 117%

E UMP W32 data beiore 2018 Farmu Ias Data Review View Develuper _ r - . ‘ Id-tl Aumsum v
. 7 = i9! ' HI ' Ea Wrap Tm Custom v' H. by L12. {AH . El . El . % MY %?.
Pasta 1: E :: E Mnrgaﬂgcanur v s v % 3 fig ‘93 agrml 3:14:21 53:25 Man: Balm Format 0 an&quot; SEEK?
P9 . . v
N Cl P Q R S T U I W X Y 2 AA AB AC AD AE AF AG AH
T
2 turnisad button -
your choice. Total Customer Order [maul] review WM“
Crib-[W
__ _ —
_ 0am Express 15
l- BP 10
_ Mm 11
_ am mukbar 5
_ Tar-Is ‘1
I—
_
— -II
20
21
22
23
24
25
26
27 Insert Graph 1 here .‘ 2015-2018 customer order review and projection
zs El
29 [Id WING Ull‘ll ,\
30 1] mama“)
31 ‘ I
32
33 I :5
34 f
'u A 4 p Sheen +
Ready 13 El JJ ——\_',—+ 117%

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents