Question: slove it in excel x & fi B D E F G Question 1: M.P. VanOyen Manufacturing has gone out on bid for a regulator

slove it in excel

x & fi B D E F G Question 1: M.P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is 700 units per month. The item can be purchased from either Allen Manufacturing or Baker Manufacturing. Their price lists are shown in the table. Ordering cost is $50, and annual holding cost per unit is $5. a) What is the economic order quantity? b) Which supplier should be used? Why? c) What is the optimal order quantity and total annual cost of ordering, purchasing, and holding the component? Allen MFG Unit Price 1 Quantity 1-499 500-999 16.00 15.50 15.00 Baker MFG Quantity Unit Price 1-399 16.10 400-799 15.60 800+ 15.10 3 1000+

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!

please do it in excell and show me the formula as well Question 1: M.P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is 700 units per month. The item can be...

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

AND 1. THE USE OF CALCULATORS SPREAASHEETS 2. PLEASE MAKE SURE TO WRITE Stolal ANSWER EXPLANATIONS THAT ARE SUPPORTED BY YOUR CALCULATIONS deep AsE OuESTION 3. PLEASE USE EXCEL TO CALCULATE AND SHOW...

M.P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is 700 units per month. The item can be purchased from either Allen Manufacturing or Baker Manufacturing....

what is c? Allen Mfg. Quantity Unit Price 1-499 $16.00 500-999 15.50 1000+ 15.00 Baker Mfg. Quantity Unit Price 1-399 $16.10 400-799 15.60 800+ 15.10 M.P. VanOyen Manufacturing has gone out on bid...

M. P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is 725 units per month. The item can be purchased from either Allen Manufacturing or Baker Manufacturing....

9 of 16 (13 completo) HW Score: 69.79%, 11.17 of 16 pts Problem 12.26 Question Help M.P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is 675 units per month....

As well as question A thats on the picture, theres a few more parts: b. Which supplier should be used? Why? c. What is the optimal order quantity? d. Total annual cost of ordering? e. Total annual...

I need assistance with solving these practice problems in Excel. Can you show the work in excel spreadsheet so that I can have a better understanding of how to use excel when solving the problems?...

Now suppose instead of the firms competing on quantity they compete on price. a) What is the equilibrium price and quantity? b) What is different about the Cournot and Bertrand equilibriums, and what...

You are one of five lead teachers in your preschool. Your director has asked you and the other lead teachers to develop a list of criteria to be used to decide whether themes, projects, and...

1 2 3 Multiple Cholce 1 point Which one of the followine it NOT a managed care program? Medicald Preferred Provider Organizations ( PPOs ) Provider Service Networks ( PSNs ) Health Maintenance...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...