AIN3701 Assignment 3
COMPLETE ANSWERS) 2024
(592440)- DUE 10 September
2024
100% GUARANTEED
, AIN3701 Assignment 3 COMPLETE ANSWERS) 2024
(592440)- DUE 10 September 2024
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 that the dashboard should look like the following
dashboard: Mrs Ceki is on leave for the following two
weeks, and she asked you to draw up the visual
dashboard. The visual dashboard should be fully
COMPLETE ANSWERS) 2024
(592440)- DUE 10 September
2024
100% GUARANTEED
, AIN3701 Assignment 3 COMPLETE ANSWERS) 2024
(592440)- DUE 10 September 2024
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 that the dashboard should look like the following
dashboard: Mrs Ceki is on leave for the following two
weeks, and she asked you to draw up the visual
dashboard. The visual dashboard should be fully
