Hometown University Menu Planning Decision Base

Hometown University Menu Planning Decision Base - HOMETOWN...

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

View Full Document Right Arrow Icon
HOMETOWN UNIVERSITY MENU PLANNING BASE CHANGING CELLS CASE NUMBER OF HEALTHY BREAKFASTS 1 NUMBER OF TASTY BREAKFASTS 1 NUMBER OF HEALTHY LUNCHES 1 NUMBER OF TASTY LUNCHES 1 NUMBER OF HEALTHY DINNERS 1 NUMBER OF TASTY DINNERS 1 CONSTANTS CALORIES FRUIT VEGETABLE GRAIN MEAT TYPE OF MEAL: PER MEAL (CUP) (CUP) (OUNCE) (OUNCE) HEALTHY BREAKFAST 700 1.00 1.00 3.00 1.00 TASTY BREAKFAST 1000 0.50 0.50 1.00 2.00 HEALTHY LUNCH 800 1.00 1.50 3.00 1.50 TASTY LUNCH 1100 0.50 0.50 1.00 2.50 HEALTHY DINNER 1000 1.00 2.00 4.00 2.50 TASTY DINNER 1250 0.50 0.50 1.00 3.50 REFINED DIRECT DAIRY FAT SUGAR PRICE OF COST OF (CUP) (TSPN) (OUNCE) A MEAL A MEAL HEALTHY BREAKFAST 1.00 2.00 0.00 3 2 TASTY BREAKFAST 0.50 4.00 2.00 5 3 HEALTHY LUNCH 1.00 2.00 0.00 5 4 TASTY LUNCH 0.50 4.00 2.00 8 5 HEALTHY DINNER 1.00 2.00 0.00 7 6 TASTY DINNER 0.50 4.00 2.00 10 7 MIN DINING PLAN CHARGE 100 FIXED DINING COSTS FOR A WEEK 20 INTERNAL TAX RATE 0.10 CALCULATIONS REVENUE FROM MEALS: -- HEALTHY BREAKFAST 3 TASTY BREAKFAST 5
Background image of page 1

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

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

This note was uploaded on 04/24/2010 for the course COS 240 taught by Professor Boycheva during the Spring '10 term at American University in Bulgaria.

Page1 / 4

Hometown University Menu Planning Decision Base - HOMETOWN...

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

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