When expenses and revenues are equal, this is known as the break-even point or BEP. To determine break-even, an examination of fixed and variable costs (expenses) in relationship to revenues is necessary. Understanding where the BEP is for a given product or service helps managers determine how to make modifications to increase profitability.

For this Assignment, review this weeks Media, the Weekly Briefing, and the information given below.

LaTricia Jones is planning to make a unique toy that will keep small children entertained for hours! She believes that parents everywhere will want to buy her toy, and she needs to determine her costs and the number of toys she needs to sell before earning a profit.

After researching her costs, she has come to the following conclusions.

The rental of a small facility will be $2,200 per month, insurance $500 per month, and other fixed costs are estimated at $1,300 per month. In this facility, she will be able to produce 100 toys per month at a variable cost for each toy of $5.00. She plans to sell them for $30 each.

The rent for a larger facility will be $5,000 per month, insurance $1,000 per month, and other fixed costs are estimated at $2,580 per month. In this facility, she will be able to produce 400 toys per month at a variable cost for each toy of $4.00. She plans to also sell them for $30 each.

The Assignment:

Part 1: Calculate the break-even point for LaTricia Jones' toy company under each of the two different scenarios using a spreadsheet program such as Excel. Be sure to apply the appropriate accounting process to determine the break-even points. (PLEASE USE EXCEL SPREADSHEET)

SMALL FACILITY

LARGER FACILITY

FIXED COST

$

FIXED COST

$

RENTAL

2,200.00

RENTAL

5,000.00

INSURANCE

500.00

INSURANCE

1,000.00

OTHER FC

1,300.00

OTHER FC

2,580.00

4,000.00

8,580.00

Total Capacity for Production

100 TOYS/MONTH

Total Capacity for Production

400 Toys/Month

Variable Cost

$5.00

Variable Cost

$4.00

Selling price

$30.00

Selling Price

$30.00

Break - even (Units)

Fixed Cost/(P-VC)

Break-even (units)

8,580/(30-4

4,000/(30-5)

8580/26

4,000/25

330 Toys

160 Toys

Break - even (Dollars)

Fixed Cost/{1-(VC/P)}

Break -even (Dollars)

Fixed Cost/{1-(VC/P)}

4,000/{1-(5/30)}

8580/{1-(4/30)}

4,000/1.0167

8580/1-0.13

4000/0.833

8580/0.87

N5,000.00

$9,862.00

PQ - VCQ - FC = 0
LATRICIA JONES	Smaller Facilty
Price per unit (P)	30.00
Quantity	160.00
Variable Cost per Unit (VC)	5.00
Fixed Cost (FC)	4,000.00
Profit	-

PQ - VCQ - FC = 0
LATRICIA JONES	Larger Facilty
Price per Unit	30.00
Quantity	330.00
Variable Cost per Unit (VC)	4.00
Fixed Cost (FC)	8,580.00
Profit	-

{THIS IS WHAT I DID SO FAR. PLEASE MAKE CORRECTIONS AS NEEDED}

Part 2: Recommend which option, based on the scenarios for the company, that you would select using a word processing program such as Word. Support your conclusion with both a written analysis and quantitative data.