1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Dahasolnce [82]
3 years ago
9

From the information given below construct a cash budget for five months period starting form May 20X1 till September. MONTH AND

YEAR PROJECTED SALES April 20X1 $ 140,000 May 20X1 130,000 June 20X1 90,000 July 20X1 65,000 August 20X1 84,000 September 20X1 95,000 October 20X1 160,000 November 20X1 200,000 December 20X1 240,000 January 20X2 190,000 Total payments 34,700 30,400 41,500 59,000 88,500 110,000 Additional information: a) Assume that minimum cash balance as $ 10,000 and same balance has to be maintained throughout the planning period. b) 100 % percent of sales are credit basis. 80 percent of the accounts receivables are collected in one month, 10 percent during the second month of sale, 5 percent during the second month of sale and remaining during the fourth month of sale.
Business
1 answer:
Alenkinab [10]3 years ago
4 0

Answer:

Cash Surplus  May   $83,300   June    $  61,600   July    $33,000  

Aug  $25,500        Sept $  3650

Explanation:

MONTH AND YEAR          PROJECTED SALES        FIRST MONTH      

                                                                                   COLLECTIONS (80%)

April 20X1                               $ 140,000                   112,000

May 20X1                                 130,000                      104,000

June 20X1                                90,000                        72,000

July 20X1                                  65,000                         52,000

August 20X1                            84,000                         67,200

September 20X1                      95,000                          76,000

October 20X1                          160,000                         128,000  

November 20X1                      200,000                        160,000

December 20X1                       240,000                       192,000

January 20X2                            190,000                      152,000  

<u><em>First we find the monthly cash collections 80 % in the month of sales , 10% in the second month , 5% in the third and 5 % in the fourth . We have summed them up in the following table.</em></u>

Sales Collections

                          MAY        JUNE      JULY        AUGUST         SEPT

Particulars

1st Month         104,000     72,000     52,000   67,000      76,000

Collections

2nd Month      14,000       13,000       9000      6500         8400

3rd Month                         7000         6500       4500         3250

<u>4th Month                                            7000      6500         4500</u>

Total

Collections       118,000      92,000    74,500    84,500      92,150

<u><em>Now we prepare the cash budget deducting payments from collections and maintaining beginning and ending balance.</em></u>

<u>Cash Budget</u>

                    <u>  MAY        JUNE      JULY        AUGUST         SEPT</u>

<em>Particulars</em>

Opening          10,000     10,000     10,000      10,000        10,000

Add Total

Collections       118,000      92,000    74,500    84,500      92,150

Less Closing    10,000        10,000       10,000      10,000      10,000

<u>Less Payments34,700        30,400     41,500      59,000       88,500 </u>

<u> Cash Surplus    83,300        61,600     33,000   25,500       3650</u>

<u />

You might be interested in
What are two examples of management information systems?
Anettt [7]

Answer:

process control systems, human resource management systems, sales and marketing systems, inventory control systems, office automation systems, enterprise resource planning systems, accounting and finance systems and management reporting systems.

Explanation:

8 0
3 years ago
Pes
lakkis [162]

Answer:

ushsj

Explanation:

bshshshhdshshshhshdbshjdjdkdjddjjdndndndnfnfkdk

8 0
3 years ago
a local pizza parlor is selling two different shapes of cheese pizza for the same price. You can get two small square pizza that
Mamont248 [21]

Answer:

The large round pizza with a 14 inch diameter

Explanation:

We can see this as a simple geometry problem. Which is the largest area? Two squares of 8 inches side or a 14 inch diameter circle? Let's see. The area of the square is side * side, in this case 8 * 8, so we have 64 squared inches  in each of the two pizzas. That makes a total of 128 squared inches (64 + 64) for the two small squared pizzas. Now to calculate the circle, we must do the following formula: \pi *r^{2} where r is the radium of the circle. The radium is half of the diameter, in this case 14/2=7. So the formula is 7^2, that is to say 49, multiplied by pi. This gives us approximately 153.93 squared inches, which is bigger than 128. A large round pizza with 14 inches of diameter gives more pizza.

We can also think that most people don't like the crust of the pizza. Two pizzas have more crust than one. So one pizza, besides being bigger, can save you to eat the crust and more cheese and sauce.

5 0
3 years ago
When borrowing money to purchase a new car, the LEAST expensive option would be to .... A. get a cash advance from their credit
djverab [1.8K]
I think the answer is C
6 0
4 years ago
Prepare Hertog Company’s journal entries to reflect the following transactions for the current year. May 7 Purchases 200 shares
Mrrafil [7]

Answer:

Explanation:

Prepare Hertog Company’s journal entries to reflect the following transactions for the current year.

1. May 7 Purchases 200 shares of Kraft stock as a short-term investment in trading securities at a cost of $50 per share plus $300 in broker fees.

Dr Short Term Investments..............................10,000

Dr Broker Fess..........................................................300

Cr. Cash.................................................................................10,300

<em>Being purchase of 200 shares of Kraft stock as a short-term investment in trading securities at a cost of $50 per share plus $300 in broker fees</em>

<em />

2. June 6 Sells 200 shares of its investment in Kraft stock at $56 per share. The broker’s commission on this sale is $150.

Dr Cash................................................................11,050

Dr Broker Fess........................................................150

Cr. Cash............................................................................10,000

Cr. Gain on Sale of Short-term investments..............1,200

Being Sale of 200 shares of its investment in Kraft stock at $56 per share. The broker’s commission on this sale is $150

4 0
3 years ago
Other questions:
  • Culture and Ethical Business PracticesThe business world is becoming increasingly global due to advances in technology and trave
    10·1 answer
  • One of the most common forms of segmenting consumer markets uses characteristics such as age, income, household size, and/or eth
    15·1 answer
  • It is a good idea to prepare for possible layoffs by making sure ______.
    15·2 answers
  • When direct labor employees contribute to the production process, the cost of their labor is recorded by debiting: O Wages Expen
    9·1 answer
  • Mark Weinstein has been working on an advanced technology in laser eye surgery. His technology will be available in the near ter
    10·1 answer
  • You have just deposited $8,500 into an account that promises to pay you an annual interest rate of 6 percent each year for the n
    9·1 answer
  • Highest and best use would best be defined as:
    10·2 answers
  • Industrialization is an important strategy in the fight against poverty. Which of the following is a benefit of an increase in t
    15·1 answer
  • Jhglijewbgijwebghrlfbejfrhfvhwrfh3vrhwrv344
    15·1 answer
  • Accourding to the quantity theory of money all countries with the same average annual rates of inlfation must also have the same
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!