Cost Accounting

bappi
QuastionofSolution.xlsx

Sheet1

Prepare the organization annual budget. Please respect the following instructions :
1) 12 months budget (January to December)
2) Manufacturing cost = RM (1.3419$/unit), DL (2.8957$/unit), OH Variable (0.7569$/unit), OH Fixed (3.3385$/unit)
3) Selling price = above manufacturing cost + 0.49$
4) The annual production volume is 3.458,975 units broken as followed
Month-1 8%
Month-2 7%
Month-3 11%
Month-4 5%
Month-5 3%
Month-6 15%
Month-7 14%
Month-8 6%
Month-9 12%
Month-10 16%
Month-11 2%
Month-12 1%
5) Fixed costs detail (cost per year)
Plant depreciation 1,354,985
Plant electricity 987,500
management salaries 3,045,879
mecanic salaries 1,525,984
Phone 524,685
tools 568,974
rent 2,678,954
40% of the balance = insurance
60% of the balance = city taxes
These expenses are evenly distributed among the months
You must show these detailed expenses in the budget
6) Variable costs detail
repair parts - variable 0.1568 $/unit
The balance is the Machine electricity
You must show these detailed expenses in the budget
7) Assume all the quantities produced are sold in the following month
Therefore there are no sales in January