餐饮数据系统

1、SALES TPS WITH MANAGEMENT INFORMATIONSYSTEM IN CELESTIAL COURTYEUNG Hei Ting, Aalia (s147454)NG Hon Lam, Tom (s147664)COM 2001-L12L23_Group 91Company BackgroundBusiness IndustrySheraton Hotels and Resorts is Starwood Hotels and Resorts Worldwides largest and second oldest brand, founded in 1937 in S

2、pringfield, MassachusettsSheraton Hong Kong Hotel & Towers which opened in 1974 at Tsim Sha Tsui is under Sheraton Hotels and Resorts.2Fine Chinese cuisine is elevated to new heights at the Sheraton Hong Kongs Sheraton Hong Kongs Celestial CourtCelestial Court.The Celestial Court Chinese Restaur

3、ant features authentic Chinese cuisine, award-winning dim sum, and a wide selection of Chinese teas. Tastefully decorated with warm burlwood panels and raw silk wall coverings, Celestial Court exemplifies Oriental style.3 3MARKETS THAT THE COMPANY SERVES Hong Kong Local FamilyForeign VisitorsRich El

4、der Wedding4 4Companys URLhttp:/ Transaction Processing System Definition General Purpose Purpose in Celestial Court Specializes for recoding its sales order, print receipt and prepare daily sales report for each branches6Characteristics of the sales TPS in Celestial Court78 Real time processing Rec

5、ord order Send data to kitchen Search and get the item price from database Calculate the total amount and discount (for members) Save the transaction record into database Prepare a temporary receipt Batch processing At the end of the day, print daily total and get transaction summary. End of week pr

6、int out transaction report.Characteristics of the sales TPS in Celestial Court9 Output : Receipts, Daily sales report, Weekly sales reportItemsUnit priceUnit soldTotal salesSteamed Pork Dumplings, Shrimp, Crab Roe蟹籽北菇燒賣7812936Steamed Pork Dumplings, Morel Mushrooms羊肚菌小籠包68231564Stewed Whole Beef Spa

7、re Rib, White Porcini Mushrooms美味牛肝菌牛肋骨56863408Roasted suckling pig stuffed with black truffle, pearl barley, glutinous rice, ham and wild mushrooms黑松露薏米燒釀乳豬1388227761011Database Transaction number Date and time Item number Staff ID Price Service fee & Discounts Customers information (for member

8、s or hotel guest) Payment method12CHARACTERISTICS OF THE SALES TPS IN CELESTIAL COURTExamples of how the sales TPS works in Celestial Court Customer Settle downStaff insert data to the sales TPSCustomer place orderStaff insert data to the sales TPSTPS retrieve from Database(price per item/a temporar

9、y receipt ready) Kitchen receive dataDishes deliver to tablesCustomer pay the billTPS print out receiptTPS trigger to make paymentTPS print out billTPS prepare sales report(Pass to MIS system and continue the process)13Sales DataSales TPSReceiptSales ReportSales DatabaseI am UserManagement Informati

10、on SystemSManagement Information System (MIS) is a system that facilitate decision making mainly for management and control of internal resources.SIt can provide reports on companys current performance, based on data from TPS.15Characteristics of the MIS in Celestial Court Input gather large amount

11、of data from Sales TPSe.g., all sales order data in each week, month or season16Characteristics of the MIS in Celestial CourtlProcesslSummarize and compare data. Then, prepare reports on a regular schedule with predefined procedure. lRelatively high capability model to handle the much larger amount

12、of data than TPSCHARACTERISTICS OF THE MIS IN CELESTIAL COURTvOutput Analysis/Management reports e.g., Half Year Management Report19Half YearHalf Year Management Management Report (First Report (First half 2015 half 2015) )ItemsActual SalesPlannedActual VS PlannedDim Sum2,010,0001,800,0001.116666667

13、Seafood2,904,8643,000,0000.968288Meat (poultry, Red Meat)3,127,6803,000,0001.04256Soups1,238,6281,200,0001.03219Mushrooms and Vegetable2,298,2402,100,0001.0944Beverage (wine, soft drinks & tea)1,394,4001,500,0000.9296TotalTotal12,973,81212,973,81212,600,00012,600,0001.0296676191.0296676190501001

14、50200250300350400JanuaryFebruaryMarchAprilMayJune0100200300400500JanuaryFebruaryMarchAprilMayJuneNumber of Customers per dayPer capita consumption Sales DataSales TPSReceiptSales ReportSales DatabaseI am User too!Analysis/ Management ReportMISManagerFeedback AFeedback BFeedback CFlow Diagram of Cele

15、stial Courts with MISFeedbackFeedback (a)Feedback to MIS: If the system cannot create the desired analysis reports or support the desired changes, the processing needs to be modified. Feedback (b)Feedback to the database: upon changes in business strategies, some changes will need to update the TPSs

16、 database e.g. in Sales TPS: having a new discount for a banks Credit Card. Feedback (c)Feedback to the input of data: when the current input data is not sufficient to produce the required outputs.Benefit to Celestial Court by Information SystemStrengths with only TPS Increase efficiency: By speed u

17、p each transaction Help Chefs to get correct orders Increase volume of transactions: without restriction on where the transaction takes place as long as the system is running normally.Weakness with only TPS Moderately high start-up costs TPS failure may affect the firm seriously and perhaps that of

18、other firms linked to it. It is not directly helpful for making decisionsBenefit to Celestial Court by Information SystemWith MIS: Increase the ability in handling the huge amount of business data facilitate decisions, especially for management: e.g., profitable business or not. helpful for making operational and managerial control: e.g., review the need for cost-cut Chefs know what dishes needs to improve or cancelu Data of separate systems of different functions cannot integrate with each other easily.u It might have system clash when converting data from TPS to a MIS inputu Mi