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

Calculate the net effective yield, A Government issued a number of index-li...

A Government issued a number of index-linked bonds on 1 June 2000 which were redeemed on 1 June 2002.  Each bond had a nominal coupon rate of 3% per annum, payable half yearly in a

Applications of marginal costing, what is the importance and assumptions of...

what is the importance and assumptions of application of marginal costing

Marginal costing, sums with solution of marginal costing

sums with solution of marginal costing

Outstanding expenses, Expenses are usually recorded only while they are pai...

Expenses are usually recorded only while they are paid. The failure to record unpaid expenses in the accounts outcomes in an understatement of which expense and also an understatem

Objective type question, 9. When in the management process do managers seek...

9. When in the management process do managers seek an answer to the question "Did we meet our cost-reduction goals for non-value-adding activities?" a. Planning b. Performing c. Ev

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

Calculate the price of regular bonds, XYZ Inc. plans to raise $5,000,000 ex...

XYZ Inc. plans to raise $5,000,000 external financing through issuing bonds, and is considering two options: regular bonds and zero couple bonds.  The regular bonds will have coupo

Feedback forward control system and feedback controls, A transport company ...

A transport company is preparing its cost budgets for the coming year. It has been set both social objectives & cost targets by the government which it must achieve in order to rec

Determine opportunity costs, Determine Opportunity Costs A company has...

Determine Opportunity Costs A company has material B in stock that originally cost Shs. 5000 for the 1000 Kshs in stores. The material is missing over from an old purchase ord

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