• 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 September 2025 exams.
Get your discount code >>

LSBF – Dec 2018 Mock – Rolling budget question

Forums › Ask ACCA Tutor Forums › Ask the Tutor ACCA PM Exams › LSBF – Dec 2018 Mock – Rolling budget question

  • This topic has 1 reply, 2 voices, and was last updated 6 years ago by John Moffat.
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • June 2, 2019 at 9:05 pm #518443
    Maria
    Member
    • Topics: 1
    • Replies: 1
    • ☆

    I absolutely can not get the clue from the model answer….

    Q2 (Sec B):
    Rolling Co is a company selling consumer goods. They have historically used a fixed annual budgeting process. The company operates in a volatile market where it is very difficult to give accurate estimates of sales volumes or costs. The new finance director has proposed the introduction of rolling budgeting to ensure that the targets set in budgets are more realistic. The original fixed budget for the year ended 31 July 20X8, for which the first quarter (Q1) has just ended, is shown below:

    Q1 Q2 Q3 Q4
    Revenue 25,463 26,227 27,014 27,824
    CoS -11,111 -11,444 -11,788 -12,141
    GP 14,352 14,783 15,226 15,683
    Distribution -1,782.4 -1,835.9 -1,891 -1,947.7
    Admin -2,475 -2,475 -2,475 -2,475
    Net Pr 10,095 10,472 10,860 11,260

    The budget was based on the following assumptions:
    Sales volumes would grow by a fixed compound percentage each quarter.
    Gross profit margin will remain stable each quarter.
    Distributions would remain a fixed percentage of revenue each quarter.
    Administration costs would be fixed each quarter.
    The actual results for the first quarter (Q1) have just been produced and are as follows:

    Revenue 27,500
    CoS -11,250
    GP 16,250
    Distrib -1,925
    Admin -2,505
    Profit 11,820

    Q1. What is the compound rate of growth of sales and what percentage is distribution cost of sales?
    Growth rate of sales is ___%
    Distribution cost is ___% of sales

    Q2. If Rolling Co implements rolling budgeting what would be the gross profit figure in quarter 3?

    Q3. If Rolling Co implements rolling budgeting what would be the net profit figure in quarter 4?

    LSBF answers:

    Q1: Growth rate of sales is 3%.
    Distribution cost is 7% of sales.

    Q2: GP = 16 907 (= 16 250 * 1.02 * 1.02)

    Q3: 13 280 (= 16 250 * 1.02^3 – 27,500 * 1.02^3*5%-2,505)

    I absolutely do not understand how they got 2% for sales growth in Q2 and 5% for distribution costs, if in Q1 it is 3% and 7% (derived from initial budget)

    June 3, 2019 at 8:10 am #518489
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54699
    • ☆☆☆☆☆

    Sorry, but I can’t see where they have got their figures from either.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 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

  • darshan.69 on Chapter 9 Pension Schemes TX-UK FA2023
  • darshan.69 on Chapter 9 Pension Schemes TX-UK FA2023
  • Jarzin on The Finance Function in the Digital Age – CIMA E1
  • dkessilfie on FM Chapter 1 Questions – Financial management objectives
  • ahmadhoney on ACCA Advanced Audit and Assurance (AAA) The Audit Report 3: Types of Audit Report

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