Your firm sells to wholesalers nationwide. Your bank has just completed a lockbo
ID: 2765355 • Letter: Y
Question
Your firm sells to wholesalers nationwide. Your bank has just completed a lockbox study of your cash collection system. After a thorough study of your remittance information, they categorized your customers into four groups as shown below. Your opportunity rate is 11 percent.
AVERAGE MONTLY REMITTANCES DAYS OF FLOAT
Using the complete enumaration model,determine the optical number of lockbox sites and the customer allocation among the chosen sites.
CUSTOME GROUP NUMBER FACE VALUE BANK A BANK B BANK C 1 2,000 $50,000 5 3 1 2 4,000 30,000 1 6 4 3 1,000 18,000 3 7 5 4 200 20,000 7 1 3 Varable processing costs $.30 $.60 $.80 Fixed costs $300 $400 $150Explanation / Answer
Total cost = N * { (F*D*i)+VC) } + FC
where , N is the number of remittances
F is the face value
D is number of days in float
i is the opportunity rate which is 11%
VC is the variable cost
FC is the fixed cost
The optimum lockbox system is site 2 system's combination 2 ( bank A and Bank C)
which have the lowest cost the all the sites and combination the cost is $ 31,464,610.
AVERAGE MONTLY REMITTANCES DAYS OF FLOAT CUSTOME GROUP NUMBER FACE VALUE BANK A BANK B BANK C 1 2,000 $50,000 5 3 1 2 4,000 30,000 1 6 4 3 1,000 18,000 3 7 5 4 200 20,000 7 1 3 Varable processing costs $0.30 $0.60 $0.80 Fixed costs $300 $400 $150 Site 1 system CUSTOME GROUP BANK A BANK B BANK C 1 $55,000,900 $33,001,600 $11,001,750 2 $13,201,500 $79,202,800 $52,803,350 3 $5,940,600 $13,861,000 $9,900,950 4 $3,080,360 $440,520 $1,320,310 Fixed costs $300 $400 $150 Total Cost $77,223,660 $126,506,320 $75,026,510 Optimum I lockbox system is bank C as their lotal cost is lowest Site 2 system Combination 1 Combination 2 Combination 3 CUSTOME GROUP BANK A BANK B BANK A BANK C BANK B BANK C 1 $33,001,600 $11,001,750 $11,001,750 2 $13,201,500 $13,201,500 $52,803,350 3 $5,940,600 $5,940,600 $9,900,950 4 $440,520 $1,320,310 $440,520 Variable Cost $19,142,100 $33,442,120 $19,142,100 $12,322,060 $440,520 $73,706,050 Fixed costs $300 $400 $300 $150 $400 $150 Total Cost $19,142,400 $33,442,520 $19,142,400 $12,322,210 $440,920 $73,706,200 Total cost of combination $52,584,920 $31,464,610 $74,147,120 Optimum 2 lockbox system is combination of bank A and bank C as their lotal cost is lowest Site 3 system CUSTOME GROUP BANK A BANK B BANK C 1 $33,001,600 2 $13,201,500 3 $5,940,600 4 $440,520 Variable Cost $19,142,100 $33,442,120 Fixed costs $300 $400 $150 Total Cost $19,142,400 $33,442,520 $150 Total cost of combination $52,585,070Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.