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

Illustration of overhead variance analysis, Illustration of Overhead Varian...

Illustration of Overhead Variance Analysis Again for intentions of our demonstrations in overhead variance analysis, we will suppose the given basic data for company in the pr

What was the cost of raw materials, Raw Materials: Manufacturing Overhead B...

Raw Materials: Manufacturing Overhead Bal 1/1: 36,000 Credits: ? Debits: 383,000 Credits: ? Debits: 470,000 Bal: 12/3: 156,000 Work in Process: Bal 1/1: 73,000 Credits: 770,000

What is the overhead variance, Morrow Company applies overhead based on dir...

Morrow Company applies overhead based on direct labor hours. At the beginning of the year, Morrow estimates overhead to be $620,000, machine hours to be 180,000, and direct labor h

Explain stock valuation, G. Mills was appointed a local agent for the High ...

G. Mills was appointed a local agent for the High Power Mobile Workshop Bolt (HPMW-B) on 1 April 2009. The HPMW-B is manufactured by Mobile Equipment Ltd (MEL). The company charges

Explain development cost, With the introduction of computer-generated anima...

With the introduction of computer-generated animated films (CGI), there has been much discussion of the impact on the movie industry. For example, illustrators need to have differe

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) =

Compute the total amount of current assets, Balance Sheet Classi?cations an...

Balance Sheet Classi?cations and Relationships: Shelley and Co. has the following balance sheet elements as of December 31, 2012. Land. . . . . . . . . . . . . . . . . . . . . .

Job-order costing, Division B uses  normal  costing in its job-order costin...

Division B uses  normal  costing in its job-order costing system, with manufacturing overhead  applied  based on direct labour hours.  You have obtained the following information a

Use account analysis to determine fixed cost, Reef Office Supplies is inter...

Reef Office Supplies is interested in estimating the cost involved in hiring new employees. The following information is available regarding the costs of operating the Human Resour

How much are your fixed costs, 1.    The following table summarizes the sho...

1.    The following table summarizes the short-run production function for your firm. Your product sells for $5 per unit, labor costs $5 per unit, and the rental price of capital i

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: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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