HomeworkAnswersForecasting Case Analysis MGT 3332 The Fresh Detergent Case
Sep 18, 2025
Excel
A local entrepreneur, Frodo Baggins, buys old computers, fixes them, and resells them to the public.
Create excel formulas that will calculate the price of each car that includes the Fredo’s cost, repair expense, and the markup percentage. Frodo determines the selling price of a computer by calculating how much money he has put into the repair, including the cost of the computer, and then marking up that price by a certain percent to get the sale price.
You have to use Excel formulae and functions in this exam. Please use NESTED IF formula with data from the above table to calculate the Markup Price.
|
Make |
Year |
Frodo's Cost |
Repair Expense |
|
Lenovo |
2018 |
$900 |
$0 |
|
IBM |
2012 |
$600 |
$100 |
|
HP |
2019 |
$500 |
$100 |
|
Apple |
2016 |
$900 |
$0 |
|
Lenovo |
2016 |
$400 |
$100 |
|
HP |
2015 |
$400 |
$200 |
|
Apple |
2014 |
$800 |
$5000 |
|
IBM |
2013 |
$500 |
$80 |
|
SONY |
2012 |
$300 |
$100 |
This markup percent can be determined from the table below.
|
Begin year |
End Year |
Markup Percent |
|
2018 |
Present |
50% |
|
2016 |
2017 |
45% |
|
2014 |
2015 |
40% |
|
2012 |
2013 |
35% |