Please show all work in excel spread sheet will all work and steps to complete calculation please
Selling Price $44 (accountants are cheap) DM- $14 DL -$9 Var Oh - $5 Fixed costs per year- $80,000 Currently, we are selling 6,250 pairs of Air-Accountants pe We need to determine the following: 1. Break-even units and sales dollars 2. Margin of safety in units, sales dollars, and percentage 3. Operating Leverage 4. What happens if we switch material suppliers? We woul extra $1.50 per shoe in materials but the higher quality cou a 10% increase in sales (units). Should we do this? 5. Going back to the original data, what if we spent $5,000 year and it increased sales (units)by 400 should we go for plan? 6. By what percentage would sales have to increase for the S advertising to make sense? Mr. Sole, our boss, will want to see this in an excel spreadsh questions of his own. As a result, we need to build the excels that in can be updated at a moment's notice. The excel sheet should be formatted in a prof (accountants are cheap) ar-$80,000 selling 6,250 pairs of Air-Accountants per year. mine the following: its and sales dollars ty in units, sales dollars, and percentage erage if we switch material suppliers? We would pay an hoe in materials but the higher quality could lead to n sales (units). Should we do this? the original data, what if we spent $5,000 on advertising this ased sales (units)by 4% should we go forward with this ntage would sales have to increase for the $5,000 of ke sense? s, will want to see this in an excel spreadsheet and may have wn. As a result, we need to build the excel sheet in such a way ment's notice. The excel sheet should be formatted in a professisnal manner as well Selling Price $44 (accountants are cheap) DM- $14 DL -$9 Var Oh - $5 Fixed costs per year- $80,000 Currently, we are selling 6,250 pairs of Air-Accountants pe We need to determine the following: 1. Break-even units and sales dollars 2. Margin of safety in units, sales dollars, and percentage 3. Operating Leverage 4. What happens if we switch material suppliers? We woul extra $1.50 per shoe in materials but the higher quality cou a 10% increase in sales (units). Should we do this? 5. Going back to the original data, what if we spent $5,000 year and it increased sales (units)by 400 should we go for plan? 6. By what percentage would sales have to increase for the S advertising to make sense? Mr. Sole, our boss, will want to see this in an excel spreadsh questions of his own. As a result, we need to build the excels that in can be updated at a moment's notice. The excel sheet should be formatted in a prof (accountants are cheap) ar-$80,000 selling 6,250 pairs of Air-Accountants per year. mine the following: its and sales dollars ty in units, sales dollars, and percentage erage if we switch material suppliers? We would pay an hoe in materials but the higher quality could lead to n sales (units). Should we do this? the original data, what if we spent $5,000 on advertising this ased sales (units)by 4% should we go forward with this ntage would sales have to increase for the $5,000 of ke sense? s, will want to see this in an excel spreadsheet and may have wn. As a result, we need to build the excel sheet in such a way ment's notice. The excel sheet should be formatted in a professisnal manner as well
