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