Assignment.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Assignment.xlsx as PDF for free.
More details
- Words: 392
- Pages: 4
COST ANALYSIS OF RO PLANT MANUFACTURING COMPANY SO SAFE S.NO MONTH OUTPUT TC TFC TVC AFC ATC 1 JAN 10 1,617,000.00 925,000.00 692,000.00 92,500.00 161,700.00 2 FEB 8 1,158,000.00 925,000.00 233,000.00 115,625.00 144,750.00 3 MAR 9 1,607,000.00 925,000.00 682,000.00 102,777.78 178,555.56 4 APR 8 1,549,500.00 925,000.00 624,500.00 115,625.00 193,687.50 5 MAY 10 1,617,000.00 925,000.00 692,000.00 92,500.00 161,700.00 6 JUN 15 1,946,200.00 1,235,000.00 711,200.00 82,333.33 129,746.67 7 JUL 11 1,634,400.00 925,000.00 709,400.00 84,090.91 148,581.82 8 AUG 14 1,828,000.00 1,125,000.00 703,000.00 80,357.14 130,571.43 9 SEP 11 1,629,500.00 925,000.00 704,500.00 84,090.91 148,136.36 10 OCT 10 1,609,000.00 925,000.00 684,000.00 92,500.00 160,900.00 11 NOV 9 1,606,400.00 925,000.00 681,400.00 102,777.78 178,488.89 12 DEC 10 1,604,500.00 925,000.00 679,500.00 92,500.00 160,450.00
Chart Title 500,000.00
MC,AFC,ATC
400,000.00 300,000.00 200,000.00 100,000.00 -
0
2
4
6
(100,000.00) OUTPUT
8
10
12
14
SO SAFE AVC MC 69,200.00 29,125.00 229,500.00 75,777.78 449,000.00 78,062.50 57,500.00 69,200.00 33,750.00 47,413.33 65,840.00 64,490.91 77,950.00 50,214.29 64,533.33 64,045.45 66,166.67 68,400.00 20,500.00 75,711.11 2,600.00 67,950.00 (1,900.00)
e
8
MC AFC ATC
10
12
14
FIXED COST PAYROLL RENT MARKETING INSURANCE BENEFITS (BONUS) OTHERS TOTAL
VARIABLE COST UTILITIES OVERTIMES FABRICATION COST OF SKID PLUMBING MATERIAL COST EMPLOYE FUELING ENTERTAINMENT EXPENSES TRANSPORTATION CHARGES VENDOR SERIVES TOTAL
JAN FEB MAR 620,000.00 620,000.00 620,000.00 200,000.00 200,000.00 200,000.00 30,000.00 30,000.00 30,000.00 75,000.00 75,000.00 75,000.00 925,000.00 925,000.00 925,000.00
FIXED COST ANALYSIS 2018 APR MAY JUNE JULY 620,000.00 620,000.00 620,000.00 620,000.00 200,000.00 200,000.00 200,000.00 200,000.00 30,000.00 30,000.00 30,000.00 30,000.00 75,000.00 75,000.00 75,000.00 75,000.00 310,000.00 925,000.00 925,000.00 1,235,000.00 925,000.00
VARIABLE COST ANALYSIS 2018 JAN FEB MAR APR MAY JUNE JULY 42,000.00 40,000.00 45,000.00 48,000.00 60,000.00 65,000.00 62,000.00 10,000.00 12,000.00 15,000.00 50,000.00 48,000.00 52,000.00 50,000.00 50,000.00 50,000.00 50,000.00 15,000.00 17,000.00 15,000.00 15,500.00 16,000.00 15,200.00 15,900.00 48,000.00 46,000.00 52,000.00 50,000.00 48,000.00 55,000.00 50,000.00 12,000.00 15,000.00 20,000.00 8,000.00 6,000.00 9,000.00 12,000.00 25,000.00 22,000.00 23,000.00 21,000.00 22,000.00 25,000.00 24,500.00 500,000.00 45,000.00 475,000.00 480,000.00 480,000.00 480,000.00 480,000.00 692,000.00 233,000.00 682,000.00 624,500.00 692,000.00 711,200.00 709,400.00
AUG SEP OCT NOV DEC 620,000.00 620,000.00 620,000.00 620,000.00 620,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 30,000.00 30,000.00 30,000.00 30,000.00 30,000.00 75,000.00 75,000.00 75,000.00 75,000.00 75,000.00 200,000.00 1,125,000.00 925,000.00 925,000.00 925,000.00 925,000.00
AUG 65,000.00 20,000.00 50,000.00 15,000.00 48,000.00 22,000.00 23,000.00 460,000.00 703,000.00
SEP OCT NOV DEC 58,000.00 54,000.00 50,000.00 45,000.00 12,000.00 50,000.00 50,000.00 50,000.00 50,000.00 15,000.00 15,000.00 15,000.00 15,000.00 54,000.00 48,000.00 49,000.00 49,500.00 14,000.00 15,000.00 16,000.00 18,000.00 21,500.00 22,000.00 21,400.00 22,000.00 480,000.00 480,000.00 480,000.00 480,000.00 704,500.00 684,000.00 681,400.00 679,500.00
Chart Title 500,000.00
MC,AFC,ATC
400,000.00 300,000.00 200,000.00 100,000.00 -
0
2
4
6
(100,000.00) OUTPUT
8
10
12
14
SO SAFE AVC MC 69,200.00 29,125.00 229,500.00 75,777.78 449,000.00 78,062.50 57,500.00 69,200.00 33,750.00 47,413.33 65,840.00 64,490.91 77,950.00 50,214.29 64,533.33 64,045.45 66,166.67 68,400.00 20,500.00 75,711.11 2,600.00 67,950.00 (1,900.00)
e
8
MC AFC ATC
10
12
14
FIXED COST PAYROLL RENT MARKETING INSURANCE BENEFITS (BONUS) OTHERS TOTAL
VARIABLE COST UTILITIES OVERTIMES FABRICATION COST OF SKID PLUMBING MATERIAL COST EMPLOYE FUELING ENTERTAINMENT EXPENSES TRANSPORTATION CHARGES VENDOR SERIVES TOTAL
JAN FEB MAR 620,000.00 620,000.00 620,000.00 200,000.00 200,000.00 200,000.00 30,000.00 30,000.00 30,000.00 75,000.00 75,000.00 75,000.00 925,000.00 925,000.00 925,000.00
FIXED COST ANALYSIS 2018 APR MAY JUNE JULY 620,000.00 620,000.00 620,000.00 620,000.00 200,000.00 200,000.00 200,000.00 200,000.00 30,000.00 30,000.00 30,000.00 30,000.00 75,000.00 75,000.00 75,000.00 75,000.00 310,000.00 925,000.00 925,000.00 1,235,000.00 925,000.00
VARIABLE COST ANALYSIS 2018 JAN FEB MAR APR MAY JUNE JULY 42,000.00 40,000.00 45,000.00 48,000.00 60,000.00 65,000.00 62,000.00 10,000.00 12,000.00 15,000.00 50,000.00 48,000.00 52,000.00 50,000.00 50,000.00 50,000.00 50,000.00 15,000.00 17,000.00 15,000.00 15,500.00 16,000.00 15,200.00 15,900.00 48,000.00 46,000.00 52,000.00 50,000.00 48,000.00 55,000.00 50,000.00 12,000.00 15,000.00 20,000.00 8,000.00 6,000.00 9,000.00 12,000.00 25,000.00 22,000.00 23,000.00 21,000.00 22,000.00 25,000.00 24,500.00 500,000.00 45,000.00 475,000.00 480,000.00 480,000.00 480,000.00 480,000.00 692,000.00 233,000.00 682,000.00 624,500.00 692,000.00 711,200.00 709,400.00
AUG SEP OCT NOV DEC 620,000.00 620,000.00 620,000.00 620,000.00 620,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 30,000.00 30,000.00 30,000.00 30,000.00 30,000.00 75,000.00 75,000.00 75,000.00 75,000.00 75,000.00 200,000.00 1,125,000.00 925,000.00 925,000.00 925,000.00 925,000.00
AUG 65,000.00 20,000.00 50,000.00 15,000.00 48,000.00 22,000.00 23,000.00 460,000.00 703,000.00
SEP OCT NOV DEC 58,000.00 54,000.00 50,000.00 45,000.00 12,000.00 50,000.00 50,000.00 50,000.00 50,000.00 15,000.00 15,000.00 15,000.00 15,000.00 54,000.00 48,000.00 49,000.00 49,500.00 14,000.00 15,000.00 16,000.00 18,000.00 21,500.00 22,000.00 21,400.00 22,000.00 480,000.00 480,000.00 480,000.00 480,000.00 704,500.00 684,000.00 681,400.00 679,500.00
More Documents from "Muhammad Faizan"
Electronics-sample-paper-5.pdf
December 2019 0
Assignment.xlsx
December 2019 0
Kids Magazine
November 2019 41
Classification Of Soil (autosaved).docx
November 2019 33
Project Management 2.pdf
April 2020 24