A laptop manufacturer wants to compare the total cost of assembling its laptops in the United States versus Taiwan. All of the laptops will be sold in the United States. To evaluate inventory, it uses a safety factor of 2.25. The holding cost per laptop is $4 per week in the United States and $3.50 per week in Taiwan. The lead time with U.S. production is 2 weeks, whereas it is 9 weeks with production in Taiwan. In addition, it costs $2 to ship laptops to the United States from Taiwan. Weekly demand is 5442 laptops with a standard deviation of 800. How much more inventory (on-order and on-hand) will the manufacturer have, on average, if it manufacturers in Taiwan than if it manufactures in the United States? Please provide a numeric-only answer to two decimal places.

A laptop manufacturer wants to compare the total cost of assembling its laptops in the United States versus Taiwan. All of the laptops will be sold in the United States. To evaluate inventory, it uses a safety factor of 2.25. The holding cost per laptop is $4 per week in the United States and $3.50 per week in Taiwan. The lead time with U.S. production is 2 weeks, whereas it is 9 weeks with production in Taiwan. In addition, it costs $2 to ship laptops to the United States from Taiwan. Weekly demand is 5442 laptops with a standard deviation of 800. How much more inventory (on-order and on-hand) will the manufacturer have, on average, if it manufacturers in Taiwan than if it manufactures in the United States? Please provide a numeric-only answer to two decimal places.

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

