• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Free ACCA & CIMA online courses from OpenTuition

Free ACCA & CIMA online courses from OpenTuition

Free Notes, Lectures, Tests and Forums for ACCA and CIMA exams

  • ACCA
  • CIMA
  • FIA
  • OBU
  • Books
  • Forums
  • Ask AI
  • Search
  • Register
  • Login
  • ACCA Forums
  • Ask ACCA Tutor
  • CIMA Forums
  • Ask CIMA Tutor
  • FIA
  • OBU
  • Buy/Sell Books
  • All Forums
  • Latest Topics

20% off ACCA & CIMA Books

OpenTuition recommends the new interactive BPP books for March and June 2025 exams.
Get your discount code >>

Full cash flow forecast

Forums › Ask ACCA Tutor Forums › Ask the Tutor ACCA FM Exams › Full cash flow forecast

  • This topic has 0 replies, 1 voice, and was last updated 6 years ago by luncia1.
Viewing 1 post (of 1 total)
  • Author
    Posts
  • January 8, 2019 at 5:52 am #500325
    luncia1
    Member
    • Topics: 13
    • Replies: 5
    • ☆

    Hello sir

    I am stuck with this question relating to cash forecast from Kaplan study text,

    In the near future a company will purchase a manufacturing business for
    $315,000, this price to include goodwill ($150,000), equipment and
    fittings ($120,000), and inventory of raw materials and finished goods
    ($45,000).
    A delivery van will be purchased for $15,000 as soon as the business
    purchase is completed. The delivery van will be paid for in the second
    month of operations.
    The following forecasts have been made for the business following
    purchase:
    (i) Sales (before discounts) of the business’s single product, at a mark-
    up of 60% on production cost will be:
    Month 1 2 3 4 5 6
    ($000) 96 96 92 96 100 104
    25% of sales will be for cash; the remainder will be on credit, for
    settlement in the month following that of sale. A discount of 10% will be
    given to selected credit customers, who represent 25% of gross sales.
    (ii) Production cost will be $5 per unit. The production cost will be made
    up of:
    Raw materials $2.50
    Direct labour $1.50
    Fixed overhead $1.00
    (iii) Production will be arranged so that closing inventory at the end of
    any month is sufficient to meet sales requirements in the following
    month. A value of $30,000 is placed on the inventory of finished
    goods, which was acquired on purchase of the business. This
    valuation is based on the forecast of production cost per unit given
    in (ii) above.
    (iv) The single raw material will be purchased so that inventory at the
    end of a month is sufficient to meet half of the following month’s
    production requirements. Raw material inventory acquired on
    purchase of the business ($15,000) is valued at the cost per unit
    that is forecast as given in (ii) above. Raw materials will be
    purchased on one month’s credit.
    (v) Costs of direct labour will be met as they are incurred in production.
    (vi) The fixed production overhead rate of $1.00 per unit is based upon
    a forecast of the first year’s production of 150,000 units. This rate
    includes depreciation of equipment and fittings on a straight-line
    basis over the next five years. Fixed production overhead is paid in
    the month incurred.
    (vii) Selling and administration overheads are all fixed, and will be
    $208,000 in the first year. These overheads include depreciation of
    the delivery van at 30% pa on a reducing balance basis. All fixed
    overheads will be incurred on a regular basis, and paid in the month
    incurred, with the exception of rent and rates. $25,000 is payable for
    the year ahead in month one for rent and rates.
    Required:
    (a) Prepare a monthly cash flow forecast. You should include the
    business purchase and the first four months of operations following
    purchase.
    (b) Calculate the inventory, receivables, and payables balances at the
    end of the four-month period. Comment briefly upon the liquidity
    situation.

    In the question they haven’t mentioned anything about the time period to be considered for calculating sales units. But the working note gives the following figures
    Sales units
    12k for 1 month, 12k for 2nd month, 11.5k for 3rd month, 12k for 4 month,12.5k for 5th month & 13k for 6th month.
    So I don’t understand how these figures are been derived to calculate production units.

  • Author
    Posts
Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.
Log In

Primary Sidebar

Donate
If you have benefited from our materials, please donate

ACCA News:

ACCA My Exam Performance for non-variant

Applied Skills exams is available NOW

ACCA Options:  “Read the Mind of the Marker” articles

Subscribe to ACCA’s Student Accountant Direct

ACCA CBE 2025 Exams

How was your exam, and what was the exam result?

BT CBE exam was.. | MA CBE exam was..
FA CBE exam was.. | LW CBE exam was..

Donate

If you have benefited from OpenTuition please donate.

PQ Magazine

Latest Comments

  • thienan0110 on Interest rate risk management (1) Part 5 – ACCA (AFM) lectures
  • Venoth on Time Series Analysis – ACCA Management Accounting (MA)
  • mrjonbain on Professionalism, ethical codes and the public interest – ACCA Strategic Business Leader (SBL)
  • mrjonbain on Professionalism, ethical codes and the public interest – ACCA Strategic Business Leader (SBL)
  • kemo1000 on Financial instruments – convertible debentures – ACCA Financial Reporting (FR)

Copyright © 2025 · Support · Contact · Advertising · OpenLicense · About · Sitemap · Comments · Log in