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

Reasons for overhead variances useful for control reasons, Reasons for Over...

Reasons for Overhead Variances Useful for Control Reasons Overhead variances are essentially a book balancing exercising giving an arithmetic reconciliation between the actual

Manufacturing cost, Use a selected company or your current work environment...

Use a selected company or your current work environment to identify at least one cost or expense that would fit under each of the following categories: • Variable • Fixed • Mixed •

Calculate cost or equivalent units, Calculate Cost or Equivalent Units ...

Calculate Cost or Equivalent Units The given work in progress account concerns to the blending department of a company, a soft-drinks company for the month of January in 1999

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

Prepare the consolidated balance sheet, H Bhd has a 75% holding in the ordi...

H Bhd has a 75% holding in the ordinary shares of S Sdn Bhd and 40% in A Sdn Bhd. Shares in S were acquired  in 2006 when its retained earnings were RM120 million.  The shares in A

Social benefit cost analysis, Define the concept of opportunity cost in y...

Define the concept of opportunity cost in your own words. Given an example from your own life of the opportunity cost of a decision (do NOT use classroom examples). Explain why o

Issuance of stock - shares of common stock, 1. Issuance of stock Prepa...

1. Issuance of stock Prepare journal entries to record the issuance of 100,000 shares of common stock at $20 per share for each of the following independent cases: a. Jacks

Material handling, Material Handling The objective is to ensure about ...

Material Handling The objective is to ensure about the goods are delivered to the right places at the right instance and in aright manner to ignore delays, unnecessary and con

Draw the demand curve of marginal benefit, The total demand (marginal benef...

The total demand (marginal benefit) curve for visiting Yosemite is as follows: Price = 5000-10*NumberOfTrips -10*TonsOfVisibleTrash. a. Suppose the quantity of trash=100 tons. D

Example of high - low method of cost estimation, Example of High - Low Meth...

Example of High - Low Method of Cost Estimation Based on the performance, such you have been provided along with the given information regarding ABC Ltd for the year ended on

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