Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a contribution margin income statement for Salem Data Services. Assume that intracompany usage is 205 hours. Assume that commercial usage is at the March

Create a contribution margin income statement for Salem Data Services. Assume that intracompany usage is 205 hours. Assume that commercial usage is at the March level.

Exhibit 1 Salem Data Services Summary of Computer Utilization, First Quarter 2004
January February March
Number of weekdays (MF) 22 20 23
X 24 hours per day 528 480 552
Number of Saturdays 5 4 4
X 8 hours per day 40 32 32
Total hours available for revenue 568 512 584
Revenue hours
Intracompany 206 181 223
Commercial 123 135 138
Total revenue hours 329 316 361
Hours available to sell 239 196 223

Exhibit 2 Salem Data Services Summary Results of Operations, First Quarter 2004
January February March
Revenues
Intracompany sales $82,400 $72,400 $89,200
Commercial sales 98,400 108,000 110,400
Total revenue $180,800 $180,400 $199,600
Expenses
Space costs:
Rent $8,000 $8,000 $8,000
Custodial services 1,240 1,240 1,240
9,240 9,240 9,240
Equipment costs
Computer leases 95,000 95,000 95,000
Maintenance 5,400 5,400 5,400
Depreciation:
Computer equipment 25,500 25,500 25,500
Office equipment and fixtures 680 680 680
Power 1,546 1,485 1,697
128,126 128,065 128,277
Wages and salaries
Operations: salaried staff 21,600 21,600 21,600
Operations: hourly personnel 7,896 7,584 8,664
Systems development and maintenance 12,000 12,000 12,000
Administration 9,000 9,000 9,000
Sales 11,200 11,200 11,200
61,696 61,384 62,464
Sales promotion 7,909 7,039 8,083
Corporate services 15,424 15,359 15,236
Total expenses $222,395 $221,087 $223,300
Net income (loss) ($41,595) ($40,687) ($23,700)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Insights Into The Effectiveness Of Internal Audit

Authors: Rainer Lenz

1st Edition

3659852414, 978-3659852411

More Books

Students also viewed these Accounting questions