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

(3 pts) All final answers, charts, graphs should be in the Word document. Submit this Word document and the Excel spreadsheet to the 5.5 Dropbox.

Prepare a report on disclosure issues related to the segment and noncontrolling interest information for HP. I am not allowed to attach a website per this website my last post was flagged but any website containg this infomration is fine!! I am just having an issue talking about and understand their non controlling interests.

I’m not really sutre what infomrtaion is needed

HEWLETT-PACKARD COMPANY AND SUBSIDIARIES

Consolidated Balance Sheets

		October 31
		2011		2010
		In millions, except par value
ASSETS
Current assets:
	Cash and cash equivalents		$	8,043		$	10,929
	Accounts receivable			18,224			18,481
	Financing receivables			3,162			2,986
	Inventory			7,490			6,466
	Other current assets			14,102			15,322
		Total current assets			51,021			54,184
Property, plant and equipment			12,292			11,763
Long-term financing receivables and other assets			10,755			12,225
Goodwill			44,551			38,483
Purchased intangible assets			10,898			7,848
Total assets		$	129,517		$	124,503
LIABILITIES AND STOCKHOLDERS’ EQUITY
Current liabilities:
	Notes payable and short-term borrowings		$	8,083		$	7,046
	Accounts payable			14,750			14,365
	Employee compensation and benefits			3,999			4,256
	Taxes on earnings			1,048			802
	Deferred revenue			7,449			6,727
	Accrued restructuring			654			911
	Other accrued liabilities			14,459			15,296
		Total current liabilities			50,442			49,403
Long-term debt			22,551			15,258
Other liabilities			17,520			19,061
Commitments and contingencies
Stockholders’ equity:
HP stockholders’ equity
	Preferred stock, $0.01 par value (300 shares authorized; none issued)			—			—
	Common stock, $0.01 par value (9,600 shares authorized; 1,991 and 2,204 shares issued and outstanding, respectively)			20			22
	Additional paid-in capital			6,837			11,569
	Retained earnings			35,266			32,695
	Accumulated other comprehensive loss			(3,498	)		(3,837	)
		Total HP stockholders’ equity			38,625			40,449
Non-controlling interests			379			332
Total stockholders’ equity			39,004			40,781
Total liabilities and stockholders’ equity		$	129,517		$	124,503

The accompanying notes are an integral part of these Consolidated Financial Statements.

76

Table of Contents

HEWLETT-PACKARD COMPANY AND SUBSIDIARIES

Consolidated Statements of Cash Flows

		For the fiscal years ended October 31
		2011		2010		2009
		In millions
Cash flows from operating activities:
	Net earnings		$	7,074		$	8,761		$	7,660
	Adjustments to reconcile net earnings to net cash provided by operating activities:
		Depreciation and amortization			4,984			4,820			4,780
		Impairment of goodwill and purchased intangible assets			885			—			—
		Stock-based compensation expense			685			668			635
		Provision for doubtful accounts—accounts and financing receivables			81			156			345
		Provision for inventory			217			189			221
		Restructuring charges			645			1,144			640
		Deferred taxes on earnings			166			197			379
		Excess tax benefit from stock-based compensation			(163	)		(294	)		(162	)
		Other, net			(46	)		169			22
		Changes in assets and liabilities:
			Accounts and financing receivables			(227	)		(2,398	)		(549	)
			Inventory			(1,252	)		(270	)		1,532
			Accounts payable			275			(698	)		(153	)
			Taxes on earnings			610			723			733
			Restructuring			(1,002	)		(1,334	)		(1,237	)
			Other assets and liabilities			(293	)		89			(1,467	)
				Net cash provided by operating activities			12,639			11,922			13,379
Cash flows from investing activities:
	Investment in property, plant and equipment			(4,539	)		(4,133	)		(3,695	)
	Proceeds from sale of property, plant and equipment			999			602			495
	Purchases of available-for-sale securities and other investments			(96	)		(51	)		(160	)
	Maturities and sales of available-for-sale securities and other investments			68			200			171
	Payments in connection with business acquisitions, net of cash acquired			(10,480	)		(8,102	)		(391	)
	Proceeds from business divestiture, net			89			125			—
				Net cash used in investing activities			(13,959	)		(11,359	)		(3,580	)
Cash flows from financing activities:
	(Payments) issuance of commercial paper and notes payable, net			(1,270	)		4,156			(6,856	)
	Issuance of debt			11,942			3,156			6,800
	Payment of debt			(2,336	)		(1,323	)		(2,710	)
	Issuance of common stock under employee stock plans			896			2,617			1,837
	Repurchase of common stock			(10,117	)		(11,042	)		(5,140	)
	Excess tax benefit from stock-based compensation			163			294			162
	Cash dividends paid			(844	)		(771	)		(766	)
				Net cash used in financing activities			(1,566	)		(2,913	)		(6,673	)
(Decrease) increase in cash and cash equivalents			(2,886	)		(2,350	)		3,126
Cash and cash equivalents at beginning of period			10,929			13,279			10,153
Cash and cash equivalents at end of period		$	8,043		$	10,929		$	13,279

The accompanying notes are an integral part of these Consolidated Financial Statements.