Question

**PLEASE SHOW ALL WORK IN EXCEL!!!!!!!**

**SHOW CALCULATIONS / FORMULAS IN
ANSWER!!!!!!!!**

You need to buy raw materials for your production process. You use 2,000 units of the raw material each year. The supplier quotes you a price of $9.50 per unit for an order size of 499 units or less, a price of $9 per unit for orders of 500 to 1499 units, and a price of $8.50 per unit for an order of 1,500 or more units. You assign an annual holding cost of 30 percent of the price of the unit to this inventory. Assume ordering cost is $60/order. What order quantity would you use if the objective is to minimize total annual costs of holding, ordering, and purchasing (be sure to identity total costs of 3 options)?

**PLEASE SHOW ALL WORK IN EXCEL!!!!!!!**

**SHOW CALCULATIONS / FORMULAS IN
ANSWER!!!!!!!!**

Answer #1

Following is the solution in excel

In condition 500 - 1499 and 1500 or more, the EOQ is 298.14 and 306.79 which do not fulfil the condition. Hence minimum order is consider and calculated based on that.

Answer - The optimal order quantity is 290.19 at the price of $9.50

Please complete all work in excel. Use excel to make the
calculations (cells can be clicked on to view any formulas used)
and be sure to identify your answer, including units.
A manager needs to buy raw materials for the production process.
For a particular raw material, the manager uses 20,000 units each
year. The supplier has quoted a price of $6.50 per unit for an
order size of 999 units or less, a price of $6 per unit for...

PLEASE SHOW ALL WORK IN EXCEL!!!!!!!
SHOW CALCULATIONS / FORMULAS IN
EXCEL!!!!!!!!
Voters arrive at a polling station at an average of 4 per minute
(Poisson) where the service rate is 50 per hour (Poisson).
a. What is the average number of voters in the system with 5
voter booths? (10 pts)
b. What is the minimum number of voting booths needed to keep
the average time in the system under three minutes? (10 pts)
PLEASE SHOW ALL WORK IN...

Please show all calculations. If using Excel, please show
formulas and data.
Practice 9:
You started with a market price of $30 and 10,000 shares.
Calculate number of shares after the split and the per share
price:
*please do this example 2 ways.
part a: calculate as 4 individual splits
part b: calculate splits as successive.... begin with the
original market price and number of shares and calculate the price
and number of shares after 4 consecutive splits
split 1:...

Please show all calculations and formulas. If using Excel (or
tables), please show data, formulas, etc.
Practice question 14:
Calculate the company’s w.a.c.c. using the info
below.
***assume this is a corporate bond that pays 2x annually when
calculating the PV of the bond
Harvey LLC’s capital structure consists of a 25-year bond issued
5 years ago with a coupon of 6% and a par value of $14,000,000. The
company’s main competitor just issued a similar bond paying 5%. The...

ITS AN EXCEL PROBLEM, PLEASE ATTACH SCREENSHOT OF EXCEL OR
EXPLAIN THE EXCEL FORMULAS YOU USED
Suppose a company is about to start
the following project, where all the dollar figures are in
thousands of dollars. In year 0, the project requires a fixed cost
of $12,000. The fixed costs is depreciated on the straight-line
basis over five years, and there is a salvage value of $1,500 in
year 5. The sales generated in years 1-5 are estimated to be...

Please show all calculations. If using Excel, please show
formulas.
Practice Question:
Calculate the NPV & IRR for the following 5 year
project:
- discount rate of 10%
- ncf yr 0 = -250,000
- ncf yr 1 = 200,000
- ncf yr 2 = 350,000
- ncf yr 3 = 300,000
- ncf yr 4 = 300,000
- ncf yr 5 = -50,000

Please complete all work in excel. Use excel to make the
calculations (cells can be clicked on to view any formulas used)
and be sure to identify your answer, including units.
Patrons arrive at a movie theater at an average of 4 per minute
(Poisson) where the service rate is 50 per hour (Poisson).
What is the average number of patrons in the system with 5
ticketing stations?
What is the minimum number of ticketing stations needed to keep
the...

Please show all calculations and explain the answer in detail.
If using Excel please show data.
practice #7
If the current exchange rate is 105 Japanese yen per U.S.
dollar, the price of a Big Mac hamburger in the United States is
$3.41, and the price of a Big Mac hamburger in Japan is 380 yen,
then other things equal, the Big Mac hamburger in Japan is
______________ (over-valued/under-valued/fairly-valued).

Please show formulas in Excel or work - My formulas keep getting
an Error and I don't know what I am doing wrong.
You want to compare two separate retirement savings scenarios:
(A) and (B). In scenario (A) you start immediately, contribute
for a few years, but then stop contributing. However, you leave
the accumulated savings to compound until retirement. In
scenario(B) you start later (after the end of savings in
scenario A) and contribute all the way to retirement....

Please SHOW YOUR Calculations and formulas in
Excel
A shareholder’s group, in lodging a protest, claimed that the
mean tenure for a chief executive officer (CEO) was at least 9
years. A survey of companies reported in the Wall Street Journal
found a sample mean tenure of ?̅= 7.27 years for CEOs with a
standard deviation of 6.38 years.
1) Formulate a hypothesis that can be used to challenge the
validity of the claim made by the shareholder’s group.
2)...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 7 minutes ago

asked 7 minutes ago

asked 49 minutes ago

asked 50 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago