Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please use the IF function and show the work in Excel! Vladimir owns a store that sells rare and exotic lizards to reptile pet owners.
Please use the IF function and show the work in Excel!
Vladimir owns a store that sells rare and exotic lizards to reptile pet owners. He usually sells each lizard for $25. Due to the amount of time breeding lizards takes, and uncertainty in demand, he has two suppliers with two different prices. The low cost supplier can supply a maximum of 50 lizards per month at $5 per lizard. Beyond this demand, Vladimir must go to his second supplier who can provide a seemingly unlimited number of lizards for $10 per lizard. a. Build a model to calculate Vladimir's monthly profit using good modelling practices. b. How much profit does Vladimir make when he sells 30 lizards? C. How much profit does Vladimir make when he sells 70 lizardsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started