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
Artemon [7]
3 years ago
7

Alpha Ltd has appointed you as a manager in the budgeting department. The company has provided the following information to prep

are a cash flow budget for the six months from the 1 January 2021 to 30 June 2021.
i. Alpha Ltd produces only one type of product and the projected selling price of the product is £2 for January and February and after that will be fixed at £3 for the foreseeable future.
ii. For the first three months of the year, 2,000 units will be sold per month. For the following three months, 2,500 units will be sold per month. Sales income is to be received in the month of sale.
iii. Insurance costs are £200 every two months. The company will pay for insurance on 1 December 2020.
iv. The company is paying 20% of sales of each month as bonus to the employees in the following month. The total sales during December 2020 will be £5,000.
v. Alpha Ltd will pay overhead costs of £2,000 each month.
vi. The opening cash balance at 1 January 2021 will be £1,000.
vii. The monthly cost of direct material and direct labour is estimated to be £500 and the company will pay them during each month.
viii. Fixed costs of production are £100 per month, payable in the month.

Required:
Prepare a cash flow budget for the period 1 January 2021 to 30 June 2021 and indicate the closing balance as at 30 June 2021.​
Business
1 answer:
nasty-shy [4]3 years ago
3 0

Answer and Explanation:

The preparation of the cash flow budget is presented below:

                                   Cash Flow Budget

Particulars    Jan 2021      Feb 2021 Mar 2021      Apr 2021 May 2021      Jun 2021

Opening Balance $1,000 $1,400 $2,000 $4,600 $8,300 $11,700

Sales        $4,000          $4000 $6,000      $7,500  $7,500  $7,500

   (2,000 ×  2)         (2,000 ×  2)       (2,000 ×  3)    (2,500 ×  3)  (2,500 ×  3)  (2,500 ×  3)

Total Cash Inflow  $5,000 $5,400 $8,000 $12,100 $15,800 $19,200

Less: Cash payments

Less: Bonus to employees $1,000 $800     $800   $800   $1,500 $1,500

(5,000 × 20% )   (4,000 × 20% )   (4,000 × 20% )  (4,000 × 20% )  (7,500 × 20% )   (7,500 × 20% )

Less: Overhead Cost 2,000 2,000 2,000 2,000 2,000 2,000  

Less: Direct material & Direct Labor 500      500    500    500   500 500  

Less: Fixed Cost 100 100 100 100 100 100  

Net cash generated  (A) 400  600  600  4100  3400  3400  

Opening Cash balance (B)  1000  1400  2000  2600  6700  10100  

Closing Balance (A+B)  1400 2000 4600 8300 11700 15100

Balance as on 30 June 2021 = 15100

We simply deduct all cash payments from the all cash receipts so that the ending balance or closing balance could come

You might be interested in
Companies facing the challenge of setting prices for the first itme can choose between two board strategies; marketing-penetrati
Alika [10]

The correct question should be:

Companies facing the challenge of setting prices for the first time can choose between two board strategies; marketing-penetration pricing and _______ pricing.

Answer: Market Skimming pricing.

Explanation:

A company with a product new to the market can either choose to use the market penetration pricing or the market skimming pricing.

The market penetration pricing works best in a market with a lot of competition. The penetration pricing is a kind of pricing a company uses where the price of it's Products are set to be very low to attract price-sensitive consumers and still make profit.

The market skimming pricing on the other hand is a price setting method where a high entry price is set for a new product and then subsequently reduced with increase in market competition.

5 0
4 years ago
Taxes on the purchase of specific items such as gasoline, cigarettes, or alcoholic beverages are called _____ taxes.
marishachu [46]

Answer:

<em>Taxes on the purchase of specific items such as gasoline, cigarettes, or alcoholic beverages are called </em><em><u>excise</u></em><em> taxes.</em>

7 0
3 years ago
Beginning at point d if you were planning to purchase the good next week and the price would triple what new point would you mov
monitta

Answer:

Whazup

Explanation:

7 0
3 years ago
The custodian of a $450 petty cash fund discovers that the fund has $65 in coins and currency plus $382 in receipts at the end o
Mandarinka [93]

The entry to replenish the petty cash fund will include a credit to cash for $385.

What is petty cash fund?

When regular purchasing techniques are impractical, such as when buying office supplies or paying employees, a tiny sum of money called petty cash is utilized instead.

The entry to replenish the petty cash fund amount will include:

Fund amount : $450 - Used

Fund amount  :$450 - $382 = 68

cash on hand - remaining ; $68 - $65 = $3

Used + remaining ; $382 + $65 = 385

As a result, a credit to cash for $385.

Learn more about on petty cash fund, here:

brainly.com/question/23864192

#SPJ1

8 0
1 year ago
The internal rate of return (IRR) refers to the compound annual rate of return that a project generates based on its up-front co
Sav [38]

Answer:

The answer and procedures of the exercise are attached in the following archives.

Explanation:

Consider this explanation too

The IRR is the project’s expected rate of return, assuming that intermediate cash flows also earn the IRR. If this return exceeds the cost of the capital invested in the project, the excess value goes to the firm’s shareholders. Therefore, independent projects whose IRR is greater than the WACC should be accepted.

Therefore in this case WACC of the project is 7% and IRR of the project is 1.86% which is less than WACC of the project. Hence the firm reject the project delta.

Calculation of IRR is based on Cash inflows and outflows for the number of years so that increase in cost of capital will not affect IRR.

5 0
3 years ago
Other questions:
  • In attempting to become financially organized a person must ?
    8·1 answer
  • 2. An electronics manufacturing firm is currently manufacturing resistors that have a variable cost of $0.50 per unit and a sell
    15·1 answer
  • Sheridan Company prepared a 2019 budget for 150000 units of product. Actual production in 2019 was 175000 units. To be most usef
    5·1 answer
  • XYZ Company is in the process of issuing bonds. The bonds have a stated interest rate of 4%, which is 2% below the current marke
    6·1 answer
  • A decline in total real output for two or more consecutive quarters is referred to as
    13·1 answer
  • Andy has been working at Aerial Corp. for a long time. He feels he is hard working and that he deserves a pay hike. He seeks a m
    5·2 answers
  • What evidence indicated throughout the 1920s that the economy was not as healthy as most believed? why weren’t these weaknesses
    7·1 answer
  • The Laffer curve shows that Group of answer choices at some specific tax rate, tax revenue is maximized. tax revenue is constant
    14·1 answer
  • Talia, Shemp and Lola formed a corporation under the name Dependable Health Solutions, Inc., and advertise their services nation
    5·1 answer
  • A supervisor asks the HR manager for advice on delivering performance feedback. The supervisor finds that the meetings tend to b
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!