sorry its base on appendix 1
fx Any work required in an Appendix must be done in the blue boxes. Please read the narrative carefully to see what Elliot is requ A B . D E G Any work required in an Appendix must be done in the blue boxes. Please read the narrative carefully to see what Elliot is requesting. Appendix 11 Required: Determine the variable costs for each product line based on your appendix I. Run Like the Live in Terrific Tank Wind Pullover Leggings 2,520 2.160 7,452 46.00 108.00 98.00 Total 12,132 Units sold 1 Selling price 12 Variable Costs 13 Contribution margin 14 Total fixed costs 15 16 Required: 17 a. Determine 18 $ 470,976 19 Terrific Tank Run Like the Live in Wind Pullover Leggings Total (a) Sales Mix as a function 20 of units sold (b) weighted average 21 contribution margin Hint! While you will want to provide Elliot the weighted average CM and break-even units, be sure to explain to her what these mean. 22 (c) Total number of units that the company must produce to break-even (round to the nearest whole number) 23 24 (d) Number of units of each model that the company must produce to break-even (round to nearest whole number) 25 26 Run Like the Live in 27 Terrific Tank Wind Pullover Leggings Total 28 Units 29 30 31 Proof Calculate operating income when the above units are sold (as calculated in part b) w ed in part b) Run Like the Terrific Tank Wind Pullover Total CM 5 Less: fixed costs 5 Operating income Live in Leggings Total 58 39 40 41 Immaterial within $200 (rounding error due random #generato 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 B E Any work required in an Appendix must be done in the blue boxes. Please read the narra carefully to see what Elliot is requesting. Appendix 11 Run Like the Live in Terrific Tank Wind Pullover Leggings Production (units) 2,520 2,160 7,452 Sales revenue/unit 115,920.00 233,280.00 730,296.00 Variable cost of goods sold 65,066.40 66,096.00 173,259.00 1 Fixed cost of goods sold $ 25,922 $ 38,884 $ 64,806 72 Gross Profit $ 24,931 $ 128,300 $ 492,231 13 Variable operating expenses 14,597 $ 12,511 $ 43,164 14 Fixed operating expenses 4,385 $ 17,832 $ 12,967 15 Common fixed costs $ 30,618 $ 45,927 $ 229,635 16 Net Operating income $ (24.668) $ 52,030 $ 206,465 $ Total 12,132.00 1,079,496.00 304,421.40 129,61200 645,462.60 70,272.00 35,184.00 306,180.00 233,826.60 $ 17 Prepare a segment margin income statement showing each of the three products. Fixed operating costs and fixed cost of goods sold can be traced to each product line. See the chapter 7 student excel template and 18 19 20 Sales revenue Terrific Tank Run Like the Wind Pullover Live in Leggings 21 Variable cost of goods sold Total 22 Variable on A B D E F 7 2 Any work required in an Appendix must be done in the blue boxes. Please read the narrative carefully to see what Elliot is 3 requesting. 4 5 Appendix 1 6 7 Production in units: 8 Terrific Tank 9 Run Like the Wind Pullover 210 10 Live in Leggings 180 11 Monthly Production 621 12 1,011 13 Posts 2 Mivoda 2. Mixed Costs 3. Variable cost per unit Product vs. Period 13 Costs: /month 1. Classification Fixed Portion Variable Portion 14 Fabric - Terrific Tank (note 1) S 2.176 15 Fabric - Run Like the Wind Pullover S 3,688 16 Fabric - Live in Leggings S 9,725 17 Tailor's hourly wages - Terrific Tank (note 2) $ 3,247 Tailor's hourly wages - Run Like the Wind 18 Pullover $ 1,820 19 Tailor's hourly wages - Live in Leggings $ 4.713 20 Tailor supervisor's salary (note 3) S 2,063 Inventory and fulfillment manager's salary 21 (note 4) S 1.997 22 Shipping salary (note 5) S 2 Recering clerk salary (note 6) 1.446 $ 24. Rent on factory space (note 7) 1,826 $ 25 Rent on office space (note 7) 7,804 S 26 Insurance - Factory (note 8) 2,667 27 Insurance - office space (note B) S 1.975 $ 28 Utility costs (note 9) 147 22 Office Supplies S 2,335 30 Maintenance on building (note 10) s 1.100 31 Depreciation on office equipment (note 11) $ 32 Depreciation on factory equipment (note 11) S 1,800 33 Rent on factory equipment (note 12) s 2.400 34 Advertising - Yoga Campaign (note 13) $ 3.469 35 Advertising - Run Club Campaign (Note 14) $ 1,446 36 Shipping expense (Note 15) $ 1.486 37 Bookkeepers' salary (Note 16) $ 1.121 38 President's salary_(Note 17 S 1,658 39 5 4,764 40 Notes 3,600 41 Note 1: All fabric is outsourced from our supplier in Taiwan Appendix Appendor Appendix ! - Appendo TV Type here to search Appende v Appendix 1 Production in units: Terrific Tank Run Like the Wind Pullover ive in Leggings Monthly Production 210 180 621 1,011 2. Mixed Costs 3. Variable cost 1. Classification Fixed Portion Variable Portion per unit Product vs. Period /month $ 2,176 $ 3,688 $ 9,725 $ 3,247 Costs: Fabric - Terrific Tank (note 1) Fabric - Run Like the Wind Pullover Fabric - Live in Leggings Tailor's hourly wages - Terrific Tank (note 2) Tailor's hourly wages - Run Like the Wind Pullover Tailor's hourly wages - Live in Leggings Tailor supervisor's salary (note 3) Inventory and fulfillment manager's salary (note 4) Shipping salary (note 5) Receiving clerk salary (note 6) Rent on factory space (note 7) $ $ 1,820 4,713 2,063 $ $ $ 1,997 1.446 1,826 7.804 S $ B D E F G A LA $ GA $ EA A n office space (note 7) nce - factory (note 8) nce - office space (note 8) costs (note 9) supplies enance on building (note 10) ciation on office equipment (note 11) ciation on factory equipment (note 11) on factory equipment (note 12) tising - Yoga Campaign (note 13) tising - Run Club Campaign (Note 14) ing expense (Note 15) keepers' salary (Note 16) EA $ 2,667 1,975 147 2,335 1,100 3,600 1,800 2,400 3,469 1,446 1,486 1,121 1,658 4,764 S $ $ $ S dent's salary (Note 17) $ s 1: All fabric is outsourced from our supplier in Taiwan 2: There are three tailors who each work on a selected product. They come in as needed and are paid hourly 5:02 Case study 1_GROUP3_ACCT1116 W20... Overview Org chart Appendix i Appendix Appendium Appendix IV Appendix V Any work and Appendi 210 Turin Fan Lee the Wind Live 2. Fun Wine Sion's houry weet . WP Sh ry Hogy TH 20 actory their US 1 2 Torrente Advengo Lopen Note 1: Alfredo Note: There who nachwed product. They Note: The Note: The Inventory and ment manager manages the chromowanada Note: The clerk is paid on my doen Note The wing how to remo They were more padoch produced per moth Note: The Wings 2.000.00 Hate this when things 3.000 Note Nute 16 mm 200 manat Watu 11 Depren interagire Not: Rent is paid for the winners Niste t The Camps the Town Muta se. The fun ange ulike the wind Heta 15 So wie den Here 16 The Wandrew Note 17 tot want you to the contin Propietat word Theme Any work required in an Appendix must be done in the blue boxes. Please read the narrative carefully to see what Elliot is requesting. Appendixit Required: Determine the variable costs for each product line based on your appendix I. Terrific Tank Run Like the Live in Wind Pullover Leggings Total Units sold 2,520 2,160 7,452 12,132 Soling price 46 108 198 Variable Costs Contribution margin Total fixed costs 470,976 Required: a. Determine: Total Terrifie Tank Run Like the Live in Wind Pullover Leggings 21% 18% 61% 100% (a) Sales Mix as a function of units sold (b) weighted average contribution margin Hintl While you will want to provide Elliot the weighted average CM and break-even units, be sure to explain to her what these mean. (c) Total number of units that the company must produce to break-even (round to the nearest whole number (d) Number of units of each model that the company must produce to break-even (round to nearest whole number) Terrific Tank Run Like the Live in Wind Pullover Leggings Total Units Proot Calculate operating income when the above units are sold (as calculated in part by Terrific Tank Run Like the Wind Pullover Live in Leggings Total Total CM Less: fixed costs Operating income immaterial within $200 (rounding error due random generator fx Any work required in an Appendix must be done in the blue boxes. Please read the narrative carefully to see what Elliot is requ A B . D E G Any work required in an Appendix must be done in the blue boxes. Please read the narrative carefully to see what Elliot is requesting. Appendix 11 Required: Determine the variable costs for each product line based on your appendix I. Run Like the Live in Terrific Tank Wind Pullover Leggings 2,520 2.160 7,452 46.00 108.00 98.00 Total 12,132 Units sold 1 Selling price 12 Variable Costs 13 Contribution margin 14 Total fixed costs 15 16 Required: 17 a. Determine 18 $ 470,976 19 Terrific Tank Run Like the Live in Wind Pullover Leggings Total (a) Sales Mix as a function 20 of units sold (b) weighted average 21 contribution margin Hint! While you will want to provide Elliot the weighted average CM and break-even units, be sure to explain to her what these mean. 22 (c) Total number of units that the company must produce to break-even (round to the nearest whole number) 23 24 (d) Number of units of each model that the company must produce to break-even (round to nearest whole number) 25 26 Run Like the Live in 27 Terrific Tank Wind Pullover Leggings Total 28 Units 29 30 31 Proof Calculate operating income when the above units are sold (as calculated in part b) w ed in part b) Run Like the Terrific Tank Wind Pullover Total CM 5 Less: fixed costs 5 Operating income Live in Leggings Total 58 39 40 41 Immaterial within $200 (rounding error due random #generato 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 B E Any work required in an Appendix must be done in the blue boxes. Please read the narra carefully to see what Elliot is requesting. Appendix 11 Run Like the Live in Terrific Tank Wind Pullover Leggings Production (units) 2,520 2,160 7,452 Sales revenue/unit 115,920.00 233,280.00 730,296.00 Variable cost of goods sold 65,066.40 66,096.00 173,259.00 1 Fixed cost of goods sold $ 25,922 $ 38,884 $ 64,806 72 Gross Profit $ 24,931 $ 128,300 $ 492,231 13 Variable operating expenses 14,597 $ 12,511 $ 43,164 14 Fixed operating expenses 4,385 $ 17,832 $ 12,967 15 Common fixed costs $ 30,618 $ 45,927 $ 229,635 16 Net Operating income $ (24.668) $ 52,030 $ 206,465 $ Total 12,132.00 1,079,496.00 304,421.40 129,61200 645,462.60 70,272.00 35,184.00 306,180.00 233,826.60 $ 17 Prepare a segment margin income statement showing each of the three products. Fixed operating costs and fixed cost of goods sold can be traced to each product line. See the chapter 7 student excel template and 18 19 20 Sales revenue Terrific Tank Run Like the Wind Pullover Live in Leggings 21 Variable cost of goods sold Total 22 Variable on A B D E F 7 2 Any work required in an Appendix must be done in the blue boxes. Please read the narrative carefully to see what Elliot is 3 requesting. 4 5 Appendix 1 6 7 Production in units: 8 Terrific Tank 9 Run Like the Wind Pullover 210 10 Live in Leggings 180 11 Monthly Production 621 12 1,011 13 Posts 2 Mivoda 2. Mixed Costs 3. Variable cost per unit Product vs. Period 13 Costs: /month 1. Classification Fixed Portion Variable Portion 14 Fabric - Terrific Tank (note 1) S 2.176 15 Fabric - Run Like the Wind Pullover S 3,688 16 Fabric - Live in Leggings S 9,725 17 Tailor's hourly wages - Terrific Tank (note 2) $ 3,247 Tailor's hourly wages - Run Like the Wind 18 Pullover $ 1,820 19 Tailor's hourly wages - Live in Leggings $ 4.713 20 Tailor supervisor's salary (note 3) S 2,063 Inventory and fulfillment manager's salary 21 (note 4) S 1.997 22 Shipping salary (note 5) S 2 Recering clerk salary (note 6) 1.446 $ 24. Rent on factory space (note 7) 1,826 $ 25 Rent on office space (note 7) 7,804 S 26 Insurance - Factory (note 8) 2,667 27 Insurance - office space (note B) S 1.975 $ 28 Utility costs (note 9) 147 22 Office Supplies S 2,335 30 Maintenance on building (note 10) s 1.100 31 Depreciation on office equipment (note 11) $ 32 Depreciation on factory equipment (note 11) S 1,800 33 Rent on factory equipment (note 12) s 2.400 34 Advertising - Yoga Campaign (note 13) $ 3.469 35 Advertising - Run Club Campaign (Note 14) $ 1,446 36 Shipping expense (Note 15) $ 1.486 37 Bookkeepers' salary (Note 16) $ 1.121 38 President's salary_(Note 17 S 1,658 39 5 4,764 40 Notes 3,600 41 Note 1: All fabric is outsourced from our supplier in Taiwan Appendix Appendor Appendix ! - Appendo TV Type here to search Appende v Appendix 1 Production in units: Terrific Tank Run Like the Wind Pullover ive in Leggings Monthly Production 210 180 621 1,011 2. Mixed Costs 3. Variable cost 1. Classification Fixed Portion Variable Portion per unit Product vs. Period /month $ 2,176 $ 3,688 $ 9,725 $ 3,247 Costs: Fabric - Terrific Tank (note 1) Fabric - Run Like the Wind Pullover Fabric - Live in Leggings Tailor's hourly wages - Terrific Tank (note 2) Tailor's hourly wages - Run Like the Wind Pullover Tailor's hourly wages - Live in Leggings Tailor supervisor's salary (note 3) Inventory and fulfillment manager's salary (note 4) Shipping salary (note 5) Receiving clerk salary (note 6) Rent on factory space (note 7) $ $ 1,820 4,713 2,063 $ $ $ 1,997 1.446 1,826 7.804 S $ B D E F G A LA $ GA $ EA A n office space (note 7) nce - factory (note 8) nce - office space (note 8) costs (note 9) supplies enance on building (note 10) ciation on office equipment (note 11) ciation on factory equipment (note 11) on factory equipment (note 12) tising - Yoga Campaign (note 13) tising - Run Club Campaign (Note 14) ing expense (Note 15) keepers' salary (Note 16) EA $ 2,667 1,975 147 2,335 1,100 3,600 1,800 2,400 3,469 1,446 1,486 1,121 1,658 4,764 S $ $ $ S dent's salary (Note 17) $ s 1: All fabric is outsourced from our supplier in Taiwan 2: There are three tailors who each work on a selected product. They come in as needed and are paid hourly 5:02 Case study 1_GROUP3_ACCT1116 W20... Overview Org chart Appendix i Appendix Appendium Appendix IV Appendix V Any work and Appendi 210 Turin Fan Lee the Wind Live 2. Fun Wine Sion's houry weet . WP Sh ry Hogy TH 20 actory their US 1 2 Torrente Advengo Lopen Note 1: Alfredo Note: There who nachwed product. They Note: The Note: The Inventory and ment manager manages the chromowanada Note: The clerk is paid on my doen Note The wing how to remo They were more padoch produced per moth Note: The Wings 2.000.00 Hate this when things 3.000 Note Nute 16 mm 200 manat Watu 11 Depren interagire Not: Rent is paid for the winners Niste t The Camps the Town Muta se. The fun ange ulike the wind Heta 15 So wie den Here 16 The Wandrew Note 17 tot want you to the contin Propietat word Theme Any work required in an Appendix must be done in the blue boxes. Please read the narrative carefully to see what Elliot is requesting. Appendixit Required: Determine the variable costs for each product line based on your appendix I. Terrific Tank Run Like the Live in Wind Pullover Leggings Total Units sold 2,520 2,160 7,452 12,132 Soling price 46 108 198 Variable Costs Contribution margin Total fixed costs 470,976 Required: a. Determine: Total Terrifie Tank Run Like the Live in Wind Pullover Leggings 21% 18% 61% 100% (a) Sales Mix as a function of units sold (b) weighted average contribution margin Hintl While you will want to provide Elliot the weighted average CM and break-even units, be sure to explain to her what these mean. (c) Total number of units that the company must produce to break-even (round to the nearest whole number (d) Number of units of each model that the company must produce to break-even (round to nearest whole number) Terrific Tank Run Like the Live in Wind Pullover Leggings Total Units Proot Calculate operating income when the above units are sold (as calculated in part by Terrific Tank Run Like the Wind Pullover Live in Leggings Total Total CM Less: fixed costs Operating income immaterial within $200 (rounding error due random generator
