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

Sales budget, Sales Budget It provides volume of sales and sales mix o...

Sales Budget It provides volume of sales and sales mix of the recent operations. The sales forecast is initially prepared and upon completion the sales budget is finalized. Th

Find the cost of equity of company, Outdoor Travel Inc. needs to estimate t...

Outdoor Travel Inc. needs to estimate the cost of capital for the evaluation of capital expenditures. A typical project is financed with 25% debt-to-value ratio (i.e., D/(D+E) =

Prepare the franking account, XYZ Pvt Ltd is a private company incorporated...

XYZ Pvt Ltd is a private company incorporated in Australia, and manufactures handbags. The opening balance of XYZ Pvt Ltd's franking account on 1 July 2010 was $nil. During the 201

Estimate the initial after-tax cash outlay, Shubenacadie Inc. is currently ...

Shubenacadie Inc. is currently considering a project with a 5-year life that it believes has the potential to return the company to profitability. Based on the results from a marke

allocation of cost, looking for a dissertation of cost allocatio

looking for a dissertation of cost allocation

Overhead- classification;apportionment and absorption, metods of absorption...

metods of absorption of manufecturing overhead

Opportunity costs are relevant costs, Opportunity Costs Are Relevant Costs ...

Opportunity Costs Are Relevant Costs Opportunity cost introduces an additional concept that is not available like part of normal cost analysis in the accounting record system.

Marginal costing vs direct costing, MARGINAL COSTING Vs DIRECT COSTING ...

MARGINAL COSTING Vs DIRECT COSTING Direct costing is the method where only direct costs are measured while calculating the cost of the product. Indirect costs are met in opposi

Reconciliation of profits, Reconciliation of Profits Reconciliation of...

Reconciliation of Profits Reconciliation of profits disclosed by Financial Accounts and Costing Accounts in an interlocking system, While interlocking cost accounting system

Mini Report about Brand Image, Write a mini report in which you "Critically...

Write a mini report in which you "Critically Describe, Aanlyse and Reflect on the Brand Image Extension.  This task must include evidence of collection primary data on the same

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: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd