Table (5) Building rent 2000 Electricity and internet rent 400 3000 Salary Others 2000 According to the investigation wh
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Table (5) Building rent 2000 Electricity and internet rent 400 3000 Salary Others 2000 According to the investigation wh
Table (5) Building rent 2000 Electricity and internet rent 400 3000 Salary Others 2000 According to the investigation which was done by Ms. Layla, all the fixed cost items will be the same during the coming five years except the building rent which is expected to be grown at a rate of 15%. Use Table (3) to develop an XY-Function to describe the number of customers shown as a function of price and the variable cost as a function of number of customers. ● Use Table (4) to develop a Cubic Function to describe the number of academic events as a function of price and the variable cost as a function of number of academic events. Develop an Excel model that computes profits over the next five years (starting from year 2018) and then discounts those profits back to today's dollars by using the following discount rates: 4%, 8%, 12%, and 16% To help Ms. Layla the Investment Manager, in estimating a good price for Knowledge Café' services, find at what growth rate for the price of library materials, restaurant, and academic events the Knowledge Cafe' will reach a yearly increased in their profit for $2000? Cost in BD
Table (5) Building rent 2000 Electricity and internet rent 400 3000 Salary Others 2000 According to the investigation which was done by Ms. Layla, all the fixed cost items will be the same during the coming five years except the building rent which is expected to be grown at a rate of 15%. Use Table (3) to develop an XY-Function to describe the number of customers shown as a function of price and the variable cost as a function of number of customers. ● Use Table (4) to develop a Cubic Function to describe the number of academic events as a function of price and the variable cost as a function of number of academic events. Develop an Excel model that computes profits over the next five years (starting from year 2018) and then discounts those profits back to today's dollars by using the following discount rates: 4%, 8%, 12%, and 16% To help Ms. Layla the Investment Manager, in estimating a good price for Knowledge Café' services, find at what growth rate for the price of library materials, restaurant, and academic events the Knowledge Cafe' will reach a yearly increased in their profit for $2000? Cost in BD