Excel
hercules224See attachment
a year ago
15
files (2)NewInstructions.doc
Week2-Hands-On1ManolaDepartmentStore.xlsx
NewInstructions.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)
- Soc 419 Web Discussion and Assignment #4
- Only QUALITYPROFESSOR
- Patient Care Plan (For Nursing Expert Only)
- Thank you very much! Please let me know if you need help in the future! Please rate me! Godbless!
- The Genesis Energy operations management team is now preparing to implement the operating expansion plan. Previously, the firmâs cash position...
- History using books: The American Promise by Roark Johnson Fifth Edition and The American Past by Michael P. Johnson Fifth Editions
- Nyanya
- HRM 310 Week 5 Implementing Change Report
- MGT 448 Week 3 Learning Team Assignment Country Risk and Strategic Planning Analysis Paper
- HPE 170 Week 5 Individual Assignment Chronic and Infectious Diseases Paper
