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

Prepare a statement of cash flows, 2012                     2011 Cash   ...

2012                     2011 Cash                               12200                 17700 Acct receivable                  25200                  22300 Investments

Evaluate the cost structure, The project (using the tools and techniques gi...

The project (using the tools and techniques given in Chapters 3, 8, 10, 11, and 12 of the textbook) and its subsequent report are based on the complete economic analysis of a compa

Calculate actual costs of work performed, This is defined as an actual amou...

This is defined as an actual amount paid or incurred, as opposed to estimated cost or standard cost. In contracting, actual costs amount includes direct labor, direct material, and

Standard costing, behavioral aspect of standard costing

behavioral aspect of standard costing

Goods and services tax, William Potter is a plumber currently operating as ...

William Potter is a plumber currently operating as a Sole Trader in Levin. William has approached you, a tax accountant, for your advice on certain tax matters. William's brothe

Calculate break even point using a mathematical equation, Smart Ltd ha sa u...

Smart Ltd ha sa unit selling price of $500 variable costs per unit of $325 and fixed costs of $140 000. Calculate the break even point in units using (a) a mathematical equations a

Prepare the journal entries to record declaration, Unrecaptured Sec. 1250 G...

Unrecaptured Sec. 1250 Gain and 1231. Mr. Briggs purchased an apartment complex on January 10, 2011, for $2 million with 10% of the price allocated to land. He sells the complex on

Alternative to total overhead variances, Alternative to Total Overhead Vari...

Alternative to Total Overhead Variances There is an easier approach to overhead variances.  In this approach, the overheads are NOT sub-divided into their fixed and variable e

Example of over and under absorption of production overhead, Example of Ove...

Example of Over and under absorption of production overhead costs By employing data from diagram assume such the production overhead absorption rate was computed where an acti

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