20 Slides PPT Statistics assignment. Due in 18 hours. No Plagiarism. Detailed Speaker notes is necessary. 

Check the link below for the instruction file.

https://drive.google.com/file/d/1BGQOKL05mtDjlyzvN_XLxr8NVoF_TO-Z/view?usp=sharing

Check the link below for the data file. 

https://drive.google.com/file/d/1tg8FInb_-DZNk-x4ZFpO7Dacp_1W-mYe/view?usp=sharing

Learning Strategies Mini Lesson Rubric

Criteria

Levels of Achievement

Content 70%

Advanced

Proficient

Developing

Not present

Introduction

10 points

Strategy is CLEARLY named and identified and include necessary APA formatted references. Both state and national standards are named and identified. Strategy is an OUTSTANDING match for the listed content standards and age/grade.

9 points

Strategy is named and identified and includes necessary APA formatted references. State standards are identified. Strategies are a GOOD match for the content standards and age/grade.

1 to 8 points

Strategies is named but references are not present AND/OR standards are not identified for this work AND/OR strategies are a poor match with for the listed content strategies OR age/grade.

0 points

Not present.

Descriptions and Implementation Plan

14 to 15 points

Description provides a CLEAR, CONCISE summary of the strategy, its relevance, an explanation of when/how it is used, and WHY it supports learning in the content area. Steps for constructing the strategy are VERY detailed and accurate, but CONCISE. Steps for implementing the strategy are detailed and broken down into logical steps that include all of the components. At least THREE logical ways that strategy could be used beyond what is described OR realistic variations for different learners are included.

13 points

Description provides a summary of the strategy, its relevance, an explanation of when/how it is used, AND why it supports learning in the content area. Steps for constructing the strategy are SOMEWHAT detailed and accurate and FAIRLY concise. Steps for implementing the strategy are SOMEWHAT detailed and broken down into MANAGEABLE steps while remaining fairly concise. At least TWO logical ways that the strategy can be extended beyond what is described OR realistic variations for different learners are listed.

1 to 12 points

Description may not provide a summary of the strategy, its relevance, an explanation of when/how it is used, or why it supports learning in the content area. Steps for preparing and implementing the strategy are not detailed or accurate; they are NOT concise OR are missing some or all of the implementation components. Includes only one or no ways that the strategy could be extended beyond what is listed on the primary page.

0 points

Not present.

Instructional Components

5 points

Handout or teachers guide has VERY clear directions and expectations; visual aids or handouts are very visually appealing; Answer key/rubric CLEARLY shows how the students might respond.

4 points

Handout or teachers guide has SOMEWHAT clear directions and expectations; Answer key/rubric is present but may not show how students might respond.

1 to 3 points

Handout or teachers guide is missing or has UNCLEAR directions; Answer key/rubric MAY BE missing or UNCLEAR.

0 points

Not present.

Text

5 points

Text is VERY GOOD match for the strategy, standards, and age/grade.

4 points

Text is a GOOD match for the strategy, standards, and age/grade.

1 to 3 points

Text is NOT a match for the strategy, standards, and age/grade.

0 points

Text is not present.

Structure 30%

Advanced

Proficient

Developing

Not present

Mechanics

5 points

No spelling, grammar, and/or punctuation errors are present.

4 points

Candidate makes three or fewer spelling, grammar, and/or punctuation errors.

1 to 3 points

Candidate makes more than four spelling, grammar, and/or punctuation errors.

0 points

Organization

5 points

A correctly formatted title page is included. APA formatted citations are provided in a reference page at the conclusion of the paper with references of selected texts as well as any substantiating works. No errors in APA formatting are present.

4 points

A correctly formatted title page is included. APA formatted citations are provided in a reference page at the conclusion of the paper with references of selected texts as well as any substantiating works. Minor errors in APA formatting are present.

1 to 3 points

A title page and references section are included but may have multiple (more than 5) errors throughout OR references and correctly formatted title page are missing from final document.

0 points

APA Formatting

5 points

Final paper is well organized. Headings are used throughout to help with the overall organization and writing is clear and concise.

4 points

Overall arrangement is logical but can be difficult to follow at times. Headings are present throughout to help with overall organization. Writing is mostly clear and concise.

1 to 3 points
Writing lacks clarity or conciseness. Lack of focus makes the presented points hard to understand or your ideas are not fully developed. There are multiple readability and organization issues throughout that make the work difficult to understand.

0 points

Coffee Cafe Night

Student’s Name

Executive Summary
Data set for a restaurant of Cafe Chain
Thorough analysis of data needed
Data analysis to result to:
Exploratory analysis
Menu analysis

The data set provided is for a restaurant of Cafe Chain.
It requires thorough analysis to result to exploratory and menu analysis essential to improve the profitability of the restaurant.
2

Introduction
The Café Chain aims to increase its revenue
Restaurant has no loyalty program
Dataset with customer level information not available
Point of sale data available

The Café Chain aims to have a data analysis to help it increase its revenue.
It is worth noting that the restaurant has no loyalty program to encourage customers to keeping purchasing products from the restaurant.
Additionally, there is no dataset with customer level information to help identify areas that need improvement.
However, the point of sale data is available which is key to streamlining certain tasks in the restaurant for smooth operation.
This information is critical for stocking and labor control.
3

Exploratory Analysis
The restaurant’s grand quantity is 163519 and 32805895.27
Top items in quantity sold are;
Food at 62141
Beverages at 50637
Tobacco at 37384

The total quantity of products sold is 163,519 units at 32805895.57.
The items sold most in quantity are food at 62,141, beverages at 50,637 and tobacco at 37,384.
This means that food is the most consumed followed by beverages and tobacco.
4

