Solution Manual09
Solution Manual09
Solution Manual09
97,500 120,000
From January sales on account ............... 20,000** 26,000 32,000
Total cash receipts .................................... $ 102,125 $130,625 $159,125
*$7,125 = $190,000 .25 .15
= $5.00
...............................................
270,000
297,000
326,700
893,700
Total cash receipts ............................... $413,000 $454,300 $499,730 $1,367,030
*10% of current month's credit sales.
The desired ending inventory for the quarter is equal to the desired ending inventory
on March 31, 20x1.
**The beginning inventory for the quarter is equal to the December ending inventory.
McGraw-Hill/Irwin 2002 The McGraw-Hill Companies, Inc.
9-42 Solutions Manual
PROBLEM 9-48 (CONTINUED)
4. Cash disbursements budget:
20x1
January
February
March
First
Quarter
Inventory purchases:
Cash payments for purchases
during the current month* ........
$129,360
$142,296
$149,072
$ 420,728
Cash payments for purchases
during the preceding
month
.......................................
176,400
194,040
213,444
583,884
Total cash payments for
inventory purchases .......................
$305,760
$336,336
$362,516
$1,004,612
Other expenses:
Sales salaries .................................. $ 21,000 $ 21,000 $ 21,000 $ 63,000
Advertising and promotion ............ 16,000 16,000 16,000 48,000
Administrative salaries ................... 21,000 21,000 21,000 63,000
Interest on bonds** ......................... 15,000 -0- -0- 15,000
Property taxes** .............................. -0- 5,400 -0- 5,400
Sales commissions......................... 4,400 4,840 5,324 14,564
Total cash payments for other
expenses .........................................
$ 77,400
$ 68,240
$ 63,324
$ 208,964
Total cash disbursements ................... $383,160 $404,576 $425,840 $ 1,213,576
*40% of current months' purchases [see requirement (3)].
.................. 676,000
Total assets ................................................................................................... $1,247,664
Accounts payable** ....................................................................................... $ 223,608
Bond interest payable ................................................................................... 5,000
Property taxes payable ................................................................................. 900
Bonds payable (10%; due in 20x6) ............................................................... 300,000
Common Stock .............................................................................................. 500,000
Retained earnings ......................................................................................... 218,156
Total liabilities and stockholders' equity ..................................................... $ 1,247,664
*Accounts receivable, 12/31/x0 .................................................................... $ 270,000
Sales on account [see req. (1)] ..................................................................... 1,092,300
Total cash collections from credit sales
($109,230 + $893,700) ................................................................................
(1,002,930 )
Accounts receivable, 3/31/x1 ........................................................................ $ 359,370
\
|
|
.
|
\
|
+
|
|
.
|
\
|
|
|
|
|
|
.
|
\
|
unit
per cost
holding
annual
2
quantity order
order
per cost
quanity
order
t requiremen
annual
2. Economic order quantity =
unit per cost holding annual
order) per t)(cost requiremen (2)(annual
=
$4
($150) (2)(4,800)
=
360,000 = 600
3. Using the formula given for requirement (1):
Total annual cost of ordering
and storing XL-20
= ( ) ( ) $4
2
600
$150
600
4,800
|
.
|
\
|
+
|
.
|
\
|
= $2,400
Note that this cost does not include the actual cost of XL-20 purchases (i.e., the
quantity puchased multiplied by the price).
4. Orders per year:
Number of orders per year = 8
600
4,800
quantity order
t requiremen annual
= =
5. Using the new cost data:
a. EOQ =
unit per cost holding annual
order) per (cost t) requiremen (annual (2)
=
$19.20
($20) (2)(4,800)
= 10,000 = 100
McGraw-Hill/Irwin 2002 The McGraw-Hill Companies, Inc.
Managerial Accounting, 5/e 9-47
PROBLEM 9-49 (CONTINUED)
b. Number of orders per year =
100
4,800
quantity order
t requiremen annual
=
= 48
PROBLEM 9-50 (20 MINUTES)
1. Tabulation of inventory ordering and holding costs:
Order size
400 600 800
Number of orders
(4,800 order size) .................................
12
8
6
Ordering cost
($150 number of orders) .....................
$1,800
$1,200
$900
Average inventory
(order size 2) ........................................
200
300
400
Holding costs
($4 average inventory) ........................
$800
$1,200
$1,600
Total annual costs (ordering
costs + holding costs) ............................
$2,600
$2,400
$2,500
minimum
2. The tabular method is cumbersome and does not necessarily identify the optimal
order quantity. If the optimal order quantity does not happen to be selected as one of
the order quantities for the tabular analysis, an order quantity other than those
included in the table will be the least-cost order quantity.
McGraw-Hill/Irwin 2002 The McGraw-Hill Companies, Inc.
9-48 Solutions Manual
PROBLEM 9-51 (25 MINUTES)
Graphical analysis of economic order quantity:
Total annual cost
Holding costs
Ordering costs
Order quantity
200 400 600 800 1,000
Economic order quantity (EOQ)
Total annual cost
$3,500
$3,000
$2,500
$2,000
$1,500
$1000
$500
Minimum
cost
-
-
-
-
-
-
-
-
McGraw-Hill/Irwin 2002 The McGraw-Hill Companies, Inc.
Managerial Accounting, 5/e 9-49
PROBLEM 9-52 (35 MINUTES)
1. Reorder point:
Monthly usage =
12
usage annual
=
canisters 400
12
4,800
=
Usage during
1-month
lead time
= 400 canisters
Reorder point = 400 canisters
The chemical XL-20 should be ordered in the economic order quantity of 600 canisters
when the inventory level falls to 400 canisters. In the one month it takes to receive the
order, those 400 canisters will be used in production.
McGraw-Hill/Irwin 2002 The McGraw-Hill Companies, Inc.
9-50 Solutions Manual
PROBLEM 9-52 (CONTINUED)
2. Graph of usage, lead time and reorder point:
Quantity (canisters)
of XL-20
Usage of
XL-20
Time
Denotes
1 month
Order
received
1 month
lead time
Reorder point, when
inventory equals 400
canisters. Order EOQ
of 600 canisters.
200
400
600
McGraw-Hill/Irwin 2002 The McGraw-Hill Companies, Inc.
Managerial Accounting, 5/e 9-51
PROBLEM 9-52 (CONTINUED)
3. Safety stock and new reorder point:
Monthly usage of XL-20 fluctuates between 300 and 500 canisters. Although average
monthly usage still is 400 canisters, there is the potential for an excess range of 100
canisters in any particular month. The safety stock of XL-20 is equal to the potential
excess monthly usage of 100 canisters. With a safety stock of 100 canisters, the
reorder point is 500 canisters (400 + 100). The materials and parts manager should
order the EOQ of 600 canisters when the inventory of XL-20 falls to 500 canisters.
During the one-month lead time, another 300 to 500 canisters of XL-20 will be used in
production.
PROBLEM 9-53 (45 MINUTES)
1. The ordering cost per order is composed of the following costs:
Inspection fee ............................................................................................... $ 75.00
Direct labor: receiving clerk (8 hours $9.00) ........................................... 72.00
Variable overhead (8 hours $2.50) ........................................................... 20.00
Processing cost* .......................................................................................... 5.80
Total ordering cost per order ...................................................................... $172.80
*Processing cost per order =
orders of number in change
cost ordering in change
=
15 95
$11,900 $12,300
=
80
$400
= $5.00
Recognition of 16% cost increase = $5.00 1.16
= $5.80
McGraw-Hill/Irwin 2002 The McGraw-Hill Companies, Inc.
9-52 Solutions Manual
PROBLEM 9-53 (CONTINUED)
2. The storage cost per windshield is composed of the following costs:
Variable warehouse rent (fixed fee not relevant) ....................................... $ 5.35
Breakage cost ............................................................................................... 3.00
Taxes and fire insurance ............................................................................. 1.15
Other storage costs ..................................................................................... 10.50
Total storage cost per windshield .............................................................. $ 20.00
3. The economic order quantity (EOQ) is calculated as follows:
EOQ =
$20.00
)($172.80) (2)(10,800
EOQ = 432 windshields per order
4. The minimum annual relevant cost at the economic order quantity is calculated as
follows:
Minimum cost = ordering cost + storage cost
=
2
$20.00 432
432
$172.80 10,800
+
= $4,320 + $4,320
= $8,640
5. The reorder point in units is calculated as follows:
Usage per day lead time in days = 36* units 6 days
= 216 windshields
*10,800 50 weeks 6 days
McGraw-Hill/Irwin 2002 The McGraw-Hill Companies, Inc.
Managerial Accounting, 5/e 9-53
PROBLEM 9-53 (CONTINUED)
6. Using the new cost estimates:
a. EOQ =
$60.00
)($32.40) (2)(10,800
= 11,664 = 108 windshields per order
b. Number of orders per year =
108
10,800
quantity order
t requiremen annual
=
= 100 orders
c. Minimum cost = ordering cost + storage cost
=
2
$60.00 108
108
$32.40 10,800
+
= $3,240 + $3,240
= $6,480
McGraw-Hill/Irwin 2002 The McGraw-Hill Companies, Inc.
9-54 Solutions Manual
SOLUTIONS TO CASES
CASE 9-54 (60 MINUTES)
1. Yes, City Raquetball Club (CRC) should be better able to plan its cash receipts with
the new membership plan and fee structure. The cash flows should be more
predictable and certain because the large, prepaid membership fee becomes the only
factor affecting cash receipts. The hourly court fees, which were dependent upon a
variable that could fluctuate daily, are eliminated.
2. a. Factors that CRCs management should consider before adopting the new
membership plan and fee structure include:
- Costs associated with the plan changeover
- Public acceptance of the new proposal
- The expected number of memberships by classes that can be sold for each
plan at the specified rates
- The anticipated rate of return for excess cash or cost of borrowing funds in
periods of cash shortages
b. Financial analyses conducted by CRC could include a forecast of projected cash
inflows and outflows by months, an income statement including interest revenue
and expense, a cost-volume-profit analysis, and a cash management plan for
excess cash or cash shortages.
3. Because CRC's cash flows should be more predictable, management should be better
able to plan for and control cash disbursements. In addition, management should be
better able to plan for short-term investments when excess cash occurs or to arrange
for short-term financing when there are cash shortages.
The collection and billing function is also simplified with the new membership
plan and fee structure. There would be only a one-time cash receipt rather than
multiple transactions.
McGraw-Hill/Irwin 2002 The McGraw-Hill Companies, Inc.
Managerial Accounting, 5/e 9-55
CASE 9-55 (35 MINUTES)
1. Some of the operational and behavioral benefits that are generally attributed to a
participatory budgeting process are as follows:
Utilization of the best knowledge of activities in a specific area, because the participants
are close to daily operations.
Goals that are more realistic and acceptable.
Improved communication and group cohesiveness.
A sense of commitment and willingness to be held accountable for the budget.
2. Four deficiencies in Patricia Eklunds participatory policy for planning and
performance evaluation, along with recommendations of how the deficiencies can be
corrected:
Deficiencies Recommendations
The setting of constraints on fixed
expenditures includes uncontrollable fixed
costs, thereby mitigating the positive effects
of participatory budgeting.
Rewards should be based on meeting
budget and/or organizational goals or
objectives.
The arbitrary revision of approved budgets
defeats the participatory process.
The contingency budget should be separate,
over and above each departments original
submission.
The division manager holds back a
percentage of each budget for discretionary
use.
Managers should be involved in the revision
of budgets. Managers could submit a
budget with programs at different levels of
funding.
Evaluation based on budget performance
must be accompanied with intrinsic rewards.
Divisional constraints could be
communicated at a budget kick-off
meeting; however, individual limits of
controllable expenses should be set by each
manager.
McGraw-Hill/Irwin 2002 The McGraw-Hill Companies, Inc.
9-56 Solutions Manual
CASE 9-56 (120 MINUTES)
1. Sales budget:
20x0 20x1
4th
Quarter
1st
Quarter
2nd
Quarter
3rd
Quarter
4th
Quarter
Entire
Year
S frame unit
sales ....................
50,000
55,000
60,000
65,000
70,000
250,000
S sales price ..... $10 $10 $10 $10 x $10 $10
S frame sales
revenue ...............
$ 500,000
$ 550,000
$ 600,000
$ 650,000
$ 700,000
$2,500,000
L frame unit
sales ....................
40,000
45,000
50,000
55,000
60,000
210,000
L sales price ...... $15 $15 $15 $15 $15 $15
L frame sales
revenue ...............
$ 600,000
$ 675,000
$ 750,000
$ 825,000
$ 900,000
$3,150,000
Total sales
revenue ...............
$1,100,000
$1,225,000
$1,350,000
$1,475,000
$1,600,000
$5,650,000
Cash sales* ........... $ 440,000 $ 490,000 $ 540,000 $590,000 $640,000 $2,260,000
Sales on
account
..............
660,000
735,000
810,000
885,000
960,000
3,390,000
*40% of total sales.
............................................
132,000
147,000
162,000
177,000
618,000
Total cash receipts ............................ $1,210,000 $1,335,000 $1,460,000 $1,585,000 $5,590,000
*80% of current quarter's credit sales.
.........
$441,600
$ 485,600
$ 529,600
$ 573,600
$2,030,400
Cash payments for
purchases during the
preceding quarter** ..........
99,400
110,400
121,400
132,400
463,600
Total cash payments for
raw-material purchases ...
$541,000
$ 596,000
$ 651,000
$ 706,000
$2,494,000
Direct labor:
Frames produced
(S and L) ...........................
102,000
112,000
122,000
132,000
468,000
Direct-labor hours per
frame .................................
.1
.1
.1
.1
.1
Direct-labor hours to be
used ..................................
10,200
11,200
12,200
13,200
46,800
Rate per direct-labor
hour ...................................
$20
$20
$20
$20
$20
Total cash payments for
direct labor .......................
$204,000
$ 224,000
$ 244,000
$ 264,000
$ 936,000
*Cash disbursements budget continued on next page.
80% of current quarters purchases
**20% of previous quarters purchases
McGraw-Hill/Irwin 2002 The McGraw-Hill Companies, Inc.
9-62 Solutions Manual
CASE 9-56 (CONTINUED)
Manufacturing overhead:
Indirect material .................... $ 10,200 $ 11,200 $ 12,200 $ 13,200 $ 46,800
Indirect labor ........................ 40,800 44,800 48,800 52,800 187,200
Other...................................... 31,000 36,000 41,000 46,000 154,000
Total cash payments for
manufacturing
overhead ...........................
$ 82,000
$ 92,000
$ 102,000
$ 112,000
$ 388,000
Cash payments for selling
and administrative
expenses ..........................
$100,000
$ 100,000
$ 100,000
$ 100,000
$ 400,000
Total cash disbursements ........ $927,000 $1,012,000 $1,097,000 $1,182,000 $4,218,000
McGraw-Hill/Irwin 2002 The McGraw-Hill Companies, Inc.
Managerial Accounting, 5/e 9-63
CASE 9-56 (CONTINUED)
6. Summary cash budget:
20x1
1st
Quarter
2nd
Quarter
3nd
Quarter
4th
Quarter
Entire
Year
Cash receipts [from req. (2)] .......... $1,210,000
$1,335,000
$1,460,000
$1,585,000
$5,590,000
Less: Cash disbursements
[from req. (5)] ..............................
927,000
1,012,000
1,097,000
1,182,000
4,218,000
Change in cash balance due to
operations ...................................
$ 283,000
$ 323,000
$ 363,000
$ 403,000
$1,372,000
Payment of dividends ..................... (50,000) (50,000) (50,000) (50,000) (200,000)
Proceeds from bank loan (1/2/x1) .. 1,000,000
1,000,000
Purchase of equipment .................. (1,000,000) (1,000,000)
Quarterly installment on loan
principal ......................................
(250,000)
(250,000)
(250,000)
(250,000)
(1,000,000)
Quarterly interest payment* ........... (25,000) (18,750) (12,500) (6,250) (62,500)
Change in cash balance during
the period ....................................
$ (42,000)
$ 4,250
$ 50,500
$ 96,750
$ 109,500
Cash balance, beginning of period 95,000
53,000
57,250
107,750
95,000
Cash balance, end of period .......... $ 53,000
$ 57,250
$ 107,750
$ 204,500
$ 204,500
*$1,000,000 10% = $25,000
$750,000 10% = $18,750
$500,000 10% = $12,500
$250,000 10% = $6,250
McGraw-Hill/Irwin 2002 The McGraw-Hill Companies, Inc.
9-64 Solutions Manual
CASE 9-56 (CONTINUED)
7. FRAME-IT COMPANY
BUDGETED SCHEDULE OF COST OF GOODS MANUFACTURED AND SOLD
FOR THE YEAR ENDED DECEMBER 31, 20X1
Direct material:
Raw-material inventory, 1/1/x1 ................................................. $ 59,200
Add: Purchases of raw material [req. (4)] ............................... 2,538,000
Raw material available for use ................................................. $2,597,200
Deduct: Raw-material inventory, 12/31/x1
([req. (4)] 10,400 $8) ..........................................................
83,200
Raw material used $2,514,000
Direct labor [req. (5)] ....................................................................... 936,000
Manufacturing overhead:
Indirect material ........................................................................ $ 46,800
Indirect labor ............................................................................. 187,200
Other overhead ......................................................................... 154,000
Depreciation .............................................................................. 80,000
Total manufacturing overhead ................................................. 468,000*
Cost of goods manufactured ......................................................... $3,918,000
Add: Finished-goods inventory, 1/1/x1 ......................................... 167,000
Cost of goods available for sale .................................................... $4,085,000
Deduct: Finished-goods inventory, 12/31/x1 ................................ 235,000
**
Cost of goods sold ......................................................................... $3,850,000
*In the budget, budgeted and applied manufacturing overhead are equal. The applied
manufacturing overhead may be verified independently as follows:
Total number of frames produced ........................................... 468,000
Direct-labor hours per frame ................................................ .1
Total direct-labor hours ............................................................ 46,800
Predetermined overhead rate per hour ................................ $10
Total manufacturing overhead applied ................................... $468,000
......................................................................................... 83,200
Finished goods ...................................................................................... 235,000
Plant and equipment (net of accumulated depreciation)** ....................... 8,920,000
Total assets .................................................................................................. $9,634,700
Accounts payable
...................................................................................... $ 143,400
Common stock ............................................................................................. 5,000,000
Retained earnings ........................................................................................ 4,491,300
Total liabilities and stockholders' equity.................................................... $9,634,700
*Fourth-quarter sales on account 20% = $960,000 20%
10,400 units $8
**$8,000,000 + $1,000,000 $80,000
Fourth-quarter purchases on account 20% = $717,000 20%
McGraw-Hill/Irwin 2002 The McGraw-Hill Companies, Inc.
Managerial Accounting, 5/e 9-67
CURRENT ISSUES IN MANAGERIAL ACCOUNTING
ISSUE 9-57
"U.S. AIRLINES CONSIDER IMPACT OF HIGHER FUEL BILL," THE WALL STREET
JOURNAL, OCTOBER 13, 2000. "AMERICAN'S NET SOARS, BUT HIGH OIL PRICES STING
U.S. AIRWAYS," THE WALL STREET JOURNAL, OCTOBER 19, 2000, MELANIE TRUTTMAN
AND SUSAN CAREY.
1. Higher fuel costs mean that airlines may have to raise airfares so that costs are met.
2. Higher fuel costs result in many expenses increasing throughout society. Since
airlines have to purchase many different kinds of supplies, many of which could be
affected by rising prices, increased fuel prices could affect the airlines budgets in
many places in addition to their actual fuel costs.
ISSUE 9-58
"BUDGET PLANNING: THE NEXT GENERATION," INFORMATIONWEEK.COM, SEPTEMBER
25, 2000, RICK WHITING.
1. Budgeting has moved to a combination of top-down and bottom-up processes. The
idea is that managers will be able to measure results more accurately. Strategic
planning begins with the organization's objectives and then builds a budget designed
to achieve those goals. Input from all levels is needed to make strategic planning
successful.
2. New technology via computer software allows employees from different levels of an
organization to provide integrated input into budget formation. This has allowed a
faster and more accurate process on a national as well as an international scale that
is updated on a continuous basis.
3. Amway Corporation incorporated Adaytum Software to project reducing travel
expenses by 5% for its executives. Next year Amway will use the software to
eventually link several hundred managers into the budgeting process.
McGraw-Hill/Irwin 2002 The McGraw-Hill Companies, Inc.
9-68 Solutions Manual
ISSUE 9-59
"INEFFICIENT BUDGETING COSTS COMPANIES DEARLY," MANAGEMENT ACCOUNTING,
FEBRUARY 2000, JOHN FANNING.
The traditional budget and associated processes, such as strategic planning,
forecasting, monthly reviews and reward processes, consume an enormous amount of
management time. If these processes are linked, rather than operating in isolation, the
overall level of control over the business can be improved while eliminating, or
substantially streamlining, redundant or superfluous activities.
ISSUE 9-60
"THE REVOLUTION IN PLANNING," CFO, AUGUST 1999, RUSS BANHAM.
There are fewer best practices that are directly transferable from company to company
than exist with re-engineering. This article discusses re-engineering the planning
process. Planning pervades every corner of an organization and is steeped in a
tradition of negotiation. Planning is the most political of all processes. Success in this
area requires patience, communication with employees, investment in new data-
gathering tools and time. It also requires finance to evolve from being a reporter to
being a facilitator of the process. Companies that succeed in revamping this process
believe they can accurately assess strategic decisions based on metrics intrinsic to the
business. Since this is a continuous process that starts when senior management
defines business objectives and communicates them to the operating lines, benefits
begin immediately.
ISSUE 9-61
"SELLING THE BUDGET," STRATEGIC FINANCE, SEPTEMBER 1999, CATHERINE M.
STANKE.
Using too much detail can bog an audience down and make them miss the overall
message. The author of the article suggests choosing the view of a picture that is best
for the message the presenter is trying to convey. Use bar graphs, pie charts, line
graphs, and/or scatter graphs for the purpose they were intended. Present high-level
assumptions that don't give more detail than is needed to make an informed decision.
The presenter can always give more detail when answering a specific question. Value
an audience's time, and respect their intelligence level.
ISSUE 9-62
McGraw-Hill/Irwin 2002 The McGraw-Hill Companies, Inc.
Managerial Accounting, 5/e 9-69
"MANAGEMENT ACCOUNTING IN CHINA CHANGES - PROBLEMS AND THE FUTURE,"
MANAGEMENT ACCOUNTING, JANUARY 1999, MIKE JONES AND JASON XIAO.
1. Economic Responsibility Contracts are designed to control and motivate enterprise
management. Internal Responsibility Contracts are used by many enterprises to
meet the ERC. While ERCs are becoming less popular, IRCs are still in operation in
many companies. The IRC has four principal components. First, responsibility
centers are established for appropriate internal departments, such as production, to
facilitate income monitoring and cost control. Second, top management uses the
company's overall financial targets to implement targets at the responsibility center
level. Third, an internal bank is established which settles transactions between
company divisions and lends funds raised from within or outside the company to
internal divisions. Finally, performance by the IRC is evaluated periodically against
pre-set targets.
2. ERCs involve management of a state-owned enterprise attaining an agreed level of
sales and profit upon which it is then taxed. In return, the enterprise has autonomy
to manage its business operations. A consequence of this system is that
enterprises develop management accounting techniques, such as budgeting and
standard costing, to help them meet targets.