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

Sanford charge to expense during 2013, In January, 2008, Sanford Corporatio...

In January, 2008, Sanford Corporation purchased a patent for a new product for $1,200,000. The patent was valid for fifteen years but it was estimated to have a useful life of ten

What would be the impact on net income, Brandywine Homecare, a not-for-prof...

Brandywine Homecare, a not-for-profit business, had revenues of $12 million in 2011. Expenses other than depreciation totaled 75 percent of revenues, and depreciation expense was $

Manufacturing a/c, value of which items are required to be put in a simple...

value of which items are required to be put in a simple format of manufacturing a/c.

Calculate over applied overhead for last year, The following information re...

The following information relates to Araceli Manufacturing Company: total estimated manufacturing overhead cost at beginning of year $864,000 predetermined overhead rate (based

Standard costing system, Standard costing System has the following main adv...

Standard costing System has the following main advantages or benefits: 1. The process in itself often discloses inefficiencies, because the setting of standards requires a thoro

Requirements of uniform costing, Requirements of Uniform Costing 1. Un...

Requirements of Uniform Costing 1. Uniform costing systems must process the given features as: 2. Cost reports and statements should be organized and laid out in a same for

Break-even chart, Break-Even Chart This is a diagrammatic presentation...

Break-Even Chart This is a diagrammatic presentation of the relationship among costs, prices, expenses and the sales volume. A break-even chart expresses revenue and expens

Long run average marginal cost curves of the firm, Q. Let a firm's producti...

Q. Let a firm's production function be given by K 0.3 L 0.7 . (i) Sketch (without specific numbers) the shape of the long run average and long-run marginal cost curves of the fir

Calculate remuneration of employee of an organisation, Calculate Remunerati...

Calculate Remuneration of Employee of an Organisation Based on the data underneath that you are necessary to calculate the remuneration of all employee like determined with ea

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