Information Systems And Reporting
Help Questions
CPA Business Analysis and Reporting (BAR) › Information Systems And Reporting
A company needs to analyze five years of sales transaction data, customer demographics, and product categories for ad hoc reporting and trend analysis. Which data storage solution is most appropriate?
An online transaction processing (OLTP) system designed for real-time transaction entry and retrieval
A data warehouse that stores historical data in a structured format optimized for analytical queries
A document management system that stores scanned images of paper sales records
A spreadsheet workbook with linked tabs for each data category
Explanation
A data warehouse is specifically designed to support analytical and reporting workloads over large historical datasets. Its denormalized structure and indexing optimize it for complex queries that join multiple data sources across long time periods. Option A is unsuitable for large-volume, multi-source data requiring relational queries. Option C (OLTP) is optimized for fast, individual transaction processing - not historical analysis or ad hoc queries across large datasets. Option D stores unstructured document images, not structured queryable data.
A data analyst needs to retrieve all customer records from an accounts receivable database where the outstanding balance exceeds $10,000. Which SQL command accomplishes this?
DELETE FROM customers WHERE balance > 10000
UPDATE customers SET balance > 10000
INSERT INTO customers VALUES balance > 10000
SELECT * FROM customers WHERE balance > 10000
Explanation
SELECT is the SQL command for retrieving data. The * retrieves all columns, FROM specifies the table, and WHERE applies the filter condition. This query returns all rows from the customers table where the balance column exceeds 10,000. Option A uses UPDATE, which modifies existing records - it would change data, not retrieve it. Option B uses DELETE, which removes records - a destructive operation. Option D uses INSERT, which adds new records to a table.
A company's dashboard shows: revenue $3,600,000 (target $4,000,000), gross margin 32% (target 42%), customer satisfaction 79/100 (target 85), and on-time delivery 88% (target 95%). Measured by percentage-point variance from target, which KPI shows the largest negative gap?
Gross margin, which is 10 percentage points below target
Revenue, which is $400,000 below target
Customer satisfaction, which is 6 points below target
On-time delivery, which is 7 percentage points below target
Explanation
Percentage-point variances: Gross margin = 32% - 42% = -10pp; On-time delivery = 88% - 95% = -7pp; Customer satisfaction = 79 - 85 = -6 points; Revenue = -$400,000 (not a percentage-point measure). Gross margin shows the largest negative percentage-point gap at -10 points. Option A measures revenue in dollars, not percentage points. Options B and C correctly calculate their gaps but both are smaller than gross margin's -10pp.
Under SEC rules, within how many business days must a public company file a Form 8-K following a triggering event such as entering into a material definitive agreement?
60 calendar days
10 business days
90 calendar days
4 business days
Explanation
The SEC requires Form 8-K to be filed within 4 business days of most triggering events, including material agreements, executive officer changes, and other significant corporate events. The 4-business-day rule ensures that material information is promptly disclosed to investors. Option B (10 days) was the prior rule before the SEC tightened 8-K requirements. Options C and D describe deadlines for annual and quarterly reports, not 8-K filings.
Under ASC 280, which of the following disclosures is required for each reportable segment?
Revenues and a measure of profit or loss for each reportable segment, with total assets disclosed when that amount is regularly provided to the CODM
Customer-level revenue detail for the top 10 customers in each segment
Names and compensation of each segment's senior management team
Specific risks and uncertainties unique to each reportable segment
Explanation
ASC 280 requires disclosure of revenues and a measure of profit or loss for each reportable segment. Total assets must also be disclosed, but only when that amount is included in the measure of segment profit or loss reviewed by the chief operating decision maker (CODM) or is otherwise regularly provided to and used by the CODM to assess segment performance. Additional items - such as depreciation, interest, equity method investments, and capital expenditures - are required when included in segment profit or regularly provided to the CODM. Option A (management compensation) is not a segment disclosure requirement. Option B (customer-level detail) is not required; only entity-wide major customer information for customers exceeding 10% of total revenue is required. Option C (segment-specific risks) is not an ASC 280 requirement.
A company's internal reporting system generates a weekly flash report showing prior-week sales, gross margin, and backlog. This represents which type of management reporting?
External financial reporting prepared in accordance with GAAP
Statutory compliance reporting required by regulatory authorities
Operational dashboard reporting that provides timely data to support short-cycle management decisions
Annual Management Discussion and Analysis (MD&A) reporting
Explanation
An internal weekly flash report is a form of operational management reporting, designed to give managers timely performance data so they can make quick operational decisions - adjusting staffing, expediting orders, or addressing margin issues. Option B is incorrect; internal flash reports are not GAAP-compliant external reports. Option C describes regulatory filings, which are formal compliance documents. Option D describes the annual MD&A, which is a narrative section of the annual report prepared far less frequently.
A company assigns a data steward for each key data domain (customer, financial, and product data). What is the primary role of a data steward?
Performing independent external audits of the company's financial information systems
Ensuring data quality, accuracy, completeness, and consistency within the assigned domain
Writing SQL queries to extract data from operational systems for reporting purposes
Encrypting all company data before it is stored in the primary database
Explanation
A data steward is responsible for the quality and integrity of data within a specific domain. This includes defining data standards, resolving data quality issues, enforcing consistent definitions, and ensuring data meets the needs of users. Option A describes data security responsibilities, typically managed by IT security. Option B describes an analyst or data engineer role. Option D describes an external auditor function, which is independent of the organization's data stewardship structure.
Under Regulation S-K, which of the following topics is required in a public company's Management Discussion and Analysis (MD&A) section of the annual report?
Disclosures of the CEO's personal investment portfolio
Performance evaluations for key employees
Detailed customer contracts and pricing terms for all material customers
Results of operations including discussion of liquidity, capital resources, and known trends or uncertainties affecting future performance
Explanation
MD&A under Regulation S-K requires companies to discuss: results of operations comparing periods; liquidity and capital resources; known trends, demands, commitments, or uncertainties material to future performance; and critical accounting estimates. Option A (personal investment portfolios) is not an MD&A requirement; it may appear in proxy statement disclosures under different rules. Options B and C describe disclosures not required in MD&A.
A company uses descriptive analytics in its financial reporting process. Which of the following best characterizes what descriptive analytics provides?
Predictions about future outcomes based on patterns identified in historical data
Summaries and visualizations of historical data that explain what has already occurred
Real-time alerts when key performance indicators deviate from defined thresholds
Optimization recommendations for the actions management should take
Explanation
Descriptive analytics summarizes historical data to answer the question 'What happened?' through reports, dashboards, and visualizations. Option A describes predictive analytics, which forecasts future outcomes. Option C describes prescriptive analytics, which recommends specific actions. Option D describes a monitoring or alerting function that sits within operational reporting systems, not a type of analytics per se.
A company's sales report shows revenue 8% above budget. However, the data was extracted from a legacy system known to sometimes double-count intercompany transactions. An analyst presents this report to the board without investigating the data quality issue. Which concern is most significant?
The favorable variance confirms data accuracy because errors typically produce unfavorable results
Presenting data from a system with known quality issues without investigating its reliability undermines the report's value and could drive incorrect business decisions
Management reporting is not subject to accuracy requirements
The favorable variance is material and requires immediate external auditor notification
Explanation
Data quality is a prerequisite for reliable decision-making. Presenting results from a system with documented double-counting issues without verification means the board cannot trust whether the favorable variance is real or an artifact of the data error. If intercompany transactions were double-counted, the actual revenue performance may be below budget rather than above it. Option A overstates the disclosure requirement. Option B incorrectly dismisses accuracy requirements. Option D is logically flawed - data errors can produce either favorable or unfavorable-appearing results.