User Account

All Pages

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

Combined cash - bank account- cash book, The following is a summary of a ca...

The following is a summary of a cash book for the year ended 31 April 2012 Payments                                              $              Receipts

Direct material, Flying High Company manufactures model airplanes. During t...

Flying High Company manufactures model airplanes. During the month, it manufactured 10,000 airplanes. Each one used an average of 6.5 direct labor hours and an average of 1.5 sheet

Storage and issue of material, Storage and Issue of Material A number ...

Storage and Issue of Material A number of questions are relevant in this control of materials throughout storage and question of materials. These are as: a) Stock control r

Compute the days'' sale, Year Ending April 2009, 2009 April 30, 2008 Net Sa...

Year Ending April 2009, 2009 April 30, 2008 Net Sales $10,148,082 $10,070,778 Accs Receivable 1,171,797 1,161,481 Assume that the accounts receivable (in thousands) were $996,852 a

EXPECTED CASH COLLECTIONS.PRACTICE QUESTIONS, WORKED EXAMPLES OF EXPECTED C...

WORKED EXAMPLES OF EXPECTED CASH COLLECTIONS PATTERNS

Business management, Business Management Business Management includes ...

Business Management Business Management includes planning and staffing, organizing, directing and controlling an organization's activities so like to meet a specified objectiv

Cost concept, cost accounting concept

cost accounting concept

Management accounting, Management Accounting It is the part of account...

Management Accounting It is the part of accounting such provides special-reason statements and reports to other persons and management inside the organization.  The informatio

Determine the expected range of returns , Series Arithmetic Mean ...

Series Arithmetic Mean Standard Deviation   Small-company stocks 15.9  % 32.8  %   Large-company

Cost accounting terms, what is the meaning or definition of cost objective?...

what is the meaning or definition of cost objective?

Write Your Message!

Captcha
Order Assignment

Featured Services

Order Now

Popular Subjects

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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