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

Estimate the manufacturing cost for bearing housing, Estimate the manufactu...

Estimate the manufacturing cost for a bearing housing following the Formula Student Costing Scheme.  Dimensions and materials of the bearing housing will depend on your student

Absorbtion, when one firm purchase other and take over its all assets.balan...

when one firm purchase other and take over its all assets.balance sheet of absorbed firm shows goodwill,should we goodwill as well?

Presentation & Essay, Why are the main contribution teams can make to an or...

Why are the main contribution teams can make to an organisation? What are the conditions necessary in organisations if people are to work effectively in teams? * Describe what tea

Cost - terms used in cost accounting, Cost - Terms Used in Cost Accounting ...

Cost - Terms Used in Cost Accounting It measures the economic sacrifice created to achieve an organizations aims. For a product, cost represents the monetary measurement of re

Cost bookkeeping, what are the accounting entries for interlocking and int...

what are the accounting entries for interlocking and integrated systems of cost accounting?

Purpose of cost accounting information, Purpose of Cost Accounting Informat...

Purpose of Cost Accounting Information Cost accounting is employed for a number of reasons, some of that are briefly described in the given points as: a) Accounting for co

Find the weighted average cost of capital, PrivateJets (PJ) is considering ...

PrivateJets (PJ) is considering expanding its operations in the corporate travel market. Currently, PJ has a capital structure with a 25% debt-equity ratio. Their levered equity

Evaluate the cost structure, The project (using the tools and techniques gi...

The project (using the tools and techniques given in Chapters 3, 8, 10, 11, and 12 of the textbook) and its subsequent report are based on the complete economic analysis of a compa

Determine internal rate of return and cash flow statement , A local deliver...

A local delivery company has purchased a delivery truck for $15,000.  The truck will be depreciated under MACRS as a five year property.  The trucks market value (salvage value)

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