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

The installation of a costing system in a business, discuss the problems of...

discuss the problems of installing a costing system

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

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

What was the amount of cash collected from customers, Q. What was the amoun...

Q. What was the amount of cash a firm collected from its customers, given the following fact set? The firm's balance sheets at the beginning and end of the year show gross accou

Budget project, need help with master budget

need help with master budget

Classification of cost, what is the meaning of classification of cost in re...

what is the meaning of classification of cost in relation to variability?

Cost classification, #question.discuss the importance of cost classificatio...

#question.discuss the importance of cost classification to a business organisation?

Determine cost, . Alice Company has received a special order from Jo...

. Alice Company has received a special order from John. John wishes to buy 100 units of Alice's product at a price of $48. The regular price is $65. The unit cost informati

Compute the cost per unit, Fosson Furniture uses a process cost system to a...

Fosson Furniture uses a process cost system to account for its chair factory. Beginning inventory consisted of 5,000 units (100% complete as to material, 55% complete as to labor)

Draw the demand curve - quantity of trash, The total demand (marginal benef...

The total demand (marginal benefit) curve for visiting Yosemite is as follows: Price = 5000-10*NumberOfTrips -10*TonsOfVisibleTrash.     a. Suppose the quantity of trash=100 ton

Calculate the optimal re-order quantity, Mr. Marley is a wholesaler who buy...

Mr. Marley is a wholesaler who buys and sells a wide range of products, one of which is the Laker. Mr. Marley sells 24,000 units of the Laker each year at a unit price $20. Sales o

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: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd