Question

Suppose to start a new business for a manufacturing concern

1- identify Direct Material, Indirect material, Direct Labor, indirect Labor cost for your business

2-Prepare inventory costing sheet

3-Calculate Breakeven in units and dollars

4-calculated units required for certain target profit.

Information provided

Income statement annual of ici polyester

Balance sheet

Financial summary

Costing detail before Gross profit line

Transcribed image text: ICI Income Statement Collapse All Annual Quarterly 2020 30/06 2019 30/06 2018 30/06 2017 30/06 Period Ending 49992.07 41771.22 55256.47 59382.41 Total Revenue 49992.07 41771.22 55256.47 59382.41 Revenue 44339.71 33755.44 49637.4 41060.07 Other Revenue, Total Cost of Revenue, Total Gross Profit 8931.99 8015.78 9745.01 10916.76 49736.93 37584.8 54438.98 45426.62 4858.26 4341.99 3940.51 3442.53 150.34 84.58 82.25 68.85 36.76 Total Operating Expenses Selling/General Admin. Expenses, Total Research & Development Depreciation / Amortization Interest Expense (Income) - Net Operating Unusual Expense (Income) Other Operating Expenses, Total Operating Income Interest Income (Expense), Net Non-Operating Gain (Loss) on Sale of Assets Other Net 388.61 375 307.03 317.98 5519.55 4943.44 4565.45 4186.42 -1619.98 -1171.49 -331.01 356.51 1.49 41 6.25 7.29 -408.54 -372.08 -307.05 -155.26 3492.51 Net Income Before Taxes 3403.96 3933.64 4394.96 Provision for Income Taxes 1130.9 867.33 635.99 1114.85 Net Income After Taxes 2361.62 2536.63 3297.65 3280.11 166.44 -11.41 -17.65 2.64 Minority Interest Equity In Affiliates US GAAP Adjustment Net Income Before Extraordinary Items Total Extraordinary Items 2528.06 2525.22 3280.01 3282.75 Net Income 2528.06 2525.22 3280.01 3282.75 2528.06 2525.22 3280.01 3282.75 2528.06 2525.22 3280.01 3282.75 Net Income Total Adjustments to Net Income Income Available to Common Excluding Extraordinary Items Dilution Adjustment Diluted Net Income Diluted Weighted Average Shares Diluted EPS Excluding Extraordinary Items DPS - Common Stock Primary Issue Diluted Normalized EPS 2528.06 2525.22 3280.01 3282.75 92.36 92.36 92.36 92.36 27.37 27.34 35.51 35.54 16 9 16.5 18 27.36 27.31 35.79 35.48 in Millions of PKR (except for per share items) ICI Balance Sheet Collapse All Annual Quarterly 2020 30/06 2019 30/06 2018 30/06 2017 30/06 Period Ending 19372.04 Total Current Assets 19897.93 19328.31 14672.37 549.56 423.89 1687.35 Cash and Short Term Investments 1266.46 Cash 425,56 300.33 1586.31 987.11 124 123.56 101.04 279.35 7130.36 7994.09 5903.2 Cash & Equivalents Short Term Investments Total Receivables, Net Accounts Receivables - Trade, Net Total Inventory Prepaid Expenses Other Current Assets, Total 7361.19 2718.12 2386.12 2449.66 2589.88 11278.24 11157.06 9957.28 6925.28 149.83 133.52 101.49 428.71 264.05 189.37 221.01 148.72 Total Assets 49441.42 36801.93 48385 25631.08 45012.53 22375.94 25873.78 19958.62 57398.01 55014.32 48980.33 44144.54 .-31766.94 -29140.54 -26604.38 -24185.92 206.37 206.37 206.37 79.86 Property/PlantEquipment, Total - Net Property/Plant/Equipment Total - Gross Accumulated Depreciation. Total Goodwill, Net Intangibles, Net Long Term Investments Note Receivable - Long Term Other Long Term Assets Total Other Assets Total 1498.06 1489.52 1482 703.49 1478.27 1132.5 1109.29 530.12 966.54 452.04 443.79 382.42 38.05 43.52 43.6 38.63 15296.92 16733.29 14708.01 Total Current Liabilities 12815.76 5147.21 3896.05 2931.74 2315.04 3879.45 3695.24 3034.73 2981.17 Accounts Payable Payable/Accrued Accrued Expenses Notes Payable/Short Term Debt Current Port of LT Debt/Capital Leases Other Current liabilities, Total 4898.67 7356.14 7332.33 2128.91 1694.5 967.87 649.68 1373.23 1249,51 1055 66 1058.04 1908.81 Total Liabilities 27377.31 29486.47 26405.91 19563.51 8969,04 9454.19 8243.01 4920.28 8715.45 9454.19 8243.01 4919.48 253.59 0.8 Total Long Term Debt Long Term Debt Capital Lease Obligations Deferred Income Tax Minority Interest Other Liabilities, Total 1480.47 1748.37 1903.09 1225.08 1516 17 1437.62 1426.21 487.36 114. 113.01 125.59 115.03 2.1007.7 19954.95 18606.63 17238.41 923.59 923.59 923.59 923.59 309.06 19410.99 18287.09 16861.05 Total Equity Redeemable Preferred Stock, Total Preferred Stock - Non Redeemable, Net Common Stock, Total Additional Paid-In Capital Retained Earnings (Accumulated Deficit) Treasury Stock - Common ESOP Debt Guarantee Unrealized Gain (Loss) Other Equity. Total Total Liabilities & Shareholders Equity Total Common Shares Outstanding Total Preferred Shares Outstanding 15102.98 673 12 744.27 821.98 902 79 48385 49441 42 45012.53 36801.93 92.86 92.36 92.36 92.36 in Millions of PKR excantlar i ICI Financial Summary For the three months ended 30 September 2020, ICIPakistan Limited revenues decreased less than 1% to PKR 14.47B. Net income increased 18% to PKR984.7M. Revenuesreflect Others segment increase of 36% to PKR275.1M, alsoreflect Polyester segment decrease of 6% to PKR5.48B, SodaAsh segment decrease of 5% to PKR3.85B, General Chemicalssegment decrease of 9% to PKR2B. TTM = Trailing Twelve Months MRQ = Most Recent Quarter Annual Quarterly ICI Income Statement 80B Gross margin TTM Operating margin TTM Net Profit margin TTM Return on Investment ITM 60B 19.71% 9.67% 4.37% 7.67% 40B Total Revenue Net Income 20B 2017 2019 2020 2018 Jun 30, 2018 Jun 30, 2017 Jun 30, 2019 Period Ending: Jun 30, 2020 45012.53 36801.93 48385 49441.42 Total Assets 26405.91 19563.51 27377.31 29486.47 Total Liabilities 18606.63 17238.41 21007.7 19954.95 Total Equity ICI Cash Flow Statement 58.45. 5B 597.78 Cash Flow/Share TTM Revenue/Share TTM Operating Cash Flow 2.5B 42.38% OB Cash Net Change in Cash -2 5B -5B -7/5B 2017 2019 2020 2018 Jun 30, 2020 Period Ending Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Period Length 12 Months 12 Months O Months 12 Months 6483.33 4080.38 -1337.47 5128.65 Cash From Operating Activities Cash From Investing Activities Cash From Financing Activities -1485)14 -6108.94 -6353.53 -4745.83 -2415.05 741.28 2908.47 432.95 Net Change in Cash 2583.14 -1287.28 -4782.53 815.78 Net revenue (Rs(mn))- LHS Cost of sales Gross profit Distribution costs Administrative expenses Operating profit Finance cost Exchange gain/ (loss) Workers' profit participation fund Workers' welfare fund Other income Other expenses Dividend income Profit before taxation Taxation Profit after taxation 29,287 27,914 4.92% (23,490) (23,726) -0.99% 5,797 4,188 38.42% (1,743) (1,557) 11.95% (652) (676) -3.55% 3,402 1,955 74.02% (936) (696) 34.48% 28 (215) -113.02% (150) (63) 138.10% (47) (26) 80.77% 49 41 19.51% (22) (32) -31.25% 530 255 107.84% 2,854 1,219 134.13% (784) (319) 145.77% 2,070 900 130.00% Transcribed image text: ICI Income Statement Collapse All Annual Quarterly 2020 30/06 2019 30/06 2018 30/06 2017 30/06 Period Ending 49992.07 41771.22 55256.47 59382.41 Total Revenue 49992.07 41771.22 55256.47 59382.41 Revenue 44339.71 33755.44 49637.4 41060.07 Other Revenue, Total Cost of Revenue, Total Gross Profit 8931.99 8015.78 9745.01 10916.76 49736.93 37584.8 54438.98 45426.62 4858.26 4341.99 3940.51 3442.53 150.34 84.58 82.25 68.85 36.76 Total Operating Expenses Selling/General Admin. Expenses, Total Research & Development Depreciation / Amortization Interest Expense (Income) - Net Operating Unusual Expense (Income) Other Operating Expenses, Total Operating Income Interest Income (Expense), Net Non-Operating Gain (Loss) on Sale of Assets Other Net 388.61 375 307.03 317.98 5519.55 4943.44 4565.45 4186.42 -1619.98 -1171.49 -331.01 356.51 1.49 41 6.25 7.29 -408.54 -372.08 -307.05 -155.26 3492.51 Net Income Before Taxes 3403.96 3933.64 4394.96 Provision for Income Taxes 1130.9 867.33 635.99 1114.85 Net Income After Taxes 2361.62 2536.63 3297.65 3280.11 166.44 -11.41 -17.65 2.64 Minority Interest Equity In Affiliates US GAAP Adjustment Net Income Before Extraordinary Items Total Extraordinary Items 2528.06 2525.22 3280.01 3282.75 Net Income 2528.06 2525.22 3280.01 3282.75 2528.06 2525.22 3280.01 3282.75 2528.06 2525.22 3280.01 3282.75 Net Income Total Adjustments to Net Income Income Available to Common Excluding Extraordinary Items Dilution Adjustment Diluted Net Income Diluted Weighted Average Shares Diluted EPS Excluding Extraordinary Items DPS - Common Stock Primary Issue Diluted Normalized EPS 2528.06 2525.22 3280.01 3282.75 92.36 92.36 92.36 92.36 27.37 27.34 35.51 35.54 16 9 16.5 18 27.36 27.31 35.79 35.48 in Millions of PKR (except for per share items) ICI Balance Sheet Collapse All Annual Quarterly 2020 30/06 2019 30/06 2018 30/06 2017 30/06 Period Ending 19372.04 Total Current Assets 19897.93 19328.31 14672.37 549.56 423.89 1687.35 Cash and Short Term Investments 1266.46 Cash 425,56 300.33 1586.31 987.11 124 123.56 101.04 279.35 7130.36 7994.09 5903.2 Cash & Equivalents Short Term Investments Total Receivables, Net Accounts Receivables - Trade, Net Total Inventory Prepaid Expenses Other Current Assets, Total 7361.19 2718.12 2386.12 2449.66 2589.88 11278.24 11157.06 9957.28 6925.28 149.83 133.52 101.49 428.71 264.05 189.37 221.01 148.72 Total Assets 49441.42 36801.93 48385 25631.08 45012.53 22375.94 25873.78 19958.62 57398.01 55014.32 48980.33 44144.54 .-31766.94 -29140.54 -26604.38 -24185.92 206.37 206.37 206.37 79.86 Property/PlantEquipment, Total - Net Property/Plant/Equipment Total - Gross Accumulated Depreciation. Total Goodwill, Net Intangibles, Net Long Term Investments Note Receivable - Long Term Other Long Term Assets Total Other Assets Total 1498.06 1489.52 1482 703.49 1478.27 1132.5 1109.29 530.12 966.54 452.04 443.79 382.42 38.05 43.52 43.6 38.63 15296.92 16733.29 14708.01 Total Current Liabilities 12815.76 5147.21 3896.05 2931.74 2315.04 3879.45 3695.24 3034.73 2981.17 Accounts Payable Payable/Accrued Accrued Expenses Notes Payable/Short Term Debt Current Port of LT Debt/Capital Leases Other Current liabilities, Total 4898.67 7356.14 7332.33 2128.91 1694.5 967.87 649.68 1373.23 1249,51 1055 66 1058.04 1908.81 Total Liabilities 27377.31 29486.47 26405.91 19563.51 8969,04 9454.19 8243.01 4920.28 8715.45 9454.19 8243.01 4919.48 253.59 0.8 Total Long Term Debt Long Term Debt Capital Lease Obligations Deferred Income Tax Minority Interest Other Liabilities, Total 1480.47 1748.37 1903.09 1225.08 1516 17 1437.62 1426.21 487.36 114. 113.01 125.59 115.03 2.1007.7 19954.95 18606.63 17238.41 923.59 923.59 923.59 923.59 309.06 19410.99 18287.09 16861.05 Total Equity Redeemable Preferred Stock, Total Preferred Stock - Non Redeemable, Net Common Stock, Total Additional Paid-In Capital Retained Earnings (Accumulated Deficit) Treasury Stock - Common ESOP Debt Guarantee Unrealized Gain (Loss) Other Equity. Total Total Liabilities & Shareholders Equity Total Common Shares Outstanding Total Preferred Shares Outstanding 15102.98 673 12 744.27 821.98 902 79 48385 49441 42 45012.53 36801.93 92.86 92.36 92.36 92.36 in Millions of PKR excantlar i ICI Financial Summary For the three months ended 30 September 2020, ICIPakistan Limited revenues decreased less than 1% to PKR 14.47B. Net income increased 18% to PKR984.7M. Revenuesreflect Others segment increase of 36% to PKR275.1M, alsoreflect Polyester segment decrease of 6% to PKR5.48B, SodaAsh segment decrease of 5% to PKR3.85B, General Chemicalssegment decrease of 9% to PKR2B. TTM = Trailing Twelve Months MRQ = Most Recent Quarter Annual Quarterly ICI Income Statement 80B Gross margin TTM Operating margin TTM Net Profit margin TTM Return on Investment ITM 60B 19.71% 9.67% 4.37% 7.67% 40B Total Revenue Net Income 20B 2017 2019 2020 2018 Jun 30, 2018 Jun 30, 2017 Jun 30, 2019 Period Ending: Jun 30, 2020 45012.53 36801.93 48385 49441.42 Total Assets 26405.91 19563.51 27377.31 29486.47 Total Liabilities 18606.63 17238.41 21007.7 19954.95 Total Equity ICI Cash Flow Statement 58.45. 5B 597.78 Cash Flow/Share TTM Revenue/Share TTM Operating Cash Flow 2.5B 42.38% OB Cash Net Change in Cash -2 5B -5B -7/5B 2017 2019 2020 2018 Jun 30, 2020 Period Ending Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Period Length 12 Months 12 Months O Months 12 Months 6483.33 4080.38 -1337.47 5128.65 Cash From Operating Activities Cash From Investing Activities Cash From Financing Activities -1485)14 -6108.94 -6353.53 -4745.83 -2415.05 741.28 2908.47 432.95 Net Change in Cash 2583.14 -1287.28 -4782.53 815.78 Net revenue (Rs(mn))- LHS Cost of sales Gross profit Distribution costs Administrative expenses Operating profit Finance cost Exchange gain/ (loss) Workers' profit participation fund Workers' welfare fund Other income Other expenses Dividend income Profit before taxation Taxation Profit after taxation 29,287 27,914 4.92% (23,490) (23,726) -0.99% 5,797 4,188 38.42% (1,743) (1,557) 11.95% (652) (676) -3.55% 3,402 1,955 74.02% (936) (696) 34.48% 28 (215) -113.02% (150) (63) 138.10% (47) (26) 80.77% 49 41 19.51% (22) (32) -31.25% 530 255 107.84% 2,854 1,219 134.13% (784) (319) 145.77% 2,070 900 130.00%