budgeted, Cost Accounting

Assignment Help:
Question:

Yamba Home Products is just beginning its fourth quarter, in which peak sales occur. The company has requested a $12,000, 90-day loan from its bank to help meet cash requirements during the quarter. The loan officer has asked for a cash budget for the quarter to help determine whether the loan should be made.

The following data are available for the quarter:

1. On April 1, the start of the quarter, the company had a cash balance of $6,000. Accounts receivable on April 1 totalled $31,500, of which $29,500 will be collected during April and $1,600 will be collected during May. The remainder will be uncollectable.

2. Past experience shows that 25 percent of a month''s sales are collected in the month of sale, 70 percent in the month following sale, and 4 percent in the second month following sale. Budgeted sales and expenses for the fourth quarter follow:







April


May


June




Sales


$ 50,000


$60,000


$45,000




Merchandise purchase


36,000


27,000


24,000




Payroll


6,500


6,750


6,000




Rent payment


4,500


4,500


4,500




Other Cash payments


8,500


9,100


7,500




Depreciation


2,500


2,500


2,500


3. Merchandise purchases are paid in full during the month following purchase. Accounts payable for merchandise purchases on March 31, which will be paid during April, totalled $30,000.

4. In preparing a cash budget, assume that the loan is made in April and repaid in June. Interest on the loan will total $450.

Required:

a. Prepare a schedule of budgeted cash collections for April, May and June and for the quarter in total.

b. Prepare a cash budget, by month and in total, for the quarter.

c. If the company needs a minimum cash balance of $5,000 to start each month, can the loan be repaid as planned? Explain.

Related Discussions:- budgeted

Multiple products, Multiple Products, Selling Costs, and Margin Management ...

Multiple Products, Selling Costs, and Margin Management Selling charge are oftentimes variable. For instance, a salesperson can be paid a designated percentage of entire sales

Calculate the incremental liquidation cash flows, How relevant to the decis...

How relevant to the decision are the $800(000) initial cost of the project and the operating losses of $300(000)? Calculate the incremental liquidation cash flows for the abando

Budget Presentation for Management, 1) Please elaborate on the attached per...

1) Please elaborate on the attached performance report by preparing a presentation to "management" which incorporates the information presented in the performance report. Present t

Determine a simplified single cost allocation rate, When implementing ABC, ...

When implementing ABC, once a company has identified business activities and their costs, the company will probably: A) determine a simplified single cost allocation rate B)

introduction of internal rate of return , Introduction of Internal Rate of...

Introduction of Internal Rate of Return The traditional internal rate of return (IRR) method of project selection has been shown to be inferior to the NPV method due to vario

Accounting case study, Accounting Case Study: The Champlain Career Con...

Accounting Case Study: The Champlain Career Consulting Corporation ("CCCC") is owned by three Trent graduates. Incorporated in 2009, CCCC provides a wide-range of career plann

Calculate the discounted cash flow and net present value, King Airlines ...

King Airlines King Airlines is one of many low-cost airlines in Europe. The managers want to expand the business and have an opportunity to purchase a second-hand plane to op

Keogh plan, Most of David's clients are local. However, a few of his client...

Most of David's clients are local. However, a few of his clients require out of town travel. He incurred $2,500 of airfare, $1,570 in lodging and $1,313 in meals relating to the bu

Measuring performance in organization, list and discus the problem encounte...

list and discus the problem encountered in adopting profit as a yardstick in measuring performance

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd