Question: 4 Formula 3 points Dynamic - Problem and answer changes with each attempt ( consider an Excel solution ) Farm Supply is located in a

4
Formula 3 points
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 302,716 for November, $329,819 for December, and $ 243,054 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 expensesho be paid in cash are $22,400.
Monthly depreciation is $27,500.
Ignore taxes.
Calculate the difference between cash receipts and cash disbursements for December.
Hint: Range of answer is 45,000 to 60,000
Type your answer...
4 Formula 3 points Dynamic - Problem and answer

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!