Cost Controls (HOSP 2820)

This course provides students an opportunity to explore the internal controls and information systems used in food and beverage operations. They develop techniques for effective purchasing, receiving and production control, sales control, food and beverage cost calculation and the use of the sales mix. Emphasis is placed upon interpretation of data for effective and profitable decision-making using various tools such as Breakeven Analysis, Menu Engineering and Cost/Margin.

This course is part of the full-time Hospitality Management Diploma Program

Course code: HOSP 2820

Credits: 3.0

Tuition: $0^*

Length: 45.0 hours

Course outline: https://www.vcc.ca/cfm-files/course-outline.cfm?subject=HOSP&number=2820

Schedule†

HOSP 2820 schedule for programs:

HOSP

Course dates and times may vary throughout the term. Select the CRN number below to see a full schedule.

CRN #	Instructor	Dates	Day/Time	Instructor
74922	Lie, Linda	September 9, 2020 to December 14, 2020	Wed \| 9:00 a.m - 10:00 a.m	Lie, Linda
74922 Online Delivery		September 9, 2020 to December 14, 2020	Wed \| 1:00 p.m - 3:00 p.m
74923	Lie, Linda	September 9, 2020 to December 14, 2020	Wed \| 9:00 a.m - 10:00 a.m	Lie, Linda
74923 Online Delivery		September 9, 2020 to December 14, 2020	Wed \| 10:00 a.m - 12:00 p.m
74924	Lie, Linda	September 9, 2020 to December 14, 2020	Wed \| 9:00 a.m - 10:00 a.m	Lie, Linda
74924 Online Delivery		September 9, 2020 to December 14, 2020	Thu \| 8:00 a.m - 10:00 a.m
74925	Lie, Linda	September 9, 2020 to December 14, 2020	Wed \| 9:00 a.m - 10:00 a.m	Lie, Linda
74925 Online Delivery		September 9, 2020 to December 14, 2020	Thu \| 10:00 a.m - 12:00 p.m

query

RESULTSET

query
	BEGIN_TIME_ROUND	DAY_OF_WEEK	END_DATE	END_TIME_ROUND	SIRASGN_PIDM	SSBSECT_CRN	SSBSECT_SEATS_AVAIL	SSBSECT_TERM_CODE	SSBSECT_VOICE_AVAIL	SSBSECT_WAIT_COUNT	SSRBLCK_BLCK_CODE	SSRMEET_BEGIN_TIME	SSRMEET_BLDG_CODE	SSRMEET_END_DATE	SSRMEET_END_TIME	SSRMEET_ROOM_CODE	SSRMEET_SCHD_CODE	SSRMEET_START_DATE	START_DATE	STVSCHD_DESC
1	2020-09-01 09:00:00.0	Wed	09-Dec-2020	2020-09-01 10:00:00.0	50207722	74922	2	202070	N	0	HOSP231	0900	ONLINE	2020-12-09 00:00:00.0	0959	[empty string]	L	2020-09-09 00:00:00.0	09-Sep-2020	Lecture
2	2020-09-01 09:00:00.0	Wed	09-Dec-2020	2020-09-01 10:00:00.0	50207722	74923	2	202070	N	0	HOSP232	0900	ONLINE	2020-12-09 00:00:00.0	0959	[empty string]	L	2020-09-09 00:00:00.0	09-Sep-2020	Lecture
3	2020-09-01 09:00:00.0	Wed	09-Dec-2020	2020-09-01 10:00:00.0	50207722	74924	0	202070	N	0	HOSP233	0900	ONLINE	2020-12-09 00:00:00.0	0959	[empty string]	L	2020-09-09 00:00:00.0	09-Sep-2020	Lecture
4	2020-09-01 09:00:00.0	Wed	09-Dec-2020	2020-09-01 10:00:00.0	50207722	74925	1	202070	N	0	HOSP234	0900	ONLINE	2020-12-09 00:00:00.0	0959	[empty string]	L	2020-09-09 00:00:00.0	09-Sep-2020	Lecture
5	2020-09-01 10:00:00.0	Wed	09-Dec-2020	2020-09-01 12:00:00.0	50207722	74923	2	202070	N	0	HOSP232	1000	ONLINE	2020-12-09 00:00:00.0	1159	[empty string]	L	2020-09-09 00:00:00.0	09-Sep-2020	Lecture
6	2020-09-01 13:00:00.0	Wed	09-Dec-2020	2020-09-01 15:00:00.0	50207722	74922	2	202070	N	0	HOSP231	1300	ONLINE	2020-12-09 00:00:00.0	1459	[empty string]	L	2020-09-09 00:00:00.0	09-Sep-2020	Lecture
7	2020-09-01 08:00:00.0	Thu	10-Dec-2020	2020-09-01 10:00:00.0	50207722	74924	0	202070	N	0	HOSP233	0800	ONLINE	2020-12-10 00:00:00.0	0959	[empty string]	L	2020-09-10 00:00:00.0	10-Sep-2020	Lecture
8	2020-09-01 10:00:00.0	Thu	10-Dec-2020	2020-09-01 12:00:00.0	50207722	74925	1	202070	N	0	HOSP234	1000	ONLINE	2020-12-10 00:00:00.0	1159	[empty string]	L	2020-09-10 00:00:00.0	10-Sep-2020	Lecture
9	2020-09-01 08:00:00.0	Fri	09-Oct-2020	2020-09-01 12:00:00.0	50207722	74922	2	202070	N	0	HOSP231	0800	ONLINE	2020-10-09 00:00:00.0	1159	[empty string]	L	2020-10-09 00:00:00.0	09-Oct-2020	Lecture
10	2020-09-01 08:00:00.0	Fri	13-Nov-2020	2020-09-01 12:00:00.0	50207722	74923	2	202070	N	0	HOSP232	0800	ONLINE	2020-11-13 00:00:00.0	1159	[empty string]	L	2020-11-13 00:00:00.0	13-Nov-2020	Lecture
11	2020-09-01 08:00:00.0	Mon	14-Dec-2020	2020-09-01 10:00:00.0	50207722	74922	2	202070	N	0	HOSP231	0800	ONLINE	2020-12-14 00:00:00.0	0959	[empty string]	L	2020-12-14 00:00:00.0	14-Dec-2020	Lecture
12	2020-09-01 08:00:00.0	Mon	14-Dec-2020	2020-09-01 10:00:00.0	50207722	74923	2	202070	N	0	HOSP232	0800	ONLINE	2020-12-14 00:00:00.0	0959	[empty string]	L	2020-12-14 00:00:00.0	14-Dec-2020	Lecture
13	2020-09-01 08:00:00.0	Mon	14-Dec-2020	2020-09-01 10:00:00.0	50207722	74924	0	202070	N	0	HOSP233	0800	ONLINE	2020-12-14 00:00:00.0	0959	[empty string]	L	2020-12-14 00:00:00.0	14-Dec-2020	Lecture
14	2020-09-01 08:00:00.0	Mon	14-Dec-2020	2020-09-01 10:00:00.0	50207722	74925	1	202070	N	0	HOSP234	0800	ONLINE	2020-12-14 00:00:00.0	0959	[empty string]	L	2020-12-14 00:00:00.0	14-Dec-2020	Lecture

CACHED

false

EXECUTIONTIME

SQL

