MLB expansion, looking for four youngest rookies to go to MLB

https://www.baseball-reference.com/teams/LAA/2021-pitching.shtml

Sample business report. A sample business report is provided at the end of the document. The business report should include the following:

a. Sample business report. The report body is the result of your SQL query. Format results in a professional business report format. Add a title, column headings, and some key selection criteria to the report.

b. A short narrative explaining how this report can be used to facilitate organizational operations or decision-making.

C. The SQL query that will return the information displayed in the report. You can use multiple SQL queries to generate information in one report.

d. Describes sample data for tables generated in logging reports.

e. Description of Data Source – Briefly explain the operational activity or external provider that generated the recorded data.

An example business report

Sample Business Report

Table 1. Example of Monthly Vendor Activity Summary Report

Vendor Activity Summary

For 1/1/2011 thru 1/31/2011

Vendor

# of Invoices

Total Amount

Average Invoice Amount

Unpaid Amount

American Standard Plumbing

3

$168,650.00

$56,216.67

$19,850.00

El’s Pipe Supply

1

$16,000.00

$16,000.00

$16,000.00

Grainger Welding Equipment

1

$1,000.00

$1,000.00

$1,000.00

Horizon Tape

1

$2,582.50

$2,582.50

$0.00

Kitchen Sink Co.

2

$35,000.00

$17,500.00

$13,000.00

Office Max

2

$980.00

$490.00

$0.00

Skil Tools

2

$7,000.00

$3,500.00

$0.00

Totals

12

$231,212.50

$19,267.71

$49,850.00

A short narrative

The Vendor Activity summary is run at least monthly as part of the purchasing manager’s oversight activities. This manager is charged with ensuring that payments are appropriate and with optimizing purchasing efficiency by monitoring vendor activity. This oversight process begins by understanding the flow of purchases.

The report identifies total purchases (to identify key suppliers), number and average amount of invoices, and unpaid amounts to assess accounts payable. This information can be important for a variety of activities including:

· looking for price negotiation opportunities to reduce cost, e.g., identify the vendor from whom many purchases are made.

· identifying new or unusual patterns of activity that might reflect fraud or a need for oversight. For example, the purchasing manager can identify vendors with uncommon average invoice amounts and investigate those invoices.

SQL queries (You may need one or multiple queries to generate a business report)

The heading for this report includes a title and a date range. The regular monthly version uses the first and last day of the month, but reports can also be generated for other time frames. These dates are then embedded in the queries that produce the report.

The rows shown in the body of the report are extracted using this query:

SELECT AP_Vendors.Vendor_Name, Count(Invoices.Invoice_ID) AS CountOfInvoice_ID, Sum(Invoices.Inv_Ttl_Amt) AS SumOfInv_Ttl_Amt, Avg(Invoices.Inv_Ttl_Amt) AS AvgOfInv_Ttl_Amt, Sum([Inv_Ttl_Amt]-[Invoices].[Paid_Amt]) AS Amt_Unpaid

FROM AP_Vendors, Invoices

WHERE AP_Vendors.Vendor_ID = Invoices.Vendor_ID And Invoices.Entered_Date >=#1/1/2011# And Invoices.Entered_Date <=#1/31/2011#

GROUP BY AP_Vendors.Vendor_Name;

ORDER BY AP_Vendors.Vendor_Name;

The totals can be generated using this query:

SELECT Count(Invoices.Invoice_ID) AS CountOfInvoice_ID, Sum(Invoices.Inv_Ttl_Amt) AS SumOfInv_Ttl_Amt, Avg(Invoices.Inv_Ttl_Amt) AS AvgOfInv_Ttl_Amt, Sum([Inv_Ttl_Amt]-[Invoices].[Paid_Amt]) AS Amt_Unpaid

FROM Invoices

WHERE (((Invoices.Entered_Date)>=#1/1/2011# And (Invoices.Entered_Date)<=#1/31/2011#));

Example data for the tables used to generate the documented report

This report uses data from two tables. The AP_Vendors Table and the Invoices table.

Table 2. Example data from the AP_Vendors Table

AP_Vendors

Vendor_ID

Vendor_Name

Annual_Limit

Open_Payables

YTD_Total

Contact_Name

10001

SilphCo. Paper

$2,800

$250

$1,300

Steve Wilson

10002

El’s Pipe Supply

$920,000

$16,000

$112,000

Rainn Novak

10003

Home Depot

$20,000

$800

$62,550

Angela Nunez

10013

Kinkos

$4,000

$23

$980

Creed Robinson

10014

Ricks Truck Rental

$22,000

$0

$18,000

Craig Liberstein

10015

Mill Supply

$500,000

$0

$0

John Calven

The AP_Vendors table lists vendors who are paid using the AP system. Its primary key is Vendor_ID. It is connected to a number of tables that have foreign key relationships that point to the Vendor_ID, as shown in Figure 1.

Table 3. Example data from the Invoices Table

Invoices