Family Restaurant

INTRODUCTION

Mr. Morgan had approached me, as an HR consultant, for a proposal that can help him to reduce his daily business travel in order to be efficient and cost-effective. As an operation manager of Castle’s Family Restaurant, Jay Morgan travels to restaurants location within the northern of California in order to take care of scheduling, recruiting, hiring, answer employees questions, and as well as HR administrative work.

BUSINESS ASSESSMENT

Currently, they have total 8 restaurants that operate by 340 employees out of that 204 are full-time and 136 part-time. According to Occupational Outlook Handbook, “food service managers are responsible for the daily operations of restaurants and other establishments that prepare and serve food and beverages to customers and ensure that customers are satisfied with their dining experience” (BLS, 2013). Upon assessed, I noticed that Mr. Morgan has been taken care payroll by tracking with Excel spreadsheets and using computer application to print payroll checks. Beside that he manages the business routine at individual location rather than unionize and automates.

IDENTIFIED PROBLEMS

After analyze the situation, I have identified several problems that need to address. Some of the problems are:

• 60% of workforce come from part-time employee

• Excel spreadsheet uses to keep track Payroll and a computer application to print payroll checks

• Mr. Morgan function as operation manager and HR manager for entire restaurant chain

This is clearly a case of lack automate system in which can help by using a Database Management System (DBMS). DBMS is a set of computer programs that combined with a database. With such system would definitely help to manage data electronically and more effectively. At the same time, it also helps in create information that necessary to aid in HR decisions, define data characteristics, organize data scheme that help the integrity of quality and accessibility by restrict access to...