For this assignment, we will be performing a financial analysis using two different pricing methods to calculate their monthly profits and determine which pricing option results in the best outcome for the funeral home. As a future business owner/manager, this is a typical analysis you should be performing to determine how to strategize best for your firm. In reality, you would need a lot more data than a few months due to the inherent fluctuations of our business to draw true strategic results. Please use the file below to input your results with the required written summary:

Funeral Home A

They utilize a fixed multiplier of 2.5 for their caskets

January

Model Name	Quantity	Wholesale Price (per unit)
Dakota	4	$875
Sebring	8	$1,150
Claire	11	$545
Horizon	5	$895

February

Model Name	Quantity	Wholesale Price (per unit)
Dakota	7	$875
Sebring	4	$1,150
Claire	20	$545
Horizon	9	$895

Funeral Home B

They utilize a fixed dollar amount of $1,000 for their caskets

January

Model Name	Quantity	Wholesale Price (per unit)
Dakota	4	$875
Sebring	8	$1,150
Claire	11	$545
Horizon	5	$895

February

Model Name	Quantity	Wholesale Price (per unit)
Dakota	7	$875
Sebring	4	$1,150
Claire	20	$545
Horizon	9	$895

For your assignment, I want you to determine the total Wholesale Cost of both funeral homes, total sales and Gross Margin. Lastly, input which method results in a better profit to the funeral home. Also, include which pricing method you prefer and reasoning