Do all work in Excel with Formulas An office supply store open 5 days a week must determine the best inventory policy for boxes of copier paper. Weekly demand is nearly constant at 250 boxes and when orders are placed, then entire shipment arrives at once. The cost per box is $22 and the inventory holding cost is 30%. Orders are placed at a cost of $40 each, including preparation time and communication charges, and the lead time is 2 days. a. Find the optimal order quantity. b. What is the reorder point? c. How often should an order be placed? d. What is the cycle time?

Question

Do all work in Excel with Formulas

An office supply store open 5 days a week must determine the best inventory policy for boxes of copier paper. Weekly demand is nearly constant at 250 boxes and when orders are placed, then entire shipment arrives at once. The cost per box is $22 and the inventory holding cost is 30%. Orders are placed at a cost of $40 each, including preparation time and communication charges, and the lead time is 2 days.

a.

Find the optimal order quantity.

b.

What is the reorder point?

c.

How often should an order be placed?

d.

What is the cycle time?

Expert Answer

1 Rating

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Business
Operations Management

Inventory Management

Related Operations Management Q&A

Find answers to questions asked by students like you.

Q: Describe the operations function and the nature of the operations manager’s job.

A: An Operation is the process of converting inputs into outputs at the same time adding some value to ...

Q: What are the characteristics of purchasing and supply management?

A: Purchasing is the procedure of buying goods from suppliers for a company. The characteristics of pur...

Q: Given the following network and activity time estimates, determine: The expected time and varian...

A: Given data,  Activity  a m b A 5 9 14 B 1 6 15 C 3 7 10 D 6 8 19 E 3 11 14 F 2 9 14 ...

Q: Why is it important to match supply and demand? If a manager believes that supply and demand will no...

A: The supply and demand has to be equal. If supply is more than demand it means the product will remai...

Q: What is the amount of the difference between the variable costing and absorption costing net operati...

A: Absorption costing: It is a type of costing where all the manufacturing costs are treated as invento...

Q: What is the difference between TOC and Lean synchronisation?

A: The theory of constraints states that the bottlenecks in a system are the only constraints to the th...

Q: Baxter Corporation’s master budget calls for the production of 5,000 units per month and $144,000ind...

A: Click to see the answer

Q: Explain Rebalancing the Assembly Line?

A: Assembly-line balancing: Assembly-line balancing is a procedure in the manufacturing strategy where ...

Q: COQ Histogram; Spreadsheet Application Genova Company classifies its costs of quality intofour categ...

A: Given data, Cost  2019 2020 2021  Prevention Cost  1.00% 4.00% 2.00% Appraisal Cost  3.00 2.5...

Q: Show that if ˆ is an unbiased estimator of θ andvar()ˆ Z 0, then ˆ 2 is not an unbiased estimator of...

A: Click to see the answer

Q: Consider the job of a server at Boston Pizza. Design a new employee onboarding program for this job....

A: Training programmes paint a picture of the company in the minds of the employees. The way it is cond...

Q: Discussion the criteria of selecting curriculum content.

A: Steps VALIDITY INTEREST UTILITY LEARNABILITY FEASIBILITY SELF-SUFFICIENCY SIGNIFICANCE 

Q: What is the formula for calculating number of possible schedules ?

A: The formula for calculating number of possible schedules is:

Q: Explain the key aspects of operations management decision making.

A: The operation manager plays a vital role in decision making and planning. The decision making includ...

Q: State one main argument by corporatism theory in studying the public policy process.

A: According to corporatism theory, workers and employers would be organized into industrial and profes...

Q: What are the five steps in theory of constraint?

A: TOC is an organizational change method that is focused on improving its profits. The basic premise o...

Q: Understand the process structure in services and how to position a service process on the customer-c...

A: The process structure falls under the classification of procedure the executives. A procedure struct...

Q: What is corporate social responsibility?

A: Corporate social responsibility A company must look into its impact on the social and environmental ...

Q: Condo Construction Company is going to First NationalBank for a loan. At the present time, the bank ...

A: Cost of overstock:Co=0.10 Cost of under-stock: Cu=0.25-0.10=0.15

Q: Cost-of-Quality (COQ) Reporting CVI Inc. had November sales totaling $4,200,000 andincurred the foll...

A: 1.

Q: Explain Nested Processes?

A: Nested process is created by breaking down the process into smaller tasks and then further breaking ...

Q: What is the role of risk preference in performance evaluation?

A: Performance evaluation is the process of assessing the way the employees effectively perform to fulf...

Q: You work in a small bookshop which specializes in selling business books to businesses and occasiona...

A: 1) Strategic planning refers to a process that is used by organizations to achieve their goals and o...

Q: Do cost management practices change over the product’s sales life cycle? Explain how

A: A product goes through different stages during its lifetime. The stages are: 1. Introduction to mark...

Q: Describe how lean systems can facilitate the continuous improvement of processes.

A: In order to comprehend how lean systems can facilitate the continuous improvement of processes, let ...

Q: Explain program evaluation and review technique (PERT)?

A: PERT refers to Program Evaluation and Review Technique is a technique adopted by organizations to an...

Q: Wood County Hospital consumes 1,000 boxes of bandages per week. The price of bandages is $35 per box...

A: Click to see the answer

Q: What type of company can benefit from an activity-based costing system?

A: Service companies, merchandising companies, manufacturing companies benefit from ABC system.

Q: What is the differences between strategic planning at small versus large firms ?

A: The strategic planning of an organization is the documentation and form a direction for the organiza...

Q: We are thinking of filming the Don Harnett story. Weknow that if the film is a flop, we will lose $4...

A: Click to see the answer

Q: Explain the Dimensions of Customer Contact in Service Processes?

A: The measurements and dimensions of customer contact are physical presence, what is prepared & Pr...

Q: Smith Co. is a firm specializing in financial advice for retired individuals. After some analysis, y...

A: Earning Multipler is a term of financial terminology that helps in finding out the company's current...

Q: What is the first step in project analysis?

A: Project analysis is a process of evaluating various components of project. This is to confirm whethe...

Q: Distinguish between product costs and period costs

A: A manufacturer's product costs are the direct materials, direct labor, and manufacturing overhead us...