budgeted, Cost Accounting

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.
Posted Date: 8/20/2013 3:24:58 AM | Location : Australia







Related Discussions:- budgeted, Assignment Help, Ask Question on budgeted, Get Answer, Expert's Help, budgeted Discussions

Write discussion on budgeted
Your posts are moderated
Related Questions
I need project help in Government and nonprofit accounting, can you help me in look out this problems?

Devprop Leasing Co.is an industrial property development company, that typically develops warehouse and industrial complexes in new or underdeveloped areas, operates these complexe

(a)  (i) Conversion Value Conversion Value = Conversion Ratio * Stock Price                 = 22*$40 = $880 (ii) Market Conversion Price Market Conversion Price =

Cost Volume Profit Analysis 1. Post Publishers has collected the following data for recent months: Month                 Issues published              Total cost May

Vincent Ltd operates solely in Western Australia and the chief operating decision maker has identified five operating segments: Mining, Insurance, Retailing, Manufacturing and Tran

Cost Classification Bases Costs can be classified on either more or one of the given bases as: a) Are the costs dependent on the level of output as like variable or are the

UTILITY OF BREAK EVEN POINT IN MANAGERIAL DECISION MAKING 1. It assists in determination of sales mix 2. It assists in exploring new markets 3. It assists in deciding abo

Standard Cost and Standard Costing To effectively control the costs of a certain organization, we require a yard stick to measure the real performance against. Traditionally,

Classification of Labour Costs This can be classified into like: a) Indirect or Direct cost b) Variable or Fixed cost c) Non controllable and controllable cost a)

weekly working hour 48 , hourly wage rate 15$ , price rate per unit 6$ , normal time taken per piece 36 minuets , normal output per week 220 pieces , actual output per week 275 pie