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

EXPECTED CASH COLLECTIONS, WORKED EXAMPLES OF EXPECTED CASH COLLECTIONS PAT...

WORKED EXAMPLES OF EXPECTED CASH COLLECTIONS PATTERNS

Issuance of stock - shares of common stock, 1. Issuance of stock Prepa...

1. Issuance of stock Prepare journal entries to record the issuance of 100,000 shares of common stock at $20 per share for each of the following independent cases: a. Jacks

Product versus period costs, Product Versus Period Costs Another way to...

Product Versus Period Costs Another way to look at manufacturing costs is to think of them as attaching to a product. In other words, goods result from the manufacturing proces

Method of measuring costs associated with production, Which method of measu...

Which method of measuring costs associated with production is more widely used in practice A. Normal Costing  B. Actual Costing  C. Both are used equally  D. Neither one

Gross rental revenue, Operating Income 1. Operating Income is derived f...

Operating Income 1. Operating Income is derived from two sources, Rental Income from businesses operating in the warehouse complex and Interest Income of the project operating

Conceptual Frame work, What are the dependent and independent variables in ...

What are the dependent and independent variables in Cost Accounting??

Long - term capital loss, The Smiths have a long-term capital loss carryove...

The Smiths have a long-term capital loss carryover of $10,000 from 2010. On May 9, 2007, David's uncle, Joe, gave him the family antique gun collection. Based on family records

Calculate capacity ratio and efficiency ratio, Woodall Ltd has two producti...

Woodall Ltd has two production departments, X and Y. For month 2, the company budgets its overhead costs as:   X Y Variable overhead

Prepare the purchases ledger control account, You work for a firm of accoun...

You work for a firm of accountants as a junior accounts assistant and part of your role is to prepare clients' ledgers accounts from incomplete records. A client of the firm you

ECONOMIC ORDER QUANTITY, ANNUAL DEMAND = 2400 UNITS ORDERING COST PER UNIT ...

ANNUAL DEMAND = 2400 UNITS ORDERING COST PER UNIT = RS.4.00/- UNIT PRICE = RS 2.40/- STORAGE COST = 2% P.A INTEREST RATE = 10 % P.A LEAD TIME = HALF MONTH CALCULATE ECONOMIC ORDER

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