Use the eoq model with quantity discounts to determine

Assignment Help Basic Statistics
Reference no: EM131105131

Sarah operates a concession stand at a downtown location throughout the year. One of her most popular items is circus peanuts, selling about 200 bags per month. Sarah purchases the circus peanuts from Peter's Peanut Shop. She has been purchasing 100 bags at a time. However, to encourage larger purchases, Peter now is offering her discounts for larger order sizes according to the following price schedule, where the price for each category applies to every bag purchased.

Sarah wants to use the EOQ model with quantity discounts to determine what her order quantity should be. For this purpose, she estimates an annual holding cost rate of 17 percent of the value (based on purchase price) of the peanuts. She also estimates a setup cost of $4 for placing each order. Follow the instructions of Prob. 19.3-17 to analyze Sarah's problem.

Prob. 19.3-17

Kenichi Kaneko is the manager of a production department which uses 400 boxes of rivets per year. To hold down his inventory level, Kenichi has been ordering only 50 boxes each time. However, the supplier of rivets now is offering a discount for higher-quantity orders according to the following price schedule, where the price for each category applies to every box purchased.

The company uses an annual holding cost rate of 20 percent of the price of the item. The total cost associated with placing an order is $80 per order. Kenichi has decided to use the EOQ model with quantity discounts to determine his optimal inventory policy for rivets.

(a) For each discount category, write an expression for the total cost per year (TC) as a function of the order quantity Q.

(b) For each discount category, use the EOQ formula for the basic EOQ model to calculate the value of Q (feasible or infeasible) that gives the minimum value of TC. (You may use the analytical version of the Excel template for the basic EOQ model to perform this calculation if you wish.)

(c) For each discount category, use the results from parts (a) and (b) to determine the feasible value of Q that gives the feasible minimum value of TC and to calculate this value of TC.

(d) Draw rough hand curves of TC versus Q for each of the discount categories. Use the same format as in Fig. 19.3 (a solid curve where feasible and a dashed curve where infeasible). Show the points found in parts (b) and (c). However, you don't need to perform any additional calculations to make the curves particularly accurate at other points.

(e) Use the results from parts (c) and (d) to determine the optimal order quantity and the corresponding value of TC.

(f) Use the Excel template for the EOQ model with quantity discounts to check your answers in parts (b), (c), and (e).

(g) For discount category 2, the value of Q that minimizes TC turns out to be feasible. Explain why learning this fact would allow you to rule out discount category 1 as a candidate for providing the optimal order quantity without even performing the calculations for this category that were done in parts (b) and (c).

(h) Given the optimal order quantity from parts (e) and (), how many orders need to be placed per year? What is the time interval between orders?

Reference no: EM131105131

Questions Cloud

Default risk of various municipal and corporate bonds : Agencies such as Moody's, Fitch, and Standard & Poor's rate the default risk of various municipal and corporate bonds. While their rating systems are proprietary, it is widely known that they rely on financial ratios as key inputs to their bond ra..
Record the adjusting entry for the provider : Calculations after an end of period stock-take revealed a closing stock (balance) of $5,000. There was an opening balance of $3,000 and during the period $8,800 of supplies were purchased.
Find the number of zeros of the function : Let p be a nonzero polynomial with nonnegative coefficients, ? ⊂ C a bounded open region, ?¯ its closure, and  f: ?¯ → C a continuous function analytic on ?. Prove that the function p(|f(z)|) achieves a maximum on the boundary ∂?. Find the number ..
The optimal production schedule that satisfies the monthly : Suppose that production planning is to be done for the next 5 months, where the respective demands are r1 = 2, r2 = 4, r3 = 2, r4 = 2, and r5 = 3.
Use the eoq model with quantity discounts to determine : Sarah operates a concession stand at a downtown location throughout the year. One of her most popular items is circus peanuts, selling about 200 bags per month.
What portion of the organizational costs will be expensed : Production equipment $815,000 Travel costs of salaried employees 40,000 License fees 14,000 Training of local employees for production and maintenance operations 120,000 Advertising costs 85,200 What portion of the organizational costs will be exp..
What would be synthias cost of factoring the receivables : The fair value of the recourse obligation is $15,000. Assuming all receivables are collected, what would be Synthia's cost of factoring the receivables?
What would they need to limit the material and labor costs : Assuming no direct factory overhead costs (i.e., inventory carry costs) and $3 million dollars in combined promotion and sales budget. Given their product currently is priced at $35.00, what would they need to limit the material and labor costs to?
Prepare a multi-step income statement and a retained earning : Multi-step Income, Retained Earnings) Presented below is information related to American Horse Company for 2004. Prepare a multi-step income statement and a retained earnings statement.

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd