Memo Re: Salem Telephone Company‚ Salem Data Services Accounting Analysis Salem Telephone Company recently established Salem Date Services‚ a computer service subsidiary of the telephone company. The new subsidiary was established in efforts to earn the company increased revenues in order to relieve pressure to increase rates for the regulated telephone company. Salem Data Services accounting has shown profit loss for the subsidiary over the past three months. Peter Flores‚ president of Salem
Premium Variable cost Income statement Costs
Riverbend Telephone Company has determined that they need a new maintenance truck and crew. Looking at the options they obtained 4 bids from truck dealers. They are expecting the truck to have a working life of five years. We looked at both options and believe that purchasing a new truck is the most cost effective when looking at keeping the truck for five years. The best offer for a lease is $7‚200 a year with a total present value of $36‚000. The best offer for purchasing a truck is $24
Premium Price Tax Leasing
revenue hours. All other costs are fixed with respect to revenue hours. With higher fixed cost‚ Salem Data Services has a higher leverage and is therefore riskier. 2. ($7‚896 + $1‚546) / 329 hours = $28.70 / hour. For every hour spent working‚ the company spends 28.70 dollars. 3. Intracompany Commercial Total Number of Hours (a): 205 138 343 Revenue (a x b): $82‚000 $110‚400 $192‚400 Variable Costs (a x c): ($5‚883.50) ($3‚960.60) ($9‚844.10) Contribution Margin: $76‚116.50
Premium Variable cost Costs Management accounting
Case Study #1. Salem Telephone Company 1. Variable expenses: Power (the more hours sold‚ the more energy consumed) The hourly personnel (operations) works only when the computers are in operation Fixed expenses: The rent has to be paid despite any level of production ($8‚000 monthly) The custodial services depend on Salem Telephone’s estimated space‚ they are independent from the revenue of the Company The computer leases were acquired to run the business (before it was actually started
Premium Variable cost Costs Fixed cost
James Whittle Salem Telephone Company Case Study 9/29/2014 1.) The variable costs in Exhibit 2 are Power and Hourly Personnel Wages as the costs fluctuate from month to month and are driven by the revenue hours for the company. The fixed costs in Exhibit 2 are Rent‚ Custodial Services‚ Computer Equipment Leases‚ Computer Maintenance‚ Computer Depreciation‚ Office Equipment and Fixtures Depreciation‚ Salaried Staff Wages‚ Systems Development and Maintenance‚ Administrative Wages‚ Sales Wages
Premium Variable cost Fixed cost Costs
1.) VARIABLE EXPENSES - Power - Operations (hourly personnel) FIXED EXPENSES - Rent - Custodial services - Computer leases - Maintenance - Depreciation - Operations (salaried staff) - Systems development and maintenance - Administration - Sales - Sales promotion - Corporate services 2.) VARIABLE EXPENSES: COST/HOUR JAN. FEB. MAR. Power: 4.7 4.7 4.7 Operations (hourly personnel): 24 24 24 TOTAL: 28.7 28.7 28.7 3.) CONTRIBUTION MARGIN INCOME STATEMENT
Premium Variable cost Management accounting Costs
option3‚ net income will increase to a benefit amount. However‚ if the promotion expense is equal to or less than 1548.72‚ this option should be taken consideration. 6. Based on my analysis above‚ Salem Data Services is a problem to Salem Telephone Company. Firstly‚ Flores should consider the promotion can be the turning point or not. Then decide if he will abort this service. For my consideration‚ I will recommend Flores to abort this unprofitable
Premium Variable cost Income statement Costs
Sales Fixed cost10 Sales promotion Fixed cost11 Corporate services Fixed cost11 1 The rent is a fixed cost because SDS has to pay the rent at Salem Telephone independent how many hours they are selling. That means even if SDS sell nothing the rent has to be paid. 2 The custodial services are fixed cost because they depend on Salem Telephone ’s estimated annual cost per square foot and so they are independent from the revenue of SDS. 3 The computer equipment is a fixed cost due to the fact
Premium Variable cost Costs Fixed cost
Introduction Peter Flores‚ president of Salem Telephone Company (STC) informed the Public Service Commission “that a profitable computer service Subsidiary would reduce pressure for the telephone rate increase.” And a result‚ Salem Data Services (SDS) was established. In 2003‚ SDS has “yet to experience a profitable month” and this induced the meeting between Peter Flores and Cynthia Wu‚ manager of SDS in April 2004. Flores and Wu held different views in regards to SDS; Flores felt SDS was draining
Premium Variable cost Costs Revenue
1697/361=4.7 8664/361=24 =24+4.7=28.7 3. Create a contribution margin income statement for Salem Data Services; Assume that intra company usage is 205 hours‚ Assume commercial usage is at the March Level. Revenue Variable costs Contribution Margin Fixed Costs Operating Income (loss) From the case we know that intracompany work was billed at $400 per hour‚ and commercial sales were billed at $800 per hour. Commercial 138*$800=$110‚400 138*$28.70=$3960.60
Premium Variable cost Costs Management accounting