Top Items in Quantity Sold

The top items in quantity sold by the restaurant are graphical represented in a pie chart.
Food takes the largest share at 62141 followed by beverages 50637 then tobacco at 37384 and liquor at 10283.
This means that most customers take food and beverages at the restaurant which contribute the largest share in sales.
5
Quantity Sold
Quantity
Food Beverages Tobacco Liquor 62141 50637 37384 10283

Exploratory Analysis (cont’d)
Customer’s lowest demand products are:
Liquor quantity of 1
Liquor and Tpbacco quantity of 63
Merchandise quantity of 551

Some products in the restaurant have low demand.
They include liquor which recorded one sale, liquor and Tpbacco which recorded 63 sales and merchandise which recorded 531 sales.
This information is significant to the restaurant in terms of stocking as well as the decision to scrap off or continue selling these products.
6

Lowest Items in Quantity Sold

This pie chart is a graphical presentation of goods with the lowest quantity sold in the restaurant.
7

Quantity Sold

Liquor Merchandise Liquor & Tpbacco 1 551 63

Restaurant’s Highest Sales
Restaurant’s highest sales are;
Tobacco at 14507075.74
Food at 9952727.98
Beverage at 5510239.1

This indicates the restaurant’s highest sales in amount. Despite tobacco being the third highest in terms of quantity sold, it has the highest sales in monetary terms.
Food then follows and beverages.
8

Highest Total Sales

This is a chart illustrating the highest total sales of products in amount.
9

Total Sales
Food Beverage Tobacco Liquor 5510239.0999989947 9952727.9800000004 14507075.74 2112397.1600000067

Exploratory Analysis (cont’d)

This chart illustrates the total sum of products sold in the restaurant the entire year.
Some products like food, beverages and tobacco attracted relatively high sales while others like liquor and tpbacco performed poorly.
10
Sum of Quantity BEVERAGE FOOD LIQUOR LIQUOR LIQUOR & TPBACCO MERCHANDISE MISC TOBACCO WINES 50637 62141 10283 1 63 551 1385 37384 1074 Sum of Total BEVERAGE FOOD LIQUOR LIQUOR LIQUOR & TPBACCO MERCHANDISE MISC TOBACCO WINES 5510239.0999989947 9952727.9800011441 2112397.1600000067 1050 42561.52 120074.02000000027 206858.12999999989 14507075.740002131 352911.62

Trends in Consumer Behavior
Most purchases are done on the first days of the month
There are few purchases in the middle of the month
Most purchases are done in the afternoon
Some days recorded very minimal sales

Consumer behavior at the restaurant indicates that most purchases are made on the first few days of the month. The first day of every month recorded relatively high sales.
Fewer purchases are made towards and after mid month.
Most purchases are done in the afternoon during most days.
Lastly, minimal sales are recorded in certain days.
11

Recommendations on Consumer Behavior
Ensure adequate stock at the end of every month
Minimize orders in the middle of the month
Offer discounts during low sales seasons

Due to the consumer behavior trend realized, it is good to ensure there is adequate stock at the end of every month due to the increased demand for the restaurant’s products/.
Since there are few sales towards and after mid month, minimizing orders can be a good strategy to manage stock.
Alternatively, the restaurant can offer discounts during the low sales seasons to boost sales.
12

Menu Items
Some menu items that can be taken of are:
Liquor quantity of 1 total 1050
Liquor and tpbacco quantity 63 total 42561.52
This is because the quantity sold is relatively low

The menu contains several items. Some items, especially those with low quantity sales like liquor can be taken off.
There is no need of considering this an item in the menu yet only one unit was sold the entire year.
13

Trends across Months
Most purchases are made from June to December
The purchases are low from January to June
Food and Beverage sales highest across months

The trends of making purchases at the restaurant indicate that most purchases occur from the months of June through to December.
Purchases are low from January to June.
It is worth noting that food and beverages record the highest sales across most months.
14

Menu Analysis
Involves identification of combo meals
Listing of best combo meals from menu items

The menu analysis aims at understanding the menu items of the restaurant in order to list best combinations meals.
This may increase profitability when two products are purchased from the combo menu.
15

Suggestion of Best Combo Meals
Item 1 Item 2
Chicken salami panini Add fries
Lemon iced tea Cookie monster
Italian omelet breakfast Lindt chocolate shake

Some suggestions for best combo meals are;
Chicken salami Panini with fries
Lemon iced tea with cookie monster
Italian omelet breakfast with lindt chocolate shake.
16

Suggestion of Best Combo Meals (cont’d)
Item 1 Item 2
BMT panini Sambuca
Caffe latte Add hazelnut flavor

Other suggestions are;
BMT Panini with Sambuca
Caffe latte with hazelnu
17

Recommendations
Have adequate stock for both peak and low season
Offer discounts to boost sales
Ensure enough staff during peak season
Inclusion of combo meals essential to boost sales

Conclusion
Coffee Café Night can improve sales through discounts
Should reduce stock levels during low season
Should increase stock level during peak season
Items with low quantity sales should be taken off
This helps prevent unnecessary costs

• IMG-0250 (p.1)
• IMG-0251 (p.2)
• IMG-0252 (p.3)
• IMG-0253 (p.4)
• IMG-0254 (p.5)
• IMG-0255 (p.6)
• IMG-0256 (p.7)
• IMG-0257 (p.8)
• IMG-0258 (p.9)
• IMG-0259 (p.10)
• IMG-0260 (p.11)
• IMG-0261 (p.12)
• IMG-0262 (p.13)
• IMG-0263 (p.14)
• IMG-0264 (p.15)
• IMG-0265 (p.16)
• IMG-0266 (p.17)