3104 strategic management accounting,
E12.26 Business unit profit statement: service company Bell Electrical Services is organised into three divisions: Metro, Suburban and Regional. Data for these divisions for last year were as follows:
Metro Suburban Regional
service revenue 1900,000 1500,000 70,000
variable expense 300,000 200,000 100,000
Controllable fixed expenses 700,000 540,000 200,000
fixed expenses controllable by others
360,000 300,000 80,000
In addition to the expenses listed above, the company had $90 000 of common fixed expenses. Income tax expense for the year was $490 000.
1 profit statement for Bell Electrical Services using Excel that highlights the profitability/performance of the three business units and the business unit managers. Use the contribution format.
2 Show how the solution will change if the following information changes: the sales revenues were $1 920 000 and $1 560 000 for Metro and Suburban, respectively
ScholarMatic: Explanation & Answer
Your ready answer from a verified tutor is just a click away for as little as $14.99
Click Order Now to get 100% Original Answer Customized to your instructions!
