Question

In: Accounting

The following information relates to Kamelwa limited a retail grocer engaged in buying and selling of...

The following information relates to Kamelwa limited a retail grocer engaged in
buying and selling of foodstuffs.
(1) Budgeted sales (2021) : January K500,000
February K450,000
March K625,000
April K700,000
May K665,500
June K781,000
July K718,750
August K593,750
September K812,500
October K780,000
November K850,000
December K1,020,000
January (2022) K620,000(2) Kamelwa limited sells its purchases at cost plus 25% mark- up.
(3) Kamelwa has a policy to hold inventory at the end of each month which is
sufficient to meet sales demand in the next half month. Sales are budgeted to
occur evenly during each month.
(4) Purchases are paid for in the following manner: 50% in the month of purchase
and the remainder in the month after purchase.
(5) Sales are 85% on credit basis and 15% cash basis.
Credit sales are collected as follows: 60% in the month following the sale;
20% the second month after the sale and 20 % the third month after the sale.
(6) Labour is remunerated at 10% of cost of sales and is paid for in the month
that it is incurred.
(7) Overheads incurred in the production department are 70% of labour cost.
These overheads are paid 30% in the month they are incurred and the
balance the following month.
(8) An auction sale conducted on 29 December 2020 resulted into disposal of
property worth K600,000 which amount (cash) will be collected on 29 January
2021.
(9) The company will pay the last company tax balance for the period 2020 on 30
June 2021 amounting to K85,000.
REQUIRED
(a) Prepare Kamelwa’s limited cash budget for the year 2021.
(b) Discuss the circumstances under which each of the following budgets might
be used .
- Rolling budget
- Zero based budget ( 6 marks)

Solutions

Expert Solution


Related Solutions

The following information relates to Bailey Ltd a retail business selling office furniture. The table below...
The following information relates to Bailey Ltd a retail business selling office furniture. The table below provides the sales and purchases for the company: Actual Sales Actual Purchases October 2019 $38,000 $20,000 November 2019 $41,000 $24,000 December 2019 $48,500 $29,800 Budgeted Sales Budgeted Purchases January 2020 $54,000 $32,000 Additional information includes: Cash sales are 20% each month. Credit sales are expected to be collected 60% one month after sale, 20% two months after the sale and 15% 3 months after...
Retail Inventory Method Turner Corporation uses the retail inventory method. The following information relates to 2016:...
Retail Inventory Method Turner Corporation uses the retail inventory method. The following information relates to 2016: Cost Retail Cost Retail Inventory, January 1 $ 29,000 $ 45,000 Additional markups — $ 50,000 Purchases (gross price) 140,000 190,000 Markup cancellations — 10,000 Purchases discounts taken 3,000 — Markdowns — 15,000 Purchases returns 5,000 8,000 Markdown cancellations — 3,000 Freight-in 20,000 — Net Sales — 190,000 Employee discounts — 3,000 Required: 1. Compute the cost of the ending inventory under each of...
The following information relates to Tea Limited, a company that will commence business on 1 January...
The following information relates to Tea Limited, a company that will commence business on 1 January 2021. The company is preparing its budget for 2021 and will detail the projected activities for each quarter of the year. Information: 1. Cash at bank on 1 January 2021 amounted to R150 000. 2. Projected sales per quarter for 2021:           First quarter R750 000           Second quarter R825 000           Third quarter R930 000           Fourth quarter R980 000 Fifty percent (50%)...
The following information relates to Tea Limited, a company that will commence business on 1 January 2021.
  The following information relates to Tea Limited, a company that will commence business on 1 January 2021. The company is preparing its budget for 2021 and will detail the projected activities for each quarter of the year. Information: 1. Cash at bank on 1 January 2021 amounted to R150 000. 2. Projected sales per quarter for 2021: First quarter R750 000 Second quarter R825 000 Third quarter R930 000 Fourth quarter R980 000 Fifty percent (50%) of the sales...
