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

Importance of cost classification, Importance of Cost Classification A...

Importance of Cost Classification Analysis of cost behaviour is significant to all organizations for effective management. It is since many organizations have a unique cost st

Calculated the net working capital, Balance Sheet                      ...

Balance Sheet                                                                      2010                2011             Assets Cash

MARGINAL AND ABSORPTION COSTING, MARGINAL COSTING IS PREFERRED TO ABSORPTIO...

MARGINAL COSTING IS PREFERRED TO ABSORPTION COSTING IN DECISION MAKING WHY

Approtionment overheads, Is building rental connected to kilowatt hours

Is building rental connected to kilowatt hours

Break-even calculations, Break-Even Calculations As they say, a picture...

Break-Even Calculations As they say, a picture is significance a thousand words, and this is undoubtedly true for the CVP graphic just presented. Though, everyone is not an art

Conceptualizing job costing, Conceptualizing Job Costing Start to devel...

Conceptualizing Job Costing Start to develop an understanding of job costing by thinking about the simple illustration. Jack Castle owns an electrical constricting company, Cas

Calculate the variable cost, Workmen shoes accumulated the following produc...

Workmen shoes accumulated the following production and cost data for the past 5 months. i)  Using the high/low method calculate the variable cost per unit and the fixed cos

Cost accounting, Cost Accounting Cost accounting has been defined via ...

Cost Accounting Cost accounting has been defined via many accounting scholars in different forums. There is no single watertight definition of cost accounting, however the var

Relevance of interdependence , Describe the meaning and relevance of interd...

Describe the meaning and relevance of interdependence of variances when reporting to managers.

Close-end matching grants, RC School District has a large number of student...

RC School District has a large number of students in need of remedial instruction.  The superintendent of RC School System can allocated her budget between purchasing X units of re

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