- 1. CHAPTER 16
Financial Control of Logistics Performance
- 2. Questions Accounting System Must be Capable of AnsweringHow do logistics costs affect contribution by product, by territory, by customer, and by salesperson?
What are the costs associated with providing additional levels of customer service? What trade-offs are necessary, and what are the incremental benefits or losses?
What is the optimal amount of inventory? How sensitive is the inventory level to changes in warehousing patterns or to changes in customer service levels? How much does it cost to hold inventory?
What mix of transport modes/carriers should be used?a
- 3. Questions Accounting System Must be Capable of Answering (cont.)How many field warehouses should be used and where should they be located?
How many production setups are required? Which plants will be used to produce each product? What are the optimum manufacturing plant capacities based on alternative product mixes and volumes?
What product packaging alternatives should be used?
To what extent should the order processing system be automated?
What distribution channels should be used?b16-2 b
- 4. Is costdependent onunit volume?Isresourcededicated to aspecificproductline?Place in contributionpoolChargeApplicableSegmentChargeApplicableSegmentVariableNon-VariableIndirectNONOYESYESAssigning Costs To Segments 16-3
- 5. Contribution Approach with a Charge For Assets EmployedNet sales
Cost of goods sold (variable manufacturing costs)
Manufacturing contribution
Variable marketing and logistics costs
Sales commissions
Transportation
Warehousing (handling in and out)
Order processing
Charge for investment in accounts receivable
Segment contribution margin
Assignable nonvariable costs
Salaries
Segment-related advertising
Bad debts
Inventory carrying costs
Segment controllable margin
Charge for assets used by segment
Net segment marginTotal Company Segment A Segment B Segment C
____________ ________ ________ ________
____________ ________ ________ ________
____________ ________ ________ ________
____________ ________ ________ ________
____________ ________ ________ ________
____________ ________ ________ ________
____________ ________ ________ ________
____________ ________ ________ ________
16-4
- 6. Profitability by Type Of Account: A Contribution ApproachSales Less discounts, returns and allowancesNet Sales Cost of goods sold (variable manufacturing costs)Manufacturing contribution Variable selling and distribution costs: Sales commissions Transportation costs Warehouse handling Order-processing costs Charge for investment in accounts receivableContribution margin Assignable nonvariable costs (costs incurred specifically for the segment during the period): Sales promotion and slotting allowances Advertising Bad debts Display racks Inventory carrying costsSegment controllable marginSegment controllable margin-to-sales ratioNote: This approach could be modified to include a charge for the assets employed by each of the segments, as well as a deduction for the change in market value of these assets. The result would be referred to as the net segment margin (residual income).$42,5002,50040,00020,00020,0008002,50060040070015,0001,2505003002001,250$11,50027.1%$6,2502506,0002,5003,50012031015060202,84060---------150$2,63042.1%$10,50050010,0004,8005,200200225---35504,690620---------200$3,87036.9%$19,7501,75018,0009,2008,8003601,7954502806155,300400500300200800$3,10015.7%$6,000---------6,0003,5002,500120170---25152,170170---------100$1,90031.7%TotalCompanyDepartmentStoresGroceryChainsDrugStoresDiscountStoresType of Account16-5
- 7. Profitability By Type of Account: A Contribution Approach ($000)Note: This approach could be modified to include a charge for the assets employed by each of the segments, as well as a deduction for the change in market value of these assets. The result would be referred to as the net segment margin (residual income).Sales Less discounts, returns and allowancesNet Sales Cost of goods sold (variable manufacturing costs)Manufacturing contribution Variable selling and distribution costs: Sales commissions Transportation costs Warehouse handling Order-processing costs Charge for investment in accounts receivableContribution margin Assignable nonvariable costs (costs incurred specifically for the segment during the period): Sales promotion and slotting allowances Advertising Bad debts Display racks Inventory carrying costsSegment controllable marginSegment controllable margin-to-sales ratio$19,7501,75018,0009,2008,8003601,7954502806155,300400500300200800$3,10015.7%Drug StoreChannelType of Account$10,0001,0009,0004,5004,5001801,4753502005601,735200500300200620($85)---IndependentPharmacies$5,5005005,0002,6002,40010020010055351,910110---------100$1,70030.9%RegionalDrug Chains$4,2502504,0002,1001,90080120---25201,65590---------80$1,48534.9%NationalDrug Chains16-6
- 8. Shortcomings for Corporate Profitability Reports1. Full manufactured costs (which sometimes include a profit for the plant) were used in calculating costs.
2. Operating costs such as development, selling, and administration were fully allocated to products often on a percentage-of-sales basis.
3. Costs such as transportation, warehousing, sales commissions, and sales promotions were not reported as separate line items.
4. When marketing and logistics costs were identified explicitly as expenses, they usually were allocated to products on a percentage-of-sales basis.Copyright © 2001 by The McGraw-Hill Companies, Inc. All rights reserved. a16-7 a
- 9. 5. Inconsistencies in terminology were common. When executives referred to contribution margins, often the numbers used were actually manufacturing contribution.
6. Opportunity costs such as inventory carrying costs, a charge of accounts receivable, and a charge for other assets employed did not appear on profitability reports.
7. Reports that covered more than one year were not adjusted for inflation.
8. Reports were not adjusted to reflect replacement costs.Shortcomings for Corporate Profitability Reports (cont.)b16-7 b
- 10. Profitability By Type Of Account: A Full Cost Approach ($000)Net Sales Cost of goods sold (Full manufacturing costs)Manufacturing Margin Less Expenses: Sales commissions Transportation costs ($/case) Warehouse handling ($/cu. ft) Order-processing costs ($/order) Sales promotion (% of sales) Advertising (% of sales) Bad debts (% of sales) General Overhead and Administrative Expense (% of sales)Net Profit (before taxes)Profit-to-sales ratio$40,00025,00015,0008002,5006004001,2505003006,150$2,5006.3%TotalCompanyType of AccountDrugStoresGroceryChainsDept.StoresDiscountStores$6,0003,7502,25012037590301877545922$4066.8%$10,0006,2503,75020062515050312125751,538$6756.8%$18,00011,2506,7503601,1252703005632251352,768$1,0045.6%$6,0003,7502,25012037590201887545922$4156.9%16-8
- 11. Controlling Logistics ActivitiesControl over
logistics costs can
be accomplished
byStandard costsBudgetsProductivity
standardsStatistical process
control16-9
- 12. A Modular Database System for Reporting Cost and Revenue FlowsMarketing segment
analysisFunctional cost reportsChargesCreditAccounts for
external
reportingNon-financial
data
Source
documentsStandard costsActual costsRevenuesExternal
reportsModular
databaseRevenue flow
Actual recorded cost flow
Standard estimated cost applied to actual activity16-10
- 13. Report Generating Capabilities of the Modular BaseGeographical
profitabilityCost by
cost center
and functionExternal
Financial
statementsRevenue and
expense itemsProduct
profitabilityCustomer
profitabilityChannel
profitabilityModular
databasedSalesperson
performanceCoded16-11