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

What is wage rate, The employees at Warren Manufacturing Company are unioni...

The employees at Warren Manufacturing Company are unionized. As minimum requirements, the union members insist on keeping a work force of at least 300 workers, and accepting an hou

Determine the expected return, Imagine a world in which there are only two ...

Imagine a world in which there are only two investment assets: Hasbro Inc. Stock (HAS) and McDonalds stock (MCD). The table below lists annual total returns (%) for each of the las

Describe the concept of full cost recovery with illustrative, Describe the ...

Describe the concept of full cost recovery with illustrative examples.

Assumptions of cvp, Assumptions of CVP This chapter has given informati...

Assumptions of CVP This chapter has given information on how to apply CVP for the business analysis. Most of this analysis is keyed to the model of how profitability is impacte

Determine the cost of the finished goods inventory, Manufacturing statemen...

Manufacturing statements and cost behavior  Tampa Foundry began operations during the current year, manufacturing various products for industrial use. One such product is light-g

Current funding availability, 1. The Initial Borrowings required are determ...

1. The Initial Borrowings required are determined by the amount required to start  the project less the Cash Invested by the Corporation.  The loans will always be principle & inte

Calculate labour time or efficiency variance, standard hours = 5000 standa...

standard hours = 5000 standard wages = Rs.3/hr actual hours worked = 5600 hrs actual wages paid = 17920

Identify the income statement and balance sheet, In January 2012, the manag...

In January 2012, the management of Stefan Company concludes that it has sufficient cash to permit some short-term investments in debt and stock securities. During the year, the fol

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