Computer Science - Machine Learning Excel Assignment
hercules224
7 months ago
15
files (2)Week2-Part2and3Instructions.doc
Week2-Hands-On1ManolaDepartmentStore.xlsx
Week2-Part2and3Instructions.doc
[removed]
Week2-Hands-On1ManolaDepartmentStore.xlsx
Sheet1
| Manola Department Stores, Inc. | |||||||
| Six-Month Financial Projection | |||||||
| January | February | March | April | May | June | Total | |
| Revenue | $ 1,475,000.00 | $ 1,406,000.00 | $ 1,116,600.00 | $ 1,496,000.00 | $ 1,102,900.00 | $ 1,455,000.00 | $ 8,051,500.00 |
| Cost of Goods Sold | $ 206,718.75 | $ 263,437.60 | $ 222,487.60 | $ 290,875.00 | $ 206,793.75 | $ 214,743.76 | $ 1,405,056.46 |
| Gross Margin | $ 1,268,281.25 | $ 1,142,562.40 | $ 894,112.40 | $ 1,205,125.00 | $ 896,106.25 | $ 1,240,256.24 | $ 6,646,443.54 |
| Expenses | $ - 0 | ||||||
| Bonus | $ 7,500.00 | $ 7,500.00 | $ - 0 | $ 7,500.00 | $ - 0 | $ - 0 | $ 22,500.00 |
| Salary | $ 367,426.00 | $ 351,210.00 | $ 296,650.00 | $ 374,500.00 | $ 276,725.00 | $ 286,265.00 | $ 1,952,776.00 |
| Bonus | $ 7,500.00 | $ 7,500.00 | $ - 0 | $ 7,500.00 | $ - 0 | $ - 0 | $ 22,500.00 |
| Site Rental | $ 147,650.00 | 140.600.00 | $ 118,660.00 | $ 149,000.00 | $ 110,290.00 | $ 114,500.00 | $ 640,100.00 |
| Marketing | $ 1,447.50 | $ 49,175.00 | $ 41,631.00 | $ 82,430.00 | $ 38,601.00 | $ 40,065.50 | $ 253,350.00 |
| Miscellaneous | $ 1,467.50 | $ 49,175.00 | $ 41,631.00 | $ 52,430.00 | $ 36,601.50 | $ 40,065.50 | $ 221,370.50 |
| Total Expenses | $ 525,491.00 | $ 597,660.00 | $ 498,572.00 | $ 665,860.00 | $ 462,217.50 | $ 480,896.00 | $ 3,230,696.50 |
other Questions(10)
- ACC - NEWGRADE ENERGY INC.
- Hume’s two best arguments for this claim: humans regularly manifest their commitment to and belief in the doctrine of determinism concerning human behavior.
- APUSH Summer Assignment 2014
- WEEK 6 FIN DISCUSSION FOR XOON
- FOR BEST OF BEST ONLY 5 7 i
- What are some of the ways Cisneros put together her novel
- 2-3 pages with references please and no plagirazm
- POS 421 Week 4 Complete (Windows Server Networking) A+ Graded
- NETW206 W3 Assignment 2
- Goodwriter
