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

WACC, formula for calculting WACC

formula for calculting WACC

Davids net state lottery gains, One month before she died on April 14, 2002...

One month before she died on April 14, 2002, Barbara Gent (Amy's aunt) gave Amy a coin collection. Based on careful records that Barbara kept, the collection had a cost basis of $9

Marginal costing from financial information for management, prepare a trad...

prepare a trading and profit and loss accounts for the period using marginal costing and absorption costing

Determine the current price of shares, 2. Blue-Jay Sporting Goods is a star...

2. Blue-Jay Sporting Goods is a start-up company that expects to earn $3.00 per share next year. Since the firm currently retains 100 percent of earnings to finance future grow

Calculate the direct-material price and quantity variances, Quicksilver Com...

Quicksilver Compnay has set the follwoing standards for one unit of product: Direct material Quantity: 6.2 lbs per unit Price per lb: $11 per lb Direct Labor Quantity: 6 hrs

Determine the variable cost element for selling expense, The following info...

The following information pertains to Tudor Logistics Company: 200X Information: Sales                                      $4,875,000 Selling expense

Qualities of accounting profession, explain any five qualities of accountin...

explain any five qualities of accounting profession

Development and research cost budget, Development and Research Cost Budget ...

Development and Research Cost Budget These are costs that are discretional in nature such as they are determined on need basis via the managers concerned. Research cost is the

Inventory systems, Find a journal article online about just-in-time invento...

Find a journal article online about just-in-time inventory systems. In the subject line of your post, include the title of the article that you read. Post a link to that article wi

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

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

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