quantitative data

For the 9 diseases and drug regimens shown in Ex. 1 in the case, what is the total pharmaceutical cost for the country? Please submit a spreadsheet exhibit to show your calculations, including the percentage markup necessary to assure financial viability. Use the data provided on annual operating costs.

The discussion for Unit 5 should focus on the questions in the case related to a pricing decision as well as those I have posted here. There are other aspects of the decision to consider.
1.    What factors should one consider when projecting the total pharmaceutical cost for the country?
2.    What options does the Ministry have to reduce the costs if they are too high?
3.    How does one come up with a pricing strategy to assure financial sustainability of the community pharmacies?    1