There are two strategies utilized to understand which path to take to maximize profit. "Strategy 1" will maximize gross revenue by increasing amount cars based on average daily rental rate of vehicle paid by customer. "Strategy 2" goal is to minimize cost by adjusting the vehicles based on monthly cost which is insuracne plus lease cost. These models are dynamic and are to be used to analyze company's inventory to reach gross revenue, cost and profit goals. The light yellow cells are editable. The "Growth rate" cell above the "Total" cell of the 2019 Projections allows the user to adjust the overall growth rate of all tiers simultaneously. The last column of "2019 Projections" highlighted yellow gives the user the ability to adjust the individual percent values of each individual tier to better forecast which tier would reach the company's goal.
-
Notifications
You must be signed in to change notification settings - Fork 0
albaug/Lariat-car-rental
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
No description, website, or topics provided.
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published