Gerald's Produce Provides Quality Fruits and Vegetables to Upscale Restaurants

Gerald's Produce provides quality fruits and vegetables to upscale restaurants in the tri-cities area. A sales forecast for Gerald's is shown on the top row of the table. Gerald makes 100% of his sales on credit. Gerald collects 50% of sales in the month following the sale, and the remaining 50% two months later. Gerald buys his produce in the same month as the sales. The cost of the fruits and vegetables is half of sales. Suppliers require Gerald to pay cash for his purchases. Gerald makes lease payments on his van of $500 per month, and gas costs him $100 per month. Gerald's Produce has a cash balance of $1,000 at the beginning of January.
Sales Forecast and Cash Budget
Gerald's Produce

-Referring to Gerald's Produce,what is Gerald's ending cash balance expected to be in March?

A) $15,400
B) $16,700
C) $17,000
D) $17,700
E) $18,200