MUST USE EXCEL!

5. What net operating income would appear in Adgers flexible budget for May?

6. What is Adgers revenue 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.)

7. What is Adgers 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 (i.e., zero variance). Input all amounts as positive values.)

8. What is Adgers 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.)

9. What is Adgers 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 (i.e., zero variance). Input all amounts as positive values.)

10. What amount of revenue would be included in Adgers planning budget for May?

11. What amount of employee salaries and wages would be included in Adgers planning budget for May?

12. What amount of travel expenses would be included in Adgers planning budget for May?

13. What amount of other expenses would be included in Adgers planning budget for May?

14. What activity variance would Adger report in May with respect to its revenue? (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.)

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 (i.e., zero variance). Input all amounts as positive values.) --> employee salaries and wages, travel expenses, and other expenses.

PLEASE USE EXCEL AND SHOW FORMULAS!

Required information The following information applies to the questions displayed belowj Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and varlable cost estimates that It uses for budgeting purposes and the actual results for May as shown below Fixed Element Variable Element per Customer Served S 5,500 $ 2,000 S 510 Actual Total for May S 204,000 137,900 S 17,500 S 36,200 per Nonth S 59,000 S 38,000 Revenue Employee salaries and wages Travel expenses other expenses When preparing its planning budget the company estimated that It would serve 35 customers per month; however, during May the company actually served 40 customers