Case study (need in 10 hours)
Establish (create) the COGs and SGA for a new Pediatric Healthcare center in Qingdao, China.
COGs must include Direct Cost, Labor Cost, Expenses, Number of Patients, and Total COGs. For the word report, explain each one, and how much will be for each one, also explain the criteria that you use. In Excel do the calculation, not only numbers, need to be the formulas that you used it. Forecast for 5 years, and explain the criteria that you use for forecast each component.
SAG must include indirect expenses associated with operating the pediatric center, cost of general and administrative expenses (non-medical staff), cost of selling and marketing expenses (these can include expenses associated with advertising, public relations, and other promotional activities), and the total SAG expenses by adding the general and administrative expenses and selling and marketing expenses.
For the word report, explain each one, and how much will be for each one, also explain the criteria that you use. In Excel do the calculation, not only numbers, need to be the formulas that you used it. Forecast for 5 years, and explain the criteria that you use for forecast each component.
You have to create tables and graphs for a better understanding. Remember that you have to create all this with information about Qingdao, China. Use US$ Dollar as currency.
The word report must include an introduction, body (COGs and SAG), conclusion, and lreferences.
