Petaluma Jewelry Case - July 2017
Write a short report directed to Ms. Tiffany Nadeau with your recommendation on how to increase revenue, supported with a pro-forma contribution income statement which incorporates your recommendations. You should show all calculations in a Microsoft Excel document.
Include a breakeven analysis for zero profit and a second analysis to achieve an after tax target income of $240,000 for Ms. Nadeau and provide your conclusion.
The report to Ms. Nadeau can be written in a Textbox. Textboxes automatically wrap text in a separate worksheet in the same Excel document.
Submit one document that contains your calculations, the 2 breakeven analyses, and the report. Be sure to proofread. A PowerPoint presentation "Petaluma Jewelry Hints" has been posted in this week's module to get you started.
Required Multimedia:
Breakeven Analysis and Contribution:
1. Breakeven Analysis and Contribution by James Slocombe
2. Breakeven Analysis - Charts by James Slocombe
Required Readings:
* Capital budgeting
* Simon, Herman. Confessions of the Pricing Man, Springer International Publishing, 2015. Chapter one. ISBN: 978-3-319-20399-7 (e-reserves)
The report should be appropriate for your client, with all recommendations thoroughly supported by data and logic.
Attachment:- Case.rar