Dynamic - Problem and answer changes with each attempt (consider an Excel solution) Farm Supply is located in a small town on the coast of California. Data regarding the store's operations follow: - Sales are budgeted at 311,667 for November, $333,118 for December, and $248,717 for January. - Collections are expected to be 70% in the month of sale and 30% in the month following the sale. - The cost of goods sold is 75% of sales. - The company desires to have an ending merchandise inventory at the end of each month equal to 80% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase. - Other monthly expenses to be paid in cash are $22,400. - Monthly depreciation is $27,500. - Ianore taxes