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

Internal users of accounting information, Describe the ways in which the ne...

Describe the ways in which the needs of internal and external users of accounting information are the same and different.

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

Schedule of work in process, Schedule of Work in Process The given sche...

Schedule of Work in Process The given schedule presents the calculations which pertain to work in the process. Pay attention to the details, noting that (1) direct materials

Determine internal rate of return and cash flow statement , A local deliver...

A local delivery company has purchased a delivery truck for $15,000.  The truck will be depreciated under MACRS as a five year property.  The trucks market value (salvage value)

Evaluate the balance in the patent account, Banana Corporation had the foll...

Banana Corporation had the following transactions relating to a patent: January 1, 2010: Purchased patent for $2,000,000. The patent had fifteen years remainnig although Banan

Job-order costing, Division B uses  normal  costing in its job-order costin...

Division B uses  normal  costing in its job-order costing system, with manufacturing overhead  applied  based on direct labour hours.  You have obtained the following information a

Costsheet, preparation of costsheet

preparation of costsheet

Prepare the capital accounts, Shirley and Ken are in partnership, trading i...

Shirley and Ken are in partnership, trading in the construction industry. The year end for the partnership business is 30 June. You are the Assistant Accountant and have been as

An impact on the breakeven, We've all experienced (or heard about) the chal...

We've all experienced (or heard about) the challenges that the airlines have been facing. Read the Zacks Investment Research article, "Airline Industry Stock Outlook - August 2012"

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

explain any five qualities of accounting profession

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