Calculations and spreadsheets should be prepared using Excel in a neat, easy-to-read format

1. (20 Points)

Doctors Without Borders (DWB) operates health programs around the world. It has a central general administrative management staff, and direct country staff (that directly administer the world-wide programs/mission). DWBs mission is to administer medical treatment free-of-charge to local country populations.

DWB had the following costs, with the following specific characteristics, for 2017:

Central General Management Staff Salaries-------------------880,000
Central HR GENERAL MANAGEMENT SALARIES-------------360,000
Afganistan Clinic Supplies-----------------------------750,000
Kenya Clinic Directors Salaries------------------560,000
Depreciation Central Office-------------------------34,000
Employee Benefits-Kenya Staff----------------62,000
Employee Benefits- Central Staff Administration---------220,000
Automobiles for Country Clinics in Africa--------------124,000
Doctors Salaries, Per Diem: St.Thomas, St.John Country Clinic,---------340,000
Country Clinic Rental Cost----------------------------------------------------469,000
Depreciation, Kenyan Clinics----------------------------------------------258,000
Program Management Salaries ( time studies support a level of effort of 20% General Management; and 80% Direct Program/ Local Country Program Activities-9,250,000

Allocate the costs outlined above between DWB Program Activities and Management & General based on the information and cost characteristics provided above. Please us the following format (set-up this spreadsheet in Excel):

DESCRIPTION	Doctors without Borders Schedule of Function Expenses, Year Ended December 31, 2017 DWB Program Activities	Management & General	TOTAL
SALARIES
BENEFITS
Physician Salaries
Clinical Renta TRansportation Supplies Depreciationl

What percentage of every dollar is allocated to DWBs:

Program Activities

Management & General Costs