Refer to the Medical Supplies for Banjul case. From the corresponding exercise in Chapter 3, review the design of a spreadsheet that will enable you to request the required funds from your team’s finance officer, order supplies from the home office, and ensure dissemination of appropriate quantities to each village. Your final order to the home office should specify the number of packages required of each item.

a. The population figures will show that there are 3,000 children, 2,500 teenagers, 500 seniors, and 9,000 other adults in the population. If there were no stock on hand, what amount would be required for ordering supplies?
b. Using the parameters in (a), construct a graph showing how the amount required for the order would vary if the unit cost of a package of bandages rose by $0.25, $0.50, and so on, up to $3.00 per package.
c. Following up on (a), a check on stock shows an inventory of 124 packages of A-bandages, 16 packages of B-bandages, 82 packages of C-bandages, 72 rolls of tape, and 4 hearing aids. What amounts will be required for ordering supplies?