3) The Atlas Movies Theater is planning to reprice their ticket rates to maximize revenues. They have three classes of tickets: Classic, Silver, and Gold. The table below provides information on the average ticket sales, revenue and price elasticity on demand. They have a total seating capacity of 300. The table also provides the price range within which they plan to reduce their ticket rates.

Atlas Movie Theater Ticketing
Ticket Class	Current Rate	Average Daily Sold	Elasticity	Price Range
Classic	8.45	150	-1.3	6.5	7.5
Silver	13.25	80	-2.25	11.5	12.5
Gold	17.5	30	-1.1	15.5	16.5
Total Capacity	300

According to the nonlinear model, which of the following is the projected sales figure for Classic tickets at the new price?

		172
		178
		181
		175

1. Use the table below to answer the following question(s) by invoking the binary constraints on the variables using the standard Solver. Below is the spreadsheet for a project selection model:

   	A	B	C	D	E	F	G
   1	Project Selection Model
   2
   3	Data
   4		Project 1	Project 2	Project 3	Project 4	Project 5	Available Resources
   5	Expected Return (NPV)	$160,000	$250,000	$175,000	$150,000	$225,000
   6	Cash requirements	$45,000	$70,000	$28,000	$52,000	$65,000	$175,000
   7	Personnel requirements	7	4	3	6	4	11
   8
   9	Model
   10
   11	Project selection decisions
   12	Cash Used
   13	Personnel Used
   14	Return

   What is the total return obtained from all five projects?

   		$700,000
   		$550,000
   		$860,000
   		$650,000