Скачать
Basic Excel: find best possible price
Автор: Hubert Pun
Загружено: 2020-10-23
Просмотров: 592
Описание:
Basic Excel operations - https://hubertpun.com
A firm needs to find the best possible price, p.
Demand = 100-p
The production cost consists of two components.
1. Fixed cost = $50.
2. Variable cost.
a. in-house production: unit cost = $10/unit; capacity = 20
b. outsource production: unit cost = $20/unit
Learning objective
If statement
Max/Min
One way table
Conditional formatting
Roadmap
1. Find Demand
2. Find revenue
3. Find production cost
4. Find profit
5. Use one-way table to find maximum profit
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
