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

Cost sheet, what is a cost sheet? what are its advantages?

what is a cost sheet? what are its advantages?

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)

Process costing, what is accounting treatment for material losses due to ab...

what is accounting treatment for material losses due to abnormal reasons

What is the amount of cost of goods manufactured, Wayne Company's beginning...

Wayne Company's beginning and ending inventories for the month of June were as follows: June 1 June 30 Work in progress $145,000 171,000 Finished Goods 85,000 78,000 Production

Limitations of standard costing system, The use of standard costs can prese...

The use of standard costs can present a number of potential problems or disadvantages. Most of these problems result from improper use of standard costs and the management by excep

Economic order quantity, #purchase price R45 order costs R175 lead time 6 d...

#purchase price R45 order costs R175 lead time 6 days cost of capital (after taxation) 20% direct inventory holding costs R25 annual demand 8500 units business operational 330day p

Time analysis - cost accumulation, Time Analysis - Cost Accumulation T...

Time Analysis - Cost Accumulation This is generally achieved via having the employee complete a daily or weekly timesheet or via contain job cards or piecework tickets. As whe

Fcff and fcfe, Show the effect of an increase in each of the items listed b...

Show the effect of an increase in each of the items listed below on the FCFF and FCFE. Suppose a $100 increase in every case and a 40 percent tax rate a.    Net income b.    Cas

Calculate the equivalent annual cost, A plant is considering the replacemen...

A plant is considering the replacement of a piece of equipment in its materials handling system with a new piece. If the company's cost of capital is 10%. Should the present asset

Prepare the amortization schedule, Logan Corporation issued $800,000 of 8% ...

Logan Corporation issued $800,000 of 8% bonds on October 1, 2006, due on October 1, 2011. The interest is to be paid twice a year on April 1 and October 1. The bonds were sold to y

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: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd