Hello. I need help with my Milestone I, for my final project in ACC-207 (Cost Accounting). I will post below exactly the format and information that I have. I want to understand what I am doing, and I am having a hard time, as it is an online course. Can someone please fill in the correct answers with an explanation so I understand how all is calculated and inputted. Thank you in advance!

- For Milestone one, analyze costs, contribution margin, and breakeven point for the bird feeder division of the company. Complete a cost-volume-profit analysis to determine how many bird feeders must be sold at the current cost and sales price level to earn a $10,000 profit and how much the sales price would have to increase to earn a $10,000 profit at the same cost and sales volume level.

a) Classify all product and period costs appropriately.

b) Compute a cost-volume-profit analysis. What are the implications of this analysis?

c) Compute contribution margin per unit and contribution margin ratio.

d) Determine the breakeven quantity and the breakeven revenue accurately.

e) Determine if the company is breaking even. What are cost-volume-profit analysis implications on short-term planning?

I. Sales and Manufacturing Expenses: Budget and Actual (2014)

You will use this table to complete Milestones One and Two.

	Budget ($)	Actual ($)
Sales	1,050,000	991,700
Expenses:
Materials (Clear)	225,000	248,160
Materials (Plastic)	37,500	37,741
Factory worker labor	300,000	332,760
Materials - Indirect	3,000	2,585
Factory depreciation	78,000	78,000
Factory utilities	12,000	12,000
Factory maintenance and repairs	5,000	4,500
Shipping ($2.25/each)	112,500	105,750
Sales commissions ($2.00/unit sold)	100,000	94,000

Office rent	12,000	12,000
Advertising	20,000	20,000
Liability insurance	5,000	5,000
Office depreciation	1,000	1,000
Office salaries	48,000	48,000

Total Expenses

959,000

1,001,496

Below is the exact spreadsheet copy and pasted from excel. I can send it via email if that helps. Thanks. Milestone One, Part II

50,000

Totals

Totals

Units

Budget

Actual

Sales Price per Unit

Variable Costs

Materials - Cedar

4.50

225,000

Materials - Plastic

0.75

37,500

When you do this calculation you get $4.50 for Cedar and $0.75 Plastic

Factory Worker Labor

Materials - Indirect

3,000

2,585

Shipping ($2.25/ea)

Sales Commissions ($2/unit sold)

Variable Cost per Unit

Contribution Margin

Fixed Costs

Factory Depreciation

Factory Utilities

Factory Maintenance and Repairs

Office Rent

Advertising

Liability Insurance

Office Depreciation

Office Salaries

Total Fixed Costs

Using Budgeted Amounts

Breakeven Point -

Breakeven Point -

Using Actual Amounts

Units at Current Sales Price

+ 10,000 profit

Using actual amounts

New Contribution Margin

+ 10,000 profit

Current Variable Costs

New Sales Price

Thank you to anyone!!