Management Accounting
Tazim
ManagementAccountingAssingment.xlsxSchedule 1,2 & 3
| Schedule 1 | |||||||
| Resources Cost Categories and Resource Drivers | |||||||
| Cost Category | Cost | Resource Driver | Cost Per resource driver | Total Employees | 121 | ||
| Wages | $ 6,975,000.0000 | number of employees | $ 57,644.6281 | Total floor Space | 6700 | ||
| Building Costs | $ 1,860,000.0000 | Floor Space | $ 277.6119 | Total machince hours | 12300 | ||
| Depreciation | $ 1,240,000.0000 | Machice Hourse | $ 100.8130 | Total Orders | 560 | ||
| Consumable | $ 62,000.0000 | Orders Places by centre | $ 110.7143 | Total kilowatt hrs | 924000 | ||
| Energy | $ 260,400.0000 | Kilowatt hours used | $ 0.2818 | ||||
| Other | $ 62,000.0000 | number of employees | $ 512.3967 | ||||
| Total | $ 10,459,400.0000 | ||||||
| Schedule 2 | |||||||
| Cost Category | Wages | Building Cost | Depreciation | Consumeables | Energy | Other | |
| Activity Centres | Employees $ | per m2 $ | Machine hours $ | Orders $ | Kilowatt Hours $ | Employees | |
| Product Develpoment | $ 172,933.8843 | $ 83,283.5821 | $ - 0 | $ 1,107.1429 | $ 2,818.1818 | $ 1,537.1901 | |
| Sales and Distribution | $ 691,735.5372 | $ 194,328.3582 | $ - 0 | $ 1,107.1429 | $ 3,381.8182 | $ 6,148.7603 | |
| Inspecting | $ 115,289.2562 | $ 194,328.3582 | $ - 0 | $ 1,107.1429 | $ 3,381.8182 | $ 1,024.7934 | $ 315,131.3688 |
| Blending | $ 1,786,983.4711 | $ 360,895.5224 | $ 493,983.7398 | $ 21,035.7143 | $ 70,454.5455 | $ 15,884.2975 | |
| Boiling | $ 1,786,983.4711 | $ 360,895.5224 | $ 625,040.6504 | $ 13,285.7143 | $ 104,272.7273 | $ 15,884.2975 | |
| Moulding and Packaging | $ 1,383,471.0744 | $ 360,895.5224 | $ 120,975.6098 | $ 21,035.7143 | $ 70,454.5455 | $ 12,297.5207 | |
| Administration | $ 691,735.5372 | $ 194,328.3582 | $ - 0 | $ 2,214.2857 | $ 2,818.1818 | $ 6,148.7603 | |
| Corporate Manegement | $ 345,867.7686 | $ 111,044.7761 | $ - 0 | $ 1,107.1429 | $ 2,818.1818 | $ 3,074.3802 | |
| Total | $ 6,975,000.0000 | $ 1,860,000.0000 | $ 1,240,000.0000 | $ 62,000.0000 | $ 260,400.0000 | $ 62,000.0000 | $ 10,459,400.0000 |
| Schedule 3 | |||||||
| Activity | Labour time | Labour Cost | Percentage of floor space | Floor space cost | Orders placed | Orders Cost | total Cost |
| Inspect ingredients | 30% | $ 34,894.2149 | 50% | $ 98,855.0882 | 0% | $ - 0 | $ 133,749.3031 |
| Disposal of substandard ingredients | 10% | $ 11,631.4050 | 10% | $ 19,771.0176 | 30% | $ 332.1429 | $ 31,734.5655 |
| Move to mixing room | 10% | $ 11,631.4050 | 10% | $ 19,771.0176 | 0% | $ - 0 | $ 31,402.4226 |
| Inspect finished products | 30% | $ 34,894.2149 | 10% | $ 19,771.0176 | 0% | $ - 0 | $ 54,665.2325 |
| Disposal of substandard products | 10% | $ 11,631.4050 | 10% | $ 19,771.0176 | 30% | $ 332.1429 | $ 31,734.5655 |
| Reports to Health Dept | 10% | $ 11,631.4050 | 10% | $ 19,771.0176 | 40% | $ 442.8571 | $ 31,845.2797 |
| Total | 100% | $ 116,314.0496 | 100% | $ 197,710.1764 | 100% | $ 1,107.1429 | $ 315,131.3688 |
Schedule 4
| Schedule 4 | |||||
| List of activities | |||||
| Activity | Activity cost | Activity driver | Quantity of activity driver | Activity Cost/Quantity Driver | |
| Corporate management | $ 345,868.0000 | Assigned directly to products | |||
| Process receivables | $ 358,898.0000 | No. of invoices | 6,200 | invoices | $ 57.8868 |
| Process payables | $ 339,183.0000 | No. of purchase orders | 3,100 | Purchase Orders | $ 109.4139 |
| Production planning | $ 199,164.0000 | No. of production schedules | 1,240 | Production Schedules | $ 160.6161 |
| Reports to Health Dept | $ 31,845.2797 | No. of reports | 1,240 | reports | $ 25.6817 |
| Process sales order | $ 574,858.0000 | No. of sales orders | 4,960 | sales orders | $ 115.8988 |
| Dispatch sales order | $ 318,462.0000 | No. of dispatches | 3,100 | dispatches | $ 102.7297 |
| Product Development | $ 172,934.0000 | Assigned directly to new products lines | |||
| Inspect ingredients | $ 133,749.3031 | No. of batches | 1,240 | batches | $ 107.8623 |
| Disposal of substandard ingredients | $ 31,734.5655 | No. of batches | 1,240 | batches | $ 25.5924 |
| Move to mixing room | $ 31,402.4226 | No. of batches | 1,240 | batches | $ 25.3245 |
| Set up blender | $ 198,332.0000 | No. of batches | 1,240 | batches | $ 159.9452 |
| Weigh and sort ingredients | $ 198,332.0000 | No. of batches | 1,240 | batches | $ 159.9452 |
| Load blender | $ 1,559,248.0000 | No. of kilograms | 248,000 | kilograms | $ 6.2873 |
| Operate blender | $ 378,618.0000 | No. of batches | 1,240 | batches | $ 305.3371 |
| Unload and Clean blender | $ 198,332.0000 | No. of batches | 1,240 | batches | $ 159.9452 |
| Move to filling room | $ 216,376.0000 | No. of batches | 1,240 | batches | $ 174.4968 |
| Set up scales | $ 108,188.0000 | No. of batches | 1,240 | batches | $ 87.2484 |
| Weigh ingredients | $ 198,332.0000 | No. of batches | 1,240 | batches | $ 159.9452 |
| Load boiling vats | $ 396,663.0000 | No. of batches | 1,240 | batches | $ 319.8895 |
| Coagulate, Drain and Scald | $ 1,860,570.0000 | No. of kilograms | 248,000 | kilograms | $ 7.5023 |
| Drain and clean vats | $ 216,376.0000 | No. of batches | 1,240 | batches | $ 174.4968 |
| Move to moulding room | $ 126,233.0000 | No. of kilograms | 248,000 | kilograms | $ 0.5090 |
| Load hopper | $ 439,166.0000 | No. of products | 992,000 | products | $ 0.4427 |
| Set up moulds and packaging | $ 157,622.0000 | No. of trays | 19,840 | trays | $ 7.9447 |
| Move to moulder | $ 87,833.0000 | No. of trays | 19,840 | trays | $ 4.4271 |
| Mould products and package | $ 1,090,798.0000 | No. of trays | 19,840 | trays | $ 54.9797 |
| Unload moulder | $ 87,833.0000 | No. of trays | 19,840 | trays | $ 4.4271 |
| Inspect finished products | $ 54,665.2325 | No. of trays | 19,840 | trays | $ 2.7553 |
| Disposal of substandard product | $ 31,734.5655 | No. of trays | 19,840 | trays | $ 1.5995 |
| Move to truck | $ 105,878.0000 | No. of trays | 18,850 | Finished trays | $ 5.6169 |
| Total | $ 10,249,228.3688 | ||||
Fudge
| Schedule 5 | |||
| Fudge | |||
| Activities consumed | Quantity of activity driver | Cost | |
| Corporate management | $93,063 | Assigned directly to products | $93,063 |
| Process receivables | 600 | invoices | 34732.064516129 |
| Process payables | 200 | purchase orders | 21882.7741935484 |
| Production planning | 170 | production schedules | 27304.7419354839 |
| Reports to Health Dept | 170 | reports | 4365.8851257291 |
| Process sales order | 620 | sales orders | 71857.25 |
| Dispatch sales order | 500 | dispatches | 51364.8387096774 |
| Product Development | $0 | Assigned directly to new products lines | |
| Inspect ingredients | 170 | batches | 18336.5980017269 |
| Disposal of substandard ingredients | 170 | batches | 4350.7065543005 |
| Move to mixing room | 170 | batches | 4305.1708400148 |
| Set up blender | 170 | batches | 27190.6774193548 |
| Weigh and sort ingredients | 170 | batches | 27190.6774193548 |
| Load blender | 49,750 | kilograms | 312792.693548387 |
| Operate blender | 170 | batches | 51907.3064516129 |
| Unload and Clean blender | 170 | batches | 27190.6774193548 |
| Move to filling room | 170 | batches | 29664.4516129032 |
| Set up scales | 170 | batches | 14832.2258064516 |
| Weigh ingredients | 170 | batches | 27190.6774193548 |
| Load boiling vats | 170 | batches | 54381.2177419355 |
| Coagulate, Drain and Scald | 49,750 | kilograms | 373239.344758064 |
| Drain and clean vats | 170 | batches | 29664.4516129032 |
| Move to moulding room | 49,750 | kilograms | 25322.9506048387 |
| Load hopper | 198,400 | products | 87833.2 |
| Set up moulds and packaging | 1,990 | trays | 15809.8679435484 |
| Move to moulder | 1,990 | trays | 8809.8623991935 |
| Mould products and package | 1,990 | trays | 109409.678427419 |
| Unload moulder | 1,990 | trays | 8809.8623991935 |
| Inspect finished products | - | trays | |
| Disposal of substandard product | - | trays | |
| Move to truck | 1,990 | Finished trays | 11177.5713527851 |
| 1480917.4242 | |||
| Direct Materials | $2 | per kilogram | |
| Current Market Selling Price | $9 | per unit of product | |
| Batch size | 1,200 | ||
| Annual Volume | 199,000 |
Almond Nougat
| Schedule 6 | |||
| Almond Nougat | |||
| Activities consumed | Quantity of activity driver | Cost per activity $ | |
| Corporate management | $ 11,224.0000 | Assigned directly to products | $ 11,224.0000 |
| Process receivables | 200 | invoices | $ 11,577.3548 |
| Process payables | 100 | purchase orders | $ 10,941.3871 |
| Production planning | 60 | production schedules | $ 9,636.9677 |
| Reports to Health Dept | 60 | reports | $ 1,540.9006 |
| Process sales order | 190 | sales orders | $ 22,020.7702 |
| Dispatch sales order | 100 | dispatches | $ 10,272.9677 |
| Product Development | $ 86,354.0000 | Assigned directly to new products lines | $ 86,354.0000 |
| Inspect ingredients | 50 | batches | $ 5,393.1171 |
| Disposal of substandard ingredients | 50 | batches | $ 1,279.6196 |
| Move to mixing room | 50 | batches | $ 1,266.2267 |
| Set up blender | 50 | batches | $ 7,997.2581 |
| Weigh and sort ingredients | 50 | batches | $ 7,997.2581 |
| Load blender | 12,000 | kilograms | $ 75,447.4839 |
| Operate blender | 50 | batches | $ 15,266.8548 |
| Unload and Clean blender | 50 | batches | $ 7,997.2581 |
| Move to filling room | 50 | batches | $ 8,724.8387 |
| Set up scales | 50 | batches | $ 4,362.4194 |
| Weigh ingredients | 50 | batches | $ 7,997.2581 |
| Load boiling vats | 50 | batches | $ 15,994.4758 |
| Coagulate, Drain and Scald | 12,000 | kilograms | $ 90,027.5806 |
| Drain and clean vats | 50 | batches | $ 8,724.8387 |
| Move to moulding room | 12,000 | kilograms | $ 6,108.0484 |
| Load hopper | 24,800 | products | $ 10,979.1500 |
| Set up moulds and packaging | 500 | trays | $ 3,972.3286 |
| Move to moulder | 500 | trays | $ 2,213.5333 |
| Mould products and package | 500 | trays | $ 27,489.8690 |
| Unload moulder | 500 | trays | $ 2,213.5333 |
| Inspect finished products | 500 | trays | $ 1,377.6520 |
| Disposal of substandard product | 500 | trays | $ 799.7622 |
| Move to truck | 480 | Finished trays | $ 2,696.0976 |
| $ 479,894.8101 | |||
| Direct Materials | $4 | per kilogram | |
| Current Market Selling Price | $13 | per unit of product | |
| Batch size | 500 | ||
| Annual Volume | 24,000 |
