Question

In: Accounting

Rx Plus Pharmacy has two major business segments: Retail and Wholesale. In December, the Retail business...

Rx Plus Pharmacy has two major business segments: Retail and Wholesale. In December, the Retail business segment had sales revenues of $2,500,400, contribution margin ratio of 80% and traceable fixed expenses of $1,200,320. During the same month, the Wholesale business segment had sales revenues of $2,960,000, contribution margin ratio of 30% and traceable fixed expenses of $720,000. Common fixed expenses totaled $400,000 and were allocated based on sales (46% to retail, 54% to wholesale)

Required:

a. Prepare a segmented income statement in the contribution format for the company.

b. The CFO thinks that when common fixed expenses are taken into account, the Wholesale segment is losing money. He is contemplating the possibility of closing the Wholesale segment but not before asking for your opinion. What recommendation would you give to the CFO? Please explain.

Solutions

Expert Solution

A. Segmented income statement in the contribution format

Particulars Retail Wholesale
A. Revenue                         25,00,400                                      29,60,000
B. Variable Cost                            5,00,080                                      20,72,000
C. Contribution (A-B)                         20,00,320                                        8,88,000
D. Tracable Fixed Expense                         12,00,320                                        7,20,000
E. Common Fixed Expense                            1,84,000                                        2,16,000
F. Segment Profit (C-E-F)                            6,16,000                                          -48,000

B. Opinion:

We don't Agree with the CFO's opinion of closing the Wholesale segment as though the same is generating loss, but that is after allocation of common fixed expenses of $216,000. This fixed expense would be incurred even if wholesale division is closed. If we see the picture eliminating this fixed cost, then there is net profit of $168,000. Henvce this division should not be closed.


Related Solutions

Camren Corporation has two major business segments-Apparel and Accessories. Data concerning those segments for December appear...
Camren Corporation has two major business segments-Apparel and Accessories. Data concerning those segments for December appear below:   Sales revenues, Apparel $ 717,000   Variable expenses, Apparel $ 397,000   Traceable fixed expenses, Apparel $ 125,000   Sales revenues, Accessories $ 771,000   Variable expenses, Accessories $ 510,000   Traceable fixed expenses, Accessories $ 176,000 Common fixed expenses totaled $181,000 and were allocated as follows: $74,000 to the Apparel business segment and $107,000 to the Accessories business segment. Required: Prepare a segmented income statement in the...
McHale Company does business in two customer segments, Retail and Wholesale. The following annual revenue information...
McHale Company does business in two customer segments, Retail and Wholesale. The following annual revenue information was determined from the accounting system's invoice information: 20Y5 20Y4 Retail $281,820 $268,400 Wholesale 147,576 171,600 Total revenue $429,396 $440,000 Prepare a horizontal analysis of the segments. Round percentages to one decimal place. Enter negative values as negative numbers. McHale Company Horizontal Analysis For the Years 20Y4 and 20Y5 20Y5 20Y4 Difference - Amount Difference - Percent Retail $281,820 $268,400 $ % Wholesale 147,576...
Segment Analysis McHale Company does business in two customer segments, Retail and Wholesale. The following annual...
Segment Analysis McHale Company does business in two customer segments, Retail and Wholesale. The following annual revenue information was determined from the accounting system's invoice information: 20Y5 20Y4 Retail $219,600 $244,000 Wholesale 179,400 156,000 Total revenue $399,000 $400,000 Prepare a horizontal analysis of the segments. Round percentages to one decimal place. Enter negative values as negative numbers. McHale Company Horizontal Analysis For the Years 20Y4 and 20Y5 20Y5 20Y4 Difference - Amount Difference - Percent Retail $219,600 $244,000 $ %...
Walsh Corporation has two major business segments: Consumer and Commercial.
Walsh Corporation has two major business segments: Consumer and Commercial. Data for the segments and for the company for March appear below:Sales revenues, Consumer$680,000Sales revenues, Commercial$280,000Variable expenses, Consumer$394,000Variable expenses, Commercial$143,000Traceable fixed expenses, Consumer$102,000Traceable fixed expenses, Commercial$45,000In addition, common fixed expenses totaled $210,000 and were allocated as follows: $122,000 to the Consumer business segment and $88,000 to the Commercial business segment.A properly constructed segmented income statement in a contribution format would show that the segment margin of the Consumer business segment...
1.) Maurice Corporation has two major business segments; Philippe and Chip. In April, the Philippe business...
1.) Maurice Corporation has two major business segments; Philippe and Chip. In April, the Philippe business segment had sales revenues of $500,000, variable expenses of $280,000, and traceable fixed expenses of $80,000. During the same month, the Chip business segment had sales revenues of $970,000, variable expenses of $514,000, and traceable fixed expenses of $184,000. The common fixed expenses totaled $280,000 and were allocated as follows: $112,000 to the Philippe business segment and $168,000 to the Chip business segment. A...
Glass PLC is a manufacturing company and engaged in the business of wholesale and retail business....
Glass PLC is a manufacturing company and engaged in the business of wholesale and retail business. The following information has been provided for the quarter ended 31st October 2019. 1. Sales to Wholesale shops : Rs. 7,500,000 2. Sales to end customers : Rs. 6,000,000 3. NBT paid on imported raw materials : Rs. 35,000 4. NBT paid on services : Rs. 50,000 Compute the NBT payable for the quarter ended 31st October 2019 B. Explain the different between exempt...
Data for January for Corporation and its two major business segments, North and South, appear below:...
Data for January for Corporation and its two major business segments, North and South, appear below: Sales revenues, North $660,000 Variable expenses, North $383,000 Traceable fixed expenses, North $79,000 Sales revenues, South $510,000 Variable expenses, South $291,000 Traceable fixed expenses, South $66,000 In addition, common fixed expenses totaled $179,000. A properly constructed segmented income statement in a contribution format would show that the net operating income of the company as a whole is:
State two examples of business segments and explain why these would be feasible business segments. You...
State two examples of business segments and explain why these would be feasible business segments. You can use examples from your work or pick a publicly held company and describe the segments that company may have.
Tootsie Roll Industries has two business segments, one for operations in the United States and one...
Tootsie Roll Industries has two business segments, one for operations in the United States and one for operations in Mexico and Canada. The following information (in thousands) comes from a recent annual report. Year 2 Year 1 United States Mexico and Canada United States Mexico and Canada Sales $ 499,660 $ 46,325 $ 487,185 $ 41,184 Net assets 821,335 25,402 832,260 25,740 Net earnings 55,074 1,200 42,554 1,399 Required: a. Find the ROI for each segment for each year. b....
Office Plus is a retail business that sells office equipment, furniture, and supplies. Its credit purchases...
Office Plus is a retail business that sells office equipment, furniture, and supplies. Its credit purchases and purchases returns and allowances for September are shown below. The general ledger accounts and the creditors’ accounts in the accounts payable subsidiary ledger used to record these transactions are also provided. All balances shown are for the beginning of September. GENERAL LEDGER ACCOUNTS 205 Accounts Payable, $28,296 Cr. 501 Purchases 502 Freight In 503 Purchases Returns and Allowances Creditors Name Terms Balance Apex...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT