Restaurant E-Management System Salesforce Project

Restaurant E-management Workflow:

  1. A customer looks for the menu on the mobile device available on the table.
  2. The customer selects the menu items and confirms them.
  3. Customers can view the orders in the cart.
  4. The order will be displayed on the devices available in the kitchen.
  5. The customer has the option to modify the ordered item unless the chef starts preparing the item.
  6. The item will be marked as Pending until the chef starts cooking it.
  7. The chef starts cooking the food and marks the status as Preparing.
  8. Chefs prepare the food item and change the status to Ready.
  9. The servers will pick up the food from the counter and serves it at the appropriate table.
  10. Customers can order the food many times. The above process will be repeated.
  11. Also, customers can view the bill till now before generating the actual bill.
  12. When the customer finishes, he selects generate bill option and pays the bill.
  13. Customers will also have the option to fill in the survey.

System users

  1. Customer
  2. Chef
  3. Waiter (Server)
  4. Restaurant Manager
  5. Inventory Manager

Functionalities of the users

Customer:

The customer enters a restaurant. The manager will look for empty tables with a specified number of people. The table will be allocated to the customer. The customer will have a device on the table through which he can order the food items.

Customers can browse through the menu. He can choose categories from appetizers, entrees, and desserts. There is also a sub-category for vegetarian non-vegetarian and vegan. Menu items are classified on these criteria.

Main menu page where a user can browse through different categories. The default section is the Appetizers as highlighted above.

Customers can browse through another section. Here the customer is in the Entrée section.

Customers can select the menu items and use the ‘+’ & ‘-’ signs to increase/decrease quantity respectively. Add those to the cart using the ‘Add’ option. The order of items will be the order in which they are added to the cart on the right.

Clicking on Add button adds the items to the cart on the right side.

Customers can see the top-selling items in the restaurant in each of the sections with a star mark on them.

Customers can view the bill and cart on the right side of the screen. It will contain a list of items selected by the customer. Once the customer clicks on ‘Place Order’ the items get added to the ‘Billed Items’ section. Customers can add or remove items from the cart using the ‘Edit Order’ button. Customers can also clear the entire cart by using the ‘Reset Cart’ option.

Items are added to the cart and then placed order items are under the Billed Items section.

Customers can view the total bill for the ordered items. When the customer clicks the ‘Place Order’ button, the items from the cart are moved to the ‘Billed Items’ section. These confirmed items are now displayed on the chef’s screen for processing.

Chef’s screen as and when the order is placed by the customer.

The customer can edit these items before the chef clicks the ‘Accept’ button. Once the chef accepts the items for preparation, the customer cannot update those items. The tax will be added to the total bill and the new amount to be paid will be displayed at the end. Edit Modal allows to increase/decrease the quantity of the items or delete the items from the order.

The Edit modal opens up when the user clicks on the ‘Edit Items’ button.

Customers can see the delivery time for the first item to be served.

Before paying the bill, the customer can provide a tip. Customers can also provide feedback on the service and food.

Bill Page shows the amount to be paid, adds a tip, and allows the user to pay the amount.

Feedback form available to the customer.

Chef:

When the Chef logs in, he first selects the number of chefs in the kitchen at present. This will be used for the delivery estimation of an item.

The landing page of the chef

When the customer clicks the ‘Place Order button, the chef’s screen will get the list of items to be prepared. The order of items will be the order in which the order is placed. The chef’s screen displays the queue of items that were ordered. The chef accepts the order by clicking the ‘Accept’ button. From this moment, the customer cannot edit the accepted items.

Chef’s screen with some orders that have been accepted and are being prepared. Some orders waiting to be accepted.

When the item is cooked, he will update the item to a Ready state. At this time, this item will be added to the waiter’s screen. The chef can view the list of total items ordered in that restaurant.

Waiter:

This screen will be accessible to the waiter so that, she/he can change the status from occupied to ready once she/he finishes cleaning the table after the customer leaves. Also, she/he will be able to select the menu which is displayed to the next visiting customer.

Chef’s screen with some orders that have been accepted and are being prepared. Some orders waiting to be accepted.

This screen will display the list of items prepared by the chef and which are ready for pickup. Once the waiter picks up the item and serves it at the table, he/she will change the status of the item to Delivered using the ‘Delivered’ button in the Edit modal. Then the items will have the delivered e-stamp on them.

Waiter’s screen with the list of ready orders.

Items have the Delivered e-stamp on the items that have been delivered.

Once the customer finishes ordering, the waiter can mark the order as complete.

In the end, the waiter can proceed with payment from the customer and will mark the order as paid.

Front Desk Manager:

She/he can update the status of the tables in the restaurant. Also, she/he can assign an appropriate table to the customers depending on the availability and number of guests.

The table status lists for the restaurant

Restaurant Manager:

She/he can add, delete or modify the information about the food items. Also, she/he can modify the information about the restaurant.

The restaurant Manager can view the weekly, monthly and annual sales for his/her outlet using the filters in the report section. This can be done using the Reports section where we have several reports to show the statistics pictorially.

Sales reports are visible to the people at the managerial level.

She/he can view the current inventory position of the restaurant. Also, the restaurant manager can update the inventory items. She/he can view the forecast of items in the inventory that are to be replenished.

Inventory chart for a quick update on the items in the repository.

Higher Manager:

She/he can view restaurant-wise weekly, monthly, quarterly and annual sales of the restaurant. Also, she/he can view the most popular items, average bills, and least popular items for further actions in menu management across the chain as well as per restaurant.

Screens

Table Screen

This is the first screen. The restaurant manager gets the list of table details with seats available and status in his restaurant. The guests will be allocated an appropriate table. When the table is selected, the status is changed to Occupied.

Controller Name: TableController

Page Name: TestTables

Menu Screen

This page displays the menu items. On the upper side, special offers are displayed. Menus are divided into 3 sections namely appetizers, entrees, and desserts. In each section, users can select vegetarian, non-vegetarian, and vegan items. By clicking on the item, the customer can view the food details. By pressing Add button, the item will be added to the cart.

The cart is displayed on the right side. The items in the cart can be modified before the place order button is clicked. The customer can see the total amount to be paid along with the taxes. When the item is delivered, the waiter will mark the item as delivered.

Controller Name: MenuItemListController

Page Name: Menu

Bill Screen

This page gets enabled when all the items in the order are delivered. This page will display the name, quantity, and amount for each item. The total will be displayed below it. Bill Page also has the option to provide tips. This will change the total amount. By clicking on the done button, the order is completed and the order will be closed.

If the customer wants to order more items, then the Back to cart button needs to be clicked. This will take the customer to the menu page.

At the end of the page, customers can give feedback;

Controller Name: Bill

Page Name: Bill

Chef Screen

This page displays the list of the ordered items by customers. The chef will click Accept button when he starts cooking the ordered item. After this moment, the customer cannot modify the item count that the chef has started preparing. When the item is ready, the chef will click on the Ready button. This will notify the waiter screen that the item is prepared. Now the waiter will serve the particular item.

Controller Name: ChefListController

Page Name: Chef_Pending_Orders

Waiter Screen

This page displays the list of food items that are ready to deliver. The waiter will pick up the items and deliver them to the table number specified with the item. He will click on the Pickup button when he takes the item.

Controller Name: WaiterListController

Page Name: WaiterPendingOrders

Shelter Homes and Donations Management Platform Project using Salesforce CRM Software

Business Background:

This Salesforce CRM Project is an Integrated Donations Management System Platform, which brings together Shelter Homes and their donors to a single platform.

The application makes it easier for shelter homes to access a large base of donors and provides the donors with a convenient way to identify the requirements of social establishments around them.

The application allows shelter homes and donors to create requests or pledges, respectively, and then view these entries and respond accordingly.

This provides an effective medium to match the requirements at the shelter homes to availability with the donors in the community.

We essentially aim to bring a market-place-based model to donations management at shelter homes.

Project Scope:

We have identified several gaps in the way shelter homes Donations Management System to collect donations:

1.     Difficulty in communicating immediate requirements to the society

2.     Time taken to request, and receive donations can be too high

3.     Donations may not reach where they are required the most immediately

4.     Donors may find it difficult to find an organization that could use their help

5.     Lack of a common platform to enable engagement between the shelter homes and the society

The application aims to address each of these issues systematically. Specific functionalities from within the Salesforce CRM have been utilized to build a system that caters to the requirements of both, donor and shelter home perspectives.

The Donations Management application needs to adhere to the following project goals:

1.     Users are able to log in as donors/shelter homes using web integration. Donors can register as either individuals or organizations

2.     Users are able to create pledges/requests for a specific category using web integration.

3.     Users are able to create pledges/requests in response to specific requests/pledges using web integration

4.     Allow the creation of campaigns to facilitate donations for a specific purpose (for ex, preparation for upcoming storm warnings, etc.)

5. System-generated reports help match pledges/requests based on selected categories, and their status is updated as such

6.     Analytical reports on activities on the platform

7.     Scheduled report provides frequent updates on open requests/pledges.

Limitations:

In the scenario where users do not provide an existing pledge/request name, the matching needs to be done by the administrator. This causes a manual intervention and may cause delays in the matching process

