Excel project on Product profitability and introduction to Budgeting

Assume a 20% profit margin. Include tables for each section.

Here are the facts

Coco 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 labor

Cute

6 yards of material

2 cubic feet of stuffing

6 hours of labor

Bruiser

6 yards of material

4 cubic feet of stuffing

8 hours of labor

Costs:

$3 per yard of material

$1 per cubic foot of stuffing

$20 per hour of labor

Overhead is 150% of labor cost

Part 1

On Product cost and price sheet 2, develop costs and pricing for each product

Part 2

On Budget sheet, develop budgets at noted level

Budget at following levels of sales

Sales Level 1 Level 2 Level 3

Mini 40 50 10

Cute 60 80 20

Bruiser 80 100 40

Part 3

On Breakeven Sheet, develop Breakeven level of sales

Breakeven sales with a sales mix of 20% mini, 40% cute, 40% bruiser

other facts

Executive Support $200,000

Executive Overhead $400,000

Other Costs $500,000