The ABC Company starts the year in fine shape. The firm makes widgets-just what the customer wants. It makes them for $0.75 each and sells them for $1.00. The ABC Company keeps an inventory equal to shipments of the pat 30 days, pays its bilk promptly, and collects cash from customers within 30 days after the sale. The sales manager predicts a steady increase in sales of 500 widgets each month beginning in February. Ii looks like a great year, and it begins that way
January 1 Cash, $875: receivables. $1,000; inventory, $750
January In January the firm sells. on account for $1,000, 1,000 widgets costing $750. Net income for the month is $250. The firm collects receivables outstanding at the beginning of the month. Production equals 1,000 units at a total cost of $750. The books at the end of January show the following:
February 1 Cash, $1,125: receivables, $1,000: inventory, $750
February This month's sales jump, as predicted, to 1,500 units. With a corresponding step-up in production to maintain the 30-day inventor, ABC Company makes 2,000 units at a cost of $1,500. It collects all receivables from January sales. Net income so far is $625. Now the books look like this:
March 1 Cash, $625: receivables, $1,500; inventory, $1,125
MarchMarch sales are even better, increasing to 2.000 units. Collections are on time. Production, to adhere to the inventory policy, is 2,500 units. Operating results for the month show net income of $500. Net income to date is $1.125. The books show the following:
April 1 Cash, $250: receivables. $2,000; inventory, $1,500
April In April, sales jump another 500 units to 2.500, and the manager of ABC Company shakes the sales manager's hand. Customers are paying right on time. Production increases to 3,000 units, and the month's business nets $625 for a net income to date of $1,750. The manager of ABC Company takes off for Miami before the accountant issues a report. Suddenly a phone call comes from the treasurer: Come homes W need cash!??
May 1Cash, $0 receivables, $2,500; inventory, $1,875
a. Prepare an analysis that explains what happened to ABC Company.
b. How can a firm show increasing net income but a decreasing amount of cash?
c. What insights does this problem provide about the need for all three financial statements-balance sheet, income statement, and statement of cash floes?
d. What actions would you suggest that ABC Company take to deal with its cash flow problem?