budgeted, Question: Yamba Home Products is just beginning its fourth quarter, in which, Cost Accounting

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.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages

budgeted, Cost Accounting

Related Discussions:- budgeted

Finance and logistics, responsibility of director of finance and logistics

FSND Analysis, What is idle time for Fast Moving,Slow Moving,Non Moving, an...

Calculate the group profit and loss, Using the chosen company from Bursa Ma...

Find the total landed cost, What conclusion can you draw when comparing the...

Classification of cost, what is the meaning of classification of cost in re...

Comparison between marginal and absorption costing, Comparison between Marg...

Calculated the net working capital, Balance Sheet ...

Cost accounting, cost accounting as a descriptive/analytical discipline

Illustration of overhead variance analysis, Illustration of Overhead Varian...

Idea behind activity-based costing, Idea behind Activity-Based Costing ...

Write Your Message!

Featured Services

Online Tutoring

Project Development

Exam Preparation

Course Help

Assignment Help

Popular Subjects

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT