Joshua Studios expects the following sales in March, April and May: Sales $ Purchases $ March...

Joshua Studios expects the following sales in March, April and May: Sales $ Purchases $ March 240,000 180,000 April 250,000 210,000 May 300,000 225,000 The controller has determined that the company collects sales in the following pattern: 30% in the month of sale, 50% in the first month after sale, 10% in the second month after sale, and 10% uncollectable. Based on the agreed terms of trade with suppliers, 40% of purchases are expected to be paid in the month of purchase with the remaining 60% paid in the month after purchase. Required:

a) Prepare a cash budget for the month of May identifying the cash receipts, cash payments and the expected net increase or decrease in cash for the month of May?

b) If the opening Bank Balance on 1 May was $30,000, what would be the forecast closing balance at the end of the month?

Expert Solution

ekkarill92 answered 1 year ago

Grenoble Enterprises had sales of $50,200 in March and $60,200 in April. Forecast sales for May,...

Grenoble Enterprises had sales of $50,200 in March and $60,200 in April. Forecast sales for May, June, and July are $70,100, $79,600, and $99,800, respectively. The firm has a cash balance of $4,500 on May 1 and wishes to maintain a minimum cash balance of $4,500. Given the following data, prepare and interpret a cash budget for the months of May, June and July. 1) The firm makes 16% of sales for cash, 62% are collected in the next month,...

The following information was available from ABC Company's financial records. Sales Purchases April $90,000 $52,500 May...

The following information was available from ABC Company's financial records. Sales Purchases April $90,000 $52,500 May $82,500 $60,000 June $75,000 $45,000 July $97,500 $67,500 August $82,500 $75,000 Collections from customers are as follows: Month of sale 75% One month following sale 20% Second month following sale 5% On the purchase side, the Company takes full advantage of the 3 percent discount allowed on purchases paid for by the tenth of the following month. (Hint: April purchases are paid in full...

The following information is from Tejas WindowTints financial records, Month Sales Purchases April $75,000 $50,000 May...

The following information is from Tejas WindowTints financial records, Month Sales Purchases April $75,000 $50,000 May 75,000 60,000 June 71,000 48,000 July 78,000 66,000 Collections from customers are normally 66 percent in the month of sale, 17 percent in the month following sale and 16 percent in the second month following the sale. The balance is expected to be uncollectible. All purchases are on account. Management takes full advantage of the 1 percent discount allowed on purchases paid by the...

Question 1: - Cash Budget: Estimated sales January February March April May Total Coffee sales (units)...

Question 1: - Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500 18,000 14,500 Your friend, MATT, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told MATT his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information...

Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500...

Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told Chris his depreciation expense was going to be $9,000 per year, using the straight-line method. He has supplied you with the following information (above) to help you...

Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500...

Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500 18,000 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told Chris his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information (above) to...

A company expects to sell 6,000 units in April and expects sales to increase 20% each...

A company expects to sell 6,000 units in April and expects sales to increase 20% each month after. The unit sales price of $8 is expected to remain constant. The company wants ending finished goods inventory to be 15% of the next month’s sales. What are budgeted sales revenues for the second quarter? How many units will be produced in the second quarter? Round answers to nearest whole number. The raw materials ending inventory should be 20% of the next...

March, April, and May have been in partnership for a number of years.

March, April, and May have been in partnership for a number of years. The partners allocate all profits and losses on a 4:2:2 basis, respectively. Recently, each partner has become personally insolvent and, thus, the partners have decided to liquidate the business in hopes of remedying their personal financial problems. As of September 1, the partnership’s balance sheet is as follows: Cash Ș 35,000 Liabilities ...

Sunland Company’s record of transactions for the month of April was as follows. Purchases Sales April...

Sunland Company’s record of transactions for the month of April was as follows. Purchases Sales April 1 (balance on hand) 1,020 @ $6.00 April 3 850 @ $10.00 4 2,550 @ 6.08 9 2,380 @ 10.00 8 1,360 @ 6.40 11 1,020 @ 11.00 13 2,040 @ 6.50 23 2,040 @ 11.00 21 1,190 @ 6.60 27 1,530 @ 12.00 29 850 @ 6.79 7,820 9,010 (a1) Your answer is correct. Assuming that periodic inventory records are kept in units...

Novak Company’s record of transactions for the month of April was as follows. Purchases Sales April...

Novak Company’s record of transactions for the month of April was as follows. Purchases Sales April 1 (balance on hand) 1,740 @ $6.00 April 3 1,450 @ $10.00 4 4,350 @ 6.08 9 4,060 @ 10.00 8 2,320 @ 6.40 11 1,740 @ 11.00 13 3,480 @ 6.50 23 3,480 @ 11.00 21 2,030 @ 6.60 27 2,610 @ 12.00 29 1,450 @ 6.79 13,340 15,370 Assuming that perpetual inventory records are kept in dollars, determine the inventory using (1)...

Question