8. Three types of motors are being inventoried by a company. The inventory carrying cost rate is 15%. Total space available is 1500 ft. Using the following information to determine the optimum order quantity for each motor with the space constraint. Solve by trial and error using excel. Motor 1 1500 Motor 2 2000 5 USD Motor 3 3000 Demand per year Item cost 10 USD 7.5 USD Ordering cost Floor space/item 50 USD 0.5 ft 50 USD 2.5 ft 50 USD 1.0 ft?
Q: Sanchez Trucking has been experiencing delays at its warehouse operations. Management hired a…
A: Given data: No. of members in crew = 6 Full time hrs/member = 40 hrsPermanently hired cost/week =…
Q: Consider the foll owing network diagram showing different routes in a university. Determine the path…
A:
Q: Plan production for a four-month period: February through May. For February and March, you should…
A: Production planning is indeed the process of defining a roadmap for the design and manufacture of a…
Q: Use a preference matrix to calculate the total weighted score for each supplier. The weighted score…
A:
Q: A set of tools costs Php 1,800 and can be ground twenty times. Each regrinding costs Php 18.00 and…
A:
Q: Consider the optimization problem represented by this graph. The objective function is represented…
A: Optimal solution is determined from the feasible points. Feasible points are the points that touches…
Q: "Ruby runs a machine design shop that has 4 stages of process in succession. Stage i is cutting that…
A: Given data:
Q: Compute the objective function value for the following problem: Min 260X + 65Y subject to : 2X>=0…
A:
Q: State TWO pricing efficiencies achieved through grading and explain how they lead to better…
A: Pricing efficiency can be defined in different ways but a fundamental way to understand is that the…
Q: Warehouse: 2.Identify the major role of stores management to economic development.
A: A warehouse acts as a support function for logistics and plays a key role in attaining the overall…
Q: What are some discretionary benefits that a company could eliminate? Why
A: The term discretionary benefit can be understood as the benefits which are over and above the cost…
Q: a. Which of the two suppliers would provide the lowest annual cost to Weekend Projects? What…
A:
Q: A publisher for a promising new novel figures fixed costs (overhead, advances, promotion, copy…
A: The Break-even point is the point where the production cost and the production revenue of an…
Q: What is the importance of manpower in operating a business?
A: Manpower planning is nothing but the basic dealing with the coordinating, encouraging or motivating,…
Q: Volkswagen Operations Strategy Product Design In 1945, a rare and curious Volkswagen car was shipped…
A: Automobiles and private transportation have a bright future ahead of them.. Volkswagen is poised to…
Q: How does business consulting jobs and the consulting field relate to labor economics. Can you tie…
A: Labor economics: It is the study of the labor force important component in the process of…
Q: Distinguish between functional, matrix, and project organizations. Describe how each structure…
A: The difference between between functional, matrix and project organization can be listed down as…
Q: explain the expression "collaborate closely with suppliers to maximize the efficiency of the retail…
A: Supply chain management - is the management of the whole production flow of the products or services…
Q: Soft influence tactics are more effective than hard influence tactics at getting a high level of…
A: Soft influence tactics are more effective than hard influence tactics at getting a high level of…
Q: For the following payoff table, what alternative should be chosen if you are following a Maximin…
A:
Q: At Dot Com, a large retailer of popular books, demand is constant at 20,400 books per year. The cost…
A: Annual Demand = D = 20400 books Ordering Cost = S = $75 Annual Holding Cost = h = $6 Lead time = L =…
Q: In the Fulfillment Process, we are doing which of the following activities: Selling…
A: Order fulfillment refers to the process where goods are received, processed and then delivered to…
Q: How does a desire for personal control affect managers and how can they balance it with…
A: Organizational control is the systematic method by which managers govern organizational operations…
Q: The selling price per unit of a product is $35, the fixed costs per month are $12,500, and the total…
A: A breakeven point is a unit sales level or revenue level which helps to identify no profit or No…
Q: A high-speed train operator schedules six trains per day departing from City A. The destination of…
A:
Q: What are some possible disadvantages of moving people to new jobs every 3 to 5 years?
A: Job rotation is the term used when people are rotated from one job position to another in order to…
Q: ompanies outsource system development? Or not? Describe your response.
A: Third-party software development is becoming more frequent as organizations across the globe seek to…
Q: a. Determine the expected project completion time and the variance. b. What is the project's…
A: The critical path is a method to find the shortest duration by which a project can be completed with…
Q: Firm XYZ makes custom outfits in three tailoring shops in Albany, Boston, and Hartford. These…
A: Given data is
Q: Explain three asset complementarities that International Managem
A: IMG, initially acknowledged as the International Management Group, is a worldwide sport, events…
Q: Starbucks buying coffee from locations like Colombia and Guatemala is an example of
A: As per Bartleby's guidelines, I have solved the first question because multiple unrelated questions…
Q: In the fewest possible words, define the phrase "balanced scorecard." What is the connection between…
A: The balanced scorecard is an example of performance measurement system. By this approach, business…
Q: Facebook had its ______ when it sold stocks to the public for the first time. tombstone financial…
A: Facebook had its ______ when it sold stocks to the public for the first time. tombstone financial…
Q: In a new company, what role do you think technology will play?
A: Technology refers to a process innovation which results into betterment and advancement of the…
Q: Should Earth Friendly Babies perform a post-implementation evaluation? If your answer is no,…
A: Post implementation evaluation process: Post implementation is led in the wake of finishing an…
Q: Warehouse: 4. What is stock receipt? What consideration should be taken in the stock receipt?
A: Stock receipts refers to the receipts received by the supplier related to the goods and materials…
Q: Zan Azlett and Angela Zesiger have joined forces to start A&Z Lettuce Products, a processor of…
A: Indifference point indicating the calculation of crossover point using two different methods. Here,…
Q: My best friend that has a small technology business, and he claim that in his business receive 121…
A: Queuing analysis helps to make better planning by determining the queue size and customers waiting…
Q: In the context of data warehouses, what precisely does the term "Hybrid Approach" imply?
A: Hybrid Approach :- A hybrid approach to data warehousing means that you maintain two or more…
Q: What Are Manufacturing Decision Patterns and How Can They Be Described?
A: Manufacturing decision in production include planning, organizing, staffing, directing and…
Q: Q4: The following time series shows the annual production of a factory: 2009 2008 2007 2006 2005 the…
A:
Q: nt at Walmart ? Which concenpts ot techniques are used by Walmart to create performance management…
A: Introduction The goal of performance management is to ensure that an organization's goals are met…
Q: A project, which consist of one-unit reinforced concrete 2-storeys bungalow house building will be…
A: For this project, we would be working on the bungalow house building/construction project, The group…
Q: shopper analysis consists certain analysis for integration what are they? - feel free to explain in…
A: Customer relationship management is described as the process of managing customers through the…
Q: Can a business succeed if it does not have substantial funding investments
A: Competitive advantage is described as the set of factors that facilitate a firm to produce services…
Q: a) What is the throughput time of this work cell? b) What is the bottleneck time of this work cell?…
A:
Q: 1. What’s the cycle time for this production line? 2. What’s the theoretical minimum number of…
A:
Q: Determine the pivot element in the simplex tableau. (If there is more than one correct pivot…
A:
Q: The seven-month demand for product X is as follows: 500; 6,000; 2,000; 1,500; 4,000; 5,500; and…
A: Month Demand 1 500 2 6000 3 2000 4 1500 5 4000 6 5500 7 6500
Q: Acadia Logistics anticipates that it will need more distribution center space to accommodate what it…
A: Expected value identifying the possible cost based on probable demand with the consideration of unit…
Step by step
Solved in 2 steps with 3 images
- c. Once you find the optimal order quantity i.e., EOQ, create a Data Table that generates inventory cost within ±100 units (with 10units increment) from the optimal order quantity. For example, if the EOQ=150, then you need to generate Data Table for inventory cost starting from 50 to 250 with 10 increments. Explain the exact steps completed in excel to create the data table d. Create a Scatter plot with “smooth lines” for the Data Table created in c) to show the inventory cost. Label your plot clearly (axis and title). The optimum order quantity should indicate the minimum cost in your plot.The Economic Order Quantity (EOQ) model is a classical model used for controlling inventory and satisfying demand. Costs included in the model are holding cost per unit, ordering cost and the cost of goods ordered. The assumptions for that model are that only a single item is considered, that the entire quantity ordered arrives at one time, that the demand for the item is constant over time, and that no shortages are allowed. Suppose we relax the first assumption and allow for multiple items that are independent except for a restriction on the amount of space available to store the products. The following model describes this situation: Let Dj = annual demand for item j Cj = unit cost of item j Sj = cost per order placed for item j i = inventory carrying charge as a percentage of the cost per unit W = the maximum amount of space available for all goods wj = space required for item j The decision variables are Qj, the amount of item j to order. The model is:…The Economic Order Quantity (EOQ) model is a classical model used for controlling inventory and satisfying demand. Costs included in the model are holding cost per unit, ordering cost and the cost of goods ordered. The assumptions for that model are that only a single item is considered, that the entire quantity ordered arrives at one time, that the demand for the item is constant over time, and that no shortages are allowed. Suppose we relax the first assumption and allow for multiple items that are independent except for a restriction on the amount of space available to store the products. The following model describes this situation: Let Dj = annual demand for item j Cj = unit cost of item j Sj = cost per order placed for item j i = inventory carrying charge as a percentage of the cost per unit W = the maximum amount of space available for all goods wj = space required for item j The decision variables are Qj, the amount of item j to order. The model is: (view…
- The demand for a clothing brand is shown in the table below. The cost per order is about $4000. Cost of each unit of clothing = $5. Carrying cost percentage = 25% per item per 5 months. The analysis period = 5 month duration. Month Demand 1 400 2 300 3 200 4 400 5 500 a. Using this data, compute the solutions using the Lot for Lot and Periodic Order Quantity heuristics? Which of these heuristics would perform better and why? b. Assuming that the demand follows a normal distribution with the mean and variance from the data given above, determine the optimal order should be greater or lesser than the single period EOQ model.Consider that you work at Kroger Grocery store, and that you've been tasked with creating an ABC inventory classification for 6 items. The 6 items, as well as their profit per case and number of cases sold per week, are as follows:Ribeye Steak - $135 in profit per case, 3 cases sold per weekLobster Tail - $245 in profit per case, 3 cases sold per weekPasta - $23 in profit per case, 12 cases sold per weekSalt - $3 in profit per case, 2 cases sold per weekNapkins - $12 in profit per case, 2 cases sold per weekTomato Sauce - $23 in profit per case, 11 cases sold per weekUsing total weekly profits, please classify each products into A, B, or C categories. Which items form the boundary of the class A and B items in your classification, and why? Which items form the boundary of the class B and C items in your classification, and why?You are currently working as a manager in a retail company. It is known that the company sells 2,500 cartons of cooking oil per year. The cost for each reorder cost of cooking oil is Rp. 750,000 and the carrying cost is Rp. 150,000. By using the Economic Order Quantity (EOQ) formula, determine how many units are optimal for each order?
- Suppose demand is know and constant at 500 units per year (one year has 250 working days). The holding cost is $2 per unit per year and the ordering cost is $20 per order. Also assume that the lead time is 10 days. Compute the optimal order quantity (EOQ) and the optimal annual inventory cost. Draw a picture of the evolution of the inventory level with time. Indicate the ROP on the picture as well as the length of the cycle. Now assume that the lead time is 90 days. Indicate the ROP on the picture.The Economic Order Quantity (EOQ) model is a classical model used for controlling inventory and satisfying demand. Costs included in the model are holding cost per unit, ordering cost, and the cost of goods ordered. The assumptions for that model are that only a single item is considered, that the entire quantity ordered arrives at one time, that the demand for the item is constant over time, and that no shortages are allowed. Suppose we relax the first assumption and allow for multiple items that are independent except for a restriction on the amount of space available to store the products. The following model describes this situation: Let Dj = annual demand for item j Cj = unit cost of item j Sj = cost per order placed for item j i = inventory carrying charge as a percentage of the cost per unit W = the maximum amount of space available for all goods wj = space required for item j The decision variables are Qj , the amount of item j to order. The model is: In…The maintenance department in Ranchi Hospital uses 816 cases of liquid cleanser annually. Ordering costs are $12, carrying costs are $4 per case a year, and the new price schedule indicates that orders of less than 50 cases will cost $20 per case, 50 to 79 cases will cost $18 per case, 80 to 99 cases will cost $17 per case, and larger orders will cost $16 per case. Determine the optimal order quantity and the total cost.
- Please solve this. Lebar Daun Sdn Bhd is planning to use the economic order quantity model to determine the optimal order levels of raw materials. Material Z is consumed evenly over the year and the current usage is 120,000 units. The material is purchased in boxes and each box contains 12 units of material Z, at a price of RM252 per box. A safety stock of 200 boxes is kept. The cost of placing and handling orders is estimated to be RM6,300, which is based cost incurred for similar orders that have already made. The cost of RM6,300 was for 30 orders. The inflation of 2 per cent should be added to the above ordering costs. Besides, the company estimates to be charged the transporation cost of RM15 per order. It should be assumed that ordering costs change in proportion to the number of orders place. Other costs which relate to material Z such as insurance, interest and space costs for a year, were calculated at 15 % of the purchase price. Required: a. Calculate the order quantity that…Problem 20-40 (Algo) In the past, Taylor Industries has used a fixed−time period inventory system that involved taking a complete inventory count of all items each month. However, increasing labor costs are forcing Taylor Industries to examine alternative ways to reduce the amount of labor involved in inventory stockrooms, yet without increasing other costs, such as shortage costs. Here is a random sample of 20 of Taylor's items. ITEMNUMBER ANNUALUSAGE ITEMNUMBER ANNUALUSAGE 1 $ 1,600 11 $ 13,200 2 12,200 12 700 3 2,300 13 42,400 4 50,500 14 10,100 5 11,600 15 1,300 6 900 16 10,400 7 2,100 17 4,100 8 11,200 18 61,600 9 5,200 19 3,600 10 15,200 20 3,000 a. Classify each item in inventory using an ABC plan.In Lecture 5 we extended the newsvendor solution to the infinite horizon problem when there is no order lead time. Now suppose that the order lead time is L periods throughout the infinite horizon: if an order is placed at the beginning of period t, it arrives at the beginning of period t+L. Can we still extend the newsvendor solution to the infinite horizon problem in the case of backordering? Why or why not? Would your answer change in the case of lost sales? Why or why or not? I WANT LONG AND CLEAR EXPLANATION NOT AN 1 SENTENCE!!!!!!