Question Tag: Cash Budgeting

Search 500 + past questions and counting.
  • Filter by Professional Bodies

  • Filter by Subject

  • Filter by Series

  • Filter by Topics

  • Filter by Levels

MI – May 2018 – L1 – SA – Q12 – Budgeting

Understanding the purpose of cash budgeting.

Which of the following is NOT a purpose of cash budgeting?
A. To ensure availability of working capital throughout the period concerned
B. To determine the timing of cash inflows and outflows in advance
C. To plan on investing surplus cash whenever it arises
D. To plan against likely cash deficits during the budget period
E. To reduce cost of operation

Login or create a free account to see answers

Find Related Questions by Tags, levels, etc.

Report an error

You're reporting an error for "MI – May 2018 – L1 – SA – Q12 – Budgeting"

MI – Mar-Jul 2020 – L1 – SA – Q7 – Budgeting

Calculate the sales collection in Month 4 based on given purchasing and collection pattern.

MNO is a retailer of various domestic goods, selling all purchases in the same month, therefore not keeping any stock. The company’s policy is to sell at a margin of 9.091% and collection of sales proceeds is 50% in the month of sales, 30% the month after, and the balance in the 3rd month. Purchases for the past four months are as follows:

Month Amount (N)
1 65,000,000
2 72,000,000
3 60,000,000
4 80,000,000

What is the sales collection in Month 4?

A. N64,000,000
B. N70,400,000
C. N72,000,000
D. N78,793,459
E. N79,200,000

Login or create a free account to see answers

Find Related Questions by Tags, levels, etc.

Report an error

You're reporting an error for "MI – Mar-Jul 2020 – L1 – SA – Q7 – Budgeting"

MA – Nov 2017 – L2 – Q2b – Cash budgets and master budgets

Calculate purchases figures and prepare a cash budget for a three-month period based on given financial information and sales projections.

b) Abigail Acheampong is in the process of preparing budgets for the period October to December 2017. The following information has been provided to assist in the budgeting process:

  • Sales are 20% cash and 80% credit. Credit sales are collected over a three month period, 15% in the month of sale, 70% in the month following sale and 15% in the second month following sale. Bad debts of 5% are anticipated on all credit sales.
  • Total sales revenue in August amounts to GH¢30,000 and September’s total sales revenue amounts to GH¢36,000.
  • Cost of sales is expected to amount to 60% of sales revenue each month.
  • The business maintains its closing inventory levels at 75% of the following month’s cost of sales. Inventory at the beginning of October is expected to amount to GH¢18,000.
  • 50% of inventory purchased is paid in the month of purchase. The remaining 50% is paid for in the month following purchase. As at 30 September 2017, amount owed for purchases are GH¢11,700.
  • A grant of GH¢20,000 is expected to be received in mid-October.
  • A second hand van which cost GH¢8,000 three years ago is expected to be sold in December 2017 for GH¢3,000. At this time the expected net book value of the van is GH¢1,800.
  • Equipment costing GH¢4,500 will be purchased and paid for in November 2017. The equipment will be depreciated on a straight line basis over three years.
  • Operating expenses are paid as incurred. These have been estimated as follows: GH¢ October 12,800 November 18,900 December 14,600 The above figures include depreciation on existing assets of GH¢2,000 per month.
  • The cash balance on 1 October is expected to amount to GH¢8,000

Required: i) Calculate the purchases figure for each month from October 2017 to December 2017.

(3 marks)

ii) Prepare a cash budget on a monthly basis and in total for the period October 2017 to December 2017. (12 marks)

Login or create a free account to see answers

Find Related Questions by Tags, levels, etc.

Report an error

You're reporting an error for "MA – Nov 2017 – L2 – Q2b – Cash budgets and master budgets"

MA – May 2020 – L2 – Q2b – Cash budgets and master budgets

Prepare a cash budget for Emefa Ltd for October 2019 based on the given sales and cost data.

