Managerial report for business statistics

Managerial Report BUSI 2305

[Company name] [Document title] [Document subtitle] Name [Date]

Introduction

This report analyzes and tracks the data given in monthly sales reports from the local restaurant, ABC, located in ABC, TX, United States. Address is XYZ. The aforementioned sales reports compare the periods of the month (31 days) of January 2019 and January 2020. The establishment offers seafood-based food choices, most of which is customized according to menu options and customer preference. The following factors are to be extracted from collected data to be analyzed for this report. They include payments, discounts, and category sales. The purpose is to summarize and compare the statistical results of these sales reports and construct appropriate responses to company performance.

Descriptive Data Analysis (Month of January 2020)

For the monthly report of January 2019, measures of central tendency and frequency are examined for three variables. For the payments, the mean payment transaction is $20.36. For subcategories, the most frequently-occurring payment transaction occurred by credit card, with 1255 transactions constituting 89% of total payments, and with an average of $20.87 per payment. The least-occurring transaction was by gift card, with 4 transactions and an average of $13.08 per payment.

For the discounts, the mean discount applied was $4.18, with a mode discount of $1.55 and a median discount of $4.18. The most frequently applied discount is the “10% off sale” at 24 applied discounts or 26% of total applied discounts, with the least occurring discounts occurring only at 1 for several subcategories.

For the category sales, the mean sales amount was $9.42 per sale, with a median sale of $11.44, and mode of $11.43. The most frequently occurring sale, for subcategories occurred with uncategorized sales, at 1871 sales or 70% of all category sales. In contrast the least frequent sale was “extra protein” at 14 sales.

Descriptive Data Analysis (Month of January 2019)

For the monthly report of January 2020, descriptive statistics are also examined. For payments for this period was $19.66. For frequency, the largest occurring payment transaction (by credit card) occurred at 762 transactions or 90% of all payments. In contrast, the least occurring payment took place at only 86 times, or 10% of payments made. Sub categorically, the means for these two frequencies, “Card” and “Cash” have average payments of $20.11 and $15.67 respectively.

Discounts for this period experienced a mean discount of $3.28, and had a median applied discount of $2.38. The mode discount also measured at $2.38. For frequency, the largest frequently occurring discount lies at 16 applications for “Rewards 10”, or 30% of all discounts. Meanwhile the least frequently occurring discount applied lies at 1 application among many subcategories of discount types.

Finally, category sales, we calculated at a mean or average sale of $9.09. The median price for a category sale was measured at $11.05. Additionally, the mode sale was calculated and observed at $11.06. Measures of frequency has shown that the most frequently occurring category sale was measured at 1179 sales, or 73% of the total amount of category sales. The least frequent type of sale transacted was measured at only 15 sales for the sub category “extra protein”.

Analysis, Comparing of Results

Looking at the extrapolated data from the following sales reports for the restaurant between the two time periods of January for the consecutive years, it is observed that data for the period of January 2020 experienced stronger performance in overall sales for the company. In all three variables that were observed, calculations have shown better sales performance and financial health, with greater average payments and sales transactions from customers made to goods and services.

For payments made, despite the average transaction only being marginally larger than January of 2019, total payments made for January 2020 was nearly double the total payments accrued in month of last year.

Category Sales for the 2020 month also showed total sales figures that nearly doubled that of the figures accrued during January of 2019. This observation follows the data shown in payments from the sales reports, and once more shows a higher number of customers being attracted to the establishment. As much of the food options are custom-ordered, customers are shown frequently to choose the sub category “uncategorized” as the majority of sales, consistently, in both periods

Additionally, for discounts applied, more discounts were applied to customer payments in the 2020 month, and the mean cost of discounts applied to goods and services per transaction was nearly one dollar more. This would initially show a greater potential loss of cash flow due to items not being paid at full price, as shown to any potential business partner or owner. However, due to the significantly high volume if payments and sales, the average payment made for the company’s services will still contribute a reasonable profit, as shown with comparison between the two periods.

Due to the information presented, it is therefore reasonable to infer, from a general managerial perspective, that consistent business practices and exposure will maintain increasing growth in the restaurant’s revenue, and not sustain losses in future months. This of course is also dependent on other unforeseen factors, such as the economy of the nation affecting wages, taxes, and social behavior of potential consumers with budgets to maintain. Additionally, the utilizing different sales events and offering new products may draw new customers to the establishment. As such, it is important that a company such as this one in the restaurant industry maintain appealing foods and service to retain customer loyalty and build up an increasingly positive reputation.

Sales for January of 2019

Explain Graph-1 in few lines:

Source:….

Sales for January 2020

Source:

References

Sales for January of 2020

Explain Graph-2 in few lines:

Catgory Sales

Drinks Xtra T & S xtra protein preset bowls uncategorized 332.56 118.5 54.5 2948.3 21393.15

Sales Subcategories

Sales amount ($)

Payments

cash card gift card other 2344.17 26195.49 52.32 0

Payment Types

Payment Amount ($)

Discounts Applied

$2 off 10% off entire sale 25% off :) Discount 15% Employee FishBowl Football 2$ off next visit 15% off next visit Honda Mil/LE/Fire 1 Free Large 1 free regular rewards 10 rewards 15 rewards 20 verizon 2 37.299999999999997 9.83 4.0599999999999996 5.64 33.36 2.0299999999999998 0.38 6 23.66 5.25 33.729999999999997 27.1 150.15 2.76 9.0299999999999994 11.55 7.74

Discount Type

Discount amount ($)

Payments

cash card gift card other 1347.53 15320.44 0 0

Payment Types

paymetns amount ($)

Category Sales

Combos Drinks Extra T & S Xtra Protein Preset Bowl uncategorized 264.5 126.12 67 57 1145.4000000000001 13037.45

Sale Subcategories

Sales amount ($)

Discounts applied

25% 25% off two bowls 50% BOGO Danny Coupon Poke Employee Grand Opening Rewards Rewards 10 Rewards 15 Vape Shop 3.36 23.01 6.72 4.9800000000000004 14.64 40.78 8.07 5.38 38.07 25.45 3.44

Discount Types

Discount amount ($)

(ABC, 2019)