1. ABC Ltd. Furnishes the following particulars for preparation of its budgets for the year 2019

Particulars	Amount (AED)
Sale of Pens	8,000,000
Sale of Copy	2,000,000
Direct Material Cost	4% of sales
Direct Wages	100,000
Remuneration of factory manager	1,000 per month
Stores and spares	1% on sales
Depreciation on plant and machinery	2,000
Light and power	5,000
Factory repairs and maintenance	6,000
Other factory expenses	1 % on direct wages
Administrative, selling and distribution expenses	15,000 per annum

You are required to prepare a Master Budget for the year 2019.

Note: The Answer should be in word or excel format