CHAPTER 8: STRATEGY STRATEGY AND AND THE TH E MASTER BUDGET QUESTIONS 8-1 Compel Compel strategi strategic c planning planning and facili facilitate tate impleme implementat ntation ion of strategi strategic c plans. plans. An organization’s strategy, strategic plans, and budgets are interrelated. Preparing budgets budgets compels compels reviews of an organization’s strategy strategy and its strategic plans and can facilitate implementations of the strategic plan. Feedback from budgets often results in improvements to an organization’s strategy and strategic plan. Budgets serve serve as the benchma benchmark rk Serve as a basis for performance evaluation . Budgets against which actual performance can be compared. Budgets are a better basis for udging performance than past performance for two reasons. First, budgeted amou amount nts s take take into into acco accoun untt e!pe e!pect cted ed chan change ges s and and impr improv ovem emen ents ts in the the environment. "econd, past performance is a result of past events and operations and may not be suitable to serve as a benchmark. #o the e!tent past performance was not effective$efficient it does not make sense to use this as the standard against which actual performance is compared. Motivate managers and employees . Budgets, if internalized, serve as goals for managers and employees and, if properly implemented, can motivate them toward achievements of the goals. Promote coordination and communication within the organization . Budgets compel managers to think of interdependencies and interrelationships among subunits of the the orga organi niza zati tion on.. A budg budget et is also also a com communi munica cati tion on devi device ce that that help helps s all all employees and managers understand and accept the organization’s obectives and e!pected roles and contributions over the coming period. Authorizat Authorization ion to act . #he approved budget, particularly in a not%for%profit setting, gives the manager authorization to act &make decisions, etc.'. (ther benefits include serving as a basis for resource allocation, allocation, aiding cash-flow management, and providing authorization documentation. 8-2 An organization’s strategic plan describes how the organization matches its strengths and weaknesses with the opportunities and threats in the marketplace in order order to accompl accomplish ish its long%ter long%term m goals goals &e.g., &e.g., achieve achieve sustaina sustainable ble compet competiti itive ve advantage'. )t is the guideline for the firm’s short%term and long%term operations. A strategic plan may e!tend over several budget periods &e.g., years' covered by a master budget. A master budget is a comprehensive operational plan of action actio n for the coming year. )t includes both operating budgets and financial budgets and culminates in a set set of forec orecas astted &i. &i.e., e., pro-forma' fina financi ncial al stat statem ement ents s &cash &cash flow flow,, incom income e statement, and balance sheet'. #he strategic plan of a firm guides, in a general sense sense,, the the deter determi minat nation ion of the the mast master er budge budgets ts prepa prepared red annua annually lly by the the organization. organization. "pecialized consulting companies now provide software that can be used to integrate master master budgets with strategic plans as part of a comprehensive comprehensive performance management system. &"ee, for e!ample, *eac, at www.performance.geac.com.'
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-1
©The McGraw-Hill Companies 2008
8-3 A master budget is is a comprehensive comprehensive plan of action for an organization for a future perio period d whil while e a capital budget is is an investment &and financing' plan for a maor proect or program that has long%range effects on operations. As indicated in te!t +!hibit .-, resources specified in the capital budget of the current period are included in the master budget of the period. is a comprehensive plan of action for a future period as such, 8-4 A master budget is the master master budget budget includes includes both operatin operating g and financial financial budgets budgets.. An operating consists of plans regarding revenues and resource ac/uisition$use ac/uisition$use across budget consists all maor operating areas of the organization &e.g., sales, production, purchasing, marketing, marketing, research and development, development, and general administrative administrative activities'. activities'. #he set of operati operating ng budgets budgets culmin culminate ates s in a budgete budgeted d income income statem statement ent.. inancial relate to sources sources and uses of funds funds for an upcoming upcoming period. #he set of budgets relate financial budgets culminates in a budgeted cash flow statement and budgeted balance sheet. 8-5 "uccessful budgeting systems typically0
have full support by one or more key managers in the organization become become personal personalized ized budgets budgets of the people who have the responsibili responsibility ty for carrying them out as such, they serve an important motivational function are perceived by managers and employees as planning and coordinating tools, not not pres pressu sure re devi device ces s or mech mechan anis isms ms desi design gned ed to stif stifle le crea creati tivi vity ty and and opportunity are not viewed as a basis for placing blame. provide for a two%way flow of information in the budget%preparation process include budgets that are 1highly achievable2
#he budg budget et comm commit itte tee e of an orga organi niza zati tion on is the the high highes estt auth author orit ity y in the the 8-6 #he organization for all matters related to the budget. #he committee sets or approves the overall budget goals for the organization and its maor business units, directs and coordinates budget preparation, resolves conflicts and differences that may arise during the budget%preparation process, approves the final budget, monitors operations as the year unfolds, and reviews operating results at the end of the period. #he budget committee committee also approves maor maor revisions of the budget during the period. refers to estimated 8-7 3o, these terms are not synonymous. #he term 1 sales forecast! refers sales volume for an upcoming period. As such, the sales forecast is generally the starting point in preparing the sales budget for the period. #he term 1 sales budget 2 refers to forecasted sales dollars for an upcoming period. Alternatively, rather than focusing on the difference between sales volume and sales dollars, some writers distinguish between these two terms on the basis of the the level level of control control00 we use the term term sales forecast to refer to both units and dollars dollars because because,, unlike unlike costs, costs, these these elemen elements ts are affec affected ted by e!terna e!ternall &e.g., &e.g., comp compet etit itor or acti action ons' s' as well well as inte intern rnal al fact factor ors s &e.g &e.g., ., prod produc uctt prom promot otio ion n e!penditures'. Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-2
©The McGraw-Hill Companies 2008
8-3 A master budget is is a comprehensive comprehensive plan of action for an organization for a future perio period d whil while e a capital budget is is an investment &and financing' plan for a maor proect or program that has long%range effects on operations. As indicated in te!t +!hibit .-, resources specified in the capital budget of the current period are included in the master budget of the period. is a comprehensive plan of action for a future period as such, 8-4 A master budget is the master master budget budget includes includes both operatin operating g and financial financial budgets budgets.. An operating consists of plans regarding revenues and resource ac/uisition$use ac/uisition$use across budget consists all maor operating areas of the organization &e.g., sales, production, purchasing, marketing, marketing, research and development, development, and general administrative administrative activities'. activities'. #he set of operati operating ng budgets budgets culmin culminate ates s in a budgete budgeted d income income statem statement ent.. inancial relate to sources sources and uses of funds funds for an upcoming upcoming period. #he set of budgets relate financial budgets culminates in a budgeted cash flow statement and budgeted balance sheet. 8-5 "uccessful budgeting systems typically0
have full support by one or more key managers in the organization become become personal personalized ized budgets budgets of the people who have the responsibili responsibility ty for carrying them out as such, they serve an important motivational function are perceived by managers and employees as planning and coordinating tools, not not pres pressu sure re devi device ces s or mech mechan anis isms ms desi design gned ed to stif stifle le crea creati tivi vity ty and and opportunity are not viewed as a basis for placing blame. provide for a two%way flow of information in the budget%preparation process include budgets that are 1highly achievable2
#he budg budget et comm commit itte tee e of an orga organi niza zati tion on is the the high highes estt auth author orit ity y in the the 8-6 #he organization for all matters related to the budget. #he committee sets or approves the overall budget goals for the organization and its maor business units, directs and coordinates budget preparation, resolves conflicts and differences that may arise during the budget%preparation process, approves the final budget, monitors operations as the year unfolds, and reviews operating results at the end of the period. #he budget committee committee also approves maor maor revisions of the budget during the period. refers to estimated 8-7 3o, these terms are not synonymous. #he term 1 sales forecast! refers sales volume for an upcoming period. As such, the sales forecast is generally the starting point in preparing the sales budget for the period. #he term 1 sales budget 2 refers to forecasted sales dollars for an upcoming period. Alternatively, rather than focusing on the difference between sales volume and sales dollars, some writers distinguish between these two terms on the basis of the the level level of control control00 we use the term term sales forecast to refer to both units and dollars dollars because because,, unlike unlike costs, costs, these these elemen elements ts are affec affected ted by e!terna e!ternall &e.g., &e.g., comp compet etit itor or acti action ons' s' as well well as inte intern rnal al fact factor ors s &e.g &e.g., ., prod produc uctt prom promot otio ion n e!penditures'. Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-2
©The McGraw-Hill Companies 2008
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-
©The McGraw-Hill Companies 2008
8-8 #he sales budget is often regarded as the cornerstone in the master budget because all operating activities in a business emanate from efforts to attain the level of sales specified specified in the sales budget. A firm can complete complete the plan for other activities of a period only after it knows the e!pected sales levels for the current and the immed immediat iate e future future periods. periods. A manufa manufactu cturing ring firm, firm, for e!ampl e!ample, e, cannot cannot complete its production schedule for the upcoming period without knowing the number of units it must produce for each of its products. #he firm can ascertain the number of units to be produced only after it knows both forecasted sales and the desired ending inventory. #he units to be produced, in turn, affect many other activities of the firm including amount and kinds of materials to be purchased, number of employees to be hired, levels of factory overhead, and selling and administrative e!penses. 8-9 4hen sales volume is seasonal in nature, the three most significant items to coordinate are0 production volume, finished goods inventory, and sales volume. 8-10 Additional factors include0
beginnin beginning g and desired desired ending ending inventorie inventories s of work%in work%in%proc %process ess and finished finished goods the re/uired material inputs &in lbs., liters, etc.' for each product beginning and desired ending inventories of direct materials the cost of materials &per lb., liter, etc.'
8-11 #he two factors that determine the amount of factory overhead for a period are manage managemen mentt decision decision and planned planned product production ion volume volume.. #he former former refers refers to capacity%related &i.e., fi!ed overhead' costs while the latter refers to the planned utilization of that capacity &i.e., variable overhead costs'. generall y includes three maor components0 8-12 A cash budget generally
5ash available &i.e., beginning cash balance plus budgeted cash receipts' 5ash disbursements &other than interest e!pense', and Finan Financin cing g activi activity ty &new &new finan financin cing, g, repay repayme ment nt of princi principal pal,, and intere interest st e!pense'
813#he 813 #he following following are some some of the similarit similarities ies betwee between n cash budgets and cash-flow statements re/uired by *AAP0
Both include sources and uses of funds Both are prepared for a period of time 3either includes any non%cash revenues and e!penses
Among differences between these two statements statements are0
A cash%flow statement reports the results r esults of past activities activities while a cash budget describes effects of planned operations. operations. A firm needs to follow *AAP in preparing cash%flow statement while the guiding principle for preparing a cash budget is relevance and usefulness to
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-!
©The McGraw-Hill Companies 2008
management.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-"
©The McGraw-Hill Companies 2008
#he maor categories of cash%flow statements are operating, financing, and investing activities. +ach of these categories may include both sources and uses of cash. #he maor categories of cash budgets are cash available, cash disbursements, and financing. Both cash available and cash disbursements may include cash from either operating or investing activities.
8-14 )n comparison with manufacturing organizations, uni/ue budget characteristics of service organizations include0
absence of production and materials purchases budgets emphasis on workforce planning
8-15 )n contrast to business firms &i.e., for%profit entities', a not%for%profit organization0 has no single bottom%line amount such as operating income is more likely to use its budgets as the source of authorization for its activities limits the total amount in the budget to the e!pected total revenues &Federal budgets are e!ceptions'
8-16 "ero-base budgeting &6BB' is a budgeting process that re/uires managers to prepare budgets each period from ground zero for all operations. A typical budgeting process is 1incremental2 in nature. #hat is, budgets for the upcoming period start from the approved budgets for the current period, with amounts added to reflect planned changes for the upcoming period. #hus, traditional budgets assume that most, if not all, of the current activities and functions will continue into the coming budget period. )n contrast, a zero%base budgeting process allows no activities or functions to be included in the budget unless managers can ustify their need. Pure forms of 6BB are e!pensive and time%consuming. For this reason, some companies have partial 6BB systems. A number of companies &e.g., 7ero!, #e!as )nstruments' and government organizations &e.g., "tate of *eorgia' have at one time or another used 6BB. 8-17 3o. #aizen budgeting is a budgeting approach that e!plicitly incorporates continuous improvement standards$e!pectations in the approved budgets. )n contrast, activity%based budgeting &ABB' is a budgeting process that relies on the costs of activities and activity%cost drivers to prepare budgets. )n other words, ABB develops master budget data using the organization’s activity%based cost &AB5' system. #hus, ABB begins by /uantifying products and services to be produced for an upcoming period. #hese forecasts are then used to estimate the amount of activities, across the internal value chain, that are needed to meet forecasted output &products or services'. #he budgeting process is completed by assigning estimated resource costs to the specified activities. Both American $%press and A&'& Paradyne provide e!amples of actual implementation of ABB systems. "ee, Player, ". 8 9eys, :. +. &eds.', Activity-(ased Management) Arthur Andersen*s +essons from the A(M (attlefield . 3ew ;ork0
>>.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-#
©The McGraw-Hill Companies 2008
8-18 (udgetary slac , or ?padding? the budget, is the practice of knowingly including a higher amount of e!penditure in the budget &or lower amount of revenue' than managers actually believe should be the case. (ne reason that it is common to find slacks in budgets is the desire of managers to use such slack as a cushion for unpredictable$uncontrollable future events &e.g., worker attrition, machine breakdowns$malfunctions'. Another reason is the increased recognition or reward that might accrue to those who 1beat2 their budget target. Finally, managers may believe that the budgets they submit will be 1cut2 in the budget negotiation process. #herefore, such managers must 1pad2 their budgets in order to secure the amount of resources they feel they actually need. 8-19 A 1highly achievable2 budget has a target that is achievable by most managers 1most of the time2 &e.g., @ to >@ percent of the time'. )n a study by erchant &=>>@', the author finds that a budget with a highly achievable target serves well in the vast maority of organizational situations, especially when accompanied by e!tra rewards for performance e!ceeding the target. Among the advantages of using a highly achievable budget target are the following0 =. C. -. D.
)ncreasing managers commitment to achieving the budget target. aintaining managers confidence in the budget. :ecreasing organizational control cost. Eeducing the risk that managers will engage in harmful earnings% management practices or violate corporate ethical standards. . Allowing effective and efficient managers greater operating fle!ibility. G. )mproving predictability of earnings or operating results. H. +nhancing the usefulness of a budget as a planning and coordinating tool. 8-20 Participative budgeting is a 1bottom%up2 approach that involves everyone in the budget%preparation processIfrom low%level workers all the way to the top managers of the organization. #he principal idea is to have employees$managers 1internalize2 &i.e., take ownership of' the budgets that are prepared. For participative budgeting to be effective, top management needs to be actively involved. Furthermore, top management should institute incentives to guard against e!cessive budget padding, and encourage the generation of accurate budgetary proections. Finally, top managers may have to serve as arbiters when irreconcilable differences occur in the budget preparation process.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-$
©The McGraw-Hill Companies 2008
BRIE! E"ERCISES 8-21 JC "alesIC@@H Proected K increase for C@@ +stimated "ales LolumeIC@@ ! +stimated Mnit "elling PriceIC@@ +stimated "ales :ollarsIC@@ 8-22
J=G,@@@ CK
=,@@@ CK
20#000 ND.@@ $80#000
18#750 ND.@@ $75#000
Payment history0 K paid in month of purchase0 CK K paid in month following month of purchase0 HK +!pected 5ash :isbursements0 February0 &N,@@ ! @.H' O &NG,@@ ! @.C' arch0 &NG,@@ ! @.H' O &N,@@@ ! @.C'
8-23
$5#750 $6#875
3umber of units produced in Jtr. =0 +nding inventory of : &in lbs.' @,@@@ #arget ending inventory K CK of following month’s production re/uirements #herefore, E used for production in Jtr. = @,@@@[email protected] C@@,@@@ lbs. Mnits produced in Jtr. = lbs. of E used$lbs. of E per unit of output C@@,@@@$ C,@@@ units : re/uirements &in lbs.', Jtr. C Planned production, Jtr. C ! : lbs.$unit &C,@@@ units ! =.=@' ! lbs.$unit CH,@@ units ! lbs.$unit 220#000 %&'
8-24 "cheduled Production, Juarter C0 Mnits re/uired to meet estimated sales, Jtr. C
=C,@@@ units
Mnits re/uired to meet targeted ending inventory0 =,@@@ units ! =@K #otal units needed Qess0 Beginning inventory, Jtr.C &=C,@@@ units ! =@K' "cheduled production, Juarter C
=,@@ units =-,@@ units =,C@@ units 12#300 ()*+'
8-25 5urrent level of monthly operating costs N=@,@@@0 +stimated operating costs, >= +stimated operating costs, >G +stimated operating costs, :ecember N=@,@@@ ! @.>>=C
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-8
$9#900 $9#415 $8#864
©The McGraw-Hill Companies 2008
8-26 5ollection of 5redit "alesI3ovember0 -@K of 5redit "ales made in (ctober @.-@ ! N-@,@@@ H@K of 5redit "ales made in 3ovember @.H@ ! NCD,@@@ #otal +stimated 5ollections%%3ovember
N>,@@@ N=G,@@ $25#800
5ollection of 5redit "alesI:ecember0 -@K of 5redit "ales made in 3ovember @.-@ ! NCD,@@@ H@K of 5redit "ales made in :ecember @.H@ ! NC@,@@@ #otal +stimated 5ollections%%:ecember
NH,C@@ N=D,@@@ $21#200
8-27 5ollection of 5redit "alesI:ecember0 From credit sales made in 3ovember @.C@ ! N>@,@@@ From credit sales made in :ecember0 [email protected] ! N=@@,@@@' ! @.> #otal +stimated 5ollectionsI:ecember
N=,@@@
NH-,@@ $91#500
8-28 +stimated interest e!penseIApril borrowing in April ! &annual rate$=C' R&N-@,@@@ % N=,@@@' O N=,@@@S ! &@.=C$=C' N=-,@@@ ! @.@= $13000 3ote that, strictly speaking, to maintain a minimum cash balance of N-@,@@@, the company would have to borrow an e!tra N=,@@@ to be able to cover the interest payment &eom' and still have at least N-@,@@@ of cash. +stimated financing transactionsIay0 )nterest e!pense &paid eom'0 N=-,@@@ ! @.@= Principal repayment0 Beginning%of%month cash balance N=,@@@ O &N=-,@@@ % N=-@' Plus0 net cash flow in ay, prior to financing 5ash balance prior to financing transactions Qess0 interest e!pense &eom' for ay Qess0 minimum cash balance re/uirement 5ash available for principal repayment Eounded down to nearest N=,@@@ T,+% .*))/*) +)'/+*,)'M
N=-@ N-@,H@ NCC,@@@ NC,H@ &N=-@' &N-@,@@@ ' NCC,HD@ NCC,@@@ $22#130
8-29 : purchases, :ecember &: issued to production O ending : inventory' % beginning : inventory &N=@,@@@ O N->,@@' % N-H,@@@
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-%
$152#500
©The McGraw-Hill Companies 2008
8-30 #otal estimated marketing e!penses, Dth /uarter0 Lariable costs N@.@$unit ! &D,@@@ units ! =.=@' N@.@$unit ! D,D@@ units Fi!ed costs0 "alaries N=@,@@@ :epreciation N,@@@ )nsurance NC,@@@ #otal estimated marketing e!penses, D th /uarter Qess0 non%cash charges0 :epreciation e!pense +stimated cash payments for marketing e!penses
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-10
NCC@
N=H,@@@ $17#220 N,@@@ $12#220
©The McGraw-Hill Companies 2008
E"ERCISES 8-31 +-I. A)%'*' 20 M*)(+' =. #he term 1what if 2 analysis is one e!ample of the more general term 1sensitivity analysis2 and is used to e!plore the effects &e.g., on a decision or a budget for an upcoming period' of different marketing, production, or selling strategies &e.g., the effect on revenues of lowering product selling prices, the profit%effect of using a different sales%promotion plan'. #hat is, a 1what%if2 analysis e!amines how a result will change if the original &base%line' data are not achieved or, as in the present case, if an underlying assumption &viz., rate of bad%debts e!pense' changes. C.
-. anagers today work in a world of uncertainty. (ne way to cope with uncertainty in the master budgeting process is to model the underlying relationships associated with the various budgets that are prepared and then to perform sensitivity analysis. (ne form of sensitivity analysis is the 1what%if2 analysis described above. For #yson 5ompany, this type of analysis can help the firm decide whether it might need to implement a more restrictive credit%granting policy and, if so, how much it might be willing to spend in this regard.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-11
©The McGraw-Hill Companies 2008
8-32 B;*,% C,)'*<+*,)' 15 M*)(+' #here are at least two issues here. (ne is the failure to take advantage of all the cash discount included in the sales term. &)n this regard, see +!ercise %-H.' #he other is the constant occurrence of rush orders, last%minute changes, and other operating emergencies that re/uire the purchasing department to do last minute purchases.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-12
©The McGraw-Hill Companies 2008
8-33 B(<+ S%/= )< >,-B'< B(<+*) >BB 20 ?*)(+' =. (udgetary slac is a planned difference between budgeted revenue and e!pected revenue, and$or budgeted e!penditures and e!pected e!penditures. Budgetary slack describes the tendency of managers to under%estimate revenues and over% estimate e!penditures during the budgetary process in order to build in allowances &1cushions2' for une!pected declines in revenue and$or unforeseen e!penses. Budgetary slack occurs because of conflicts between the personal interests of a manager and the interests of the organization. #hese conflicts include pressure from top management to achieve budgets and the desire on the part of the manager to look favorable in the eyes of top management. C. a. From the point of view of the business unit manager, budgetary slack provides0
performance that will 1look better2 in the eyes of their superiors a coping mechanism regarding uncertainty a way to obtain what is needed since initially submitted budgets tend to be cut during the budget%negotiation process
Towever, the use of budgetary slack limits the obective evaluation of a business unit and, therefore, limits the obective evaluation of the performance of the unit manager. )t also becomes more difficult for the business unit manager to evaluate the performance of subordinates and to use the budget as a control mechanism over subordinate performance. b. From the perspective of corporate management, the use of budgetary slack increases the probability that budgets will be achieved. #his increased probability facilitates the overall corporate budgeting process. 5orporate management may also allow budgetary slack as a form of reward to managers for previous good performance. Towever, from the point of view of the business unit management, the use of budgetary slack increases the likelihood of inefficient allocation of scarce resources, and decreases the ability to identify potential weaknesses or trouble spots in operating activities.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-1
©The McGraw-Hill Companies 2008
8-33 C,)+*)(< -. a. "ero-based budgeting &6BB' is a budgeting techni/ue that evaluates all proposed operating and administrative e!penditures as though they were being initiated for the first time. +ach manager must evaluate the proposed e!penditure for each activity to be undertaken during the upcoming budget period, investigate alternative means of conducting each activity, and rank e!penditures in order of perceived importance. b. Atlantis Qaboratories could benefit from 6BB as each of the business unit managers would be re/uired to identify and ustify all proposed e!penditures for the upcoming year. #his increased evaluation of e!penditures would make it difficult to include budgetary slack in the budget for the upcoming year and likely uncover opportunities of cost savings and operational improvements. c. #he biggest disadvantage of 6BB is the significant amount of time and cost involved in its implementation. )n addition, the concept of zero%based budgeting may be difficult for management to learn and accept. Atlantis must be sure that the benefits of 6BB outweigh the associated costs.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-1!
©The McGraw-Hill Companies 2008
8-34 B(<+< C' D*'&('?)+' 25 ?*)(+' =. Budgeted cash payments for merchandise purchases0 a. February0 CK ! N=@@,@@@ HK ! N=C@,@@@
NC,@@@ N>@,@@@
$115#000
b. arch0 CK ! N=C@,@@@ HK ! N==@,@@@
N-@,@@@ NC,@@
$112#500
C. Budgeted cash payments for merchandise purchases0 a. February0 CK ! N=@@,@@@ ! @.> HK ! N=C@,@@@ ! @.>
NCD,@@ N,C@@
$112#700
b. arch0 CK ! N=C@,@@@ ! @.> HK ! N==@,@@@ ! @.>
NC>,D@@ N@,@
$110#250
-. #he financial cost of not taking advantage of the early%payment discount can be appro!imated by the following formula0 (pportunity cost &K' Rdiscount K$&= % discount K'S ! R-G$no. of e!tra days allowed if discount is not takenS R@.@C$&= % @.@C'S ! R-G$C@S @.@C@D@ ! =.C 3725@ Basically, if you choose not to take the early%payment discount, you are giving up a CK discount &on the net amount' in return for an e!tra C@ days in which to pay. #here are =.C &-G$C@' C@%day periods in a year. 3ote that in the first term of this formula we divide the CK discount rate by >K &= % CK' because, in effect, you are paying CK to delay for C@ days paying >K of the total bill. "o, the percentage rate you are paying in this case is really C.@D@K of the net bill &the bill without financing cost'. Eegardless of the technicalities here, students should understand that the opportunity cost of not taking advantage of the early% payment &cash' discount can be very significant, as is the case here. For this reason, firms record purchases at net cost and any discounts lost as interest e!pense.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-1"
©The McGraw-Hill Companies 2008
8-35 B(<+< C' R/*+' )< D*'&('?)+' 20 ?*)(+' =. Budgeted 5ash Eeceipts0 3ovember0 &N=@@,@@@ ! @.>' ! @.- ! @.@ ! @.> &N=@@,@@@ ! @.>' ! @.- ! @.C@ &N=@,@@@ ! @.>' ! @.G ! @.@ ! @.> &N=@,@@@ ! @.>' ! @.G ! @.C@
NCG,@G NG,G@ NHC,G= N=,C
$123#861
N->,=@C N>,>H ND-,H= N==,==
$103#763
3ovember0 &N=H@,@@@ ! @.H' ! @.C &NCH@,@@@ ! @.H' ! @.H
N-=,H N==,H
$183#750
:ecember0 &NC@@,@@@ ! @.H' ! @.C &N=H@,@@@ ! @.H' ! @.H
N-H,@@ N>,GC
$133#125
:ecember0 &N=@,@@@ ! @.>' ! @.- ! @.@ ! @.> &N=@,@@@ ! @.>' ! @.- ! @.C@ &N >@,@@@ ! @.>' ! @.G ! @.@ ! @.> &N >@,@@@ ! @.>' ! @.G ! @.C@
C. Budgeted 5ash :isbursements0
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-1#
©The McGraw-Hill Companies 2008
8-36 P,<(/+*,) )< ?+*%' (/'' &(<+' 20 ?*)(+' Production Budget0 Cnd Juarter -,@@@ O -,D@@ D=,D@@ U -,@@ 37#600
Budgeted sales :esired ending inventory &=@K' #otal units needed Beginning inventory #otal units to produce
-rd Juarter -D,@@@ O D,@@ -,@@ U -,D@@ -,D@@
Budgeted Purchases of :irect aterials for the "econd /uarter0 Budgeted production :irect materials per unit :irect materials needed in production :esired ending inventory of direct materials &C@K of =@G,C@@' #otal direct materials needed Beginning inventory of : &C@K of ==C,@@' Budgeted purchases of direct materials &lbs.'
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-1$
Cnd Juarter -H,G@@ ! ==C,@@
-rd Juarter -,D@@ ! =@G,C@@
O
C=,CD@ =-D,@D@ U CC,G@ 111#480
©The McGraw-Hill Companies 2008
8-37 P(/' D*'/,()+' ,) C<*+ P(/'' 20 ?*)(+' #he financial cost of not taking advantage of the early%payment discount for purchases made on credit can be appro!imated by the following formula &we use the term 1appro!imate2 here to denote the fact that the estimate below does not assume compounding of interest and as such provides a conservative estimate'0 (pportunity cost &K' Rdiscount K$&= % discount K'S ! R-G$no. of e!tra days allowed if discount is not takenS =. )n the case of C$=@, n$-@, the appro!imate economic cost of not taking advantage of the early%payment discount is0 R@.@C$&= % @.@C'S ! R-G$C@S @.@C@D@ ! =.C 3725@ Basically, if you choose not to take the early%payment discount, you are giving up a CK discount &on the net amount' in return for an e!tra C@ days in which to pay. #here are =.C &-G$C@' C@%day periods in a year. 3ote that in the first term of this formula we divide the CK discount rate by >K &= % CK' because, in effect, you are paying CK to delay for C@ days paying >K of the total bill. "o, the percentage rate you are paying in this case is really C.@D@K of the net bill &the bill without financing cost'. C. )n the case of =$=@, n$-@, the opportunity cost of not taking advantage of the early%payment cash discount is0 R@.@=$&= % @.@='S ! R-G$C@S @.@=@=@= ! =.C 1843@ -. *iven the significant opportunity cost of not taking advantage of early% payment cash discounts, good accounting practice would be to record purchases at their net%of%discount amount and then to record as 1interest e!pense2 or 1purchase discounts lost2 any cash discounts not taken advantage of.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-18
©The McGraw-Hill Companies 2008
8-38 P,<(/+*,) )< ?+*%' &(<+'--,/'' /,'+*) 20 ?*)(+' =. Budgeted Production &7PQ-@'0
Mnits
Budgeted sales Budgeted finished goods ending inventory &
D@,@@@ O @,@@@ -@,@@@ U @,@@@ 450#000
C. Mnits of 7PQ-@ to "tart into Production0 Budgeted production &from &=' above' Budgeted 4)P ending inventory &
O U
D@,@@@ C@,@@@ DH@,@@@ =@,@@@ 460#000
-. Eaw aterials Purchases Budget0 Mnits of 7PQ-@ to start into production &from &C' above' Mnits of raw materials needed per unit of 7PQ-@ #otal raw materials needed for production Budgeted raw materials ending inventory &
! O U
DG@,@@@ C >C@,@@@ @,@@@ >H@,@@@ D@,@@@ 930#000
D. 4hile the timing of the addition of materials would affect the calculation for number of e/uivalent units produced, number of e/uivalent units in the ending 4)P inventory, and the raw materials cost per e/uivalent unit, it will have no impact on the budgeted purchases of materials for the period.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-1%
©The McGraw-Hill Companies 2008
8-39 C' B(<+--!*))/*) E../+' 20 ?*)(+' Tartz 8 5o. 5ash Budget For 3ovember and :ecember, C@@H 3ovember
:ecember
5ash balance, beginning Plus0 5ash receipts #otal cash available &A'
NH,@@@ NC,@@@ NG@@,@@@
N>>,@@ ND@,@@ N@,@@@
5ash disbursements, prior to financing &B' Plus0 inimum cash balance &given' #otal cash needed &5'
ND@,@@@ N@,@@@ N@@,@@@
N@,@@@ N@,@@@ NG@@,@@@
+!cess &deficiency of' cash, before financing &5' &A' % &B'
N=@@,@@@
&N@,@@@'
Financing0 "hort%term borrowing Eepayments &loan principal' )nterest &V=CK' #otal +ffects of Financing &+'
%@% &N@,@@@' &N@@' &N@,@@'
N=,@@@ %@% &N=@' N@,D>@
$99#500
$50#490
+nding cash balance &A' % &B' O &+'
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-20
©The McGraw-Hill Companies 2008
8-40 C' &(<+ 10-15 ?*)(+' 5ash Available 5ash balance, beginning 5ash collections from customers #otal cash available
N =@,@@@ O =@,@@@ N=G@,@@@
5ash :isbursements :irect materials purchases (perating e!penses Qess0 :epreciation e!penses Payroll )ncome ta!es achinery purchase #otal cash disbursements prior to financing Financing0 5ash e!cess &shortage' before financing inimum cash balance desired Financing need
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-21
N C,@@@ N@,@@@ % C@,@@@
-@,@@@ H,@@@ G,@@@ O -@,@@@ N=GG,@@@ &N G,@@@' % C@,@@@ $26#000
©The McGraw-Hill Companies 2008
8-41 C' &(<+ 15 ?*)(+' 5ash Available0 5ash balance, beginning &given' 5ash collections from customers &given' #otal cash available
N G,@@@ O =H,@@@ N==,@@@
Budgeted 5ash :isbursements, C@@H0 Payroll (ther operating e!penses N=,@@@ Qess0 Property ta!es &see below' % -,@@@ Qess0 :epreciation e!pense % ,@@@ 5ash operating e!penses Property ta!es0 Cnd half of C@@G &@.@ ! NC,@@' N=,C@ st = half of C@@H &@.@ ! N-,@@@' =,@@ Payment for office e/uipment #otal cash disbursements, prior to financing Financing0 5ash balance before financing
N=G@,@@@
=@,@@@ C,H@ O G,@@@ N=H,H@ $2#250
3o, the cash budget shows that Bill will not be able to meet the minimum cash balance re/uirement of NG,@@@. As such, borrowing &or some other source of financing' must occur in order to meet the minimum cash re/uirement.
8-42 C' B(<+*): N,+-.,-P,.*+ C,)++ 30 ?*)(+'
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-22
©The McGraw-Hill Companies 2008
=. 1+ndowment fund02 a gift &contribution' whose principal must be maintained but whose income may be e!pended. &;ou might use the e!ample of an 1endowed professorship2 as an e!ample.' C. C' B(<+ ., T*-C,()+ S,/*% S;*/ A)/ 2007 *) +,(')<' Juarters ) )) ))) )L ;ear 5ash Balance, beginning N== $8 N== $8 $8 Eeceipts0 *rants N@ NH@ / / N-@@ 5ontracts N@ $20 $20 $20 $20 ental Tealth )ncome NC@ $25 $30 $30 N=@ 5haritable donations NC@ $350 NC@@ ND@@ $1,200 #otal 5ash Available NDH- N-- $381 $533 $1,696 Qess0 :isbursements0 "alaries and Benefits $335 N-DC $342 $346 N=,-G (ffice e!penses NH@ NH= N@ NCG $65 +/uipment purchases 8 maintenance NC ND NG N=H $5 "pecific assistance NC@ N= N= NH$20 #otal disbursements $427 $426 $437 $421 $1,711 +!cess &deficiency' of cash available over disbursements &NDG' N==C ($15 ) $47 ($104) Financing0 Borrow from endowment fund $54 $0 N==C $0 $166 Eepayments $0 &N->' $0 ($104) ($143) #otal financing effects $54 ($39 ) $112 ($104 ) $23 5ash Balance, ending $8 $8 $8 $8 $8 -. NC-,@@@. D. )t is probable that both donations and re/uests for services are unevenly distributed over the year. #he agency may want to increase re/uests for donations and seek additional grants. . 3o. Assuming there is careful fiscal management, borrowing only occurs when necessary.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-2
©The McGraw-Hill Companies 2008
8-43 C,%%/+*,) ,. A//,()+' R/*;&% 15-20 ?*)(+' =.
onth of "ale (ctober
#otal 5redit "ales N>@,@@@
K to be 5ollected in (ctober H@K
Budgeted 5ash 5ollection )n (ctober N G-,@@@
"eptember
@,@@@
=K
=C,@@@
August
H@,@@@
=@K
H,@@@
G@,@@@
DK
C,D@@
+stimated #otal 5ash 5ollections in (ctober
$84#400
C. onth of "ale (ctober
Amount of 5redit "ales N >@,@@@
K 5ollected in (ct. 3ov. :ec. H@K
=K
=-,@@
3ovember
=@@,@@@
=@K
H@K
Budgeted collection in the D th /uarter from sales in the D th Juarter N G-,@@@ >,@@@ H@,@@@
=K
=,@@@
H@K
>,@@
#otal budgeted cash collections in the D th /uarter from credit sales made in the D th /uarter
$230#000
:ecember
,@@@
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-2!
©The McGraw-Hill Companies 2008
8-44
A//,()+' R/*;&% C,%%/+*,)' )< S)'*+*;*+ A)%'*' 45 ?*)(+'
(riginal Assumptions$:ata0 Actual credit sales for arch Actual credit sales for April +stimated credit sales for ay +stimated collections in month of sale +stimated collections in first month following month of sale +stimated collections in the second month after month of sale +stimated provision for bad debts in month of sale
N=C@,@@@ N=@,@@@ NC@@,@@@ CK G@K =@K K
=. +stimated cash receipts from collections in ay0 5ollection from sales in arch &@.=@ ! N=C@,@@@' 5ollection from sales in April [email protected]@ ! N=@,@@@' 5ollection from sales in ay [email protected] ! NC@@,@@@' #otal estimated cash collections in ay
N=C,@@@ N>@,@@@ N@,@@@ $152#000
C. 0ross accounts receivable, ay -= st0 From credit sales made in April &@.= ! N=@,@@@' From credit sales made in ay [email protected] ! NC@@,@@@' +stimated gross accounts receivable, ay -=st
NCC,@@ N=@,@@@ $172#500
-. 3et accounts receivable, ay -= st0 *ross accounts receivable, ay -=st Qess0 Allowance for uncollectible accounts0 From credit sales made in April From credit sales made in ay 3et accounts receivable, ay -= st
N=HC,@@ NH,@@ N=@,@@@ $155#000
D. Eevised data$assumptions0 Actual credit sales for arch Actual credit sales for April +stimated credit sales for ay +stimated collections in month of sale +stimated collections in first month following month of sale +stimated collections in the second month after month of sale +stimated provision for bad debts in month of sale
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-2"
N=C@,@@@ N=@,@@@ NC@@,@@@ G@K CK =@K K
©The McGraw-Hill Companies 2008
8-44 &5ontinued' a. +stimated cash receipts from collections in ay0 5ollection from sales in arch &@.=@ ! N=C@,@@@' 5ollection from sales in April [email protected] ! N=@,@@@' 5ollection from sales in ay [email protected]@ ! NC@@,@@@' #otal cash collections in ay
N=C,@@@ N-H,@@ N=C@,@@@ $169#500
b. 0ross accounts receivable, ay -=st0 From credit sales made in April &@.= ! N=@,@@@' From credit sales made in ay [email protected]@ ! NC@@,@@@' *ross accounts receivable, ay -=st
NCC,@@ N@,@@@ $102#500
1ote to 2nstructor 0 An +!cel spreadsheet solution file is embedded in this document. ;ou can open the spreadsheet 1obect2 that follows by doing the following0
=. Eight click anywhere in the worksheet area below. C. "elect 1worksheet obect2 and then select 1(pen.2 -. #o return to the 4ord document, select 1File2 and then 15lose and return to...2 while you are in the spreadsheet mode. #he screen should then return you to the 4ord document. I)A(+ D-+-
Actual credit sales for arch Actual credit sales for April +stimated credit sales for ay +stimated collections in month of sale +stimated collections in first month following month o +stimated collections in the second month after mont
N=C@,@@@ N=F@,@@@ NC@@,@@@ CFK G@K =@K
. #he principal benefit is the accelerated receipt of cash, which the company can potentially employ to pay down debt, reduce borrowing, invest, etc. Principal costs would relate to whatever programs are needed to secure the accelerated collection of cash. #hese costs could include personal, travel, mailings, telephone, incentive programs, and costs related to customer relations.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-2#
©The McGraw-Hill Companies 2008
8-45 B(<+*): N,+-.,-P,.*+ S/+, 25 ?*)(+' 1& "tewardship is defined by Merriam-3ebster 4nline 5ictionary as 1the conducting,
supervising, or managing of something especially0 the careful and responsible management of something entrusted to ones care.2 #he "ocially Eesponsible )nvestment *uidelines cited states0 1Although it is a moral and legal fiduciary responsibility of the trustees to ensure an ade/uate return on investment for the support of the work of the church, their stewardship embraces broader moral concerns.2 Also, the principles of stewardship lists two fundamental and interdependent principles0 1#he 5onference should e!ercise responsible financial stewardship over its economic resources.2 and 1#he 5onference should e!ercise ethical and social stewardship in its investment policy.2 #he latter states0 1"ocially responsible investment involves investment strategies based on 5atholic moral principles. #hese strategies are based on the moral demands posed by the virtues of prudence and ustice. #hey recognize the reality that socially beneficial activities and socially undesirable or even immoral activities are often ine!tricably linked in the products produced and the policies followed by individual corporations. *iven the realities of mergers, buyouts and conglomeration, it is increasingly likely that investments will be in companies whose policies or products make the holding of their stock a ?mi!ed investment? from a moral and social point of view. 3evertheless, by prudently applying traditional 5atholic moral teaching, and employing traditional principles on cooperation and toleration, as well as the duty to avoid scandal, the 5onference can reflect moral and social teaching in investments.2 C. 1#hese two maor principles work together to encourage the 5onference to identify investment opportunities that meet both our financial needs and our social criteria. #hese principles are carried out through strategies that seek0 =' to avoid participation in harmful activities, C' to use the 5onferences role as stockholder for social stewardship, and -' to promote the common good.2 -. 3o. &Eeasons should vary.' D. ;es.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-2$
©The McGraw-Hill Companies 2008
8-46 B(<+*) C' R/*+': C' D*'/,()+' A%%,< ,) R/*;&%' 30 M*)(+' =. Breakdown of 5ash$ "ales :ata Amount Bank 5redit%5ard "ales @,@@@ "eptember N>G,@@@ Bank charges -K (ctober N,@@@ 5redit sales0 5ollection of 5redit "ales 5urrent month C@K "ales Breakdown and #erms =st month @K 5ash and bank credit card sales CK Cnd month =K 5redit sales HK -rd month =CK #erms =$eom, n$D Qate charge$mo. CK "ales S+?& #otal 5ash sales N>G,@@@ Bank credit card sales N>G,@@@ 5ollections of A$E0 "eptember credit sales N>G,@@@ August credit sales N>@,@@@
K K Paid CK D@K CK G@K HK HK HK HK
C@K @K =K =CK
K 5ollected >HK >>K =@CK
5ash Eeceipts N >,G@@ N=-,>G N=D,CG N--,H@ N >,@@@ N ,@ $86#082
C. Appropriate accounting treatment for0 a' (an service 6collection7 fees 0 these can be considered an offset to gross sales and thus can be reflected as a deduction in determining 1net sales2 &see te!t +!hibit .='. Alternatively, these amounts can be considered 1selling e!penses2 and, as such, be treated as an 1operating e!pense,2 &i.e., an element of 1"elling and Administrative +!penses2 on the )ncome "tatement'. b' Cash discounts allowed on collection of receivables 0 these can be considered a 1selling e!pense2 and, as such, would be included within the 1"elling and Administrative2 e!pense category on the )ncome "tatement.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-28
©The McGraw-Hill Companies 2008
8-47 C' D*'/,()+' S<'+ %*/+*,) 45 M*)(+' 1ote to 2nstructor 0 An +!cel spreadsheet solution file is embedded in this document. ;ou can open the spreadsheet 1obect2 that follows by doing the following0
=. Eight click anywhere in the worksheet area below. C. "elect 1worksheet obect,2 then select 1(pen2 -. #o return to the 4ord document, select 1File2 and then 15lose and return to...2 while you are in the spreadsheet mode. #he screen should then return you to the 4ord document below. S%9' D+ A?,()+ @,@@@ "eptember N>G,@@@ (ctober N,@@@ S%9' T9?' 5ash and bank credit%card sales CFK 5redit sales HFK :iscount term =K
S%9' P3 @ @
T,+% C' R9/9*+' ., S9+9?&9 5ash sales Bank credit%card sales 5ollection of accounts receivable0 "eptember credit sales August credit sales
B9=<,) ,. C'EB)= C9<*+-C< 5ash sales Bank credit%card sales Bank processing fee C,%%9/+*,) ,. C9<*+ S%9': 5urrent month =st month Cnd month -rd month Qate charge$mo.
N>G,@@@ N>G,@@@
CFK D@K CFK G@K
N>G,@@@ N>@,@@@ N@,@@@ NG@,@@@
HFK HFK HFK HFK
C,%% @
S%9 D@K G@K -K C@K F@K =FK =CK CK
C' R9/9*+'
N >HK N
>,G@@ =-,>G
C@K F@K =FK =CK
>>K N N N =@CK N $
=D,CFG --,HF@ >,@@@ F,F@ 86#082
N,@@@ N,@@@
CFK D@K CFK G@K
N >HK N
,@@ =C,@D
N,@@@ N>G,@@@ N>@,@@@ N@,@@@
HFK HFK HFK HFK
>>K N N N =@CK N $
=-,@G -G,@@@ =@,=CF H,-DD 88#141
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-2%
C@K F@K =FK =CK
©The McGraw-Hill Companies 2008
8-48 A/+*;*+-B'< B(<+*) ABB 20 M*)(+' =. Activity "torage Ee/uisition Tandling
Budgeted 5ost Lolume :river Eate D@@,@@@ [email protected]>C -@,@@@
N=C.@
N -H,@@@
Pick Packing
@@,@@@
N =.@
N=,C@@,@@@
:ata +ntry
@@,@@@
N @.@
N GD@,@@@
-@,@@@
N =.C@
N
=C,@@@
N-@.@@
N -G@,@@@
:esktop :elivery
#otal Budgeted 5ost for the :ivision C.
#otal 5ost N =>H,@@@
-G,@@@
$2#808#000
Average number of cartons$delivery =,=H@,@@@ cartons ÷ ==,H@@ deliveries =@@ cartons$delivery #otal number of cartons budgeted for delivery in
-.
+!pected saving in costsI
N
:ata +ntry0 number of lines
-H,@@@ GD@,@@@
:ata +ntry0 number of re/uisitions +!pected 5ost "avings,
-G,@@@ $1#051#000
)f the firm uses a single cost%rate system based on the number of cartons delivered, the firm will not be able to estimate the savings without special efforts to gather additional information.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-0
©The McGraw-Hill Companies 2008
8-49 A/+*;*+-B'< B(<+*) *+ F*) 40 M*)(+' =.
Mnit%Qevel0 Batch%Qevel0
Pick packing, :ata entryIQines Ee/uisition handling, :ata entryIEe/uisitions, :esktop delivery
C.
5ost driver rates0
5ost%Eeduction Activity Eate &per month' Ee/uisition Tandling >K Pick Packing >>K :ata +ntryIQines >>K :ata +ntryIEe/uisitions >K :esktop :elivery >K
5ost%:river Eates C N =.C@ N =.=HG N-@.@@ NC>.D@@
arch N=C.@@@ N =.DH@C N @.HD= N =.=C NC.=C@
Budgeted 5osts0 Activity Ee/uisition Tandling Pick Packing :ata +ntryIQines :ata +ntryIEe/uisitions :esktop :elivery :ivisional #otals -.
Activity Lolume -@,@@@ @@,@@@ @@,@@@ -@,@@@ =C,@@@
February N -GH,@@ N=,=,@@@ N G--,G@@ N -,C@ N -C,@@ NC,HH,=@
arch N -G@,=@ N=,=HG,=C@ N GCH,CGD N -D,HD N -D,HDD NC,D-,C
Factors that may influence the success of a continuous improvement aizen' program include0
Eeasonable or achievable cost reductions. Awareness of all employees on the e!pected &scheduled' cost improvements over at least the immediate future periods. Acceptance by both management and employees. 5ommitment of both management and employees on the strategic importance of the success of the continuous improvement program. 5lose link between the scheduled improvements and performance evaluations and rewards. 5ost reductions possible from small, incremental improvements, not from large discontinuous changes in factors such as operating processes, capital e/uipment, supplier networks, or customer interactions.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-1
©The McGraw-Hill Companies 2008
8-49 C,)+*)(< D.
Primary criticisms of #aizen &continuous improvement' budgets include the following0
#he budgeting process tends to place enormous pressure on employees to reduce all costs, which can lead to employee 1burnout.2 #he use of 9aizen budgets tends to motivate small, incremental rather than maor$significant process improvements. )f the 9aizen targets are confined to the manufacturing function &including product and process design engineering', frictions can arise if manufacturing believes that other parts of the organization &e.g., marketing' are not subected to the same budgetary pressure.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-2
©The McGraw-Hill Companies 2008
8-50 C' &(<+ 30 ?*)(+' =. #otal credit sales in 3ovember Percentage collectible #otal amount collectible from credit sales in 3ovember Percentage collected in the month following month of sales Budgeted collections in :ecember from 3ov. credit sales C. 5ash sales in K Percentage to be collected in K Percentage to be collected in
N G@,@@@ N=H=,@@@ ! G@K N-DC,@@@ ! D@K
-. #otal inventory purchases in 3ovember0 For 3ovember sales0 N-C@,@@@ ! @.- 7 @.G For :ecember sales0 NDG@,@@@ ! @.H 7 @.G Percentage of 3ov. purchases to be paid in :ecember Payment in :ecember for purchases in 3ovember Budgeted purchases in :ecember0 For :ecember sales0 NDG@,@@@ ! @.- 7 @.G For
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
NCD@,@@@ ! W >K NCC,@@@ ! D@K $ 91#200
8-
N H,G@@ =>-,C@@
N C,@@ =@@,@@
N=@C,G@@
=-G,@@ $299#400
NC@,@@ ! HK N=,=@@ N=-,G@@ ! CK ND,>@@ $234#000
©The McGraw-Hill Companies 2008
8-51
B(<+*) ., S;*/ !*? 60-75 ?*)(+'
#otal hours for the budgeted activities0
Business return 5omple! individual return "imple individual return
#otal Eevenue &*iven' N=,@@@,@@@ N=,C@@,@@@ N=,GD@,@@@ N-,D@,@@@
Tourly Eate &*iven' NC@ N=@@ N@
#otal Tours D,@@@ =C,@@@ -C,@@
"taff re/uirements for the budgeted activities0 "enior anager
#otal Tours 5onsultant Ee/uired #otal D,@@@
#otal +ach Business return @.@@ @ 5omple! individual return =C,@@@ "imple individual return -C,@@ @ @.C@ G,G@ @.@ #otal Tours D,@@ Tours per week X of weeks needed X of weeks per employee per year X of employees needed +!cess &deficiency' hours
@.-@ =,C@@ @.@ @.@@ CG,CD@
@.C@
@@
@.@
G@@ @
@.= =,@@ @.@@
@.D@ D,@@
=,@@ @ -G D@ =
C,G@@ D D C
=-,-G@ D@ --D D =,@D@
@.D@
D,@@ -=,@D@ D@ HHG D =G &-C@'
N,+: Because 5onsultants can be hired on a part%time basis, we round the calculation :(43 for this class of labor. #he Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-2
©The McGraw-Hill Companies 2008
other three labor classes are given &i.e., do not have to be planned for based on data in the problem'.
other three labor classes are given &i.e., do not have to be planned for based on data in the problem'.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-
©The McGraw-Hill Companies 2008
8-51 &5ontinued' SOUTION: =. "ince, according to the present staffing plan and anticipated workload needs, there is an e!cess of senior consultant hours, the budgeted cost for overtime hours worked by senior consultants would be N@. C. 3umber of full%time consultants needed for the year0 #otal number of consultant%weeks needed for the year 3umber of weeks per full%time consultant per year 3umber of full%time consultants needed per year
HHG D 16
8-51 &5ontinued' SOUTION: =. "ince, according to the present staffing plan and anticipated workload needs, there is an e!cess of senior consultant hours, the budgeted cost for overtime hours worked by senior consultants would be N@. C. 3umber of full%time consultants needed for the year0 #otal number of consultant%weeks needed for the year 3umber of weeks per full%time consultant per year 3umber of full%time consultants needed per year
HHG D 16
-. #he managers total compensation, assuming that the revenues from preparing ta! returns remains the same0 Annual "alaries0 Per partner Per manager Per senior consultant Per support staff
NC@,@@@ N>@,@@@ N>@,@@@ ND@,@@@
5onsultants pay &assumed paid on an hourly basis '0 +arnings per year NG@,@@@ Trs. worked$year =,>C@ Tourly pay rate N-=.C "taffing Plan0 Partners anagers "enior consultants Full%time 5onsultants "upport staff
= = =G
3umber of part%time &P#' hours, consultants -C@
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-!
©The McGraw-Hill Companies 2008
8-51 &5ontinued' Accu#a!, Accu#a!, )nc. Budget (perating )ncome ;ear ended August -=, C@@H Eevenue
N-,D@,@@@ Payroll e!penses0
Partner anager "enior consultantsIbase pay "enior consultantsIpay for overtime hours 5onsultants0 Full% time N>G@,@@@ Part%time N=@,@@@ "upport staff *eneral and administrative e!penses (perating income before bonus to manager Qess0 managers bonus (perating income before ta!es #otal compensation for the manager0 "alary &given' Bonus &@.=@ ! RN=,C-H,@@@ % N@@,@@@S' #otal
NC@,@@@ N>@,@@@ NHC@,@@@ N@ N>H@,@@@ NC@@,@@@
NC NC,C-@,@@@ N-H-,@@@ N=,C-H,@@@ NH-,H@@ $1#163#300
N>@,@@@ NH-,H@@ $163#700
1ote to 2nstructor 0 An +!cel spreadsheet solution file is embedded in this document. ;ou can open the spreadsheet 1obect2 that follows by doing the following0
=. Eight click anywhere in the worksheet area below. C. "elect 14orksheet (bect,2 then 1(pen.2 -. #o return to the 4ord document, select 1File2 and then 15lose and return to...2 while you are in the spreadsheet mode. #otal hours hours for the budgeted activities0 a ctivities0 #otal Tourly Eeven evenu ue Eate ate #ot #otal al &*iven' &*ive iven' Tours
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-"
©The McGraw-Hill Companies 2008
8-52 B(<+ P''( )< E+*/' 20-25 ?*)(+' =. #he use of alternativ alternative e accounti accounting ng methods methods to manipu manipulat late e reported reported earnings earnings is professionally professionally unethical because it violates the "tandards contained in the )A’ )A’s Stat Statem emen entt of $thi $thica call Prof Profes essi sion onal al Prac Practi tice ce &see0 &see0 www www.imane imanet.o t.org'. rg'. #he violat ated ed beca becaus use e of fail failur ure e to perf perfor orm m duti duties es in C,?+)/ C,?+)/ '+)<< '+)<< is viol accordance with relevant accounting &technical' standards. )t can probably be argued that the competence competence standard is also violated because the accountant accountant is not providing providing informati information on that that is accurat accurate. e. #he I)+* I)+*+ + '+)<< '+)<< is violated because because the underlyi underlying ng activi activity ty would would discred discredit it the professi profession. on. #he C<*&*%*+ '+)<< is '+)<< is violated because of failure to communicate information fairly and obectively. C. ;es, costs related to revenue should be e!pensed in the period in which the revenue is recognized &1matching principle2'. Perishable supplies are purchased for use in the current period, will not provide benefits in future periods, and should therefore be matched against revenue recognized in the current period. )n short, the accounting treatment for supplies was not in accordance with generally accept accepted ed account accounting ing principle principles s &*AAP'. &*AAP'. 3ote that that similar similar issues, issues, but on an e!tremely large basis, occurred at 4orld5om and at *lobal 5rossing. )n the case of the latter, the company was engaging simultaneously in contracts to buy and to sell bandwidth, treating the former as capitalized e!penses and the latter as revenue for the current accounting period. -. #he actions actions of *ary 4oods 4oods were were appropri appropriate. ate. Mpon discovering discovering how supplies supplies were were being being accou account nted ed for for, 4ood 4ood brough broughtt the the matt matter er to the the atte attent ntion ion of his imme immediat diate e superior superior,, *onzale *onzales. s. Mpon Mpon learning learning of the arrange arrangemen mentt with with P8E, P8E, 4ood told *onzales that the action was improper he then re/uested that the accounts be corrected and the arrangement discontinued. 4ood clarified the situ situat atio ion n with with a /ual /ualif ifie ied d and and obe obect ctiv ive e peer peer &adv &advis isor or'' befo before re disc disclo losi sing ng *onzale *onzales’s s’s arrange arrangemen mentt with with P8E to Belco’ Belco’s s division division manage manager, r, #om #om QinI *onzales’s immediate superior. 5ontact with levels above the immediate superior should be initiated only with the superior’s knowledge, assuming the superior is not involved. )n this case, however, the superior is involved. According to the )A’s stat statem emen entt rega regard rdin ing g 8eso 8esolu luti tion on of $thi $thica call Cond Conduc uct t , 4ood acted appropriately appropriately by approaching approaching Qin without *onzales’s *onzales’s knowledge and by having a confidential discussion with an impartial advisor.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-#
©The McGraw-Hill Companies 2008
PROBEMS 8-53 S?%% S?%% &('*) &('*)'' '' &(<+' &(<+' 30 30 ?*)(+' ?*)(+' =. 9ey feat features ures that that need need to be conside considered red in develop developing ing a profit plan for a small business include0
+stimation of key factors such as revenues &sales demand, sales price' and e!penses for the budget period. "ystematic evaluation of all available resources &materials, labor, technology' and their utilization utilization rates. 5oordination 5oordination of related functions or elements, such as scheduling scheduling production production to meet sales forecasts or providing sufficient capacity to meet sales demand. 5rit ritical cal evalua aluattions ions of non%o on%ope perrati ational nal sourc urces and and use uses of cash. 3onoperational items may pose a more serious threat to small businesses than to large businesses. *reater control over monthly cash flows and short%term financing than may be necessary in large enterprises. *reater needs for continuous budgeting than for large organizations, organizations, because of the higher risks associated with economic, competitive, and financial factors for small businesses.
C. #he management management accountant accountant must e!ercise e!ercise care to ensure that the the small business business manager does not suffer from information overload &i.e., strive for simplicity and parsimo parsimony' ny'.. A profit%m profit%mana anagem gement ent system system should should be establi established shed that that captures captures sufficient data on a timely basis to allow a reasonable level of operational control and evaluation without becoming too costly or too sophisticated for the business. any any large large enterp enterpris rises es may may cont contin inue ue operat operation ions s simp simply ly by inert inertia. ia. 4ith smal smalll businesses, businesses, a strategic strategic plan linked to the master budget is critical, especially in the early stage of a product’s life cycle. #he concepts concepts of activity%based managem management ent &AB', total /uality management J', logistics management, life%cycle and target costing, and constraints% management &e.g., #heory of 5onstraints' are essential for the long%run survival and growth of small businesses. -. #he manage manageme ment nt accoun accountan tantt can can insis insistt upon, upon, and assist assist in the the prepa preparat ration ion of, continu continuous ous cash budgets budgets . #hes #hese e cash%f cash%flo low w report reports s shoul should d identi identify fy the the mao maor r operational and nonoperational nonoperational sources and uses of cash, and point out the periods of potential potential cash shortages or surpluses. surpluses. #his will facilitate facilitate planning for short%term short%term lines%of%credit financing and short%term investments. A profit%management pro fit%management system should be created, utilizing the principles of activity% based costing &AB5' and cost%variance reporting including activity%based standard cost costin ing g and and acti activi vity ty%ba %base sed d cost cost vari varian ance ces. s. "eg "egment mented ed inco income me stat statem emen ents ts comparing budgeted to actual results with profit%variance summaries should be an integral component of the high%/uality profit%management system. Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-$
©The McGraw-Hill Companies 2008
8-54 E+*/' E+*/' *) *) B(< B(<+*) +*)B( B(<+ <+ S%/= S%/= 40 ?*)(+ ?*)(+' ' 1&
a. #he reasons reasons that that arge arge Atkins tkins and Pete Pete *ranger *ranger use use budgetary slac include the following0
#hese employees are hedging against the une!pected &i.e., they use slack to deal with or reduce uncertainty and risk'. allow ws emplo mploy yees ees to 1loo 1look k good good,,2 &i.e &i.e., ., to e!cee !ceed d (udgeta (udgetary ry slac slac allo e!pe e!pect ctat ation ions s and$o and$orr show show consi consist stent ent perfor performa manc nce'. e'. #his #his is parti particul cularl arly y import important ant when when performa performance nce is evaluat evaluated ed on the basis basis of actual actual versus versus budgeted results. +mployees +mployees who are able to blend personal and organizational organizational goals through budgetary slack and show good performance generally are rewarded with higher salaries, promotions, and bonuses. By 1padding the budget,2 the manager is more likely to get what he$she actually needs in terms of resources for the upcoming period.
b. #he use of budgetary slac can can adversely affect Atkins and *ranger by0
limiti limiting ng the usefulness usefulness of the budget to motiva motivate te their their emplo employee yees s to top performance affecting affecting their ability to identify identify trouble spots and take appropriate corrective action reducing their credibility in the eyes of management reducing the ability of top management to effectively allocate resources to organizational subunits on the basis of actual economic performance. For e!a e!ampl mple, the use use of budgetar affect management management decision% budgetary y slac slac may affect making, as the budgets will show lower contribution margins &lower sales, higher higher e!pens e!penses'. es'. :ecision :ecisions s regardin regarding g the profita profitabili bility ty of product product lines, lines, staffing levels, incentives, etc. could have an adverse effect on Atkinss and *rangers departments.
C. #he use use of budgetary slac , particularly if it has a detrimental effect on the company, may may be uneth unethica ical. l. )n assess assessing ing the the situ situat ation ion,, the the )A )A’s Statement Statement of $thica $thical l Professional Practice can be consulted &www.imanet.org'. #his statement notes that 1a commit commitmen mentt to ethical ethical professi professional onal practic practice2 e2 includes0 includes0 overarch overarching ing principl principles es &e!pr &e!press ession ions s of core core value values' s' and and a set set of stand standard ards s intend intended ed to guide guide actual actual conduct and practice.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-8
©The McGraw-Hill Companies 2008
8-54 C,)+*)(< #he )A’s overarching PE)35)PQ+" include0 Tonesty, Fairness, (bectivity, and Eesponsibility. #he list of "#A3:AE:" includes the following0 5ompetence, 5onfidentiality, )ntegrity, and 5redibility. #he following "tandards could be referenced in conunction with the use of budgetary slack, as described above0
5ompetence0 Provide decision support information and recommendations that are accurate, clear, concise, and timely. )ntegrity0 Eefrain from engaging in any conduct that would preudice carrying out duties ethically. 5redibility0 5ommunicate information fairly and obectively disclose all relevant information that could reasonably be e!pected to influence an intended user’s understanding of the reports, analyses, or recommendations.
#hough not asked for in the original 5A e!am problem, you might want to discuss with students how, in practice, they would deal with ethical dilemmas. )n its 8esolution of $thical Conflict statement the )A provides the following guidance0 1&
5iscuss the issue with your immediate supervisor e%cept when it appears that the supervisor is involved. )n that case, present the issue to the ne!t level. )f you cannot achieve a satisfactory resolution, submit the issue to the ne!t management level. )f your immediate superior is the chief e!ecutive officer or e/uivalent, the acceptable reviewing authority may be a group such as the audit committee, e!ecutive committee, board of directors, board of trustees, or owners. 5ontact with levels above the immediate superior should be initiated only with your superior’s knowledge, assuming he or she is not involved. 5ommunication of such problems to authorities or individuals not employed or engaged by the organization is not considered appropriate, unless you believe there is a clear violation of the law.
2& Clarify
relevant ethical issues by initiating a confidential discussion with an 2MA $thics Counselor or other impartial advisor to obtain a better understanding of possible courses of action .
& Consult
your own attorney as to legal obligations and rights concerning the ethical conflict .
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-%
©The McGraw-Hill Companies 2008
8-55 M'+ B(<+ 40-45 ?*)(+' =. #he benefits that can be derived from implementing a master budgeting system include the following0
#he preparation of budgets forces management to plan ahead and to establish goals and obectives that can be /uantified. Budgeting compels departmental managers to make plans that are in congruence with the plans of other departments as well as the obectives of the entire firm. #he budgeting process promotes internal communication and coordination of subunit activities. Budgets provide directions for day%to%day operations, clarify duties to be performed, and assign responsibility for these duties. Budgets provide a framework for measuring financial performance. A properly implemented budgeting system can motivate employees and managers to higher levels of performance, particularly if goals and outputs are linked through appropriate incentives. Budgets allow managers to anticipate problem areas &e.g., cash short%falls' and opportunities &e.g., short%term investment of e!cess cash'.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-!0
©The McGraw-Hill Companies 2008
8-55 C,)+*)(< C. a 8 b0 #he basic intent here is to demonstrate the interrelationships that e!ist among budgets contained in the organization’s master budget. "chedule$"tatement "ales Budget
"ubse/uent Budget "chedule$"tatement Production Budget "elling +!pense Budget Budgeted )ncome "tatement
+nding )nventory Budget &units'
Production Budget
Production Budget &units'
:irect aterials Purchases Budget :irect aterials Msage Budget :irect Qabor Budget Factory (verhead Budget
:irect aterials Budget :irect Qabor Budget Factory (verhead Budget 5ost of *oods anufactured Budget
5ost of *oods anufactured Budget 5ost of *oods anufactured Budget 5ost of *oods anufactured Budget 5ost of *oods "old Budget
5ost of *oods "old Budget
Budgeted )ncome "tatement Budgeted Balance "heet
"elling +!pense Budget Eesearch 8 :evelopment Budget Budgeted )ncome "tatement
Budgeted )ncome "tatement Budgeted )ncome "tatement Budgeted Balance "heet
5apital +!penditures Budget 5ash Eeceipts Budget 5ash :isbursements Budget
5ash Budget 5ash Budget 5ash Budget
5ash Budget
Budgeted Balance "heet
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-!1
©The McGraw-Hill Companies 2008
8-56 C,?)'*; P,.*+ P%) 90 ?*)(+' =. "ales Budget S*) M)(./+(*) C,?) S%' B(<+ 2007 "ales &in units' ! "elling Price Per Mnit #otal "ales Eevenue
5=C =C,@@@ N=@ $1#800#000
:H >,@@@ NCC@ $1#980#000
#otal C=,@@@ $3#780#000
C. Production Budget "pring anufacturing 5ompany Production Budget C@@H 5=C Budgeted "ales &in units' =C,@@@ O :esired finished goods ending inventory -@@ #otal units needed =C,-@@ U Beginning finished goods inventory D@@ 11#900 Budgeted Production &in units'
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-!2
:H >,@@@ C@@ >,C@@ =@ 9#050
©The McGraw-Hill Companies 2008
8-56 &5ontinued%=' -. :irect aterials Purchases Budget S*) M)(./+(*) C,?) D*/+ M+*%' P(/'' B(<+ ()*+' )< <,%%' 2007 5=C Eaw aterial &E' =0 Budgeted Production Pounds per Mnit E = needed for production Plus0 :esired +nding )nventory &lbs.' #otal E = needed &lbs.' Qess0 Beginning inventory &lbs.' Ee/uired purchases of E = &lbs.' 5ost per pound Budgeted purchases, E =
==,>@@ ! =@ ==>,@@@
>,@@ ! HC,D@@
==,>@@ !@ @
>,@@ !D -G,C@@
==,>@@ !C C-,@@
>,@@ != >,@@
Eaw aterial &E' C0 Budgeted Production Pounds per Mnit E C needed for production Plus0 :esired +nding )nventory &lbs.' #otal E C needed &lbs.' Qess0 Beginning inventory &lbs.' Ee/uired purchases of E C &lbs.' 5ost per pound Budgeted purchases, E C Eaw aterial -0 Budgeted Production Pounds per Mnit E - needed for production Plus0 :esired +nding )nventory &lbs.' #otal E - needed &lbs.' Qess0 Beginning inventory &lbs.' Ee/uired purchases of E - &lbs.' 5ost per pound Budgeted purchases, E -
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
:H
8-!
#otal
=>=,D@@ D,@@@ =>,D@@ -,@@@ 192#400 NC.@@ $384#800
-G,C@@ =,@@@ -H,C@@ =,@@ 35#700 NC.@ $89#250
-C,@ =,@@ -D,-@ =,@@@ 33#350 N@.@ $16#675
©The McGraw-Hill Companies 2008
8-56 &5ontinued%C' D. :irect anufacturing Qabor Budget S*) M)(./+(*) C,?) D*/+ &, B(<+ 2007 Budgeted production :irect labor hours per unit #otal direct labor hours needed Tourly wage rate Budgeted direct labor costs
5=C ==,>@@ ! C C-,@@
:H >,@@ ! CH,=@
#otal @,>@ NC.@@ $1#273#750
. Factory (verhead Budget S*) M)(./+(*) C,?) !/+, O;< B(<+ 2007 Lariable Factory (verhead0 )ndirect materials iscellaneous supplies and tools )ndirect labor Payroll ta!es and fringe benefits aintenance costs Teat, light, and power
N=@,@@@ ,@@@ D@,@@@ C@,@@@ =@,@@ ==,@@@
N-CG,@@
N=C@,@@@ C@,@@@ D-,DC@ N=-,DC@ H=,--@
NCD,H@
Fi!ed Factory (verhead0 "upervision aintenance costs Teat, light, and power #otal 5ash Fi!ed Factory (verhead :epreciation #otal Budgeted Factory (verhead
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
$580#830
8-!!
©The McGraw-Hill Companies 2008
8-56 &5ontinued%-' G. Budgeted 5ost of *oods "old S*) M)(./+(*) C,?) E)<*) !*)*'< G,,<' I);)+, )< B(<+< CGS 2007 "ales volume 5ost per unit &"chedule = and C' 5ost of goods sold
5=C =C,@@@ N>-.@ N=,=C,G@@
:H
#otal C=,@@@
>,@@@ N=-.H@ N=,CC=,-@@
$2#346#900
Finished goods ending inventory 5ost per unit &"chedule = and C' Budgeted ending inventories
-@@ N>-.@ NC,=D@
C@@ N=-.H@ NCH,=D@
$55#280
"chedule =0 5ost per Mnit%%Product 5=C0 5ost +lement E%= E%:irect labor Lariable factory (T &N-CG,@@$@,>@' Fi!ed factory (T &NCD,H@$@,>@' anufacturing cost per unit
)nputs Mnit )nput 5ost Juantity NC.@@ =@ N@.@ C NC.@@ C NG.D@ C N.@@ C
5ost Per Mnit NC@.@@ N=.@@ N@.@@ N=C.@ N=@.@@ $9380
)nputs Mnit )nput 5ost Juantity NC.@@ NC.@ D N@.@ = NC.@@ NG.D@ N.@@ -
5ost Per Mnit N=G.@@ N=@.@@ N@.@ NH.@@ N=>.C@ N=.@@ $13570
"chedule C0 5ost per Mnit%%Product :H0 5ost +lement E%= E%C E%:irect labor Lariable factory (T &N-CG,@@$@,>@' Fi!ed factory (T &NCD,H@$@,>@' anufacturing cost per unit
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-!"
©The McGraw-Hill Companies 2008
8-56 &5ontinued%D' H. Budgeted selling and administrative e!penses0 S*) M)(./+(*) C,?) S%%*) )< A*)*'++*; E)' B(<+ 2007 "elling +!penses0 Advertising "ales salaries #ravel and entertainment :epreciation Administrative e!penses0 (ffices salaries +!ecutive salaries "upplies :epreciation #otal selling and administrative e!penses
NG@,@@@ C@@,@@@ G@,@@@ ,@@@ NG@,@@@ C@,@@@ D,@@@ G,@@@
N-C,@@@
N-C@,@@@ $645#000
. Budgeted )ncome "tatement0 S*) M)(./+(*) C,?) B(<+ I)/,? S++?)+ !, + Y 2007 5=C "ales &part =' N=,@@,@@@ 5ost of goods sold &part G' =,=C,G@@ *ross profit NGHD,D@@ "elling and administrative e!penses &part H' Pre%ta! operating income )ncome ta!es &VD@K' After%ta! operating income
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-!#
:H N=,>@,@@@ =,CC=,-@@ NH,H@@
#otal N-,H@,@@@ C,-DG,>@@ N=,D--,=@@ NGD,@@@ NH,=@@ N-=,CD@ $472#860
©The McGraw-Hill Companies 2008
8-56 &5ontinued%' 1ote to 2nstructor 0 An +!cel spreadsheet solution file is embedded in this document. ;ou can open the spreadsheet 1obect2 that follows by doing the following0
=. Eight click anywhere in the worksheet area below. C. "elect 14orksheet (bect,2 then 1(pen.2 -. #o return to the 4ord document, select 1File2 and then 15lose and return to...2 while you are in the spreadsheet mode.
%FG "pring anufacturing 5ompany =.
"ales Budget "pring anufacturing 5ompany "ales Budget C@@H 5=C
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
:FH
8-!$
#otal
©The McGraw-Hill Companies 2008
8-57 S*) M)(./+(*) C,?)C,?)'*; P,.*+ P%) 90 M*)(+'# &(+ ?(/ %'' *. ('< *) /,)()/+*,) *+ 8-56 )< /,?%+< *+ ) E/% '<'+ =. "ales Budget S*) M)(./+(*) C,?) S%' B(<+ 2007 "ales &in units' ! "elling Price Per Mnit #otal revenue
5=C =C,@@@ N=G@ $1#920#000
:H =,@@@ N=@ $3#240#000
#otal -@,@@@ $5#160#000
C. Production Budget S*) M)(./+(*) C,?) P,<(/+*,) B(<+ 2007 Budgeted "ales &in units' Plus0 :esired finished goods ending inventory #otal units needed Qess0 Beginning finished goods inventory Budgeted Production &in units'
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-!8
5=C =C,@@@ -@@ =C,-@@ D@@ 11#900
:H =,@@@ C@@ =,C@@ =@ 18#050
©The McGraw-Hill Companies 2008
8-57 &5ontinued%=' -. :irect aterials Purchases Budget &units and dollars' S*) M)(./+(*) C,?) D*/+ M+*%' P(/'' B(<+ ()*+' )< <,%%' 2007 5=C :H #otal Eaw aterial &E' =0 Budgeted Production ==,>@@ =,@@ Pounds per Mnit ! =@ ! E = needed for production ==>,@@@ =DD,D@@ CG-,D@@ Plus0 :esired +nding )nventory &lbs.' D,@@@ #otal E = needed &lbs.' CGH,D@@ Qess0 Beginning inventory &lbs.' -,@@@ Ee/uired purchases of E = &lbs.' 264#400 5ost per pound NC.@@ $528#800 Budgeted purchases, E = Eaw aterial &E' C0 Budgeted Production Pounds per Mnit E C needed for production Plus0 :esired +nding )nventory &lbs.' #otal E C needed &lbs.' Qess0 Beginning inventory &lbs.' Ee/uired purchases of E C &lbs.' 5ost per pound Budgeted purchases, E C Eaw aterial -0 Budgeted Production Pounds per Mnit E - needed for production Plus0 :esired +nding )nventory &lbs.' #otal E - needed &lbs.' Qess0 Beginning inventory &lbs.' Ee/uired purchases of E - &lbs.' 5ost per pound Budgeted purchases, E -
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-!%
==,>@@ !@ @
>,@@ !D HC,C@@
==,>@@ !C C-,@@
=,@@ != =,@@
HC,C@@ =,@@@ H-,C@@ =,@@ 71#700 NC.@ $179#250
D=,@ =,@@ D-,-@ =,@@@ 42#350 N@.@ $21#175
©The McGraw-Hill Companies 2008
8-57 &5ontinued%C' D. :irect anufacturing Qabor Budget S*) M)(./+(*) C,?) D*/+ &, B(<+ 2007 Budgeted production :irect labor hours &:QT' per unit #otal direct labor hours needed Tourly wage rate Budgeted direct labor costs
5=C ==,>@@ ! C
:H =,@@ ! -
C-,@@
D,=@
#otal
HH,>@ NC.@@ $1#948#750
. Factory (verhead Budget Lariable (T per :QT &.,? P,& 8-56'0
NG.D@
S*) M)(./+(*) C,?) !/+, O;< B(<+ 2007 Lariable Factory (verhead &NG.D@$:QT ! HH,>@' Fi!ed Factory (verhead0 "upervision aintenance costs Teat, light, and power #otal 5ash Fi!ed Factory (verhead :epreciation #otal Budgeted Factory (verhead Lariable (T rate per :QT Fi!ed (T rate per :QT &NCD,H@$HH,>@ :QTs'
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-"0
ND>,@ N=C@,@@@ C@,@@@ D-,DC@ N=-,DC@ H=,--@
NCD,H@ $753#630 $640 $326812
©The McGraw-Hill Companies 2008
8-57 &5ontinued%-' G. Budgeted 5*" and +nding Finished *oods )nventory Budget S*) M)(./+(*) C,?) E)<*) !*)*'< G,,<' I);)+, )< B(<+< CGS 2007 "ales volume 5ost per unit &"chedule = and C' 5ost of goods sold
5=C =C,@@@ N>@.--GCD N=,@D,@-
:H =,@@@ N=-@.@D-G NC,-D>,@H>
#otal -@,@@@ $3#433#114
Finished goods ending inventory 5ost per unit &"chedule = and C' Budgeted ending inventories
-@@ N>@.--GCD NCH,=@=
C@@ N==D.@ NCG,=@=
$53#202
"chedule =0 5ost per MnitIProduct 5=C0 5ost +lement E%= E%:irect labor Lariable factory (T &N-CG,@@$@,>@' Fi!ed factory (T &NCD,H@$HH,>@' anufacturing cost per unit
)nputs Mnit )nput 5ost Juantity NC.@@ =@ N@.@ C NC.@@ C NG.D@ C N-.CG=C C
5ost Per Mnit NC@.@@ N=.@@ N@.@@ N=C.@ NG.-GCD $9033624
)nputs Mnit )nput 5ost Juantity NC.@@ NC.@ D N@.@ = NC.@@ NG.D@ N-.CG=C -
5ost Per Mnit N=G.@@ N=@.@@ N@.@ NH.@@ N=>.C@ N>.@D-G $13050436
"chedule C0 5ost per MnitIProduct :H0 5ost +lement E%= E%C E%:irect labor Lariable factory (T &N-CG,@@$@,>@' Fi!ed factory (T &NCD,H@$HH,>@' anufacturing cost per unit
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-"1
©The McGraw-Hill Companies 2008
8-57 &5ontinued%D' H. "elling and Administrative +!pense Budget S*) M)(./+(*) C,?) S%%*) )< A*)*'++*; E)' B(<+ 2007 "elling +!penses0 Advertising "ales salaries #ravel and entertainment :epreciation Administrative e!penses0 (ffices salaries +!ecutive salaries "upplies :epreciation #otal selling and administrative e!penses
NG@,@@@ C@@,@@@ G@,@@@ ,@@@ NG@,@@@ C@,@@@ D,@@@ G,@@@
N-C,@@@
N-C@,@@@ $645#000
. Budgeted )ncome "tatement S*) M)(./+(*) C,?) B(<+ I)/,? S++?)+ !, + Y 2007 5=C "ales &part =' N=,>C@,@@@ 5ost of goods sold &part G' =,@D,@- *ross profit N-,>G "elling and administrative e!penses &part H' Pre%ta! operating income )ncome ta!es &VD@K' After%ta! operating income
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-"2
:H N-,CD@,@@@ C,-D>,@H> N>@,>C=
#otal N,=G@,@@@ -,D--,==D N=,HCG,G NGD,@@@ N=,@=,G ND-C,HD $649#132
©The McGraw-Hill Companies 2008
8-57 C,)+*)(<-5 Answers0 =. #he proected increase in after%ta! operating income NGD>,=-C U NDHC,G@ $176#272 C. 4hile the changes are proected to increase after%ta! operating income, the company should e!amine the decision more closely. Although the company increases its after%ta! operating income by -HK &N=HG,CHC$NDHC,G@', it re/uires a doubling of units of :H to achieve this. )n fact, a =@@K increase in units sold of :H increases the gross profit of :H from NH,H@@ to N>@,>C=, an increase of N=-C,CC=, while the total change in gross profit is NC>-,HG &from N=,D--,=@@ to N=,HCG,G'. #he =@@K increase in :H accounts for only DK &N=-C,CC= ÷ NC>-,HG' of the increase in gross profit 5=C contributes K of the increase. Further, the price increase in 5=C has no effect on the units sold. #his may be an indication that 5=C may have a higher potential than the firm perceived. 1ote to 2nstructor 0 An +!cel spreadsheet solution file is embedded in this document. ;ou can open the spreadsheet 1obect2 that follows by doing the following0
=. Eight click anywhere in the worksheet area below. C. "elect 14orksheet (bect,2 then 1(pen.2 -. #o return to the 4ord document, select 1File2 and then 15lose and return to...2 while you are in the spreadsheet mode.
%FH "pring anufacturing 5ompany =. Budgeted "ales &units'0 5=C =C,@@@ :FH =,@@@ Budgeted "elling Prices$Mnit0 5=C N=G@ :FH N=@
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-"
©The McGraw-Hill Companies 2008
8-58 C,?)'*; P,.*+ P%) *+ Kaizen 90 ?*)(+'# &(+ ?(/ %'' *. ''*)< *) /,)()/+*,) *+ 8-56 )< /,?%+< *+ ) E/% '<'+ =. "ales Budget S*) M)(./+(*) C,?) S%' B(<+ 2007 "ales &in units' ! "elling Price Per Mnit #otal revenue
5=C =C,@@@ N=@ $1#800#000
:H >,@@@ NCC@ $1#980#000
#otal C=,@@@ $3#780#000
C. Production Budget S*) M)(./+(*) C,?) P,<(/+*,) B(<+ 2007 Budgeted "ales &in units' Plus0 :esired finished goods ending inventory #otal units needed
5=C =C,@@@ -@@
:H >,@@@ C@@ =C,-@@
>,C@@ Qess0 Beginning finished goods inventory Budgeted Production &in units'
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
D@@ 11#900
8-"!
=@ 9#050
©The McGraw-Hill Companies 2008
8-58 &5ontinued%=' -. :irect aterials Purchases Budget &units and dollars' S*) M)(./+(*) C,?) D*/+ M+*%' P(/'' B(<+ ()*+' )< <,%%' 2007 5=C Eaw aterial &E' =0 Budgeted Production Pounds per Mnit E = needed for production Plus0 :esired +nding )nventory &lbs.' #otal E = needed &lbs.' Qess0 Beginning inventory &lbs.' Ee/uired purchases of E = &lbs.' 5ost per pound Budgeted purchases, E =
==,>@@ !> =@H,=@@
>,@@ !H G-,-@
==,>@@ !@ @
>,@@ ! -.G -C,@
==,>@@ ! =. C=,DC@
>,@@ ! @. H,CD@
Eaw aterial &E' C0 Budgeted Production Pounds per Mnit E C needed for production Plus0 :esired +nding )nventory &lbs.' #otal E C needed &lbs.' Qess0 Beginning inventory &lbs.' Ee/uired purchases of E C &lbs.' 5ost per pound Budgeted purchases, E C Eaw aterial -0 Budgeted Production Pounds per Mnit E - needed for production Plus0 :esired +nding )nventory &lbs.' #otal E - needed &lbs.' Qess0 Beginning inventory &lbs.' Ee/uired purchases of E - &lbs.' 5ost per pound Budgeted purchases, E -
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
:H
8-""
#otal
=H@,D@ D,@@@ =HD,D@ -,@@@ =H=,D@ NC.@@ $342#900
-C,@ =,@@@ --,@ =,@@ -C,@@ NC.@ $80#200
C,GG@ =,@@ -@,=G@ =,@@@ C>,=G@ N@.@ $14#580
©The McGraw-Hill Companies 2008
8-58 &5ontinued%C' D. :irect anufacturing Qabor Budget S*) M)(./+(*) C,?) D*/+ &, B(<+ 2007 Budgeted production :irect labor hours per unit #otal direct labor hours needed Tourly wage rate Budgeted direct labor costs
5=C ==,>@@ ! =. =H,@
:H >,@@ ! C =,=@@
#otal -,>@ N-@.@@ $1#078#500
. Factory (verhead Budget S*) M)(./+(*) C,?) !/+, O;< B(<+ 2007 (riginal Lariable (T Budget0 )ndirect materials iscellaneous supplies and tools )ndirect labor Payroll ta!es and fringe benefits aintenance costs Teat, light, and power #otal Lariable Factory (verhead
N=@,@@@ ,@@@ D@,@@@ C@,@@@ =@,@@ ==,@@@ N-CG,@@
Eeduction Eate for Lariable (T 5osts
=@.@@K
(riginal Fi!ed (T, +!cluding :epreciation0 "upervision aintenance costs Teat, light, and power #otal 5ash Fi!ed Factory (verhead :epreciation #otal (riginal Fi!ed (T Eeduction Eate for Cash Fi!ed (T 5osts
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-"#
N=C@,@@@ C@,@@@ D-,DC@ N=-,DC@ H=,--@ NCD,H@ .@@K
©The McGraw-Hill Companies 2008
8-58 &5ontinued%-' Budgeted Lariable (T0 &N-CG,@@ ! &= % @.=@'' Budgeted Fi!ed (T0 5ash 5harges &N=-,DC@ ! &= % @.@'' :epreciation &same as last year' #otal Budgeted Fi!ed (T
$293#472
N=HD,CD> NH=,--@ $245#579
G. Budgeted 5*" and +nding Finished *oods )nventory Budget S*) M)(./+(*) C,?) E)<*) !*)*'< G,,<' I);)+, )< B(<+< CGS 2007 "ales volume 5ost per unit &"chedule = and C' 5ost of goods sold
5=C =C,@@@ NG.->=H@ N=,@-G,H@@
:H
#otal C=,@@@
>,@@@ N==-.->N=,@C@,@@
$2#057#200
Finished goods ending inventory 5ost per unit &"chedule = and C' Budgeted ending inventories
-@@ NG.->=H@ NC,>=
C@@ N==-.->NCC,GH
$48#596
"chedule =0 5ost per MnitIProduct 5=C0 5ost +lement E%= E%:irect labor Lariable factory (T &NC>-,DHC$-,>@' Fi!ed factory (T &NCD,H>$-,>@' anufacturing cost per unit
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
)nputs Mnit )nput 5ost Juantity NC.@@ > N@.@ =. N-@.@@ =. N.=G--D =. NG.-===.
8-"$
5ost Per Mnit N=.@@ N@.>@ ND.@@ N=C.CD@= [email protected]> $8639170
©The McGraw-Hill Companies 2008
8-58 &5ontinued%D' "chedule C0 5ost per MnitIProduct :H0 5ost +lement E%= E%C E%:irect labor Lariable factory (T &NC>-,DHC$-,>@' Fi!ed factory (T &NCD,H>$-,>@' anufacturing cost per unit
)nputs Mnit )nput 5ost Juantity NC.@@ H NC.@ -.G N@.@ @. N-@.@@ C N.=G--D C NG.-==C
5ost Per Mnit N=D.@@ N>.@@ [email protected]@ NG@.@@ N=G.-CGG N=-.GGCC $11338893
H. "elling and Administrative +!pense Budget S*) M)(./+(*) C,?) S%%*) )< A*)*'++*; E)' B(<+ 2007 "elling +!penses0 Advertising NG@,@@@ "ales salaries C@@,@@@ #ravel and entertainment G@,@@@ :epreciation ,@@@ N-C,@@@ Administrative e!penses0 (ffices salaries NG@,@@@ +!ecutive salaries C@,@@@ "upplies D,@@@ :epreciation G,@@@ N-C@,@@@ #otal selling and administrative e!penses
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
$645#000
8-"8
©The McGraw-Hill Companies 2008
8-58 &5ontinued%' . Budgeted )ncome "tatement S*) M)(./+(*) C,?) B(<+ I)/,? S++?)+ !, + Y 2007 5=C "ales &part =' N=,@@,@@@ 5ost of goods sold &part G' =,@-G,H@@ *ross profit NHG-,-@@ "elling and administrative e!penses &part H' Pre%ta! operating income )ncome ta!es &VD@K' After%ta! operating income
:H N=,>@,@@@ =,@C@,@@ N>>,@@
#otal N-,H@,@@@ C,@H,C@@ N=,HCC,@@ NGD,@@@ N=,@HH,@@ ND-=,=C@ $646#680
A)'': =. #he budgeted after%ta! operating income with 9aizen is $646#680. C. #he immediate benefit is an increase of N=H-,C@ in operating income, or -HK from NDHC,G@. #he firm is also likely benefit in the long%run from the reductions in materials, labor hours, and factory overhead re/uired in production. :ecreases in consumption of manufacturing elements reduce wear and tear of e/uipment and other facilities and lessens the need for additional capital investments$replacements. 1ote to 2nstructor 0 An +!cel spreadsheet solution file is embedded in this document. ;ou can open this spreadsheet 1obect2 that follows by doing the following0
=. Eight click anywhere in the worksheet area below. C. "elect 14orksheet (bect,2 then 1(pen.2 -. #o return to the 4ord document, select 1File2 and then 15lose and return to...2 while you are in the spreadsheet mode.
%F "pring anufacturing 5ompany =. Budgeted "ales &units'0
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-"%
©The McGraw-Hill Companies 2008
8-59 R+*% B(<+ 45-50 ?*)(+' =. Budgeted merchandise purchases D T,?%*)',) R+*% B(<+< M/)<*' P(/'' M )< J() ay "ales &in units' 5ost per unit 5ost of *oods "old &5*"' +nding inventory &=-@K of ne!t months 5*"' #otal needed Beginning inventory &=-@K of this months 5*"' Budgeted erchandise Purchases
==,>@@ ! NC@ NC-,@@@ O C>G,D@@ N-D,D@@
O
U -@>,D@@ $225#000
U C>G,D@@ $243#600
-=C,@@@ ND@,@@@
C. Budgeted cash disbursements ", *, 8 A e!penses0 "ales revenue ", *, 8 A e!pense ratio #otal ", *, 8 A e!pense Qess0 :epreciation (ut%of%pocket ", * 8 A e!pense
ay N-H,@@@ ! @.= N -,@ U C,@@@ N =,@
,-@@
D T,?%*)',) R+*% B(<+< C' D*'&('?)+' ., J() erchandise purchases (ut%of%Pocket ", *, 8 A e!penses #otal payables Payment for the current month’s payables &DK' (wed from last month &DGK' Budgeted cash outflow for payables
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-#0
ay N CC,@@@ O =,@ NCHG,@
,-@@ NC>C,>@@ N=,=GG O =CH,C=$285#379
©The McGraw-Hill Companies 2008
8-59 &5ontinued' -. Budgeted cash collections D T,?%*)',) R+*% C' C,%%/+*,)' M From last months &April' credit sales 4ithin the discount period After the discount period
&N-G-,@@@' ! G@K ! >HK N-G-,@@@ ! CK
NC==,CGG >@,H@
From credit sales two months ago &i.e., arch' 5ollection of credit sales made in arch
N-D,@@@ ! >K
#otal cash collections
-=,G@ $333#876
D. *ross and 3et Balance of Accounts Eeceivable &AE' as of ay -= "ales Eemaining AE K AE Balance &*ross' Bad%debt allowanceY AE Balance &3et'
arch N-D,@@@ GK NC=,CD@ NC=,CD@
April N-G-,@@@ =K ND,D@ NC=,H@
ay N-H,@@@ =@@K N-H,@@@ NC=,DC@
#otal $432#690 GD,DD@ $368#250
Y V GK of gross sales dollars
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-#1
©The McGraw-Hill Companies 2008
8-60 S%' &(<+ )< ,-.,? .*))/*% '++?)+' 75 ?*)(+' =. (riginal Budget :ata "ales &units'0 Beginning inventory of finished goods &>$=$C@@H'
>,-@@
+stimated production for the C@@H% fiscal year
=GC,@@@
Mnits available for sale
=H=,-@@
Planned ending finished goods inventory &$-=$C@@'
-,-@@
Proected unit sales, C@@H% fiscal year
=G,@@@
"elling price$unit0 "elling Price$Mnit
Proected :ollars of "ales Proected Mnit "ales N-=,CD,@@ @ N=G =G,@@@
a. 8 b. Eevised sales volume%%units and dollars0 "ales in units in the original budget &see above' )ncrease in units of production &=H@,@@@ % =GC,@@@'Y Eevised total salesIunits
=G,@@@ O
,@@@
176#000
"elling price per unit &see above'
! N
Eevised proected dollar%volume of net sales
=G
$32#736#000
Y4ith no change in the ending finished goods inventory &-,-@@ units' the increase in production is a result of the e!pected increase in sales.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-#2
©The McGraw-Hill Companies 2008
8-60 &5ontinued%=' C. M,%*< C,?) P,-!,? S++?)+ ,. C,'+ ,. G,,<' S,%< R;*'< !, + Y E)<*) A(('+ 31# 2008 :irect materials0 aterials inventory, >$=$@H
N =,-G@,@@@
aterials purchases=
=,HG,@@@
aterials available for use
N=G,>-G,@@@
aterials inventory, $-=$@ C
=,H@>,D@@
:irect aterials used
N=,CCG,G@@
:irect labor -
=,C=,C@@
Factory overhead0 )ndirect material D
N =,CC,GG@
*eneral factory overhead
-,-C@,@@@
5ost of goods manufactured
D,DC,GG@ NC=,CD,DG@
Plus0 Finished goods inventory, >$=$@H &given' 5ost of goods available for sale
=,=G>,@@@ NCC,D-,DG@
Qess0 Finished goods inventory, $-=$@G
D=-,=G>
$ 22#040#291
5ost of goods sold =
"upporting 5alculations &units represent 1e/uivalent units of output2'0 -H,@@ units
V N.@@Y
N -,-@@,@@@
D,@@@ unitsYY
V N.@@
>@,@@@ units
V N>C.D@YYY
-,>G@,@@@ ,-=G,@@@ N=,HG,@@@
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-#
©The McGraw-Hill Companies 2008
8-60 &5ontinued%C' YN-,-@@,@@@$-H,@@ units N.@@ YY:esired ending inventory of materials aterials needed for production this year #otal materials needed Beginning inventory #otal materials purchases for the year Qess0 aterials purchased in the = st /uarter aterials yet to be purchased during the year 3umber of remaining /uarters aterials to be purchased in each remaining /uarter
O U U Z
=,@@ =H@,@@@ =,@@ =G,@@@ =HC,@@ -H,@@ =-,@@@ D,@@@
YYYN.@@ ! =.@ N>C.D@ =,@@ units V N>C.D@ N=,H@>,D@@
C
-
:irect labor cost N=,=-D,@@@ ! N=,=>@,@@@ !
=H@,@@@ units =GC,@@@ units
N=,=>@,@@@
DF,@@@ units ! .@ =H@,@@@ units
CF,C@@ N=,C=F,C@@
D
)ndirect material0N=,CCG,G@@ ! @.=@ N=,CC,GG@
*eneral factory overhead0 Lariable0 N=,GC@,@@@ ! &=H@,@@@units$=GC,@@@units' Fi!ed N-,CD@,@@@ ! =$C #otal N-,-C@,@@@
G
Average manufacturing cost$unit, C@@H%0 NC=,CD,DG@ $=H@,@@@ units +nding finished goods inventory &units' ! -,-@@ 5ost of ending finished goods inventory &F)F( basis'
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-#!
N=,H@@,@@@ =,GC@,@@@
N=C.C@CH N D=-,=G>
©The McGraw-Hill Companies 2008
8-60 &5ontinued%-' -. a. "avings in working capital from eliminating ending inventory0 Finished goods :irect materials #otal savings
N>C.D@ ! &=,@@ U =@@'
N D=-,=G> =,H@@,=G@ NC,==-,-C>
#he firm can reduce the need for working capital by NC,==-,-C>. #he final net savings depends on the cost of capital of the firm. At =@K, the company saves financing costs of over NC@@,@@@ per year. #he firm can save more than NC==,--per year if the cost of capital e!ceeds =@K. 3ote that this estimate refers to financing &cost%of%capital%related' costs, not operating costs. b. ;es. Mnder the assumption that the company’s cost of capital is =@K, the economic savings would represent about DK of its current pre%ta! operating income figure, as shown below. 3ote that these savings put the company in an improved economic position, although the formal accounting statements might not reflect this. As such, this gives the instructor the opportunity to discuss with students the notion of 1+conomic Lalue Added2 &+LA[' as alternative financial performance indicator to conventional accounting income statements. M,%*< C,?) P,-!,? S++?)+ I)/,? S++?)+ !, + Y E)<*) A(('+ 31# 2008 3et sales &part =b above' 5ost of goods sold &part C above' *ross profit (perating e!penses &givenIsee te!t'0 arketing N-,C@@,@@@ *eneral and administrative C,C@@,@@@ )ncome from operations before income ta!es
N-C,H-G,@@@ CC,@D@,C>= N=@,G>,H@> ,D@@,@@@ N ,C>,H@>
NC==,---$N,C>,H@> DK c. )n addition to financial terms, the firm needs to consider carefully, among other items0 ade/uacy of the firms e/uipment to support the new system proficiency of the firms accounting information system to handle the new system support of vendors acceptance of factory managers and production workers
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-#"
©The McGraw-Hill Companies 2008
8-61 B(<+*) ., M/)<*'*) !*? 50-60 ?*)(+' =. Budgeted cash collectionsI:ecember0 From 3ovember’s sales net A$E, 3ovember -@th From :ecember’s sales NCC@,@@@ ! G@K ! >>K Budgeted cash collections%%:ecember C. 3et accounts receivableI:ecember -= st0 Budgeted sales in :ecember &given' Allowance for doubtful accounts 3et A$E from sales in :ecember 5ollections of :ecember sales in :ecember
N HG,@@@ =-@,G@ $206#680
NCC@,@@@ ! CK NCC@,@@@ ! G@K
3et Accounts EeceivableI:ecember -=st
NCC@,@@@ D,D@@ NC=,G@@ =-C,@@@ $ 83#600
-. Budgeted pre%ta! operating incomeI:ecember0 #otal sales *ross margin ratio *ross margin (perating e!penses0 onthly cash operating e!penses Bad%debts e!pense NCC@,@@@ ! CK :epreciation e!pense NC=G,@@@$=C Pre%ta! operating income
NCC@,@@@ ! CK N ,@@@ NCC,G@@ D,D@@ =,@@@
D,@@@ $10#000
D. Budgeted )nventoryI:ecember -= st0 )nventory, :ecember -=st
&NC@@,@@@ ! @.H' ! @K
$120#000
)nventory, :ecember =st &given' P%(': P(/'' <(*) D/?& %( .*( K 5ost of goods available for sale Qess0 5ost of goods sold NCC@,@@@ ! HK st )nventory, :ecember -= &part D above'
N=-C,@@@ 153#000 NC,@@@ =G,@@@ N=C@,@@@
. Budgeted PurchasesI:ecember0
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-##
©The McGraw-Hill Companies 2008
8-61 C,)+*)(< G. Budgeted Accounts PayableI:ecember -= st0 Accounts Payable, :ecember =st &given' Plus0 Budgeted Purchases, :ecember &part above' #otal Accounts Payable during :ecember Qess0 Payments in :ecember &entire beginning balance' Budgeted Accounts Payable, :ecember -=st
N=GC,@@@ N=-,@@@ N-=,@@@ N=GC,@@@ $153#000
Alternatively, the end%of%:ecember Accounts Payable Balance Purchases made in :ecember answer to Part above.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-#$
©The McGraw-Hill Companies 2008
8-62 B(<+' ., S;*/ !*? 50 M*)(+' =. #he annual cash budget is presented on the ne!t page. C. (perating problems that #riple%F Tealth 5lub could e!perience include0
&he cash contribution from lessons and classes will decrease because the pro9ected wage increase for lesson and class employees is significantly greater than the pro9ected increases in revenues 6i.e., in additional volume7 . Qast year, the cash generated from these operations was N->,@@@ &NC-D,@@@ U N=>,@@@'. #he C@@> proection is only N=C,GH &N-@D,C@@ U NC>=,C'. 4perating e%penses are increasing faster than revenues from membership fees. Qast year &C@@', cash generated from regular operations was N>=,@@@ R&N-,@@@ O NC,@@@' U &NDG=,@@@ U N=>,@@@'S. #he C@@> proection is only N>C,DC R&ND@C,C= O NC,GGH' U &NG@-,>C U NC>=,C'S. #he increase in cash from regular operations is proected to be about DK, whereas these revenues are proected to increase =-K. &riple- :ealth Club seems to have a cash-management problem . #he club does not generate enough cash from operations to meet its obligations. )t may not be able to meet e!penditures for day%to%day operations if the trend continues. #o avoid cash crises, the club should prepare monthly cash budgets to help cash management. 1on-operational payments are pro9ected to use up virtually all of the cash generated from operations. *iven the recent declines in mortgage interest rates, management should consider refinancing this debt to reduce this cash drain.
-. budget proections show only a minimal increase in the cash balance &i.e., an increase of only NC,HH'. #he total cash available is well short of the NG@,@@@ annual additional cash needed for the land purchase. )f the Board desires to purchase the adoining property, it is going to have to consider increases in fees, refinancing e!isting debt, or other methods of financing the ac/uisition &such as additional mortgage debt or membership bonds'.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-#8
©The McGraw-Hill Companies 2008
8-62 &continued' TRIPE-! HEATH CUB C' B(<+ !, + Y E)<*) O/+,& 31# 2009 C@@ O+*) C' I).%,': Annual membership fees Qesson and class fees iscellaneous #otal (perating 5ash )nflows
N-,@@@ C-D,@@@ C,@@@ $591#000
Price *rowth )ncrease -.@K -@.@K --.--K
C@@>
=@.@K
ND@C,C= -@D,C@@ C,GGH $709#082
O+*) C' O(+.%,': anager’s salary and benefits +mployee wages and benefits0 Eegular employees Qesson and class employees #owels and supplies Mtilities &heat and lights' iscellaneous Payoff of outstanding A$P #otal (perating 5ash (utflows
N-G,@@@
=.@K
ND=,D@@
=>@,@@@ =>,@@@ =G,@@@ CC,@@@ C,@@@ 3$A $461#000
=.@K =.@K C.@K C.@K C.@K given
C=,@@ C>=,C C@,@@@ CH,@@ C,@@ C,@@ $603#925
N+ O+*) C' !%,
$130#000
N,)-O+*) C' O(+.%,': Payoff of e/uipment payable ortgage principal ortgage interest Planned e/uipment purchases #otal 3on%(perating 5ash (utflow
$102#400 given given given
3et 5ash Flow Beginning 5ash Balance &given' B(<+< E)<*) C' B%)/ WWWWWWWWWWWWWWW = N-G@,@@@ ! @.@> N-C,D@@
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
-@.@K
N=,@@@ -@,@@@ -C,D@@ C,@@@ $104#900 NC,HH H,-@@ $10#057
8-#%
©The McGraw-Hill Companies 2008
8-63 B(<+*) ., M=+*) E)'' S++ 45-50 ?*)(+' =. #he following screen shots are from the +!cel spreadsheet created for this problem. )t shows that the original monthly budgeted marketing e!pense is N--,@@@ and that the revised &budgeted' amount is $372#628# an overall increase of [email protected].
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-$0
©The McGraw-Hill Companies 2008
8-63 &5ontinued'
C. )n order to achieve the monthly targeted cost of N-@,@@@, the rate of 1telephone and mailing2 costs cannot increase at all &as is the case in the proposed budget' in fact, the results of the 1goal seek2 analysis indicates that such rates must be decreased by appro!imately D-K, as shown below0
#hese results are generated by completing the following dialog bo! that appears after activating the 1goal%seek2 command from the #ools menu in +!cel0
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-$1
©The McGraw-Hill Companies 2008
8-63 &5ontinued'
-. As indicated in the te!t, budgets can be used both for control and for planning purposes. #he relative importance of each can be linked either to the competitive strategy the business is pursuing or to the product life%cycle. )n the present case &start%up company, competing on the basis of a product%differentiation strategy', the relative emphasis of the marketing budget is likely more for planning than control. #hat is, the information contained in this budget can assist the company in determining its financing needs. Towever, it probably should not be used for 1controlling2 &i.e., cutting' e!penses in situations where the underlying e!penditures are determinants of competitive success. Further, many types of so%called 1discretionary costs2 &such as marketing' are fi!ed &or at least 1sticky2' and therefore difficult to cut in the short run. As such, the primary benefit of the budget in such cases is to better plan for, rather than control, the underlying e!penses. 1ote to 2nstructor 0 #he +!cel spreadsheet solution referred to above is embedded in this document. ;ou can open the spreadsheet 1obect2 by doing the following0
=. Eight click anywhere in the worksheet area below. C. "elect 14orksheet (bect,2 then 1(pen.2 -. #o return to the 4ord document, select 1File2 and then 15lose and return to...2 while you are in the spreadsheet mode.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-$2
©The McGraw-Hill Companies 2008
8-64 S++# ,<(/+ %*.-//%# )< /' .%, 25-30 ?*)(+' =. #he development stage is generally characterized by large cash outflows and little or no cash inflows. +!penditures for research and development, plant and e/uipment, retooling, distribution, and promotion are re/uired. :uring this stage, a proect or company normally generates losses and may re/uire an infusion of outside capital. :uring the growth stage , sales and revenues rise rapidly. "ignificant cash inflows are generally present however, these may be offset in part or completely by cash outflows to build production capacity and for growing inventories and receivables. :uring this stage, manufacturing efficiencies will improve contribution margins as volume increases. :uring the maturity stage , net cash inflows are generally at an optimum. Production capacity is in place and inventories and receivables should approach a steady state. Towever, by this stage, competitors generally have entered the market resulting in higher promotional costs to maintain market share. As a conse/uence, margins may begin to decline. :uring the decline stage , both sales volume and profits fall. )ncreased price competition and the increased availability of alternative products will reduce margins. #he declining volume will generally increase the unit cost at the manufacturing level. "ometimes, significant cash inflows can be generated from the li/uidation of inventories and other product%related assets. C. #he maturity stage , the period of optimum net cash inflows, is missing from Burke 5ompanys product cycle. #he company must be able to generate or raise sufficient cash to support E 8 :, capital investment, and promotional costs during the development stages and depend on the growth stage for significant cash inflows. #his will re/uire rapid improvement in manufacturing efficiencies and careful investment in production facilities and inventories. )n addition, inventory control is e!tremely important in order to minimize cash investment and reduce potential obsolescence. -. #he techni/ues that :evin 4ard should consider to cope with Burke 5ompanys cash%management problems include0 careful, timely cash%flow proections and monitoring, matching the cash receipts from products in the growth stage with the e!penditures for products in the development stage. establishing good banking relationships and fle!ible lines of credit to facilitate short%term borrowing needs. aggressive accounts%receivable management. tight control of materials purchasing and inventory management. improved cost controls.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-$
©The McGraw-Hill Companies 2008
timely decisions on inventory li/uidation as product life cycles near collapse.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-$!
©The McGraw-Hill Companies 2008
8-65 C,)+*)(,(' &(<+*) 25-30 ?*)(+' =.a. #he increase in sales could have the following effects on production 0 Production capacity may have to be reallocated to the three models based upon the composition of the sales increase. "ome parts, in addition to the molded doors, may have to be purchased from outside suppliers. :epending upon the ability to purchase parts from outside suppliers and long%term sales proections, additional capacity may be re/uired.
=.b. #he increase in sales could have the following effects on finance and accounting 0 "hort%term financing may be needed to finance increased receivable levels and for the replacement of depleted inventories. Qong%term financing may be needed to e!pand production capacity. Budgeting may have to be revised because sales volume is probably beyond the relevant range assumed for the current budget.
=.c.
#he increase in sales could have the following effects on mareting 0 #he need to advertise will probably decrease. )nvestigation into the credit%worthiness of potential credit customers may need to become more thorough and the number of investigations will probably increase. 5ollection efforts may have to be increased unless credit%granting is tightened. 5ustomers may have to accept e!tended shipping dates or may receive units on some rational basis of output allocation.
=.d. #he increase in sales could have the following effects on personnel 0 )ncreased stress levels because of the increased volume. 3eed to schedule additional shifts or overtime, which the employees may deem unnecessary or not beneficial. 3eed to hire additional workers to meet the increase in demand.
C.a. A continuous &rolling' budget is the preparation of a new twelve%month budget as each period &e.g., month, /uarter' is completed. At the end of each period, the budget amounts for the period ust completed are deleted, the amounts for the remaining periods of the old budget are revised as necessary, and budgeted amounts for the new period are added. #hus, a twelve%month budget is rolled forward as each period is completed. C.b. #he preparation of a continuous budget would force 4est4oods management to engage in planning on an almost continuous basis. "horter planning cycles increase the chances that management will anticipate and give attention to problem situations earlier than would otherwise be the case. #hus, planning would be enhanced in all of the functional areas and there would not be any periods when a budget did not e!ist. Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-$"
©The McGraw-Hill Companies 2008
8-66 C' B(<+ 45-50 ?*)(+'
5ash balance, beginning Plus0 5ash receipts0 5ollections from customers +/uipment disposal #otal cash available &A'
) N-@,@@@
5ash disbursements0 Eaw material purchases Payroll ", *, 8 A e!penses +/uipment purchase Bond interest &V>K' Bond sinking fund payment )ncome ta!es #otal cash disbursements, prior to financing &B' Plus0 inimum cash balance #otal cash needed &5'
)L $30,770
;ear $30,000
DC,@@@ 0 $455,000
437,000 0 NDH,@@@
NC@@,@@@ 117,000 G@,@@@ 20,000 0 0 C@,@@@ $417,000 $30,000 $447,000
NCC@,@@@ $250,000 NCH@,@@@ N>D@,@@@ =C@,@@@ ==,@@@ 122,000 DHD,@@@ GC,@@@ ,@@@ GD,@@@ 244,000 30,000 30,000 0 80,000 11,250 0 11,250 22,500 20,000 0 0 20,000 C=,@@@ C,@@@ =,@@@ 84,000 $484,250 $478,000 $485,250 $1,864,500 $30,000 $30,000 $30,000 $30,000 $514,250 $508,000 $515,250 $1,894,500
+!cess cash &cash deficiency', prior to financing &:' &A' % &5' Financing0 "hort%term borrowing Eepayment &principal' )nterest &V=CK' #otal +ffects of Financing &+' +nding cash balance &A' % &B' O &+' Blocher, Stout, Cokins, Chen, Cost Management, 4/e
Juarters )) ))) $38,000 $30,520
DG@,@@@ 1,801,480 5,000 5,000 $495,770 $1,836,480
$8,000
($39,250 )
$2,000
N@ $0 $0 $0
$41,000 $0 ($1,230 ) $39,770
$0 $0 ($1,230 ) ($1,230 )
$22,000 $0 ($1,890) $20,110
$63,000 $0 ($4,350 ) $58,650
$30,520
$30,770
$30,630
$30,630
N-,@@@ 8-$#
479,480 0 N=@,@@@
($19,480)
$(58,020 )
©The McGraw-Hill Companies 2008
8-67 C,?)'*; B(<+ 90 ?*)(+' =. "chedule A0 Budgeted onthly 5ash Eeceipts )tem
August NG,G@@ =G,D@@ NC,@@@
"ept. NHC,@@@ =,@@@ N>@,@@@
NGD,@@@
NG,G@@
NHC,@@@
=,@@@ $79#000
=G,@@@ $81#600
=G,D@@ $88#400
"chedule B0 Budgeted onthly 5ash :isbursements for Purchases
8-67 C,?)'*; B(<+ 90 ?*)(+' =. "chedule A0 Budgeted onthly 5ash Eeceipts )tem
August NG,G@@ =G,D@@ NC,@@@
"ept. NHC,@@@ =,@@@ N>@,@@@
NGD,@@@
NG,G@@
NHC,@@@
=,@@@ $79#000
=G,@@@ $81#600
=G,D@@ $88#400
"chedule B0 Budgeted onthly 5ash :isbursements for Purchases )tem Purchases &V gross cost' 5ash discount &=K of gross cost' 3et purchases
,C@@ D>C $48#708
August ND,@@@ D@ $53#460
"ept. NG@,@@@ G@@ $59#400
-rd Jtr. N=G-,C@@ =,G-C $161#568
"chedule 50 Budgeted onthly 5ash :isbursements for (perating 5osts )tem "alaries and wages Eent 8 Property #a!es (ther cash operating costs #otal
August N=C,=@@ =,@@@ =,GD@ $14#740
"ept. N=C,@@ =,@@@ =,@@ $15#300
-rd Jtr. N-G,G@@ -,@@@ ,@D@ $44#640
"ept. N=,-@@ >,D@@ %@% $74#700
-rd Jtr. NDD,GD@ =G=,G G-,@@ $269#708
"chedule :0 Budgeted 5ash :isbursements Prior to Financing )tem 5ash operating costs 3et purchases +/uipment #otal
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-$$
August N=D,HD@ -,DG@ G-,@@ $131#700
©The McGraw-Hill Companies 2008
8-67 C,)+*)(<-1 "chedule +0 5ash Budget )tem 5ash balance, beginning #otal cash receipts 5ash disbursements prior to financing 5ash balance before financing Financing0 Borrowing re/uired )nterest payment Borrowing repaid 3et effect of financing 5ash balance, ending
,@@@ G-,-@ ND@,G>C
August ND@,G>C =,G@@ =-=,H@@ &N>,D@'
"ept. N->,>GH ,D@@ HD,H@@ N-,GGH
-rd Jtr. NC,@@@ CD>,@@@ CG>,H@ ND,C>C
N@ N@ N@ N@ $40#692
N@,@@@ NGC N@ ND>,-H $39#967
N@ NGC NC@,@@@ &NC@,GC' $33#042
N@,@@@ N=,C@ NC@,@@@ NC,H@ $33#042
inimum cash balance re/uired 5heck for minimum balance
N-@,@@@ (9
N-@,@@@ (9
N-@,@@@ (9
N-@,@@@ (9
C. G,%< S,+*) EL(*?)+ B(<+< I)/,? S++?)+ !, + T*< Q(+# 2007 "ales 5ost of *oods "old &sales ! &= % @.D@' ! &= % @.@='' *ross Profit (perating +!penses0 "alaries 8 wages Eent 8 property ta!es :epreciation (ther operating e!penses
NCC,@@@ N=D>,G N=@C,-=C N-G,G@@ N-,@@@ NC,D@@ N,@D@
NDH,@D@
(perating )ncome (ther )ncome$+!penses0
N,CHC
)nterest +!pense Pre%ta! )ncome )ncome #a!es &VCK' 3et )ncome
N=,C@ ND,@CC N=-,@G $40#516
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-$8
©The McGraw-Hill Companies 2008
8-67 C,)+*)(<-3 G,%< S,+*) EL(*?)+ B(<+< B%)/ S+ J() 30 + )< S+?& 30 +# 2007
"eptember -@th
Assets 5ash Accounts Eeceivable &A$E' erchandise )nventory Building and e/uipment &net' #otal Assets
NC,@@@ N=,@@@ NDH,C@ NC@@,@@@ NCH,C@
N--,@DC N=,@@@= N>,D@@C N-CD,G@@ND-,@DC
Qiabilities and "tockholders’ +/uity "hort%term payable &new e/uipment purchase' "hort%term bank loan payable )ncome #a! Payable #otal Qiabilities "tockholders +/uity #otal Qiabilities 8 "tockholders’ +/uity
N@ N@ N@ N@ NCH,C@ NCH,C@
NG-,@@ N-@,@@@ N=-,@G N=@H,@@G N-C,@-H ND-,@DC
N,+': 1 5redit sales made in "eptember, to be collected in (ctober C 3et merchandise purchases made in "eptember &to meet e!pected sales in (ctober' Beg. Balance &net' O 3ew +/uipment Purchased U :epreciation +!pense NC@@,@@@ O N=CH,@@@ U NC,D@@ 1ote to 2nstructor 0 An +!cel spreadsheet solution file is embedded in this document. ;ou can open the spreadsheet 1obect2 that follows by doing the following0
=. Eight click anywhere in the worksheet area below. C. "elect 14orksheet (bect,2 then 1(pen.2 -. #o return to the 4ord document, select 1File2 and then 15lose and return to...2 while you are in the spreadsheet mode.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-
%$©The McGraw-Hill Companies 2008
8-67 C,)+*)(<-4 -. *old needs to borrow to finance part of the payment for the new e/uipment during the third /uarter. )n addition, fluctuations in business may re/uire the firm to seek short%term loans. Payrolls, materials, and supplies have to be paid before collections from customers. )n anticipation of rising sales in the coming season, *old may e!perience a peak demand for cash to pay for the increased purchases of materials, payrolls, and supplies while collections from customers may be at the lowest point of the year as the firm comes out of a low%activity season. A short%term financing arrangement is the best way to meet seasonal cash needs. A short%term loan can be repaid as soon as activities in cash collections increase and payrolls and purchases of materials and supplies decrease as the firm enters into a slow season. Although the firm may have to pay a higher cost for short%term borrowing, the total financing cost likely would be lower than if the firm raised sufficient funds through either issuing long%term bonds or capital stock to meet peak demands for cash. A bond re/uires interest payments whether or not the firm uses the funds raised from the bond in operations. Additional capital stock is not without cost. anagement needs to earn a desired return on e/uity to satisfy investors. Furthermore, studies have shown that management is prone to be careless in spending when abundant funds are available. D. #he scenarios described involved many simplified assumptions in order to make the problem managable. Among possible complicating factors are0
3o bad debts are considered. 5ustomers always make payment as prescribed in sales terms. 4ithin a given month cash inflows are in time to meet cash outflows. )t is conceivable that the bulk of cash inflows occur toward the end of the month while payments need to go out at the beginning of the month. 5ash customers do not use bank credit cards for the purchases.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-80
©The McGraw-Hill Companies 2008
8-68 C' B(<+*) S)'*+*;*+ A)%'*' 50 M*)(+' =. +stimated 5ash Eeceipts, April C@@H0 April 5ash Eeceipts0 April cash sales &C.@K ! NDC,@@@'
N=@G,C@
April credit%card sales &NDC,@@@ ! K ! >HK'
NCCG,H-
5ollection of accounts receivable0 From April "ales &C@K ! NDC,@@@ ! CK'
NC=,C@
From arch "ales &ND@@,@@@ ! C@K ! DK'
N-G,@@@
From February "ales &N@,@@@ ! C@K ! CHK'
NC>,H@@
#otal
$419#938
C. Purchase (rder for Tardware, e!ecuted @' Ee/uired Purchases &in Mnits'
>@ -@ =C@ CH 93
b' 5ost of purchases0 "elling price per unit &e.g., N-@@,@@@$=@@ units' +stimated cost per unit &VGK of selling price' #otal cost of purchases &>- units ! N=,>@$unit'
N-,@@@ N=,>@ $181#350
1ote that the cash outflow associated with these purchases will be ;<=>>> 6/ days after e%ecuting the purchase order7.
Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-81
©The McGraw-Hill Companies 2008
8-68 &5ontinued%=' -. "ensitivity Analysis0 #hree "enarios for arch "ales and the 5*"K +stimated "alesIarch
5*" K
(ptimistic +stimate
=@@
G@K
Base%line +stimate
>@
GK
Pessimistic +stimate
@
H@K arch
5ash "ales
Payment
"cenario
&units'
5*" K
=
=@@
G@K
C
=@@
GK
-
=@@
H@K
D
>@
G@K
5
90
65@
G
>@
H@K
H
@
G@K
@
GK
>
@
H@K
a!imum
NC=@,@@@
inimum
N=D,@@
Eange
April =@th
N,C@@
D. onthly cash budgets are prepared by companies such as 5omp5ity, )nc., in order to plan for their cash needs #his means identifying when both e!cess cash and cash shortages may occur. A company needs to know when cash shortages will occur so that prior arrangements can be made with lending institutions in order to have cash available for borrowing when the company needs it. At the same time, a company should be aware of when there is e!cess cash available for investment or repaying loans so that planned usage of the e!cess can be made. Blocher, Stout, Cokins, Chen, Cost Management, 4/e
8-82
©The McGraw-Hill Companies 2008