Deliverable 3 - Ranking Capital Investment Projects

Dashboard-Data-w-Charts.xlsx

Home >Business & Finance homework help >Operations Management homework help >Deliverable 3 - Ranking Capital Investment Projects

Dashboard

	Company	Industry
Return on Equity	9.0%	6.8%
Return on Assets	7.5%	5.7%

Expenses as of Quarter Ending 12/31/2018

12/31/2018

Food and beverage Restaurant labor Restaurant expenses Marketing expenses General and administrative expenses 574.20000000000005 544.221 344.96550000000002 53.351999999999997 74.016000000000005

Pasta House Restaurants 42825 42916 43008 43100 43190 43281 43373 43465 924.56999999999994 890.91 856.44 965.88000000000011 961.02 946.80000000000007 898.29000000000008 1017.1800000000001 Pasta House Restaurants 42825 42916 43008 43100 43190 43281 43373 43465 719 720 722 725 728 729 729 731

Expenses 2017 - 2018 (USD in 000s)

Food and beverage 42825 42916 43008 43100 43190 43281 43373 43465 501.75 499.68000000000006 488.61 542.97 541.53000000000009 524.97 506.96999999999997 574.20000000000005 Restaurant labor 42825 42916 43008 43100 43190 43281 43373 43465 305.24220000000003 311.6961 319.51350000000002 327.96720000000005 328.96709999999985 325.33109999999999 328.14900000000006 344.96550000000002 Restaurant expenses 42825 42916 43008 43100 43190 43281 43373 43465 95.976000000000013 70.56 71.208000000000013 79.272000000000006 74.016000000000005 75.239999999999995 68.472000000000008 74.016000000000005 Marketing expenses 42825 42916 43008 43100 43190 43281 43373 43465 54.976499999999994 56.429999999999993 49.6755 50.359499999999997 59.251500000000007 56.857500000000002 49.59 53.351999999999997 General and administrative expenses 42825 42916 43008 43100 43190 43281 43373 43465 95.976000000000013 70.56 71.208000000000013 79.272000000000006 74.016000000000005 75.239999999999995 68.472000000000008 74.016000000000005 Depreciation and amortization 42825 42916 43008 43100 43190 43281 43373 43465 63.360000000000007 68.489999999999995 70.92 71.28 71.100000000000051 72.63000000000001 74.52 76.77

Expenses as of Quarter Ending 12/31/2018

12/31/2018

Food and beverage Restaurant labor Restaurant expenses Marketing expenses General and administrative expenses 574.20000000000005 544.221 344.96550000000002 53.351999999999997 74.016000000000005

Revenue

					1	2	3	4	5	6	7	8
				Revenue	3/31/17	6/30/17	9/30/17	12/31/17	3/31/18	6/30/18	9/30/18	12/31/18	Revenue	3/31/17	6/30/17	9/30/17	12/31/17	3/31/18	6/30/18	9/30/18	12/31/18
				Sales	1,754.5	1,740.5	1,691.6	1,913.6	1,900.5	1,847.9	1,769.0	2,013.8	Pasta House Restaurants	924.6	890.9	856.4	965.9	961.0	946.8	898.3	1,017.2
				Pasta House Restaurants	924.6	890.9	856.4	965.9	961.0	946.8	898.3	1,017.2
				Steak Grill Restaurants	392.9	364.1	348.9	407.5	412.4	387.4	371.3	434.9
				Breakfast To Go	128.3	142.5	139.5	148.6	150.4	152.1	137.5	150.1
				Souper Duper Kitchen	113.0	125.6	121.7	130.6	132.5	134.3	129.0	139.3
				Burgers on the Grill	74.7	83.0	96.9	115.3	101.8	88.2	101.3	120.9
				Tacos Tacos Tacos	50.9	56.5	45.9	50.9	55.1	59.3	47.5	51.8
				Sandwiches and Subs	45.8	50.9	52.7	62.2	56.7	51.1	53.3	63.5
				Drinks and Dessert	24.3	27.0	29.6	32.7	30.7	28.7	30.8	36.2
				Total	1,754.5	1,740.5	1,691.6	1,913.6	1,900.5	1,847.9	1,769.0	2,013.8
				# of Restaurants
				Pasta House Restaurants	719	720	722	725	728	729	729	731
				Steak Grill Restaurants	417	417	422	424	428	430	434	435
				Breakfast To Go	119	120	130	131	133	133	134	135
				Souper Duper Kitchen	57	58	58	60	61	62	64	66
				Burgers on the Grill	48	48	48	48	49	49	49	49
				Tacos Tacos Tacos	31	32	33	33	33	34	35	36
				Sandwiches and Subs	35	35	35	35	36	36	36	37
				Drinks and Dessert	15	16	16	16	16	16	17	17
				Total	1,441	1,446	1,464	1,472	1,484	1,489	1,498	1,506
				Average revenue per restaurant
				Pasta House Restaurants	1.3	1.2	1.2	1.3	1.3	1.3	1.2	1.4
				Steak Grill Restaurants	0.9	0.9	0.8	1.0	1.0	0.9	0.9	1.0
				Breakfast To Go	1.1	1.2	1.1	1.1	1.1	1.1	1.0	1.1
				Souper Duper Kitchen	2.0	2.2	2.1	2.2	2.2	2.2	2.0	2.1
				Burgers on the Grill	1.6	1.7	2.0	2.4	2.1	1.8	2.1	2.5
				Tacos Tacos Tacos	1.6	1.8	1.4	1.5	1.7	1.7	1.4	1.4
				Sandwiches and Subs	1.3	1.5	1.5	1.8	1.6	1.4	1.5	1.7
				Drinks and Dessert	1.6	1.7	1.9	2.0	1.9	1.8	1.8	2.1
				Total	11	12	12	13	13	12	12	13
	12/31/18	12/31/18	F / (U)
