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

Cost data determination, Cost Data Determination How does one decide th...

Cost Data Determination How does one decide the cost data for products and the services which are the end result of the productive processes? The response to this question is m

Mr, Extracts from P Co''s records for last month are as follows: ...

Extracts from P Co''s records for last month are as follows: BUDGET ACTUAL PRODUCTION 7,000 UNITS 7,200 UNITS Direct Material $42,000 $42,912 Calculate

Marginal cost curves, A firm operates two plants with the marginal cost cur...

A firm operates two plants with the marginal cost curves given by MC 1 = 50 + 2Q 1 , MC 2 = 90 + Q 2 . If the firm's total output must be 80 units, how much will it produce a

Evaluate the balance in the patent account, Banana Corporation had the foll...

Banana Corporation had the following transactions relating to a patent: January 1, 2010: Purchased patent for $2,000,000. The patent had fifteen years remainnig although Banan

Calculate the payback period and the accounting rate, Freshly Ground Invest...

Freshly Ground Investments have just made an investment of $550 000 in a new Toyota Hilux (with trailer) delivery vehicle. This vehicle will be used for deliveries and generate rev

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

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

Uniform Capitalization rules, Are public service corporations subject to un...

Are public service corporations subject to uniform capitalization rules?

Sensitivity analysis, Sensitivity Analysis The only certain thing is th...

Sensitivity Analysis The only certain thing is that nothing is sure thing. Cost structures can be anticipated to vary over the time period. Management should vigilantly analyze

What will the bond sell, A 20-year bond pays a coupon of 8 percent per year...

A 20-year bond pays a coupon of 8 percent per year (coupon paid semi-annually). The bond has a par value of $1000. What will the bond sell for if the nominal YTM is: a) 10 per

Provision for bad and doubtful debts, A provision must be made in advance f...

A provision must be made in advance for those debts whose recovery is uncertain and to writing off bad debts. Each enterprise, depends on their past experience, make a provision fo

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