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

Determine the interest expense is deductible, Assume the same facts as in 1...

Assume the same facts as in 1A above, except that the interest payment checks were placed on the shareholders' office on December 31, 2012. However, the shareholders are not in the

Plant wide overhead rate, how do you find the plant wide overhead rate?

how do you find the plant wide overhead rate?

Cost classification, Identify and explain many classification of costs for ...

Identify and explain many classification of costs for planning, control, performance evaluation and decision making.

Giardia, Place a prepared slide of Giardia first under tlie low power and t...

Place a prepared slide of Giardia first under tlie low power and then under the high power of the microscope and observe tlie followilig characters. i) Bilaterally symmetrical

Evaluate the cost structure, The project (using the tools and techniques gi...

The project (using the tools and techniques given in Chapters 3, 8, 10, 11, and 12 of the textbook) and its subsequent report are based on the complete economic analysis of a compa

Prepare a partial income statement, Timbatown Pty Ltd is a manufacturer of ...

Timbatown Pty Ltd is a manufacturer of timber tables and chairs. The company mostly sells on a retail basis to household consumers, but occasionally receives large orders for table

Determine the expost returns, Calculate the skewness and kurtosis statistic...

Calculate the skewness and kurtosis statistics for your assignment portfolio. How do these reconcile with the assumptions behind Modern Portfolio Theory? Demonstrate analyticall

Business and the generation of accounting standards, This time of year we a...

This time of year we all here about football. For me it is the bad news of how poorly the Buffalo Bills are performing. Hopefully your favorite team is doing well. One thing we

How many bottles do they need to sell to breakeven, Denair Fine Wines, Inc....

Denair Fine Wines, Inc., is planning to bring out a higher-quality wine product than any currently available in Stanislaus county. They've decided on selling the blended, fortified

Marginal costing and marginal cost, Marginal Costing and Marginal Cost ...

Marginal Costing and Marginal Cost Marginal Costing is an optionally method of costing to absorption costing , In marginal costing, merely variable costs are charged like a

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