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

Compute the equivalent units of production for materials, Clopack Company m...

Clopack Company manufactures one product that goes through one processing department called Mixing. All raw materials are introduced at the start of work in the Mixing Department.

Standard costing, STANDARD COSTING STANDARD COSTING is a method, which ...

STANDARD COSTING STANDARD COSTING is a method, which uses standards for costs and revenues for the idea of control by variance analysis. It can be used either through operation

Estimate finished goods cost of goods sold , ln an attempt to conceal a the...

ln an attempt to conceal a thefi of funds, Kaito Kid, controller of Shinichi Products, lnc. placed a bomb in the company s record vault. The ensuing explosion left only fragments o

Cash flows statement , You have recently graduated from VU and are now work...

You have recently graduated from VU and are now working for a small accounting firm. The firm recently purchases MYOB software for internal use. Upon learning that you had learnt M

Gain on the sale of the discontinued operation, NSC Ltd. has a 31 May fisca...

NSC Ltd. has a 31 May fiscal year-end. NSC disposed of its Information Systems Group (ISG) on 31 January 20X3. ISG had a net loss (after taxes) of $37,700,000 in 20X3, to the date

Sunk costs, Which statement best describes a sunk cost? A a cost which is i...

Which statement best describes a sunk cost? A a cost which is irrelevant for the future B a cost which must be matched against the revenue C a cost which remains the same at all le

Define the marginal, Total profit means the total revenue excluding the tot...

Total profit means the total revenue excluding the total cost of the certain products. Average profit defines the profit which comes and achieved after selling each unit. Total

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

Calculate the total revenue, Mandy Building Contractors Ltd signed a fixed-...

Mandy Building Contractors Ltd signed a fixed-price contract to build a bridge for Nelly Ltd for $110 million on 1 July 2012.  Contract costs are estimated as follows:

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