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

Closing stock, The value of un-sold stock. The stock is valued at cost or m...

The value of un-sold stock. The stock is valued at cost or market price either is lower. Usually, the closing stock is not specified in the trial balance but is specified in adjust

Absorption costing, What is an advantage of using absorption costing? A....

What is an advantage of using absorption costing? A. It permits a business to calculate the break-even point for production. B. It permits a business to calculate the total c

Inventory valuation, How the FIFO, LIFO and AW problems can be solved?

How the FIFO, LIFO and AW problems can be solved?

Determine investment allocation that maximises expect npv, Suppose that $4 ...

Suppose that $4 million is available for investment in three projects.  The probability distribution of the net present value earned from each project depends on how much is invest

What is the margin of safety, Apollo Company manufactures a single product ...

Apollo Company manufactures a single product that sells for $168 per unit and whose total variable costs are $126 per unit. The company's annual fixed costs are $630,000. (1) Use t

Overhead costs, Overhead Costs Introduction Overhead costs may be...

Overhead Costs Introduction Overhead costs may be defined like the net cost of indirect materials, indirect expenses and indirect labour. They may happen or be charged to

Marginal costing and break evan point analysis, what is marginal costing an...

what is marginal costing and explain concept of marginal costing

Cost components, Cost Components Companies which manufacture a product ...

Cost Components Companies which manufacture a product face an elaborated set of accounting issues. Additionally the usual accounting matters related with selling and administra

ECONOMICS, #ques Case Study Electron Control, Inc., sells volt...

#ques Case Study Electron Control, Inc., sells voltage regulators to other manufacturers, who then customize and distribute the products to quality assurance labs for

introduction of internal rate of return , Introduction of Internal Rate of...

Introduction of Internal Rate of Return The traditional internal rate of return (IRR) method of project selection has been shown to be inferior to the NPV method due to vario

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