Applying Power BI Analytics 08-01 (Static) Master Budgeting [LO8-2, LO8-8, LO8-9, LO8-10]

Skip to question

[The following information applies to the questions displayed below.] Abernathy Companys accounting department has finished preparing the master budget for this year. The chief financial officer (CFO) would like your assistance in creating data visualizations that she can use to better explain the master budget to the companys senior management team. More specifically, the CFO would like you to prepare some data visualizations that depict trends in sales, net income, cash collections, current assets, and operating cash flows. Download the Excel file, which you will use to create your Power BI visualizations.

Upload the Excel file into Power BI by doing the following:

Open the Power BI Desktop application.

On the Home ribbon in the Data section, click on the Excel button (you can also click on the Get data button and choose Excel from there).

Choose the Excel file and click Open.On the resulting screen, check the box next to the worksheet provided (Abernathy Company here)

Click Load

Applying Power BI Analytics 08-01 (Static) Part 2

Create a line chart that includes the monthly sales trend analysis from part 1 plus another trend line depicting the monthly cash collections from customers:

Microsoft Power BI enables us to duplicate sheets when we are trying to create a similar visualization. Right-click on the sheet name at the bottom Monthly Sales Trend and choose Duplicate Page.

Double click on this new sheet and rename it Monthly Sales vs. Cash Collections

The only aspect of this visualization that we want to change is to add a line for Total Cash Collections and to change the title:On the right-hand side under Fields do the following:

Ensure that Month ended and Sales boxes are still checked.

Check the box next to Total Cash Collections.

On the right-hand side under Visualizations click on the Format () button:Click on the Title sectionEnsure the Title is clicked On

In the Title text section change the current title and replace it with Monthly Sales vs. Cash Collections

Your visualization should appear as follows:

Required: (Note that for all questions below you may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) 2a. Which of the following statements is true based on the line chart that you just created?

check all that apply 1

The companys peak sales occur in August and its peak cash collections occur in September.unanswered

The companys peak sales occur in September and its peak cash collections occur in August.unanswered

The companys peak sales occur in July and its peak cash collections occur in August.unanswered

The companys peak sales occur in August and its peak cash collections occur in July.unanswered

2b. Which of the following statements is true based on the line chart that you just created? check all that apply 2

The companys monthly sales and cash collections never exceed $250,000.unanswered

The companys monthly sales do peak above $250,000, but its monthly cash collections never exceed $250,000.unanswered

The companys monthly cash collections peak above $250,000, but its monthly sales never exceed $250,000.unanswered

The companys monthly sales and cash collections never drop below $50,000.unanswered

2c. Which of the following statements is true based on the line chart that you just created? check all that apply 3

The companys sales are seasonal, but its cash collections are relatively constant throughout the year.unanswered

The companys cash collections lag its sales.unanswered

The companys sales lag its cash collections.unanswered

The companys cash collections are seasonal, but its sales are relatively constant throughout the year.unanswered