cpt_109_lesson_26_solution

cpt_109_lesson_26_solution - #NAME? #NAME? Veal Cutlets 5.0...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Terrace Garden Restaurant INGREDIENTS FOR BREADED VEAL CUTLETS Item Unit Cost Veal Cutlets SFr. 30.00 per kg Flour SFr. 1.10 per kg Eggs SFr. 0.40 per egg Milk SFr. 1.10 per litre Butter SFr. 9.60 per kg Oil SFr. 9.00 per litre
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Autumn 2006 BOS2-E Week 16 Exercise 2 Excel 2003 Terrace Garden Restaurant Breaded Veal Cutlet 24 Portions Years of service Faithful service Ingredient Quantity Units Unit cost I 6/23/2003 II III Veal Cutlets 5.5 kg IV I 8/21/1978 II III Butter 1.0 kg IV I 12/18/1995 II III Flour 0.8 kg IV I 9/9/2000 II III Eggs 12.0 1 egg IV I 8/16/1992 II III Oil 1.5 litre IV I 9/24/1977 II III Milk 2.0 litre IV Total cost of the ingredients V Number of suppliers older than 20 years VI Loan Loan SFr. 35,000.00 Interest rate 12% Monthly Payment SFr. 1,250.00 Number of payments VIII Supplier ID Supplier since
Background image of page 2
Autumn 2006 BOS2-E Week 16 Solution 2 Excel 2003 Terrace Garden Restaurant Breaded Veal Cutlet 24 Portions Supplier ID Years of service Faithful service Ingredient Quantity Units Unit cost F630 6/23/2003
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: #NAME? #NAME? Veal Cutlets 5.0 kg SFr. 30.00 F987 8/21/1978 #NAME? #NAME? Butter 1.0 kg SFr. 9.60 F930 8/16/1992 #NAME? #NAME? Oil 1.5 litre SFr. 9.00 F925 9/24/1977 #NAME? #NAME? Milk 2.0 litre SFr. 1.10 F583 12/18/1995 #NAME? #NAME? Flour 0.8 kg SFr. 1.10 F910 9/9/2000 #NAME? #NAME? Eggs 12.0 1 egg SFr. 0.40 Total cost of the ingredients SFr. 180.00 Number of suppliers older than 20 years Loan Loan SFr. 35,000.00 Interest rate 12% Monthly Payment SFr. 1,250.00 Number of payments 33 Supplier since ="F"&FIXED(RAND()*900+100;0;TRUE) =DATEDIF(B5;TODAY();"Y") =IF(C5>10;"long term supplier";"relatively new") =VLOOKUP(E5;INGREDIENTS!B$7:C$12;2;FALSE) =MROUND(SUMPRODUCT(F5:F10;H5:H10);0.1) =COUNTIF(C5:C10;">20") =NPER(C17/12;-C18;C16) A B C D E F G H I 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30...
View Full Document

Page1 / 3

cpt_109_lesson_26_solution - #NAME? #NAME? Veal Cutlets 5.0...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online