Profit center responsibility for a service company Instructions Pront center responsibility tor a service company Red tine Railroad toc, has three regional divisions organized as profit centers. The chief executive officer (CEO) evaluates divisional performance, using in: percent of revenues. The following quarterly income and expense accounts were provided from the trial balance as of December 31 : The compary operates three service departments: Stareholder Relations, Customer Support, and Lefal The Shareholder Relations Department conducts a vari shareholdens of the corapany. The Customer Suppott Departunent is the companys point of contact for new service, comptaints, and requests for repair. The de hours bilied is an activity base for this wonk, The following additionat information fas been pathered: Instructions 1. Piepare quartealy income itatements showing incone from opecations for the thee divisions. Use three column headings, East, West, and Central. 2. Identily the inost successful division according to the profit margin. (Round to the nearest whole percent) To receive o cedit for this assigments students have the following cotions: - Comphete the assignment usine Microsoit Excel - upload an Excel document Use the excel temolate for PR.23-2, \& - Complete the assignment using pencil and paper * upload a POF document. How to sutemit a Canvas Assigrment Canvas Guide