HRM 8-9

a. Open a new workbook.

b. Do the following on sheet1.

c. Enter all given data.

1.) Compute for the following.

a. Monthly Projection (Value of Return*1.75)

b. Monthly Projection (Value of Sales * 1.25)

2.) Total NET SALES (Summation of components of INCOME)

3.) Cost of Good Sold:

a. Values of Materials * 0.95

b. Values of Merchandise * 0.75

c. Values of Commission * 0.60

4.) Total GROSS PROFIT (Summation of components of COST OF GOODS SOLD)

5.) Value of Components of EXPENSES * 0.88

6.) Total EXPENSES (Summation of components of EXPENSES).

7.) NET PROFIT (TOTAL EXPENSES – GROSS PROFIT)

8.) NET INCOME (NET PROFIT – TAXES)