Question
[The following information applies to the questions displayed below.] PrimeTime Sportswear is a custom imprinter that began operations six months ago. Sales have exceeded management's
[The following information applies to the questions displayed below.]
PrimeTime Sportswear is a custom imprinter that began operations six months ago. Sales have exceeded management's most optimistic projections. Sales are made on account and collected as follows: 51% in the month after the sale is made and 46% in the second month after sale. Merchandise purchases and operating expenses are paid as follows: |
In the month during which the merchandise is purchased or the cost is incurred | 70 | % |
In the subsequent month | 30 | % |
PrimeTime Sportswear's income statement budget for each of the next four months, newly revised to reflect the success of the firm, follows: |
September | October | November | December | |||||||||
Sales | $ | 41,800 | $ | 53,500 | $ | 67,500 | $ | 58,900 | ||||
Cost of goods sold: | ||||||||||||
Beginning inventory | $ | 6,010 | $ | 14,650 | $ | 20,450 | $ | 21,940 | ||||
Purchases | 38,600 | 44,000 | 49,000 | 33,400 | ||||||||
Cost of goods available for sale | $ | 44,610 | $ | 58,650 | $ | 69,450 | $ | 55,340 | ||||
Less: Ending inventory | (14,650 | ) | (20,450 | ) | (21,940 | ) | (19,870 | ) | ||||
Cost of goods sold | $ | 29,960 | $ | 38,200 | $ | 47,510 | $ | 35,470 | ||||
Gross profit | $ | 11,840 | $ | 15,300 | $ | 19,990 | $ | 23,430 | ||||
Operating expenses | 10,000 | 12,700 | 14,600 | 16,600 | ||||||||
Operating income | $ | 1,840 | $ | 2,600 | $ | 5,390 | $ | 6,830 | ||||
Cash on hand August 31 is estimated to be $39,770. Collections of August 31 accounts receivable were estimated to be $20,420 in September and $15,400 in October. Payments of August 31 accounts payable and accrued expenses in September were estimated to be $24,390. Required: Prepare a cash budget for september
|
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