User Account

All Pages

Petaluma jewelry case - how to increase revenue

Assignment Help Managerial Accounting
Reference no: EM131870434

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

Verified Expert

This is an analysis of a case study. It is about the price at which a jewelry product should be sold to achieve the desired net profit after tax. It involves calculation of total variable costs, total fixed costs, fixed cost per unit, and contribution.

Reference no: EM131870434

Questions Cloud

What should be the elements of a zero-policy ethics policy : What should be the elements of a zero-policy ethics policy? What if any are missing from Siemens Global.
Study in fertility control : A certain scientist concluded his study in fertility control as follows: "So far one result has emerged from the before-and-after survey, and it is a key
Prepare journal entries for transactions : Prepare journal entries for the transactions that occurred in June, July, and August. The company uses a perpetual inventory system
Review problem on the homosexuality : Can employers protect the rights of people whose religion teaches them that homosexuality is immoral and those people who are sexual preference minorities.
Petaluma jewelry case - how to increase revenue : 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
Hypothesis that the new conditions grow no better plants : (a) At the 5 % significance level, test the hypothesis that the new conditions grow no better plants.
How would payment differ if you paid interest only : The furniture store offers you a 3-year loan with an 11 percent APR. What are the monthly payments? How would the payment differ if you paid interest only?
Calculate the prob-value : (a) Calculate the prob-value, and interpret.
What are the challenges of delivering learning to employees : Employee Training and Development (HR 313) - What are the challenges of delivering learning to employees who work on the road or at home?

Reviews

inf1870434

5/9/2018 6:07:03 AM

This is a complicated financial model. So other cells are just inputs required for doing the contribution per batch and break-even analysis. For instance, the rows in dark green calculate the fixed cost per batch. The final output of these rows is the fixed cost per batch. This fixed cost per batch is used as input in the contribution per batch and break-even analysis given in the cells marked in "light green". The cells marked in yellow give the profit after tax of Tiffany's at the current price per batch. I have explained all the formula clearly in the text box too.

inf1870434

5/9/2018 6:06:18 AM

PLease log in to : UMUC username:, Password: Choose MY CLASSES, then choose: DMBA 620 9042 Effective Financial and Operations. Then choose CONTENT: then WEEK 4. BREAK EVEN ASSIGNMENT You will have access to all instructions and materials to complete assignment. I need a 100%, this should help. I expect a large discount due to the last 2 assignment were on 80% correct. In the attached excel sheet i have marked in light green, the contribution per batch analysis. This is the main analysis. It also contains the break even analysis.

len1870434

2/20/2018 2:34:49 AM

Then choose CONTENT: then WEEK 4. BREAK EVEN ASSIGNMENT You will have access to all instructions and materials to complete assignment. I need a 100%, this should help. The report should be appropriate for your client, with all recommendations thoroughly supported by data and logic. All calculations should be shown,step by step, done by using Excel. Submit a single Excel file in your assignment folder that contains your calculations, CVP graph, and the report to your client. Be sure to proofread. Title your file, "Jewelry case week 4."

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd