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

Accounting case study, Accounting Case Study: The Champlain Career Con...

Accounting Case Study: The Champlain Career Consulting Corporation ("CCCC") is owned by three Trent graduates. Incorporated in 2009, CCCC provides a wide-range of career plann

Calculate the consumption ratios for each product, The activity driver for ...

The activity driver for the shipping activity is the number of orders shipped. Product A uses 20 orders and Product B uses 60 orders. Calculate the consumption ratios for each prod

What is a statement of cash flows, 1.What is a Statement of Cash Flows? How...

1.What is a Statement of Cash Flows? How does it differ from an Income Statement? 2.What unique information does the Statement of Cash Flows deliver to investors? Why do they care?

Prepare a direct material purchases budget., 1) The Svelte Jeans Company pr...

1) The Svelte Jeans Company produces two different types of jeans. One is called the "Simple Life" and the other is called the "Fancy Life". The company sales budget estimates that

Prepare of the final accounts of a business, You are assisting the accounta...

You are assisting the accountant on the preparation of the final accounts of a business with a year-end of 31 December. A trial balance has been drawn up and a suspense account ope

Purpose of cost accounting, what is the purpose of cost accounting and its ...

what is the purpose of cost accounting and its nat ure?

Determine cash flow statement, Download the financials of Shoprite , study ...

Download the financials of Shoprite , study them, then, using ratio analysis, the cash flow statement, and the segmental breakdown of the results, prepare a statement outlining the

Economic order quantity, #purchase price R45 order costs R175 lead time 6 d...

#purchase price R45 order costs R175 lead time 6 days cost of capital (after taxation) 20% direct inventory holding costs R25 annual demand 8500 units business operational 330day p

Bin card, I need an explanation of how a bin card is done

I need an explanation of how a bin card is done

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