Revenue	Actuals	Budget	Variance	Var %
Pasta House Restaurants	1,017.2	996.8	20.3	2.0%
Steak Grill Restaurants	434.9	421.8	13.0	3.1%
Breakfast To Go	150.1	130.0	20.1	15.5%
Souper Duper Kitchen	139.3	143.5	(4.2)	-2.9%
Burgers on the Grill	120.9	96.7	24.2	25.0%
Tacos Tacos Tacos	51.8	56.9	(5.2)	-9.1%
Sandwiches and Subs	63.5	63.4	0.1	0.2%
Drinks and Dessert	36.2	37.0	(0.8)	-2.2%
Total	2,013.8	1,946.2	67.6	3.5%

Revenue for Quarter Ending 12/31/2018

Pasta House Restaurants Steak Grill Restaurants Breakfast To Go Souper Duper Kitchen Burgers on the Grill Tacos Tacos Tacos Sandwiches and Subs Drinks and Dessert 924.56999999999994 392.94000000000005 128.25 113.03999999999999 74.7 50.85 45.81 24.3

Revenue by Quarter - All Restaurants

Sales 42825 42916 43008 43100 43190 43281 43373 43465 1754.4599999999998 1740.5100000000002 1691.6400000000003 1913.58 1900.53 1847.8799999999999 1768.95 2013.84

Expense

	1	2	3	4	5	6	7	8
Expense	3/31/17	6/30/17	9/30/17	12/31/17	3/31/18	6/30/18	9/30/18	12/31/18
Food and beverage	501.8	499.7	488.6	543.0	541.5	525.0	507.0	574.2
Restaurant labor	305.2	311.7	319.5	328.0	329.0	325.3	328.1	345.0
Restaurant expenses	96.0	70.6	71.2	79.3	74.0	75.2	68.5	74.0
Marketing expenses	55.0	56.4	49.7	50.4	59.3	56.9	49.6	53.4
General and administrative expenses	96.0	70.6	71.2	79.3	74.0	75.2	68.5	74.0
Depreciation and amortization	63.4	68.5	70.9	71.3	71.1	72.6	74.5	76.8
	Expense	12/31/18
	Food and beverage	574.2
	Restaurant labor	544.2
	Restaurant expenses	345.0
	Marketing expenses	53.4
	General and administrative expenses	74.0
	Depreciation and amortization	76.8
					Monthly Household Budget
				Rent	1,000
				Car payment	300
				Utilities	200
				Groceries	150
				Fun	100
				Gasoline	50

12/31/2018

Food and beverage Restaurant labor Restaurant expenses Marketing expenses General and administrative expenses Depreciation and amortization 574.20000000000005 544.221 344.96550000000002 53.351999999999997 74.016000000000005 76.77

Food and beverage 42825 42916 43008 43100 43190 43281 43373 43465 501.75 499.68000000000006 488.61 542.97 541.53000000000009 524.97 506.96999999999997 574.20000000000005 Restaurant labor 42825 42916 43008 43100 43190 43281 43373 43465 305.24220000000003 311.6961 319.51350000000002 327.96720000000005 328.96709999999985 325.33109999999999 328.149000000000 06 344.96550000000002 Restaurant expenses 42825 42916 43008 43100 43190 43281 43373 43465 95.976000000000013 70.56 71.208000000000013 79.272000000000006 74.016000000000005 75.239999999999995 68.472000000000008 74.016000000000005 Marketing expenses 42825 42916 43008 43100 43190 43281 43373 43465 54.976499999999994 56.429999999999993 49.6755 50.359499999999997 59.251500000000007 56.857500000000002 49.59 53.351999999999997 General and administrative expenses 42825 42916 43008 43100 43190 43281 43373 43465 95.976000000000013 70.56 71.208000000000013 79.272000000000006 74.016000000000005 75.239999999999995 68.472000000000008 74.016000000000005 Depreciation and amortization 42825 42916 43008 43100 43190 43281 43373 43465 63.360000000000007 68.489999999999995 70.92 71.28 71.100000000000051 72.63000000000001 74.52 76.77

Monthly Household Budget

Rent Car payment Utilities Groceries Fun Gasoline 1000 300 200 150 100 50

Expenses by Type 2017 - 2018

Benchmark

Financial Ratios			Restaurant Brands Unlimited
	Industry	IVV(iShares-SP500)
Beta	0.54	1.07	Beta (3Y Monthly)	0.7
ROE	6.82	17.83	Return on Equity (ttm)	9
ROA	5.7	7.21	Return on Assets (ttm)	7.50%
ROI	8.14	11.14
Debt-to-Equity	0.28	0.65			Water Temperature	Seconds
Current Ratio	0.69	1.29			60	50
Cash Flow ($/share)	58.29	1,946.00			70	44
Price to Book	0	5.56			80	42
Price To Sales	1	2.58			90	39
Dividend Yield	0.00%	1.92%	Dividend Yield	2.20%	100	35
					110	33
					120	30
1	7
2	15
3	40
4	30
5	22
				1 = Strongly Disagree
				2 = Disagree
				3 = Neither Agree or Disgree
				4 = Agree
				5 = Strongly Agree

Employee Survey Results

1 2 3 4 5 7 15 40 30 22

Relationship of Water Temperature to Time

for Antacid Tablets to Dissolve

Seconds 60 70 80 90 100 110 120 50 44 42 39 35 33 30

Temperature of Water in Degrees Farenheit

Seconds to Dissolve