cpt_109_lesson_14_solution

cpt_109_lesson_14_solution - CANTONAL HOSPITAL Theoretical...

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

View Full Document Right Arrow Icon
Autumn 2006 BOS2-E Week 2 Lecturer Excel 2003 CANTONAL HOSPITAL Theoretical cost of goods Breakdown of meals on 01/08/06 CHOICE Cost of goods Nos. OF MEAL per meal sold MEAL 1 MEAL 2 MEAL 3 MEAL 4 MEAL 5 TOTAL Total costs Course: Complete the column headed "Cost of goods per meal" using RAND (6.50/8.50) rounded to the nearest 10 centimes (MROUND). Complete the column headed "Nos. sold" using RAND (50/200) rounded to to the nearest unit (INT).
Background image of page 1

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

View Full DocumentRight Arrow Icon
CANTONAL HOSPITAL Theoretical cost of goods Breakdown of meals on 01/08/06 CHOICE Cost of goods Nos. OF MEAL per meal sold MEAL 1 MEAL 2 MEAL 3 MEAL 4 MEAL 5 TOTAL Total costs
Background image of page 2
Theoretical cost of goods Breakdown of meals on 01/08/06 CHOICE Cost of goods Nos. OF MEAL per meal sold MEAL 1 =MROUND(RAND()*2+6.5;0.1) =INT(RAND()*151+50) MEAL 2 =MROUND(RAND()*2+6.5;0.1) =INT(RAND()*151+50) MEAL 3 =MROUND(RAND()*2+6.5;0.1) =INT(RAND()*151+50) MEAL 4 =MROUND(RAND()*2+6.5;0.1) =INT(RAND()*151+50) MEAL 5 =MROUND(RAND()*2+6.5;0.1) =INT(RAND()*151+50)
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This homework help was uploaded on 04/19/2008 for the course CPT CPT 109 taught by Professor A.sisini during the Fall '08 term at Franklin CH.

Page1 / 5

cpt_109_lesson_14_solution - CANTONAL HOSPITAL Theoretical...

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

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