Gary Raad recently opened a steel warehouse. Gary buys his steel only after he receives a firm order from a customer; thus, Gary only buys what he sells in a particular month. Nevertheless, Gary projects that he will experience some cash flow problems toward the end of the year. While Gary is confident about the fundamentals of his business, he is wondering if he is perhaps too generous with his credit terms to customers.
Gary informs you that he currently collects 30% of revenues in the month after sale and the remaining 70% two months following the sale. Gary pays for 50% of his purchases in the month of purchase and 50% in the following month. His monthly fixed costs amount to $95,000, including $10,000 in noncash depreciation expenses. Finally, Gary marks up his products by 25% over the purchase price.
Gary provides you with the following information regarding projected sales for the next five months.

Required:
a. What is Gary's budgeted contribution margin income statement for October, November, and December?
b. What is Gary's cash budget for October, November, and December? Assume that Gary plans to begin October with $5,000 in cash on hand.
c. Why is Gary is facing a cash flow problem even though his business is profitable? Identify two things that Gary could do to alleviate the anticipated cash crunch.

October $468.750 S468,750 $475,000 $525,000 $562.500 August September November December