WILLIAMS COMPANY Forecasted Departmental Income Statements For Year Ended December 31, 2020 Clock Mirror Paintings Combined 0 0 0 0 Direct expenses 0 0 0 Total direct expenses Allocated expenses 0 0 0 0 Total allocated expenses Total expenses 0 0 0 0 $ 0 $ 0 $ 0 $ 0 Problem 09-3A Departmental income statements; forecasts LO P3 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 $ 150,000 $ 85,000 $ 235,000 Cost of goods sold 73,500 52,700 126,200 Gross profit 76,500 32,300 108,800 Direct expenses Sales salaries 21,500 7,200 28,700 Advertising 1,300 800 2,100 Store supplies used 950 600 1,550 Depreciation-Equipment 1,600 200 1,800 Total direct expenses 25,350 8,800 34,150 Allocated expenses Rent expense 7,070 3,960 11,030 Utilities expense 3,100 1,900 5,000 Share of office department expenses 11,500 9,000 20,500 Total allocated expenses 21,670 14,860 36,530 Total expenses 47,020 23, 660 70,680 Net income $ 29,480 $ 8,640 $ 38,120 Williams plans to open a third department in January 2020 that will sell paintings. Management predicts that the new department will generate $55,000 in sales with a 85% gross profit margin and will require the following direct expenses: sales salaries, $7,500; advertising, $1,000; store supplies, $500; and equipment depreciation, $900. It will fit the new 1,300 950 1,600 25, 350 800 600 200 8,800 2,100 1,550 1,800 34, 150 Advertising Store supplies used Depreciation-Equipment Total direct expenses Allocated expenses Rent expense Utilities expense Share of office department expenses Total allocated expenses Total expenses Net income 7,070 3,960 11,030 3,100 1,900 5,000 11,500 9,000 20,500 21,670 14,860 36,530 47,020 23, 660 70,680 $ 29,480 $ 8,640 $ 38,120 Williams plans to open a third department in January 2020 that will sell paintings. Management predicts that the new department will generate $55,000 in sales with a 85% gross profit margin and will require the following direct expenses: sales salaries, $7,500; advertising, $1,000; store supplies, $500; 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 $7,700. Since the Painting department will bring new customers into the store, management expects sales in both the clock and Mirror departments to increase by 7%. 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 2020 for the three operating (selling) departments and their combined totals. (Do not round intermediate calculations. Round your final answers to nearest whole dollar amount.)
