Mini Case:  Cash Conversion, Inventory, and Receivables Management

Bracelet Blanks, Inc. (BB) generated $43,803,000 in sales (all on credit) during 2010.  The cost of goods sold (COGS) was 57% of that total.  Accounts receivable (A/R) totaled $3,240,222, inventory totaled $842,020 and accounts payable (A/P) totaled $1,826,070.
Instructions – complete as an excel worksheet and show all calculations for this assignment.

problems:

1. Compute BB's current cash conversion cycle.

2. BB presently uses 3,000 ingots of aluminum each year to manufacture bracelet blanks.  The order cost (including shipping) is $5,000 per order, and carrying costs are $75 per unit per year.

a. Determine the economic order quantity

b. Amount of safety stock

c. The reorder point for aluminum ingots assuming there is a 1-week lead-time and the firm would like a safety stock of 3%.

3. In an attempt to boost sales, BB is considering relaxing its credit standards by extending more credit to small firms.  BB charges $1.50 per unit.  Variable costs are $0.5126 per unit and fixed costs are $10,000,000 per year.  The relaxation of credit standards is expected to result in a 3.8% increase in sales (the firm has sufficient excess capacity to handle the increase) as well as an increase of three days in the average collection period.  They also expect bad debts to rise from the current level of 0% to 0.5% of sales.

a. Assuming that BB requires a 13% return on investments of this type, should the firm relax its credit standards?

4. Additionally, BB currently offers its credit customers terms of net 30.  However, it is considering changing the terms to 2/10 net 30 in an attempt to reduce the amount of time it takes to collect its accounts receivable (A/R).  The firm believes this change alone would decrease the average collection period by five days.  BB also expects that 63% of its customers will elect to pay within the discount period and that the increased attractiveness of the terms will increase sales by 1% a year.  It is not expected that bad debs will change from the current level of 0% because of this change in terms.  BB's opportunity cost of funds invested in accounts receivable (A/R) is 10%.

a. Should the firm offer the cash discount?

b. Evaluate this scenario separately from the one described in problem 3.