b) Emefa Ltd (Emefa) is in the process of preparing its budget for the month of October 2019 for its product, YEK. The Company expects to sell the product for GH¢75 but this price is expected to increase in the last quarter of 2019 by 5%. The following are the expected sales in units for the last six months in 2019.

Month Units
August 7,000
September 8,000
October 9,000

In October 2019, a total of 9,150 units of product YEK are expected to be produced to meet demand.

Typically, cash sales represent 20% of sales. Credit sales terms are 2/10, n/30. Emefa bills customers on the first day of the month following the month of sale. Experience has shown that 60% of the billings will be collected within the discount period, 25% by the end of the month after sales, 10% by the end of the second month after the sale, and 5% will ultimately be uncollectible. The firm writes off uncollectible accounts after 12 months.

The firm uses two materials for production, Mat and Pat. The purchase terms for materials are 2/15, n/60. Experience has shown that 80% of the purchases are paid in the month of the purchase and the remainder is paid in the month immediately following. In September 2019, the firm budgeted purchases were GH¢32,000 for Mat and GH¢20,000 for Pat.

The firm’s budgeted direct material and labour budgets are as follows:

Direct Materials Purchases Budget (in Cedis) For October 2019

Material Budgeted Purchases (Pounds) Expected Purchase Price per Unit (GH¢) Total (GH¢)
Mat 45,000 2.00 90,000
Pat 25,000 3.00 75,000
Total Budgeted Purchases 165,000

The production process requires direct labour at two skill levels (SL). The rate for labour at the SL1 level is GH¢45 per hour and for the SL2 level is GH¢25 per hour. The SL1 level can process one batch of YEK per hour while SL2 uses two (2) hours for the same output. Each batch consists of ten (10) units. The manufacturing of YEK also requires one-fifth of an hour of SL2 workers’ time for each unit manufactured.

Variable manufacturing overhead is GH¢100 per batch plus GH¢75 per direct labour-hour. In addition to variable overhead, the firm has a monthly fixed factory overhead of GH¢60,000, of which GH¢18,000 is depreciation expense. The firm pays all manufacturing labour and factory overhead when incurred.

Total budgeted marketing, distribution, customer service, and administrative costs for the 2019 annual budget are GH¢3,000,000. Of this amount, GH¢2,000,000 is considered fixed and includes depreciation expense of GH¢400,000. All marketing and administrative costs are paid in the month incurred.

Management desires to maintain an end-of-month minimum cash balance of GH¢100,000. The firm has an agreement with a local bank to borrow its short-term needs in multiples of GH¢10,000 up to GH¢1,000,000 at an annual interest rate of 26%. Borrowings are assumed to occur at the end of the month. Bank borrowing at October 1 was GH¢0.

Required:

Prepare the cash budget for October 2019 for Emefa Ltd. (10 marks)

Login or create a free account to see answers

Find Related Questions by Tags, levels, etc.

Report an error

You're reporting an error for "MA – May 2020 – L2 – Q2b – Cash budgets and master budgets"

CSEG – Nov 2018 – L2 – Q1- Analysing the internal environment

Analyzing the internal environment, Strategic management process, Financial planning and forecasting, Liquidity management, Long-term capital raising

GHANA’S FOOTWEAR MANUFACTURING INDUSTRY

Introduction:

The footwear industry has many players including artisanal shoemakers, local and foreign manufacturers, with local representatives, producing a wide range of footwear. In Ghana, the footwear industry is making headway in the local market, with most of the shoes being produced in Kumasi. The Kumasi Shoe Manufacturing Company focuses on making footwear for almost all the security agencies in Ghana, as well as some private security companies. The local market is also filled with individual artisans and small startup companies who make footwear for sale in the country. The other regions in the country such as the Greater Accra Region and the Northern Region also have a few individuals who are into footwear manufacturing but on a smaller scale.

Foreign-produced footwears are of superior quality and attract skimming pricing compared to the locally produced ones. The sector is projected to have high growth potential with most of its forecasted sales to emanate from low-income segments with marginal and flat growth from middle and high-income segments respectively. The growth, among other things, will be fueled by the government’s free school uniform and sandals policy which is expected to be sourced from local manufacturers. In Ghana, luxury shoes are usually European or American brands. The luxury footwear production in Ghana is still a virgin market with a lot of potential once people start to believe in the high quality these Ghanaian brands can offer.

