Question: An assembler orders two components from a single supplier. The assembler uses 200 units of the first component and 4000 units of the second component

An assembler orders two components from a single supplier. The assembler uses 200 units of the first component and 4000 units of the second component every month. The fixed transportation cost is $600. Also, the inspection and sorting costs are $100 for each component. The unit purchasing cost is $400 for the first component and $200 for the second component. The carrying cost is 20%. The assembler is trying to come up with an ordering plan that minimizes total holding and ordering costs. Find the best possible plan using the heuristic method. Calculate the average number of orders per month and order quantity for each component. In addition, calculate the total holding and ordering costs.

Please show calculation in excel as well as answer

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

An assembler orders two components from a single supplier. The assembler uses 2 5 0 units of the first component and 1 2 5 0 units of the second component. The fixed transportation cost is $ 4 0 0 ....

make project report on all * 25,000 (b) Relevant Costs of Buy for 10,000 units at 25 per unit (C) Loss to Company, by manufacturing blades In this case, the company should purchase the Blades from...

Q 1 . CAU store sells 1 , 0 0 0 jackets each month. Each jacket costs the store $ 5 0 and the company has an annual holding cost of 2 0 percent. The fixed cost of a replenishment order ( including...

I need answer in excel sheet with formulaes. Q 1 . CAU store sells 1 , 0 0 0 jackets each month. Each jacket costs the store $ 5 0 and the company has an annual holding cost of 2 0 percent. The fixed...

SHOW ALL WORK AND COMPUTATIONS. STATE YOUR CONCLUSION CLEARLY. NO CREDIT WILL BE GIVEN IF NO WORK IS SHOWN. Questions 1 %u2013 5 are worth 2 pts. each. (Total 10 pts) 1. Suppose you have a winning...

Supply Chain Management Introduction Outline What is supply chain management? Significance of supply chain management. Push vs. Pull processes utdallas.edu/~metin 1 A Generic Supply Chain Sources:...

Montonya Company has the following selected data for the current year: Sales (10,000 units) $90,000 Direct materials 30,000 Direct labor costs 10,000 Variable manufacturing overhead 3,500 Fixed...

hello, need help with a accounting quiz I have attached: 1) quiz 2)pdf files CH. 18- CH 21 Chapter 18 \"Managerial Accounting Concepts/Job Costing\" from Accounting Principles: A Business...

This assignment is very urgent! Be as Accurate as possible providing explanations to each answer. Chapter 1 1.Managerial Accounting and Financial Accounting differ in the following way: A. Financial...

A capacitor is connected across the terminals of an ac generator that has a frequency of 440 Hz and supplies a voltage of 24 V. When a second capacitor is connected in parallel with the first one,...

Bill Cavitt owns a data processing company. He plans to buy an additional computer for $20,000, use the computer for 3 years, and sell it for $10,000. He expects that use of the computer will produce...

2) Raymond has a diversified portfolio which he expects to receive investment income with an overall 8% return. In his holdings are Guaranteed Investment Certificates (GIC's) that will earn...

Fertile (female) cats produce an average of three litters per year. Suppose that one fertile, female cat is randomly chosen. In one year, find the probability she produces: c. Give the distribution...