This analysis will require you to complete a business decision analysis on each of two different cases, and then conduct a comparative analysis between the two. You will present a final report that includes the following:

The results of your analysis (i.e. presenting analysis and conclusions for all Research Analysis Questions presented in case).

A clear rationale outlining how you conducted the analysis and why.

A comparison between the two cases that clearly outlines their similarities and differences, and strengths and weaknesses relative to each other.

The Case Scenario:

You, as a consultant, have been approached by a local business, the Widget Factory, which is seeking to develop models for sustainable profitability.

a) New Product Break-Even Analysis

The Widget Factory has developed a new product, a solar powered beach fan, that it feels has potential in the market, but wants to be assured that it will be financially viable prior to going to the next level of development. The company conducted some preliminary market research and determined that the new product, if/when launched, can be sold at $50.00 per unit.

Internal cost analysis on the manufacturing of the product, based on current assets and resources of the company, reveals the following information (NOTE: The available accounting data is in terms of units):

Fixed cost per period: $8640.00

Variable cost per unit: $30.00

Production capacity per period: 900 units

RESEARCH ANALYSIS QUESTION #1: Should the company proceed with the introduction of this product and if so, how?

b) Corporate-wide Break Even Analysis

The following information is available about the operations of the Widget Factory for the current year (Note: In this instance, the available accounting data is presented in terms of total dollars, not units).

Sales		$40000
Fixed costs	$ 12600
Variable costs	$ 16000
Total cost		$ 28600
Net income		$ 11400

Capacity is a sales volume of $60000.

RESEARCH ANALYSIS QUESTION #2: Is the company well positioned to be profitable given the parameters outlined above? Why or why not?

The Case Analysis:

In preparing your final report, your team must:

Perform a break-even analysis for each of the data sets above that includes:

an algebraic statement of the revenue function, and the cost function,

a detailed break-even chart

a computation of the break-even point of both data sets as both a percentage of capacity and in dollars.

Present the Break-Even Next for each of the data sets, include all the cost-volume-profit analysis aspects.

The program should be functioning properly such that we should be able to change the input data [through changing cells] to vary the variables and observe the changes to Total Cost, Total Revenue, & Fixed cost graphically. For example, we could change the Fixed cost, the number of items produced, the cost per unit, selling price per unit, & the variable cost individually, or in combination in cells and see the changes resulting graphically.

Prepare a consulting report for the Widget Factory that includes:

Two detailed responses to the Research Analysis Questions support by your analysis.

An interpretation of the parameters of the analysis presented, including: losses, gains, risks, and the role and significance of the break-even points presented.

A discussion of the implications of market fluctuations, and the potential for them to impact the other parameters of the case. Include recommendations for the management of the Widget Factory in regards to how they can minimize the impact of market fluctuations, and what they should be aware of when reviewing market data.