Product Development Expenses:

Research and Development expenses: $100,000

Design costs: $50,000

Patent filing fees: $10,000

Manufacturing Costs:

Raw materials: $80,000

Labor: $60,000

Overheads: $30,000

Marketing and Sales Expenses:

Advertising: $5000

Promotions: $10,000

Website development: $1000

Operating Expenses:

Rent: $12,000

Utilities: $5,000

Salaries: $60,000

Administrative costs: $10,000

Revenue:

Ear Inserts Sold: 10,000 units

Selling price per unit: $200

Gross Revenue: $1,500,000

Depreciation and Amortization

Manufacturing Equipment: $50,000 (useful life: 5 years)

Office Furniture: $10,000 (useful life: 3 years)

Patents: $20,000 (useful life: 10 years)

Taxation:

Corporate Income Tax Rate: 8.84%

Sales Tax Rate: 7.25%

Use this information and make an Excel business budget for a company. Also, find the break-even point.