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

Why different countries have different accounting standards, As a potential...

As a potential investor, what is the problem with different countries having different accounting standards? As the president of a multinational company, what is the problem with

Compute the most profitable combination of products, GZ Inc. manufactures t...

GZ Inc. manufactures two products that require both machine processing and labor operations. Although there is unlimited demand for both products, GZ could devote all its capacitie

Prepare cost sheet, The Pacific Manufacturing Company operates a job-order ...

The Pacific Manufacturing Company operates a job-order costing system and applies overhead cost to jobs on the basis of direct labor cost. Its predetermined overhead rate was based

Margin of safety, Margin of safety Measures the sensitivity of budgeted...

Margin of safety Measures the sensitivity of budgeted sales volume compared with break-even sales volume. The difference between level of sales activity achieved and level of s

Bin card, I need an explanation of how a bin card is done

I need an explanation of how a bin card is done

Calculate the current cost capital, The Zooline Company (Pty) Ltd is an Ame...

The Zooline Company (Pty) Ltd is an American based company that focuses on the LSM 8 -10 markets. They do vehicle interiors, raise or lower suspensions and install top end sound sy

What is the overhead variance, Morrow Company applies overhead based on dir...

Morrow Company applies overhead based on direct labor hours. At the beginning of the year, Morrow estimates overhead to be $620,000, machine hours to be 180,000, and direct labor h

Job Order Costing, Bedovin Company manufactures office tables and chairs us...

Bedovin Company manufactures office tables and chairs using the job order cost system

Cost volume profit analysis, Cost Volume Profit Analysis 1. Post Publish...

Cost Volume Profit Analysis 1. Post Publishers has collected the following data for recent months: Month                 Issues published              Total cost May

Write Your Message!

Captcha
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!

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