Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use Table 1 to calculate the profit per meter if Amir decides to get the amount of the cloth shown in Table 2 manufactured instead

  1. Use Table 1 to calculate the profit per meter if Amir decides to get the amount of the cloth shown in Table 2 manufactured instead of buying it from suppliers.image text in transcribedimage text in transcribed
TABLE 1: 2018 FINANCIAL PERFORMANCE OF STAR TEXTILES, GROUPED BY QUALITIES OF CLOTH SOLD Thread count (Colors) Purchased Total 70x60 76x64 80x72 76x64 80x80 (light) (light) (light) (dark) (dark) 540,000 460,000 280,000 210,000 230,000 1,720,000 86 102 120 115 132 46,440,000 46,920,000 33,600,000 24,150,000 30,360,000 181,470,000 Sales (meters) Price (INR) Sales (INR) Cost of Sales Allocation Basis Purchase price Cut piece* Meters Packaging Actual Freight in Actual Total Cost of Sales 42,120,000 41,860,000 29,680,000 21,420,000 26,450,000 161,530,000 1,026,000 874,000 532,000 399,000 437,000 3,268,000 540,000 460,000 280,000 210,000 230,000 1,720,000 520,000 430,000 260,000 202,000 220,000 1,632,000 44,206,000 43,624,000 30,752,000 22,231,000 27,337,000 168,150,000 Gross Profit 2,234,000 3,296,000 2,848,000 1,919,000 3,023,000 13,320,000 Administrative Expenses Salaries Meters Rent Meters Sampling Actual Electricity Meters Telephone Meters Debt recovery Meters Maintenance Meters Porter Meters Miscellaneous Meters Total Administrative Expenses Net Profit 769,186 298,256 30,000 122,442 91,047 97,953 28,884 106,744 34,535 1,579,047 654,953 655,233 398,837 254,070 154,651 25,000 15,000 104,302 63,488 77,558 47,209 83,442 50,791 24,605 14,977 90,930 55,349 29,419 17,907 1,344,559 818,209 1,951,441 2,029,791 299,128 327,616 115,988 127,035 10,000 20,000 47,616 52,151 35,407 38,779 38,093 41,721 11,233 12,302 41,512 45,465 13,430 14,709 612,407 679,778 1,306,593 2,343,222 2,450,000 950,000 100,000 389,999 290,000 312,000 92,001 340,000 110,000 5,034,000 8,286,000 Profit per Meter 1.21 4.24 7.25 6.22 10.19 Note: Some numbers might not add exactly due to rounding. * Cut piece is the cost of odd-length cloth that needs to be disposed of because retailers wouldn't buy it. TABLE 2: QUOTES FOR DIFFERENT QUALITIES OF GREIGE CLOTH AND COST OF DYEING 76 64 Light 80 72 Light 76 64 Dark 80 80 Dark 61 61 61 61 10% 10% 12% 12% Quality Specifics Warp 70 Weft 60 Colors Light Width of greige 61 (inches) Shortage 10% Cost (per meter) Greige 44 Dyeing 20 Estimated meters to be manufactured and 200,000 sold next year Currently: Cost of purchasing 78 finished cloth per meter Current sale price per meter 86 51 24 60 27 54 30 63 32 150,000 100,000 80,000 80,000 91 106 102 115 102 120 115 132 Note: All monetary values are represented in Indian rupees (INR). TABLE 1: 2018 FINANCIAL PERFORMANCE OF STAR TEXTILES, GROUPED BY QUALITIES OF CLOTH SOLD Thread count (Colors) Purchased Total 70x60 76x64 80x72 76x64 80x80 (light) (light) (light) (dark) (dark) 540,000 460,000 280,000 210,000 230,000 1,720,000 86 102 120 115 132 46,440,000 46,920,000 33,600,000 24,150,000 30,360,000 181,470,000 Sales (meters) Price (INR) Sales (INR) Cost of Sales Allocation Basis Purchase price Cut piece* Meters Packaging Actual Freight in Actual Total Cost of Sales 42,120,000 41,860,000 29,680,000 21,420,000 26,450,000 161,530,000 1,026,000 874,000 532,000 399,000 437,000 3,268,000 540,000 460,000 280,000 210,000 230,000 1,720,000 520,000 430,000 260,000 202,000 220,000 1,632,000 44,206,000 43,624,000 30,752,000 22,231,000 27,337,000 168,150,000 Gross Profit 2,234,000 3,296,000 2,848,000 1,919,000 3,023,000 13,320,000 Administrative Expenses Salaries Meters Rent Meters Sampling Actual Electricity Meters Telephone Meters Debt recovery Meters Maintenance Meters Porter Meters Miscellaneous Meters Total Administrative Expenses Net Profit 769,186 298,256 30,000 122,442 91,047 97,953 28,884 106,744 34,535 1,579,047 654,953 655,233 398,837 254,070 154,651 25,000 15,000 104,302 63,488 77,558 47,209 83,442 50,791 24,605 14,977 90,930 55,349 29,419 17,907 1,344,559 818,209 1,951,441 2,029,791 299,128 327,616 115,988 127,035 10,000 20,000 47,616 52,151 35,407 38,779 38,093 41,721 11,233 12,302 41,512 45,465 13,430 14,709 612,407 679,778 1,306,593 2,343,222 2,450,000 950,000 100,000 389,999 290,000 312,000 92,001 340,000 110,000 5,034,000 8,286,000 Profit per Meter 1.21 4.24 7.25 6.22 10.19 Note: Some numbers might not add exactly due to rounding. * Cut piece is the cost of odd-length cloth that needs to be disposed of because retailers wouldn't buy it. TABLE 2: QUOTES FOR DIFFERENT QUALITIES OF GREIGE CLOTH AND COST OF DYEING 76 64 Light 80 72 Light 76 64 Dark 80 80 Dark 61 61 61 61 10% 10% 12% 12% Quality Specifics Warp 70 Weft 60 Colors Light Width of greige 61 (inches) Shortage 10% Cost (per meter) Greige 44 Dyeing 20 Estimated meters to be manufactured and 200,000 sold next year Currently: Cost of purchasing 78 finished cloth per meter Current sale price per meter 86 51 24 60 27 54 30 63 32 150,000 100,000 80,000 80,000 91 106 102 115 102 120 115 132 Note: All monetary values are represented in Indian rupees (INR)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management And Cost Accounting

Authors: Charles T. Horngren, George Foster, Srikant M. Datar

3rd Edition

0273687514, 978-0273687511

More Books

Students also viewed these Accounting questions