Excel Assignment Review

Documentation

Seattle Popcorn
Author:	Larry Neal
Date:	08/062012
Purpose:	To perform a profit analysis based on the manufacturing cost
	of each unit, the selling price of each unit, and the fixed monthly
	operating expenses.

Profit Analysis

						Units Sold	Revenue	Expense
						0	$0	$30,000
						500	$6,500	$35,000
						1,000	$13,000	$40,000
						1,500	$19,500	$45,000
						2,000	$26,000	$50,000
						2,500	$32,500	$55,000
						3,000	$39,000	$60,000
						3,500	$45,500	$65,000
						4,000	$52,000	$70,000
						4,500	$58,500	$75,000
						5,000	$65,000	$80,000
						5,500	$71,500	$85,000
	Sales Price per Unit:	$13				6,000	$78,000	$90,000
	Manufacturing Cost per Unit:	$10 Bojan: Comment: Call Joe Heller in Cost Accounting for unit cost data.				6,500	$84,500	$95,000
	Fixed Monthly Expense:	$30,000				7,000	$91,000	$100,000
	Break-Even Point (Units Sold):	10,000				7,500	$97,500	$105,000
	Revenue at Break-Even Point:	$130,000				8,000	$104,000	$110,000
						8,500	$110,500	$115,000
						9,000	$117,000	$120,000
						9,500	$123,500	$125,000
						10,000	$130,000	$130,000
						10,500	$136,500	$135,000
						11,000	$143,000	$140,000
						11,500	$149,500	$145,000
						12,000	$156,000	$150,000
						12,500	$162,500	$155,000
						13,000	$169,000	$160,000
						13,500	$175,500	$165,000
						14,000	$182,000	$170,000
						14,500	$188,500	$175,000
						15,000	$195,000	$180,000
						15,500	$201,500	$185,000
						16,000	$208,000	$190,000
						16,500	$214,500	$195,000
						17,000	$221,000	$200,000
						17,500	$227,500	$205,000
						18,000	$234,000	$210,000
						18,500	$240,500	$215,000
						19,000	$247,000	$220,000
						19,500	$253,500	$225,000
						20,000	$260,000	$230,000

Break-even Analysis

My Name

Profit Analysis

Revenue 0 500 1000 1500 2000 2500 3000 3500 4000 4500 5000 5500 6000 6500 7000 7500 8000 8500 9000 9500 10000 10500 11000 11500 12000 12500 13000 13500 14000 14500 15000 15500 16000 16500 17000 17500 18000 18500 19000 19500 20000 0 6500 13000 19500 26000 32500 39000 45500 52000 58500 65000 71500 78000 84500 91000 97500 104000 110500 117000 123500 130000 136500 143000 149500 156000 162500 169000 175500 182000 188500 195000 201500 208000 214500 221000 227500 234000 240500 247000 253500 260000 Expense 0 500 1000 1500 2000 2500 3000 3500 4000 4500 5000 5500 6000 6500 7000 7500 8000 8500 9000 9500 10000 10500 11000 11500 12000 12500 13000 13500 14000 14500 15000 15500 16000 16500 17000 17500 18000 18500 19000 19500 20000 30000 35000 40000 45000 50000 55000 60000 65000 70000 75000 80000 85000 90000 95000 100000 105000 110000 115000 120000 125000 130000 135000 140000 145000 150000 155000 160000 165000 170000 175000 180000 185000 190000 195000 200000 205000 210000 215000 220000 225000 230000

10000 130000

Units Sold

Print Worksheet