Revenue Analysis - Part I

In Financial Data Analysis, Revenue Analysis speaks primarily to understanding which product(s) generate the most revenues and whether we can identify any aspect of seasonality towards these trends or not.

The importance of this is that we are able to clearly understand which product(s) generate the most revenues and least revenues and this forms the first part of our puzzle.

If a product generates a lot of revenues, but the expenses are greater than the revenues - this isn't a good news story.

However, if the product generates a lot of revenues, and the expenses are well below the revenues - we may have a product which is performing well.

Let's take a look at how Southern Water Corps Revenue Analysis looks like by calculating the Revenues for each of the products and asking ourselves - what does the data tell us?

Let's get started!

Q1. For each of the three Southern Water Corp. Desalination Plants, they produce desalinated water which is then consumed via private, public or residential usage.

Please calculate the monthly revenues for Kootha, Surjek and Jutik and put this in the table below. What trends are you able to pick up?

Please note you will have to reference the account type FINANCIAL ACTUAL in the Data Repository Tab to answer the questions in this Case Study for Revenue Analysis, Expenses Analysis and EBIT Analysis.

Unit Value Driver Profit Centre Profit Centre Element Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14

Total

Kootha Revenue 001 Private Water Hedge Sales W-Transact (0211) - Soft $0.00

Kootha Revenue 001 Private Water Hedge Sales W-Transact (0212) - Hard $0.00

Kootha Revenue 002 Public Sales W-Transact (0211) - Soft $0.00

Kootha Revenue 002 Public Sales W-Transact (0212) - Hard $0.00

Kootha Revenue 003 Residential Sales W-Transact (0211) - Soft $0.00

Surjek Revenue 001 Private Water Hedge Sales W-Transact (0211) - Soft $0.00

Surjek Revenue 001 Private Water Hedge Sales W-Transact (0212) - Hard $0.00

Surjek Revenue 002 Public Sales W-Transact (0211) - Soft $0.00

Surjek Revenue 002 Public Sales W-Transact (0212) - Hard $0.00

Surjek Revenue 003 Residential Sales W-Transact (0211) - Soft $0.00

Jutik Revenue 001 Private Water Hedge Sales W-Transact (0211) - Soft $0.00

Jutik Revenue 001 Private Water Hedge Sales W-Transact (0212) - Hard $0.00

Jutik Revenue 002 Public Sales W-Transact (0211) - Soft $0.00

Jutik Revenue 002 Public Sales W-Transact (0212) - Hard $0.00

Jutik Revenue 003 Residential Sales W-Transact (0211) - Soft $0.00

You've now calculated the Revenues for each of the three desalination plants (Kootha, Surjek and Jutik). This has given you a micro-view of the trends, but let's take a look at the macro-revenue

trends and view all this information aggregated together. Is there any particular trend(s) that we can pick up with respect to which water product(s) have the highest revenue overall?

Q2) Aggregate the Profit Centre(s) for each Unit (i.e. 001 Private Water Hedge Sales, Public Sales, Residential Sales) in the table below and subsequently plot this out

What trends do you note when comparing Kootha, Surjek and Jutik? Is there any plant / product which generates the majority of the revenues?

Unit Value Driver Profit Centre Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14

Total

Kootha Revenue 001 Private Water Hedge Sales $0.00

Kootha Revenue 002 Public Sales $0.00

Kootha Revenue 003 Residential Sales $0.00

Surjek Revenue 001 Private Water Hedge Sales $0.00

Surjek Revenue 002 Public Sales $0.00

Surjek Revenue 003 Residential Sales $0.00

Jutik Revenue 001 Private Water Hedge Sales $0.00

Jutik Revenue 002 Public Sales $0.00

Jutik Revenue 003 Residential Sales $0.00

In the previous exercise we've picked up some trends from observing the monthly revenues trended over a twelve month period.

Specifically, it's clear that one of the Unit(s) generates the majority of the revenues for Southern Water Corp.

However, it's important for us to understand the contribution each customer segment provides from a % standpoint as well as a dollar stand point.

Let's close out the Revenue Analysis with the below question.

Q3. Calculate the overall % contribution of each customer segment for each of the three (3) units listed below and stacked column chart showing the contributions

that each customer segment provides per unit. (You can add a stacked column chart showing either % contribution or Overall $ Contribution as per the below example)

001 Private Water Hedge Sales 002 Public Sales 003 Residential Sales Total

Kootha $0.00

Surjek $0.00

Jutik $0.00

001 Private Water Hedge Sales 002 Public Sales 003 Residential Sales Total

Kootha 0%

Surjek 0%

Jutik 0%

3.12 Match the flowchart or DFD segments in the right column to an appropriate description in the left column.REQUIRED Prepare a program flowchart to help Melanie program this process. 3.12 Match the flowchart or DFD segments in the right column to an appropriate description in the left column. DFDS 1. Statements are prepared and sent to customers from data contained in the accounts receivable data store. 2. A vendor sends a sales invoice to B the accounts payable process. 3. The cash receipt process updates the cash receipts data store. O5. The system prepares a check that is mailed to the E. customer. 6. A report is prepared from data stored on magnetic F. tape. 7. Billing data are entered into a system from a ter- G minal and used to update both the sales order database and the customer database. 8. Data from a paper invoice are used to update the H, cash disbursements file. 9. The system prepares two copies of a sales order; I. one copy is sent to the customer and the other is filed. 10. An accounts receivable aging report is prepared from the accounts receivable master file and the cash receipts master file.Assignment Description Accountants can use data flow diagrams (DFDs) to depict the physical flows of data through an AIS (like document flowcharts), or the logical flow of data through an AIS (like system flowcharts). Like document or system flowcharts, their main objective is to document data flows in an orderly. graphic, and easily-understood format. But DFDs use fewer symbols than either document or system flowcharts, and do not require columns (like document flowcharts). . Discuss how a document flowchart assists each of the following individuals: o A systems analyst. o A systems designer. o A computer programmer. o An auditor. o A data security expert. . Flowcharting is both an art and a science, Guidelines can be used to make better flowcharts. What are these guidelines for document, system, and data flow diagram flowcharts? . What are the four symbols used in data flow diagrams? What does each mean? . Discuss why data flow diagrams are developed in a hierarchy? What are the names of some levels in the hierarchy?Fund - Networking Technologies (ITNW-1325-10Z1) My courses / tate / 21-SP / WAC / 7CYS / 21/5P ITNW-1325-1071 / Unit 1: Bits, Bytes, and IP Addressing / ITNW 132 Use these subnetting specifications to answer the questions below. Number of needed subnets: 10 Network Address: 192.70:10.0. What is the address class? What is the default subnet mask for that class? What is the custom subnet mask for these specifications? What is the total number of subnets created? What is the total number of host addresses created? What is the total number of usable host addresses created? How many bits were borrowed for this subnet scheme? What is the 9th subnet range? to What is the subnet number for the 4th subnet? What is the subnet broadcast address for the 12th subnet What are the assignable addresses for the 10th subnet? to - Subnet Practice (Optional rump to