The vegetable buyer for a group of grocery stores has decided to sell packages of sprouted grain in the vegetable section of the stores. The product is perishable, and any remaining unsold after one week in the store is discarded. The supplier will deliver the packages to the stores, arrange them in the display space, and remove and dispose of any old packages. The price the supplier will charge the stores depends on the size of the total weekly order for all the stores.
The sprouted grain will be sold at the same price in all the grocery stores.
(a) How many packages should be purchased per week, and at which of the five prices listed above should they be sold?
(b) Build a spreadsheet (see Appendix A) to calculate the profit for every combination of selling price and weekly order size.