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

Accounting for job order costing, Accounting for Job Order Costing ...

Accounting for Job Order Costing 1.  Direct Labor  Dr W.I.P. Control Account Cr Cash Account 2.  Accrued Direct Wages Dr W.I.P. Control Account Cr Wages

Direct labour budget, Direct Labour Budget It represents the forecasts...

Direct Labour Budget It represents the forecasts of indirect and direct labour requirements to meet the demands of the company throughout the budget period. Therefore the budg

Limitations of unit cost, What are the limitations of unit cost.

What are the limitations of unit cost.

What is the idyllic minimum or maximum population, Q. What is the idyllic m...

Q. What is the idyllic minimum or maximum population required to use fca? Ans. FCA is not depending on size. It is merely a common-sense approach to overseeing money and k

Close-end matching grants, RC School District has a large number of student...

RC School District has a large number of students in need of remedial instruction.  The superintendent of RC School System can allocated her budget between purchasing X units of re

Method of bonus payment , from the following particulars calculate the earn...

from the following particulars calculate the earning of worker . rate per hours $0.50 standard time 200 hours time taken 140 hours

Bin card, I need an explanation of how a bin card is done

I need an explanation of how a bin card is done

Calculate average cost and marginal cost, Farmer Dorr figures that her fixe...

Farmer Dorr figures that her fixed costs are $2,000, and the relevant portion of her total cost curve is:                                           Thousands of

Valuation of inventory or closing and issues stocks, Valuation of Inventory...

Valuation of Inventory or Closing and Issues Stocks Valuation of inventory aims on attaching a monetary value in the issued or stores for production. It is useful in producing

Interest rates and adjust rates, The Federal Reserve adjusts short term int...

The Federal Reserve adjusts short term interest rates based upon their perceptions of the needs in the economy.  Please describe the ways the Federal Reserve can influence interest

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