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%