Q.1 The budget department of ABC Ltd., gathered the following information for preparing its budgets for forthcoming period.

1. Sales forecast.

Product Sales Quantity Selling price Inventories 01-01-2019 31-12-2019

Product-A 30,000 units Rs. 30 per unit. 5,000 units 10,000 units

Product-B 40,000 units Rs. 40 per unit. 10,000 units 15,000 units

Materials Purchase budget.

2. Material Product Inventories

A B 01-01-2019 31-12-2019 Price per kg

Materials-X 2kg 1kg 25,000kg 30,000kg Rs.2.0

Materials-Y 1kg 3kg 10,000 kg 15,000 kg Rs.1.0

3. Labor budget.

Hour per unit Rate per hour

Product A 2 hours Rs 5 per hour

Product-B 3 hours Rs. 4 per hour

4. Factory Overhead

Factory overhead rate is Rs.2 per direct labor hour.

Required:-

1. Prepare Sales budget product wise and total.
2. Production budget in quantity product wise and total.
3. Purchase budget in quantity and Rupees.
4. Labor cost budget Rupees.
5. Factory overhead budget Rupees.
6. Manufacturing cost per unit of product-A, B and C.
7. Discuss the behavioral issues that you may face while implementing budgeting in Pakistani environment.

Q.2 ABC Ltd., has been facing cash shortage problem for many years. You have just joined the company and made the proposal to prepare cash budget for controlling of cash shortage problem. Management has given you the green signal to prepare the cash budget and made the projection for requirement of cash through commercial bank channel in the coming period. The following information were gathered for preparing the cash budget.

1. Sales budgets

November, 2019. Rs.200,000

December, 2019 300,000

January, 2020.. 400,000

February, 2020 500,000

March, 2020.. 600,000

All sales are made on credit basis and customers follow the following patter to pay;

1. 40 % pay in the month of sales.
2. 50 % in the following month of sales.
3. 10 % pay in the second month of sales.

2. Purchase budgets

3. Purchases are made equal to 60 % of the respective month sales at beginning of the month. 50% of purchase amount is paid in the month of purchases and 50% in the following month of purchases
4. Cash operating expenses per month is estimated Rs.80,000.
5. Dividend is expected to be paid Rs.100,000 in the month of January, 2020.
6. Tax is to be paid Rs.50,000 in the month of march, 2020.
7. A new plant costing Rs. 250,000 to be purchased in the month of Feb.,2020.
8. Cash on hand on 1^st January, 2020 is Rs.100,000.
9. A minimum cash balance of Rs.150,000 to be maintained from 31^st January,2020 on ward, company has made arrangement with the local bank a line of credit to meet its cash requirement and if excess cash available it would be paid to bank to pay the loan.

Required: Prepare a cash budget for the month of January, February, March, 2020.