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

Determine how much to stock, Determine how much to stock 1. Employ The...

Determine how much to stock 1. Employ The Economic Order Quantity Model This is an easiest model which helps the manager to find out the optimum quantity of stock to order

What is the original cost of the auto?, I'm having a hard time with this, c...

I'm having a hard time with this, can you please help? I know the dates are imparative also in finding the solution. Stevens purchased an auto on Jan 1, 2001. On December 31, 2003

Difference between balance sheet and income statement, (i) Describe the di...

(i) Describe the difference between the balance sheet and the income statement in financial statements of companies. (ii) Give two examples of intangible assets and two exampl

Standard costing and variance analysis using kaizen costing, Discuss how SD...

Discuss how SD can use standard costing and variance analysis to prepare meaningful reports when using Kaizen Costing. By the use of standard costing and variance analysis, fr

Prepare the amortization schedule, Logan Corporation issued $800,000 of 8% ...

Logan Corporation issued $800,000 of 8% bonds on October 1, 2006, due on October 1, 2011. The interest is to be paid twice a year on April 1 and October 1. The bonds were sold to y

Differential analysis, West Industries is a highly decentralized corporatio...

West Industries is a highly decentralized corporation with independent operating divisions. Each division is evaluated and rewarded based on its total net income. One of the divisi

Calculate the variable overhead efficiency variance, Questions 8-10 rely on...

Questions 8-10 rely on the following data. FrontGrade Systems allocates manufacturing over- head based on machine hours. Each connector should require 11 machine hours. According t

Government and nonprofit accounting, I need project help in Government and ...

I need project help in Government and nonprofit accounting, can you help me in look out this problems?

Compute the industry volume variance for each product, The next year's budg...

The next year's budget for Benny, Inc., is given below: Product 1-2 Sales $945,000-688500 Variable costs 459,900-297,000 Fixed costs 300,000-3

prepare a simple balance sheet, Assume that Banc One receives a primary de...

Assume that Banc One receives a primary deposit of $1 million. The bank must keep reserves of 20 percent against its deposits. Prepare a simple balance sheet of assets and liabilit

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