Q. Complete the Expense sheet

Prestige Telephone Company In April 2003, Daniel Rowe, president of Prestige Telephone Company, was preparing for a meeting with Susan Bradley, manager of Prestige Data Services, a company subsidiary. Partial deregulation and an agreement with the state Public Service Commission had permitted Prestige Telephone to establish a computer data service subsidiary to perform data processing for the telephone company and to sell computer service to other companies and organizations. Mr. Rowe had told the commission in 1999 that a profitable computer services subsidiary would reduce pressure for telephone rate increases. However, by the end of 2002 the subsidiary had yet to experience a profitable month. Ms. Bradley felt only more time was needed, but Rowe felt action was necessary to reduce the drain on company resources. Prestige Data Services had grown out of the needs of Prestige Telephone for computer services to plan, control, and account for its own operations in the metropolitan region it served. The realization by Prestige that other businesses in the metropolitan region needed similar services and that centralized service could be provided over telephone circuits suggested that Prestige could sell computer time not needed by telephone operations. In addition, the state Public Service Commission had encouraged all public utilities under its jurisdiction to seek new sources of revenue and profits as a step toward deregulation and to reduce the need for rate increases which higher costs would otherwise bring Because it operated as a public utility, the rates charged by Prestige Telephone Company for telephone service could not be changed without the approval of the Public Service Commission. In presenting the proposal for the new subsidiary, Mr. Rowe had argued for a separate but wholly owned entity whose prices for service would not be regulated. In this way, Prestige could compete with other computer service organizations in a dynamic field; in addition, revenues for use of telephone services might also be increased. The commission accepted this proposal subject only to the restriction that the average monthly charge for service by the subsidiary to the parent not exceed $82,000, the estimated cost of equivalent services used by Prestige Telephone Company in 1999. All accounts of Prestige Data Services were separated from those of Prestige Telephone, and each paid the other for services received from the other. From the start of operations of Prestige Data Services in 2000 there had been problems. Equipment deliveries were delayed. Personnel had commanded higher salaries than expected. And most important, customers were harder to find than earlier estimates had led the company to expect By the end of 2002, when income of Prestige Telephone was low enough to necessitate a report to shareholders revealing the lowest return on investment in seven years, Rowe felt it was time to reassess Prestige Data Services. Susan Bradley had asked for more time, as she felt the subsidiary would be profitable by March. But when the quarterly reports came (Exhibits 1 and 2), Rowe called Bradley to arrange their meeting. Rowe received two reports on operations of Prestige Data Services. The summary of computer utilization (Exhibit 1) summarized the use of available hours of computer time. Service was offered to commercial customers 24 hours a day on weekdays and eight hours on Saturdays Routine maintenance of the computers was provided by an outside contractor who took the computer off-line for eight hours each week for testing and upkeep. The reports for the quarter revealed a persistent problem; available hours, which did not provide revenue, remained high Revenue and cost data were summarized in the quarterly report on results of operations (Exhibit 2). Intracompany work was billed at $400 per hour, a rate based on usage estimates for 2000 and the Public Service Commission's restrictions that cost to Prestige Telephone should not exceed ar average of $82,000 per month. Commercial sales were billed at $800 per hour. While most expenses summarized in the report were self-explanatory, Rowe reminded himself of the characteristics of a few. Space costs were all paid to Prestige Telephone. Prestige Data Services rented the ground floor of a central exchange building owned by the company for $8,000 per month. In addition, a charge for custodial service based on the estimated annual cost per square foot was paid by Data Services, as telephone personnel provided these services. Computer equipment had been acquired by lease and by purchases; leases had four years to run and were noncancelable. Owned equipment was all salable but probably could not bring more than its book value in the used equipment market. Wages and salaries were separated in the report to show the expense of four different kinds of activities. Operating salaries included those of the six persons necessary to run the center around the clock as well as amounts paid hourly help who were required when the computer was ir operation. Salaries of the programming staff who provided service to clients and maintained the operating system were reported as system development and maintenance. Sales personnel, who called upon and serviced present and prospective commercial clients, were also salaried. Because of its relationship with Prestige Telephone, Prestige Data Services was able to avoid many costs an independent company would have. For example, all payroll, billing, collections, and accounting were done by telephone company personnel. For those corporate services, Prestige Data Services paid Prestige Telephone an amount based on wages and salaries each month. Although Rowe was discouraged by results to date, he was reluctant to suggest to Bradley that Prestige Data Services be closed down or sold. The idea behind the subsidiary just seemed to good to give up easily. Besides, he was not sure that the accounting report really revealed the contribution that Data Services was making to Prestige Telephone. In other cases, he felt that the procedures used in accounting for separate activities in the company tended to obscure the costs and benefits they provided. After examining the reports briefly, Rowe resolved to study them in preparation for asking Bradley to estimate the possible effects on profits of increasing the price to customers other than Prestige Telephone, reducing prices, increasing sales efforts and promotion, and of going to two-shif rather than 24-hour operations. Exhibit 1 Prestige Data Services Summary of Computer Utilization, First Quarter 2003 Revenue Hours January February March Intercompany 206 181 223 Commercial 123 135 138 Total revenue hours 329 316 361 Service hours 32 32 40 Available hours 223 164 143 Total hours 584 512 544 Exhibit 2 Prestige Data Services Summary Results of Operations, First Quarter 2003 January February March $82,400 $72,400 $89.200 Revenues Intercompany sales Commercial sales Computer use Other Total revenue Expenses Space costs: Rent Custodial services 98,400 9,241 $190,041 108,000 9,184 $189,584 110,400 12.685 $212.285 $8,000 1.240 9,240 $8,000 1.240 9,240 $8.000 1,240 9,240 95,000 5,400 95,000 5,400 95,000 5,400 Equipment costs Computer leases Maintenance Depreciation: Computer equipment Office equipment and fixtures 25,500 680 1,633 128,213 25,500 680 1,592 128,172 25,500 680 1.803 128.383 Power Wages and salaries Operations Systems development and maintenance Administration Sales Materials Sales promotions Corporate services Total expenses Net Income (loss) 29,496 12,000 9,000 11,200 61,696 9,031 7,909 15,424 $231,513 $(41,472) 29,184 12,000 9,000 11,200 61,384 8,731 7,039 15,359 $229,925 $(40,341) 30,264 12.000 9,000 11.200 62,464/ 10.317 8,083 15,236 $233,723 $(21,438) 4 A BCD E F G H J K L M N 1 equired: 3 4 Using the information from the Analysis worksheet, complete the shaded cells. 7 Prestige Data Services Standard Costs -- Average Month Variable Expenses: per hour per hour Total Variable Expenses per hour per hour Nonvariable Expenses 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Wages and Salaries: Total Wages and Salaries Sales Promotion (assume: programmed cost) 8,000 Total Nonvariable Expenses