Question: 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
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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts