Chapter 7, Problem 7.7BE

in the “Problems – Series A” section 8-19A of Ch. 8, “Performance Evaluation” of Fundamentals of Managerial Accounting Concepts. Scenario: The Redmond Management Association held its annual public relations luncheon in April Year 2. Based on the previous year’s results, the organization allocated $25,290 of its operating budget to cover the cost of the luncheon. To ensure that costs would be appropriately controlled, you, the treasurer, prepared the following budget for the Year 2 luncheon.   Usin Excel—showing all work and formulas—to complete the following: I need help  Preparing a flexible budget. Computing the sales volume variance and the variable cost volume variances based on a comparison between the master budget and the flexible budget. And Computing flexible budget variances by comparing the flexible budget with the actual results.

I am searching for the accurate solution to this financial accounting problem with the right approach.

Cher Enterprises reported net income of $2,100,000. The average total liabilities were $6,800,000 and the average total stockholders' equity was $7,400,000. Interest expense was $250,000 and the tax rate was 30%. What is the return on assets ratio?