Williams Company began operations in January 2017 with two operating (selling) departments and one service (office) department. Its departmental income statements follow.
Williams plans to open a third department in January 2018 that will sell paintings. Management predicts that the new department will generate $54,000 in sales with a 95% gross profit margin and will require the following direct expenses: sales salaries, $6,500; advertising, $900; store supplies, $600; and equipment depreciation, $900. It will fit the new department into the current rented space by taking some square footage from the other two departments. When opened, the new painting department will fill one-fifth of the space presently used by the clock department and one-fourth used by the mirror department. Management does not predict any increase in utilities costs, which are allocated to the departments in proportion to occupied space (or rent expense). The company allocates office department expenses to the operating departments in proportion to their sales. It expects the painting department to increase total office department expenses by $8,400. Since the painting department will bring new customers into the store, management expects sales in both the clock and mirror departments to increase by 14%. No changes for those departments’ gross profit percents or their direct expenses are expected except for store supplies used, which will increase in proportion to sales.
Required:
Prepare departmental income statements that show the company’s
predicted results of operations for calendar-year 2018 for the
three operating (selling) departments and their combined totals.
(Do not round intermediate calculations. Round your final
answers to nearest whole dollar amount.)
Solution :
Williams Company | ||||
Forecasted Departmental Income statement | ||||
For the year ended Dec 31, 2017 | ||||
Particulars | Clock | Mirror | Paintings | Combined |
Sales | $182,400 | $96,900 | $54,000 | $333,300 |
Cost of goods sold | $89,376 | $60,078 | $2,700 | $152,154 |
Gross Profit | $93,024 | $36,822 | $51,300 | $181,146 |
Direct expenses: | ||||
Sales Salaries | $20,000 | $7,000 | $6,500 | $33,500 |
Advertising | $1,500 | $300 | $900 | $2,700 |
Store supplies used | $570 | $399 | $600 | $1,569 |
Depreciation of equipment | $1,400 | $600 | $900 | $2,900 |
Total direct expenses | $23,470 | $8,299 | $8,900 | $40,669 |
Allocated Expenses: | ||||
Rent expense | $5,648 | $2,655 | $2,297 | $10,600 |
Utilities Expense | $2,611 | $1,227 | $1,062 | $4,900 |
Share of office department expenses | $14,721 | $7,821 | $4,358 | $26,900 |
Total allocated expenses | $22,980 | $11,703 | $7,717 | $42,400 |
Total expenses | $46,450 | $20,002 | $16,617 | $83,069 |
Net Income | $46,574 | $16,820 | $34,683 | $98,077 |
Williams Company began operations in January 2017 with two operating (selling) departments and one service (office)...
Williams Company began operations in January 2015 with two operating (selling) departments and one service (office) department. Its departmental income statements follow. WILLIAMS COMPANY Departmental Income Statements For Year Ended December 31, 2015 Clock Mirror Combined Sales $ 210,000 $ 95,000 $ 305,000 Cost of goods sold 102,900 58,900 161,800 Gross profit 107,100 36,100 143,200 Direct expenses Sales salaries 21,000 6,900 27,900 Advertising 1,700 400 2,100 Store supplies used 1,000 500 1,500 Depreciation—Equipment 1,300 600 1,900 Total direct...
Williams Company began operations in January 2019 with two operating (selling) departments and one service (office) department. Its departmental income statements follow. WILLIAMS COMPANY Departmental Income Statements For Year Ended December 31, 2019 Clock Mirror Combined Sales $ 160,000 $115,000 $275,000 Cost of goods sold 78,400 71,300 149,700 Gross profit 81,600 43,700 125,300 Direct expenses Sales salaries 20,000 7,300 27,300 Advertising 1,700 600 2,300 Store supplies used 550 500 1,050 Depreciation Equipment 1,900 900 Total direct expenses 24,150 9,300 Allocated...
Williams Company began operations in January 2019 with two operating (selling) departments and one service (office) department. Its departmental income statements follow. WILLIAMS COMPANY Departmental Income Statements For Year Ended December 31, 2019 Clock Mirror Combined Sales $ 200,000 $115,000 $ 315,000 Cost of goods sold 98,000 71,300 169,300 Gross profit 102,000 43,700 145,700 Direct expenses Sales salaries 21,000 7,500 28,500 Advertising 1,600 700 2,300 Store supplies used 650 350 1,000 Depreciation-Equipment 1,900 2,100 Total direct expenses 25, 1508,750 33,900...
Williams Company began operations in January 2019 with two operating (selling) departments and one service (Office) department. Its departmental income statements follow. Ship WILLIAMS COMPANY Petang Departmental Income Statements For Year Ended December 31, 2019 Clock Mirror Combined Sales $ 150,000 $115,000 $ 265,000 Cost of goods sold 73,500 71,300 144,800 Gross profit 76,500 43,700 120,200 Direct expenses Sales salaries 21,000 7,100 28,109 Advertising 1,700 300 2,000 Store supplies used 700 550 1,250 Depreciation-Equipment 1,700 900 2,600 Total direct expenses...
Williams Company began operations in January 2019 with two operating (selling) departments and one service office) department. Its departmental Income statements follow. WILLIAMS COMPANY Departmental Income Statements For Year Ended December 31, 2019 Clock Mirror Combined Sales $ 230,00 $ 95,00 $ 325,000 Cost of goods sold 112,780 58,988 171,688 Gross profit 117,380 36,182 153,480 Direct expenses Sales salaries 28.000 8.00€ 28,000 Advertising 1,200 500 1.780 Store Supplies used 950 389 1,250 Depreciation-Equipment 2,100 2.680 Total direct expenses 24,25€ 9,388...
Williams Company began operations in January 2019 with two operating (selling) departments and one service office department. Its departmental income statements follow WILLING COMPANY Departmental Income Statements Loe Year Ended December 31, 2019 Clock Mirror Combined Sales $ 140,000$ 85,000 $225,000 Cost of goods sold 68,600 52,700 121,300 Gross profit 71. 400 32,300 103,706 Direct expenses Sales salaries 22.000 7.300 29, 300 Advertising 2,200 200 2,400 Store supplies used 1.050 700 1,750 Depreciation Equipment 1.900 2,300 Total direct expenses 21.156...
Williams Company began operations in January 2019 with two operating (selling) departments and one service (office) department. Its departmental income statements follow.Williams plans to open a third department in January 2020 that will sell paintings. Management predicts that the new department will generate $50,000 in sales with a 55% gross profit margin and will require the following direct expenses: sales salaries, $8,000; advertising, $800; store supplies, $500; and equipment depreciation, $200. It will fit the new department into the current...
Williams Company began operations in January 2019 with two operating (selling) departments and one service office) department. Its departmental income statements follow. WILLIAMS COMPANY Departmental Income Statements For Year Ended December 31, 2019 Clock Mirror Combined Sales $ 170,000 $105,000 $275,000 Cost of goods sold 83,300 65,100 148,400 Gross profit 86,700 39,900 126,600 Direct expenses Sales salaries 21,000 7,900 28,900 Advertising 1,200 600 1,800 Store supplies used 1,050 450 1,500 Depreciation-Equipment 2,000 700 2,700 Total direct expenses 25, 250 9,650...
Williams Company began operations in January 2019 with two operating (selling) departments and one service office) department. Its departmental income statements follow. WILLIAMS COMPANY Departmental Income Statements For Year Ended December 31, 2019 Clock Mirror Combined Sales $140,000 $125,000 $265,000 Cost of goods sold 68,600 77,500 146, 100 Gross profit 71,400 47,500 118,900 Direct expenses Sales salaries 20,500 8,600 29,100 Advertising 1,300 900 2,200 Store supplies used 600 1,000 Depreciation-Equipment 1,400 400 1,800 Total direct expenses 23,800 10,300 34,100 Allocated...
Williams Company began operations in January 2019 with two operating (selling) departments and one service (office) department. Its departmental income statements follow. WILLIAMS COMPANY Departmental Income Statements For Year Ended December 31, 2019 Clock Mirror Combined Sales $ 220,000 $ 85,000 $ 305,000 Cost of goods sold 107,800 52,700 160,500 Gross profit 112,200 32,300 144,500 Direct expenses Sales salaries 21,000 6,800 27,800 Advertising 1,200 600 1,800 Store supplies used 950 450 1,400 Depreciation—Equipment 1,600 400 2,000 Total direct expenses 24,750...