This post has two assignments:
-
” Comedians in cars getting coffee”
The paper should talk about the show ” Comedians in cars getting coffee” Season one, episode 1. The guest of the episode was Larry David. The paper should talk about the difference between Ethos, Pathos and logos. Also, the main two thing this paper should include that in the show they talked about how people like coffee or tea, cigarettes and cigars, boxers and panties. The writer should write about people choose and evaluate what to get from those choices.
2. Case studies: Analytics mindset
TechWear
Part ll:
Required: …
Now that you have your data, you need to perform appropriate analytics techniques to inform your risk
assessment for the order-to-cash cycle for TechWear.
1. Develop an accounts receivable (AR) trial balance (by customer and by invoice) as of December 31,
2015.
‘ Recall that beginning AR + sales – sales returns – cash receipts – bad debt write-offs = ending
AR. As mentioned in Part l, the beginning accounts receivable balance is zero and there are no
returns or write-offs in 2015.
Perform the following analyses relating to collectibility risk (which is the risk the company won’t collect
money for its sales) on the December 31,2015, accounts receivable balance. For each procedure,
provide a brief statement regarding your findings. tear
2. Display the year-to-date trend in sales and cash receipts by month for 2015 (with months on the x- c I , l’o( t
axis and dollars on the y-axis). Use a visuatization to best highlight any concerns about potential f*’ 1
collection issues.
3. Compute the year-to-date days-sales-outstanding (DSO) ratio for each month. Show the results
numerically and with a visualization. For the latter, use a column chart, also called a vertical bar chart
(with months as the x-axis and DSO as the y-axis), to best highlight any concerns about potential
collection issues
– DSO = ending AR balance for the period / total sales for the period (year-to-date)) * number of
days in the period (year{o-date)
4. Develop an aging analysis by customer and invoice using 30-day increments (0-30 days, 31-60
days, 61-90 days and > 90 days). Display this at the customer level with the ability to drill down to the
transaction (invoice) level. Provide a visualization of the percentage of accounts receivable in each
aging category at the company level using a column chart (with aging category as the x-axis and
percentage as the y-axis).
-rt 5. Prepare a memo (maximum one-page) commenting on the trends you have identified from your
analysis and what those trends suggest related to audit risk assessment for TechWear’s order-tocash
cycle.
/ti, ,\
r, Y*(‘=t
‘”1 \
r\ ft, r,
L.
vl \/ I:
ti\”
k
Analytics mindset case studies – TechWear
O 2016 Ernst & Young Foundation (US). All Rights Reserved.
SCORE No.02315-161US
ba’5
lL-“*-
7uo
Ju
(r h€
‘bt( ‘(J {rT””
