Assessment 5 (Activity 6.7) Due 27 September 2023

THIS DOCUMENT CONTAINS EDITABLE SOLUTIONS TO AIN3707 ACT

, Dashboard

Sum of Jul-
Cake Profit 23




341922
47057



44890



37982



37600



33168



25646



24502



24193



23327



16143



14912



12502
es
t t s el ge na te rry ui
t e
ve
t
i su lt
or rro ke m an na ol
a
be Fr gu l su
Ca ca ra r in ve m e
kf Pa
n Ca O B a oc w e r d ira lR
ac Ch tra M Re T ta
Bl S on To
m
Le




Total Profit

R30 000


R25 000


R20 000


R15 000


R10 000


R5 000


R-
Chocolate Total Result




10% 45%

8% 40% 40%

6% 35%

4% 30% 30%

2% 25% 25%

0% 20%
Division Breads Cakes SA Delights
-2% 15%

-4% 10%

-6% 5%

-8% Data Column C Column D Column E Column F Column G Column H 0%
Column I

,Division Aug Sep Oct Nov Dec
Breads
(empty)
(empty)
(empty)
(empty)
(empty)
Cakes
(empty)
(empty)
(empty)
(empty)
(empty)
SA Delights
(empty)
(empty)
(empty)
(empty)
(empty)
Total Result

, Data
Sum of Rev Jan Sum of Rev Feb Sum of Rev MaSum of Rev ASum of Rev MSum of Rev JunSum of Rev J
2397201 2403792 2557166 2295787 1958659 2307272 2875197
2397201 2403792 2557166 2295787 1958659 2307272 2875197
2397201 2403792 2557166 2295787 1958659 2307272 2875197
2397201 2403792 2557166 2295787 1958659 2307272 2875197
2397201 2403792 2557166 2295787 1958659 2307272 2875197
2397201 2403792 2557166 2295787 1958659 2307272 2875197
905504 1043994 856865 1185516 911045 988872 906691
905504 1043994 856865 1185516 911045 988872 906691
905504 1043994 856865 1185516 911045 988872 906691
905504 1043994 856865 1185516 911045 988872 906691
905504 1043994 856865 1185516 911045 988872 906691
905504 1043994 856865 1185516 911045 988872 906691
1156039 1109449 1179483 899166 822733 943667 894107
1156039 1109449 1179483 899166 822733 943667 894107
1156039 1109449 1179483 899166 822733 943667 894107
1156039 1109449 1179483 899166 822733 943667 894107
1156039 1109449 1179483 899166 822733 943667 894107
1156039 1109449 1179483 899166 822733 943667 894107
4458744 4557235 4593515 4380468 3692437 4239811 4675995