Question
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
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 summary 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
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%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started