Problem Reed’s  Company  case (excel Answer)

1. Calculate a few ratios and compare Reed’s results with industry averages. (Some industry averages are shown in Exhibit 16.4.) What do these ratios indicate?

1. Why does Holmes want Reed’s to have an inventory reduction sale, and what does he think will be accomplished by it?

1. Jim Reed had adopted a very loose working capital policy with higher current assets than industry averages. If he merely tightens his working capital policy to the averages, should this affect his sales?

4. Assuming that Reed’s can improve its operations to be in line with the industry averages, construct a 1995 pro forma income statement. Assume that net sales will be reduced 5 percent to $1,938,000 but that depreciation and amortization will not change but remain at $32,000.

1. What type of inventory control system would you suggest to Jim Reed?
2. What type of accounts receivable control would you suggest to Jim Reed?
3. Is the increase in sales related to the increase in inventory? (See Exhibit 16.5.)

1. What is Reed’s cost of not taking the suppliers’ discounts?