Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Farmers Delight Corporation reported sales of $350,000 in June, $380,000 in July, and $390,000 in August. The forecasts for September, October, and November are
Farmers Delight Corporation reported sales of $350,000 in June, $380,000 in July, and $390,000 in August. The forecasts for September, October, and November are $385,000, $418,000, and $429,000 respectively. The initial cash balance on September 1 is $150,000, and a minimum of $8,000 should be kept. Use the given information to compile a cash budget for the months of September, October and November. September, October, and November (1) Farmers Delight predicts that 5% of its sales will never be collected, 30% of its sales will be cash sales, and the remaining 65% will be collected in the following month. (2) Farmers Delight receives other monthly income of $3,000. (3) The actual or expected purchases are $15o,000, $120,000, and $115,000 for the months of September to November, respectively, and 50% are paid in cash while the remainder is paid in the following month. The purchases for August were $120,000. (4) Monthly rent is $3,500 chargeable only in October and November. (5) Wages and salaries are 12% of the previous month's sales. (6) Cash dividends of $4,600 are declared and will be paid in September. (7) Long-term loan repayment of principal and interest of $4,700 is due in October. (8) Additional equipment costing $8,500 is ordered and scheduled to be paid for in cash in November. (9) Taxes of $8,250 are due in November.
Step by Step Solution
★★★★★
3.55 Rating (148 Votes )
There are 3 Steps involved in it
Step: 1
Farmers Delight Details Aug Sep Oct Nov Sales revenue 390000 385000 418000 429000 Mon...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started