Question: Revenue, Cost, and Profit Relationships This problem introduces you to the computer-aided problem software-the PLUS computer program-and gets you started with the use of spreadsheet analysis for marketing decision making. This problem is simple. In fact, you could work it without the PLUS software. But by starting with a simple problem, you will learn how to use the program more quickly and see how it will help you with more complicated problems. Complete instructions for the PLUS software are available at the end of this text. However, while you are working with the software, you can press the H key to get help on-screen whenever you need it. Cline, the business manager at Magna University Student Bookstore, is developing plans for the next academic year. The bookstore is one of the university's non-profit activities, but any "surplus" (profit) it earns is used to support the student activities center.
Two popular products at the bookstore are the student academic calendar and notebooks with the school name. Sue Cline thinks that she can sell calendar. to 90 percent of Magna's 3,000 students, so she has had 2,700 printed. The total cost including art work and printing is $ 11.51X/ Last year the calendar sold for $5.00. but Sue is considenng changing the price this year. Sue thinks that the bookstore will be able to sell 6,000 notebooks if they are priced right. But she knows that many students will buy similar notebooks (without the school name) from stores in town if the bookstore price is too high. Sue has entered the information about selling price, quantity, and costs for calendars and notebooks in the spreadsheet program so that it is easy to evaluate the effect of different decisions. The spreadsheet is also set up to calculate revenue and profit, based on Revenue = (Selling price) x (Quantity sold), and Profit = (Revenue) - (Total cost).
Use the program to answer the questions below. Remember, you can press the H key to get help whenever you need it. Record your answers on a separate sheet of paper.
a. From the Spreadsheet Screen, how much revenue does Sue expect from calendars? How much revenue from notebooks? How much profit will the store earn from calendars? And from notebooks?
b. If Sue increases the price of her calendars to $6.00 and still sells the same quantity, what is the ex-petted revenue? The expected profit? (Note: change the price from $5.00 to $6.00 on the spreadsheet and the program will recompute revenue and profit.) On your sheet of paper, show the calculations that confirm that the program has given you the correct values.
c. Sur is interested in getting an overview of how a change in the price of notebooks would affect revenue and profit, assuming that she sells all 6.000 notebooks she is thinking of ordering. Prepare a table-on your sheet of paper-with column headings for three variables: selling price, revenue, and profit. Show the value for revenue and profit for different possible selling prices for a notebook-starting at a minimum price of $1.60 and adding 8 cents to the price until you reach a maximum of $2.40. At what price will selling 6,000 notebooks contribute $5,400.00 to profit? At what price would notebook sales contribute only $1,080.00?