Management accounting

problem
calculate a cash budget from following data for October to Decembers

sale purchases salaries

sept 40000 80000 25000
oct 120000 52500 30000
nov 70000 80000 300000
dec 12000 80000 300000

sale are collected 20% in cash same month and 80% credit of which half is same month half is next.
purchases are 100% credit paid one month later salaries are paid same month.
opening cash is 10000. Minimum balance is 10000
interest is 12% per annul. loans are made at the month.
loans are made and paid in rounded 1000

what is the closing cash balance

Tho' is the problem i am having i know how to do the sale but the purchase salaries i don't know can some on help me on this problem

1. 👍 0
2. 👎 0
3. 👁 86

Similar Questions

1. accounting

Prepare a monthly Cash Budget in tabular form for the months of February, March and April; showing the bank balance at each month's end. Company Information and Background The following data is available from the various

asked by Jasmine on July 24, 2012
2. Managerial Accounting

I have a homework problem that asks me to do the following: 1. Prepare a schedule of total cash collections for October through December. 2. Prepare a schedule of total cash disbursements for October through December. 3. Prepare a

asked by Jenn on October 6, 2014
3. principles of finances

according to my interpretation of the question in October they would collect: the 10% of the August sales = .10(\$10,000) the 20% of the Sept sales = .20(\$20,000) and the 70% of the Oct sales = .70(\$30,000) Do the arithmetic and

asked by Reiny on March 28, 2007
4. Finance

Assignment 1: LASA 2—Cash Management and Budgeting The new owner of Bob’s Boats, Bob, just purchased the business and discovered that the prior owner did not have a plan for managing the current assets of the company. Bob has

asked by Deanna on November 10, 2012
5. Acounting 202

Dokken & Dietrich’s Donut Company pays for 25% of its inventory purchases in the month of the purchase and the remainder in the following month. The company’s inventory purchases totaled \$840,000 in October, \$920,000 in

asked by merceda on March 22, 2007
6. accounting

You are provided with the following information for Pavey Inc. for the month ended October 31, 2008. Pavey uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price October 1 Beginning inventory 60

asked by RJ on March 15, 2009
7. math

Classic Furniture purchases dining room sets with an invoice date of September 27, and terms of sale of 3/10, n/60. What is the net date? A) October 17 B) October 22 C) November 2 D) November 26

asked by jo on December 14, 2014
8. managerial accounting

Werntz furniture had actual sales for July and august and forecasted sales for September, October, November and December as follows: Actual: July………………………………………………………….\$ 98,000

asked by mz nailz on October 17, 2011
9. accounting

Shower Sales Ltd sells plumbing fittings in a rapidly developing area. Its sales in June are \$500 000. From recent experience, the manager can confidently predict that sales will increase 10% each month cumulatively. 10% of sales

asked by MIchael on May 16, 2018
10. business

Lansing Auto Pats, Inc., has projected sales of \$25,000 in October , \$35,000 in November, and \$30,000 in December of the company’s sales 20 percent are paid for by cash and 80 percent are sold on credit. The credit sales are

asked by Andre on March 20, 2012

More Similar Questions