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

Marginal analysis, Marginal analysis finds to equalize the cost of producin...

Marginal analysis finds to equalize the cost of producing one more item (marginal costs) with the revenue gained from selling one more item (marginal revenue).

How many pizzas must vince''s sell to break even, Vince's Pizza delivers pi...

Vince's Pizza delivers pizzas to dormitories and apartments near a major state university. The company's annual fixed costs are $48,000. The sales price averages $9, and it costs t

Idle capacity, How does idel capacity effect cost behavior patterns and fac...

How does idel capacity effect cost behavior patterns and factory overhead application methods

Accounting, Ask What is the major value of the weighted cost of capital cal...

Ask What is the major value of the weighted cost of capital calculation for the firm? question #Minimum 100 words accepted#

Method of bonus payment , from the following particulars calculate the earn...

from the following particulars calculate the earning of worker . rate per hours $0.50 standard time 200 hours time taken 140 hours

Prepare trial balance for transactions, Encik Farid, a sole trader, started...

Encik Farid, a sole trader, started his business on 1 May 2010 under the name Farid Enterprise. The following are his business transactions for the month of May a. Encik Farid b

Ow much overhead will be assigned to each sailboat produced?, ShipShape Com...

ShipShape Company makes 2 different types of boats, commercial fishing and sail boats both for recreation and competition. The company consists of two different departments, design

Direct material cost variances (dmcv), Direct Material Cost Variances (DMCV...

Direct Material Cost Variances (DMCV) This variance is a general difference in the standard direct material cost and the actual direct material cost. This variance may be prese

Find the fixed cost, A firm's fixed costs for 0 units of output and its ave...

A firm's fixed costs for 0 units of output and its average total cost of producing different output levels are summarized in the table below. Complete the table to find the fixed c

Elements of manufacturing cost, i want some informations about elements of ...

i want some informations about elements of manufacturing cost

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