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

Factory overhead, what are the examples of factory overhead

what are the examples of factory overhead

Compute the irr, Matheson Electronics' Canadian Branch will help introduce ...

Matheson Electronics' Canadian Branch will help introduce into Canada the just developed new electronic device which, when mounted on an automobile, will tell the driver how many m

Cost drivers and predictors, why is determining the cost to manufacture a p...

why is determining the cost to manufacture a product quite a different activity from determining how to control such cost?

What are the firm’s fixed cost, Q. A firm's total cost function is given b...

Q. A firm's total cost function is given by TC = 2Q 2 + 10. What are the firm's fixed cost, variable cost, average fixed cost, average variable cost, and marginal cost functions?

Paramecium, Place a prepared slide of Paratuecium under the microscope and...

Place a prepared slide of Paratuecium under the microscope and focus it under low power (5x x 5x) and observe the following: i) It has a cigar-shaped or slipper-shaped body

Objective type question, 1. Pardee Company plans to sell 12,000 units durin...

1. Pardee Company plans to sell 12,000 units during the month of August. If the company has 2,500 units on hand at the start of the month, and plans to have 2,000 units on hand at

What is the optimal price without price discrimination, We consider two reg...

We consider two regions A and B. Each market has the same size (i.e. number of consumers) but differs in the willingness to pay for one unit of the good proposed by the firm. On ma

Calculate the net present value and efficiency , A foreign company plans to...

A foreign company plans to clear several dozen acres of ecologically valuable mangrove swamp in Vietnam for the creation of a shrimp aquaculture facility. This decision will create

Explain with examples and cite were needed, What are the distinguishing cha...

What are the distinguishing characteristics of these types of stock- describe any one of them. What is the difference between par value, book value and market value of stock? Expla

Planning Budgetting, Bugga Corp expects to sell 3,000 units in October, and...

Bugga Corp expects to sell 3,000 units in October, and expects sales to increase 20% each month thereafter. Sales price is expected to stay constant at $8 per unit. What are budge

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