Accountancy  ·  Level 6
Quantitative Techniques
Chapter 3: Formulate linear programming models
📚 5 Topics
⚑ What you will be able to do

By the end of this chapter, you will be able to:

  • Identify key assumptions clearly based on the data provided.
  • Formulate accurate linear equations using real data.
  • Choose the best linear programming methods suited to the data.
  • Analyze linear equations correctly to find meaningful solutions.
  • Interpret the results of linear models accurately in context.
  • Recognize assumptions behind inventory control models following your organization's guidelines.
  • Select the right inventory control model to meet your organization’s goals.
  • Determine stock levels that align with your organization’s objectives.
  • Calculate total inventory costs accurately to support decision-making.

Mastering these skills will help you solve real-world problems efficiently and make smart decisions in your trade.

Formulating linear programming (LP) models is a fundamental quantitative technique for accountancy professionals engaged in resource allocation, cost minimization, or profit maximization within Kenyan businesses and organizations. LP models help accountants and financial analysts translate complex business constraints and objectives into mathematical expressions that can be solved efficiently. This chapter focuses on understanding the core terminology used in linear programming and how to develop accurate models that reflect real-world financial and operational scenarios.

3.1 Meaning of terms

In this section, we define and explore key terms essential to formulating linear programming models. Mastery of these terms allows accountancy professionals to construct precise models that optimize financial decisions such as budgeting, production scheduling, and portfolio management.

3.1.1 Decision Variables

Decision variables represent the unknown quantities that an LP model seeks to determine in order to optimize the objective function. These variables correspond to controllable activities or resources in the accounting context, such as units of products to produce, amounts of funds to allocate, or hours of labour to assign.

$$ \text{Decision variables: } x_1, x_2, ..., x_n $$

Worked Examples

Example 1: A retail business wants to decide how many units of product A and product B to stock. Let \(x_1\) be units of product A and \(x_2\) units of product B.

Given: No numerical calculation yet; define variables.

Example 2: A SACCO plans to allocate funds between two loan products: agricultural loans (\(x_1\)) and business loans (\(x_2\)).

Given: Variables represent loan amounts in Ksh million.

Example 3: A county government office wants to determine the hours staff spend on auditing (\(x_1\)) and financial reporting (\(x_2\)).

Given: Variables represent staff hours per week.

3.1.2 Objective Function

The objective function is a mathematical expression representing the goal of the LP model, typically maximization of profit or minimization of cost. It is formulated as a linear combination of decision variables with coefficients that quantify contribution per unit.

$$ \text{Maximize or Minimize } Z = c_1 x_1 + c_2 x_2 + \dots + c_n x_n $$

where \(c_i\) are coefficients representing profit, cost, or any other measurable metric.

Worked Examples

Example 1: A hotel wants to maximize revenue from two room types. Revenue per room: Ksh 5,000 for deluxe (\(x_1\)) and Ksh 3,000 for standard (\(x_2\)).

$$ Z = 5000 x_1 + 3000 x_2 $$

Example 2: A retail business aims to minimize total cost of stocking two products. Cost per unit: Ksh 200 for product A (\(x_1\)) and Ksh 150 for product B (\(x_2\)).

$$ Z = 200 x_1 + 150 x_2 $$

Example 3: A bank wants to maximize net interest income from two loan types. Net income per million Ksh: 0.12 for personal loans (\(x_1\)) and 0.10 for commercial loans (\(x_2\)).

$$ Z = 0.12 x_1 + 0.10 x_2 $$

3.1.3 Constraints

Constraints are linear inequalities or equalities representing the limitations or requirements within which the decision variables must operate. These constraints reflect resource availability, policy limits, or regulatory requirements.

$$ a_{11} x_1 + a_{12} x_2 + \dots + a_{1n} x_n \leq b_1 $$

$$ a_{21} x_1 + a_{22} x_2 + \dots + a_{2n} x_n \geq b_2 $$

$$ a_{31} x_1 + a_{32} x_2 + \dots + a_{3n} x_n = b_3 $$

Worked Examples

Example 1: A cooperative has a budget limit of Ksh 1,000,000 for two loan products \(x_1\) and \(x_2\) with unit costs of Ksh 500,000 and Ksh 400,000 respectively.

$$ 500000 x_1 + 400000 x_2 \leq 1000000 $$

Example 2: A university’s accounting department requires at least 40 hours of auditing work (\(x_1\)) and 60 hours of financial reporting (\(x_2\)) weekly.

$$ x_1 \geq 40 $$

$$ x_2 \geq 60 $$

Example 3: A retail business must stock at least 100 units of product A (\(x_1\)) and 150 units of product B (\(x_2\)).

$$ x_1 \geq 100 $$

$$ x_2 \geq 150 $$

3.1.4 Non-negativity Restrictions

Non-negativity restrictions require all decision variables to be zero or positive, reflecting the reality that negative quantities of physical or financial resources are not possible in accounting contexts.

