Question
Excel project on Product profitability and introduction to Budgeting Here are the facts Coco Raven Designer Dog Beds makes beds for favorite dogs. There are
Excel project on Product profitability and introduction to Budgeting
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
Make Excel sheets and post images of each of the tables for each of the parts.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started