advanced spreadsheet 8
Lola2230
NP_EX19_8a_studentname_1.xlsxDocumentation
| New Perspectives Excel 2019 | Module 8: SAM Project 1a | |
| Cairo Consulting | |
| EXPLORE BUSINESS OPTIONS WITH WHAT-IF TOOLS | |
| Author: | student name |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Management
| Cairo Consulting - Management | ||||||||||
| Sales | Management - Profit Analysis | |||||||||
| Hours Sold | 7,500 | Hours Contracted | Total Sales | Total Expenses | Gross Profit | |||||
| Price Per Hour | $ 310.00 | |||||||||
| Total Sales | $ 2,325,000.00 | 6,500 | ||||||||
| 7,000 | ||||||||||
| Expenses | 7,500 | |||||||||
| Variable Expenses | 8,000 | |||||||||
| Hours Contracted | 7,500 | 8,500 | ||||||||
| Variable Cost Per Hour | $ 190.00 | |||||||||
| Total Variable Costs | $ 1,425,000.00 | |||||||||
| Fixed Expenses | Management - Gross Profit Analysis | |||||||||
| Total Fixed Cost | $ 770,000.00 | $ 130,000 | $ 280.00 | $ 290.00 | $ 300.00 | $ 310.00 | $ 320.00 | $ 330.00 | $ 340.00 | |
| Expenses - Total | $ 2,195,000.00 | 6,500 | ||||||||
| Total Expense Per Hour Contracted | $ 292.67 | 7,000 | ||||||||
| 7,500 | ||||||||||
| Profit | 8,000 | |||||||||
| Total Sales | $ 2,325,000.00 | 8,500 | ||||||||
| Total Expenses | $ 2,195,000.00 | |||||||||
| Gross Profit | $ 130,000.00 | |||||||||
| Break-Even Analysis | ||||||||||
| Price Per Hour | $ 310.00 | |||||||||
| Cost Per Hour | $ 292.67 | |||||||||
| Hours Contracted | 7,500 | |||||||||
| Gross Profit | $ 130,000.00 |
Change
| Cairo Consulting - Organizational Change | ||||||
| Sales | Organizational Change - Break-Even Analysis | |||||
| Hours Sold | 3,750 | Hours Contracted | Total Sales | Total Expenses | Gross Profit | |
| Price Per Hour | $ 380.00 | 3,750 | 1,425,000 | 1,373,750 | 51,250 | |
| Total Sales | $ 1,425,000.00 | 3,000 | 1,140,000 | 1,175,000 | (35,000 | |
| 3,250 | 1,235,000 | 1,241,250 | (6,250 | |||
| Expenses | 3,500 | 1,330,000 | 1,307,500 | 22,500 | ||
| Variable Expenses | 3,750 | 1,425,000 | 1,373,750 | 51,250 | ||
| Hours Contracted | 3,750 | 4,000 | 1,520,000 | 1,440,000 | 80,000 | |
| Variable Cost Per Hour | $ 265.00 | 4,250 | 1,615,000 | 1,506,250 | 108,750 | |
| Total Variable Costs | $ 993,750.00 | 4,500 | 1,710,000 | 1,572,500 | 137,500 | |
| Fixed Expenses | 4,750 | 1,805,000 | 1,638,750 | 166,250 | ||
| Total Fixed Cost | $ 380,000.00 | 5,000 | 1,900,000 | 1,705,000 | 195,000 | |
| Expenses - Total | $ 1,373,750.00 | |||||
| Total Expense Per Hour Contracted | $ 366.33 | |||||
| Profit | ||||||
| Total Sales | $ 1,425,000.00 | |||||
| Total Expenses | $ 1,373,750.00 | |||||
| Gross Profit | $ 51,250.00 | |||||
| Break-Even Analysis | ||||||
| Price Per Hour | $ 380.00 | |||||
| Cost Per Hour | $ 366.33 | |||||
| Hours Contracted | 3,750 | |||||
| Gross Profit | $ 51,250.00 |
Process
| Cairo Consulting - Process | ||||||||
| Sales | Process Consulting - Net Income Analysis | |||||||
| Hours Sold | 5,500 | Average Price Per Hour | ||||||
| Price Per Hour | $ 290.00 | 187500.0 | $ 270.00 | $ 280.00 | $ 290.00 | $ 300.00 | $ 310.00 | |
| Total Sales | $ 1,595,000.00 | 3,500 | (92,500.00 | (57,500.00 | (22,500.00 | 12,500.00 | 47,500.00 | |
| 4,000 | (50,000.00 | (10,000.00 | 30,000.00 | 70,000.00 | 110,000.00 | |||
| Expenses | 4,500 | (7,500.00 | 37,500.00 | 82,500.00 | 127,500.00 | 172,500.00 | ||
| Variable Expenses | 5,000 | 35,000.00 | 85,000.00 | 135,000.00 | 185,000.00 | 235,000.00 | ||
| Hours Contracted | 5,500 | 5,500 | 77,500.00 | 132,500.00 | 187,500.00 | 242,500.00 | 297,500.00 | |
| Variable Cost Per Hour | $ 185.00 | 6,000 | 120,000.00 | 180,000.00 | 240,000.00 | 300,000.00 | 360,000.00 | |
| Total Variable Costs | $ 1,017,500.00 | 6,500 | 162,500.00 | 227,500.00 | 292,500.00 | 357,500.00 | 422,500.00 | |
| Fixed Expenses | 7,000 | 205,000.00 | 275,000.00 | 345,000.00 | 415,000.00 | 485,000.00 | ||
| Total Fixed Cost | $ 390,000.00 | 7,500 | 247,500.00 | 322,500.00 | 397,500.00 | 472,500.00 | 547,500.00 | |
| Expenses - Total | $ 1,407,500.00 | |||||||
| Total Expense Per Hour Contracted | $ 255.91 | |||||||
| Profit | ||||||||
| Total Sales | $ 1,595,000.00 | |||||||
| Total Expenses | $ 1,407,500.00 | |||||||
| Gross Profit | $ 187,500.00 | |||||||
| Break-even Analysis | ||||||||
| Price Per Hour | $ 290.00 | |||||||
| Cost Per Hour | $ 255.91 | |||||||
| Hours Contracted | 5,500 | |||||||
| Gross Profit | $ 187,500.00 |
Process Providers
| Cairo Consulting - Process Consulting Providers | ||||
| Process Pros | ABQ Consulting | Tema Han | Total | |
| Hours Provided | 500 | 0 | 5,000 | 5,500 |
| Fixed Costs | $ 178,000.00 | $ 280,000.00 | $ 26,700.00 | |
| Fixed Cost Per Hour | 356.00 | - 0 | 5.34 | |
| Variable Costs | 104,500.01 | - 0 | 1,025,000.00 | |
| Variable Cost Per Hour | 209.00 | 220.00 | 205.00 | |
| Total Costs | $ 282,500 | $ - 0 | $ 1,051,700 | $ 1,334,200 |
| Minimum Total Cost Model | ||||
All Types
| Cairo Consulting - Product Mix | |||
| Management | Organizational Change | Process | |
| Revenues | |||
| Hours Sold | 7,500 | 3,750 | 5,500 |
| Price Per Hour | $ 310.00 | $ 380.00 | $ 290.00 |
| Total Sales | $ 2,325,000.00 | $ 1,425,000.00 | $ 1,595,000.00 |
| Cost of Goods Sold | |||
| Hour Contracted | 7,500 | 3,750 | 5,500 |
| Fixed Costs | $ 770,000.00 | $ 380,000.00 | $ 390,000.00 |
| Variable Cost Per Hour | $ 190.00 | $ 265.00 | $ 185.00 |
| Variable Costs | $ 1,425,000.00 | $ 993,750.00 | $ 1,017,500.00 |
| Total Costs | $ 2,195,000.00 | $ 1,373,750.00 | $ 1,407,500.00 |
| Total Profit | $ 130,000 | $ 51,250 | $ 187,500 |
| Profit Per Hour Contracted | $17.33 | $13.67 | $34.09 |
