discussion question
Assignment
| Assignment: |
| Chris is interviewing for a new job and the company requested the following from Chris via email. |
| Consider you are playing the role of Chris and prepare the document for the interview. |
| On the Discussion Board, upload the prepared document and provide a sumary of your analysis. |
From: Stephanie Date: Fri, Apr 5, 20xx at 11:13 AM Subject: Trunk Club - Candidate Assessment To: Chris Hi Chris, Hope you are having a great week! Below, I have attached your project for your upcoming interview. This exercise will helpu us assess your ability to analyze data based on the attached P&L statement. While knowledge of how financial statements work is helpful, it is not necessary to draw conclusions from the data. Consider using your Excel knowledge to compare Actual vs. Budget, Current Year vs. Prior Year, etc. (both as actual $ and as % increase/decrease). Please plan to summarize of your findings during your interview (focus on three key take-aways). Any specific questions about the project, please reach out to Annette . We look forward to having you onsite! Best, Stephanie
P&L statement
| Trunk Club | ||||
| Profit and Loss - Summary | ||||
| $ in 000's | ||||
| Actual | Forecast | Budget | Last Year | |
| TCM - Field | 4.9 | 5.0 | 4.7 | 3.8 |
| TCW - Field | 16.7 | 15.9 | 14.1 | 9.7 |
| Total Field | 21.6 | 20.9 | 18.8 | 13.5 |
| TCM - In-House | 1.1 | 1.3 | 1.4 | 1.9 |
| TCW - In-House | 1.9 | 1.1 | 2.1 | 1.5 |
| Total In-House | 3.0 | 2.4 | 3.4 | 3.4 |
| TCM - Custom | 0.7 | 1.7 | 1.7 | 1.4 |
| Net Sales | 25.3 | 25.0 | 23.9 | 18.3 |
| Fee Revenue | 0.1 | 0.2 | 0.1 | 0.1 |
| Net Revenue | 25.4 | 25.2 | 24.0 | 18.4 |
| Total COGS | 10.9 | 10.9 | 10.5 | 7.8 |
| Gross Margin | 14.6 | 14.2 | 13.5 | 10.6 |
| % of net revenue | 57% | 57% | 56% | 58% |
| Fulfillment Expense | 1.9 | 2.1 | 1.9 | 1.7 |
| % of net revenue | 8% | 8% | 8% | 9% |
| Fulfillment Labor | 1.4 | 1.2 | 1.0 | 0.7 |
| % of net revenue | 5% | 5% | 4% | 4% |
| Sales Team | 3.4 | 3.4 | 3.6 | 3.3 |
| % of net revenue | 13% | 13% | 15% | 18% |
| Selling Margin | 7.9 | 7.6 | 7.0 | 4.9 |
| % of net revenue | 31% | 30% | 29% | 26% |
| Direct Team | 0.3 | 0.4 | 0.4 | 0.3 |
| Other Direct | 0.1 | 0.3 | 0.2 | 0.1 |
| Allocated | 0.2 | 0.2 | 0.2 | 0.1 |
| % of net revenue | 2% | 3% | 3% | 3% |
| Direct Op. Margin | 7.4 | 6.7 | 6.2 | 4.3 |
| % of net revenue | 29% | 27% | 26% | 23% |
| Marketing | 3.6 | 3.9 | 3.0 | 3.2 |
| Occupancy | 1.0 | 1.0 | 1.0 | 0.9 |
| Corp Team | 1.9 | 2.0 | 2.0 | 1.7 |
| Corp Expenses | 0.6 | 0.7 | 0.5 | 0.5 |
| Pre-Allocation EBIT | 0.2 | (0.9) | (0.3) | (2.0) |
| % of net revenue | 1% | -4% | -1% | -11% |