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

Cvp and computer applications, CVP and Computer Applications The broad...

CVP and Computer Applications The broad availability of personal computers encourages more managers to apply cost volume profit analysis. Computers can quickly create the comp

Long - term capital loss, The Smiths have a long-term capital loss carryove...

The Smiths have a long-term capital loss carryover of $10,000 from 2010. On May 9, 2007, David's uncle, Joe, gave him the family antique gun collection. Based on family records

Calculate average cost to manufacture, Sony manufactures battery for Iphone...

Sony manufactures battery for Iphone 6+. The average costs to manufacture batteries are $4 for 10,000 ad $2.67 for 30,000. Assuming the total cost function is linear, what will be

Wages department, Wages Department It is accountable for the preparati...

Wages Department It is accountable for the preparation of the payroll and the payment of wages. The routine will need: a) Analysis of clock cards and verify of overtime aut

Calculate the current stock price, The Bloomington Electric Company operate...

The Bloomington Electric Company operates in a stable industry and therefore has predictable dividend growth of 8% per year. The most recent annual dividend was paid yesterday in t

Abnormal loss account and abnormal gain account, A product is manufactured ...

A product is manufactured by passing through three processes: A, B and C. In process C a by-product is also produced which is then transferred to process D where it is completed. F

Inventory systems, Find a journal article online about just-in-time invento...

Find a journal article online about just-in-time inventory systems. In the subject line of your post, include the title of the article that you read. Post a link to that article wi

Using the dupont formula for rate of return on investment, The vice preside...

The vice president of operations of six layer computer Inc. is evaluating the performance of two divisions organized as investments centers. Invested assets and condensed income st

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