Zambeka limited is a modern company that offers customised products to its clients. The company has received some seed fund (cash) that will be used as equity capital amounting to ZMW150, 000 on January 1 2023. You have just been engaged by the company to prepare a cash budget for the first three months of the 2023 using the information given below: The Budgeted sales for the first quarter of 2023 are expected to be ZMW240, 000. Since the company will be launching the same year, sales are expected to gradually pick as product awareness increases. It is assumed that 15% of the first quarter sales will be in January, 30% in February and the remainder in March. If these projections hold it is anticipated that annual sales in 2023 will be ZMW1, 000,000. Clients must pay a deposit of 5% of the price when the order is made. Payments of 45% and 50% of the order price will be paid in month one and month two following the month of sale. The company does not plan for any defaulting customers (Bad Debts). The company will employ six staff and each will be paid ZMW4,500 at the end of each month. The company plans to procure materials for the jobs for a value of ZMW 100,000 in January. A deposit of 25% is payable on collections and the balance is paid in equal instalments in February and March. The company will rent offices at a cost of ZMW6, 500 per month paid three months in advance at the start of the lease contract. The landlord charges a security deposit of 10% for each of three month’s rent. The production costs are paid in the month they are incurred and have been budget as follows: January ZMW 1,300 February ZMW 4,200 March ZMW 8,000 The company plans to spend ZMW 10,000 on marketing and advertising in January 2023 and a further ZMW5, 000 in the same area in March 2023. Administration overheads are budgeted at ZMW500 per month: 60% is paid in the month of usage and the balance one month later. Fixed assets will be depreciated at 25% per annum of the initial investment capital. Required: a.Prepare the Cash Budget by month for the first quarter of 2016. b.Identify and comment on those areas of the cash budget that you wish to draw to the attention of management and recommend action to be taken.
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
QUESTION ONE
Zambeka limited is a modern company that offers customised products to its clients. The company has received some seed fund (cash) that will be used as equity capital amounting to ZMW150, 000 on January 1 2023.
You have just been engaged by the company to prepare a
- The Budgeted sales for the first quarter of 2023 are expected to be ZMW240, 000. Since the company will be launching the same year, sales are expected to gradually pick as product awareness increases. It is assumed that 15% of the first quarter sales will be in January, 30% in February and the remainder in March. If these projections hold it is anticipated that annual sales in 2023 will be ZMW1, 000,000.
- Clients must pay a deposit of 5% of the price when the order is made. Payments of 45% and 50% of the order price will be paid in month one and month two following the month of sale. The company does not plan for any defaulting customers (
Bad Debts ). - The company will employ six staff and each will be paid ZMW4,500 at the end of each month.
- The company plans to procure materials for the jobs for a value of ZMW 100,000 in January. A deposit of 25% is payable on collections and the balance is paid in equal instalments in February and March.
- The company will rent offices at a cost of ZMW6, 500 per month paid three months in advance at the start of the lease contract. The landlord charges a security deposit of 10% for each of three month’s rent.
- The production costs are paid in the month they are incurred and have been budget as follows:
January ZMW 1,300
February ZMW 4,200
March ZMW 8,000
- The company plans to spend ZMW 10,000 on marketing and advertising in January 2023 and a further ZMW5, 000 in the same area in March 2023.
- Administration
overheads are budgeted at ZMW500 per month: 60% is paid in the month of usage and the balance one month later. - Fixed assets will be
depreciated at 25% per annum of the initial investment capital.
Required:
a.Prepare the Cash Budget by month for the first quarter of 2016.
b.Identify and comment on those areas of the cash budget that you wish to draw to the attention of management and recommend action to be taken.
Step by step
Solved in 2 steps with 2 images