*LBEC Data Tables(1) Q . Search Sheet + Home Insert Page Layout Formulas Data Review View X Cut Calibri (Body) * 1 12 . A- A- General AutoSum Wrap Text Copy Fill Paste Format BI UTY MA. # Merge & Center $ 9 % 2 00 Conditional Format Cell Insert Delete Format Sort & Formatting as Table Styles Clear Filter F21 X A C D E F G H K L M N P Q R S T 1 Table 1 Culinary Courses # of Courses # of Chef Duration Duration # of Students # of Student Programs > > Targeted market segment Total students Instructor Details planned per per course hours year Hours Fun (team building) cooking lessons 2 days a Juste pour le fun for organizations and its employees Weekends week/ 6 hours 300 3,600 360 (CSR) as part of their CSR initiative a day essons for young kids/community 2 days a Le week-end members who are learning how to Weekends week/ 6 hours 30 10 300 3,600 360 Cours cook, with a focus on healthy meals a day Individual lesson for 3 days a professionals/semi-professionals Jeune Chef 4 weeks week/ 2 hours 20 260 6,240 312 who aspire to become better rated per day chefs Group lessons for amateur groups, 3 days a Groupe Classe - who wish to enroll together as 4 weeks week/ 2 hours T 20 260 6,240 312 cuisson rapide friends/family and learn some quick | a day 6 cooking skills for everyday meals Tota 36 1,120 19,68 1,344 11 27 28 29 Table 1 Table 2 Table 3 Table 4 + Ready + 100%*LBEC Data Tables(1) Q . Search Sheet + Home Insert Page Layout Formulas Data Review View X Cut Calibri (Body) * 12 . A- A = Wrap Text AutoSum General AP. Copy Fill Paste # Merge & Center $ % 2 00 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter A3 X V fx Grocery, produce and other food items B C D E F G H K L M N P Q 1 Costs Description Cost Type Activity Driver Remarks Annualised Cost Number of 3 $10 per student per hour Direct/Variable students For 4 week courses Direct/Variable Number of $5 per student per hour students or weekend courses Number of $40 per student/course Direct/Variable For all courses 5 students Number of $40 per day per student Direct/Variable students Only for weekend courses Number of $60 per instructor hour Direct/Variable instructional hours Useful life 10 years; no salvage Indirect/Fixed Number of Depreciation is a factor of the extent B value. Cost $100,000 student hours of student usage 10,000 Useful life 10 years; No salvage Number of Indirect/Fixed Depreciation is a factor of the extent value; Cost $40,00 student hours of student usage 4,000 Number of Utility consumption is a function of $2,500 per month Indirect/Semi-variable 10 student hours student's presence/usage 30,000 11 $1,000 per month Indirect/Semi-variable Common costs Cannot be traced to course groups 12,000 Number of Space usage is a function of $8,000 per month Indirect/Fixed 12 student hours student's presence 96,000 13 $5,000 per year Indirect/Semi-variable Common costs Cannot be traced to course groups 5,000 Cleaning/maintenance requirements 3 hours per day * 365 days @ $20 Indirect/Fixed Number of per hour student hours is a function of student's presence and usage of facilities 14 21,900 Number of Can be translated to per student per Direct/Fixed 15 courses course 86,000 16 264,900 17 18 te is to increase the week-end customer base as they feel that it is an untapped market. 19 an be increased and the companies can still afford it and there may be a cross marketing of the longer term courses. 20 's are approximately $1,000 per course offering * 86 course offerings during the year rising, Marketing & Promotional expenses for the week end programs, it worked out to be nearly $1,250 per week and course offering EEI 21 week courses. 22 costs cannot be traced, accurately and therefore should be treated as common costs eciation; Utilities, Rental Costs and Cleaning & Maintenance) could be allocated based on the planned classes and/or student hours during 23 lausible drivers. atad with coma caution: thara carte could also ha considered unaunidahla and tharafora ralavant in catting the fear nar courca or Table 1 Table 2 Table 3 Table 4 + Ready + 100%*LBEC Data Tables(1) Q . Search Sheet + Home Insert Page Layout Formulas Data Review View X Cut Calibri (Body) * 12 . A- A Wrap Text General AutoSum AP. Copy Fill Paste BI UTYMAY + Merge & Center $ % 2 00 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter A3 X V fx |Grocery, produce and other food items A B C E F G H 1 J K L M N Table 2 Costs Costs Heading Description Cost Type Activity Driver Remarks Annualised Cost Grocery, produce and other Number of 3 food items $10 per student per hour Direct/Variable students For 4 week courses Grocery, produce and other food items $5 per student per hour Direct/Variable Number of students For weekend courses $40 per student/course Direct/Variable Number of Course materials For all courses students $40 per day per student Direct/Variable Number of Lunch & Refreshments students Only for weekend courses Number of Instructor's compensation $60 per instructor hour Direct/Variable instructional hours 20 Cooking stations; $5,000 Useful life 10 years; no salvage Number of depreciation is a factor of the extent B Indirect/Fixed each value. Cost $100,000 student hours of student usage 10,000 Equipment/Cutlery, etc. for the cooking stations; $2,000 Useful life 10 years; No salvage Indirect/Fixed Number of Depreciation is a factor of the extent value; Cost $40,000 student hours of student usage each 4,000 Utilities $2,500 per month Indirect/Semi-variable Number of Utility consumption is a function of 10 student hours student's presence/usage 30,000 11 Communications $1,000 per month Indirect/Semi-variable Common costs Cannot be traced to course groups 12,000 Rental costs $8,000 per month Indirect/Fixed Number of Space usage is a function of 12 student hours student's presence 96,000 13 Insurance costs $5,000 per year Indirect/Semi-variable Common costs Cannot be traced to course groups 5,000 Cleaning/maintenance requirements 3 hours per day * 365 days @ $20 Number of Cleaning & Maintenance per hour Indirect/Fixed student hours s a function of student's presence and usage of facilities 14 21,900 Advertising & Marketing Direct/Fixed Number of Can be translated to per student per 15 courses course 86,000 6 Total Indirect and Fixed Costs 264,900 17 Notes 18 The strategic goal of the institute is to increase the week-end customer base as they feel that it is an untapped market. 19 The fees for weekend courses can be increased and the companies can still afford it and there may be a cross marketing of the longer term courses. 20 Marketing and Advertising costs are approximately $1,000 per course offering * 86 course offerings during the year When they calculated the Advertising, Marketing & Promotional expenses for the week end programs, it worked out to be nearly $1,250 per week and course offering 21 and the balance was for the 4 week courses. 22 Communication and Insurance costs cannot be traced, accurately and therefore should be treated as common costs The following Fixed Costs (Depreciation; Utilities, Rental Costs and Cleaning & Maintenance) could be allocated based on the planned classes and/or student hours during 23 the year, as those seem to be plausible drivers. Thara fived carts should ha trastad with coma caution: thara carts could alea has fora not ralavant in catting the fans nar courca or Table 1 Table 2 Table 3 Table 4 + Ready + 100%*LBEC Data Tables(1) Q . Search Sheet + Home Insert Page Layout Formulas Data Review View X Cut Calibri (Body) * 12 . A- A Wrap Text General AutoSum AP. Copy Fill Paste Insert Format Merge & Center $ % 2 00 Conditional Format Cell Delete Format Sort & Formatting as Table Styles Clear Filter A3 X V fx Grocery, produce and other food items A B C E F G H 1 J K L M N Table 2 Costs Costs Heading Description Cost Type Activity Driver Remarks Annualised Cost Lunch & Refreshments $40 per day per student Direct/Variable Number of Only for weekend courses 6 students Number of Instructor's compensation $60 per instructor hour Direct/Variable instructional hours 20 Cooking stations; $5,000 Useful life 10 years; no salvage Indirect/Fixed Number of Depreciation is a factor of the extent B each value. Cost $100,000 student hours of student usage 10,000 Equipment/Cutlery, etc. for the cooking stations; $2,000 Useful life 10 years; No salvage Number of Depreciation is a factor of the extent value; Cost $40,000 Indirect/Fixed student hours of student usage each 4,000 Utilities $2,500 per month Indirect/Semi-variable Number of Utility consumption is a function of 10 student hours student's presence/usage 30,000 11 Communications $1,000 per month Indirect/Semi-variable Common costs Cannot be traced to course groups 12,000 Rental costs $8,000 per month Indirect/Fixed Number of Space usage is a function of 12 student hours student's presence 96,000 13 Insurance costs $5,000 per year Indirect/Semi-variable Common costs Cannot be traced to course groups 5,000 3 hours per day * 365 days @ $20 Number of Cleaning/maintenance requirements Cleaning & Maintenance Indirect/Fixed per hour student hours is a function of student's presence and usage of facilities 21,900 Advertising & Marketing Direct/Fixed Number of Can be translated to per student per 15 courses course 86,000 16 Total Indirect and Fixed Costs 264,900 17 Notes 18 The strategic goal of the institute is to increase the week-end customer base as they feel that it is an untapped market. The fees for weekend courses can be increased and the companies can still afford it and there may be a cross marketing of the longer term courses. 20 Marketing and Advertising costs are approximately $1,000 per course offering * 86 course offerings during the year When they calculated the Advertising, Marketing & Promotional expenses for the week end programs, it worked out to be nearly $1,250 per week and course offering 21 and the balance was for the 4 week courses. 22 Communication and Insurance costs cannot be traced, accurately and therefore should be treated as common costs The following Fixed Costs (Depreciation; Utilities, Rental Costs and Cleaning & Maintenance) could be allocated based on the planned classes and/or student hours during 23 the year, as those seem to be plausible drivers. These fixed costs should be treated with some caution; these costs could also be considered unavoidable and therefore not relevant in setting the fees per course or 24 student. 25 26 27 28 Table 1 Table 2 Table 3 Table 4 + Ready + 100%*LBEC Data Tables(1) Q . Search Sheet + Home Insert Page Layout Formulas Data Review View X Cut AutoSum Calibri (Body) 12 . A- A- Wrap Text General AP. Copy Fill Paste #+ Merge & Center $ % 2 00 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter A3 x v fx Culinary Instructor's compensation C D F G H 1 J K L M N P Q Table 3 Cost per Student Unit Costs Cost Type Total Cost Remarks Culinary Instructor's 3 compensation 80,640 Instructor's compensation per hour = $60 60.00 Lunch & Refreshments (only for weekend courses) 48,000 600 students x 2 days x $40 per student 40.00 Course Material: 5 44,800 1,120 students * $40 per student 40.00 For 4 week courses: Grocery, Produce and other foo 260 students/course * 2 courses * 3 days * 2 hours * 4 weeks 6 items 124,800 * $10 per student/hour 10.00 For week end courses: 300 students/course * 2 courses * 2 days * 6 hours 36,000 $5/student/hour 5.00 8 Total costs 834,240 9 Total students 1,120 10 Cost per student 298.43 11 12 13 16 34 26 Table 1 Table 2 Table 3 Table 4 + Ready + 100%*LBEC Data Tables(1) Q . Search Sheet + Home Insert Page Layout Formulas Data Review View X Cut AutoSum Calibri (Body) * 12 . A- A Wrap Text General Copy Fill Paste BI UTY MA. # Merge & Center $ % 2 00 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter F33 fx A D E F G H 1 J K L M N P Q R S T 1 Table 4 Le Bleu Ecole de Cuisine N Revenue / Profit Projections Juste pour le Le week- Groupe Classe fun (CSR) end Cours Jeune Chef Total cuisson rapide 5 Volumes: Culinary instructor hours 360 360 312 312 1,344 Expected student enrolments 300 300 260 260 1,120 Number of courses per year 30 30 13 13 86 10 Per Student: 11 Fee 399 399 399 399 12 Cost (Refer to Table 3) 298 298 298 298 13 Contribution 101 101 101 101 14 Contribution (%) 25% 25% 25% 25% 15 16 Total: $ $ 17 Revenue 19,700 119,700 103,740 103,740 446,880 18 Direct Cost 39,529 89,529 7,591 77,59 334,240 19 Contribution 30,171 30,171 26,149 26,149 112,640 20 Common Costs 21 Depreciation 14,000 22 Utilities 30,000 23 Communication Costs 12,000 24 Rental Costs 96,000 25 Insurance Costs 5,000 26 Cleaning and Maintenance Costs 21,90 27 Advertising and Marketing 86,000 28 Total common costs 264,900 29 Profit/(Loss) before taxes (152,260) 30 31 Approximate Revenue projected per student $ 399 32 33 34 35 36 37 38 39 40 41 Table 1 Table 2 Table 3 Table 4 + Ready + 100%LBEC Data Tables(1) Q . Search Sheet Home Insert Page Layout Formulas Data Review View fx A Q e ED Define Name Trace Precedents O 15/fox Calculate Now Trace Dependents Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Create from Selection Show Error Calculation Calculate Sheet Function Used Time Reference Trig Functions Ix Remove Arrows Formulas Checking Options C18 X V fx A C D E 1 Table 3 Cost per Student Unit Costs Cost Type Total Cost Remarks Culinary Instructor's compensation 3 'Table 1'!17*E3 Instructor's compensation per hour = $60 Lunch & Refreshments (only for weekend courses) =('Table 1"!G4+'Table 1"!G3)*2*E4 600 students x 2 days x $40 per student 40 Course Materials 5 ='Table 1'!G7*E5 1,120 students * $40 per student 40 For 4 week courses: 6 Grocery, Produce and other food items =('Table 1'!H5+'Table 1'!H6)*E6 260 students/course * 2 courses * 3 days * 2 hours * 4 weeks * $10 per student/hour 10 For week end courses: unT =('Table 1'!H3+"Table 1'!H4)*E7 300 students/course * 2 courses * 2 days * 6 hours * $5/student/hour 8 Total costs =SUM(B3:B7) 9 Total students =Table 1'/G7 10 Cost per student =B8/B9 11 12 13 15 16 17 19 20 32 33 34 D Table 1 Table 2 Table 3 Table 4 + Edit + 100%LBEC Data Tables(1) Q . Search Sheet + Home Insert Page Layout Formulas Data Review View fx E . A . B . 2 . A Q e ED Define Name Trace Precedents Calculate Now Trace Dependents Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Create from Selection Show Error Used Trig Ex Remove Arrows Calculation Calculate Sheet Function Time Reference Functions Formulas Checking Options E36 X V fx A B C D E F G 1 Table 4 Le Bleu Ecole de Cuisine N Revenue / Profit Projections ='Table 1"!A3 ='Table 1"!A4 ='Table 1'!A5 ='Table 1"!A6 Total 5 Volumes: Culinary instructor hours 'Table 1'll3 ='Table 1'll4 ='Table 1'!16 ='Table 1'll5 -SUM(B6:E6) Expected student enrolments ='Table 1'IG3 ='Table 1'IG4 'Table 1'!G6 "Table 1'IG5 -SUM(B7:E7) Number of courses per year =Table 1'lE3 'Table 1'IE4 'Table 1'IE6 =Table 1'IE5 =SUM(B8:E8) 10 Per Student: 11 Fee ='Table 4'ISC$31 "Table 4'I$C$31 "Table 4'ISC$31 "Table 4'I$C$31 12 Cost (Refer to Table 3) =Table 3'!$B$10 "Table 3'!$B$10 'Table 3'!$B$10 'Table 3'!$B$10 13 Contribution =B11-812 C11-C12 =D11-D12 =E11-E1 14 Contribution (%) =813/B11 =C13/C11 D13/D11 E13/E11 15 16 Total: $ 17 Revenue =B11*B$7 -C11*C$7 =D11*D$7 E11*E$7 =D17+E17+C17+B17 18 Direct Cost =B12*8$7 =C12*C$7 =D12*D$7 E12"ES =D18+E18+C18+818 19 Contribution =813*B$ C13*C$7 =D13*D$7 E13*E$7 D19+E19+C19+819 20 Common Costs 21 Depreciation =('Table 2"IF8+'Table 2"IF9) 22 Utilities ='Table 2'IF10 23 Communication Costs ='Table 2'!F11 24 Rental Costs ='Table 2'IF12 25 Insurance Costs =Table 2'!F13 26 Cleaning and Maintenance Costs ='Table 2'IF14 27 Advertising and Marketing ='Table 2'IF1! 28 Total common costs =SUM(F21:F27) 29 Profit/(Loss) before taxes =F19-SUM(F21:F27) 30 31 Approximate Revenue projected per student =399 32 33 34 35 36 37 38 39 40 41 Table 1 Table 2 Table 3 Table 4 + Ready + 100%LBEC Data Tables(1) Q . Search Sheet + Home Insert Page Layout Formulas Data Review View fx A Q e ... ED Define Name Trace Precedents 15/fac Calculate Now Trace Dependents Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Create from Selection Show Error x Remove Arrows Calculation Calculate Sheet Function Used Time Reference Trig Functions Formulas Checking Options A3 4 X v fx Grocery, produce and other food items C D E 1 Costs Description Cost Type Activity Driver Remarks Annualised Cost 3 $10 per student per hour Direct/Variable Number of students For 4 week courses $5 per student Direct/Variable Number of students For weekend courses $40 per student/course Direct/Variable Number of students For all courses 5 $40 per day per student Direct/Variable Number of students Only for weekend courses $60 per instructor hour Direct/Variable Number of instructional hours Useful life 10 years; no salvage value. Cost $100,000 Indirect/Fixed Number of student hours Depreciation is a factor of the extent of student usage =(20*5000)/10 Useful life 10 years; No salvage value; Cost $40,000 Indirect/Fixed Number of student hours Depreciation is a factor of the extent of student usage =20*2000/10 $2,500 per month direct/Semi-variable 10 Number of student hours Utility consumption is a function of student's presence/usage =12*2500 11 $1,000 per month Indirect/Semi-variable Common costs Cannot be traced to course groups =12*1000 $8,000 per month direct/Fixed 12 Number of student hours Space usage is a function of student's presence =12*8000 13 $5,000 per year ndirect/Semi-variable Common costs Cannot be traced to course groups 5000 3 hours per day * 365 days @ $20 per hour Indirect/Fixed Number of student hours Cleaning/maintenance requirements is a function of student's presence and usage of facilities 14 =3*365*20 Direct/Fixed Number of courses an be translated to per student per course 15 =86*1000 16 =SUM(F8:F15) 17 18 ustomer base as they feel that it is an untapped market. 19 nies can still afford it and there may be a cross marketing of the longer term courses. 20 21 al expenses for the week end programs, it worked out to be nearly $1,250 per week and course offering and the balance was for the 4 week courses. 22 23 and Cleaning & Maintenance) could be allocated based on the planned classes and/or student hours during the year, as those seem to be plausible drivers. Table 1 Table 2 Table 3 Table 4 + Ready + 100%LBEC Data Tables(1) Q . Search Sheet + Home Insert Page Layout Formulas Data Review View fx E . A . . 2 . A Q e ... ED Define Name Trace Precedents Calculate Now Trace Dependents Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Create from Selection Show Error 1x Remove Arrows Calculation Calculate Sheet Function Used Time Reference Trig Functions Formulas Checking Options F21 $ X V fx B C D E F G H 1 Courses Targeted market segment Duration Duration Details # of Courses planned per # of Students per course Total students # of Student hours # of Chef Instructor Hours year 2 m building) cooking lessons for organizations and its employees as Weekends 2 days a week/ 6 hours a day heir CSR initiative 30 10 =E3*F3 =G3*2*6 =E3*2*6 for young kids/community members who are learning how to Weekends 2 days a week/ 6 hours a day 4 th a focus on healthy meals 30 10 =E4*F4 =G4*2*6 =E4*2*6 3 days a week/ 2 hours per al lesson for professionals/semi-professionals who aspire to 4 weeks day 5 better rated chef 13 20 =65*F5 =G5*4*3*2 =[5*4*3*2 4 weeks ssons for amateur groups, who wish to enroll together as |3 days a week/ 2 hours a day family and learn some quick cooking skills for everyday meals 13 20 =E6*F6 =G6*4*3*2 =[6*4*3*2 =SUM(E3:E6) =SUM(G3:G6) =SUM(H3:H6 -SUM(13:16 CO 27 28 29 Table 1 Table 2 Table 3 Table 4 + Enter + 100%LBEC Data Tables(1) Q . Search Sheet Home Insert Page Layout Formulas Data Review View fx E . A . B . 2 . A O Q e ... ED Define Name Trace Precedents Calculate Now Trace Dependents Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Create from Selection Show Error Function Used Time Reference Trig Functions Ex Remove Arrows Calculation Calculate Sheet Formulas Checking Options A3 X V fx Grocery, produce and other food items B C D E Table 2 Costs Costs Heading Description Cost Type Activity Driver Remarks Annualised Cost Grocery, produce and other food items $10 per student per hour Direct/Variable Number of students For 4 week courses Grocery, produce and other food items $5 per student per hour Direct/Variable Number of students For weekend courses Course material $40 per student/course Direct/Variable Number of students For all courses Lunch & Refreshments $40 per day per student Direct/Variable Number of students Only for weekend courses Instructor's compensation $60 per instructor hour Direct/Variable Number of instructional hours |20 Cooking stations; $5,000 each Useful life 10 years; no salvage value. Cost $100,000 Indirect/Fixed Number of student hours Depreciation is a factor of the extent of student usage =(20* 5000)/10 Equipment/Cutlery, etc. for the cooking stations; $2,000 each Useful life 10 years; No salvage value; Cost $40,000 Indirect/Fixed Number of student hours Depreciation is a factor of the extent of student usage =20*2000/10 Utilities Indirect/Semi-variable 10 $2,500 per month Number of student hours Utility consumption is a function of student's presence/usage 12*2500 110 Communications 51,000 per month Indirect/Semi-variable Common costs Cannot be traced to course groups =12*1000 Rental costs $8,000 per month Indirect/Fixed Number of student hours Space usage is a function of student's presence =12*8000 Insurance costs $5,000 per year Indirect/Semi-variable Common costs Cannot be traced to course groups 5000 3 hours per day * 365 days @ $20 per hour Indirect/Fixed Number of student hours Cleaning/maintenance requirements is a function of student's presence and Cleaning & Maintenance usage of facilities -3*365*20 15 Advertising & Marketing Direct/Fixed Number of courses Can be translated to per student per course #86*1000 16 Total Indirect and Fixed Costs SUM (F8:F15] 17 Notes 18 The strategic goal of the institute is to increase the week-end customer base as they feel that it is an untapped market. 19 The fees for weekend courses can be increased and the companies can still afford it and there may be a cross marketing of the longer term courses. 20 Marketing and Advertising costs are approximately $1,000 per c 21 When they calculated the Advertising, Marketing & Promotional expenses for the week end programs, it worked out to be nearly $1,250 per week and course offering and the balance was for the 4 week courses. Communication and Insurance costs cannot be traced, accuratel 23 The following Fixed Costs (Depreciation; Utilities, Rental Costs and Cleaning & Maintenance) could be allocated based on the planned classes and/or student hours during the year, as those seem to be plausible drivers. These fixed costs should be treated with some caution; these costs could also be considered relevant in setting the fees per course or student. 30 Table 1 Table 2 Table 3 Table 4 + Ready + 85%