Reference no: EM133055488
Question - Best Restaurant Supply sells various equipment and supplies to restaurants in the local and surrounding communities. The company's controller, Barry Barley, has requested your help in preparing a cash budget for the month of June. Barry accumulated the following information for you:
The cash balance on 1 June was estimated to be $10 000.
Actual sales for April and May and budgeted sales for June are as follows:
|
|
April
|
May
|
June
|
|
Cash sales
|
$16 500
|
$15 500
|
$17 500
|
|
Sales on account (Credit)
|
30 000
|
40 000
|
50 000
|
Sales on account are collected over a two-month period, with 70 per cent being collected in the first month and the remainder being collected in the second month.
Inventory purchases are expected to be $35 000 in June. The company pays for inventory purchases in the following month's purchases. The balance of May's purchases is $22 000.
Selling and administrative expenses are budgeted to be $14 000 for June. Of that amount, 50 per cent is depreciation.
Equipment costing $14 000 will be purchased in June for cash.
Dividends in the amount of $2500 will be paid in June.
The company wants to maintain a minimum cash balance of $10 000 and has set up a line of credit at the local bank that can be used to cover any shortage. If the company must borrow, the loan will be made at the beginning of the month, and any repayment will be made at the end of the month of repayment.
Required -
(a) Prepare a cash budget for the month of June.
(b) List three problems that may be encountered in preparing a cash budget.
|
Prepare Gold Stripe State Bank Journal entry
: Prepare Gold Stripe State Bank's Journal entry to record the making of the loan, and the corresponding entry recorded by Wabash Men's Daycare
|
|
Prepare a complete depreciation schedule
: Prepare a complete depreciation schedule, beginning with the current year, under each of methods listed assuming that Van Winkle employs half-year convention
|
|
What is the Pasta Division Return on Investment
: The total assets of the Pasta Division were $2,750,000, while current liabilities were $330,000. What is the Pasta Division Return on Investment
|
|
Calculate the accounting rate of return of investing
: The vehicles will cost $55,000 each to buy, payable in full immediately. Calculate the Accounting Rate of Return of investing
|
|
Prepare a cash budget for the month of June
: Selling and administrative expenses are budgeted to be $14 000 for June. Prepare a cash budget for the month of June
|
|
News media be used in crime analysis
: How can the news media be used in crime analysis? Do you consider the news media to be a valuable asset? Why or why not?
|
|
Ideology of hate under protection of freedom of speech
: Hate groups are often able to promote their ideology of hate under the protection of freedom of speech
|
|
Communicate with professional who holds the position
: Communicate with a person in the Human Resources department of the agency or organization. Communicate with a professional who holds the position.
|
|
Calculate the weighted average contribution margin
: Calculate the weighted average contribution margin, assuming the sales mix as determined from the survey is expected to remain constant
|