XL homework

xl.xlsx

Sheet1

Excel Spreadsheet to be submitted	Assignment 1
PLEASE FOLLOW INSRUCTIONS IN DETAIL		Jan	Feb	Mar	Apr	May	Jun	Total
	Income
	Rooms	145,000	187,000	154,000	153,777	123,500	131,200	894,477
1. Complete the missing cells in the income, expense and margin	Telephone	13,400	2,145	16,700	18,799	15,545	16,700	83,289
Rooms Expense is 30% of rooms income	Rental	1,345		1,500	1,432	4,300	2,378	12,408
Telephone expense is 85% of telephone income	Total Income	159,745	190,598	172,200	174,008	143,345	150,278	990,174
Rental expense is 15% of Rental income
	Expense
2. Create Bar chart of total income vs total expense for Jan -Jun	Rooms	43,500	56,100	46,200		37,050	39,360	268,343
	Telephone	11,390	1,823	14,195	15,979	13,213		70,796
3. Create Line chart of rooms income vs. rooms expense for Jan - Jun	Rental	202	218	225	215	645	357	1,861
	Total Expense	55,092	58,141	60,620	62,327	50,908	53,912	341,000
4. Create Pie chart of total rooms income, total telephone income and
total rental income	Margin	104,653	132,457		111,681	92,437	96,366	649,174
	Margin %		69.50%	64.80%	64.18%	64.49%	64.13%	65.56%
Submit by the due date in Campus Crusier
If you cannot do, please email prior to submission date so we can set up time
		Dollars
	Rooms	894477
	Telephone	83289
	Rental	12408