Excel Document
24 days ago
15
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 | [email protected] | 3 | 74.5 | 35.25 | $ 2,626.13 | $ 2,626.13 | $ 131.31 | $ 2,232.21 | 9/5/10 | ||
| Fox, Linda | [email protected] | 1 | 80 | 33.1 | $ 2,648.00 | $ 264.80 | $ 132.40 | $ 2,250.80 | 10/17/2012 | ||
| Handfield, Jermaine | [email protected] | 0 | 71.75 | 28.65 | $ 2,055.64 | $ 205.56 | $ 102.78 | $ 1,747.29 | 1/15/16 | ||
| Jamie, Ben | [email protected] | 2 | 60 | 18 | $ 1,080.00 | $ 108.00 | $ 54.00 | $ 918.00 | 5/18/2012 | ||
| Nacht, Savannah | [email protected] | 1 | 42.25 | 25.9 | $ 1,094.27 | $ 109.43 | $ 54.71 | $ 930.13 | 5/24/13 | ||
Klapore Engineering
mailto:[email protected]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)
- accounting theory revision
- reliable papers
- business statistics case analysis
- Unit V Assessment
- Political Issue
- BUS Dis 2
- How much heat is lost when 12.55 g of zinc vapor at 907 degrees celsius is cooled to 425 degrees...
- Calculus
- investigate the biotic and abiotic structure and function of an ecosystem.
- Science Discussion