Question

In: Accounting

Required information Problem 23-6A Analysis of possible elimination of a department LO A1 [The following information...

Required information

Problem 23-6A Analysis of possible elimination of a department LO A1

[The following information applies to the questions displayed below.]

Elegant Decor Company’s management is trying to decide whether to eliminate Department 200, which has produced losses or low profits for several years. The company’s 2017 departmental income statements shows the following.

ELEGANT DECOR COMPANY
Departmental Income Statements
For Year Ended December 31, 2017
Dept. 100 Dept. 200 Combined
Sales $ 447,000 $ 281,000 $ 728,000
Cost of goods sold 269,000 210,000 479,000
Gross profit 178,000 71,000 249,000
Operating expenses
Direct expenses
Advertising 16,000 11,500 27,500
Store supplies used 5,500 5,200 10,700
Depreciation—Store equipment 4,600 3,100 7,700
Total direct expenses 26,100 19,800 45,900
Allocated expenses
Sales salaries 65,000 39,000 104,000
Rent expense 9,470 4,720 14,190
Bad debts expense 9,700 7,500 17,200
Office salary 18,720 12,480 31,200
Insurance expense 2,300 1,500 3,800
Miscellaneous office expenses 2,400 1,800 4,200
Total allocated expenses 107,590 67,000 174,590
Total expenses 133,690 86,800 220,490
Net income (loss) $ 44,310 $ (15,800 ) $ 28,510


In analyzing whether to eliminate Department 200, management considers the following:

The company has one office worker who earns $600 per week, or $31,200 per year, and four sales clerks who each earn $500 per week, or $26,000 per year for each salesclerk.

The full salaries of two salesclerks are charged to Department 100. The full salary of one salesclerk is charged to Department 200. The salary of the fourth clerk, who works half-time in both departments, is divided evenly between the two departments.

Eliminating Department 200 would avoid the sales salaries and the office salary currently allocated to it. However, management prefers another plan. Two salesclerks have indicated that they will be quitting soon. Management believes that their work can be done by the other two clerks if the one office worker works in sales half-time. Eliminating Department 200 will allow this shift of duties. If this change is implemented, half the office worker’s salary would be reported as sales salaries and half would be reported as office salary.

The store building is rented under a long-term lease that cannot be changed. Therefore, Department 100 will use the space and equipment currently used by Department 200.

Closing Department 200 will eliminate its expenses for advertising, bad debts, and store supplies; 66% of the insurance expense allocated to it to cover its merchandise inventory; and 24% of the miscellaneous office expenses presently allocated to it.

Problem 23-6A Part 1

Required:
1. Complete the following report showing total expenses, expenses that would be eliminated by closing Department 200 and the expenses that would continue. The statement should reflect the reassignment of the office worker to one-half time as salesclerk.

Solutions

Expert Solution

Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you.
Analysis of Expenses under Elimination of Department 200
Total Expense Eliminated Expnese Continuing Expense
Cost of Goods Sold $         479,000 $                    210,000 $                     269,000
Direct Expenses:
Advertising $           27,500 $                       11,500 $                       16,000
Store supplies used $           10,700 $                         5,200 $                         5,500
Depreciation—Store equipment $             7,700 $                         7,700
Allocated expenses:
Sales salaries 52000 will be eliminated,15600(31200/2) will be reclassed to Sale from Office $         104,000 $                       39,000 $                       65,000
Rent expense $           14,190 $                       14,190
Bad debts expense $           17,200 $                         7,500 $                         9,700
Office salary 31200/2 $           31,200 $                               -   $                       31,200
Insurance expense 1500*66% $             3,800 $                            990 $                         2,810
Miscellaneous office expenses 1800*24% $             4,200 $                            432 $                         3,768
Total Expenses $         699,490 $                    274,622 $                     424,868

Related Solutions

Required information Problem 17-5A Comparative ratio analysis LO A1, P3 [The following information applies to the...
Required information Problem 17-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows. Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 800,000 $ 912,200 Cash $ 18,000 $ 34,000 Cost of goods sold 596,100 650,500 Accounts receivable, net 37,400 56,400 Interest expense...
Required information Problem 05-4A Break-even analysis; income targeting and forecasting LO C2, P2, A1 [The following...
Required information Problem 05-4A Break-even analysis; income targeting and forecasting LO C2, P2, A1 [The following information applies to the questions displayed below.] Astro Co. sold 19,200 units of its only product and incurred a $43,072 loss (ignoring taxes) for the current year, as shown here. During a planning session for year 2020’s activities, the production manager notes that variable costs can be reduced 50% by installing a machine that automates several operations. To obtain these savings, the company must...
Required information Problem 9-5A Computing and analyzing times interest earned LO A1 [The following information applies...
Required information Problem 9-5A Computing and analyzing times interest earned LO A1 [The following information applies to the questions displayed below.] Shown here are condensed income statements for two different companies (assume no income taxes). Miller Company Sales $ 1,000,000 Variable expenses (80%) 800,000 Income before interest 200,000 Interest expense (fixed) 60,000 Net income $ 140,000 Weaver Company Sales $ 1,000,000 Variable expenses (60%) 600,000 Income before interest 400,000 Interest expense (fixed) 260,000 Net income $ 140,000 Problem 9-5A Part...
Problem 23-2A Preparation and analysis of a flexible budget performance report LO P1, P2, A1 Phoenix...
Problem 23-2A Preparation and analysis of a flexible budget performance report LO P1, P2, A1 Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 18,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 4,050,000 Cost of goods sold Direct materials $ 990,000 Direct labor 270,000 Machinery repairs (variable cost) 72,000 Depreciation—Plant equipment (straight-line) 315,000 Utilities ($54,000 is variable) 214,000 Plant management...
Problem 23-2A Preparation and analysis of a flexible budget performance report LO P1, P2, A1 Phoenix...
Problem 23-2A Preparation and analysis of a flexible budget performance report LO P1, P2, A1 Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 16,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,200,000 Cost of goods sold Direct materials $ 960,000 Direct labor 240,000 Machinery repairs (variable cost) 48,000 Depreciation—Plant equipment (straight-line) 315,000 Utilities ($32,000 is variable) 182,000 Plant management...
Problem 23-5A Analysis of sales mix strategies LO A1 Edgerron Company is able to produce two...
Problem 23-5A Analysis of sales mix strategies LO A1 Edgerron Company is able to produce two products, G and B, with the same machine in its factory. The following information is available. Product G Product B Selling price per unit $ 132 $ 160 Variable costs per unit 50 96 Contribution margin per unit $ 82 $ 64 Machine hours to produce 1 unit 0.4 hours 1.0 hours Maximum unit sales per month 600 units 150 units The company presently...
Required information Problem C-1A Applying activity-based costing LO P1, P2, A1, [The following information applies to...
Required information Problem C-1A Applying activity-based costing LO P1, P2, A1, [The following information applies to the questions displayed below.] Craftmore Machining produces machine tools for the construction industry. The following details about overhead costs were taken from its company records. Production Activity Indirect Labor Indirect Materials Other Overhead Grinding $ 330,000 Polishing $ 135,000 Product modification 500,000 Providing power $ 255,000 System calibration 590,000 Additional information on the drivers for its production activities follows. Grinding and Polishing 9,000 machine...
Problem 13-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed...
Problem 13-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows.    Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 770,000 $ 880,200 Cash $ 19,500 $ 34,000 Cost of goods sold 585,100 632,500 Accounts receivable, net 37,400 57,400 Interest expense 7,900...
Problem 13-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed...
Problem 13-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows.    Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 770,000 $ 880,200 Cash $ 19,500 $ 34,000 Cost of goods sold 585,100 632,500 Accounts receivable, net 37,400 57,400 Interest expense 7,900...
Problem 13-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed...
Problem 13-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows.    Barco Company Kyan Company Barco Company Kyan Company   Data from the current year-end balance sheets Data from the current year’s income statement   Assets Sales $ 770,000    $ 880,200      Cash $ 19,500     $ 34,000 Cost of goods sold 585,100    632,500      Accounts receivable, net...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT