Wages and salaries, Cost Accounting

Assignment Help:

Given the information that follows, prepare a cash budget for the XYZ Store for the first six months of 2010.

  • All prices and costs remain constant.
  • Sales are 90% for credit and 10% for cash.
  • With respect to credit sales, 70% are collected in the month after the sale, 20% in the second month, and 10% in the third. Bad-debt losses are insignificant.
  • Sales, actual and estimated, are:

October 2009         $200,000        March 2010        $220,000
November 2009      350,000        April 2010          300,000
December 2009      300,000        May 2010          280,000
January 2010         150,000        June 2010          240,000
February 2010        250,000        July 2010          320,000

  • Payments for purchases of merchandise are 80% of the following month's anticipated sales.
  • Wages and salaries are:

January 2010        $45,000            April 2010          $55,000
February 2010        40,000            May 2010            60,000
March 2010            50,000            June 2010            57,000

 

  • Rent is $6,000 a month.
  • Interest of $9,500 is due on the last day of each calendar quarter, and no quarterly cash dividends are planned.
  • A tax prepayment of $70,000 for 2010 income is due in April.
  • A capital investment of $80,000 is planned in June, to be paid for then.
  • The company has a cash balance of $80,000 at December 31, 2009, which is the minimum desired level for cash. Funds can be borrowed in multiples of $5,000. (Ignore interest on such borrowings.)

 


Related Discussions:- Wages and salaries

Uniform costing, Uniform Costing It is a general system utilizing agre...

Uniform Costing It is a general system utilizing agreed concepts, standard and principles accounting practices adopted via different entities in the similar industry to ensure

Find the amount capitalized for the patent account, Gomez incurred $350,000...

Gomez incurred $350,000 of research and development costs to develop a product for which a patent was granted on January 2, 2008. Legal fees and other costs associated with the re

Evaluate equivalent annual cost, An industrial drill costs $60.000 to purch...

An industrial drill costs $60.000 to purchase and $10,000 to install seven years ago. The market value now is $33.000 and this will decline by 12% of current value each year for th

Prepare trial balance for transactions, Encik Farid, a sole trader, started...

Encik Farid, a sole trader, started his business on 1 May 2010 under the name Farid Enterprise. The following are his business transactions for the month of May a. Encik Farid b

Limitations of cvp analysis, Limitations of CVP Analysis The make use ...

Limitations of CVP Analysis The make use of the basic CVP model is just only relevant to planning and decision-making in an activity range whether the basic cost and revenue b

Calculate the capital account balance, You are given the following informat...

You are given the following information about a sole trader as at 1 January 2012: The value of assets and liabilities were: Non-current assets at net book value £16,800

Standard cost card, Standard Cost Card It is a card record of the Stan...

Standard Cost Card It is a card record of the Standard or expected costs in producing a specified output.  This gives the physical quantities of inputs and also their monetary

Gains and losses on disposal, When assets are replaced during the anticipat...

When assets are replaced during the anticipated life of the project, or at the end of the anticipated life of the project, they are sold at their pre-determined scrap values. Incom

Determine the direct materials cost variance, Question P A RT A ...

Question P A RT A Borrico ltd manufacture a single product and they had currently introduced a system of budgeting and variance analysis. The subsequent information i

Ledger accounting system, Q. Is it possible to execute fca in the deficienc...

Q. Is it possible to execute fca in the deficiency of a general ledger accounting system ? Ans. Yes. FCA can be executed for whichever solid waste management system and whi

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