menu planning and diet analysis
murad.hajyani
Assignment2-ExcelSheet_LeBlanc.pdf
Monday Tuesday Wednesday Thursday Friday Weekly
Total
Weekly
Requirement
(cups)
Weekly
Requirement
Check
Minimum Fruit (cups) 1/2 1/2 1/2 1/2 1/2 2 1/2 2 1/2 YES
Monday Tuesday Wednesday Thursday Friday Weekly
Total
Weekly
Requirement
(cups)
Weekly
Requirement
Check
Minimum Vegetables 3/4 3/4 3/4 3/4 3/4 3 3/4 3 3/4 YES
Cups of DARK GREEN 0 0 3/4 0 0 3/4 1/2 YES
Cups of RED/ORANGE 3/4 0 1/4 0 0 1 3/4 YES
Cups of
BEANS/PEAS(Legumes) 0 1/2 0 0 0 1/2 1/2 YES
Cups of STARCHY
vegetables 0 1/2 0 0 0 1/2 1/2 YES
Cups of OTHER
(any other type of
vegetable ) 0 0 0 3/4 3/4 1 1/2 1 1/2 YES
Monday Tuesday Wednesday Thursday Friday Weekly
Total
Weekly
Requirement
(oz
equivalents)
Weekly
Requirement
Check
Minimum Meat/Meat
Alternate 2.00 2.00 2.00 2.00 2.00 10.00 9 YES Maximum Meat/Meat
Alternate 2.00 2.00 2.00 2.00 2.00 10.00 10 YES
Weekly Report
Lunch, Grades 6-8
Monday Tuesday Wednesday Thursday Friday Weekly
Total
Weekly
Requirement
(oz
equivalents)
Weekly
Requirement
Check
Minimum Grain 2.00 2.00 2.00 2.00 1.00 9.00 8 YES Maximum Grain 2.00 2.00 2.00 2.00 2.00 10.00 10 YES
0.00
No more 2 oz
equivalents YES
0.00 0.00 0.00 0.00 0.00 YES
Whole Grain Rich Weekly
Amount
Weekly
Grains Total:
Weekly
Whole Grain
Rich Total:
Percent of
Whole Grain
Rich 100.0%
100% whole
grain rich YES
Monday Tuesday Wednesday Thursday Friday Weekly
Total
Weekly
Requirement
(cups)
Weekly
Requirement
Check
Minimum Fluid Milk 1 1 1 1 1 5 5 YES Variety: Skim/fat-free
unflavored, Skim/fat-free
flavored, Low-fat (less than
1%), unflavored YES YES YES YES YES
Low-fat (1% or less), flavored
Reduced fat (2% fat) or
whole, unflavored and
flavored
Grain Based Dessert Total for all weekly meals
