Data table for expected profit with order quantity

Reference no: EM131133985

Continuing Problem 5, create a two-way data table for expected profit with order quantity along the side and unit expediting cost along the top. Allow the order quantity to vary from 500 to 4500 in increments of 500, and allow the unit expediting cost to vary from $36 to $45 in increments of $1. Each column of this table will allow you to choose an optimal order quantity for a given unit expediting cost. How does this best order quantity change as the unit expediting cost increases? Write up your results in a concise memo to management.

Problem 5

In some ordering problems, like the one for Sam's Bookstore, whenever demand exceeds existing inventory, the excess demand is not lost but is filled by expedited orders-at a premium cost to the company. Change Sam's model to reflect this behavior. Assume that the unit cost of expediting is $40, well above the highest regular unit cost.

Reference no: EM131133985

Questions Cloud

Describe your reaction to your experience of the biases : State your position on the selected topic. Determine the biases you experienced as you examined the reasons for and against your position. Describe your reaction to your experience of these biases.

What are stocks and bonds : What are Stocks and Bonds? Describe how you could estimate their values. If you are investing in the stock market, which would you invest in and why

Long-term debt to operating property : Required a. Calculate the following for 2007, 2006, and 2005: 1. Operating ratio 2. Long-term debt to operating property

How is art a reflection of society : How is art a reflection of society? Explain with at least two examples to illustrate the relationship between art and society. These two examples may be from the text or of your own selection.

Data table for expected profit with order quantity : Continuing Problem 5, create a two-way data table for expected profit with order quantity along the side and unit expediting cost along the top. Allow the order quantity to vary from 500 to 4500 in increments of 500, and allow the unit expediting ..

Describe the business problem and charge : Describe the business problem and charge you have for marketing plan and provide a brief overview of what issue you are studying, and how a marketing perspective can help address the issue.

Describe training issues for global organizations : Formulate different developmental approaches to training, including competency models and case-based decision making. Explain organizational learning techniques.

Find the maximum charge on each capacitor : After the switch S is closed, find the maximum potential difference across each capacitor.

Compare the capital structure ratios for avon hospital : Ratio analysis. Compare the capital structure ratios for Avon Hospital against industry benchmarks. Note that during this time period, Avon has refinanced its fixed rate debt with lower variable rate debt.Compare the capital structure ratios for ..

User Account

All Pages