Ignore the part that says appendix A.

But using excel answer part b) using a spreadsheet to calculate the profit of every of selling price and weekly order size .

4) 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. Weekly Order Price per Package 70 Less than 1000 packages 1000-1499 56 1500-1999 50 2000 or more 40 The vegetable buyer estimates the quantity that can be sold per week, at various selling prices, as follows: Selling Price Packages Sold per Week $1.20 300 90 600 1200 80 66 1700 52 2300 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