Cash Budget Preparation PT ABC has sales 50,000 unit in March and 60,000 unit in April....

Cash Budget Preparation

PT ABC has sales 50,000 unit in March and 60,000 unit in April. Sales prediction for May, June and July are 70,000,80,000 and 100,000 unit. Cash balance on May 1, is USD 5,000 and minimum cash policy is USD 5,000. Based on the data for May, June, July are as follow:

a. Cash sales 20% on the month sales, 60% received next month and 20% the following (2months later)

b. Other revenues USD 21,000 every month

c. Pay full all purchases in May, June, July for the following USD 50,000. 70,000 dan 80,000.

d. Rent expenses USD 3,000 per month

e. Salary and wages expenses 10% from previous month

f. Paid Cash dividend USD 3,000 in June

g. Paid payable with total principal and interest in June USD 4,000

h. Cash payment paid in full amount USD 6,000 in July

i. Tax will be paid in June USD 6,000

Expert Solution

ekkarill92 answered 1 year ago

Cash budget—Basic Grenoble Enterprises had sales of $50,100 in March and $60,100 in April. Forecast sales...

Cash budget—Basic Grenoble Enterprises had sales of $50,100 in March and $60,100 in April. Forecast sales for May, June, and July are $69,500, $80,000, and $99,800, respectively. The firm has a cash balance of $4,800 on May 1 and wishes to maintain a minimum cash balance of $4,800. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 24% of sales for cash, 62% are collected in the...

Cash budget—Basic Grenoble Enterprises had sales of $50,100 in March and $60,100 in April. Forecast sales...

Cash budget—Basic Grenoble Enterprises had sales of $50,100 in March and $60,100 in April. Forecast sales for May, June, and July are $69,500, $80,000, and $99,800, respectively. The firm has a cash balance of $4,800 on May 1 and wishes to maintain a minimum cash balance of $4,800. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 24% of sales for cash, 62% are collected in 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...

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...

Below is the abbreviated cash budget for ABC Pty Ltd. Beginning Cash Balance 50,000 Estimated Cash...

Below is the abbreviated cash budget for ABC Pty Ltd. Beginning Cash Balance 50,000 Estimated Cash Receipts Cash Available 390,000 Estimated Cash Payments Purchases 210,000 Operating Expenses Office Equipment Purchases 50,000 Total Estimated Cash Payments Ending Cash Balance 40,000 (a) Calculate the amount of Estimated Cash Receipts, Operating Expenses, and Total Estimated Cash Payments. (b) What action if any should ABC Pty Ltd take as a result of preparing this budget? Briefly justify your answer.

2. Webster Corporation is preparing its cash budget for April. The March 31 cash balance is...

2. Webster Corporation is preparing its cash budget for April. The March 31 cash balance is $36,500. Cash receipts are expected to be $642,000 and cash payments for purchases are expected to be $609,500. Other cash expenses expected are $27,100 selling and $33,600 general and administrative. The company desires a minimum cash balance at the end of each month of $31,000. If necessary, the company borrows enough cash to meet the minimum using a short-term note. Webster's preliminary cash balance...

Titan manufactures and sells a product. It projects unit sales for Jan, Feb, March and April...

Titan manufactures and sells a product. It projects unit sales for Jan, Feb, March and April of 2500, 2250, 3000, and 3750, respectively. At the end of a month, Titan plans to have finished goods inventory equal to 20% of the following month's sales. *Make a Monthly production schedule for Jan-March (Titan had 800 units of finished goods on hand at the end of December.) 2.) Cubs sales for Jan, Feb, and March are budgeted to be $5000, $4500, and...

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...

what is the benefits of the preparation of cash budget for the management ?

Sill Corporation makes one product. Budgeted unit sales for January, February, March, and April are 9,900,...

Sill Corporation makes one product. Budgeted unit sales for January, February, March, and April are 9,900, 11,400, 11,900, and 13,400 units, respectively. The ending finished goods inventory equals 20% of the following month's sales. The ending raw materials inventory equals 40% of the following month’s raw materials production needs. Each unit of finished goods requires 5 pounds of raw materials. If 61,000 pounds of raw materials are required for production in March, then the budgeted raw material purchases for February...

Question

Cash Budget Preparation PT ABC has sales 50,000 unit in March and 60,000 unit in April....

Solutions

Expert Solution

Related Solutions

Cash budget—Basic Grenoble Enterprises had sales of $50,100 in March and $60,100 in April. Forecast sales...

Cash budget—Basic Grenoble Enterprises had sales of $50,100 in March and $60,100 in April. Forecast sales...

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

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

Below is the abbreviated cash budget for ABC Pty Ltd. Beginning Cash Balance 50,000 Estimated Cash...

2. Webster Corporation is preparing its cash budget for April. The March 31 cash balance is...

Titan manufactures and sells a product. It projects unit sales for Jan, Feb, March and April...

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

what is the benefits of the preparation of cash budget for the management ?

Sill Corporation makes one product. Budgeted unit sales for January, February, March, and April are 9,900,...