10:43 Done Attachment 12:35 Done Attachment Using the original case study and the information in the attached spreadsheet that lists all costs with the classifications we discussed in class, please calculate the following: 1. Break-even point (as a bundle of both the Standard Model and the Baleno Model). Please keep in mind the following steps a. For variable costs, you will need to determine the variable cost per unit for each model b. For mixed costs, after determining how much is related to variable cost per unit, you will need to determine how much is total fixed cost c. You will need to determine the contribution margin for | cach model d. Each bundle consists of 4 units of Standard models and I unit of the Baleno model. You will need to use this mix to determine the total contribution margin for the bundle 2. Break-even point in units and dollars for each model based on the sales mix of 4 to 1. Please keep in mind the following a. The above is the break-even point for a bundle b. Each bundle consists of 4 units of Standard models and I unit of the Baleno model. You will need this mix to determine the break even for each model in units 3. Calculate the number of units (as a bundle) that Harsh Electrics must sell to match the level of profit earned in financial year 2010-2011. Please keep in mind the following: a. The contribution margin for the bundle was calculated in item #1 above b. For the profit, please use the Earnings before interest and tax 4:31 LTE When Onion www Share For the exclusive use of J. Brimmer, 2021. EXHTMARS ELECTRICALE RAN MATERIAL COMPONENTS, CONTANDERTORY MOLDING PERIOD Cost for Raw Material Congo Bale Modeling te ise sod 20 Motor Pome mo www. Dia kinets 190 3333 RESE 00 20 STRE ETRAS ELECTRICALS MONTHLY ELECTRICITY CONSUMPTION in who Med Machinery Ong hbsp.harvard.edu 4:31 LTE of the bene mtu www wwwww For the exclusive use of J. Brimmer, 2021. CROT 1 HARG ELECTRICALS COME STATEMENTS 2005-2013 2001- 20 C. G ting and Promotion su 70.00 16 Gun A. Palacement Custe 2000 300 www De Amor Freedo ECHT DETAILS OF FEARSETS FOR ELECTRICALS Patund CD Fundum Chow comprends For the exclusive hbsp.harvard.edu m 4:31 ) lala. He w trains , For the exclusive use of u. Brimmer, 2021. HARSELECTRICAL MARKETIO THATROY www. Tiles pud . de son Mriteratta. thai thaai plantu irulture taiy testant a The nate , PREPARATION pe wwwwwww puwe wwwwwwwwwwwww tetariat - For the exclusive use of J. Brimmer , 2021.. hbsp.harvard.edu M 4:31 LTE For the exclusive use of Srimmer, 2001, taly . www. www. Tem at y yle The as The ral kta, www.by 1 tips, , - all malay: . verde - hase For the exclusive use of J. Brimmer, 2021. WARSH ELECTRICALS MARKETING STRATEGY 4 is antari hbsp.harvard.edu 15 m 10:43 Done Attachment 12:35 Done Attachment Using the original case study and the information in the attached spreadsheet that lists all costs with the classifications we discussed in class, please calculate the following: 1. Break-even point (as a bundle of both the Standard Model and the Baleno Model). Please keep in mind the following steps a. For variable costs, you will need to determine the variable cost per unit for each model b. For mixed costs, after determining how much is related to variable cost per unit, you will need to determine how much is total fixed cost c. You will need to determine the contribution margin for | cach model d. Each bundle consists of 4 units of Standard models and I unit of the Baleno model. You will need to use this mix to determine the total contribution margin for the bundle 2. Break-even point in units and dollars for each model based on the sales mix of 4 to 1. Please keep in mind the following a. The above is the break-even point for a bundle b. Each bundle consists of 4 units of Standard models and I unit of the Baleno model. You will need this mix to determine the break even for each model in units 3. Calculate the number of units (as a bundle) that Harsh Electrics must sell to match the level of profit earned in financial year 2010-2011. Please keep in mind the following: a. The contribution margin for the bundle was calculated in item #1 above b. For the profit, please use the Earnings before interest and tax 4:31 LTE When Onion www Share For the exclusive use of J. Brimmer, 2021. EXHTMARS ELECTRICALE RAN MATERIAL COMPONENTS, CONTANDERTORY MOLDING PERIOD Cost for Raw Material Congo Bale Modeling te ise sod 20 Motor Pome mo www. Dia kinets 190 3333 RESE 00 20 STRE ETRAS ELECTRICALS MONTHLY ELECTRICITY CONSUMPTION in who Med Machinery Ong hbsp.harvard.edu 4:31 LTE of the bene mtu www wwwww For the exclusive use of J. Brimmer, 2021. CROT 1 HARG ELECTRICALS COME STATEMENTS 2005-2013 2001- 20 C. G ting and Promotion su 70.00 16 Gun A. Palacement Custe 2000 300 www De Amor Freedo ECHT DETAILS OF FEARSETS FOR ELECTRICALS Patund CD Fundum Chow comprends For the exclusive hbsp.harvard.edu m 4:31 ) lala. He w trains , For the exclusive use of u. Brimmer, 2021. HARSELECTRICAL MARKETIO THATROY www. Tiles pud . de son Mriteratta. thai thaai plantu irulture taiy testant a The nate , PREPARATION pe wwwwwww puwe wwwwwwwwwwwww tetariat - For the exclusive use of J. Brimmer , 2021.. hbsp.harvard.edu M 4:31 LTE For the exclusive use of Srimmer, 2001, taly . www. www. Tem at y yle The as The ral kta, www.by 1 tips, , - all malay: . verde - hase For the exclusive use of J. Brimmer, 2021. WARSH ELECTRICALS MARKETING STRATEGY 4 is antari hbsp.harvard.edu 15 m