Skip to content
knowsia logo
  • Home
  • Programs
    • Student Dashboard
    • Professional Tuition
    • Webinars and CPDs
    • Certificate Courses
    • All Courses
  • Question Bank
    • Past Questions
    • Case Studies
    • Study Questions
    • QB Pricing
  • Community
  • Blog
  • About
  • My Account
  • Home
  • Programs
    • Student Dashboard
    • Professional Tuition
    • Webinars and CPDs
    • Certificate Courses
    • All Courses
  • Question Bank
    • Past Questions
    • Case Studies
    • Study Questions
    • QB Pricing
  • Community
  • Blog
  • About
  • My Account
knowsia logo
  • Home
  • Programs
    • Student Dashboard
    • Professional Tuition
    • Webinars and CPDs
    • Certificate Courses
    • All Courses
  • Question Bank
    • Past Questions
    • Case Studies
    • Study Questions
    • QB Pricing
  • Community
  • Blog
  • About
  • My Account
  • Home
  • Programs
    • Student Dashboard
    • Professional Tuition
    • Webinars and CPDs
    • Certificate Courses
    • All Courses
  • Question Bank
    • Past Questions
    • Case Studies
    • Study Questions
    • QB Pricing
  • Community
  • Blog
  • About
  • My Account
  • 20 Marks

MI – May 2025 – F – Q2 – Cost Classifications

List and explain four methods of separating fixed and variable costs, and prepare cost estimates for July to December using given data.

  • ICA (Nigeria)
  • PROFESSIONAL PROGRAM
  • MANAGEMENT INFORMATION
Question

a. List and explain briefly FOUR methods of separating fixed and variable costs (8 Marks)

b. The following information was extracted from the record of XYZ LTD Month Actual Production (Units) Actual Cost (₦) Month Budgeted Production (Units) January 4500 1,500,000 July 4800 February 2700 1,050,000 August 3200 March 6500 2,075,000 September 6000 April 5000 1,625,000 October 6600 May 8000 2,450,000 November 8200 June 5500 1,825,000 December 5800 Fixed costs increase by 20% when production is above 5,000 units. (12 Marks)

Required: Prepare the cost estimate for the period July to December.

Answer

The following are cost estimation methods:

 a.

  1. Engineering method
  2. Account analysis method
  3. Scatter Graph Method
  4. High-Low method
  5. Least-Squares method

 

  1. Engineering method: The engineering method is based on the use of engineering analysis of technological relationships between inputs and outputs – for example methods study, work sampling and time motion studies. The approach is appropriate when there is a physical relationship between costs and the cost driver. This study is to make an analysis based on direct observations of the underlying physical quantities required for an activity and then convert the results into cost estimates.
  2. Accounts analysis method: This method requires an inspection of each item of expenditure within the accounts for a particular period and then classify each item of expense as a wholly fixed, wholly variable or a semi-variable cost.
  3. Scatter Graph method: This method involves plotting on a graph, the total costs for each activity level. The total cost is represented on the vertical (Y axis) and the activity levels are recorded on the horizontal (X axis). A straight line is fitted to the scatter of plotted points by visual approximation. 20

16 * * 12 * * * 8 * * * 4 * * * 0 * * 5 10 15 20 25 30 Example of a scatter graph

4. High-Low method: The high-low method consists of selecting the periods of highest and lowest activity levels; and comparing the changes in costs that result from the two levels. The fixed cost can be estimated at any level of activity (assuming a constant unit variable cost) by subtracting the variable cost portion from the total cost.

5. The Least-Squares method: This method determines mathematically, the regression line of best fit. It is based on the principle that the sum of the squares of the vertical deviations from the line that is established using the method is less than the sum of the squares of the vertical deviations from any other line that might be drawn.

b.

Units Cost Low level of production 2,700 1,050,000 High level of production 5,000 1,625,000 Difference 2,300 575,000 Variable cost 575,000/2300 = 250 Fixed cost 1,050,000 – (2700 x 250) = 375,000 Fixed cost with 20% increase 375,000 + (375,000 x 20%) = 450,000

July August September October November December Production (units) 4,800 3,200 6,000 6,600 8,200 5,800 Variable cost (N) 1,200,000 800,000 1,500,000 1,650,000 2,050,000 1,450,000 Fixed Cost (N) 375,000 375,000 450,000 450,000 450,000 450,000 Total Cost (N) 1,575,000 1,175,000 1,950,000 2,100,000 2,500,000 1,900,000

  • Tags: Account Analysis, Cost Estimation, Engineering, Fixed Costs, High-Low Method, Least Squares, Scatter Graph, Separation Methods, Variable Costs
  • Level: Level 1
  • Topic: Cost Classifications
  • Series: MAY 2025
  • Uploader: Samuel Duah
Back to all questions
knowsia

Take control of your business data with insight and in-depth understanding by taking this course. 

Our Offerings

  • Professional Tuition
  • Question Bank
  • CPDs and Webinars
  • Corporate Trainings
  • Certificate Courses
  • Zoom Meetings

Contact Info

  • +233203701923
    +233543919232
  • info@knowsia.com

My Account

  • My Account
  • Manage Subscriptions
  • Tutors Dashboard
  • Become An Affiliate
  • Affiliate Dasboard
  • Login/Logout

Get In Touch

Follow us on our social media and get daily updates.

Facebook-f Twitter Linkedin-in Envelope

Forgot Password?

admin

Sign In

Pick a Form

Professional Tutor Application Form
Academic Tutor Application Form
Student Tutor Application Form