Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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. 88, 200 WILLIAMS COMPANY Departmental Income Statements For Year Ended December 31, 2019 clock Mirror Combined Sales $ 180,000 $80,000 $ 260,000 Cost of goods sold 49,600 137,800 Gross profit 91,800 30, 400 122,200 Direct expenses Sales salaries 20,500 7,000 27,500 Advertising 1,300 750 2,050 Store supplies used 1,150 650 1,800 Depreciation-Equipment 1,600 550 2,150 Total direct expenses 24,550 8,950 33,500 Allocated expenses Rent expense 7,020 3,780 10,800 Utilities expense 5,850 3,150 9,000 Share of office department expenses 10,500 4,500 15,000 Total allocated expenses 23,370 11,430 34,800 Total expenses 47,920 20,380 68,300 Net income $ 43,880 $ 10,020 53,900 Williams plans to open a third department in January 2020 that will sell paintings. Management predicts that the new department will generate $65,000 in sales with a 55% gross profit margin and will require the following direct expenses: sales salaries, $8,500; advertising, $1,050; store supplies, $750; and equipment depreciation, $450. 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 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 $17,000. Since the Painting department will bring new customers into the store, management expects sales in both the Clock and Mirror departments to increase by 8%. 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.) X Answer is not complete. WILLIAMS COMPANY Forecasted Departmental Income Statements For Year Ended December 31, 2020 Clock Mirror Paintings $ 180,000 $ 80,000 $ 65,000 88,200 X 49,600 x 91,800 30,400 65,000 Combined Sales $ 325,000 X 325,000 Cost of goods sold Gross profit Direct expenses Sales salaries 8,500 7,000 750 OOO Advertising Store supplies used Depreciation of equipment 1,050 20,500 1,300 1,150 X 1,600 24,550 36,000 3,100 2,550 X 2,600 650 750 0X 550 450 Total direct expenses 8,950 10,750 44,250 Allocated expenses Rent expense Utilities expense Share of office dept. expenses Total allocated expenses 3,780 3,150 4,500 0 7,020 X 5,850 10,500 X 23,370 47,920 43,880 $ 0 0 Total expenses 11,430 20,380 10,020 10,750 44,250 Net income $ $ 54,250 $ 280,750
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started