A garage band wants to hold a concert

Reference no: EM13287494

"A garage band wants to hold a concert. The expected crowd is 3,000. The average expenditure on concessions is $15. Tickets sell for $10 each, and the band’s profit is 80% of the gate, along with concession sales, minus a fixed cost of $10,000. To clarify, the band only gets 80% of the all of the revenue including both ticket sales and concession sales.

Assume for now that all of the input variable are known with certainty and that the concert venue has sufficient capacity to hold 3200 people. However, for your first Base Model, let’s IGNORE the concert venue capacity constraint. In other words, pretend that the venue can hold an unlimited number of people.

Your goal is to build a spreadsheet model that will allow you to do things like find the breakeven level of ticket sales and do some sensitivity analysis to some of the inputs."

Reference no: EM13287494

Questions Cloud

Compute the max height above the ground : A gray kangaroo can bound across level ground with each jump carrying it 9.2 from the takeoff point. what is the max height above the ground

Find the lumped element values of the open-circuited line : An open-circuited 50 Ω microstrip transmission line is used ina microwave amplifier circuit to provide a capacitance of 3.2 pF at2.3 GHz. (a) Find the appropriate electrical length of the line

Explain the barometric pressure in a cavern : The barometric pressure in a cavern was measured using a mercury barometer. A value of 74.2 cm of Hg was obtained. How many atmospheres is this

Specify the dimensions having zero-thickness outer conductor : A transmission line constructed from perfect conductors and airdielectric is to have a maximum dimension of 8mm for its crosssection. The line is to be used at high frequencies. Specify the dimensions if it: (a) a two-wire line with Zo = 300 Ω

A garage band wants to hold a concert : "A garage band wants to hold a concert. The expected crowd is 3,000. The average expenditure on concessions is $15. Tickets sell for $10 each, and the band’s profit is 80% of the gate, along with concession sales, minus a fixed cost of $10,000. To cl..

Explain the empirical formula of a compound : Determine the empirical formula of a compound that is 36.86% N and 63.14% O by the mass

Formal organization and the informal organization coexist : Can the formal organization and the informal organization coexist within the same organizational structure? Why, or Why not?

Determine the energy delivered in the time interval : The charge entering the positve terminal of an element is given by the expression q(t)=-12e^(-2t) mC. The power delivered to the element is p(t)=2.4e^(-3t) W. Compute the current in the element, the voltage across the element,

What is the variance of the distribution : David Axehead sells new cars for Axehead Ford. David usually sells the largest number of cars on Saturday. He has developed the following probability distribution for the number of cars he expects to sell on a particular Saturday.

User Account

All Pages