Excel project on Product profitability and introduction to BudgetingHere are the factsCoco Raven Designer Dog Beds makes beds for favorite dogs. There are $3$ types Mini for small Dogs Cute for medium Dogs Bruiser for large Dogs Pricing and costs are as follows:Mini$4$ yards of material$2$ cubic feet of stuffing$4$ hours of laborCute$6$ yards of material$2$ cubic feet of stuffing$6$ hours of laborBruiser$6$ yards of material$4$ cubic feet of stuffing$8$ hours of laborCosts:$$3$ per yard of material$$1$ per cubic foot of stuffing$$20$ per hour of laborOverhead is $150\%$ of labor costPart $1$On Product cost and price sheet $2,$ develop costs and pricing for each productPart $2$On Budget sheet, develop budgets at noted levelBudget at following levels of salesSales Level $1$ Level $2$ Level $3$Mini $405010$Cute $608020$

Bruiser $8010040$Part $3$On Breakeven Sheet, develop Breakeven level of salesBreakeven sales with a sales mix of $20\%$ mini, $40\%$ cute, $40\%$ bruiserother factsExecutive Support $$200,000$Executive Overhead $$400,000$Other Costs $$500,000$

Mini Cute BruiserMaterialStuffingLaborOverheadTotal CostsRequired pricing$(50\%$ profit$)$

BudgetsLevel $1$ Level $2$ Level $3$SalesMiniCuteBruiserCOGSMiniCuteBruiserContribution MarginOther CostsExecutive SupportExecutive OverheadOther CostsNet Profit

Breakeven Salesbreak even salesyou will need to use a weighted average contribution margin calculation