1. Activity6.7

The CEO of Ikhishi Likagogo was very impressed after you have developed the initial dashboard. Dueto the dashboard of 2022, she was able to identify that cash was not a KPI for the company. She alsolooked at other KPIs for similar companies and decided the major KPI will be net profit percentage(NP%).Shedecidedthatthebudgetednp%forthedivisions wouldbeasfollows:

Division	NP%
Breads	25%
Cakes	40%
SADelights	30%

Table6.15:Netprofitpercentagefordivisions-2023

Her requirement is to be able to select a division and then to immediately see what the divisions netprofit percentage, net profit and revenue are. Also, part of this view should indicate if the selecteddivision is over or under budget with the variance. She wants to be able to see it per the selectedmonth.Toassistherinidentifyingtop performingproductsandpoorperforming products,shewants to see a chart displaying the top 5 or the bottom 5 products per the division selected initially(please show actual and budget values). Another requirement (on a separate chart in the dashboard)is to see the np% for a specific product (per the division selected initially). This product should trackthe actual np% versus the budgeted np%. She wants to see this for the whole year, viewing the trendofthenp%. ShecallsthischartaNetprofitpercentagetracker.

Lastly, she told you that she is a bit old school and still want to include a table in the dashboard.Whenselectingthedivisionandmonthabove,thetable shouldpopulate thefollowingfields:

NP%

Profit

Revenue

Nr*

ProductName

Act

Bud

Var

Robot*

Act

Bud

Var

Smileys*

Act

Bud

Var

Bar*

Table6.16:Tablerequirementindashboard

Therowswiththe *shouldnot haveaheader,but theirmeaningsare asfollows:

Robot: If the np% is below budget, then a red light should appear. If budget is net plus 10%above budget,ayellow indicatorshouldappear.If over10%of budget,a green

indicatorshouldappear.Forexample, .

Smileys: If the variance between actual and budget is positive, then awill appear;otherwiseashouldappear.

Bar: A bar where 0 is the mid-point. Any variance above zero should be a bar chart to theright,anda value belowzeroshouldbea barcharttothe left.

This table should be sorted from the highest net profit percentage to the lowest. She also only wantsto see10productsata time.She asks youtoinsert ascroll bartoscroll to thenext products.

You can download the data spreadsheet that was supplied by the CEO here. Please note that thespreadsheethas twosheets. (Thedateof thisdatasetis 31July2023.)

You are required to develop this dashboard in Microsoft Excel 365. The CEO requested that you usecompany logo colours in your graph unless specifically requested otherwise. Once your dashboard isdone, print your output (dashboard) to a PDF file (please select July and the Cakes division; the tableshould display product 1-10, Top 5, Profit and Chocolate cake). Make sure that it fits on one pageand that the content is readable. You will be assessed on the content and best practice principles ofyourdashboard.

Please uploadyourPDFdocumenthere.

000 000