Question
Peachtree's Siding and Window Co. is a custom home improvement company. All sales are made on account: 30 percent of a month's sales are collected
Peachtree's Siding and Window Co. is a custom home improvement company. All sales are made on account: 30 percent of a month's sales are collected in the month of sale, 60 percent are collected in the month following the sale, and 8 percent are collected in the second month following the sale. Cash on hand on October 1 is estimated to be $32,000.
Merchandise purchases and operating expenses are paid as follows:
In the month during which the merchandise is purchased or the cost is incurred | 80% |
In the subsequent month | 20% |
Peachtree's Siding and Window Co.'s budgeted income statement for each of the next three months is as follows:
| August | September | October |
Sales | $140,000 | $169,000 | $181,000 |
Cost of goods sold: |
|
|
|
Beginning inventory | $16,400 | $28,900 | $25,600 |
Purchases | 135,300 | 141,500 | $149,700 |
Goods available | $151,700 | $170,400 | $175,300 |
Less: End. inventory | (28,900) | (25,600) | (21,200) |
Cost of goods sold | $122,800 | $144,800 | $154,100 |
Gross profit | $17,200 | $24,200 | $26,900 |
Operating expenses | (11,400) | (15,100) | (14,300) |
Operating income | $5,800 | $9,100 | $12,600 |
Prepare a cash budget for the month of October.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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