PROBLEM SET B
Problem 22-1B (60 minutes)
Part 1
Average occupancy cost = $465,000 / 20,000 sq. ft. = $23.25 per sq. ft.
These costs are assigned to Style's department as follows
Department / Square Footage / Rate / TotalStyle’s Dept...... / 2,000 / $23.25 / $46,500
Part 2
Market rates are used to allocate occupancy costs for the building rent. Lighting and cleaning costs are allocated to the departments on all three floors at the average rate per square foot. Costs assigned to each class are:
Occupancy Costs / TotalCosts / Value-Based
Costs / Usage-Based
Costs
Building rent...... / $400,000 / $400,000
Lighting expense...... / 25,000 / $25,000
Cleaning expense...... / 40,000 / ______ / 40,000
Totals...... / $465,000 / $400,000 / $65,000
Value-based costs are allocated in two steps
(i) Compute market value of each floor
Floor / Square Footage / Value perSq. Ft. / Total
First floor...... / 7,500 / $40 / $300,000
Second floor...... / 7,500 / 20 / 150,000
Basement floor...... / 5,000 / 10 / 50,000
Total market value...... / $500,000
Problem 22-1B (Continued)
(ii) Allocate the $400,000 to each floor based on its percent of market value
Floor / MarketValue / % of
Total / Allocated
Cost / Cost per
Sq. Ft.
First floor...... / $300,000 / 60% / $240,000 / $32.00
Second floor...... / 150,000 / 30 / 120,000 / 16.00
Basement floor...... / 50,000 / 10 / 40,000 / 8.00
Totals...... / $500,000 / 100% / $400,000
Usage-based costs allocation rate= $65,000 / 20,000 sq. ft.
= $3.25 per sq. ft.
Total allocation rates for the departments on all three floors are
Floor / Value / Usage / TotalFirst floor...... / $32 / $3.25 / $35.25
Second floor...... / 16 / 3.25 / 19.25
Basement floor...... / 8 / 3.25 / 11.25
These rates are applied to allocate occupancy costs to Style’s department
Department / Square Footage / Rate / TotalStyle’s Department......
/ 2,000 / $11.25 / $22,500Part 3
A basement manager would prefer the allocation based on market value. This is a reasonable and logical approach to allocation of occupancy costs. With a flat rate method, all square footage has equal value. This is not logical for this type of occupancy. Less cost would be allocated to the basement departments if the market value method were used.
Problem 22-2B (70 minutes)
BONANZA ENTERTAINMENTForecasted Departmental Income Statements
For Year Ended December 31, 2014
Movies / Video Games / Compact Discs /
Combined
Sales...... / $648,000 / $216,000 / $300,000 / $1,164,000 / (1)
Cost of goods sold...... / 453,600 / 166,320 / 195,000 / 814,920 / (2)
Gross profit...... / 194,400 / 49,680 / 105,000 / 349,080
Direct expenses
Sales salaries...... / 37,000 / 15,000 / 18,000 / 70,000
Advertising...... / 12,500 / 6,000 / 10,000 / 28,500
Store supplies used...... / 4,320 / 1,080 / 2,000 / 7,400 / (3)
Depreciation of equipment..... / 4,500 / 3,000 / 1,200 / 8,700
Total direct expenses...... / 58,320 / 25,080 / 31,200 / 114,600
Allocated expenses
Rent expense...... / 30,750 / 6,000 / 13,250 / 50,000 / (4)
Utilities expense...... / 5,535 / 1,080 / 2,385 / 9,000 / (4)
Share of office dept. expenses. / 47,345 / 15,725 / 21,930 / 85,000 / (5)
Total allocated expenses...... / 83,630 / 22,805 / 37,565 / 144,000
Total expenses...... / 141,950 / 47,885 / 68,765 / 258,600
Net income...... / $ 52,450 / $ 1,795 / $ 36,235 / $ 90,480
Supporting Computations—coded (1) through (5) in statement above
Note 1 (Sales)
Movies / VideoGames / Compact
Discs
2013 sales...... / $600,000 / $200,000
Growth rate (8% increase)..... / x 108% / x 108%
2014 sales...... / $648,000 / $216,000 / $300,000
Note 2 (Cost of Goods Sold)
Movies / VideoGames / Compact
Discs
2013 cost of goods sold...... / $420,000 / $154,000
2013 sales...... / $600,000 / $200,000
2013 cost as % of sales...... / 70% / 77%
2014 sales ...... / $648,000 / $216,000 / $300,000
2014 cost as % of sales ...... / x 70% / x 77% / x 65%*
2014 cost of goods sold...... / $453,600 / $166,320 / $195,000
* The 65% cost of goods sold percent is computed as 100% minus the predicted 35% gross margin.
Problem 22-2B (Continued)
Note 3 (Store Supplies Used)
Movies / VideoGames / Compact
Discs
2013 store supplies used ..... / $ 4,000 / $ 1,000
Growth rate (8% increase)..... / x 108% / x 108%
2014 store supplies ...... / $ 4,320 / $ 1,080 / $ 2,000
Note 4 (Rent and Utilities)
Movies / VideoGames / Compact
Discs
2013 rent ...... / $41,000 / $ 9,000
One-fourth from movies to
compact discs...... /
(10,250) / $10,250
One-third from video games
to compact discs...... / ______ /
(3,000) /
3,000
2014 rent ...... / $30,750 / $ 6,000 / $13,250
Percent of total ...... / 61.5% / 12.0% / 26.5%
2014 allocation of $9,000
total utilities ...... /
$ 5,535 /
$1,080 /
$ 2,385
Note 5 (Office Department Expenses)
Movies / VideoGames / Compact
Discs
2014 sales ...... / $648,000 / $216,000 / $300,000
Percent of total sales* ...... / 55.7% / 18.5%† / 25.8%
2014 allocation of $85,000
total office department
expenses($75,000 in 2013
plus $10,000 increase)...... /
$ 47,345 /
$ 15,725 /
$ 21,930
*Rounded to the nearest 0.1% * If students round to something other than one-tenth of a percent, their numbers will slightly vary.
†Adjusted to eliminate rounding difference.
Problem 22-3B (50 minutes)
Part 1
a.
Responsibility Accounting Performance ReportDept. Manager, Refrigerator Department
For the Month of April
Budgeted / Actual / Over (Under)
Amount / Amount / Budget
Controllable Costs
Raw materials......
/ $400,000 / $385,000 / $(15,000)Employee wages...... / 170,000 / 174,700 / 4,700
Supplies used...... / 15,000 / 14,000 / (1,000)
Depreciation—Equipment...... / 53,000 / 53,000 / 0
Totals...... / $638,000 / $626,700 / $(11,300)
b.
Responsibility Accounting Performance ReportDept. Manager, Dishwasher Department
For the Month of April
Budgeted / Actual / Over (Under)
Amount / Amount / Budget
Controllable Costs
Raw materials......
/ $200,000 / $202,000 / $ 2,000Employee wages...... / 80,000 / 81,500 / 1,500
Supplies used...... / 9,000 / 9,700 / 700
Depreciation—Equipment...... / 37,000 / 37,000 / 0
Totals...... / $326,000 / $330,200 / $4,200
Problem 22-3B (Continued)
c.
Responsibility Accounting Performance ReportPlant Manager, Chicago Plant
For the Month of April
Budgeted / Actual / Over (Under)
Amount / Amount / Budget
Controllable Costs
Dept. manager salaries.... / $ 104,000 / $ 101,500 / $ (2,500)
Utilities...... / 48,000 / 55,200 / 7,200
Building rent...... / 80,000 / 82,300 / 2,300
Other office salaries...... / 40,000 / 35,200 / (4,800)
Other office costs...... / 21,000 / 29,800 / 8,800
Refrigerator department... / 638,000 / 626,700 / (11,300)
Dishwasher department.... / 326,000 / 330,200 / 4,200
Totals...... / $1,257,000 / $1,260,900 / $ 3,900
Part 2
The refrigerator department manager did a good job of controlling costs and meeting the budget, spending $11,300 below budget. However, the dishwasher department did not do such a good job, spending $4,200 above the budgeted amount. The plant manager’s controllable costs would have been under budget by $300 if the Dishwasher department manager’s actual costs had been equal to budgeted costs.
Problem 22-4BB (60 minutes)
Part 1
Allocations of joint cost on the basis of sales values
Land preparation, seeding, and cultivating: $700,000
Grade / SalesValue / Percent of Total / Allocated Cost
No. 1...... / $ 900,000 / 62.5% / $437,500
No. 2...... / 500,000 / 34.7 / 242,900
No. 3...... / 40,000 / 2.8 / 19,600
Total...... / $1,440,000 / 100.0% / $700,000
Harvesting, sorting, and grading: $40,000
Grade / SalesValue / Percent
of Total / Allocated
Cost
No. 1...... / $ 900,000 / 62.5% / $ 25,000
No. 2...... / 500,000 / 34.7 / 13,880
No. 3...... / 40,000 / 2.8 / 1,120
Total...... / $1,440,000 / 100.0% / $ 40,000
Delivery: $17,000 to Grade Nos. 1 & 2
Grade / SalesValue / Percent
of Total / AllocatedCost
No. 1...... / $ 900,000 / 64.3% / $10,931
No. 2...... / 500,000 / 35.7 / 6,069
No. 3 [identified]...... / ______ / ____ / 3,000*
Total...... / $1,400,000 / 100.0% / $20,000
* No. 3 Grade delivery costs are separately identified by the company.
Problem 22-4B (Continued)
Part 2
RITA AND RICK REDDINGIncome Statement
For Year Ended December 31, 2013
No. 1 / No. 2 / No. 3 / Combined
Sales (by grade)
No. 1: 500,000 lbs. @ $1.80..... / $900,000
No. 2: 400,000 lbs. @ $1.25..... / $500,000
No. 3: 100,000 lbs. @ $0.40..... / $40,000
Total sales...... / $1,440,000
Costs
Land preparation, seeding,
and cultivating...... /
437,500 /
242,900 /
19,600 /
700,000
Harvesting, sorting & grading... / 25,000 / 13,880 / 1,120 / 40,000
Delivery...... / 10,931 / 6,069 / 3,000 / 20,000
Total costs...... / 473,431 / 262,849 / 23,720 / 760,000
Net income (loss)...... / $426,569 / $237,151 / $16,280 / $680,000
Part 3
Delivery costs include both crating and hauling costs. The Reddings are able to identify the portion of the cost directly related to the No. 3 tomatoes, presumably because the No. 3s are going to a different destination than the No. 1 and No. 2 tomatoes. If the No. 1s and No. 2s are going to the same place, then the hauling portion of the delivery cost may truly be a joint cost, at least for the No. 1 and No. 2 tomatoes.
However, since the No. 1 and No. 2 tomatoes are different grades and are sold for different prices per pound, it seems safe to assume they are crated separately. If the cost of crating the No. 3 tomatoes can be traced as a direct cost, then it seems the crating costs for the No. 1s and No. 2s should also be identifiable as separate amounts. This means, perhaps, the crating portion of delivery costs is not a true joint cost.
Problem 22-5B (60 minutes)
Part 1
Process time...... / 16.0 hoursInspection time...... / 3.5 hours
Move time...... / 9.0 hours
Wait time...... / 21.5 hours
Manufacturing cycle time...... / 50.0 hours
Part 2
Manufacturing cycle efficiency (16.0 hours/ 50.0 hours)... / 0.32This means that Best Ink is spending 32% of its time in value-added activities, and 68% of its time on non-value-added activities.
Part 3
To increase the manufacturing cycle efficiency to 0.80 Best Ink needs to reduce the total manufacturing cycle time to 20 hours without changing the process time (16 hours/ 0.80 = 20 hours). To do this, they must reduce the 34 hours of non-value added time (3.5 + 9.0 + 21.5) down to 4 hours or less. One way to do this might be to rearrange the manufacturing facility so that materials and work in process do not have to move as far, reducing the move time. In addition, better scheduling and planning may help Best Ink to reduce the wait time.
Problem 22-6B (45 minutes)
Part 1
Sadar Company
Departmental Income Statements
Department
Videos
/Music
Sales......
/$370,500
/$279,500
Cost of goods sold......
/320,000
/175,000
Gross margin......
/50,500
/104,500
Direct expenses
Salaries......
/35,000
/25,000
Maintenance......
/12,000
/10,000
Utilities......
/5,000
/4,500
Insurance......
/4,200
/3,700
Total direct expenses......
/56,200
/43,200
Departmental contribution to overhead......
/(5,700)
/61,300
Allocated indirect expenses
Advertising*......
/8,550
/6,450
Salaries**......
/16,200
/10,800
Office expenses***......
/2,000
/1,200
Total allocated indirect expenses......
/26,750
/18,450
Departmental net income......
/$ (32,450)
/$ 42,850
* / Advertising allocation: / Sales / % / Amount / AllocatedVideos / $370,500 / 57% / $15,000 / $ 8,550
Music / 279,500 / 43% / 15,000 / 6,450
Total / $650,000 / 100% / $15,000
** / Salaries allocation: / Employees / % / Amount / Allocated
Videos / 3 / 60% / $27,000 / $16,200
Music / 2 / 40% / 27,000 / 10,800
Total / 5 / 100% / $27,000
*** / Office expenses allocation: / Sq. ft. / % / Amount / Allocated
Videos / 5,000 / 62.5% / $3,200 / $2,000
Music / 3,000 / 37.5% / 3,200 / 1,200
Total / 8,000 / 100.0% / $3,200
P
Problem 22-6B (Concluded)
Part 2
The video department has both a negative contribution to overhead and a negative departmental net income. It is not even covering its own direct costs, and is therefore not contributing anything to overhead. Before deciding whether to eliminate the video department, Sadar should consider whether any of the direct expenses can be reduced or if the revenues can be increased. Sadar should also consider whether eliminating videos would affect music sales. If expenses cannot be reduced or video sales cannot be increased, and music sales are not affected, Sadar should consider eliminating the video department.
1
©2013 by McGraw-Hill Education. This is proprietary material solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.
Solutions Manual, Chapter 22