Purchase Solution

Increasing Order Fill Rates and Develop Strategic Profit Model

Not what you're looking for?

Ask Custom Question

Please see attached Case Study for Paper2Go.com and respond to the following Case Questions:
1. You are the logistics analyst at Paper2Go.com and have been asked to do the following:
a. Calculate the financial impact of increasing order fill rates to 98% from 92%.
b. Develop a strategic profit model of both the old system and the modified system that reflects the suggested adjustments.

Please cite any outside sources and fully explain (and show work for) order fill rate calculation and strategic profit model if applicable.

Attachments
Purchase this Solution

Solution Summary

Determining the impact of increasing the order fill rate from 92% to 98%. Also, develop a strategic profit model to show the impact of increasing the order fill rate from 92% to 98%.

Solution Preview

Increasing Order Fill Rates and Develop Strategic Profit Model

Please see attached Case Study for Paper2Go.com and respond to the following Case Questions:
1. You are the logistics analyst at Paper2Go.com and have been asked to do the following:
a. Calculate the financial impact of increasing order fill rates to 98% from 92%.
b. Develop a strategic profit model of both the old system and the modified system that reflects the suggested adjustments.

Please cite any outside sources and fully explain (and show work for) order fill rate calculation and strategic profit model if applicable.

A. ) In order to calculate the Revenue and Profit for the order fill rate at 92%, the total number of orders 500,000 is multiplied by 92% to calculate the number of orders filled at 92% (460,000). Next, the total number of orders (500,000) is subtracted from the number of orders filled at 92% (460,000) is 40,000, which is the number of orders not filled on time. Finally, number of orders not filled on time (40,000) is multiplied by 85%, which is 34,000.

The revenue for orders filled on time is calculated by multiplying the Average Revenue per on Time Order ($150) by the number of orders filled at 92%, which is $69,000,000. The revenue for orders not filled on time is calculated by multiplying the Average Revenue per on Time Order ($150) by the number of replenishment orders filled at 85% of not filled on time (34,000), which is $5,100,000.
Papers2Go.com costs for each rehandled order is $15. The total rehandling cost fee is calculated by multiplying the rehandled order fee ($15) by the number of replenishment orders filled at 85% of not filled on time (34,000), which is $510,000.

Papers2Go.com costs for each invoice reduction for rehandled orders per order is $30. The total invoice reduction for rehandled orders fee is calculated by multiplying the Invoice reduction for rehandled order fee ($30) by the number of replenishment orders filled at 85% of not filled on time (34,000), which is $1,020,000.
The annual payment on the $40,000,000 loan payment is calculated with the following formula: P = r(PV)/(1-(1+r)^-n) where P = Annual ...

Purchase this Solution


Free BrainMass Quizzes
Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Motivation

This tests some key elements of major motivation theories.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.