FLAGLAND MUSEUM In 1928, Josiah P. Flagland, a Southern railroad owner, established an endowment to fund the Flagland Museum in Palatka. Whereas the museum currently has a 30 million dollar endowment, it also has substantial operating costs and continues to add to its eclectic collection that encompasses paintings, photographs, drawings, and design objects post-1900. Annual earnings from the endowment (approximately $2,100,000 in 2021) are not sufficient to cover operations and acquisitions, and the museum's trustees and president are conscious of the need to generate income from admissions, special exhibits, and museum store sales. Spencer Lambert, photographic curator, is in the process of planning an exhibition of O. Winston Link photographs, which will run from September through November of 2022. Below is a preliminary budget, prepared by Spencer, of revenue and costs associated with the exhibition: Note Revenue (10,000 x 15) $150,000 1 Less: Lease of photographs from other museums and collectors $89,000 2 Packing and transportation of photographs from collectors 5,000 3 Event insurance 4,000 4 Spencer Lambert salary (25%) 22,000 5 Jacob Williams salary (25%) 12,500 6 Guard service 15,000 7 Installation costs 4,000 8 Advertising 5,000 9 Exhibition printed programs 3,000 159,500 10 Profit (loss) ($9,500) Notes Estimated attendance is 10,000 and admission to the exhibit is $15. Some photographs will come from the Flagland collection while others will be leased from other museums and collectors. Cost of packing transportation to and from the Flagland Museum. Insurance to cover photographs during the run of the exhibition. Twenty-five percent of annual salary for Spencer Lambert, head photography curator. Twenty-five percent of annual salary for Jacob Williams, assistant photography curator. Cost of guard service for exhibition. Painting of exhibition room to off-white background. Advertising in newspapers and public radio. Cost of programs describing the work of O. Winston Link and pictures at exhibition. Additional information In preparing the budget, Spencer assigned 25 percent of his and his assistant's annual salaries to the exhibition since they will each spend approximately three months on the project. An admission fee of $8 is charged to enter the museum, and attendance at the exhibition is an additional $15 per person. Approximately one-fifth of the individuals who are estimated to attend the exhibition would have come to the museum whether or not the exhibition is being held. (Alternatively, four-fifths of the individuals are coming specifically to attend the exhibition.) Analysis of prior data indicates that 25 percent of visitors to the museum make a purchase at the museum store, and the average purchase price is $8. The store has a 40 percent gross margin (sales minus cost of sales) and net profit (sales minus cost of sales minus staff salaries and other operating costs) per dollar of sales of 5 percent. Required Prepare an analysis of the financial impact of the exhibition on the Flagler Museum assuming attendance is 10,000. Does offering the exhibition appear to be a good decision from a financial standpoint? Give reasons for and against having the exhibition. How many people must attend the exhibition for its financial impact to be project neutral (i.e., the museum will be no better off nor no worse of financially?) Write a short memo to Spencer Lambert explaining the errors in his calculations. Most importantly: Incorporate an Excel sheet showing all calculations with "What IF" equations added into the spreadsheet