Use Different Headings for Each Question. APA style, References from academic and peer review, and scholarly articles only. Keep the sentences of references short. 1. Use Ansoff’s Matrix and evaluate….
Describe how this project fulfills the Gen Ed Outcomes (Interpretation, Representation, Calculation, Application/Analysis, Assumptions
Project â€“ Restaurant Meal Analysis
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 JR.Â® Sandwich||310||18||390||27||13|
|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|
(3 pts) Choose your favorite entrÃ©e and fill in the chart.
|Favorite entrÃ©e||Calories||Total fat (g)||Carbohydrate (g)||Protein (g)|
(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.
|Number of Servings in your EntrÃ©e|
|Daily Recommended Servings|
(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|
(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.