Problem (1)Mondo Motorcycles is determining its production schedule for the next four quarters. De-mand for motorcycles will be as follows: quarter 1-40; quarter 2-70; quarter 3-50;quarter 4 20. Mondo incurs four types of costs.1 It costs Mondo $400 to manufacture each motorcycle.2 At the end of each quarter, a holding cost of S100 per motorcycle is incurred.3 Increasing production from one quarter to the next incurs costs for training employ-ees. It is estimated that a cost of $700 per motorcycle is incurred if production is increasedfrom one quarter to the next.4 Decreasing production from one quarter to the next incurs costs for severance pay, de-creasing morale, and so forth. It is estimated that a cost of $600 per motoreycle is in-curred if production is decreased from one quarter to the next.All demands must be met on time, and a quarter's production may be used to meet de-mand for the current quarter. During the quarter immediately preceding quarter 1, 50 Mon-dos were produced. Assume that at the beginning of quarter 1, no Mondos are in inventory.Formulate an LP that minimizes Mondo's total cost during the next four quarters.Discuss your answer?

Let, x1 = Number of motorcycles manufactured in Quarter 1x2 = number of motorcycles manufactured in…

Mondo Motorcycles is determining its production schedule for the next four quarters. De- mand for motorcycles will be as follows: quarter 1-40; quarter 2-70; quarter 3-50%3; quarter 4 20. Mondo incurs four types of costs. 1 It costs Mondo $400 to manufacture each motorcycle. 2 At the end of each quarter, a holding cost of $100 per motorcycle is incurred. 3 Increasing production from one quarter to the next incurs costs for training employ- ees. It is estimated that a cost of $700 per motorcycle is incurred if production is increased from one quarter to the next.

Mondo Motorcycles is determining its production schedule for the next four quarters. De- mand for motorcycles will be as follows: quarter 1-40; quarter 2-70; quarter 3-50%3; quarter 4 20. Mondo incurs four types of costs. 1 It costs Mondo $400 to manufacture each motorcycle. 2 At the end of each quarter, a holding cost of $100 per motorcycle is incurred. 3 Increasing production from one quarter to the next incurs costs for training employ- ees. It is estimated that a cost of $700 per motorcycle is incurred if production is increased from one quarter to the next.

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 ?
Company XYZ, Inc. purchases widgets from a supplier at a cost of $20 per unit and sells the widgets for $30 per unit. By the end of Spring, demand for these widgets subsided considerably and all widgets that weren't sold during the Spring can be sold at a discounted price of $18 per unit. The company estimates demand during quarter two (Q2) to be normally distributed with mu = ? = 10,000 and sigma = ? =1525 boxes What is the optimal stockout probability for company XYZ, Inc.?
A quarry uses five types of rocks to fulfill four orders. The gypsum content, availability of each type of rock, and the production cost per pound for each rock, as well as the size of each order and the minimum and maximum gypsum percentage in each order, are given below.Rock type-------Cost-------% gypsum-------Amount Available1-------------------$1.00-----------2.0%-----------5002-------------------$5.00-----------5.0%-----------6003-------------------$5.50-----------4.5%-----------7004-------------------$2.00-----------3.0%-----------4005-------------------$1.20-----------6.0%-----------450 Order No.--------------------1----------2----------3---------4Order Size------------------500------600------500------350Min % gypsum-----------3.5%-----3.8%-----4.0%-----3.6%Max % gypsum----------4.4%-----4.6%-----4.7%-----4.8%What is the cheapest way to fill the orders?
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
A manufacturer of exercise equipment purchases pulleys from a supplier who lists these prices: less than 1,000, $5 each; 1,000 to 3,999, $4.95 each; 4,000 to 5,999, $4.90 each; and 6,000 or more, $4.85 each. Ordering cost is $50 per order, annual holding cost is 20 percent of purchase cost, and annual usage is 4,900 pulleys. Determine the order quantity that will minimize total cost.
BicycleBro is a retailer that sells bicycles. The company had been operating for 30 days (1 month). By the end of 1 month it wants to measure its performance in terms of Inventory turnover and Days of inventory. Below is the information that the company has collected from its warehouse and accounting department Stock Count Sheet Item code Stock on hand Stock count week (week number when employees counted the stock on hand) 100 30 week1 200 10 week1 100 10 week3 200 20 week3 Inventory valuation Item code Value per unit (in $) 100 1000 200 2000 Bicycles sold by end of month Item code Units sold 100 5 200 10 Given the information above find What is the total inventory turnover rate for given period? What is the total Inventory Days of Sales for given period?
LPM Corp. produces and sells two types of frozen burgers, Turkey Burgers and Veggie Burgers. In the most recent month, the firm sold 12,000 Turkey Burgers and 8,000 Veggie Burgers. Turkey Burgers sold for $14.00 per box and variable costs were $7.40 per box. The Veggie Burgers sold for $16.00 per box and variable costs were $8.25 per box. The fixed expenses of the entire company were $41,160. If the sales mix were to shift toward the Turkey Burgers product line with total sales volume remaining constant at 20,000, the overall break-even point for the entire company:
Anxlege supplies firms with apparel containing their logo to be used for promotional purposes. Anxlogo has three enterprise customers: IBM, HP, and Dell. During the holiday season, the logos are adorned with a Christmas motif. Demand from each firm for apparel with the Christmas motif is normally distributed, as shown below. IBM HP Dell Мean 7000 6000 5000 Standard Deviation 3000 1000 2000 Anxlogo currently uses a manufacturer in Sri Lanka to produce all the apparel including the logo embroidery in advance of the holiday season. Due to long lead times, there can be only a single order for the holiday season. The manufacturer charges $15 for each unit, which is then sold by Anylego.for $50 to its customers. Any leftover inventory at the end of the holiday season is essentially worthless and cannot be repurposed for a different customer, due to company logo and Christmas motif embroidery. It is thus donated by AnyLego to charity. Holding the apparel in inventory adds another %20 to the…