1. (a) Explain the steps for coming up with a production budget. [10 marks]
(b) An agri-firm has a total fixed cost (TFC) of K200,000 per year, an average unit cost of K800 per unit and an average revenue (AR) of K1,200 per unit. You are required to budget for the following:
(i) Breakeven point for this firm [2 marks]
(ii) Gross profit of K850,000 [4 marks]
(iii) Breakeven and Gross profit if average cost
rises K1,000 [4 marks]
2. A fresh milk firm supplies the commodity through 4 channels. Information for each channel is given below.
Channel
1
2
3
4
Sales
300
350
450
420
Returns inwards
20
50
40
40
Opening stock
30
10
40
20
New supplies
100
100
100
100
Unsold stock
40
60
40
20
Expenses
40
50
40
60
Tax
5
5
4
8
You are required to identify the best channel for this
firm. What must it do to raise productivity for poor
channels. (10)
3. The projected financial information for Nalungwe Fertilizer Marketing Co. for the period April, 2019 to March, 2020, has the following information based on market research:
The company intends to import 200 metric tonnes of fertilizers in June at a cost of K200 per 50kg bag. The sales of all the 200 metric tonnes will run from August to December as follows: 5% of sales will be in August, 15% in September, 25% in October, 45% in November, and 10% in December. Fertilizer prices expected to be K260 per 50kg bag in August and September. In October and November, prices will be K280 per 50kg bag. And in December, they will come down to K275 per 50kg bag. 50% of sales in December will be on credit due to low demand and people will settle their debts in February. Wages are K8000 per month, repairs K4000 in March, June, September, and December. Mukelabai estimates drawings at K15,000 in July. The firm will pay storage costs of K20,000 in April and 20% of the costs will be financed from a bank overdraft payable in March, 2020. The firm will sell some used vehicles in August at K55,000. Tax is paid once a year in April at K2,500 and bank interest of K2,000 on the bank overdraft will be paid together with the overdraft in March, 2020. Moreover, the firm will buy a delivery truck worth K80,000 in June. The company donates K1,000 per month to charitable organizations.
Prepare a cash flow for this firm
(6)
Suggest how to manage the business of this
company.
(4)
4. A farmer intends to go into wheat production from May 2016 to September 2016 on its 60 ha of farm land. He/she will spend K800/ha on planting in May, K600/ha on seed in May, K500/ha on fertilizer in May and June, K3000/month on electricity, K5000/month on wages, K1000.month on charity, K25000/month on family livelihood, K2000/ha on harvesting in September, and K200000 on tax in September. The farmer will realise 6 tonnes/ha at US$500/tonne of sold wheat in September. (Assume the exchange rate to be K8.00=US$1.00).
(a) Prepare a cash flow for this farmer. [10 marks]
(b) Determine periods of surpluses and deficits. [5 marks]
(c) If the farmer
will finance the deficits from one bank loan with interest of 18%
per annum, what will the farmer’s net income at the end of
September?
[5 marks]
Need this information asap
Question 2 answer
Particulars | 1 | 2 | 3 | 4 | particulars | 1 | 2 | 3 | 4 |
opening stock | 30 | 10 | 40 | 20 | sales | 300 | 350 | 450 | 420 |
new supplies | 100 | 100 | 100 | 100 | less:returns inward | (20) | (50) | (40) | (40) |
expenses | 40 | 50 | 40 | 60 | closing stock | 40 | 60 | 40 | 20 |
gross profit(balancing amount) | 150 | 200 | 270 | 220 | |||||
total | 320 | 360 | 450 | 400 | 320 | 360 | 450 | 400 | |
tax | 5 | 5 | 4 | 8 | gross profit b/d | 150 | 200 | 270 | 220 |
net profit (balancing amount) | 145 | 195 | 260 | 212 |
Hence 3 rd channel is best for earning more .Remaining channels decrease their inward returns to increase their profits .
1. (a) Explain the steps for coming up with a production budget. [10 marks]...
1. (20 Marks Quolala is a merchandising company. Quolala expects unit sales for the coming year as follows: March 15,000 23.000 April 31,000 May 47,000 June 56,000 July The average selling price is P23 per unit. The company's policy is to maintain month-end inventory levels at 30% of next month's anticipated sales. All sales are made on credit and expected collections are as follows: 70% collected in the month of sale 20% collected in the month following the sale 10%...
PYHTON Try! Consider a dictionary for the month months Dictionary = { 1 : "January", 2 : "February", 3 : "March", 4: "April", 5 : "May", 6 : "June", 7 : "July", 8: "August", 9 : "September", 10 : "October", 11: "November", 12 : "December" } . Prints out all the items, both key and value, in the dictionary Prints out all the keys in the dictionary Prints out just the values in the dictionary Loops though using the keys...
Question 3 (10 marks) BBG Limited is now in the process of preparing its cash budget for October. The nning cash balance is $44,000. Budgeted cash receipts total $318,000 and budgeted cash disbursements total $344,000. The desired ending cash balance is $60,000. BBG can borrow up to $500,000 from Hang Seng Bank whenever they are in need of cash, with interest not due until the following month. Required: Prepare the BBG's cash budget for October in good form. Question 4...
AutoSaveff File Home InsertPage Layout Formulas Da D1 1 Year Month 2 1 13 17 1 January February 15 4 1 March 511 April 6 1 May 12 32 15 June 1 July 91 August 17 101 September33 15 October 12 1 November34 December 21 14 2 January26 15 2 February10 13 1 162 March 17 2 April 18 2 May 14 19 17 14 27 30 222 September25 June 21 2 23 2 25 27 3 29 3 August...
(Preparation of a cash budget) Lewis Printing has projected its sales for the first 8 months of 2016 as follows: January $140,000 April $300,000 July $200,000 February $100,000 May $255,000 August $200,000 March $170,000 June $180,000 Lewis collects 30 percent of its sales in the month of thesale, 40 percent in the month following the sale, and the remaining 30 percent 2 months following the sale. During November and December of 2015, Lewis's sales were...
Question 4 [12 marks] Sales of commercial elevators at Armsteel Co. over the 12 months were as below: Month Sales Month Sales January 898 July 900 February 1325 August 1502 March 1250 September 1311 April 1008 October 899 May 1497 November 1311 June 1186 December 1074 Use three-period weighted moving average with weights 0.5, 0.3, 0.2 (0.5 = most recent) to forecast the forecast for April and May. Show your works in the Excel. (label the tab in Excel spreadsheet...
Q4. (15 Marks) From the following information, prepare cash budget of a business firm for the month of April. (a) The firm makes 20 per cent cash sales. Credit sales are collected 40, 30 and 25 per cent in the month of sales, month after and second month after sales, respectively. The remaining 5 per cent becomes bad debts. (b) The firm has a policy of buying enough goods cach month to maintain its inventory at two and one-half times...
Front Page Video Games Corporation has forecasted the following monthly sales: January$99,000 July$44,000 February92,000 August44,000 March24,000 September54,000 April24,000 October84,000 May19,000 November104,000 June34,000 December122,000 Total sales = $744,000 The firm sells its Last Spike video game for $5 per unit, and the cost to produce the game is $2 per unit. A level production policy is followed. Each month's production is equal to annual sales (in units) divided by 12. Of each month's sales, 20 percent are for cash and 80...
(Cash budget) The Sharpe Corporation's projected sales for the first 8 months of 2016 are shown in the following table: January $170,000 May $280,000 February $100,000 June $250,000 March $115,000 July $205,000 April $220,000 August $130,000 Of Sharpe's sales, 30 percent is for cash, another 40 percent is collected in the month following the sales, and 30 percent is collected in the second month following sales. November and December sales for 2015 were $200,000 and $155,000, respectively. Sharpe...
SlippyLtd has been in business for several years. They are in the midst of preparing their quarterly budgets for the first three months starting on 1" January 2019. 1. Sales for November 2018 and December 2018were $75,000 and $83,000 respectively. Forecast sales for the first three months in 2019 are as follows: January 2019 $90,000 February 2019 $100,000 March 2019 $120,000 All sales are on the following terms: 20% on cash basis and remainder is on credit terms. All credit sales are on average are...