In: Accounting
| 
 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

If you are benefited from the solution then please LIKE , if disliked then please specify the reason in the comments .