Download - Dennys Fast Foodsff
-
8/10/2019 Dennys Fast Foodsff
1/36
-
8/10/2019 Dennys Fast Foodsff
2/36
Introduction
Our Fast food business is a new addition in the fast food industry with high aims to
facilitate people with healthy foods, which have marvelous health full ingredients. Ourpromise is to give your body healthful products. Due to increasing the needs, wants and
demand of foreign cuisine we decided to launched our fast food centre on a small scale.Its a partnership based business. And we provided self purchasing services and free
home delivery within Faisalabad. Our main focus is on a taste because there are manyFast food doing a business in Faisalabad so we have to compete them by using a best
selling strategy at low price and high quality.
Vision statementOur customers health is our profit
Mission statementAdd up nutritions and taste in peoples life
-
8/10/2019 Dennys Fast Foodsff
3/36
Executive Summary:
This project is about a new business of fast food. It covers the core concepts that are
involved in the development and implementation of this new company. Taking it towardssomething unique and different. This project guides about the company attributes,
boosting its early phases to penetrate through target market identification and segmentingit to different locations, planning for market positioning, effective pricing strategy, how
to promote it to clients through different mediums and sources and most importantly
-
8/10/2019 Dennys Fast Foodsff
4/36
DEPARTMENTS:Following is the working of the departments in Dennysfood point
Reception
Kitchen
Inventory
Management
Working of Departments:
Reception:
Order receiving
Order passing
Serving
Billing
Report generationKitchen:
Receive order
Inventory checking
Preparation of food
ReportInventory:
Receiving/recording
Manage
Deliver
Report
Admin Accounts( payroll section)
Hiring of employees
Allocation of work
Receive reports
Planning
Budgeting
-
8/10/2019 Dennys Fast Foodsff
5/36
ENTITIES
RECEPTION ENTITIES
Customers
Central ordering system Employees
Menus
KITCHEN ENTITIES
Employees
Food&grocery
INVETORY DEPARTMENT
ENTITIES
Food supplies
Employees Furniture&fixtureADMIN DEPARTMENT
ENTITIES
Employees
Reports
-
8/10/2019 Dennys Fast Foodsff
6/36
Common entities &AttributesProduct Product _Id
Name
Description Category
Supplier name
Inventory Inventory id
Name
Description
Cost price
Type
Supplier Supplier_Id
Name
Category
Type
Address
Fax
Email
Customer Customer _Id
Type Gender
Age
Name
Order Order_ Id
Sale price
Payment
Order date
Order number
Quantity
-
8/10/2019 Dennys Fast Foodsff
7/36
-
8/10/2019 Dennys Fast Foodsff
8/36
ERD
ERD
CustomerTypeId
GenderAge
Name
SupplierName
DescriptionIdAddress
Email address
Phone No
OrderProduct id
Order dateOrder number
Sale priceQuantity
EmployeesName
IdCategory
AddressGender
AgeCell no
Id card numberSalary
ProductProduct idDescription
NameType
Supplier name
ReportTypeDate
Id
InventoryInventory id
NameDescription
Cost priceType
DFD
-
8/10/2019 Dennys Fast Foodsff
9/36
Reception
-
8/10/2019 Dennys Fast Foodsff
10/36
FLOOR PANNEL
-
8/10/2019 Dennys Fast Foodsff
11/36
Menu
Start
A B C
Product
A, b, c
Receive order
Stop
Yes
No
Yes
FLOW CHARTS
Order receiving
-
8/10/2019 Dennys Fast Foodsff
12/36
start
Order
processing
Preparation
Dine in
Service to dine in
Check
out
Stop
Service to
reception
Takeaway
Delivery
Service to
delivery
Service to take
away
Yes Yes Yes
No No
Food preparation and service
-
8/10/2019 Dennys Fast Foodsff
13/36
Start
Order Receive
on reception
Order passing
Preparation
Delivery
Stop
Service to
reception
Delivery order
-
8/10/2019 Dennys Fast Foodsff
14/36
Start
Read order
Delivery
Payment
Stop
CashNo
Yes Yes
Payment
-
8/10/2019 Dennys Fast Foodsff
15/36
Start
Available?
Generate purchase order
Purchase order payment process
Inventory update
Inventory account update
Sto
Inventory
requisition
Receive purchase order
Issue inventory
Stock in
No
Yes
Stock in
-
8/10/2019 Dennys Fast Foodsff
16/36
Start
Check items
availability
Chicken Cold
itemsGrocery
Move towards
kitchen
Out of stock
Stop
Reorder
YesYesYes
No No
No
Stock movements
-
8/10/2019 Dennys Fast Foodsff
17/36
Start
Employees list
Check out the days they
worked
Is days less
or equal to
25?
Pay normal wages Pay overtime wages
Stop
YesNo
Payroll
-
8/10/2019 Dennys Fast Foodsff
18/36
REPORTS
USER LOGINChoose a user login name from the dropdown boxSupply the associated password for the selected user.Press enter or click on the submit button
FORGOT PASSWORD SCREENEnter user name from the drop down boxWrite new passwordRetype password.Click on button enter or cancel.
-
8/10/2019 Dennys Fast Foodsff
19/36
TOOLBARAdmin
Click on admin will list down the punch clock, pay roll, expenses and
main search page.Reception
Click on reception will list down the customer report, order report andsale reports.
KitchenClick on kitchen will list down the punch report
InventoryClick on inventory will list down the inventory control report, new stock
received and stock movement.Exit
Click on exit to quit.
BARBack
Click on back for previous menu.
ForwardClick on forward for next screen.
-
8/10/2019 Dennys Fast Foodsff
20/36
MAIN MENUClick on admin will open multi-screens, user account, punch clock, pay roll,
expenses and main search page.Click on reception will open multi-screen customer report, order report andsale reports.Click on kitchen will list open punch reportClick on inventory will open the multi-screen inventory control report, newstock received and stock movement.Click on button to quit.
-
8/10/2019 Dennys Fast Foodsff
21/36
USER ACCOUNTClick on add to open the field then input the dataWrite user nameWrite full nameEnter passwordEnter re-passwordWrite status for drop down boxInput data will generate reportClick edit to modify the dataClick on save to store dataClick on cancel to quit
-
8/10/2019 Dennys Fast Foodsff
22/36
ADMINClick on punch clock button, open punch clock window (data entry, report,search page)Click on payroll button, open payroll window (data entry, report, search page)Click on expense button, open expense window (data entry, report, searchpage)Click on main search button to open a new window (report, search page)Click on quit button to exit
-
8/10/2019 Dennys Fast Foodsff
23/36
PUNCH CLOCKClick on add to enter the dataEnter the specified date, name, time in and time out, no of hoursClick on delete to remove the wrong dataClick on select to print the specified reportEnter the specified data to search fields then click on search buttonClick on quit button to exit
PUNCH CLOCK QUERYSELECT: date. Punch clock, name. Employee, time in. punch clock
Time out. Punch clock, no of hours. Punch clock
FROM: Punch clock, employee
WHERE: date=2-1-2012 or name =adeel or time in =11:00am or time out=07:00pm, No of hours = 8
-
8/10/2019 Dennys Fast Foodsff
24/36
PAY ROLLClick on add to enter the data (employees name, status, total work hour etc)Entered data will generate reportClick on button issue wages to pay the salary (according to total hours)Enter data in search fields (fromto.) to answer the queriesClick on select button to print the specified report
Click on quit button to exit
PAY ROLL QUERYSELECT: employee name. Employee, date. Payroll, normal hours. Payroll, normal
amount. Payroll, overtime hours. payroll, tax. Payroll, tax. Payroll, net
amount. Payroll.FROM: employee, payrollWHERE: employee name= Adeel or Date= 2-1-2012 to 30-1-2012 or normal
hours=240 or normal amount=14400 or over time hours=60 or overtimeamount=4200 or tax=10% or net amount=16740
-
8/10/2019 Dennys Fast Foodsff
25/36
EXPENSES
Click on add button to enter the data ( date, description, amount etc)Click on enter to generate the reportClick on delete to remove wrongly enter dataClick on select to print the specified reportEnter data in specified search fields then click search buttonClick on quit to exit
EXPENSESQUERYSELECT: Date. Expenses, category. Expenses, description. Expenses, Amount.
expenses
FROM: expenses,WHERE: date=1-2-2012 to 1-2-2012 or Category=revenue OR amount=100000
-
8/10/2019 Dennys Fast Foodsff
26/36
MAIN SEARCH PAGESelect the query boxEnter data in specified search fields then click search button
Click on select to print the specified reportClick on quit to exit
MAIN SEARCH PAGEQUERYSELECT: product name. product, category. product
quantity. Product, sales. salesFROME: Product, sales
WHERE: product=chicken burger, category= fast foodQuantity=12000 unit, sales=100000
-
8/10/2019 Dennys Fast Foodsff
27/36
RECEPTIONClick on customer report button, open new window (data entry, report, searchpage)Click on order report button, open new window (data entry, report, searchpage)Click on sales report button, open new window (data entry, report, searchpage)Click on quit button to exit
-
8/10/2019 Dennys Fast Foodsff
28/36
CUSTOMER REPORTClick add button to enter the general data (client no, title, e-mail and name
etc)Click on edit to modify the dataClick on delete to remove the dataClick on save to store the dataClick on membership button to enter the membership card dataClick on add fees button and check the paid boxClick on select button print the specified reportEnter the data in search field and press search buttonClick on quit button to exit
CUSTOMERS QUERYSELECT: Client No.customers, First Name.customers, Last
Name.customers, City.customers, DOB.customersFROM: Customer
WHERE: Client no=1 or last name=sarwar or first name=rabia or phone no=o333-0000000 or city=T.T Sing or DOB=7-12-1990
-
8/10/2019 Dennys Fast Foodsff
29/36
MEMBERSHIP QUERIES
SELECT: customer ID. Customer, client name. membership ,issue date.
membership, expiry date. membership, fee. membership, status.Membership
FROM: customer, membershipWHERE :customer ID= 0000021 OR client name= jahanzaib sultan OR issue
date=1-1-2012 OR expiry date= 30-12-2012 OR fee=500 OR status=paid
ORDER REPORTSelect the specified circle box (Dine in, take away and Delivery)Click on add to enter the data (order no, customer id etc)Click on select to print the specified reportEnter the data in search field and press search buttonClick on quit button to exit
ORDER QUERYSELECT: dine in. order, take away. Order, delivery. Order, order number. Sales,
customer id. Customer, item. Product, status. Order, code. Order,
quantity. order, price.product,amount. salesFROM: order, sales, product
WHERE: order number=34 or id number=0000021 or item=chicken burger orstatus=membership or code=f001 or qty=03 or price=150 or amount=450
-
8/10/2019 Dennys Fast Foodsff
30/36
SALES REPORTSelect the specified circle box (Dine in, take away and Delivery)Click on select to print the specified reportEnter the data in search field and press search buttonClick on quit button to exit
SALES REPORT QUERYSELECT: dine in. order, take away. Order, delivery. Order,
Transact number. Order, date. Sales, time. Sales, item. Product, code.Product, quantity. Order, Amount. sales
FROM: Order, sales, productWHERE: Transact number=1 or date=1-1-2012, time11:00am or item=chicken
burger or code=F001 or quantity=3 or amount=414
-
8/10/2019 Dennys Fast Foodsff
31/36
INVENTORY CONTROLClick on inventory control report button, open new window (data entry, report,search page)Click on new stock receive button, open new window (data entry, report,search page)Click on stock movements button, open new window (data entry, report,search page)Click on quit button to exit
-
8/10/2019 Dennys Fast Foodsff
32/36
INVENTORY CONTROL REPORTClick on add button to enter the data (product name, product code, Qty etc)Click on edit to modify the dataClick on delete to remove wrongly enter dataClick on save to store the dataClick on select to print the specified reportEnter data in specified search fields then click search buttonClick on quit to exit
INVENTORY CONTROLQUERYSELECT: product name. product, product code. Product, category. Froduct, quantity.
orderFROM: product, orderWHERE: product name=chicken pieces or product code=C001 or category=fast
food or Quantity=400
-
8/10/2019 Dennys Fast Foodsff
33/36
NEW STOCK RECEIVEDClick on add button to enter the data (supplier, product name, product code,Qty and cost price etc)Click on edit to modify the dataClick on delete to remove wrongly enter data
Click on save to store the dataClick on quit to exit
NEW STOCK RECEIVED QUERYSELECT: order number. inventory , product name. product ,
quantity. New stock received, code. Product,cost price. New stock received, supplier. Inventory control, ,
FROM: inventory control, new stock received, productWHERE: order number=31 or product name=chicken pieces or quantity=1000,
code=C001or cost price=20000 or supplier=K&NS
-
8/10/2019 Dennys Fast Foodsff
34/36
STOCK MOVEMENTClick on add button to enter the data (date, product name, product code, Qtyfrom ,to etc)Click on select to print the specified reportEnter data in specified search fields then click search button
Click on quit to exit
STOCK MOVEMENT QUERY
SELECT: date.stock movement, product.inventory controll, quantity. inventory,
category.product, code.productFORM: stock movement, inventory control, product
WHERE: date=1-1-2012 or product=chicken burger or category=fasrfood orcode=C001 or quantity=500
-
8/10/2019 Dennys Fast Foodsff
35/36
KITCHENClick on kitchen punch report button, open new window (data entry, report,search page)Click on quit button to exit
-
8/10/2019 Dennys Fast Foodsff
36/36
KITCHEN PUNCH REPORTSelect the specified circle box (Dine in, take away and Delivery)Click on quit button to exit
KITCHEN PUNCH REPORT QUERY
SELECT: dine in. order , takeaway. Order, delivery. Order, order no. sales, date.Sales, item. product, code. Product, quantity. inventory
FROM: order, sales, product, inventoryWHERE: order=37 or date=12-1-2012 or time=1pm or item=chicken burger or
code=F001 or quantity=03