ATHE Level 3 Unit 6 Introduction to Financial Controls in Business Assignment Answers

ATHE Level 3 Extended Diploma in Business and Management

Aim of this Unit

This unit aims to help learners understand the financial controls that are used in business. Learning about financial controls helps you understand costs, budgets, financial ratios, and cash flow, which are used to monitor financial performance, support decision-making, and ensure effective management of organisational finance. 

Special Note: 

Make sure you use this sample for learning purposes only. If you make the mistake of using this sample to copy the content that has been mentioned here, you will get stuck on academic integrity. As every assignment is checked for plagiarism and AI detectors, plagiarism will be detected in your file, which will make you fail your assignment. 

Assignment Scenario

Mini-Mart Ltd (MML) is a regional grocery chain operating 27 stores across the north of the country. Recently, the CEO, Chun Wang, has been considering how the company could become more environmentally aware. There are several farms situated in the region, producing fruit, vegetables, meat and dairy products. Chun thinks it would help the environment by reducing food miles if MML sourced more products locally. She has already approached one of the local farmers about stocking his seasonal fruit and vegetables rather than importing from the usual overseas supplier.

You have recently joined MML as a junior manager, and Chun Wang has asked you to lead a new business development team that is researching how MML can become a more sustainable business whilst supporting the local environment.

AC 1.1 The explanations should include examples for each of the four terms in the task.

Answer:

There are four terms in the task:
1.    Fixed Costs
2.    Variable Costs
3.    Direct Costs
4.    Indirect Costs

Financial costs are a vital component of business management as it assists organisations to plan budgets, fix prices, manage expenditure and make informed financial decisions. The knowledge of the various costs helps managers to determine the profitability, estimate future costs and track business performance.

1. Fixed Costs: Fixed costs are costs that do not change as the quantity of output or sales changes within a time period. These expenses may occur whether or not the business generates income or not. Fixed costs are stable since they do not vary according to the activity of the business.
   
   Mini Mart Ltd has to pay £8,000 every month for one of their stores, for instance. A store has a monthly rent of £8,000, irrespective of the number of products sold in the month, which is either 500 or 5,000. Some other fixed costs are insurance premiums, business rates and permanent staff salaries.
   
   
2. Variable Costs: Variable costs vary in direct proportion to the number of goods or services produced or sold. Variable costs increase when the amount produced (or sold) goes up. But when it is produced, these costs are reduced.
   
   For instance, if Mini Mart Ltd is buying apples from a local farm at £1 for every kg of apples, it will cost the firm £500 to buy 500 kg of apples and £1000 to buy 1 000 kg of apples. The price is dependent on the quantity. Some other variable costs are packaging, raw materials and commissions on sales.
   
   
3. Direct Costs: Direct costs are those costs which are easily identifiable with a given product or service. These are the costs that are easily recognisable, and they're factored in when working out the cost of a specific product.
   
   For instance, if Mini-Mart Ltd is selling a locally produced cheese, the sum paid to the farmer for each batch of cheese is a direct cost as it is directly related to the cheese. Other direct costs can be raw materials, production wages and any specialised packaging used only for that product.
   
   
4. Indirect Costs: Indirect expenses are those that help keep the business going, but are not easily attributed to any one product or service. These costs are apportioned amongst various activities and are often known as overheads.
   
   For instance, the light and heat that a Mini-Mart uses to light and heat its store benefit the entire store instead of a specific product. So, electricity is considered an indirect cost. Examples of other costs include office administration salaries, cleaning services, internet charges and security costs.

The distinction between fixed and variable costs, direct and indirect costs, aids those in charge to make accurate budgets, estimating product pricing, track profit, and make sound financial decisions. Accurately defining these costs will help businesses enhance financial management and make better use of the available resources.

AC 1.2 (a) The outline of contribution (selling price – direct costs = contribution) should include a numerical example.

Answer;

a)  Contribution Formula 

Contribution is the income after deducting all direct (variable) costs from the selling price of a product. It's used to fund the cost of the business and once that cost is met, any excess contribution is profit. The formula for contributions is:
Contribution – Selling Price – Direct Costs

Assume that a locally-fruited basket costs £15 at Mini-Mart Ltd. The direct costs, such as buying from the local farmer and packaging, are £9.
Contribution = £15 – £9 = £6

