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

Zero based budgeting, Zero Based Budgeting It is referred to also lik...

Zero Based Budgeting It is referred to also like priority based budgeting. It is a cost advantage approach budgeting where it is assumed that the cost allowance is Zero for a

Job-order costing system.., Compute the predetermined overhead rate used du...

Compute the predetermined overhead rate used during the year in the Preparation and Fabrication Departments.

Capital project, is sale of salvage from capital project recorded as gain/l...

is sale of salvage from capital project recorded as gain/loss or applied back to project costs

Decision making, Decision Making Nature of Decision-making Deci...

Decision Making Nature of Decision-making Decision-making may fall into any type of the following categories as: 1. Short run operational decisions 2. Short run t

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

Costs of the service departments, Bull Bay Ltd. Manufacturers two types of ...

Bull Bay Ltd. Manufacturers two types of surfboard, "Winner" and "Surf King", whose selling prices are $300 and $900 respectively. Each surfboard passes through two manufacturing d

Cost classification bases, Cost Classification Bases Costs can be clas...

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

Calculate the minimum annual sales, a factory operates a small canteen but ...

a factory operates a small canteen but its annual operation has consistently shown a loss:

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