Cost Accounting

profilebappi
Solution.xlsx
Home>Business & Finance homework help>Accounting homework help>Cost Accounting

Sheet1

ORGANIZATION BUDGET
Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec Total
Selling volume 276,718 242,128 380,487 172,949 103,769 518,846 484,257 207,539 415,077 553,436 69,180 3,424,385
Production volume 276,718 242,128 380,487 172,949 103,769 518,846 484,257 207,539 415,077 553,436 69,180 34,590 3,458,975
Sales - 0 2,441,482.91 2,136,297.55 3,357,039.01 1,525,926.82 915,556.09 4,577,780.46 4,272,595.10 1,831,112.19 3,662,224.37 4,882,965.83 610,370.73 30,213,351.06
Expenses
RM 371,327.88 324,911.90 510,575.84 232,079.93 139,247.96 696,239.78 649,823.80 278,495.91 556,991.83 742,655.77 92,831.97 46,415.99 4,641,598.55
DL 801,292.31 701,130.77 1,101,776.93 500,807.70 300,484.62 1,502,423.09 1,402,261.55 600,969.23 1,201,938.47 1,602,584.63 200,323.08 100,161.54 10,016,153.91
OH Variable
repair parts 43,389.38 37,965.71 59,660.40 27,118.36 16,271.02 81,355.09 75,931.42 32,542.04 65,084.07 86,778.76 10,847.35 5,423.67 542,367.28
Machine electricity 166,058.47 145,301.16 228,330.40 103,786.54 62,271.93 311,359.63 290,602.33 124,543.85 249,087.71 332,116.94 41,514.62 20,757.31 2,075,730.90
209,447.85 183,266.87 287,990.80 130,904.91 78,542.95 392,714.73 366,533.74 157,085.89 314,171.78 418,895.71 52,361.96 26,180.98 2,618,098.18
OH Fixed
Plant depreciation 112,915.42 112,915.42 112,915.42 112,915.42 112,915.42 112,915.42 112,915.42 112,915.42 112,915.42 112,915.42 112,915.42 112,915.42 1,354,985.00
Plant electricity 82,291.67 82,291.67 82,291.67 82,291.67 82,291.67 82,291.67 82,291.67 82,291.67 82,291.67 82,291.67 82,291.67 82,291.67 987,500.00
management salaries 253,823.25 253,823.25 253,823.25 253,823.25 253,823.25 253,823.25 253,823.25 253,823.25 253,823.25 253,823.25 253,823.25 253,823.25 3,045,879.00
mecanic salaries 127,165.33 127,165.33 127,165.33 127,165.33 127,165.33 127,165.33 127,165.33 127,165.33 127,165.33 127,165.33 127,165.33 127,165.33 1,525,984.00
Phone 43,723.75 43,723.75 43,723.75 43,723.75 43,723.75 43,723.75 43,723.75 43,723.75 43,723.75 43,723.75 43,723.75 43,723.75 524,685.00
Tools 47,414.50 47,414.50 47,414.50 47,414.50 47,414.50 47,414.50 47,414.50 47,414.50 47,414.50 47,414.50 47,414.50 47,414.50 568,974.00
Rent 223,246.17 223,246.17 223,246.17 223,246.17 223,246.17 223,246.17 223,246.17 223,246.17 223,246.17 223,246.17 223,246.17 223,246.17 2,678,954.00
Insurance 28,694.23 28,694.23 28,694.23 28,694.23 28,694.23 28,694.23 28,694.23 28,694.23 28,694.23 28,694.23 28,694.23 28,694.23 344,330.80
City taxes 43,041.35 43,041.35 43,041.35 43,041.35 43,041.35 43,041.35 43,041.35 43,041.35 43,041.35 43,041.35 43,041.35 43,041.35 516,496.20
962,315.67 962,315.67 962,315.67 962,315.67 962,315.67 962,315.67 962,315.67 962,315.67 962,315.67 962,315.67 962,315.67 962,315.67 11,547,788.00
Net Result (2,344,383.72) 269,857.70 (726,361.69) 1,530,930.81 45,335.64 (2,638,137.17) 1,196,845.71 2,273,728.39 (1,204,305.56) (64,227.40) 3,575,133.15 (524,703.44) 1,389,712.42