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

Sgtatement of Cash Flow, “The statement of cash flows is the easiest of the...

“The statement of cash flows is the easiest of the basic financial statements to prepare because you know the answer before you start. You compare the beginning and ending balances

Calculate the dead weight loss of the tariff, (a) Calculate Mexico's produc...

(a) Calculate Mexico's producer surplus and consumer surplus in autarky. (b) Calculate the number of Mexican imports with as well as without the Tarriff. (c) Calculate Mexico

Limitations of cvp analysis, Limitations of CVP Analysis The make use ...

Limitations of CVP Analysis The make use of the basic CVP model is just only relevant to planning and decision-making in an activity range whether the basic cost and revenue b

Homework, i need help on my homework

i need help on my homework

Prepare a flexible overhead budget, Under a contract with the provincial go...

Under a contract with the provincial government, ChemLabs Inc. analyzes the chemical and bacterial composition of well water in various municipalities in the interior of British Co

Prepare an eps summary for income statement, You are thinking of investing ...

You are thinking of investing in one of two corporations, both in the same industry, the XYZ Corporation or the ABC Corporation. Selected data follows: Sales data for the year e

Cost sheet, what is a cost sheet? what are its advantages?

what is a cost sheet? what are its advantages?

Visual fit method of cost estimation, Visual Fit Method of Cost Estimation ...

Visual Fit Method of Cost Estimation Cost estimation is based on past data regarding the dependent variable and the cost driver. The previous data on cost levels and the outpu

Determine the expected range of returns , Series Arithmetic Mean ...

Series Arithmetic Mean Standard Deviation   Small-company stocks 15.9  % 32.8  %   Large-company

Master budget framework, Master Budget Framework The master budget is ...

Master Budget Framework The master budget is the overall quantifications of the budgeting plan. In this, functional budgets are not corporate. A functional budget is a budget

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