Connedt Excel Assignments Help Save Exit Required informetio

Connedt Excel Assignments Help Save &Exit; Required informetion Chapter 9: Applying Excel [LO9.1, LO9-2. LO9-3, LO9-4) The Chapter 9 Form worksheet is to he used to create your own worksheet version of the Review Problem example in the Chapter 9: Applying Excel: Excel Worksheet (Part 1 of 2) coes Downiond the Applying Excel form and enter formules in all celisthat contain question marks. For example, in cell 830 enter the formua-820 Notes n the text, veriances are always displaved as posithve numbers To accomplish this you can use the ABSi0 urncticon l For example formula in cell C31 would be ABS(E31-B311 O This question will be sent ta your instructor for grading Prev 2 3 3 I Next > e here to search

Solution

Formulas displayed in below :

Dear Student,

Best effort has been made to give quality and correct answer. But if you find any issues please comment your concern. I will definitely resolve your query.

Also please give your positive rating.

	Actual Results	Revenue and Spending Variance	Flexible Budget	Activity Variance	Planning Budget
Meals Served	1,700			1,700			1,800
Revenue	$            30,250	$                      550	F	$                   28,050	$                  1,650	U	$                 29,700
Expesnes:
Cost incredients	$            11,110	$                      140	F	$                   10,625	$                      625	F	$                 11,250
Wages and Salaries	$            10,130	$                      270	F	$                   10,400	$                         -	F	$                 10,400
Utilities	$               1,080	$                        80	F	$                     1,140	$                        20	F	$                   1,160
Rent	$               2,200	$                         -		$                     2,200	$                         -		$                   2,200
Miscellaneous	$               2,240	$                      200	U	$                     1,960	$                        80	F	$                   2,040
Total Expenses	$            26,760	$                      290	F	$                   26,325	$                      725	F	$                 27,050
Net Operating income	$               3,490	$                      840	F	$                     1,725	$                      925	F	$                   2,650