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

Definitions of manufacturing concepts, Interstate Manufacturing produces br...

Interstate Manufacturing produces brass fasteners and incurred the following costs for the year just ended: Materials and supplies used Brass $75,000 Repair parts 16,000

What was the cost of goods manufactured for the period, A company started w...

A company started with $0 in direct materials, purchased $5,000 of materials, and ended with $300 in materials. Direct labor equaled $4,000. The applied overhead for the period was

Variable production cost , From  the  following  data  write the  standard ...

From  the  following  data  write the  standard  cost  card  for  one  unit  of  the  sole  product manufactured.                                    Standard Cost card for One U

Straight line method, Assume that $140,000 of Denham Springs school dostric...

Assume that $140,000 of Denham Springs school dostrict 8% bonds are sold on the bond issue date for $128,598 interest is payable semiannually, and the bonds mature in 15 years. The

Determine growth rate, (a)  The value of a share of Rio National Equity on...

(a)  The value of a share of Rio National Equity on 31 December 2002, using the Gordon growth model and the capital asset pricing model, can be determined as follows. Required

Compute the internal rate of return, ABC bond is a 20-year bond with face v...

ABC bond is a 20-year bond with face value $1000. The coupon payment is $25 per 6 months. The semi-annual yield is 4%. Use the PV function in Excel (or equivalent) to Önd the price

Labour variances, Labour Variances From our basic data, we can ca...

Labour Variances From our basic data, we can calculate the labour variances as given as: i. Labour Rate Variance = (AH x AR) - (AH  x SR)

Total annual sales revenue, Mr. Homer Simpson, President and Chief Executiv...

Mr. Homer Simpson, President and Chief Executive Officer of Duff's Beer Making Supplies Inc. recently hired you as the new budget analyst for his company.  As your first duty, he h

Calculate the bad debt estimation, Q. 1. The 31st December 2009 trial balan...

Q. 1. The 31st December 2009 trial balance of Anika Co. reported the following information. Dr. Cr. Allowance for Bad Debts........................... $1,300 During the year 201

Prepare the report and explaining the growth, You are a beginner accountant...

You are a beginner accountant with a large accountancy firm and a training day has been organised to update all technical staff on a range of topics across numerous technical disci

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