Use red font to write your answers and explanations on this Word document. All final answers, charts, graphs should be in the Word document. However, you will submit this Word document and the Excel spreadsheet to the 5.5 Dropbox.

Pick your favorite restaurant, and do a web search for the nutrition facts for its menu items. Most restaurants have this information available. If you can’t find the nutrition facts, choose another restaurant.

(15 pts) Choose 10 entrees and record the following information. Then create an Excel spreadsheet to display these values and make sure to save it to your computer. Use an Excel formula to find the mean for each category.

Name of Restaurant: Burger King
Item Name Calories Total fat (g) Sodium (mg) Carbohydrate (g) Protein (g)
WHOPPER® Sandwich 660 40 980 49 28
WHOPPER JR.® Sandwich 310 18 390 27 13
Cheeseburger 280 13 560 27 15
Double Cheeseburger 390 21 590 27 23
Grilled Chicken Sandwich 470 19 850 39 37
Chicken Nuggets- 4pc 170 11 310 11 8
Original Chicken Sandwich 660 40 1170 48 28
RODEO® Crispy Chicken Sandwich 960 60 2230 72 33
French Fries – medium (Salted) 380 17 570 53 5
Garden Side Salad – w/o dressing 60 4 95 3 4
Mean 434 24.3 774.5 35.6 19.4

(3 pts) Choose your favorite entrée and fill in the chart.

Favorite entrée Calories Total fat (g) Carbohydrate (g) Protein (g)
Double Cheeseburger 390 21 27 23

(3 pts) Assume that one serving of fat is approximately 5 g, one serving of protein is approximately 7 g, and one serving of carbohydrates is approximately 15 g. Then determine how many servings of fat, protein, and carbohydrates are in that entrée.

Show your work here:

(3 pts) Look up how many servings are recommended per day (remember to cite your source). Record this information along with the results from Question 3 in the table below.

Fat Protein Carb
Number of Servings in your Entrée
Daily Recommended Servings
Source:

(3 pts) Use Excel to create a double (or “clustered”) bar graph that compares the number of servings in your entrée to the number of recommended daily servings. Include labels.

Paste the double bar graph here:

(3 pts) Look up how many calories are in one gram of fat, protein, and carbohydrates (remember to cite your source). Write these values and the website you used here:

1 gram Fat 1 gram Protein 1 gram Carb
Source:

(3 pts) Determine how many calories in your chosen entrée come from fat, protein, carbohydrates, and other.

Show your work here:

(3 pts) Convert these to percentages of the total calories in the entrée and use Excel to create a pie chart. Include labels.

Paste your pie chart here:

(15 pts) Determine the total calories in the entrée. Assume you consumed a 300 calorie breakfast, a 600 calorie lunch, and this entrée for dinner. If you ate this meal every day for 1 year (365 days), how would this effect your life and body (weight, health, etc)?

Your response needs to be at least 300 words.

Base your answer on these assumptions

You should consume 2000 calories per day.

One pound of weight gain or loss is equivalent to 3500 calories.

You do not have any food allergies.

Explain and show any work needed for this calculation.

Describe the assumptions in making your judgments.

Provide compelling rationale for why each assumption is appropriate or inappropriate.

Explain whether and how your findings are valid.

Explain whether and how your findings are reasonable.

Provide deep and thoughtful judgments, drawing insightful, carefully qualified conclusions from the project.

(3 pts) Describe how this project fulfills the Gen Ed Outcomes (Interpretation, Representation, Calculation, Application/Analysis, Assumptions, Communication).

(3 pts) Describe how this MAT-118 course is essential for one’s professional education program as well as expanding other long-term career path options.

Found something interesting ?

• On-time delivery guarantee
• PhD-level professional writers
• Free Plagiarism Report

• 100% money-back guarantee
• Absolute Privacy & Confidentiality
• High Quality custom-written papers

Related Model Questions

Feel free to peruse our college and university model questions. If any our our assignment tasks interests you, click to place your order. Every paper is written by our professional essay writers from scratch to avoid plagiarism. We guarantee highest quality of work besides delivering your paper on time.

Grab your Discount!

25% Coupon Code: SAVE25
get 25% !!