Mondo Motorcycles is determining its production schedule for the next 4 quarters. Demands for motorcycles are forecasted to be 400 in quarter 1; 700 in quarter 2; 500 in quarter 3; 200 in quarter 4. It costs Mondo $800 to manufacture each motorcycle. At the end of each quarter, a holding cost of $100 per motorcycle left in inventory is incurred. When production is increased from one quarter to the next, a cost is incurred, primarily for training employees, at a cost of $700 per motorcycle. When production is decreased from one quarter to the next, a cost is incurred, primarily for severance pay and decreased morale, at a cost of $600 per motorcycle. All demands must be met on time, and a quarter's production can be used to meet demand for the current quarter (as well as future quarters). During the quarter immediately preceding quarter 1,500 motorcycles were produced. Assume that at the beginning of quarter 1, no motorcycles are in inventory. Formulate an IP to minimize the total costs. (a) Which OR problem is this? (b) Decision variables? (c) Objective and objective function? (d) Constraints?

Mondo Motorcycles is determining its production schedule for the next 4 quarters. Demands for motorcycles are forecasted to be 400 in quarter 1; 700 in quarter 2; 500 in quarter 3; 200 in quarter 4. It costs Mondo $800 to manufacture each motorcycle. At the end of each quarter, a holding cost of $100 per motorcycle left in inventory is incurred. When production is increased from one quarter to the next, a cost is incurred, primarily for training employees, at a cost of $700 per motorcycle. When production is decreased from one quarter to the next, a cost is incurred, primarily for severance pay and decreased morale, at a cost of $600 per motorcycle. All demands must be met on time, and a quarter's production can be used to meet demand for the current quarter (as well as future quarters). During the quarter immediately preceding quarter 1,500 motorcycles were produced. Assume that at the beginning of quarter 1, no motorcycles are in inventory. Formulate an IP to minimize the total costs. (a) Which OR problem is this? (b) Decision variables? (c) Objective and objective function? (d) Constraints?

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

1) To order less than 2,000 the vendor quotes $1.80 per piece. Orders between 2001 to 5,000 are $1.60 per piece and 5,001-10,000 it's $1.40. Any orders above 10,000 the price drops to $1.25. Ordering costs are $200 per order and to store the materials we have a 5% storage costs from UC catering. Our estimated annual demand is 15,000 pieces. If we contract to place orders annually with the vendor for 10,001 pieces each time to get the S1.25 price, what is my total cost for the year? 2) To order less than 2,000 the vendor quotes $1.80 per piece. Orders between 2001 to 5,000 are S1.60 per piece and 5,001-10,000 it's S1.40. Any orders above 10,000 the price drops to $1.25. Ordering costs are $200 per order and to store the materials we have a 5% storage costs from UC catering. Our estimated annual demand is 15,000 pieces. What is the optimal Order Qty ?
Daily demand of a chemical at an oil refinery is normally distributed with a mean of 60 litres and a standard deviation of 7. The supplier reliably delivers the chemical by maintaining a constant lead time of 1 week. There are no delivery charges from the supplier. Sales occur throughout the year. An order placement requires one hour of an administrative employee who is paid $20 per hour. Receiving and storing a chemical shipment requires two workers to work for half an hour. Workers are paid $12 per hour each. Chemical’s purchase price is $500 per litre. Annual cost of capital is 5%. Other holding costs are estimated to be $0.5 per litre. Find the order quantity and the reorder point to satisfy a 95% service level during the lead time. (Round answers to 2 decimal places.)
15) JBs needs to determine what quantity of a new tennis racquet to order for the upcoming summer season. They sell the racquet for $110 and procure it from their supplier for $70. Any leftovers will be marked down 60% and are expected to all sell at that price. Anticipated demand is modeled with a normal distribution where the mean is 120 and the standard deviation is 25. How many racquets should JBs order if they want to meet a 95% target fill rate? A) 130 C) 162 B) 127 D) 149
The production planner of a company forecasts the sales over the next five years as 220, 205, 340, 130, and 300 packages, respectively. The planner estimates that there will be 40 packages on hand at the end of this year and she wants the ending inventory to be 50 packages at the end of the next five years. Assume that each worker produces 70 packages per year. The company uses level strategy and shortages are not allowed. What is the minimum constant workforce over the next five years? O a 5 O b. 6 OC.4 O d. 8 O e. 7
The beginning stock of a product is 200 units (On hand stock =200 unites). Safety Stock level is 50 unites. It is desirable to prepare a 12-week Master Production Schedule. MPS is 400 units. The Demand forecast and Customer order quantities for the 12 periods are given in the table below. Determine the Master Production Schedule and Available to promise amount (ATP) in a way that maintains the amount of safety stock. Demand Forecast Customer Order 1 2 3 4 5 6 70 60 90 90 110 120 80 120 120 110 110 100 90 7 130 80 8 150 50 9 140 40 10 145 0 11 180 0 12 190 0
Magdeleine James is a sole trader, who sells souvenir T-shirts. She wishes to sell her T-shirts at the Tobago Jazz festival. Each t-shirt cost $165 to produce and sells for $225. After the festival, she reduces the sale price of the T-shirts by 70% in order to sell them off. Experience from previous years has shown that the demand for these T-shirts at the festival is 82, with a standard deviation of 21. How many T-shirts should Magdeleine take to sell at the festival?
An airline company offers four fairs as shown in the table below. The demand distribution for each fare is normal with mean and standard deviation as given in the table. Find an estimate of the protection levels for the classes using the heuristic EMSR-a. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
A local manufacturer of Toys produces several toys. Among the most popular is Elsa Doll. Suppose that there are currently 100 Elsa Doll in inventory and that there are customer orders that have been committed and must be filled. Suppose that a production lot size of 150 Elsa Dolls. The weekly forecasts for the eight weeks are 176, 172, 50, 130, 40, 120, 132, and 135 respectively. The customer orders for weeks 1, 2, 3 through 8 are the 88, 86, 25, 65,20, 51, 0, 0 respectively. Using the standard principles of Master Production Schedule (MPS) along with Available-To-Promise (ATP) for the Elsa Dolls, what is the Available to promise (ATP) level in week 2 Select one: O a. 150 b. 79 O c. 39 O d. 0 Oe. None is correct Next page
Pls help with below homework. Select the correct option and explain it in 7-8 sentences.
A retailer has 7 stores in different cities in northern Ontario. The weekly demand for each store follows the normal distribution with a mean value of 60 and a standard deviation of 10. The retailer is planning to use a single centralized store in northern Ontario and they think the demand in the single store will be equal to the sum of the demand in all 7 cities. It takes 3 weeks for the supplier to send the products to the retailer. Calculate the safety stock for the centralized and decentralized cases if the correlation of demands between different cities is 0.3. Assume the planned customer service level is 98%. Please post answer in excel showing formula and answer
10/Do not solve it in excel , please.