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

Relationship among management accounting and cost accounting, Relationship ...

Relationship among management accounting and cost accounting Referring to CIMA's definition for cost accounting, we can determine cost accounting is a part of management accou

What are fixed costs, The costs that are fixed irrespective of manufacture ...

The costs that are fixed irrespective of manufacture are fixed costs. EX: Rent, Depreciation. Fix cost is those cost who not alter in any time whether the production done or not

Direct material, Flying High Company manufactures model airplanes. During t...

Flying High Company manufactures model airplanes. During the month, it manufactured 10,000 airplanes. Each one used an average of 6.5 direct labor hours and an average of 1.5 sheet

What are the variable expenses per unit, Superior Door Company sells pre-hu...

Superior Door Company sells pre-hung doors to home builders. The doors are sold for $60 each. Variable costs are $42 per door and fixed costs total $450,000 per year. The company i

Overheadd anarlysis, Following figures are taken from annual budget of ABC ...

Following figures are taken from annual budget of ABC manufacturers for the year 2013: Fixed factory overhead Rs. 4,000,000 Factory overhead absorption rate Rs. 70 per direct labor

Distinction between absorption and marginal costing, Distinction between Ab...

Distinction between Absorption and Marginal Costing These are two approaches of arriving at the cost of production or total profit for a specified period. The major difference

Period costs, Period Costs Some terms are difficult to define. In one s...

Period Costs Some terms are difficult to define. In one school of thought, period costs are the any costs that are not product costs. But, such a description is a stretch, beca

Prepare the relevant journal entry to account, The following information is...

The following information is provided to you concerning Lydia Ltd as at 30 June 2012.  Assume a company tax rate of 30%. (i) The balance of rent received in advance in the balan

Prepare an amortization table, On January 1, 2012 Morgan's Motors issued $5...

On January 1, 2012 Morgan's Motors issued $500,000 of 3-year, 8% bonds when the market yield was 6%. The bond agreement stated that compounding was semi-annual with payments due on

.inventory, what are thereasons for holding inventories

what are thereasons for holding inventories

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