I need this answered in full accordance to the directions. I need both parts answered. Thanks in advance.

- Comprehensive Problem III When submitting the completed project, it should include: 1. Please show all work and number each answer accordingly. 2. Round all answers to two decimal places. Part I - Use CVP to Plan Profits - (worth a total of 21 points - 3 points for each question) Nottingham News Company has the rights to sell and deliver the city newspaper in a designated area in the country. A monthly subscription sells for $30.00 and Nottingham News pays $10.00 per month for each newspaper subscription. In addition to this variable cost, Nottingham News has fixed costs of $3,000 per month. Nottingham News currently activity level is 700 subscriptions. Required: 1. Calculate the contribution margin ratio and explain the ratio as it pertains to Nottingham News Company. 2. Use the mathematical formula to calculate Nottingham News' monthly breakeven point in units (number of subscriptions). 3. Use the shortcut contribution margin approach to calculate Nottingham News' monthly breakeven in units (number of subscriptions). 4. Prove the breakeven point by preparing a contribution margin income statement. 5. Use the contribution margin ratio, which you calculated in number one to compute Nottingham News' breakeven point in sales dollars. 6. Calculate the margin of safety ratio and explain the ratio as it pertains to Nottingham News Company. 7. The owner of Nottingham News' wants to earn a $10,000 profit per month. Calculate the sales volume in units (number of subscriptions) and sales dollars required to achieve this level of profit. Part II - Effect of Sales Mix on CVP Analysis - (worth a total of 24 points) 1 Fat Cat Furniture store sells two types of products; cat beds and scratching posts. Over the past year Fat at sold 6,000 cat beds and 4,000 scratching posts, the sales mix of 6,000 beds to 4,000 posts creates a percentage of 60% for the cat beds and 40% for the scratching posts. Fat Cat's total fixed costs are $40,000. The cat bed's unit selling price is $44.00 and variable costs per bed are $24.00. The scratching post's unit selling price is $100.00 and variable cost per post is $30.00. Required: 1. Calculate the weighted average contribution margin per unit. 2. Calculate Fat Cat's breakeven point in units for the \"package\" of products. 3. Calculate how many units of each product line the company must sell in order to breakeven. 4. Calculate the sales dollars required of each product line to breakeven Do not use the weighted average contribution margin ratio formula due to rounding issues. May still use the weighted average contribution margin per unit formula. 5. Prove the breakeven point by preparing a contribution margin income statement Make sure to provide three columns: one for Cat Beds, one for Scratching Posts, and one for Total. 6. The owner of Fat Cat Furniture wants to earn a $60,000 profit. Calculate the sales volume in units and total sales dollars of each product line the company must sell in order to earn $60,000 in profit. Do not use the weighted average contribution margin ratio formula due to rounding issues. May still use the weighted average contribution margin per unit formula. Part III - CVP Analysis - (worth a total of 5 points) 2 How will changes in sales price, variable or fixed costs, affect the breakeven point? Answer the question using the chart below. Cause Effect Contribution Margin per unit Result Breakeven Point 1. Selling Price per Unit Increase 2. Selling Price per Unit Decrease 3. Variable Cost per Unit Increase 4. Variable Cost per Unit Decrease 5. Total Fixed Cost Increase 6. Total Fixed Cost Decrease 3 PART 1-USE OF CVP TO PLAN PROFITS (NOTTINGHAM NEW COMPANY) 1.)CONTRIBUTION MARGIN RATIO(CMR) CMR=P-V/P where p =price of newspaper,v=variable cost per newspaper CMR=30-10/30=0.67 EXPLANATION: A good contribution margin ratio 2.) BREAKEVEN POINT IN UNITS USING MATHEMATICAL FORMULA(Bep) At breakeven profit =0 Bep=(P-V)Q-F=0 Bep=$(30-10)Q=$3000 20Q=3000 Q=150 newspapers 3.) BREAKEVEN POINT IN UNITS USING SHORTCUT(Bep) Bep=F/CM where F=fixed costs and CM =P-V Bep=$3000/30-20 Bep=3000/20=150 newspapers 4.) CONTRIBUTION MARGIN INCOME STATEMENT CM of Subscriptions 150(30-20) $ 3000 Fixed costs Profits At breakeven,profit is 0 5.) BREAKEVEN IN SALES DOLLARS(BepD) BepD=F/CMR BepD=$3000/2/3 BepD=$3000*3/2 BepD=$4500 6.) MARGIN OF SAFETY RATIO(MOSR) $ 3000 $0 MOSR= (Expected sales- Breakeven sales)/Expected sales MOSR= (700-150)/700 MOSR=550/700 MOSR=0.79 Explanation: Higher MOSR hence more safety 7.) Assume $10000 profit find Bep in Units and in Dollars (i)IN UNITS Bep=(F+profit)/CM Bep=($3000+$10000)/20 Bep =650 units (ii)IN DOLLAR SALES BepD=Bep*Price per unit BepD=650*$30=$19500 PART 2-EFFECTS OF SALES MIX ON CVP ANALYSIS(FAT CAT FURNITURE STORE) 1.)WEIGHTED CONTRIBUTION MARGIN(WCM) WCM=(Wc*CMc)+(Ws*CMs) where Wc= weight of cat beds in mix, CMc =contribution margin of cat beds.Ws=weight of scratching posts in mix and CMs=contribution of scratching posts WCM=(.6*(44-24))+(.4*(100-30)) WCM=(.6*20+.4*70)=$40 2.) BREAKEVEN POINT IN UNITS(Bep) Bep=F/CM Bep=$40000/$40 Bep=1000 Units 3.) UNITS OF EACH PRODUCT (i)Cat beds=W*Total Bep =(.6*1000)=600 (ii)Scratching Posts=W*Total Bep =(.4*1000)=400 4.) BREAKEVEN IN SALES DOLLARS FOR EACH PRODUCT (i)Cat Beds=Bep*price =600*$44=$26400 (ii)Scratching Posts=Bep*price =400*100=$40000 5.) CONTRIBUTION MARGIN INCOME STATEMENT Cat beds CM per unit $20 Units 600 Total CM $ 12000 Total fixed costs scratching posts $70 Total $ 40 400 1000 $28000 $40000 $40000 Profit 6.) ASSUME $60000 PROFIT FIND Bep in Units and dollars (i)IN UNITS Bep = (F+profit)/CM Bep=($40000+$60000)/$40 Bep=$100000/$40 Bep=2500 Units a)Cat beds=W*Total Units =(.6*2500)=1500 Units b)Scratching posts=W*Total Units (.4*2500)=1000 Units (ii)IN SALES DOLLARS a) Cat beds=Bep*price BepD=1500*$44=$66000 b) Scratching posts=Bep*price BepD=1000*$100=$100000 $0 PART3-CVP ANALYSIS CAUSE 1)selling price per unit increase 2)selling price per unit decrease 3)variable cost per unit increase 4)variable cost per unit decrease 5)total fixed cost increase 6)total fixed cost decrease Effect Contribution margin per unit Increase Decrease Results Breakeven point Decrease Increase Decrease Increase Increase Decrease No effect No effect Increase Decrease