### Raner, Harris, and Chan Consulting Firm Case Study The Raner, Harris and Chan consulting firm specializes in information systems for medical and dental clinics. The firm has two offices— one in Chicago and one in Minneapolis. **Contribution Format Segmented Income Statement for the Most Recent Year:**| | Total Company | Office | |---|---|---|---|---| | | Amount | % | Chicago | Amount | % | Minneapolis | Amount | % | | Sales | $495,000 | 100% | $165,000 | 100% | $330,000 | 100% | | Variable Expenses | $247,500 | 50% | $49,500 | 30% | $198,000 | 60% | | Contribution Margin | $247,500 | 50% | $115,500 | 70% | $132,000 | 40% | | Traceable Fixed Expenses | $188,000 | 38% | $85,000 | 52% | $103,000 | 31% | | Office Segment Margin | $188,000 | 38% | $29,700 | 18% | $79,200 | 24% | | Common Fixed Expenses not Traceable to Offices | $60,900 | 14% || Net Operating Income | $39,600 | 8% |### Future Projections If sales in Chicago increase by $55,000 next year while sales in Minneapolis remain unchanged, with no changes in fixed costs, the following adjustment is required:1. **Compute the New Segmented Income Statement**#### Given Adjustments:- **Chicago Sales Increase**: $55,000- **Fixed Costs** remain the same.**Instruction for Calculation Adjustments**:- **Round intermediate calculations and percentage answers to 1 decimal place** (e.g., 12.3%).- **Round other answers to the nearest whole dollar**.Below is the table template for the new segmented income statement for the company. You can use this template to compute the new projections based on the given data and adjustments.| | Segments | |---|---|---|---|---|

Segment Income Statement: A segmented income statement offers more information by dividing down…

Raner, Harris and 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: Total Company Chicago Minneapolis $ 330,000 Sales Variable expenses Contribution margin Office $ 165,000 100% 49,500 30% 115,500 70% 85,800 52% 18% 100% 198,000 60% 132,000 48% $ 495,000 100% 247,500 58% 247,500 58% 138,600 28% 108,900 22% 69,300 14% $ 39,680 8% Traceable fixed expenses 52,800 16% 24% $ 29,700 $ 79,200 office segment margin Common fixed expenses not traceable to offices Net operating income 3. Assume that sales in Chicago increase by $55,000 next year and that sales in Minneapolis remain unchanged. Assume no change in fixed costs. a. Prepare a new segmented income statement for the company. (Round your Intermediate calculations and percentage answers to 1 decimal place (l.e. 0.1234 should be entered as 12.3 and other answers to the nearest whole dollar.))