SELECT ssbsect_crn, ssbsect_term_code, ssrblck_blck_code, ssrmeet_start_date, ssrmeet_end_date, TO_CHAR(ssrmeet_start_date, 'DD-Mon-YYYY') AS start_date, TO_CHAR(ssrmeet_end_date, 'DD-Mon-YYYY') AS end_date, ssrmeet_begin_time, ssrmeet_end_time, TRUNC( TO_DATE(CONCAT(ssrmeet_begin_time,'00'),'HH24:MI:SS')) + ( ROUND( (TO_DATE(CONCAT(ssrmeet_begin_time,'00'),'HH24:MI:SS') - TRUNC(TO_DATE(CONCAT(ssrmeet_begin_time,'00'),'HH24:MI:SS')) ) * 96 ) / 96) as begin_time_round, TRUNC( TO_DATE(CONCAT(ssrmeet_end_time,'00'),'HH24:MI:SS')) + ( ROUND( (TO_DATE(CONCAT(ssrmeet_end_time,'00'),'HH24:MI:SS') - TRUNC(TO_DATE(CONCAT(ssrmeet_end_time,'00'),'HH24:MI:SS')) ) * 96 ) / 96) as end_time_round, DECODE(ssrmeet_sun_day, 'U', 'Sun ', '') || DECODE(ssrmeet_mon_day, 'M', 'Mon ', '') || DECODE(ssrmeet_tue_day, 'T', 'Tue ', '') || DECODE(ssrmeet_wed_day, 'W', 'Wed ', '') || DECODE(ssrmeet_thu_day, 'R', 'Thu ', '') || DECODE(ssrmeet_fri_day, 'F', 'Fri ', '') || DECODE(ssrmeet_sat_day, 'S', 'Sat ','') AS day_of_week, ssrmeet_bldg_code, ssrmeet_room_code, sirasgn_pidm, ssbsect_seats_avail, ssbsect_wait_count, ssbsect_voice_avail, ssrmeet_schd_code, stvschd_desc FROM ssbsect INNER JOIN stvschd ON ssbsect_schd_code = stvschd_code AND ssbsect_schd_code NOT IN ('PLA', 'CL', 'CB', 'CI', 'T') LEFT OUTER JOIN ssrblck ON ssrblck_term_code = ssbsect_term_code AND ssrblck_crn = ssbsect_crn LEFT OUTER JOIN ssrmeet ON ssrmeet_term_code = ssbsect_term_code AND ssrmeet_crn = ssbsect_crn LEFT OUTER JOIN sirasgn ON sirasgn_crn = ssbsect_crn AND sirasgn_term_code = ssbsect_term_code WHERE ssbsect.ssbsect_subj_code = 'HOSP' AND ssbsect.ssbsect_crse_numb = '2820' AND ssbsect.ssbsect_term_code >= 202070 AND ssbsect.ssbsect_ssts_code = 'A' AND ssbsect.ssbsect_ptrm_end_date > sysdate-1 ORDER BY ssrmeet_start_date, ssrmeet_begin_time, ssbsect_crn

array

struct
1	74922
2	HOSP231

struct
1	74923
2	HOSP232

struct
1	74924
2	HOSP233

struct
1	74925
2	HOSP234

struct
1	74923
2	HOSP232

struct
1	74922
2	HOSP231

struct
1	74924
2	HOSP233

struct
1	74925
2	HOSP234

struct
1	74922
2	HOSP231

struct
1	74923
2	HOSP232

struct
1	74922
2	HOSP231

struct
1	74923
2	HOSP232

struct
1	74924
2	HOSP233

struct
1	74925
2	HOSP234

array

struct
1	HOSP HOSP HOSP HOSP
2	74922 74923 74924 74925
3	HOSP231

Contact us

Frequently asked questions

Ask a question

Book an appointment with an advisor

fill out an online form
Call 604.871.7000, option 2

INTERNATIONAL STUDENTS

Visit VCC International for contact information.

* Fees are approximate and subject to change. Students are required to pay any applicable fee increases. Fees listed are for domestic students. For international programs, visit VCC International.

† This information is intended as a guideline only. Program and course details are subject to change with the approval of VCC's Board of Governors.

Cost Controls (HOSP 2820)

Schedule†

HOSP 2820 schedule for programs:

Additional Information

Contact us