cpt_109_lesson_14_solution

# cpt_109_lesson_14_solution - CANTONAL HOSPITAL Theoretical...

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

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).

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

View Full Document
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
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)

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

View Full Document
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
Ask a homework question - tutors are online