This will assist the company to achieve its fixed cost of £6 per fruit basket sold, which covers staff wages, insurance and rent, etc. After subtracting all of the fixed costs, any additional contributions will increase the company's profit.

AC 1.2 (b)The learners must explain the significance of break-even, not simply define break-even.

Answer;

b)    Significance of Break-even

Break-even is the number of sales at which total revenues are equal to total costs. At this time, the business neither incurs losses nor makes profits because all costs (both fixed and variable) have been met. It is important to know the break-even point because it enables managers to find out the smallest number of units that have to be sold to make a profit.

The calculation of the break-even point would enable management at Mini-Mart Ltd to determine if their product was a worthwhile venture financially, including the introduction of locally produced products. If they are not, then the company might need to consider its pricing policy and cut expenses or enhance marketing to reach the break-even point. On the other hand, if the sales forecast is higher than the break-even, the new product will positively impact the profitability.

Break-even analysis is also helpful in decision making after introducing new products, while preparing budgets, setting selling prices, and analysing risks faced in business. The knowledge of the break-even point assists managers in making informed decisions on their finances and in future expanding their business. 

1M1 The analysis must show how (a) raising and (b) lowering the selling price changes the breakeven level of output. Stronger answers may refer to how changes in selling price change the level of demand. They should identify the main issues and include references to current research or theory where appropriate.

Answer:

The break-even point is directly affected by the selling price of the product because it influences the contribution that is made on every unit sold. Changes in selling price will have an impact on the number of units that must be sold to cover the fixed costs because contribution is the selling price less the direct costs.

The contribution per unit will increase with the increase in the selling price of locally-sourced products by Mini-Mart Ltd, but the direct cost remains the same. A higher contribution will mean a higher amount of contribution for the fixed costs for each sale. The business will therefore not have to sell as many products to compensate for its losses. For instance, if a product costs a direct cost of £9 and the selling price is £15, the contribution will be £6. If the selling price is increased to £17 and the direct costs remain at £9, then the contribution would be £8. This means that the business will make a profit faster, as it will have to sell fewer units for it to become profitable.

But raising the selling price could also decrease customers' demand. In numerous cases, sellers are price-sensitive, including groceries, where there are numerous other sellers that offer similar products. If customers think that the products are too costly, then they may opt for other products of their competitors. However, even though the break-even output is decreasing, sales volume can also be decreasing. The more profit, the more customers demand.

However, if the selling price is decreased, the contribution per unit of sale will also be reduced. The break-even point for Mini-Mart Ltd will be further out since each sale will be less significant in covering the fixed costs. This will boost the break-even point, but a lower selling price can lure in more buyers and boost the quantity sold. Even when there is an increase in demand, so much so that the business earns less contribution per unit, the business can still make more profits in total.

Therefore, the manager should take into account the financial calculations and the market conditions when setting prices. While break-even analysis is valuable information, other factors such as customer demand, competitor prices, and the perceived value of the product should also be considered when determining a product's price. Combining all these will enable Mini-Mart Ltd to select a price strategy that will help in attaining profitability and also ensure the long-term development of the business.

AC 2.1 The learners must use the figures in the sample assignment, and the template in the workbook should be used. 

Answer:

Sample financial information has been provided below to illustrate how budgets are used to plan and control the finances of a business, for Mini-Mart Ltd.

A budget is the prediction of income and expenses for an accounting period. Sales revenue is income that is projected to come from selling products such as local fruit and vegetables, meat and dairy products. Once the costs of goods sold are subtracted from this, the business should make a gross profit of £70,000.

The cost of the wages, rent, utilities, marketing, insurance and other overheads is deducted to arrive at the estimated net profit of £22,000. Having a budget gives Mini-Mart Ltd the ability to plan the allocation of financial resources, keep track of the money that is being spent, and then compare actual spending to planned spending.

Budgets also provide the basis for decision making, as they help managers pinpoint those areas in the budget where costs could be controlled, and to assess future investment opportunities and whether adequate resources are available to support the company's sustainability goals. The business can take corrective action if the performance is not as expected, if monitoring of the budget is continued regularly.

AC 2.2 (a) The explanation must include the reasons why both positive and negative variances occur. (b) The explanation must include each of the stages of the budgetary process. 

Answer:

a)   Reasons for favourable and adverse budget variances

