Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Analytics Methods Models And Decisions

Authors: James R. Evans

2nd Edition

321997824, 978-1119298588, 978-0321997821

More Books

Students also viewed these General Management questions