Excel assignment

Documentation

	New Perspectives Excel 2019 | Module 8: EOM Project 2
	Expo Events
	EXPLORE BUSINESS OPTIONS WITH WHAT-IF TOOLS
Author:	Bank me
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.

Builders

	Expo Events - Builders Trade Show
	Revenue			Builders Trade Show - Profit Analysis
	Attendees	2,800		Attendees	Total Revenue	Total Expenses	Gross Profit
	Registration fee	$ 65.00		2,800	$ 182,000	$ 172,750	$ 9,250
	Total revenue	$ 182,000.00		2,200
				2,500
	Variable Expenses			2,800
	Materials	$ 55,150.00		3,100
	Variable cost per attendee	$ 24.00		3,400
	Total variable costs	$ 122,350.00
	Fixed Expenses
	Total fixed cost	$ 50,400.00		Builders Trade Show - Gross Profit Analysis
	Total expenses	$ 172,750.00		$ 9,250	$ 55.00	$ 60.00	$ 65.00	$ 70.00	$ 75.00	$ 80.00	$ 85.00
	Total expense per attendee	$ 61.70		2,200	(37,350.00)	(26,350.00)	(15,350.00)	(4,350.00)	6,650.00	17,650.00	28,650.00
				2,500	(28,050.00)	(15,550.00)	(3,050.00)	9,450.00	21,950.00	34,450.00	46,950.00
	Profit			2,800	(18,750.00)	(4,750.00)	9,250.00	23,250.00	37,250.00	51,250.00	65,250.00
	Total sales	$ 182,000.00		3,100	(9,450.00)	6,050.00	21,550.00	37,050.00	52,550.00	68,050.00	83,550.00
	Total expenses	$ 172,750.00		3,400	(150.00)	16,850.00	33,850.00	50,850.00	67,850.00	84,850.00	101,850.00
	Gross profit	$ 9,250.00

GymWear

	Expo Events - GymWear
	Revenue			GymWear - Break-Even Analysis
	Attendees	2,100		Attendees	Total Sales	Total Expenses	Gross Profit
	Registration fee	$ 85.00		2,100	178,500	167,395	11,105
	Total revenue	$ 178,500.00		2,400	204,000	175,795	28,205
				2,300	195,500	172,995	22,505
	Variable Expenses			2,200	187,000	170,195	16,805
	Materials	$ 56,995.00		2,100	178,500	167,395	11,105
	Variable cost per attendee	$ 28.00		2,000	170,000	164,595	5,405
	Total variable costs	$ 115,795.00		1,900	161,500	161,795	(295)
	Fixed Expenses			1,800	153,000	158,995	(5,995)
	Total fixed cost	$ 51,600.00		1,700	144,500	156,195	(11,695)
	Total expenses	$ 167,395.00		1,600	136,000	153,395	(17,395)
	Total expense per attendee	$ 79.71
	Profit
	Total sales	$ 178,500.00
	Total expenses	$ 167,395.00
	Gross profit	$ 11,105.00

Logistics

	Expo Events - Atlantic Logistics
	Revenue			Atlantic Logistics - Net Income Analysis
	Attendees	1,500		Registration Fees
	Registration fee	$ 95.00		8100.0	$ 85.00	$ 90.00	$ 95.00	$ 100.00	$ 105.00
	Total revenue	$ 142,500.00		1,800	11,100.00	20,100.00	29,100.00	38,100.00	47,100.00
				1,700	5,100.00	13,600.00	22,100.00	30,600.00	39,100.00
	Variable Expenses			1,600	(900.00)	7,100.00	15,100.00	23,100.00	31,100.00
	Materials	$ 49,150.00		1,500	(6,900.00)	600.00	8,100.00	15,600.00	23,100.00
	Variable cost per attendee	$ 25.00		1,400	(12,900.00)	(5,900.00)	1,100.00	8,100.00	15,100.00
	Total variable costs	$ 86,650.00		1,300	(18,900.00)	(12,400.00)	(5,900.00)	600.00	7,100.00
	Fixed Expenses			1,200	(24,900.00)	(18,900.00)	(12,900.00)	(6,900.00)	(900.00)
	Total fixed cost	$ 47,750.00		1,100	(30,900.00)	(25,400.00)	(19,900.00)	(14,400.00)	(8,900.00)
	Total expenses	$ 134,400.00		1,000	(36,900.00)	(31,900.00)	(26,900.00)	(21,900.00)	(16,900.00)
	Total expense per attendee	$ 89.60
	Profit
	Total sales	$ 142,500.00
	Total expenses	$ 134,400.00
	Gross profit	$ 8,100.00

1800 1700 1600 1500 1400 1300 1200 1100 1000 11100 5100 -900 -6900 -12900 -18900 -24900 -30900 -36900 1800 1700 1600 1500 1400 1300 1200 1100 1000 20100 13600 7100 600 -5900 -12400 -18900 -25400 -31900 1800 1700 1600 1500 1400 1300 1200 1100 1000 29100 22100 15100 8100 1100 -5900 -12900 -19900 -26900 1800 1700 1600 1500 1400 1300 1200 1100 1000 38100 30600 23100 15600 8100 600 -6900 -14400 -21900 1800 1700 1600 1500 1400 1300 1200 1100 1000 47100 39100 31100 23100 15100 7100 -900 -8900 -16900

Attendees

Net Income

Service Providers

	Expo Events - Event Service Providers
		TradeStar	General	Leary	Total
	Hours Provided	68	60	64	192
	Fixed Costs	$ 8,500.00	$ 10,000.00	$ 11,500.00
	Fixed Cost Per Hour	125.00	166.67	179.69
	Variable Costs	6,460.00	5,400.00	5,440.00
	Variable Cost Per Hour	95.00	90.00	85.00
	Total Costs	$ 14,960	$ 15,400	$ 16,940	$ 47,300
	Minimum Total Cost Model

March

	Expo Events - March Trade Shows
		Builders	GymWear	Logistics
	Revenues
	Attendees	2,800	2,100	1,500
	Registration fee	$ 65.00	$ 85.00	$ 95.00
	Total sales	$ 182,000	$ 178,500	$ 142,500
	Cost of Goods Sold
	Fixed costs	$ 50,400.00	$ 51,600.00	$ 47,750.00
	Variable cost per attendee	$ 24.00	$ 28.00	$ 25.00
	Variable costs	$ 122,350.00	$ 115,795.00	$ 86,650.00
	Total costs	$ 172,750.00	$ 167,395.00	$ 134,400.00
	Total profit	$ 9,250	$ 11,105	$ 8,100
	Profit per attendee	$3.30	$5.29	$5.40

image1.png