3 Given the Master Budget for Alcalde LLC and the period's actual results, calculate all amounts for the Flexible Budget in the following Performance Report: 5 6 7 Budgeted Performance Report Sales volume (cases) Actual 13,200 Flexible Master 13,200 12,000 10 Sales revenue ($26/case) $338,200 $343,200 $312,000 11 Less: Variable expenses: 12 Sales expense ($2/case) 24,500 26,400 24,000 13 Shipping expense ($5/case) 65,500 66,000 60,000 14 Contribution Margin $248,200 $228,000 $228,000 15 Less: Fixed expenses: 16 Salaries 17 Office rent 19 Operating Income 12,200 3,500 $232,500 19 20 21 3,500 $213,700 Given the following data, calculate ROI and residual income for all three divisions of a sports performance company. The company's minimum acceptable rate of return is 25%. 13,200 3,500 10,800 22 23 24 25 Division 1 Operating Income $1,044,000 Assets Sales Revenue Current Liabilities Residual ROI Income $4,500,000 $5,800,000 26 Division 2 1,584,000 6,400,000 8,800,000 $450,000 700,000 27 28 Is either company generating an acceptable level of income? 29