Homework Answers
| November | December | January | February | March | April | May | June | July | ||||
| Sales | 3,75,000 | 2,66,667 | 2,00,000 | 3,50,000 | 4,00,000 | 3,50,000 | 2,50,000 | 2,50,000 | 3,00,000 | |||
| Collections: | ||||||||||||
| Cash | 1,50,000 | 1,06,667 | 80,000 | 1,40,000 | 1,60,000 | 1,40,000 | 1,00,000 | 1,00,000 | 1,20,000 | |||
| First Month | 1,35,000 | 96,000 | 72,000 | 1,26,000 | 1,44,000 | 1,26,000 | 90,000 | 90,000 | 1,08,000 | |||
| Second Month | 90,000 | 64,000 | 48,000 | 84,000 | 96,000 | 84,000 | 60,000 | 60,000 | 72,000 | |||
| Total Collections | 1,50,000 | 2,41,667 | 2,66,000 | 2,76,000 | 3,34,000 | 3,68,000 | 3,22,000 | 2,74,000 | 2,70,000 | 1,68,000 | 72,000 | |
| Purchases | 1,60,000 | 1,20,000 | 2,10,000 | 2,40,000 | 2,10,000 | 1,50,000 | 1,50,000 | 1,80,000 | - | |||
| Payments: | ||||||||||||
| First Month | 80,000 | 60,000 | 1,05,000 | 1,20,000 | 1,05,000 | 75,000 | 75,000 | 90,000 | - | - | ||
| Second Month | 80,000 | 60,000 | 1,05,000 | 1,20,000 | 1,05,000 | 75,000 | 75,000 | 90,000 | - | |||
| Total Payments | 80,000 | 1,40,000 | 1,65,000 | 2,25,000 | 2,25,000 | 1,80,000 | 1,50,000 | 1,65,000 | 90,000 | - | ||
| Collections | 1,26,000 | 1,11,000 | 1,09,000 | 1,43,000 | 1,42,000 | 1,24,000 | ||||||
| Less: Disbursements | ||||||||||||
| Inventory Payments | - | - | - | - | - | - | ||||||
| Wages, Taxes and othe exp | 60,000 | 1,05,000 | 1,20,000 | 1,05,000 | 75,000 | 75,000 | ||||||
| Interest payments | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | ||||||
| Capital Expenditure | 70,000 | |||||||||||
| Total Disbursements | 90,000 | 1,35,000 | 2,20,000 | 1,35,000 | 1,05,000 | 1,05,000 | ||||||
| Beginning Cash Balance | 30,000 | 66,000 | 42,000 | 25,000 | 33,000 | 70,000 | 89,000 | |||||
| Collections - Disbursements | 36,000 | -24,000 | -1,11,000 | 8,000 |
Know the answer?
Add Answer to:
|
Active Life Inc., a sports equipment retailer, needs to prepare a cash budget for the first quarter of 2018. The financial staff at Active Life has forecasted the following sales figures: January February March April May $100,000 $150,000 $300,000 $250,000 $150,000 Actual sales in October, November, and December 2017 were $125,000, $146,000, and $125,000, respectively. Cash sales are 40% of the total, and the rest are on credit. Under the current credit policy the firm expects to collect 60% of...
The following is the sales budget for Profit, Inc., for the first quarter of 2018: Sales budget January February March $212,000 $232,000 $255,000 Credit sales are collected as follows: 70 percent in the month of the sale 15 percent in the month after the sale 15 percent in the second month after the sale The accounts receivable balance at the end of the previous quarter was $96,000 ($66,000 of which was uncollected December sales). a. Calculate the sales for November....
Cash Receipts The sales budget for Andrew Inc. is forecasted as follows: Month Sales Revenue May $ 150.000 June 175,000 July 160,000 August 200.000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales • 60 percent in the month of sale. • 20 percent in the month following sale. • 15 percent in the second month following sale. • 5 percent uncollectible....
The following is the sales budget for Shleifer, Inc., for the first quarter of 2019: Sales budget January February March $208,000 $228,000 $251,000 Credit sales are collected as follows: 55 percent in the month of the sale. 30 percent in the month after the sale. 15 percent in the second month after the sale. The accounts receivable balance at the end of the previous quarter was $92,000 ($62,000 of which were uncollected December sales). a. Calculate the sales for November....