Question: Excel Online Structured Activity: EOQ Please Post Excel formula to Calculation The annual requirement of a part is 310,200 units. The order cost is $140

Excel Online Structured Activity: EOQ

Please Post Excel formula to

Calculation The annual requirement of a part is 310,200 units. The order cost is $140 per order, the holding rate is 14 percent and the part cost is $2,000 per unit. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Round your answers according to the input instructions for each question but use the unrounded values in the further calculations. X Open spreadsheet Questions a. What is the economic order quantity? Round your answer to the nearest whole number. $ b. What is the annual holding cost? Round your answer to the nearest dollar. $ 557 c. What is the annual order cost? Round your answer to the nearest dollar. $ 78,735 units $ 113824.06 d. What is the total annual inventory cost? Round your answer to the nearest dollar. e. What is the annual holding cost if the company decided to order at a lot size of 2,200 units instead of the EOQ quantity? Round your answer to the nearest dollar. f. What is the annual order cost if the company decided to order at a lot size of 2,200 units instead of the EOQ quantity? Round your answer to the nearest idollar.

Excel Online Structured Activity: EOQ Calculation The annual requirement of a part is 310,200 units. The order cost is $140 per onder, the holding rate is 14 percent and the part cost is $2,000 per unit. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below, Do not round intermediate calculations. Round your answers according to the input instructions for each question but use the unrounded values in the further calculations. Questions a. What is the economic order quantity? Round your answer to the nearest whole number. units b. What is the annual holding cost? Round your answer to the nearest dollar. $ c. What is the annual order cost? Round your answer to the nearest dollar. $ d. What is the total annual imventory cost? Round your answer to the nearest doliar. 5 e. What is the annuat holding cost if the company decided to order at a lot size of 2,200 units instead of the EOQ quantity? Round your answer to the nearest dollar: f. What is the annual order cost if the company decided to order at a lot size of 2,200 unts instead of the toq quantity? Round your answer to the nearest dollat

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!

Microsoft Excel Activity #2: EOQ Calculation x Question 1 0110 Submit Excel Online Structured Activity: EOQ Calculation The Las Vegas Corporation purchases a critical component from one of its key...

Activity #2: EOQ Calculation x Video Excel Online Structured Activity: EOQ Calculation The Las Vegas Corporation purchases a critical component from one of its key suppliers. The operations manager...

Excel Online Structured Activity: Mullenax Automobile Par s Inc,, Inventory Management Odis Mullenax is the owner and President of Mullenax Automobile Parts Inc. His company makes various parts for...

It needs the cost for both suppliers, I have started it on the bottom but I was unsure if I was doing it correctly. Video Excel Online Structured Activity: Total Cost of Ownership Kuantan ATV, Inc....

Excel Online Structured Activity: Total Cost of Ownership Kuantan ATV, Inc. assembles five different models of all-terrain vehicles (ATVs) from various ready-made components to serve the Las Vegas,...

PLEASE PROVIDE EXCEL FORMULAS Excel Online Structured Activity: Total Cost of Ownership Kuantan ATV, Inc. assembles five different models of all-terrain vehicles (ATVs) from various ready-made...

Please help with excel formulas EOQ Calculation 4 Annual requirement in units (R) Setup cost (S) Holding rate (k) Unit Cost (C) Order lead time (LT, days) Number of days per year 6.900 $60 23% $10 5...

The IS&OM department coordinator at Harvard Business School, who purchases blank paper for the copy machines, must decide among three different suppliers. He can purchase paper from supplier A for...

IOE 419 Mark S. Daskin Service Operations Management IOE Department Winter, 2017 University of Michigan Problem set 4 DUE: MONDAY - February 20, 2017 Points: 100 points total Problem 1: Babette has...

Group: PERON A+ PERSON B +PERSON C 1- Introduction 2- Literature a. Definition of operation management b. Definition of operation strategy and why it is important c. Components of operations strategy...

Bob Lutz opened a secretarial school called Best Secretarial Training. a. Lutz contributed the following assets to the business: Cash .............$5,700 Computers .......... 4,300 Office Equipment...

Owl is a closely held corporation owned by eight shareholders (each has 12.5% of the stock). Selected financial information provided by Owl follows. Taxable income ....................$6,250,000...

When evaluation alternatives for capital decision - making, a preference decision allows companies to remove alternatives that would be less desirable to pursue. Group of answer choicesTrueFalse

Free cash flow valuation You are evaluating the potential purchase of a small business with no debt or preferred stock that is currently generating $ 4 2 , 7 0 0 of free cash flow ( F C F 0 = $ 4 2 ,...