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

Determining working capital requirements, Understanding the existing capita...

Understanding the existing capital requirements and how these are financed will assist us in understanding the process of financing of business and the flow of funds inside the bus

Measuring performance in organization, list and discus the problem encounte...

list and discus the problem encountered in adopting profit as a yardstick in measuring performance

Direct material yield variance (myv), Direct material yield variance (MYV) ...

Direct material yield variance (MYV) :   It has been described by the ICMA, London, as 'the variation between the standard yield of the actual material input and the actual yi

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

Target profit and break even analysis, Lindon Company is the exclusive dist...

Lindon Company is the exclusive distributor for an automotive product that sells for $43 per unit and has a CM ratio of 35%. The company''s fixed expenses are $421,400 per year. Th

What amount of units, If fixed costs are $200,000 and the unit contribution...

If fixed costs are $200,000 and the unit contribution margin is $20, what amount of units must be sold in order to have a zero profit?

Contract costing, how to prepare contract account

how to prepare contract account

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

What is the amount of overhead applied, Morrow Company applies overhead bas...

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

Variable costs, Variable Costs Are costs such raise or fall proportio...

Variable Costs Are costs such raise or fall proportionately along with the level of activity that is such portion of the cost of an activity which changes along with the leve

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