Question
NBA has provided sales for the month of May: April Actual cash sales = $17,550.00 April actual credit sales = $99,000 April actual total sales
NBA has provided sales for the month of May:
April Actual cash sales = $17,550.00
April actual credit sales = $99,000
April actual total sales = 116,550
May budget cash sales = 18000
may budget credit sales = 126,000
may budget total sales = 144,000
For credit sales, the collection pattern:
month of sales = 70%
month following sales = 25%
*based on past experience, the company estimates the remaining credit sales are uncollectible.
inventory purchase average 70% of current months total sales. payments for inventory as follows:
month of purchase = 40%
month following purchase = 60%
other expenses include:
Salaries and wages per month = $10,440
rent per month = $3,600
utilities per month = $5,200
insurance per quarter to be paid in may = $900
depreciation expenses per month = $1,500
May 1 cash balance is $9,216
Questions:
1. What is the budgeted cash receipts for the month of may?
2. what is the budgeted cash disbursements for inventory purchases for the month of may?
3. what is the budgeted cash disbursements for other expenses for the month of may
4. what is the ending cash balance in the cash budget for the month of may?
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