Executive Solution Overview
– ## Week2-Part2and3Instructions.doc – ## Week2-Hands-On1ManolaDepartmentStore.xlsx **## Week2-Part2and3Instructions.doc** [removed] **## Week2-Hands-On1ManolaDepartmentStore.xlsx** ## Sheet1 | | | | | | | | | | — | — | — | — | — | — | — | — | | Manola Department Stores, Inc. | | S…
Instant Solution Download
$6.99Immediate access to the full model answer, formatted citations, and rubric breakdown.
Need a Fresh Custom Paper?
Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →Assignment Prompt & Instructions
– ## 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 |
**## 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 |
**## 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 |
**## 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 |
– 1
– 2