The reasons for favourable and adverse budget variances are as follows:

Budget variance is the difference between the expected monetary outcome as per the budget and the actual monetary outcome of a business. Variances are investigated to ascertain the reasons for any difference between performance and expectation, and what needs to be done to correct it. Variances can either be favourable or adverse.

Variance is favourable when realised performance is above as it should have been planned. You can see that the sales of Mini-Mart Ltd can go higher than planned, for instance, if the demand for local products goes up or a marketing campaign becomes successful and brings in more customers. Likewise, favourable expenditure variances are those where costs are lower than planned, for example, due to supplier discounts, lower energy usage or improved stock control cutting down on waste. Favourable variance usually reflects efficiency in the use of resources and increased profitability.

An adverse variance is when the actual results are less favourable than the budgeted results. This can occur when sales are not as high as they had anticipated, as a result of tougher competition, shifting customer preferences, or a weak economy. Supplies could also go over budget due to increased prices, utility bills, wage increases or unplanned maintenance costs. Adverse variances mean less profitability and can impact the organisation's ability to meet its financial goals.
Variance analysis of positive and negative variances can help the manager determine the causes of the variance, make adjustments to budgeting in the future, and take corrective measures if needed. Managers should look into the reasons for the variance, not just the fact that it's positive or negative, before making business decisions.

b)   Stages of the budgetary process

The budgetary process is a system for planning, monitoring and controlling the finances of an organisation. It ensures that the financial goals are aligned with the business goals and that the resources are being allocated appropriately.

The first step is to establish organisational goals. Management sets financial and operational objectives for the business to attain during the budget period, for example, to grow sales, decrease costs, or enhance profits.

The second stage is preparing the budget. The managers use past performance, market trends and business forecasts to estimate future income and expenditure. Individual departmental budgets are drawn up, and the budgets are aggregated to form the overall organisational budget.

The third phase of the budget implementation is putting the budget into practice. When approved, the budget is shared with managers and staff for them to be able to use planned activities within the financial limits.

Stage 4 is monitoring performance. Actual income and expenditure are kept throughout the budget period and are compared to the planned amounts. Variances in budgets are noted as any differences.

The final step is to review and revise the budget. Management investigates the root causes of major differences and decides if action is needed. Feedback and learning from the review process can also be applied to enhance the budgeting and financial planning process in the future.

These stages ensure the management of financial control in an organisation, efficient use of resources and appropriate reactions to changes in the business environment.

AC 2M1 The learners’ response must use the figures in the sample assignment and must clearly indicate and analyse the reasons why budget variances for income, expenditure and profit occur.

Answer: 

The following table shows the difference between the budgeted values and actual financial performance for Mini-Mart Ltd for the period.

in higher sales, while other reasons that could have contributed to increasing the revenue can be promotional campaigns and strong customer service.  

Cost of goods can be seen as an adverse variance of £4,000. Although higher sales result in additional income, they also make Mini-mart spend more on products so that it can meet the demand of its customers. Additionally, high prices would be seen in locally sourced products during certain seasons or from certain suppliers; this may have increased their prices because of transport costs and higher production. 

Gross Profit was £2,000, which was higher than the expected budget, as an increase in sales revenue was more than enough to surpass the cost of higher purchasing. This shows the company’s pricing strategy was effective and the demand from customers was so good that it maintained the profit despite the increase in costs. 

Operating expenses were also seen to increase by £2,000. This could be possible because of an increase in utility bills, or an increase in marketing expenditure that was used for promoting local products. Additionally, paying for additional staff hours during busy periods, or any kind of unexpected costs. Although no doubt these expenses exceeded the budget, they have also supported a higher level of sales that was achieved in this period. 

Net profit was seen as constant with the original budget. This reflects that the increase in gross profit and in sales compensated for higher operating costs. When it is seen from a financial control perspective, this shows effective management as the business maintained its profitability despite changes in both income and expenditure. 

In short, variance analysis shows that managers should not prefer individual variances in isolation. Let the sales variance make adverse expenditure variances if there is a need of additional resources required for supporting high demands of customers. Mini-mart Ltd can understand performance differences by simply analysing expenditure, income and profit together for improving the future budgeting that will help them in creating better financial decisions. 

AC 3.1 The five separate formulae and calculations must be shown in the answer.

