a. Open a new workbook.
b. Do the following on sheet1.
c. Enter all given data.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4fXi6j85ITj2eDbl1FKaqHXcyheERI_i8XZMEA_lTaQt9KFGkcDbZXknbmtu7D_5BE6aCkCcYkx-MzBX5-KBTBNnsnfr8rQjPCwWe9XFCwABWPd0kJouTUK8ShiL-_zJkwGIod18i1ngx/s320/page1.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwlfQa03f6_ZyihNFxJEMjkPef3lAP9A9IOKlOLZaz_zxrCobdKIqMA42ddSHUNh9sVwYroGSkT_H0wwYnCwQLXmA_tnldOcQORhL9luQGyYeNPsoA82B8lXHP2G0KbV8oQeSmz2t-as-z/s320/page2.jpg)
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)
No comments:
Post a Comment