I need it done and explained on how to do it In Excel thanks, Problem 14

is $9600. per day. seminar , IU seminar for the conference room, instructor compensation, . analysis. The projected fee for the is $600 per student Micromedia rents computers for its seminars at a cost of $60 per comple the numbe lab assistants, and promot a Develop a model for the total cost to put on the seminar, et of students who enroll in the seminar. b. Develop a model for the total profit if students enroll in the C. Micromedia forecasted an enrollment of 30 students for has the seminar, How muc" profit will be earned if its forecast is accurate? d. Compute the breakeven point. 14. Eastman Publishing Company is considering publishing a paperback textbook on Spicer sheet applications for business. The fixed cost manuscript of preparationtextbook design and production setup is estimated to be $160,000. Variable production and material costs are estimated to be $6 per book. Demand over the life of the book is estimated to be 4000 copies. The publisher plans to sell the text to college and university bookstores for $6 each. a. What is the breakeven point? b. What profit or loss can be anticipated with a demand of 3800 copies C. With a demand of 3800 copies, what is the minimum price per copy that the publisher must charge to break even? d. If the publisher believes that the price per copy could be increased to $50.95 and not affect the anticipated demand of 4000 copies, what action would you recommend What profit or loss can be anticipated? 15. Preliminary plans are underway for construction of a new stadium for a major league baseball . officials question profitability of the teamCity the number and luxury come boxes planned for upper deck of stadium, the the Corporations and selected individuals for for the deck area is The cost upper- may purchase a box $300,000. fixed construction 150,each box constructed. estimated to be $500000, with cost of $000 4a variable for a. What is for number of luxury boxes the "the breakeven point the in new stadium, b. Preliminary the show space is drawings for stadium that available for the construct 50 luxury boxes. Promoters indicate that buyers are available Could be sold i constructed. What is your recommendation concerning the ce tion of luxury boxes? What profit is anticipated is an investment firm that manages stock portfolio