, AIN3701 Assignment 3 COMPLETE ANSWERS) 2024
(592440)- DUE 10 September 2024 ; 100%
TRUSTED Complete, trusted solutions and
explanations.
You have been appointed as a financial manager at Ubuhle
Bemvelo Bistro (UBB). UBB is one of the top restaurants in
South Africa, serving traditional South African dishes. UBB is
situated in a private game reserve in Pretoria and is being
visited by local and international visitors. UBB was also
recognised by an international magazine as one of the must
visit attractions in South Africa. Another achievement achieved
this year was for UBB to be awarded as one of the top 10
restaurants in South Africa. You are reporting directly to the
financial director, Mrs Ceki, who qualified as a CA(SA) in 1998.
Part of your duties is to assist Mrs Ceki with drawing up visual
dashboards for UBB. UBB uses Microsoft Excel 365 to generate
visual dashboards. UBB has invested in a new sales system who
generates summative records of sales during the year, per
product category (category) and product. These records include
the month of sale as well. The CEO of UBB, Mr Gokal, is very
exited about this new system and has provided Mrs Ceki with
the electronic records of the system. He asked Mrs Ceki to draw
up a visual dashboard reflecting the sales volumes for the 2024
year. Mrs Ceki is not well versed in visual dashboards but know
a few functions in Excel 365. She has spent around two weeks
to generate a draft dashboard for one of the product categories.
She presented the draft dashboard to Mr Gokal, and they agree
(592440)- DUE 10 September 2024 ; 100%
TRUSTED Complete, trusted solutions and
explanations.
You have been appointed as a financial manager at Ubuhle
Bemvelo Bistro (UBB). UBB is one of the top restaurants in
South Africa, serving traditional South African dishes. UBB is
situated in a private game reserve in Pretoria and is being
visited by local and international visitors. UBB was also
recognised by an international magazine as one of the must
visit attractions in South Africa. Another achievement achieved
this year was for UBB to be awarded as one of the top 10
restaurants in South Africa. You are reporting directly to the
financial director, Mrs Ceki, who qualified as a CA(SA) in 1998.
Part of your duties is to assist Mrs Ceki with drawing up visual
dashboards for UBB. UBB uses Microsoft Excel 365 to generate
visual dashboards. UBB has invested in a new sales system who
generates summative records of sales during the year, per
product category (category) and product. These records include
the month of sale as well. The CEO of UBB, Mr Gokal, is very
exited about this new system and has provided Mrs Ceki with
the electronic records of the system. He asked Mrs Ceki to draw
up a visual dashboard reflecting the sales volumes for the 2024
year. Mrs Ceki is not well versed in visual dashboards but know
a few functions in Excel 365. She has spent around two weeks
to generate a draft dashboard for one of the product categories.
She presented the draft dashboard to Mr Gokal, and they agree
