04/30/2Problem #1 - Jasper Inc., a company that sells air conditioning units for cars intends to reduce its total annual inventorycost. The annual demand is expected to be 6,000 units if market conditions are unfavorable, and 9,000 units if marketconditions are favorable. The Purchasing & Warehousing Manager estimates that the ordering cost is $20.00 per orderand the holding cost is $2.00 per unit per year.a.- Calculate the Economic Order Quantity (EOQ), Annual Ordering Cost, Annual Holding Cost and TotalAnnuarinventory Cost under unfavorable and favorable market conditions.b.- The Purchasing & Warehousing Manager identified two improvement projects in conjunction with herteam:Project A: Reduction of ordering cost to $18.00.Project B: Reduction of holding cost to $1.40 per unit per year.Which project would result in greater reduction of the EOQ and Total Annual Inventory Cost?Which of the projects would you recommend and why? Show all your calculations.

Economic order quantity (EOQ) is the optimal order quantity that a company should purchase so that…

Answered: year. a. - Calculate the Economic Order…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Genchev Industries conducts an ABC analysis of its inventory and develops the following table from its findings. Item Annual Usage Unit Cost Dollar Usage 1 9,960 $43.20 $430,272 2 3,362 $22.80 $76,654 3 8,332 $9.90 $82,487 4 3,074 $22.30 $68,550 5 2,968 $8.40 $24,931 6 4,195 $25.00 $104,875 7 4,536 $19.20 $87,091 8 9,538 $65.60 $625,693 9 3,484 $3.20 $11,149 10 10,232 $5.70 $58,322 Which of these items is a C item? a. Item 8 b. Item 6 c. Item 5 d. Item 1
10. A company will sell remote control devices online. Expected yearly demand is 3000 units and it is sold per 250TL. The controllers can be purchased from supplier A. Ordering cost is 40 TL and annual holding cost is 25% of the price. a. Calculate the economic order quantity for the company. b. Calculate the number of orders per year. c. List the assumptions of EOQ model that you used to calculate the value in part A.
Do the following: Inventory • What kind of inventory will you keep: raw materials, supplies, finished goods? • Average value in stock (i.e., what is your inventory investment)? • Rate of turnover and how this compares to the industry averages? • Seasonal buildups? • Lead-time for ordering? Details in the photo attached
Beginning Quantity Ending Inventory Order? Lost Week Demand inventory on-order inventory position (yes/no) Sales 1 100 53 2 40 3 36 4 38 5 55 6 34 7 30 8 31 9 40 10 57 11 30 12 53
1. a) Zoey Enterprises manufactures solar engines for helicopters. Given the fuel savings available, new orders for 125 units have been made by customers requesting credit. The variable cost is $11,400 per unit, and the credit price is $13,000 each. Credit is extended for one period. The required return is 1.9 percent per period. If Zoey Enterprises extends credit, it expects that 30 percent of the customers will be repeat customers and place the same order every period forever, and the remaining customers will place one-time orders. Should credit be extended? 2. b) Now, assume that the probability of default is 15 percent. Should the orders be filled now? Assume the number of repeat customers is affected by the defaults. In other words, 30 percent of the customers who do not default are expected to be repeat customers.
A major automobile manufacturer located in Georgetown, Kentucky, has two certified vendors that produce brake pads with the information shown below. New Albany Manufacturing is located in Columbus, Ohio, and LaPlaya Manufacturing is located in Monterrey, Mexico. The automobile assembly factory is assumed to operate 250 days per year. Certified Supplier New Albany Mfg. LaPlaya Mfg. Order Size (Q) 30,000 60,000 Price per Unit (P) Order quantity: Total procurement cost: Total management oversight cost: Total annual transportation cost: Annual order cost: Annual holding cost: Average annual pipeline inventory cost: Total supply chain costs: $14.38 $13.55 Oversight Cost per Unit (0) $0.00 $0.37 $ LA GA $ LA tA a. Use the Total Supply Chain Cost Excel template to compute the supply chain costs associated with each supplier if the annual demand is 480,000 brake pads. Do not round intermediate calculations. Round your answer to the nearest dollar. 30,000 units 60,000 units tA Transport Cost…
1. Using the data provided here for problem 1. Calculate the following: 6 7 8 | 9 Week Demand 1| 2 3 4 5 2554 2333 4678 4525 2243 2988 2301 3777 3245 2122 2987 2487 2567 10 11 12 13 a. Average weekly demand. b. Target inventory for 98% Inventory Service Level for this period if you get replenished with new inventory every two weeks. Formulas used: a. b.
A Maintains a particular gym. 55% on a gross murgain of all it's training products. In April the gym had a beginning inventory of 142, 000 net Purchases of 202,000 and net sales of 433,000, to estimate Use grass profit method Cost (in #1) of ending inventory?
Question 7 Firm develop new products to a.gain market share and build brand equity b.keep their research and development teams gainfully employed c.take up slack in capacity d.gain first mover advantage and eliminate waste Question 8 Economic order quantity (EOQ) assumes all of the following conditions apply .demand is known and is constant over time .there are no shortages allowed.lead time for the receipt of orders is constant.Order quantity is received all at once true or false? question 10 Trade-offs in the new product development relate to A.Product / service design, time to market and profitability B.Proft. Expenditure and market share C.Time. cost and quality D.Market reach, product / service design and timing
Use a mixed strategy - level of procuction (Jan-June) and chase demand (July- September with a support of overtime and sub-contracting not more than two workers and no limid for back orders. Jan 1000 Feb 2750 March 1250 April 1500 May 2250 June 1750 July 2750 August 2250 Sept 2500 Current work force 10 workers Production per worker Inventory holding cost Regular wage rate Overtime wage rate Sub-contracting wage rate Back-ordering wage rate Hiring cost Firing cost Beginning inventory 250 units per month S0.50 per unit per month $50.00 per unit S60.00 per unit $70.00 per unit $90.00 per unit $500 per worker S800 worker per 250 units Mth Regular Production Ending Back Order Demand OT S/k Workers Inventory J F M A. M J J Total Kos (Cost:
Mr. Waleed is running furniture manufacturing business. He required raw material on regular basis.He uses the best suitable methods of purchasing of material.He tried to used preparation of inventor budgets, perpetual inventory system, just-in- time, ABC analysis but none of the above suited to his business.Once he had to stop his production, when he was using Just-In- Time purchasing method. One day Mr.Waleed explain all the cost details to his cost accountant as follows: The normal usage was 50 Units.In case of low demand his minimum usage was only 25 units. During high demand time Mr. Waleed used to purchase 75 units.Mainly he required two types of raw material like Material 1 and Material 2, His reorder quantity for Martial 1 was 300 Units & For Material 2 was 500 Units.His cost accountant told him that they need 40 Units as average. Mr. Waleed was very good at planning, but in case of emergency he used to wait 1 day for material 1 and 2 days for material 2 to get…
Create the following: • How do to inventory in supplies? • Seasonal Buildups? • Lead time for ordering/service? Details of the business is in the photo attached

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS