Problem:
Collosal Enteretainment began operations in January 2009 with two operating (selling) departments and one service (office) department. Its departmental income statements attached.
The company plans to open a third department in January 2010 that will sell compact discs. Management predicts that the new department will generate $450,000 in sales with a 35% gross profit margin and will require the following direct expenses: sales salaries, $27,000; advertising, $15,000; store supplies, $3,000;and equipment depreciation, $1,800. The company will form the new department into the current rented space by taking some square footage from the other two departments. When opened, the new compact disc department will fill one-fourth of the space presently used by the movie department and one-third of the space used by the videogame 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 compact disc departmet to increase total office department expenses by $15,000. Since the compact disc department will bring new customers into the store, management expects sales in both the movie and video game departments to increase 8%. No changes for those departments' gross profit percents or for their direct expenses are expected, except for store supplies used, which will increase in proportion to sales.
Prepare departmental income statements that show the company's predicted results oof operations for calendar year 2010 for the three operating (selling) departments and their combined totals. (Round percent o the nearest one-tenth and dollar amounts to the nearest whole dollar.)
|
|
|
COLLOSAL ENTERTAINMENT |
|
|
|
|
|
|
Departmental Income Statements |
|
|
|
|
|
|
For Year Ended Dec 31, 2009 |
|
|
|
|
|
|
|
Movies |
Video Games |
Combined |
| Sales |
|
|
|
$900,000 |
$300,000 |
$1,200,000 |
| Cost of Goods Sold |
|
|
$630,000 |
$231,000 |
$861,000 |
| Gross Profit |
|
|
$270,000 |
$69,000 |
$339,000 |
| Direct Expenses |
|
|
|
|
|
| Sales salaries |
|
|
$55,500 |
$22,500 |
$78,000 |
| Advertising |
|
|
$18,450 |
$9,000 |
$27,750 |
| Store suppulies used |
|
$6,000 |
$1,500 |
$7,500 |
| Depreciation - Equipment |
|
$6,750 |
$4,500 |
$11,250 |
| Total Direct Expense |
|
$87,000 |
$37,500 |
$124,500 |
| Allocated Expenses |
|
|
|
|
|
| Rent Expense |
|
|
$61,500 |
$13,500 |
$75,000 |
| Utilities Expense |
|
|
$11,070 |
$2,430 |
$13,500 |
| Share of office deprtment expense |
$84,375 |
$28,125 |
$112,500 |
| Total allocated expense |
|
$156,945 |
$44,055 |
$201,000 |
| Total Expenses |
|
|
$243,945 |
$81,555 |
$325,500 |
| Net Income (loss) |
|
|
$26,055 |
($12,555) |
$13,500 |