Reports from the application provide data on requests and pledges that are currently open. This information needs to be hosted and updated online separately. There is no convenient way to integrate this into the application

Future Scope:

Several functionalities can be added to the Donations Management application to enhance user experience, and achieve greater integration:

  • Integration with Payment Gateway to enable cash donations
  • Web API to integrate with business websites, helping create a corporate partnership
  • Mobile application
  • Automated alerts on matching pledges and alerts
  • Greater integration with the transportation process, once pledges and requests are matched
  • Categorize Donor organizations based on business type for focused engagement
  • Implement Salesforce Communities to promote greater engagement
  • Access to the Blackbaud Community
  • Include a wider range of non-profit organizations

Infrastructure:

  • Considering the upfront cost of hardware, it is better to go for cloud-based service than on-premise. Cloud-based services are scalable as per requirement.
  • Software as a Service is preferred over Platform as a Service as the former needs licensing cost, and time software updates.
  • A cloud-based Customer Relationship Management (CRM) service will be more beneficial as it reduces development and deployment time.
  • Salesforce applications have the feature of API integration that can be used later in other applications.
  • The Analytics service to create dashboards will help to get insights into different transactions

Business Requirement:

The below points describe the overall business objective the application aims to fulfill:

  • Shelter Homes and Donors can register on a common platform
  • Pledges and Requests can be created via web integration by donors and shelter homes respectively
  • Ability to create campaigns to aggregate donations and run separate donation programs for donors or shelter home
  • Pledges and Requests can be viewed and responded to. For example, donors can create pledges to fulfill a particular existing requirement
  • Reports providing regular updates on open pledges/requests
  • Perform analysis on platform usage, and identify major trends (top donors, etc.)

Process Flow:

  • The user enters the ‘Welcome Page’ and chooses Member Type as ‘Donor’ or ‘Shelter Home’
  • User redirected to log in page for Donor or Shelter Home as per selection in the first step. New users can navigate to the Registration Page and complete registration. Donors can register either as an organization or an individual
  • Donors are immediately notified by email post account registration. Shelter Homes are verified for authenticity, until then, the Shelter Home account status is ‘Pending’
  • Admin verifies the Shelter Home registration and updates status to ‘Approved’. Shelter Home contact is notified via email, and can now start using the account
  • User creates new Pledge / Request. A Request / Pledge name can be provided on the Pledge / Request, respectively, using a Lookup field provided in the creation form
  • A new request/pledge is created, and the status is updated as ‘Matched’, if Pledge Name / Request Name is provided by the user
  • A new request/pledge is created, and the status is updated as ‘Open’ if Pledge Name / Request Name is not provided by the user
  • Matches with new pledges/requests are identified based on reports generated in the application
  • The status of matched pledges/requests is updated by the system admin with Salesforce access. The corresponding Donor / Shelter Home is notified of the change in status of their pledge/request
  • The report is generated with the latest updated data on open requests/pledges
  • Use Salesforce Reporting functionalities to identify Top Donors by the number of pledges, Top shelters by the number of requests, Top categories for which requests are created to enable targeted campaigns, and Shelter Homes with a high amount of open requests, to enable personalized assistance if required. These reports are generated and described in the ‘Reporting and Dashboards’ section

Management Dashboards

Apart from these transactional reports, there are various Management Reports, arranged into Dashboards, to provide a summary of the application.

Dashboard 1: Overview

The Overview Dashboard contains various reports providing important metrics regarding application usage.

The reports help us analyze:

1.     Top donors based on the number of pledges created

2.     Top shelter homes based on the number of requests created

3.     Number of Shelter Homes with pending verification vs number of verified Shelter Homes

4.     Distribution of donors by Individual and Organization Donors

Such details are important for Customer Management and Donor Management. For example, top Donors can be identified and personally acknowledged, which will help retain them on the platform.

Dashboard 2: Pledge Overview

This dashboard provides a brief summary of pledges logged in the system. The above reports provide important data including:

1.     Number of Matched vs Open Pledges

2.     Trend of Pledges created in the current month

3.     Categories Distribution for Open Pledges

These reports help identify trends of the pledges created. A systematic decrease in pledges can be detected and followed up by the management.

Dashboard 3: Request Overview

The dashboard provides a detailed summary of the Requests created in the system. The reports provide information regarding:

1.       Category distribution of Open Requests

2.     Number of Matched vs Open Requests

3.     Number of Open Requests by Shelter Home

4.     Number of Open Requests for each Category

These reports help us analyze which categories are more widely requested by shelter homes. This can help the platform organize targeted campaigns to satisfy the requirements.