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

Funds from operations, Consider as Illustration. Profit and loss account of...

Consider as Illustration. Profit and loss account of TIL demonstrates, that, operations have given gross addition of Rs. 360 million to funds throughout the period. These funds sho

Scope of cost accounting, what is the scope of cost accounting?

what is the scope of cost accounting?

Limitations of standard costing, L I M I T A T I O NS OF STANDARD ...

L I M I T A T I O NS OF STANDARD COSTING 1.     It may be very difficult to fix standards for all operations. 2.     Incorrect standards may result in wastage of mo

Assignment, What is the major value of the weighted cost of capital calcula...

What is the major value of the weighted cost of capital calculation for the firm?

Even applications, in process beg and ending

in process beg and ending

Perform an incremental analysis, Bakers Bagels LLC produces and sells 20 ty...

Bakers Bagels LLC produces and sells 20 types of bagels by the dozen. Bagels are priced at $6.00 per dozen (or $0.50 each) and cost $.020 per unit to produce. The company is consid

Job costing, Your company completed the site work for the South Pointe offi...

Your company completed the site work for the South Pointe office complex. The costs are shown in Figure 11-3. The site concrete labor and landscaping were done by subcontractors. T

Importance of cash and cash flow statement, Cash is the other form of fund ...

Cash is the other form of fund although in a narrow sense, this refers to a supply which can be drawn upon as per to the need. Here the term cash involves both cash and cash equiva

Variable costs, Variable Costs Are costs such raise or fall proportio...

Variable Costs Are costs such raise or fall proportionately along with the level of activity that is such portion of the cost of an activity which changes along with the leve

Marginal costing, sums with solution of marginal costing

sums with solution of marginal costing

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