Instructions

Complete the following steps to update the financials section of the quarterly business report.

Steps

$1$

Review the Data Retrieved

Using the previous$-$quarter data you pulled and cleaned in the previous two tasks, identify insights and calculate the metrics required for the report, namely:

Inventory turnover

Days sales outstanding $($DSO$)$

Actual revenue versus target revenue

Year$-$over$-$year revenue growth

Accounts receivable

Accounts payable

$2$

Update the Quarterly Business Report

From the options below, select the commentary and visualizations that most effectively reflect your insights from the data.

Charts

Accounts Receivable

One stacked bar showing total amounts of receivables due within the next $30$ days. Total due surpasses $$200,000.$

Three stacked bars showing total amounts of receivables due within the next $30,60,$ and $90$ days. Total due within $30$ days is just under $$200,000.$

One stacked bar showing total amounts of receivables due within the next $30$ days. Total due is close to $$400,000.$

Accounts Payable

Nine stacked bars showing ups and downs in accounts payable totals each month. The highest month totals over $$40,000.$

Three stacked bars showing a monthly increase in accounts payable last quarter. The highest month totals close to $$125,000.$

Nine stacked bars showing a consistent monthly increase in accounts payable by month. The highest month totals close to $$119,000.$

Inventory Performance

Horizontal bar chart showing days sales outstanding $($DSO$)$ and inventory turnover for each retailer. Pack Land has the lowest DSO $(0\mathrm{.}6).$

Horizontal bar chart showing days sales outstanding $($DSO$)$ and inventory turnover for each retailer. Clip & Carry has both the lowest DSO $(37)$ and the highest inventory turnover $(11\mathrm{.}9).$

Horizontal bar chart showing days sales outstanding $($DSO$)$ and inventory turnover for each retailer. Clip & Carry has the lowest DSO $(0\mathrm{.}1)$ and Urbanicity has the highest inventory turn $(1\mathrm{.}1).$

Revenue Performance

Horizontal bar chart showing actual revenue versus target and year$-$over$-$year revenue for each retailer. Clip & Carry had the highest revenue compared to its target $(122\%).$

Horizontal bar chart showing actual revenue versus target and year$-$over$-$year revenue for each retailer. Pack Land had the highest revenue compared to its target $(40\mathrm{.}56\%).$

Horizontal bar chart showing actual revenue versus target and year$-$over$-$year revenue for each retailer. Clip & Carry had the highest revenue compared to its target $(22\mathrm{.}54\%).$

Cash Flow

The cash flow table shows positive cash flow of $$634,362\mathrm{.}69$ in the quarter from April to June of $2023$ and $$578,475\mathrm{.}22$ for the same quarter the previous year.

The cash flow table shows positive cash flow of $$665,858\mathrm{.}80$ in the quarter from April to June of $2023$ and $$578,475\mathrm{.}22$ for the same quarter the previous year.

The cash flow table shows positive cash flow of $$574,100\mathrm{.}52$ in the quarter from April to June of $2023$ and $$578,475\mathrm{.}22$ for the same quarter the previous year.

Insights

Days sales outstanding and inventory turnover

Adventure Bags and Clip & Carryboth had the highest DSO $(0\mathrm{.}9$ days$)$ and the lowest Inventory Turn $(0\mathrm{.}01$ turns$)$

Urbanicity has both the highest DSO $(148$ days$)$ and the lowest Inventory Turn $(0\mathrm{.}9$ turns$)$

Urbanicity had both the highest DSO $(0\mathrm{.}41$ days$)$ and the highest Inventory Turn $(1\mathrm{.}1$ turns$)$

Actual revenue vs target revenue

Clip & Carry performed the best against the revenue target at over $22\%$ above

Pack Land performed the best year$-$over$-$year and against target for revenue

Clip & Carry performed the best against the revenue target at over $122\%$ above

Year$-$over$-$year revenue growth, YoY vs target, and inventory turnover

a la mode bags is off both year$-$over$-$year and versus target in revenue and has the second lowest inventory turn

Despite having the best revenue performance versus target, Clip & Carry had the lowest inventory turn

Pack Land performed the best with both the highest revenue versus target and the highest inventory turn