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

Compute the equivalent units of production for materials, Clopack Company m...

Clopack Company manufactures one product that goes through one processing department called Mixing. All raw materials are introduced at the start of work in the Mixing Department.

Prepare a statement of cash flows, Bickering Ltd Income Stateme...

Bickering Ltd Income Statement for the year ended 30 June 2012   Sales (credit)                                                                           636,10

Estimate the growth rate of stock, Estimate the Growth rate of stock ...

Estimate the Growth rate of stock Data stock price = 53 rate of return= 12% expected dividend = 3.15 Formula : Expected return  = (dividend paid + capital

Balance sheet and assuming monthly amortization of patents, Nieland Industr...

Nieland Industries had one patent recorded on its books as of January 1, 2014. This patent had a book value of $288,000 and a remaining useful life of 8 years. During 2014, Nieland

the refuse department , The CFO of ABC Municipality has heard of activity ...

The CFO of ABC Municipality has heard of activity based costing and wants to execute it in the municipality. Because ABC involves a number of changes to how service costs are deter

Break-even chart, Break-Even Chart This is a diagrammatic presentation...

Break-Even Chart This is a diagrammatic presentation of the relationship among costs, prices, expenses and the sales volume. A break-even chart expresses revenue and expens

Choice of budget flexing basis, Choice of Budget Flexing Basis The mo...

Choice of Budget Flexing Basis The most suitable flexing basis must be considered where it assists in the comparison of alternative budget data at the planning stage and for

High - low method of cost estimation, High - Low Method of Cost Estimation ...

High - Low Method of Cost Estimation Now, cost estimation is based upon the relationship between past level and past cost of activity. Variable cost is based on the relationsh

calculate the percent interest rate and effective cost, 1. The following t...

1. The following three one-year "discount" loans are available toyou: Loan A: $120,000 at a 7 percent discount rate Loan B: $110,000 at a 6 percent discount rate Loan

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