A laptop manufacturer wants to compare the total cost of assembling its laptops in the United States versus Taiwan. All of the laptops will be sold in the United States. To evaluate inventory, it uses a safety factor of 2.25. The holding cost per laptop is $4 per week in the United States and $3.50 per week in Taiwan. The lead time with U.S. production to one week, whereas it is eight weeks will production in Taiwan. In addition, it costs $2 to ship laptops to the United States from Taiwan. Weekly demand is 1,000 laptops, with a standard deviation of 800. a. What is the per unit holding cost of a laptop with U.S. production? Note: Round your answer to 2 decimal places. Holding cost $ Holding cost b. What is the per unit holding cost of a laptop with production in Taiwan? Note: Round your answer to 2 decimal places. 9.00 per unit $ 7.88 per unit c. A laptop requires 40 minutes of labor to assemble in the United States or in Taiwan. The total cost of labor in the United States is $40 per…
Please give fast answer. And give typed answer. I wil give positive rating. Economic Production Quantity (EPQ) TC = D * C + (D / Q) * S + (Imax / 2) * H A bicycle manufacturer uses 50,000 wheels per year for its popular cycle. The firm can make its own wheels, which it can produce at 600 per day. Assembly is uniform numbers over the entire year. The carrying cost is $1.00 per wheel per year, and the setup cost for a production run of wheels is $45. Consider that the plant operates 250 days per year, what is the order quantity and Imax? Using the same numbers, calculate the Average Inventory per day to determine inventory performance.
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for DVD players are as follows: November 1 Inventory 79 units at $63 10 Sale 63 units 15 Purchase 102 units at $67 20 Sale 57 units 24 Sale 14 units 30 Purchase 21 units at $70 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column. Schedule of Cost of Goods Sold LIFO Method DVD Players Quantity Date Purchased Purchases Unit Cost Purchases Total Cost Quantity Sold Cost of Goods Cost of Goods Sold Unit Cost Sold Total Cost Inventory Quantity Inventory Unit Cost Inventory Total Cost Nov. 1 Nov. 10 Nov. 000…
Pls answer in simple steps, let me know if you need any more details
You are working in a food manufacturing company assigned to the Production Department. You have observed that some of the raw materials in the Warehouse are not properly utilized by the production team. These raw materials are perishable and have short shelves life. The unutilized raw materials were due to the excessive inventory purchase by the company as it failed to plan its production activity. This has also increased the spending of the company, decreasing the company's profit. As the controller, what are the actions you may implement to control the situation?
Answer the given question with a proper explanation and step-by-step solution. An E-commerce firm has four regional fulfillment centers (warehouses). Weekly demand for an item (Product_A) at each warehouse is random and is normally distributed with a mean of 10,000 per week and a standard deviation of 2,000 units per week. Product_A’s unit cost is $10. The inventory holding cost of the company is 25% per year. Assume 50 weeks per year. Each replenishment order from the supplier of Product_A costs $1,000, which includes the costs associated with placing the order, transportation, receiving, inspection, and put-away labor expenses. The replenishment lead time from the supplier is 1 week. The company’s service level goal is 95% (probability of having sufficient inventory to meet demand). On average, how long does a unit of inventory spend in the warehouse before being sold? Hint: Think Little's Law 2.5 weeks 6.6 weeks 5.3 weeks 1.3 weeks
Your options for shipping $100,000 of machineparts from Baltimore to Kuala Lumpur, Malaysia, are (1) usea ship that will take 30 days at a cost of $3,800 or (2) truck theparts to Los Angeles and then ship at a total cost of $4,800.The second option will take only 20 days. You are paid via aletter of credit the day the parts arrive. Your holding cost isestimated at 30% of the value per year.a) Which option is more economical?b) What customer issues are not included in the datapresented?
Assessment of Inventory Management Practices in the Construction Industry in the Philippines-by Ma. Remedios F. Mendoza and Renato B. Garbo Jr. The Application of Automated Inventory Management System in the Construction Industry in the Philippines- by Alvin C. Custodio and Reynaldo B. Hizon Jr. Digital Inventory Management System for Construction Materials in the Philippines- by Anfernee Jade C. Herrera and Ernesto C. Enriquez. An Analysis of Inventory Management Practices in the Philippine Construction Industry- by Ricardo C. Reyes and Michelle P. Vasquez. Evaluation of Inventory Management Practices in the Construction Industry in the Philippines: A Case Study- by Jomar P. Albao and Albert M. Ramos. Inventory Management Practices in Construction Firms in the Philippines- by Jasmin A. Sison and Jocelyn A. Valiente. The Role of Digitalization in Inventory Management in the Philippine Construction Industry- by Ariel T. Dignadice and Marcelino P. Fabros Jr. An Assessment…
Assessment of Inventory Management Practices in the Construction Industry in the Philippines-by Ma. Remedios F. Mendoza and Renato B. Garbo Jr. The Application of Automated Inventory Management System in the Construction Industry in the Philippines- by Alvin C. Custodio and Reynaldo B. Hizon Jr. Digital Inventory Management System for Construction Materials in the Philippines- by Anfernee Jade C. Herrera and Ernesto C. Enriquez. An Analysis of Inventory Management Practices in the Philippine Construction Industry- by Ricardo C. Reyes and Michelle P. Vasquez. Evaluation of Inventory Management Practices in the Construction Industry in the Philippines: A Case Study- by Jomar P. Albao and Albert M. Ramos. Inventory Management Practices in Construction Firms in the Philippines- by Jasmin A. Sison and Jocelyn A. Valiente. The Role of Digitalization in Inventory Management in the Philippine Construction Industry- by Ariel T. Dignadice and Marcelino P. Fabros Jr. An Assessment…
1. Cooking Oil Blending with Inventory A company makes very fine cooking oil used in used in high-quality restaurants for salad oil. It is a blend of 5 different vegetable oils. The following table gives the posted prices of raw vegetable oils over a 3-month period of next year. These prices can be locked in now by means of futures contracts. Raw oil prices (Pesos) Price of oil Coconut Month Corn Peanut Sesame Sunflower Jan 1.79 1.72 2.03 1.88 1.72 Feb 1.80 1.40 1.72 2.03 2.03 Mar Hardness 1.72 8.8 1.49 1.56 2.03 2.19 5.0 4.2 2.0 6.1 The hardness of the blend = weighted average of hardness of oils in the blend, must be between 3.0 and 5.8. The company's blending plant has a monthly capacity for processing: at most 150 liter of corn, peanut, and coconut oils combined at most 100 liter of sesame and sunflower oils combined At the start of the 3-month period assume that there are 300 liters of each kind of vegetable oil in storage. The plan must provide for the same quantities of each oil…
You are running the supply chain for a grocery store operating across Upstate Souun Carolina. You operate a central warehouse and have multiple stores. For each of the following situations determine if it would be best to operate inventory for the product that is pooled at your central warehouse or determined individually by each retail store. Provide at least 1 sentence discussing your choice. (a) The demand for boxes of Nutty Bars at each store during a week is i.i.d. with mean u = 1000 and standard deviation o = Nutty Bars are high compared to holding costs for Nutty Bars. 10. Transshipment costs between the stores for (b) The demand for Fudge Rounds at each store during a week is i.i.d. with mean u = 200 75. Transhipment costs between the stores for Fudge and standard deviation o Rounds are relatively small compared to holding costs.
Any Company buys and resells a wide range of personal care products. Their ongoing challenges, like many of their competitors include shipping time for purchases, optimizing use of their storage space, and shipping time for sales to their customers. The company’s control over shipping time for purchases is limited. Their choice of suppliers has more impact on shipping time than any encouragement they can offer to those suppliers. Any Company uses multiple warehouses. Some are owned by the company, others are leased. The company uses contract shippers, FedEx/UPS, and the US Postal Service. Your task is to identify at least 4 KPIs you think will be relevant for Any Company to understand and improve their inventory management. Identify the data necessary for your KPIs as specifically as possible. You may use any KPIs we have mentioned in class or from the labs. Feel free to use others or to create your own. Your response does not need to include a description of graphs you might…