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

Profit an economic profit, Johnson Farms owns valuable farm land that permi...

Johnson Farms owns valuable farm land that permits it to make wheat at a lower cost than its competitors. The company reports large profits every year on its accounting statements.

Direct labour efficiency variances, Direct Labour Efficiency Variances ...

Direct Labour Efficiency Variances It is the difference between the standard hours allowed for the actual production achieved and the hours actually worked, all valued at THE

Difference between balance sheet and income statement, (i) Describe the di...

(i) Describe the difference between the balance sheet and the income statement in financial statements of companies. (ii) Give two examples of intangible assets and two exampl

Cvp analysis in situations subject to change, CVP Analysis in Situations Su...

CVP Analysis in Situations Subject To Change Revenue and Cost will change and also sales volume because of a number of factors involving: a) Increased competition may need

Earnings per share, Daisy Ltd has a net profit after tax of $3 400 000 for ...

Daisy Ltd has a net profit after tax of $3 400 000 for the year ending 30 June 2012.  For the entire financial year Daisy Ltd had two million $1.00 cumulative preference shares on

Differential costing, explain the practical application of differential cos...

explain the practical application of differential costing with the help of suitable example.

Cost accounting, diff between cost estimation and cost accounting

diff between cost estimation and cost accounting

Employers retirement plan, Amy earns $35,000 working part time. Consequentl...

Amy earns $35,000 working part time. Consequently, she is not eligible to participate in her employer's retirement plan or health insurance program. Amy's expenses are summarized a

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