Wednesday, December 21, 2011

Merry Christmas and a Happy New Year !



Have a Joyful Holiday Season, everyone ! See you in class next year !

Photo Source: http://trip.worldtravellist.com/2011/12/ten-merry-places-to-spend-christmas-other-than-home/

Session 7: Restaurant Management Systems

Restaurant Management System Demos from MaitredPOS:

MaitreD Restaurant Management System (click on "MaitreD' Flash Demo" under "Other Resources")

Case Study 1.



Chester Racecourse UK
This case study looks at how Chester Racecourse is using an electronic point-of-sale system for its restaurants, corporate and public catering facilities. It also looks at how Chester Racecourse is using software to manage inventory, procurement and stock control.

Links to companies mentioned in the case study:

  1. Chester Racecourse UK (click on "Restaurants")
  2. Infogenesis POS by Agilysis
  3. Eatec Solutions by Agilysis
  4. Restaurant Management Systems available via SaaS


Case Study 2: Hong Kong Jockey Club


HKJC Infrasys Case Study

Saturday, December 10, 2011

Exercise 5-4: Sensitivity Analysis - Goal Seek (with audio)

Exercise 5-4: Sensitivity Analysis - Goal Seek



Exercise 5-3: Sensitivity Analysis - Two Variable Data Table (with audio)

Sensitivity Analysis - Two Variable Data Table



Exercise 5-2. Sensitivity Analysis - One Variable Data Table (with audio)

Exercise 5-2. Sensitivity Analysis - One Variable Data Table



Exercise 5-1: Sensitivity Analysis - Spreadsheet Model Building

Exercise 5-1. Sensitivity Analysis - Building the Spreadsheet Model (with audio)



Exercise 4-6: Create a Pivot Table - Payment Method Analysis (with audio)

Create a Pivot Table - Payment Method Analysis

Exercise 4-5: Create a PivotChart (with audio)

Create a PivotChart based on the Registration Analysis by Workshop and Industry Pivot Table



Exercise 4-4: Create a Pivot Table - Attendees by Country (with audio)

Attendees by Country Pivot Table Report with Country as Report Filter



Exercise 4-3. Pivot Table Exercise Video

Create the Workshop Attendance Analysis Pivot Table Report (with audio)

Exercise 4-2. Pivot Table Exercise Video

Building the Registration Analysis by Workshop and Industry Pivot Table Report (with audio)

Exercise 4-1. Pivot Table Exercise Video

Building the Attendee Analysis by Industry Report (with audio)