Compute the total relevant costs for the six items using eoq

Assignment Help Operation Management
Reference no: EM13867265

The May-Bee Company distributes smart devices. Approximately 50 percent of the company's SKU are imported and the rest are acquired from domestic suppliers. May-Bee sales have been increasing at a steady rate and future trends appear very optimistic. The company is wholly owned by a Mr. Brown, who relies heavily on the bank for working capital. The current credit limit is set at $150,000, and Mr. Brown is experiencing some resistance from his banker in getting more cash to increase his investment in inventories to meet an anticipated increase in sales.

In the past Brown has used only simple decision rules for ordering from his suppliers. He orders a three-week supply of SKUs that cost more than $10 per unit and a six-week supply of items that cost less than $10 per unit.

Last year May-Bee's average inventory was around $1,000,000. He paid $19,500 interest on his bank loan, $80,000 rent for his warehouse, and $15,000 to insurance companies. Brown believes it would be profitable to increase his bank loan because he feels he could probably earn 15 percent on the borrowed money.

The following six items represent 30 percent of May-Bee's annual dollar sales volume and are according to Brown, his bread and butter.

SKU Number

Value/unit ($)

Annual Demand (unites)

1

15.78

6,400

2

40.50

2,200

3

18.30

4,500

4

8.40

3,500

5

9.70

6,000

6

25.00

4,800

*Items imported from the same supplier

Brown gets directly involved with the ordering of imported items because for these items he has to go to the bank to get a letter of credit and, on average, spends about sixty minutes per order doing so. An order for imported items had in the past included from one to ten SKUs.

The following table gives a summary of the costs involved in placing an order. These estimates were supplied by the persons involved, who guessed at the amount of time involved in each activity.

Hourly Person Involved

Rate ($)

Time Per Order (minutes)

Domestic

Imported

Typist

3.00

20

24

Inventory clerk

3.20

20

20

Receiver

4.50

30

30

Bookkeeper

4.20

20

20

Mr. Brown

20.00

20

60

In addition, there was a charge of $10 per order, which represented the bank charge for the letter of credit for imported items, whereas the bank charges were only $0.25 per order for items acquired from domestic suppliers.

1) This cost description was compiled by the bookkeeper. In your opinion, are there any costs that have been left out? Comment briefly.

2) Compute May-Bee's carrying cost (r)

3) Compute the cost of placing an order for a single domestic and for a single imported SKU

4) Compute the EOQ for six items.

5) Compute the total cycle stock for the six items under current ordering rules.

6) Compute the total relevant costs for the six items using EOQ

7) Compute the different in total relevant costunder (5) and (6). Estimate the change in total relevant costs for all the 100 items.

8) Compute the total number of replenishments for the samples of six items under the current system and under the EOQ policy.

9) Draw an exchange curve of total relevant costs versus N for imported items. From the graph calculate the increase or decrease in total relevant costs if the combined total number of orders for the three imported items is charged to thirty-six per year.

10) Compute the total relevant costs (ordering costs plus holding cost) under the current systems and under the EOQ policy. What are the estimated savings (percent) if the EOQ policy is applied throughout the whole population?

Reference no: EM13867265

Where does leadership fit into the picture

Think of an organization that has been in existence for as long as you can remember. A Fortune 500 company for example. Why and how has the company managed to survive all th

Where else does the website discuss their commitment

Describe in detail how the company shared its commitment to quality on the website. For example, is Quality mentioned in the Mission Statement? Where else does the website d

Evaluate and describe the types of leadership

Evaluate and describe the types of leadership and decision making you have observed in the public or nonprofit organizations where you have worked and which styles were the

Why a tagline is an important part of blue ocean strategy

Describe why a tagline is an important part of blue ocean strategy. Evaluate a tagline for a product from a publicly traded company, in an industry you have not used in the co

Explain the primary priority rules for job sequencing

Explain the four primary priority rules for job sequencing. In what instances at the Nissan car manufacturing might each rule be most advantageous? When would each rule be m

Create a process map

Create a Process Map- Assume you drank a cup of coffee or tea this morning. Did you make it yourself or did you buy it? Draw a detailed process map illustrating the activity

How much slack is currently available in non-critical path

Reconfigure the chart above into a critical path diagram for project scheduling similar to the diagram shown in this module's lecture. What is the duration of the project? Ho

Evaluation of the project cost and schedule variances

Project Schedule and Cost Management- Evaluation of the project manager's compression of the project  schedule and Evaluation of the project cost and schedule variances

Reviews

Write a Review

 
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