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

Prepare a preliminary cost benefit analysis, Managers need financial inform...

Managers need financial information to help them make decisions, communicate important information about their organization, and demonstrate fiscal responsibility to stakeholders.

Budget Presentation for Management, 1) Please elaborate on the attached per...

1) Please elaborate on the attached performance report by preparing a presentation to "management" which incorporates the information presented in the performance report. Present t

First in first out or fifo, First in First Out or FIFO FIFO method is ...

First in First Out or FIFO FIFO method is based upon the assumption such stock purchased first is issued first. Prices of stock purchased first are employed to determine the v

Differential costing, DIFFERENTIAL COSTING Marginal costing is often co...

DIFFERENTIAL COSTING Marginal costing is often confused with differential costing. The word 'DIFFERENTIAL COSTING' means 'a technique used in the preparation of adhoc informati

Evaluate the expected earning, During his career in the energy industry, T-...

During his career in the energy industry, T-Bone McAdams has accumulated $5,000,000 in "surplus savings" that he is planning to donate to his college alma mater, Oklahoma A&M, in

Advantage and disadvantages of zero based budgeting, Advantage and Disadvan...

Advantage and Disadvantages of Zero Based Budgeting Advantages 1. Resources allocation is more efficient. 2. Focus attention on values for money and makes clear relat

Find the cost of equity of company, Outdoor Travel Inc. needs to estimate t...

Outdoor Travel Inc. needs to estimate the cost of capital for the evaluation of capital expenditures. A typical project is financed with 25% debt-to-value ratio (i.e., D/(D+E) =

Prepare an income statement for wadley''s car wash, Income Statement Prepar...

Income Statement Preparation The following information is taken from the records of Wadley's Car Wash for the year ended December 31, 2012. Income taxes . . . . . . . . . . .

The cost per complete unit, In a given period production and cost data were...

In a given period production and cost data were as follows:     Total Costs   Materials   Rs. 5,115                      Labour          3,952                     Overheads

Calculate the cash flow - capital cost, A company is evaluating the followi...

A company is evaluating the following lease or buy option.  A four year lease with annual payments of $25,000 payable at the beginning of the year. The tax shield is available a

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