QUESTION ONE The following information relates to the only product manufactured and sold by Namwela limited....
QUESTION ONE The following information relates to the only product manufactured and sold by Namwela limited. K per Unit Selling price 50 Direct Material cost 14 Direct labour cost 16 Variable production overhead 10 Fixed production overhead 1.80 Variable sales and marketing overhead 1.00 The following level of activity took place over the first two years of the product’s life: Sales ( units) production ( units) Year 1 13,000 14,000 Year 2 12,500 11,500 ADDITIONAL INFORMATION 1. Budgeted fixed production...
Question four (assume today is 30 December 2020) The following information relates to Kamelwa limited a...
Question four (assume today is 30 December 2020) The following information relates to Kamelwa limited a retail grocer engaged in buying and selling of foodstuffs. (1) Budgeted sales (2021) : January February March April May June July August September October November December January (2022) K500,000 K450,000 K625,000 K700,000 K665,500 K781,000 K718,750 K593,750 K812,500 K780,000 K850,000 K1,020,000 K620,000 Basic Super Delux 4 (2) Kamelwa limited sells its purchases at cost plus 25% mark- up. (3) Kamelwa has a policy to hold...
QUESTION ONE [25] The following financial information relates to Cams Limited. Statement of Financial Position as...
QUESTION ONE [25] The following financial information relates to Cams Limited. Statement of Financial Position as at 31 December 2017 and 2018 2018                                2017 Ordinary share capital Retained earnings Property, plant and equipment Investments Debentures 12.5%   Inventory Trade debtors Prepaid expenses Trade creditors Bank overdraft SARS (income tax) Shareholders for dividends                           400 000                             55 000                            230 000                           165 000                              20 000                           124 000                             37 000                               -                            25 000                             21...
QUESTION ONE [25] The following financial information relates to Cams Limited. Statement of Financial Position as...
QUESTION ONE [25] The following financial information relates to Cams Limited. Statement of Financial Position as at 31 December 2017 and 2018 2018                                2017 Ordinary share capital Retained earnings Property, plant and equipment Investments Debentures 12.5%   Inventory Trade debtors Prepaid expenses Trade creditors Bank overdraft SARS (income tax) Shareholders for dividends                           400 000                             55 000                            230 000                           165 000                              20 000                           124 000                             37 000                               -                            25 000                             21...
Presented below is information that relates to Halifax Limited for 2020:               Accounts Payable ...........................................................................................
Presented below is information that relates to Halifax Limited for 2020:               Accounts Payable ........................................................................................................ 49,000        Accounts Receivable .................................................................................................... 78,000        Bond Payable....................................................................................................... ..... 600,000        Cash dividends declared on common shares.................................................................... 34,000          Collections of credit sales....................................................................................... $1,100,000        Cost of goods sold.................................................................................................... 1,100,000        Equipment ................................................................................................................... 85,000        Gain from transactions in foreign currencies (pre-tax)................................................... 220,000               Inventory.................................................................................................................... 120,000          Loss on sale of equipment .......................................................................................... 350,000          Loss from early debt repayment .................................................................................. 340,000...
Presented below is information that relates to Halifax Limited for 2020:               Accounts Payable ...........................................................................................
Presented below is information that relates to Halifax Limited for 2020:               Accounts Payable ........................................................................................................ 49,000        Accounts Receivable .................................................................................................... 78,000        Bond Payable....................................................................................................... ..... 600,000        Cash dividends declared on common shares.................................................................... 34,000          Collections of credit sales....................................................................................... $1,100,000        Cost of goods sold.................................................................................................... 1,100,000        Equipment ................................................................................................................... 85,000        Gain from transactions in foreign currencies (pre-tax)................................................... 220,000               Inventory.................................................................................................................... 120,000          Loss on sale of equipment .......................................................................................... 350,000          Loss from early debt repayment .................................................................................. 340,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT