Reference no: EM131922842
Question: The questions that need to be answered in an excel sheet are:
1. Incremental analysis
2. Break Even Analysis
3. Contribution Margin
Scenario: Your team has been hired to provide financial analysis for a start-up company, Bobble in Style, which produces customized bobble heads. The bobble heads are made out of less rigid materials and are more true to life than those of competitors. The company inventors, Mr. and Mrs. Lee, are going to pitch their idea to Shark Tank in a few months, but first they need to have a better understanding of the business financials. The Lee's are already creating and selling their product from their home-based office and work area. They know what costs are involved with making the bobble heads on a small scale, but they don't have an understanding of financial figures beyond basic costs. They need you to make sense of various financial figures for them.
1. Incremental Analysis:If production does increase dramatically after their presentation on Shark Tank, the Lees will need more space for production. They have two options. Option 1 is to rent out a spacious warehouse nearby. If they pursue this option, there rent will be $1200 per month and utilities are estimated to cost an additional $350 per month. Their second option, Option 2, is to rent a smaller storefront space that is also nearby. The storefront rent is $1350 per month. However, utilities will likely only cost an additional $150 per month. They want to compare their options over one year's time (since each rental contract is a 1 year commitment). What is the incremental analysis if the Lees choose Option 1 over Option 2?
2. Break-Even Analysis: You have been asked to calculate how many units need to be sold to break even, based on the costs provided in task #3. Assume that only one conference will be attended and the estimated expenses associated with this conference are on target. Use the information in task #3 except do not consider taxes.)
3. Contribution Margin: Based on the Break-Even Analysis just performed, what is the contribution margin per unit and the total contribution margin?
What are items that are not considered authoritative
: What are items that are not considered authoritative according to Topic 105? Log onto the DeVry University online library and click on LexisNexis.
|
Identify the resources events and agents
: Write a response to the following assignment from the Core Concepts of Accounting Information Systems text: Identify the resources, events, and agents
|
Prepared from the reaction of p-nitroaniline
: Para red, also called American Flag Red, a bright-red ago dye, is easily prepared from the reaction of p-nitroaniline, sodium nitrite, and 2-naphthol
|
What is the percent by mass of carbon found
: What is the percent by mass of carbon found in caffeine C8H9N4O2 what is the mass of carbon in milligrams found in 95mg of caffeine
|
What is the contribution margin per unit
: Contribution Margin: Based on the Break-Even Analysis just performed, what is the contribution margin per unit and the total contribution margin?
|
What is the product for the reaction
: What is the product for the following reaction? CH3CHCH3CCH + 2HBr --> ??
|
What is the ph of the hf solution
: A 35.00-mL solution of 0.2500 M HF is titrated with a standardized 0.1453 M solution of NaOH at 25°C.
|
Describe approach you will take to ensure adequate nutrition
: Describe the approach you will take to ensure adequate nutrition for the newborn, with or without breastfeeding. Provide rationale for your answer.
|
Solution after the following additions of titrant
: Find the pH during the titration of 20.00 mL of 0.1000 M triethylamine, (CH3CH2)3N (Kb = 5.2 × 10-4 ), with 0.1000 M HCl solution after the following additions
|