Construct a financial model to determine redelivery cost

Reference no: EM131961133

Question: Construct a financial model to determine the redelivery/rehandling cost, lost sales, invoice dedution cost, and net income for the following:

a. On-time delivery increases from 90 percent to 95 percent with a 5 percent increase in transportation cost.

b. Order fill rate decreases from 96 percent to 92 percent with inventory reduced by 5 percent.

Selling price/order = $150/order

Gross profit/order = $35/order

Lost sales rate:

On-time delivery failure = 15%

Order fill failure = 20%

Supply Chain Performance Measurement and Financial Analysis 181

Annual orders = 200,000

Rehandling cost = $125/order

Invoice deduction/service failure = $150/order

Transportation cost = $1,000,000

Average inventory = $1,000,000

Interest cost = $1,500,000

Inventory carrying cost rate = 25%/$/yr.

Warehousing cost = $750,000

Other operating cost = $500,000

Cash = $3,000,000

Accounts receivable = $4,000,000

Fixed assets = $30,000,000

Tax rate = 40%

Reference no: EM131961133

Questions Cloud

Write a paper about hominin evolution and climate change : Write a research paper about Hominin Evolution and Climate Change: early genus Homo to Archaic H. sapiens. Minimum 4 full pigo, maximum 6 pages; 1-inch.

What team challenges do you think would be most enjoyable : What team challenges do you think would be most enjoyable for you? What team challenges do you think would be most problematic for you?

What is the benefit-cost ratio : What is the Benefit/Cost ratio (as a percentage return on investment) for the reduced annual maintenance cost during the first ten years of operation.

What has been the most productive way : What has been the most productive way for you to deal with your negative emotions?

Construct a financial model to determine redelivery cost : Construct a financial model to determine the redelivery/rehandling cost, lost sales, invoice dedution cost, and net income for the following.

Models of cross-cultural mergers : A discussion of the communication methods appropriate for culturally diverse recipients that could be applied to models of cross-cultural mergers

Culturally diverse society : A discussion of how to integrate varied perspectives in dynamic environments in order to lead successfully in a culturally diverse society.

Construct an asymmetric butterfly : Construct an asymmetric butterfly by buying three $950 - strike call options, buying seven $1050 - strike call options and selling ten $1020.

What is the rate of return on the incremental investment : You considering two types of automobiles. Model A costs $18,000 and has a salvage value of $9,000 after 4 years. Model B costs $16,000 and has a salvage value.

User Account

All Pages