Answer:

The following financial information has been used for calculating key financial ratios for Mini-mart Ltd. 

• Sales Revenue = £186,000
• Cost of Goods Sold = £114,000
• Gross Profit = £72,000
• Net Profit = £22,000
• Current Assets = £48,000
• Current Liabilities = £24,000
• Inventory = £12,000

1. Gross Profit Margin

Formula:
Gross Profit Margin = (Gross Profit ÷ Sales Revenue) × 100
Calculation:
(£72,000 ÷ £186,000) × 100 = 38.71%
Answer: Gross Profit Margin = 38.71%

2. Net Profit Margin
Formula:
Net Profit Margin = (Net Profit ÷ Sales Revenue) × 100
Calculation:
(£22,000 ÷ £186,000) × 100 = 11.83%
Answer: Net Profit Margin = 11.83%

3. Current Ratio
Formula:
Current Ratio = Current Assets ÷ Current Liabilities
Calculation:
£48,000 ÷ £24,000 = 2.0:1
Answer: Current Ratio = 2.0:1

4. Acid Test (Quick) Ratio
Formula:
Acid Test Ratio = (Current Assets − Inventory) ÷ Current Liabilities
Calculation:
(£48,000 − £12,000) ÷ £24,000
£36,000 ÷ £24,000 = 1.5 : 1
Answer: Acid Test Ratio = 1.5 : 1

5. Inventory Turnover Ratio
Formula:
Inventory Turnover = Cost of Goods Sold ÷ Average Inventory
Calculation:
£114,000 ÷ £12,000 = 9.5 times
Answer: Inventory Turnover = 9.5 times

AC 3.2 The analysis must consider at least two of the components of each element of the ratio, e.g. for the gross profit ratio, the learner response must analyse the sales and the elements of cost of sales.

The learners should break down the possible reasons for the results into separate parts and examine each part in detail. They should identify the main issues and include references to current research or theory where appropriate. 

Answer:

Financial ratio analysis can help managers to analyse the financial performance of a business regarding its profitability, liquidity and efficiency. The ratios worked out by Mini-Mart Ltd are helpful in understanding the performance of the business and indicate areas where it may need to improve.

The Gross Profit Margin of 38.71% suggests that the company is making a good profit from its core business operations. This implies that the firm Mini-Mart Ltd has been able to manage its cost of sales and has kept a selling price that keeps it making a profit. Having a high gross profit margin gives the business enough money to pay its operating costs and develop in the future.

The Net Profit Margin is 11.83%, which means that for every £1 that the company generates in sales, they make nearly £1 a profit after all operating costs have been taken away. The business is also not as profitable as it could be because of the low cost of operations, including wages, rent and utilities, but it still makes a good profit. This shows good financial management and control of expenditure.

The Current Ratio of 2.0:1 means that Mini-Mart Ltd has sufficient current assets to cover its current liabilities. This indicates that the business has a solid position and will not have to worry about running out of money to pay suppliers or other short-term financial obligations.

The Acid Test Ratio is a more conservative measure of liquidity because it does not include inventory in current assets; it is 1.5:1. The ratio indicates that the business has sufficient liquidity to meet its short-term needs without having to sell stock. The company's cash position is strong, and good working capital management is demonstrated.

An inventory turnover ratio of 9.5 times indicates the regular turnover of the stock in the year. This is particularly beneficial for a grocery retailer because many products are perishable. A high inventory turnover minimises waste, cuts down storage expenses and enhances cash flow.

Overall, the financial ratios suggest that Mini-Mart Ltd is doing well. The business is profitable and has a good liquidity position and an efficient handling of inventory. Management will be able to monitor performance, be aware of trends and make informed business decisions by conducting regular ratio analysis.

AC 3M1 The analysis must include the range of components making up the ratios analysed.

Answer:

Financial ratios give managers a general idea of how well the business is doing, but they can also help managers understand the factors that contribute to that business's performance and what opportunities they can take advantage of to improve the performance of that business.

Sales revenue and the COGS have the greatest impact on the Gross Profit Margin. An increase in the amount of sales revenue will boost gross profit if selling prices continue to be profitable, and vice versa. Sales revenue will boost gross profit if the purchase costs are reduced and the selling prices are maintained at profitable levels. Higher local product prices are also affecting costs of sales, as Mini-Mart Ltd's sales have been strong due to the demand for locally sourced products. It is important to have the right price and buying costs to ensure profitability.

Net Profit Margin is directly related to Gross Profit and Operating Expenses. Although gross profit may be high, net profit can be lowered due to an increase in expenses like wages, utilities, marketing and rent. These are amongst the costs that Mini-Mart Ltd has kept under control; thus, it has been able to generate a reasonable profit margin for the business. Ongoing overhead (O/C) monitoring will ensure long-term profitability.

Current Ratio is calculated as the ratio of current assets to current liabilities. Raising the cash or trade receivables or inventory increases the ratio, and raising the short-term debts decreases the ratio. Managers need to make sure that current assets are adequate to meet current debts, but not have too many resources sitting idle.

The Acid Test Ratio is based on current liquid assets and ignores inventories. This gives a better idea about the ability of the business to pay its current liabilities if there is a delay in the sale of the inventories. The ratio is strong and indicates that Mini-Mart Ltd has good cash management and that there are adequate liquid resources available.

The Inventory Turnover Ratio is affected by COGS and Average Inventory. Increased sales and effective inventory management will lead to higher inventory turns, while slow-moving inventory will lead to lower inventory turns and mean a lower working capital utilisation ratio. The use of locally sourced products and frequent replenishment of stocks can help Mini-Mart Ltd ensure product freshness, which helps to lower storage expenses and the chance of wasting products.

In general, the breakdown of each ratio can offer a more detailed look at the factors that are impacting business performance. Managers should use ratio values along with values of sales, costs, assets, liabilities and inventory changes to make informed financial decisions and improve performance in the future, rather than just the ratio values.

AC 4.1 must clearly show that cash is a resource that flows into a business and that profit is calculated by subtracting costs from revenue. Examples will enhance the explanation.

Answer:

Cash is related to profit, but not identical to profit. Knowing the difference is crucial because even if a business makes a profit, it can still have cash flow issues.  

Money in and out of the business is called cash. Cash flows are receipts from customers, bank loans and investment income, payments to suppliers, payments of wages, rent, utility bills and taxes. The case flow of a business must be adequate for its day-to-day operating needs and financial commitments. 

Profit is the amount of money that a business makes once it has subtracted its expenses from its income over a particular period of time. It can be determined by the following formula: 

Profit = TR – TE. 

For example, let’s say that Mini-mart Ltd makes sales revenue of £186,000 and total expenses of £164,000. The business would have a net profit of £22,000. 

The business may not have adequate cash on hand for its business to be profitable. The goods may be sold on credit, that is, the sale may be recognised as revenue immediately, but the cash is collected at a later date by some customers. Meanwhile, the business may have to settle its supplier obligations, pay wages and other business expenses, etc., before being paid by its customers. This can lead to an actual shortage of cash even if the business is profitable. 

At the very least, profitability and positive cash flow are imperative for Mini-mart Ltf. Profit is what drives long-term business growth, and cash is what keeps your business running smoothly on a day-to-day basis. Monitoring cash flow and profitability, therefore, is a more effective way of financial management than focusing on only one. 

AC 4.2 The learners must construct a cash flow based on the figures in the assignment. The cash flow statement must be in a recognised format and clearly show the monthly cash outflow, cash inflow and the cumulative cash position.

Answer:

With the help of the Sample Financial data, this cash flow forecast has been prepared for Mini-Mart Ltd:

 

The cash flow forecast shows the anticipated cash inflows and outflows of the business for three months. The cash inflows are primarily customers' payments, and cash outflows are payments to suppliers, employee wages, rent, utilities, and other operating expenses.

According to the forecast, the cash balance is positive for Mini-Mart Ltd throughout the forecast period. The closing balance rises from £22,000 in January to £36,000 by the end of March, as there are regular surpluses of cash over the period. This indicates that the business has enough liquid assets to satisfy the liquidity requirements and that they are able to continue operating the business.

By making a cash flow forecast, managers can predict if they will have a surplus or a lack of cash and can plan ahead how they will spend the money, manage their working capital and make financial decisions. Cash Flow monitoring is also a good way of lowering the possibility of liquidity issues and therefore the long-term financial stability of the organisation.

