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

Evaluate outstanding balance, Winston Duff is planning to borrow $225,000 ...

Winston Duff is planning to borrow $225,000 to purchase a new home. Mr. Duff is considering two fixed-rate financing alternatives offered by Horsepen Creek State Bank. The first

Applications of marginal costing, what is the importance and assumptions of...

what is the importance and assumptions of application of marginal costing

Recording Transactions, I have a project due this week and I am having slig...

I have a project due this week and I am having slight issues with the transactions. I cannot seem to receive the correct titles under the recordings

Calculate the minimum annual sales, a factory operates a small canteen but ...

a factory operates a small canteen but its annual operation has consistently shown a loss:

Cash budget - budgetary planning and control, Cash Budget - Budgetary Plann...

Cash Budget - Budgetary Planning and Control This can records the cash outflows and inflows that are expected to take place in respect of every functional budget. This may be

Alternative to total overhead variances, Alternative to Total Overhead Vari...

Alternative to Total Overhead Variances There is an easier approach to overhead variances.  In this approach, the overheads are NOT sub-divided into their fixed and variable e

Calculate the annual profit from the farm , Xander Harris is considering wh...

Xander Harris is considering whether to buy a corn and soybean farm in Iowa. The farm will cost $800,000, and Xander will be able to pay this from profits his recently deceased mot

Plot janitorial labor cost produced on a scattergraph, The number of workd...

The number of workdays varies from month to month due to the number of weekdays, holidays, days of vacation, and sick leave taken in the month. The number of units produced in a

What is the margin of safety, Apollo Company manufactures a single product ...

Apollo Company manufactures a single product that sells for $168 per unit and whose total variable costs are $126 per unit. The company's annual fixed costs are $630,000. (1) Use t

Non-profit cash flows statement, Are non-profit and governments required to...

Are non-profit and governments required to depreciate assets? Why or why not? Would it make sense for them to use double declining balance? Is there a difference between a non-p

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