Please show cell formulas used to get the answer. Also, please answer all questions posted. Thanks!

Required information (The following information applies to the questions displayed below.) Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Fixed Element Variable Element Actual per per Customer Total Month Served for May $ 5,800 $ 184,000 $ 65,000 $ 1,200 $ 105,300 $ 570 $ 16,500 $ 44,000 $ 41,600 Revenue Employee salaries and wages Travel expenses Other expenses When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers, Required: 1. What amount of revenue would be included in Adger's flexible budget for May? Amount of revenue included in the flexible budget Required information (The following information applies to the questions displayed below.) Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Revenue Employee salaries and wages Travel expenses Other expenses Fixed Element Variable Element per per Customer Month Served $ 5,800 $ 65,000 $ 1,200 $ 570 $ 44,000 Actual Total for May $ 184,000 $ 105,300 $ 16,500 $ 41,600 When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers 2. What amount of employee salaries and wages would be included in Adger's flexible budget for May? Amount of employee salaries and wages included in the flexible budget Required information [The following information applies to the questions displayed below.) Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Fixed Element Variable Element Actual per per Customer Total Month Served for May $ 5,800 $ 184,000 $ 65,000 $ 1,200 $ 105,300 $ 570 $ 16,500 $ 44,000 $ 41,600 Revenue Employee salaries and wages Travel expenses Other expenses When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers. 3. What amount of travel expenses would be included in Adger's flexible budget for May? Amount of travel expenses included in the flexible budget Required information [The following information applies to the questions displayed below. Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: per Fixed Element Variable Element per Customer Month Served $ 5,800 $ 65,000 $ 1,200 $ 570 $ 44,000 Actual Total for May $ 184,000 $ 105,300 $ 16,500 $ 41,600 Revenue Employee salaries and wages Travel expenses Other expenses When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers. 4. What amount of other expenses would be included in Adger's flexible budget for May? Amount of other expenses Required information [The following information applies to the questions displayed below.) Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Fixed Element Variable Element Actual per per Customer Total Month Served for May $ 5,800 $ 184,000 $ 65,000 $ 1,200 $ 105,300 $ 570 $ 16,500 $ 44,000 $ 41,600 Revenue Employee salaries and wages Travel expenses Other expenses When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers. 5. What net operating income would appear in Adger's flexible budget for May? Net operating income Required information [The following information applies to the questions displayed below) Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Fixed Element Variable Element per per Customer Month Seryed $ 5,800 $ 65,000 $1,200 $ 570 $ 44,000 Actual Total for May $ 184,000 $ 105,300 $ 16,500 $ 41,600 Revenue Employee salaries and wages Travel expenses other expenses When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers. 6. What is Adger's revenue variance for May? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (1.e., zero variance). Input all amounts as positive values.) Revenue variance Required information [The following information applies to the questions displayed below.) Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Tixed Element Variable Element per per Customer Month Served $ 5,800 $ 65,000 $ 1.200 $ 570 $ 46,000 Actual Total for May $ 184,000 $ 105,300 $ 16,500 $ 41,600 Revenue Employee salaries and wagen Travel expenses Other expenses When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers 7. What is Adger's employee salaries and wages spending variance for May? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (ie, zero variance), Input all amounts as positive values.) Spending vanance Required information [The following information applies to the questions displayed below] Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Fixed Element Variable Element per per Customer Month Served $ 5,800 $ 65,000 $ 1,200 $ 570 $.44,000 Revenue Employee salaries and wages Travel expenses Other expenses Actual Total for May $ 184,000 $ 105,300 $ 16,500 $ 41,600 When preparing Its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers. 8. What is Adger's travel expenses spending variance for May? (Indicate the effect of each variance by selecting "F" for favorable. "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.) Spending variance Required information [The following information applies to the questions displayed below) Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Taxed Element Variable Element per per Customer Month Served $ 5,800 $ 65,000 $ 1,200 $ 570 $ 44,000 Actual Total for May $184,000 $ 105,300 $ 16,500 $ 41,600 Revenge Employee salaries and wagen Travel expenses Other expenses When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers 9. What is Adger's other expenses spending variance for May? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (.o., zero variance). Input all amounts as positive values.) Spending variance Required information [The following information applies to the questions displayed below) Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Fixed Element Variable Element per per Customer Month Served $ 5,800 $ 65,000 $ 1,200 5570 $44,000 Actual Total tor May $ 184,000 $ 105,300 $ 16,500 $ 41,600 Revenue Employee salaries and wages Travel expenses Other expenses When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers 10. What amount of revenue would be included in Adger's planning budget for Moy? Amount of revenue included in the planning budget Required information [The following information applies to the questions displayed below.) Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Fixed Element Variable Element per per Customer Month Served $ 5,800 $ 65,000 $ 1,200 $ 570 5.44.000 Actual Total for May $ 184,000 $ 105,300 $ 16,500 $ 41,600 Revenue Employee salaries and wagen Travel expenses other expenses When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers. 11. What amount of employee salaries and wages would be included in Adger's planning budget for May? Amount of employees salaries and wages included in the planning budget Required information [The following information applies to the questions displayed below.) Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Fixed Element Variable Element per per Customer Month Served $ 5,800 $ 65,000 $1,200 $ 570 $44,000 Actual Total for May $184,000 $ 105,300 $ 16,500 $ 41,600 Revenue Employee salaries and wages Travel expenses other expenses When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers. 12. What amount of travel expenses would be included in Adger's planning budget for May? Amount of travel expenses included in the planning budget Required information [The following information applies to the questions displayed below.) Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Fixed Element Variable Element per per Customer Month Served $ 5,800 $ 65,000 $ 1,200 $ 570 $ 44,000 Actual Total for May $ 184,000 $ 105,300 $ 16,500 $ 41,600 Revenue Employee salaries and wages Travel expenses other expenses When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers 13. What amount of other expenses would be included in Adger's planning budget for May? Amount of other expenses Required information [The following information applies to the questions displayed below.) Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Tixed Element Variable Element Actual per per Customer Total Month Served for May $ 5,800 $ 184,000 $ 65,000 $ 1,200 $ 105,300 $ 570 $ 16,500 $ 44,000 $ 41,600 Revenue Employee salaries and wages Travel expenses other expenses When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers, 14. What activity variance would Adger report in May with respect to its revenue? (Indicate the effect of each variance by selecting "P" for favorable, "U" for unfavorable, and "None" for no effect (e., zero variance), Input all amounts as positive values.) Activity variance Required information [The following information applies to the questions displayed below.) Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Fixed Element Variable Element per per Customer Month Served $ 5,800 $ 65,000 $ 1,200 $ 570 $ 44,000 Actual Total for May $ 184,000 $ 105,300 $ 16,500 $ 41,600 Revenue Employee salaries and wagen Travel expenses Other expenses When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers 15. What activity variances would Adger report with respect to each of its expenses for May? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (.e., zero variance), Input all amounts as positive values.) Activity Variance Employee salaries and wages Travel expenses Other expenses