AC 4.3 The analysis must include at least three separate reasons why cash is important to a business. The learners should break down the importance into separate parts and examine each part in detail. They should identify the main issues and include references to current research or theory where appropriate. 

Answer:

As one of the most valuable resources in any business, cash is essential to the company's financial obligations and smooth running. Even a successful company can find itself in trouble if it doesn't have enough cash. Therefore, businesses need to keep a close eye on their cash flow and make sure that they have sufficient cash flow to cover their everyday activities.

One of the key needs of cash is that it can ensure that the business can cover its day-to-day operating costs. Payments for wages, rents, utilities, supplier invoices, insurance and other operating costs will need to be made regularly by organisations. Mini-Mart Ltd's cash flow problems can cause them to fall behind in these payments and impact their business relationships with employees and suppliers. Having sufficient cash reserves will allow the business to keep running without any disruption.

Cash also plays an important role in business growth and investment because it is a means of financing. A growing interest in locally-sourced products may require Mini-Mart Ltd to acquire new stock, invest in refrigeration machinery, enhance the store's facilities or launch new marketing initiatives, all of which would require additional cash. When the cash is available, management has the flexibility to pursue growth opportunities without borrowing all of the money they need. Companies that have good cash flow tend to have more room to manoeuvre when it comes to reacting to shifts in demand or conditions in the market.

Another reason for the importance of cash is to preserve financial stability and business credibility. Organisations that have a good history of fulfilling their financial commitments are more likely to be the ones that will be able to attract suppliers, lenders and investors. On-time payments to suppliers can help build better relationships with suppliers and improve the chances of negotiating a better price or payment terms. Likewise, positive cash flow boosts the image of the organisation and builds investor confidence.

Cash is also insurance against financial emergencies and risks. Rapidly rising operating expenses, equipment breakdowns, fluctuations in business during the season, or broader economic problems can occur. Having a healthy cash reserve allows organisations to manage the unexpected costs without seriously affecting the day-to-day running of the business. This financial flexibility minimises the risk of taking on a loan at an unfavourable rate and liquidity constraints.

Cash is critical as it facilitates daily operations, ensures future investment opportunities, fosters stakeholder trust and mitigates financial risks to the organisation. Businesses can ensure their long-term goals and stay financially secure by using effective cash management.

4D1 Evaluate the importance of effective cash flow management in supporting business success.

Answer:

Proper cash flow management is an important part of any business's survival and success. Profitability is used to measure the financial performance of an organisation over a period of time, while cash flow analysis is used to identify whether enough cash is available to the organisation to run its daily operations. Even if a business is profitable, it can go under if it is unable to generate enough cash to pay off its short-term obligations. Maintaining good cash flow is especially important to Mini-Mart Ltd since the business is in the grocery retail industry, goods are brought frequently, and many products have very short shelf lives. By keeping a close eye on cash flow, management can buy stocks at the right level, void wasting stock and pay suppliers on time. This help to ensure that the business runs smoothly and that there are good relationships with suppliers. 

Provides managers with an accurate picture of the business’s cash flow, allowing them to see when they need to borrow more money or when they can invest any surplus funds into the business. For example, if there is a high level of cash, Mini-mart Ltd could expand its locally sourced products, refurbish stores or invest in energy-efficient equipment to help meet sustainability goals. On the other hand, if there are expected cash shortages in the future, management can postpone the payment of non-essential expenses or make short-term loans prior to the cash shortage. 

One other advantage is that of financial risk minimisation. Regularly checking cash flow will help make businesses more resilient to changes like an economic slowdown, a temprory dip in customer demand, or increasing supplier costs. Having enough cash supplies enables an organisation to continue functioning during other spells of bad weather without the customers’ service being affected or the stakeholders' confidence being shaken. 

But the Management of cash flow should not be restricted to building up large cash reserves. An excess of cash could limit the ability to invest in a profitable venture or expand the business. Managers need to find a balance between having enough liquidity and utilising the available resources effectively to earn profits in the long term. Wealth management can’t be done without being careful about cash and wise about investments. 

Finally, successful enterprises understand, that making money isn’t enough to ensure financial security. Positive cash flow, planning future cash needs and reacting swiftly to changing business conditions are key to sustainale business success. The implementation of cash management could improve the financial position of Mini-mart Ltd, provide cash for future expansion and help the company reach its strategic goal of becoming a more sustainable and competitive company.