Your task is to provide recommendations concerning the optimal size of the new Riverside Stand. You have been provided an Excel file (called Ticket Sales.xlsx available on Moodle) showing the forecast for average number of tickets per game that could potentially be sold from 2022 to 2041. The demolition and building of the new stand will incur a fixed cost of £55 million. The fixed cost includes the construction of 3,000 seats (a minimum requirement), restaurants, meeting facilities, and bars. The owners have the option of further increasing the capacity. For every additional 1,000 seats, the variable cost is £3 million (e.g., a 7,000 seat stand would cost £67 million). The maximum allowable capacity of the new stand is 10,000 seats. Your clients have informed you that they are planning to draft a contract stipulating that 30% of the project's costs must be paid the day building works start (1 July 2022). A further 10% will be payable when work is completed (1 April 2024, just in time for the 2024 season). The remaining costs need to be paid in equal monthly payments at the end of each month during construction.

d = 1,000 - 20p and p must be between $10 and $45 How many units can the firm sell at $10?

Some venture capitalists learned in economics that total revenue is the total receipts a seller receives from selling goods to buyers, and that it can be written as P x Q, which is the price of goods times the quantity of goods sold. They hold the plans to the next "hot" technology gizmo that everyone will want to buy. In pricing the item, they made some assumptions: 1) For small quantities purchased, set the price low to invite people to get familiar with the product. 2) For large quantities purchased, set the price low as preferential treatment for your best customers. 3) Limit the number that can be purchased to a maximum of 1000 units. 4) An analyst recommends that the selling price for 500 units be $2500, or you will price yourself out of the market. They have hired you as a consultant to make a recommendation about what the maximum revenue will be for the company under this business plan. Even though the units may be sold in different quantities, the central question to ask is, "If all the purchases involved the same exact number of items, what would be the revenue for the company under that condition, and when would the revenue be as big as possible?" This would provide a ceiling figure to report back to the investors.

d = 1,000 - 20p and p must be between $10 and $45 By how many units does a $1 increase in price decrease demand?

d = 1,000 -20p and p must be between $10 and $45 Which of the following pricing alternatives the business is considering maximizes revenue? A $20 B $25 C $30 D $40

Patients arrive at a hospital accident and emergency department at random follow a Poisson distribution at a rate of 5 per hour. (a) Find the mean number and the standard deviation of the patients during any-minute period. (a) Find the probability that, during any 90-minute period, the number of patients arriving at the hospital accident and emergency department is exactly 6 at least 3

The Excel file HATCO consists of data related to predicting the level of business (Usage Level) obtained from a survey of purchasing managers of customers of an industrial supplier, HATCO. The following are the independent variables. • Delivery Speed-amount of time it takes to deliver the product once an order is confirmed.. Price Level-perceived level of price charged by product suppliers. • Price Flexibility-perceived willingness of HATCO representatives to negotiate price on all types of purchases. •Manufacturing Image-overall image of the manufacturer or supplier. . • Overall Service-overall level of service necessary for maintaining a satisfactory relationship between supplier and purchaser. • Sales Force Image -overall image of the manufacturer's sales force. • Product Quality-perceived level of quality of a particular product. . Size of Firm-size relative to others in this market (0=small; 1= large). Responses to the first seven variables were obtained using a graphic rating scale, where a 10-cm line was drawn between endpoints labeled "poor" and "excellent." Respondents indicated their perceptions using a mark on the line, which was measured from the left endpoint. The result was a scale from 0 to 10 rounded to one decimal place. Using the tools in this chapter, conduct a complete analysis to predict Usage Level. Be sure to investigate the impact of the categorical variable Size of Firm (coded as 0 for small firms and 1 for large firms) and possible interactions. Also stratify the data by firm size to account for any differences between small and large firms. Write up your results in a formal report to HATCO management. REQUIRED: Analysis of the excel data attached with formulas, calculations and graphs. And a report of the results.