Required Information

Question Set $10-1($Static$)$: Order$-$To$-$Cash $($LO $10-1)$

The order$-$to$-$csin $($O$2$C$)$ process, or ssles cycle, Ifwolves three msin processes:

Soles order procesaing

$2$ Order fulfilment snd shipping

Billing snd cssh callections

Finsoncisl sccountsnts are interested in determining the smount of ssles revenue on the income statement ond sccounts

Msnsgers are concerned with moking the proces: s: efficlent s: possible to ensure incresied sales volume, sufficient

profitsbility, and fast cash colection.

Audhors should test ssles tronssction snd msster dists to ensure that only outhorized users are process:ing arders, that

sale: prises match master data and aren't sitered, snd that cuatamers aren't exceeding spprovel limta$.$ In sodilion,

ouditors use sccounts recelvable sging schedules to evoluste outstanding bolances.

The O$2$C tsbles follow the UML disgrsm shown in Exhlait $10-1.$

Dato: $10-102$C Dato.zi $R-1\mathrm{.}9$MB Zip $/20$MB Excel

QS $10-1$ Part $1($Static$)$ Instruction: Financial: What is the Total Revenue and Balance In Accounts

Recelvable? $($LO $10-1)$

Begin by calculating sccount bolances used to prepore finenciol ststements. The orderto$-$cssh process provides dets to evol uste the

revenue, which the compsny bsses on the involce smount, snd sccounts recelvable bslsncea, whilh the compsny calsulstes bosed on

the dfference between the invalce snd cssh colections and write$-$offs. The revenue snd sccounts recelvable bs$/$ances are essentisl

for inclualon In the income ststement end bolence sheet, respectively.

Microsoft or Tableau

Using the skils you hove gained throughout thls text, use Microsoft Power Bl or Tsb lesu De:itop to complete the generic tosks

presented be ow:

Butld a new dsshbosod $($Trblesu$)$ or poge $($Power Bl$)$ called Financisi that includes the following:

Creste a new workbook connect to $10-1$ O$2$C Data.xlsx$,$ snd import sil seven tables. Double$-$check the data model to ensure

relationshlpa sre carrectly defined as shown in Evilbit t$0-1.$

$2$ Add $s$ tsble to your workaheet or poge caled Sales and Recelvables thest shows the invoice manth in esch row and the Inwalce

smount, rece$/$pt smount, soljuatment smount, AR bolance, snd write$-$uff percentege in the columns. Toblesu Hint Use Messure

Nomes in the columns snd Measure Values in the marks to creste your tsble. Then ance your table la complete, use Analytics $=$

Summarize $=$ Totals to calsulste column totsla.

You will need to creste o new messure or cslcu bated fied showing the sccount AR Balance, or the tatel invalce amount

minus the totsl recelpt amount minus the tatal sajuatment smount. Toblesu Hint. To minimize erroneous vslues from

sppearing in Tablesu due to blank or misaling values, use the IFNULL$()$ function to replose blank velues with $0,$ for exsmple.

Sppesing in Tesies. dide to

the write$-$uff percentoge sis percent or to four decimsla.

c$.$ Filter thla visuel to shaw anly volues from Jsnuery $2020$ to December $2020.$

percentage. Tablesu Hint Choose Dual AxIs snd Synchronize AxIs to combine the two vo jes.

Filter thla vasuel to shaw only volues from Jsnuery $2020$ to December $2020.$

A Cleon up the farmatting and tries of your visuals and combine them into $a$ :ingle deakbosrd or pege labeled Finencisl.

W Take a screenshot of your dashbourd showing the account balances $($label it $10-1$A$).$

Sove your workbook as $10-102$C Anslyals, srawer the lob questions, then continue to Part $2$