Question

Clay Consulting Firm provides three types of client services in three health-care-related industries. The income statement...

Clay Consulting Firm provides three types of client services in three health-care-related industries. The income statement for July is as follows:

Clay Consulting Firm
Income Statement
For Month of July
Sales $ 900,000
Less variable costs (650,000)
Contribution margin 250,000
Less fixed expenses
Service $ 70,000
Selling and administrative 65,000 (135,000)
Net income $ 115,000

The sales, contribution margin ratios, and direct fixed expenses for the three types of services are as follows:

Hospitals Physicians Nursing Care
Sales $ 350,000 $ 250,000 $ 300,000
Contribution margin ratio 25% 35% 25%
Direct fixed expenses of service $ 20,000 $ 18,000 $ 16,000
Allocated common fixed service expenses $ 1,000 $ 1,000 $ 1,500

Prepare income statements segmented by client categories. Include a column for the entire firm in the statement.

Do not use negative signs with your answers.

Clay Consulting Firm
Product and Company Income Statements
For the Month of July
Hospitals Physicians Nursing Care Company Totals
Sales $Answer $Answer $Answer $Answer
Variable costs Answer Answer Answer Answer
Contribution margin Answer Answer Answer Answer
Direct fixed expenses Answer Answer Answer Answer
Product margin Answer Answer Answer Answer
Allocated common costs Answer Answer Answer Answer
Product income $Answer $Answer $Answer Answer
Unallocated common expenses:
Selling and administrative Answer
Service (less direct fixed expenses and allocated common costs) Answer
Total Answer
Net income $Answer

Homework Answers

Answer #1
Clay Consulting Firm
Product and Company Income Statements
For the Month of July
Hospitals Physicians Nursing Care Company Totals
Sales 350000 250000 300000 900000
Variable costs: 262500 162500 225000 650000 (Sales-Contibution Margin)
Contribution margin 87500 87500 75000 250000 (Sales*Contribution Ratio)
Direct fixed expenses 20000 18000 16000 54000
Product margin 67500 69500 59000 196000
Allocated common costs 1000 1000 1500 3500
Product income 66500 68500 57500 192500
Unallocated common expenses:
Selling and administrative 65000
Service (less direct fixed expenses and allocated common costs) 12500 (70000-54000-3500)
Total 77500
Net income 115000
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Income Statements Segmented by Products Clay Consulting Firm provides three types of client services in three...
Income Statements Segmented by Products Clay Consulting Firm provides three types of client services in three health-care-related industries. The income statement for July is as follows: Clay Consulting Firm Income Statement For Month of July Sales $900,000 Less Variable costs (601,000) Contribution Margin 299,000 Less fixed expenses Service 70,000 Selling and administrative 65,000 (135,000) Net income $164,000 The sales, contribution margin ratios, and direct fixed expenses for the three types of services are as follows: Hospitals Physicians Nursing Care Sales...
Keep-or-Drop for Service Firm, Complementary Effects, Traditional Analysis Devern Assurance Company provides both property and automobile...
Keep-or-Drop for Service Firm, Complementary Effects, Traditional Analysis Devern Assurance Company provides both property and automobile insurance. The projected income statements for the two products are as follows: Property Insurance Automobile Insurance Sales $4,200,000   $12,000,000   Less variable expenses 3,830,000   9,600,000      Contribution margin $370,000   $2,400,000   Less direct fixed expenses 400,000   500,000      Segment margin $(30,000)   $1,900,000   Less common fixed expenses (allocated) 100,000   200,000   Operating income (loss) $(130,000)   $1,700,000   The president of the company is considering dropping the property insurance. However, some policyholders...
Hydro Systems Engineering Associates, Inc. provides consulting services to city water authorities. The consulting firm’s contribution-margin...
Hydro Systems Engineering Associates, Inc. provides consulting services to city water authorities. The consulting firm’s contribution-margin ratio is 20 percent, and its annual fixed expenses are $250,000. The firm’s income-tax rate is 35 percent. Required: Calculate the firm’s break-even volume of service revenue. How much before-tax income must the firm earn to make an after-tax net income of $140,000? What level of revenue for consulting services must the firm generate to earn an after-tax net income of $140,000? Suppose the...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices—one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company’s most recent year is given: Office Total Company Chicago Minneapolis Sales $ 450,000 100 % $ 150,000 100 % $ 300,000 100 % Variable expenses 225,000 50 % 45,000 30...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices—one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company’s most recent year is given: Office Total Company Chicago Minneapolis Sales $ 900,000 100.0 % $ 180,000 100 % $ 720,000 100 % Variable expenses 486,000 54.0 % 54,000 30...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices—one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company’s most recent year is given: Office Total Company Chicago Minneapolis Sales $ 462,000 100 % $ 156,000 100 % $ 306,000 100 % Variable expenses 233,000 50 % 49,000 31...
Segmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of...
Segmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of Kirchner Glass Products Division. He has two years to make the division profitable. If the division is still showing a loss after two years, it will be eliminated, and Dantrell will be reassigned as an assistant divisional manager in another division. The divisional income statement for the most recent year is as follows: Sales $4,590,000 Less: Variable expenses 3,953,450 Contribution margin $636,550 Less: Direct...
Clay Inc. has two divisions, Myrtle and Laurel. Following is the income statement for the previous...
Clay Inc. has two divisions, Myrtle and Laurel. Following is the income statement for the previous year: Myrtle Laurel Total Sales $ 562,300 $ 338,600 $ 900,900 Variable Costs 178,600 176,400 355,000 Contribution Margin 383,700 162,200 545,900 Fixed Costs (allocated) 286,875 173,025 459,900 Profit Margin $ 96,825 $ (10,825 ) $ 86,000 What would Clay’s profit margin be if the Laurel division was dropped and all fixed costs are unavoidable?
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices—one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company’s most recent year is given: Office Total Company Chicago Minneapolis Sales $ 637,500 100.0 % $ 127,500 100 % $ 510,000 100 % Variable expenses 344,250 54.0 % 38,250 30...
Consider the following table and prepare a segmented income statement on paper. Use your income statement...
Consider the following table and prepare a segmented income statement on paper. Use your income statement to answer the following questions: What is the contribution margin for Product B? What is the segment margin for Product B? What is the total segment margin?   What is net income?   Product A Product B Units sold 2500 3700 Selling price per unit $36 $18 Variable costs per unit $6 $7 Direct fixed costs per product line $3750 $2035 Allocated common fixed costs per...