Raner, Harris and 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: Total Company Chicago Minneapolis $ 330,000 Sales Variable expenses Contribution margin Office $ 165,000 100% 49,500 30% 115,500 70% 85,800 52% 18% 100% 198,000 60% 132,000 48% $ 495,000 100% 247,500 58% 247,500 58% 138,600 28% 108,900 22% 69,300 14% $ 39,680 8% Traceable fixed expenses 52,800 16% 24% $ 29,700 $ 79,200 office segment margin Common fixed expenses not traceable to offices Net operating income 3. Assume that sales in Chicago increase by $55,000 next year and that sales in Minneapolis remain unchanged. Assume no change in fixed costs. a. Prepare a new segmented income statement for the company. (Round your Intermediate calculations and percentage answers to 1 decimal place (l.e. 0.1234 should be entered as 12.3 and other answers to the nearest whole dollar.))

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Gadubhai
A sada manufacturer has two operating departments. Miong and Botting Mixing has 600 employees and Botting has 400 employees. Office costs of $320,000 are allocated to operating departments based number of employees. The office costs allocated to the Botting department are Murple Choice O O O $90,000 $64,000 $200,000 $192.000
Compute for the total cost per month using costing labor cost by the given data Compute for the percentage weight of the monetary benefit, non monetary benefit, and deferred monetary benefit Compute for the percentage of cost relevant to the sales of total labor cost, given that there are 40 employees in the company and the revenue of the company is 2,500,000 monthly.
Jorgansen Lighting, Incorporated, manufactures heavy-duty street lighting systems for municipalities. The company uses variable costing for internal management reports and absorption costing for external reports to shareholders, creditors, and the government. The company has provided the following data: Year 1 Year 2 Year 3 Inventories Beginning (units) 220 160 180 Ending (units) 160 180 240 Variable costing net operating income $ 290,000 $ 269,000 $ 250,000 The company’s fixed manufacturing overhead per unit was constant at $560 for all three years. Required: 1. Calculate each year’s absorption costing net operating income. (Enter any losses or deductions as a negative value.)
Please help me
Bed & Bath, a retailing company, has two departments-Hardware and Linens. The company's most recent monthly contribution format income statement follows: Total Department Hardware Linens Sales $4,200,000 $3,090,000 $1,110,000 Variable expenses 1,240,000 840,000 400,000 Contribution margin 2,960,000 2,250,000 710,000 Fixed expenses 2,300,000 1,470, 000 830,000 Net operating income (loss) $ 660,000 $ 780,000 $ (120,000) A study indicates that $379,000 of the fixed expenses being charged to Linens are sunk costs or allocated costs that will continue even if the Linens Department is dropped. In addition, the elimination of the Linens Department will result in a 11% decrease in the sales of the Hardware Department. Required: What is the financial advantage ( disadvantage) of discontinuing the Linens Department?
A startup airline company out of Denver established 5 routes to Los Angeles, Las Vegas, Phoenix, Chicago, and Dallas last year and incurred total of $4,200,000 in overhead costs. The company wants to use activity-based method to allocate the indirect cost among the routes. The cost driver is identified as available seat miles (ASM). The following table presents the revenue passenger miles (RPM) and average load factor for each route. The overhead cost allocated to Los Angeles using ASM is nearest to. Route Total RPM Average Load Factor Total ASM Chicago 450,000 75% 600,000 Dallas 574,000 82% 700,000 Los Angeles 630,000 70% 900,000 Las Vegas 595,000 85% 700,000 Phoenix 480,000 80 600,000 Total ASM 3,500,000 O $450,000 $840,000 O $720,000 O $1,080,000
Davenport Incorporated has two divisions, Howard and Jones. The following is the segmented income statement for the past month: Howard Jones Total Sales revenue $ 800,000 $ 600,000 $ 1,400,000 Variable costs 400,000 480,000 880,000 Contribution margin $ 400,000 $ 120,000 $ 520,000 Direct fixed costs 200,000 100,000 300,000 Segment margin $ 200,000 $ 20,000 $ 220,000 Fixed costs (allocated) 150,000 150,000 300,000 Net operating income (loss) $ 50,000 $ (130,000) $ (80,000) What would Davenport's income (loss) be if the Jones Division was dropped?
Bed & Bath, a retailing company, has two departments-Hardware and Linens. The company's most recent monthly contribution format income statement follows: Sales Variable expenses Fixed expenses Contribution margin Net operating income (loss) 1,307,000 Department Total $ 4,210,000 Hardware $ 3,040,000 Linens $ 1,170,000 403,000 767,000 840,000 $ (73,000) 2,903,000 2,290,000 $ 613,000 904,000 2,136,000 1,450,000 $ 686,000 A study indicates that $379,000 of the fixed expenses being charged to Linens are sunk costs or allocated costs that will continue even if the Linens Department is dropped. In addition, the elimination of the Linens Department will result in a 15% decrease in the sales of the Hardware Department. Required: What is the financial advantage (disadvantage) of discontinuing the Linens Department? Financial (disadvantage)
Service Cost Allocation Harley Corp. has two service departments, (Admin Support Dept. & It Support Dept.) and two producing departments (AgencyLine and BancAssure). Provided below are the relevant data: Service Departments Operating Departments Admin Agency Line BancAssure Direct Costs P150,000 P300,000 P5,000,000 P6,000,000 Services by Admin Support 40% 40% 20% Services by IT Support 20% 70% 10% Requirements Prepare a 3 different complete service cost allocation report with details using the following methods: 1. Direct Method IT Services
Bed & Bath, a retailing company, has two departments-Hardware and Linens. The company's most recent monthly contribution format income statement follows: Sales Variable expenses Contribution margin Fixed expenses Net operating income (loss) Total $ 4,310,000 1,313,000 2,997,000 2,200,000 $ 797,000 Department Hardware $ 3,130,000 901,000 2,229,000 1,360,000 $ 869,000 Linens $ 1,180,000 412,000 768,000 840,000 $ (72,000) A study indicates that $377,000 of the fixed expenses being charged to Linens are sunk costs or allocated costs that will continue even if the Linens Department is dropped. In addition, the elimination of the Linens Department will result in a 11% decrease in the sales of the Hardware Department. Required: What is the financial advantage (disadvantage) of discontinuing the Linens Department? Financial (disadvantage)
$516,301 $1,770,842. $571,709 $943,699. $888,291 6