Report-Foxtrot-S-Per06-6202.xlsx - FINANCIAL REPORT FIRM S...

Info icon This preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
FINANCIAL REPORT – FIRM S – PERIOD 6 Company Profit & Loss Statement Period 0 Period 1 Revenues 26,115 27,307 Cost of goods sold -8,783 -8,617 Inventory holding costs -374 -634 Inventory selling costs 0 0 Contribution before marketing 16,958 18,056 Advertising media -3,840 -3,840 Advertising research -160 -160 Commercial team costs -1,224 -1,248 Contribution after marketing 11,734 12,808 Market research studies -245 -505 Research and development 0 -2,380 Loan reimbursed 0 0 Loan received 0 0 Interests paid 0 0 Exceptional costs or profits 0 0 Earnings before taxes 11,489 9,923 All numbers in thousands of dollars Market Contribution Sonites Vodites Revenues 27,159 4,018 Cost of goods sold -16,465 -3,684 Inventory holding costs -1,585 -217 Inventory selling costs 0 0 Contribution before marketing 9,109 116 Advertising media -1,665 -1,360 Advertising research -232 -240 Commercial team costs -2,178 -1,386 Contribution after marketing 5,034 -2,870 Market research studies -366 -335 Research and development 0 -1,720 Net contribution 4,667 -4,925 All numbers in thousands of dollars Product Contribution SOFT SOHI Sonites Sonites Revenues 5,916 285 Cost of goods sold -2,608 -171 Inventory holding costs -495 -5 Inventory selling costs 0 0 Contribution before marketing 2,812 109 Advertising media -680 -85 Advertising research -90 -15 Commercial team costs -870 -103
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Contribution after marketing 1,172 -94 All numbers in thousands of dollars Retail and Selling Prices SOFT SOHI Sonites Sonites Rec. retail price 210 430 Average retail price 194 419 Average selling price 133 267 Market Shares SOFT SOHI Sonites Sonites Market share - Unit 2.0% 0.0% Market share - Value 1.4% 0.1% Distribution Coverage and Volume Sold Specialty Stores SEACY Vodites 35% SEXY Vodites 26% SOFT Sonites 26% SOHI Sonites 13% SOLO Sonites 43% SOSATE Sonites 28% Sales, Production and Inventory SOFT SOHI Sonites Sonites Volume sold 45 1 Planned production 188 1 Actual production 150 1 Inventory at beginning of period 0 1 Inventory at end of period 106 0 All numbers in thousands of units Unit Cost, COGS and Inventory Holding Cost SOFT SOHI Sonites Sonites Volume sold 45 1 Unit cost (current) 58 157 Unit cost (average) 58 161
Image of page 2
Cost of goods sold 2,608 171 Inventory at end of period 106 0 Inventory holding costs 495 5 All numbers in thousand of units, except unit costs in $ and Cost of goods sold in Research and Development Projects MARKET : SONITES No. of Features POSOLOM3 5 7 POSOLOM2 4 7 POSOFTM 3 9 POSATE 2 10 POSOLOM 2 7 POSOFT 0 5 POSOLO 0 7 Unit costs are given in $. Cumulative budget and Budget required for completion MARKET : VODITES Resolution PESAUCY 6 65 PESEXY 5 65 Unit costs are given in $. Cumulative budget and Budget required for completion Available since Period Available since Period
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Period 2 Period 3 Period 4 Period 5 Period 6 Period 7 22,294 31,981 52,645 66,121 31,177 -5,952 -19,401 -29,434 -36,579 -20,150 -548 -982 -534 -67 -1,802 0 -1,008 -305 0 0 15,793 10,590 22,372 29,476 9,225 -3,400 -4,025 -4,330 -5,600 -3,025 -600 -475 -765 -975 -472 -1,401 -1,649 -2,732 -3,823 -3,564 10,392 4,441 14,546 19,077 2,164 -483 -493 -482 -895 -739 -4,244 -1,884 -391 -6,660 -1,720 0 0 0 0 -700 0 0 0 8,800 0 0 0 0 -440 -440 0 0 0 0 0 5,665 2,064 13,672 19,883 -1,434 SOLO SOSATE SEACY SEXY Sonites Sonites Vodites Vodites 16,758 4,200 1,316 2,701 -11,443 -2,243 -969 -2,715 -1,002 -83 -178 -39 0 0 0 0 4,313 1,875 169 -52 -680 -220 -510 -850 -97 -30 -90 -150 -897 -308 -618 -768
Image of page 4
2,639 1,316 -1,050 -1,820 SOLO SOSATE SEACY SEXY Sonites Sonites Vodites Vodites 280 480 975 700 266 466 945 658 176 299 603 442 SOLO SOSATE SEACY SEXY Sonites Sonites Vodites Vodites 4.4% 0.6% 1.6% 4.4% 4.2% 1.1% 1.6% 3.3% Distribution Coverage (% outlets) Volume sold Online Stores Specialty Stores Online Stores 34% 29% 1,302 468 412 54% 39% 1,596 2,904 1,612
Image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern