Below are the prices your supplier will charge for an item based on the order quantity....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Below are the prices your supplier will charge for an item based on the order quantity. The annual demand for this item is 10,000 units. The cost to process an order is $50 and the annual inventory holding cost is 30% of item price charged by the supplier. Enter the work and the answers in the shaded cells below. a) what is the optimal order quantity, given the below price breaks for purchasing the item? (round answer to integer] b) What price should the firm pay per unit? c) What is the total annual cost at the optimal order quantity (including purchase cost, ordering cost, and holding cost)? (Give in nearest cent, e.g, 1234.56) I Annual demand (D) Ordering cost (S) Annual holding cost (H) Range for O 1to 1499 1500-2999 3000 or more C $2.50 $2.40 $2.30 unit per order of cost of item H Annual Cost Purchas Ordering Holding Total (D/Q) S (Q/2)*H TC Adj Q DC Below are the prices your supplier will charge for an item based on the order quantity. The annual demand for this item is 10,000 units. The cost to process an order is $50 and the annual inventory holding cost is 30% of item price charged by the supplier. Enter the work and the answers in the shaded cells below. a) what is the optimal order quantity, given the below price breaks for purchasing the item? (round answer to integer] b) What price should the firm pay per unit? c) What is the total annual cost at the optimal order quantity (including purchase cost, ordering cost, and holding cost)? (Give in nearest cent, e.g, 1234.56) I Annual demand (D) Ordering cost (S) Annual holding cost (H) Range for O 1to 1499 1500-2999 3000 or more C $2.50 $2.40 $2.30 unit per order of cost of item H Annual Cost Purchas Ordering Holding Total (D/Q) S (Q/2)*H TC Adj Q DC
Expert Answer:
Answer rating: 100% (QA)
a The Economic Order Quantity EOQ formula is given by EOQ 2 D S H Where D Annual demand 10000 units ... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...
-
At December 31, Aprill Showers Company reports the following results for its calendar year Cash sales Credit sales $1,696,150 $3,135,000 In addition, its unadjusted trial balance includes the...
-
How many circuits are required to accommodate kitchen appliances in an average size home?
-
What is multi-factor authentication? What specific products are used in multi-factor authentication? What are the strengths of these products? Do they always work as intended? If not, why not, and...
-
From your break-even chart for 44.1(ii), calculate the profit or loss that will be made at levels of (i) 3,000 units; (ii) 10,000 units; (iii) 4,000 units; (iv) 7,000 units; (v) 8,500 units. Data...
-
How does a lessor account for a sales-type lease?
-
Revenue Recognition on Book Sales with High Returns) Uddin Publishing Co. publishes college textbooks that are sold to bookstores on the following terms. Each title has a fixed wholesale price, terms...
-
ABC, Inc. is a manufacturer of aluminum cans for the beverage industry. ABC purchases aluminum and other raw materials from several vendors. The purchasing process at ABC occurs as follows: When...
-
For this exercise, your client, Bright IDEAS Inc., has provided you with a listing of sales invoices. To test whether the client appears to have a receivables collectability problem, the auditor must...
-
12. A 1200 kg car is traveling around a banked exit ramp with a radius of curvature of 40 m. The road makes a 30 angle with the ground. If there is no friction on the road (it's icy) Draw an FBD for...
-
Explain how do you plan to apply strategic process in your future professional endeavors?
-
Using only the bitwise operators (&, 1,~, ^, >>,
-
Cash $ 20,000 Accounts receivable Refinishing Supplies 5,000 16,000 Tools 65,000 Accumulated Depreciation, tools $ 12,000 Accounts payable 4,000 Mark Madman, capital 4,000 Mark Madman, withdrawals...
-
A department has planned sales of $220,000, expenses of $85,000, reductions of $18,000, cash discounts of $1,800, and alteration costs of $3,200. Determine what initial markup % will result in a 7.0%...
-
Calculate the activity in millicuries of 123I produced by the 121Sb (, 2n) 123I reaction, when 200-mg natural antimony (natural abundance of 121Sb is 57.3%) is irradiated for 2 h with an -particle...
-
Question 17 of 20 < > -/3 Jason Allen, a professional athlete, currently has a contract that will pay him a large amount in the first year of his contract and smaller amounts thereafter. He and his...
-
Discuss the concept of the looking-glass self. how do you think others perceive you? do you think most people perceive you correctly?
-
Why is an independent audit committee to a company?
-
Horizon Books is a bookstore in downtown Philadelphia. It carries an inventory of approximately 5,000 books. Customers come in and browse the shelves, select their books, and take them to the...
-
Distinguish between financial and nonfinancial transactions. Give three examples of each.
-
Describe the research-based steps for buying a personal computer.
-
What are some of the advantages and disadvantages of taking a consumer dispute to small claims court?
-
Eduardo and Ana recently bought a new dining room table that they saw advertised on a furniture manufacturers Web site. When the table arrived and they opened the box, they discovered long, deep...
Study smarter with the SolutionInn App