Assignment Prompt & Instructions
– ## Week2-Part2and3Instructions.doc
– ## Week2-KlaporeEngineering.xlsx
– ## Week2-Hands-On1ManolaDepartmentStore.xlsx
**## Week2-Part2and3Instructions.doc**
[removed]
**## Week2-KlaporeEngineering.xlsx**
## Sheet1
| | | | | | | | | | | | |
| — | — | — | — | — | — | — | — | — | — | — | — |
| Klapore Engineering |
| Salary Report |
| Employee | Email Address | Dependants | Hours Worked | Hourly Pay Rate | Gross Pay | Federal Tax | State Tax | Net Pay | Hire Date |
| Alton, Bob | balton@ms.com | 3 | 74.5 | 35.25 | $ 2,626.13 | $ 2,626.13 | $ 131.31 | $ 2,232.21 | 9/5/10 |
| Fox, Linda | lfox@ms.com | 1 | 80 | 33.1 | $ 2,648.00 | $ 264.80 | $ 132.40 | $ 2,250.80 | 10/17/2012 |
| Handfield, Jermaine | mhandfield@ms.com | 0 | 71.75 | 28.65 | $ 2,055.64 | $ 205.56 | $ 102.78 | $ 1,747.29 | 1/15/16 |
| Jamie, Ben | bjamme@ms.com | 2 | 60 | 18 | $ 1,080.00 | $ 108.00 | $ 54.00 | $ 918.00 | 5/18/2012 |
| Nacht, Savannah | snacht@ms.com | 1 | 42.25 | 25.9 | $ 1,094.27 | $ 109.43 | $ 54.71 | $ 930.13 | 5/24/13 |
| | | | | | | | | | | | |
Klapore Engineering
[mailto:balton@ms.com](mailto:balton@ms.com)
**## 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-KlaporeEngineering.xlsx**
## Sheet1
| | | | | | | | | | | | |
| — | — | — | — | — | — | — | — | — | — | — | — |
| Klapore Engineering |
| Salary Report |
| Employee | Email Address | Dependants | Hours Worked | Hourly Pay Rate | Gross Pay | Federal Tax | State Tax | Net Pay | Hire Date |
| Alton, Bob | balton@ms.com | 3 | 74.5 | 35.25 | $ 2,626.13 | $ 2,626.13 | $ 131.31 | $ 2,232.21 | 9/5/10 |
| Fox, Linda | lfox@ms.com | 1 | 80 | 33.1 | $ 2,648.00 | $ 264.80 | $ 132.40 | $ 2,250.80 | 10/17/2012 |
| Handfield, Jermaine | mhandfield@ms.com | 0 | 71.75 | 28.65 | $ 2,055.64 | $ 205.56 | $ 102.78 | $ 1,747.29 | 1/15/16 |
| Jamie, Ben | bjamme@ms.com | 2 | 60 | 18 | $ 1,080.00 | $ 108.00 | $ 54.00 | $ 918.00 | 5/18/2012 |
| Nacht, Savannah | snacht@ms.com | 1 | 42.25 | 25.9 | $ 1,094.27 | $ 109.43 | $ 54.71 | $ 930.13 | 5/24/13 |
| | | | | | | | | | | | |
Klapore Engineering
[mailto:balton@ms.com](mailto:balton@ms.com)
**## 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-KlaporeEngineering.xlsx**
## Sheet1
| | | | | | | | | | | | |
| — | — | — | — | — | — | — | — | — | — | — | — |
| Klapore Engineering |
| Salary Report |
| Employee | Email Address | Dependants | Hours Worked | Hourly Pay Rate | Gross Pay | Federal Tax | State Tax | Net Pay | Hire Date |
| Alton, Bob | balton@ms.com | 3 | 74.5 | 35.25 | $ 2,626.13 | $ 2,626.13 | $ 131.31 | $ 2,232.21 | 9/5/10 |
| Fox, Linda | lfox@ms.com | 1 | 80 | 33.1 | $ 2,648.00 | $ 264.80 | $ 132.40 | $ 2,250.80 | 10/17/2012 |
| Handfield, Jermaine | mhandfield@ms.com | 0 | 71.75 | 28.65 | $ 2,055.64 | $ 205.56 | $ 102.78 | $ 1,747.29 | 1/15/16 |
| Jamie, Ben | bjamme@ms.com | 2 | 60 | 18 | $ 1,080.00 | $ 108.00 | $ 54.00 | $ 918.00 | 5/18/2012 |
| Nacht, Savannah | snacht@ms.com | 1 | 42.25 | 25.9 | $ 1,094.27 | $ 109.43 | $ 54.71 | $ 930.13 | 5/24/13 |
| | | | | | | | | | | | |
Klapore Engineering
[mailto:balton@ms.com](mailto:balton@ms.com)
**## 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
– 3