On average, it takes three to five years for local manufacturers to ramp up production significantly enough to drive down average fixed cost and attain utilization of full capacity due to intense competition and difficulty accessing the major wholesale and retail outlets trading in footwears. The foreign as well as a good number of local manufacturers sign 5 to 10 years contract with major outlets in all the major urban centres for exclusive rights to sell their footwears.

The artisanal shoemakers generally produce based on customer orders. In the Footwear industry, customers easily source from many available alternatives. The key customers of foreign and local manufacturers are the various wholesale and retail outlets. There are emerging online shops providing information on prices of goods and services from different manufacturers including footwears free of charge and consumers can easily access that information. The profit margins for the outlets are generally low. There have been recent acquisitions of some local footwear manufacturing companies by some major wholesale and retail distributors in Ghana and the experts are predicting more of such transactions.

In Ghana, there is a cartel of few major importers, controlling approximately 90% of high-quality natural and synthetic leather markets, from whom many local manufacturers and artisanal shoemakers procure their raw materials. These importers source their supplies largely from Europe, which compares favourably, in terms of quality and price, to those available in neighbouring countries. A recent consumer survey indicates that footwear produced with inputs from Europe are durable, of good quality and able to stand high-temperature conditions locally hence consumer preference.

Footwear Ventures Ltd (FVL)

Footwear Ventures Ltd (FVL) was founded by Peter Legubo, who graduated with a bachelor’s degree in Fine Arts, from a public university in Ghana. Prior to starting the company, Peter met one of his schoolmates, who owned a business that specialized in traditional handicrafts including footwear. He was able to convince him to join FVL. The schoolmate’s hands-on experience coupled with Peter’s competence in drawing and designing will be complementary and indispensable to gaining competitive edge. The initial capital for the company was raised from personal savings and severance package received by Peter from his former employment. He was able to acquire requisite tools and machines for the production of footwear.

Based on the determination and ambition of the founder, FVL outdoored its first production line with four different products including shoes and sandals for men, women, children as well as boots for security personnel. The products were well received by the public. The company continued production but it could hardly produce the quantity required by its retailers due to inadequate funding. Peter, therefore, approached some banks for credit facility but due to lack of credit history he was unsuccessful. Peter Legubo decided to turn to his friend, Kingsford Yeboah, who lived in Germany and had earlier expressed interest in investing in the business. Kingsford provided the business with a substantial amount of cash. The capital injection was used to buy more tools and machines in a bid to significantly automate the production process. Additional hands were engaged bringing the total number of employees to 100. Currently, the company produces on average 2,200 pairs of shoes per month.

The main raw materials for footwear, including natural and synthetic leather, synthetic sole and adhesive, are sourced from local importers. FVL is contemplating diversifying its raw materials. The shoes produced by the company are largely distributed through major retail shops dotted across major urban centres since FVL does not have the required resources to open its own sales outlets. The company also does direct sales to students on campuses of some tertiary institutions in the country.

On strategic approach, Peter believes the company should continue to exclusively rely on the engagement of experienced hands from the industry and should waste no time in formalizing and documenting the company’s strategy. Kingsford Yeboah also believes that the company should institutionalize a strategic approach that should focus on the strategy process, financial planning and forecasting as well as sources of finances.

Financial planning and forecasting

FVL has the potential of becoming a leading producer of footwear in the Ghanaian market. It is however faced with liquidity challenges. The management of FVL has decided to prepare a six-month budget in order to better manage its liquidity needs and avoid any shortages, especially in the light of limited access to bank credit.

Financial data

FVL has planned production and sales for the next nine months as follows:

Month April May June July August September October November December
Production (Units) 700 800 1,000 1,200 1,200 1,400 1,500 1,500 1,500
Sales (Units) 700 800 800 1,000 1,200 1,300 1,400 1,600 1,500

During the period, the business plans to advertise so as to achieve the projected sales. Payments for advertising of GH¢12,000 and GH¢18,000 will be made in June and September respectively. The selling price per unit will be GH¢120 throughout the period. 40% of sales are normally made on two months’ credit. The other 60% are settled within the month of the sale.

Raw materials used for the footwear will be held for one month before they are taken into production. Purchases of raw materials will be on one month’s credit. The cost of raw materials is GH¢60 per unit of production. Other direct production expenses, including labour, are GH¢25 per unit. These will be paid in the month incurred. Various production overheads, which during the period to 30 May had run at GH¢21,600 a month, are expected to rise to GH¢24,000 each month from 1 June to 30 September. These are expected to rise again from 1 October to GH¢28,800 a month and to remain at that level for the foreseeable future. These overheads include a steady GH¢4,800 each month for depreciation. Overheads are planned to be paid 80% in the month of production and 20% in the following month.

To help meet the planned increased production, a new item of plant will be bought and delivered in July. The cost of this item is GH¢79,200; the contract with the supplier will specify that this will be paid in three equal installments in August, September, and October. Raw materials inventories are planned to be 1,000 units on 1 June. The balance at the bank on the same day is planned to be GH¢89,000. The company earns 5% interest on the closing balance, which is paid in the following month.

Required:

a) Analyze the strengths and weaknesses of FVL. (6 marks)

b) Prepare a report to the Director of FVL on the process of strategic management. (8 marks)

c) Prepare a cash budget for the six months ending 30 November based on the financial data of FVL. Show all workings. (12 marks)

d) Recommend to the Directors of FVL FOUR (4) strategies for overcoming the liquidity crisis. (8 marks)

e) Advise the directors of FVL FOUR (4) methods of raising long-term capital. (6 marks)

Login or create a free account to see answers

Find Related Questions by Tags, levels, etc.

Report an error

You're reporting an error for "CSEG – Nov 2018 – L2 – Q1- Analysing the internal environment"

MI – May 2018 – L1 – SA – Q12 – Budgeting

Understanding the purpose of cash budgeting.

Which of the following is NOT a purpose of cash budgeting?
A. To ensure availability of working capital throughout the period concerned
B. To determine the timing of cash inflows and outflows in advance
C. To plan on investing surplus cash whenever it arises
D. To plan against likely cash deficits during the budget period
E. To reduce cost of operation

Login or create a free account to see answers

Find Related Questions by Tags, levels, etc.

Report an error

You're reporting an error for "MI – May 2018 – L1 – SA – Q12 – Budgeting"

MI – Mar-Jul 2020 – L1 – SA – Q7 – Budgeting

Calculate the sales collection in Month 4 based on given purchasing and collection pattern.

MNO is a retailer of various domestic goods, selling all purchases in the same month, therefore not keeping any stock. The company’s policy is to sell at a margin of 9.091% and collection of sales proceeds is 50% in the month of sales, 30% the month after, and the balance in the 3rd month. Purchases for the past four months are as follows:

Month Amount (N)
1 65,000,000
2 72,000,000
3 60,000,000
4 80,000,000

What is the sales collection in Month 4?

A. N64,000,000
B. N70,400,000
C. N72,000,000
D. N78,793,459
E. N79,200,000

Login or create a free account to see answers

Find Related Questions by Tags, levels, etc.

Report an error

You're reporting an error for "MI – Mar-Jul 2020 – L1 – SA – Q7 – Budgeting"

MA – Nov 2017 – L2 – Q2b – Cash budgets and master budgets

Calculate purchases figures and prepare a cash budget for a three-month period based on given financial information and sales projections.

b) Abigail Acheampong is in the process of preparing budgets for the period October to December 2017. The following information has been provided to assist in the budgeting process:

  • Sales are 20% cash and 80% credit. Credit sales are collected over a three month period, 15% in the month of sale, 70% in the month following sale and 15% in the second month following sale. Bad debts of 5% are anticipated on all credit sales.
  • Total sales revenue in August amounts to GH¢30,000 and September’s total sales revenue amounts to GH¢36,000.
  • Cost of sales is expected to amount to 60% of sales revenue each month.
  • The business maintains its closing inventory levels at 75% of the following month’s cost of sales. Inventory at the beginning of October is expected to amount to GH¢18,000.
  • 50% of inventory purchased is paid in the month of purchase. The remaining 50% is paid for in the month following purchase. As at 30 September 2017, amount owed for purchases are GH¢11,700.
  • A grant of GH¢20,000 is expected to be received in mid-October.
  • A second hand van which cost GH¢8,000 three years ago is expected to be sold in December 2017 for GH¢3,000. At this time the expected net book value of the van is GH¢1,800.
  • Equipment costing GH¢4,500 will be purchased and paid for in November 2017. The equipment will be depreciated on a straight line basis over three years.
  • Operating expenses are paid as incurred. These have been estimated as follows: GH¢ October 12,800 November 18,900 December 14,600 The above figures include depreciation on existing assets of GH¢2,000 per month.
  • The cash balance on 1 October is expected to amount to GH¢8,000

Required: i) Calculate the purchases figure for each month from October 2017 to December 2017.

(3 marks)

ii) Prepare a cash budget on a monthly basis and in total for the period October 2017 to December 2017. (12 marks)

Login or create a free account to see answers

Find Related Questions by Tags, levels, etc.

Report an error

You're reporting an error for "MA – Nov 2017 – L2 – Q2b – Cash budgets and master budgets"

MA – May 2020 – L2 – Q2b – Cash budgets and master budgets

Prepare a cash budget for Emefa Ltd for October 2019 based on the given sales and cost data.

b) Emefa Ltd (Emefa) is in the process of preparing its budget for the month of October 2019 for its product, YEK. The Company expects to sell the product for GH¢75 but this price is expected to increase in the last quarter of 2019 by 5%. The following are the expected sales in units for the last six months in 2019.

Month Units
August 7,000
September 8,000
October 9,000

In October 2019, a total of 9,150 units of product YEK are expected to be produced to meet demand.

Typically, cash sales represent 20% of sales. Credit sales terms are 2/10, n/30. Emefa bills customers on the first day of the month following the month of sale. Experience has shown that 60% of the billings will be collected within the discount period, 25% by the end of the month after sales, 10% by the end of the second month after the sale, and 5% will ultimately be uncollectible. The firm writes off uncollectible accounts after 12 months.

The firm uses two materials for production, Mat and Pat. The purchase terms for materials are 2/15, n/60. Experience has shown that 80% of the purchases are paid in the month of the purchase and the remainder is paid in the month immediately following. In September 2019, the firm budgeted purchases were GH¢32,000 for Mat and GH¢20,000 for Pat.

The firm’s budgeted direct material and labour budgets are as follows:

Direct Materials Purchases Budget (in Cedis) For October 2019

Material Budgeted Purchases (Pounds) Expected Purchase Price per Unit (GH¢) Total (GH¢)
Mat 45,000 2.00 90,000
Pat 25,000 3.00 75,000
Total Budgeted Purchases 165,000

The production process requires direct labour at two skill levels (SL). The rate for labour at the SL1 level is GH¢45 per hour and for the SL2 level is GH¢25 per hour. The SL1 level can process one batch of YEK per hour while SL2 uses two (2) hours for the same output. Each batch consists of ten (10) units. The manufacturing of YEK also requires one-fifth of an hour of SL2 workers’ time for each unit manufactured.

Variable manufacturing overhead is GH¢100 per batch plus GH¢75 per direct labour-hour. In addition to variable overhead, the firm has a monthly fixed factory overhead of GH¢60,000, of which GH¢18,000 is depreciation expense. The firm pays all manufacturing labour and factory overhead when incurred.

Total budgeted marketing, distribution, customer service, and administrative costs for the 2019 annual budget are GH¢3,000,000. Of this amount, GH¢2,000,000 is considered fixed and includes depreciation expense of GH¢400,000. All marketing and administrative costs are paid in the month incurred.

Management desires to maintain an end-of-month minimum cash balance of GH¢100,000. The firm has an agreement with a local bank to borrow its short-term needs in multiples of GH¢10,000 up to GH¢1,000,000 at an annual interest rate of 26%. Borrowings are assumed to occur at the end of the month. Bank borrowing at October 1 was GH¢0.

Required:

Prepare the cash budget for October 2019 for Emefa Ltd. (10 marks)

Login or create a free account to see answers

Find Related Questions by Tags, levels, etc.

Report an error

You're reporting an error for "MA – May 2020 – L2 – Q2b – Cash budgets and master budgets"

CSEG – Nov 2018 – L2 – Q1- Analysing the internal environment

Analyzing the internal environment, Strategic management process, Financial planning and forecasting, Liquidity management, Long-term capital raising

GHANA’S FOOTWEAR MANUFACTURING INDUSTRY

Introduction:

The footwear industry has many players including artisanal shoemakers, local and foreign manufacturers, with local representatives, producing a wide range of footwear. In Ghana, the footwear industry is making headway in the local market, with most of the shoes being produced in Kumasi. The Kumasi Shoe Manufacturing Company focuses on making footwear for almost all the security agencies in Ghana, as well as some private security companies. The local market is also filled with individual artisans and small startup companies who make footwear for sale in the country. The other regions in the country such as the Greater Accra Region and the Northern Region also have a few individuals who are into footwear manufacturing but on a smaller scale.

Foreign-produced footwears are of superior quality and attract skimming pricing compared to the locally produced ones. The sector is projected to have high growth potential with most of its forecasted sales to emanate from low-income segments with marginal and flat growth from middle and high-income segments respectively. The growth, among other things, will be fueled by the government’s free school uniform and sandals policy which is expected to be sourced from local manufacturers. In Ghana, luxury shoes are usually European or American brands. The luxury footwear production in Ghana is still a virgin market with a lot of potential once people start to believe in the high quality these Ghanaian brands can offer.

On average, it takes three to five years for local manufacturers to ramp up production significantly enough to drive down average fixed cost and attain utilization of full capacity due to intense competition and difficulty accessing the major wholesale and retail outlets trading in footwears. The foreign as well as a good number of local manufacturers sign 5 to 10 years contract with major outlets in all the major urban centres for exclusive rights to sell their footwears.

The artisanal shoemakers generally produce based on customer orders. In the Footwear industry, customers easily source from many available alternatives. The key customers of foreign and local manufacturers are the various wholesale and retail outlets. There are emerging online shops providing information on prices of goods and services from different manufacturers including footwears free of charge and consumers can easily access that information. The profit margins for the outlets are generally low. There have been recent acquisitions of some local footwear manufacturing companies by some major wholesale and retail distributors in Ghana and the experts are predicting more of such transactions.

In Ghana, there is a cartel of few major importers, controlling approximately 90% of high-quality natural and synthetic leather markets, from whom many local manufacturers and artisanal shoemakers procure their raw materials. These importers source their supplies largely from Europe, which compares favourably, in terms of quality and price, to those available in neighbouring countries. A recent consumer survey indicates that footwear produced with inputs from Europe are durable, of good quality and able to stand high-temperature conditions locally hence consumer preference.

Footwear Ventures Ltd (FVL)

Footwear Ventures Ltd (FVL) was founded by Peter Legubo, who graduated with a bachelor’s degree in Fine Arts, from a public university in Ghana. Prior to starting the company, Peter met one of his schoolmates, who owned a business that specialized in traditional handicrafts including footwear. He was able to convince him to join FVL. The schoolmate’s hands-on experience coupled with Peter’s competence in drawing and designing will be complementary and indispensable to gaining competitive edge. The initial capital for the company was raised from personal savings and severance package received by Peter from his former employment. He was able to acquire requisite tools and machines for the production of footwear.

Based on the determination and ambition of the founder, FVL outdoored its first production line with four different products including shoes and sandals for men, women, children as well as boots for security personnel. The products were well received by the public. The company continued production but it could hardly produce the quantity required by its retailers due to inadequate funding. Peter, therefore, approached some banks for credit facility but due to lack of credit history he was unsuccessful. Peter Legubo decided to turn to his friend, Kingsford Yeboah, who lived in Germany and had earlier expressed interest in investing in the business. Kingsford provided the business with a substantial amount of cash. The capital injection was used to buy more tools and machines in a bid to significantly automate the production process. Additional hands were engaged bringing the total number of employees to 100. Currently, the company produces on average 2,200 pairs of shoes per month.

The main raw materials for footwear, including natural and synthetic leather, synthetic sole and adhesive, are sourced from local importers. FVL is contemplating diversifying its raw materials. The shoes produced by the company are largely distributed through major retail shops dotted across major urban centres since FVL does not have the required resources to open its own sales outlets. The company also does direct sales to students on campuses of some tertiary institutions in the country.

On strategic approach, Peter believes the company should continue to exclusively rely on the engagement of experienced hands from the industry and should waste no time in formalizing and documenting the company’s strategy. Kingsford Yeboah also believes that the company should institutionalize a strategic approach that should focus on the strategy process, financial planning and forecasting as well as sources of finances.

Financial planning and forecasting

FVL has the potential of becoming a leading producer of footwear in the Ghanaian market. It is however faced with liquidity challenges. The management of FVL has decided to prepare a six-month budget in order to better manage its liquidity needs and avoid any shortages, especially in the light of limited access to bank credit.

Financial data

FVL has planned production and sales for the next nine months as follows:

Month April May June July August September October November December
Production (Units) 700 800 1,000 1,200 1,200 1,400 1,500 1,500 1,500
Sales (Units) 700 800 800 1,000 1,200 1,300 1,400 1,600 1,500

During the period, the business plans to advertise so as to achieve the projected sales. Payments for advertising of GH¢12,000 and GH¢18,000 will be made in June and September respectively. The selling price per unit will be GH¢120 throughout the period. 40% of sales are normally made on two months’ credit. The other 60% are settled within the month of the sale.

Raw materials used for the footwear will be held for one month before they are taken into production. Purchases of raw materials will be on one month’s credit. The cost of raw materials is GH¢60 per unit of production. Other direct production expenses, including labour, are GH¢25 per unit. These will be paid in the month incurred. Various production overheads, which during the period to 30 May had run at GH¢21,600 a month, are expected to rise to GH¢24,000 each month from 1 June to 30 September. These are expected to rise again from 1 October to GH¢28,800 a month and to remain at that level for the foreseeable future. These overheads include a steady GH¢4,800 each month for depreciation. Overheads are planned to be paid 80% in the month of production and 20% in the following month.

To help meet the planned increased production, a new item of plant will be bought and delivered in July. The cost of this item is GH¢79,200; the contract with the supplier will specify that this will be paid in three equal installments in August, September, and October. Raw materials inventories are planned to be 1,000 units on 1 June. The balance at the bank on the same day is planned to be GH¢89,000. The company earns 5% interest on the closing balance, which is paid in the following month.

Required:

a) Analyze the strengths and weaknesses of FVL. (6 marks)

b) Prepare a report to the Director of FVL on the process of strategic management. (8 marks)

c) Prepare a cash budget for the six months ending 30 November based on the financial data of FVL. Show all workings. (12 marks)

d) Recommend to the Directors of FVL FOUR (4) strategies for overcoming the liquidity crisis. (8 marks)

e) Advise the directors of FVL FOUR (4) methods of raising long-term capital. (6 marks)

Login or create a free account to see answers

Find Related Questions by Tags, levels, etc.

Report an error

You're reporting an error for "CSEG – Nov 2018 – L2 – Q1- Analysing the internal environment"

error: Content is protected !!
Oops!

This feature is only available in selected plans.

Click on the login button below to login if you’re already subscribed to a plan or click on the upgrade button below to upgrade your current plan.

If you’re not subscribed to a plan, click on the button below to choose a plan