$$ x_i \geq 0, \quad \forall i = 1, 2, ..., n $$

Worked Examples

Example 1: A SACCO cannot allocate negative funds to loans.

$$ x_1 \geq 0, \quad x_2 \geq 0 $$

Example 2: A retail business cannot stock a negative number of products.

$$ x_1 \geq 0, \quad x_2 \geq 0 $$

Example 3: A county government office cannot assign negative hours to financial activities.

$$ x_1 \geq 0, \quad x_2 \geq 0 $$

Practice Questions

  1. Define decision variables for a bank allocating Ksh 10 million between three loan products with constraints on minimum and maximum amounts for each. (5 marks)
  2. Formulate the objective function to maximize profit given unit profits of Ksh 1,200, Ksh 900, and Ksh 700 for three products \(x_1, x_2, x_3\). (5 marks)
  3. Write constraints for a retail business with a budget of Ksh 2 million, product unit costs of Ksh 400,000, Ksh 300,000, and Ksh 500,000, and minimum stock levels of 2, 3, and 1 units respectively. (6 marks)
  4. State the non-negativity restrictions for the above decision variables. (4 marks)
The rest of this chapter
🔒

Create a free account to open more of this chapter.

Free: practical guides, quick cards, workplace scenarios and more.

Create a free account
🔒3.2 Assumptions of linear programming models

In accountancy practice, formulating linear programming (LP) models requires a clear understanding of the underlying assumptions. These assumptions ensure that the LP model accurately represents the real-world financial or operational problem and produces reli…

🔒3.3 Formulation of linear programming model

Formulating a linear programming (LP) model is a fundamental step in solving optimization problems faced by accountancy professionals in Kenya. LP models assist in decision-making where resources such as budget, time, and labor must be allocated optimally unde…

🔒3.4 Solving linear programming problems

In the Kenyan accountancy profession, solving linear programming problems is crucial for optimizing resource allocation, cost minimization, and profit maximization within financial constraints. Accountants working in sectors such as banking, SACCOs, and county…

🔒3.5 Application of linear programming

Linear programming (LP) is a powerful quantitative technique widely used by accountancy professionals in Kenya to optimize resource allocation in financial planning, budgeting, and cost control. It helps accountants formulate models that maximize profits, mini…

Chapter Summary

This chapter introduced the key terms used in linear programming, including decision variables, objective function, and constraints, to establish a foundational understanding. It then outlined the assumptions underlying linear programming models, such as linearity, divisibility, certainty, and non-negativity, which ensure the applicability of the method. The process of formulating a linear programming model was detailed, emphasizing the translation of real-world problems into mathematical expressions involving an objective function and constraints. Methods for solving linear programming problems were explored, focusing on graphical and algebraic techniques to identify optimal solutions. Finally, the chapter highlighted various practical applications of linear programming in resource allocation, production scheduling, and cost minimization within diverse sectors. The combination of theory and application equips learners with the skills to model and solve optimization problems effectively.

Self-Assessment

🔒 PDFDownload this self-assessment, with answers

Written Assessment

  1. A small accounting firm can allocate at most 40 hours per week to auditing and bookkeeping. Auditing requires 3 hours per client, bookkeeping 2 hours per client. If the firm wants to serve a total of at least 10 clients, formulate the constraints for the linear programming model.

  2. A SACCO wants to maximize profits by offering two types of loans: personal loans and business loans. Each personal loan requires 1 hour of processing time, business loans require 2 hours. The total processing time available is 100 hours weekly. If the SACCO wants to approve at least 30 loans in total, write the linear programming constraints.

🔒18 more in this section.

Chapter Examination Questions

🔒 PDFDownload these examination questions, with worked answers

SECTION A (40 Marks) - Answer ALL Questions

  1. Explain the meaning of decision variables in a linear programming model within the context of a SACCO managing loan portfolios. (4 marks)
  2. State four key assumptions made in linear programming models when applied to budgeting in a county government office. (4 marks)
🔒18 more in this section.
Flashcards 21 cards Study deck ▾
Question
1

↻ Tap card to reveal answer
🔒

19 more in this section.

Create a free account
Test Yourself 16 questions Start quiz ▾
0%
0 / 2
🔒

14 more in this section.

Create a free account
Am I competent?

At the start of this chapter we promised you would be able to:

  • Identify key assumptions clearly based on the data provided.
  • Formulate accurate linear equations using real data.
  • Choose the best linear programming methods suited to the data.
  • Analyze linear equations correctly to find meaningful solutions.
  • Interpret the results of linear models accurately in context.
  • Recognize assumptions behind inventory control models following your organization's guidelines.
  • Select the right inventory control model to meet your organization’s goals.
  • Determine stock levels that align with your organization’s objectives.
  • Calculate total inventory costs accurately to support decision-making.

Tick each one you can genuinely do.

So, are you there yet?

You're competent when you can confidently do 50% or more of what this chapter promised.

Sign in to record how you're doing.