Exam (elaborations)
AIN3701 Assignment 3 COMPLETE ANSWERS) 2024 (592440)- DUE 10 September 2024
- Course
- Automation and data analysis
- Institution
- University Of South Africa
100% TRUSTED WORKINGS, EXPLANATIONS & SOLUTIONS
[Show more]
Content preview
AIN3701 Assignment 3COMPLETE 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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through EFT, credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Solutionist. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for R44,57. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
82871 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy summaries for 14 years now