1. Machine Tool Production Planning. King City Inc. manufactures machine tools. The production planner who oversees the production of two of King City's machines needs to determine how many of each to produce this month. The two machines, TopLathe and BigPress, each require a certain common component. Each TopLathe requires 10 of these components and each BigPress requires 7. Only 49 components are available this month. The sales department requires that the total number of machines produced in a month must be at least 5 (the number TopLathes plus the number BigPresses must be at least 5). The profit for a TopLathe is $50,000 and $34,000 for a BigPress. a. Assuming that adequate labor and all other resources are available, formulate an integer programming model to determine how many of each product King City should produce to maximize profit. b. Solve the model formulated in part (a) without integer requirements. What is the optimal profit? What are the optimal values for TopLathe and BigPress?

1. Machine Tool Production Planning. King City Inc. manufactures machine tools. The production planner who oversees the production of two of King City's machines needs to determine how many of each to produce this month. The two machines, TopLathe and BigPress, each require a certain common component. Each TopLathe requires 10 of these components and each BigPress requires 7. Only 49 components are available this month. The sales department requires that the total number of machines produced in a month must be at least 5 (the number TopLathes plus the number BigPresses must be at least 5). The profit for a TopLathe is $50,000 and $34,000 for a BigPress. a. Assuming that adequate labor and all other resources are available, formulate an integer programming model to determine how many of each product King City should produce to maximize profit. b. Solve the model formulated in part (a) without integer requirements. What is the optimal profit? What are the optimal values for TopLathe and BigPress?

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

12 Assuming there is no change in a product's price or the quantity demanded, if a business owner wants to increase her advertising expenses by $500 monthly, ut of this would cause total costs to and the break-even quantity to question Select one: O a. stay the same; increase. O b. increase; increase. O c. decrease; increase. O d. stay the same; decrease. O. e. decrease; stay the same. car wash pays $2.500 in rent, $500 in
(a) Give examples of independent and related dependent demand (b) APL company assembles and sales an electronics device (ED) on a contract basis. End item ED has composed of 3 units of subassembly BG and 5 units of component DD. BG is assembled using 3 DDs and 4 FCs. There are orders of 500 and 875 units of the device (ED) at the beginning of week 6 and week 8. In assembling BG, an extra 20 percent scrap allowance must be added. DD can only be ordered in whole cases of 400 units per case. One case of DD is received in each of week 1 and week 2. Also, there are 200 units of BG and 425 units of DD now on hand. The lead time for the item BG, DD, and FC is 2 weeks and that is for the item ED is 1 week.i. Calculate the required number of DD and FC for producing 100 units of ED. There is no stock of any item. ii. Prepare a material requirements plan for the component DD.
Franklin Tooling, Inc., manufactures specialty tooling for firms in the paper-making industry. All of their products are engineer-to-order and so the company never knows exactly what components to purchase for a tool until a customer places an order. However, the company believes that weekly demand for a few components is fairly stable. Component 135.AG is one such item. The last 26 weeks of historical use of component 135.AG is recorded below. Week Demand Week Demand 1 2 3 4 5 6 7 8 9 10 11 12 13 137 136 143 136 141 128 149 136 134 142 125 134 118 14 15 16 17 18 19 20 21 22 23 24 25 26 131 132 124 121 127 118 120 115 106 120 113 121 119 Use OM Explorer’s Time Series Forecasting Solver to evaluate the following forecasting methods. Start error measurement in the fifth week, so all methods are evaluated over the same time interval. Use the default settings for initial forecasts.i. Naïve (1-Period Moving Average)ii. 3-Period Moving Averageiii. Exponential Smoothing,…
2. The idea of assigning numerical values to determine a preference ordering over a set of ob- jects is not limited in application to commodity bundles. The Bill James Baseball Abstract argues that a baseball player's batting average is not an adequate measure of his offensive productivity. Batting averages treat singles just the same as extra base hits. Furthermore they do not give credit for "walks," although a walk is almost as good as a single. James argues that a double in two at-bats is better than a single, but not as good as two singles. To reflect these considerations, James proposes the following index, which he calls "runs created." Let A be the number of hits plus the number of walks that a batter gets in a season. Let B be the number of total bases that the batter gets in the season. (Thus, if a batter has S singles, W walks, D doubles, T triples, and H home runs, then A= S + D + T + H+W and B = S +W +2D +3T +4H.) Let N be the number of times the batter bats. Then his…
27) Ali has a restaurant where the customers use a different number of disposable cups each day he is open. Every 30 days, Ali places an order to replenish his cup inventory. It takes 3 days for the order to arrive, at which point it brings the inventory level up to 4000 cups. It costs Ali $30 to have the order processed. Select all statements that apply to Ali's situation: Group of answer choices a) Ali uses a Continuous Inventory System b) d is constant c) Ali uses a Periodic Inventory System d) Ali uses a Fixed-Order-Quantity Inventory System e) Maximum Inventory Level is constant
29) XYZ Company The XYZ Company uses 175 handles per day. The company operates 300 days per year. It costs $2.00 to carry one handle in inventory for one year. When handle inventory is low, an order is sent to the fabrication department to manufacture more handles. Fabrication can produce handles at a rate of 1500 per day and send the handles over to assembly while production is in progress. The setup for each production run costs $500. In order to calculate the EOQ, the XYZ company utilizes the __________ model. Group of answer choices a) Basic EOQ b) Production Quantity c) Optimal Production
Minimize z= 5.15x1+ 4.5x2 + 4.36x3 (hundreds of dollars) s.t: ?x1 + ?x2 + ?x3 > 140 ?x1 + ?x2 + ?x3 s 200 (production capacity: hours) (warehouse capacity; hundreds of sq. ft.) ?x1+?x2 = 5 (demand for 6 oz. giasses; hundreds of cases) x1, x2, x3 20 4.5X2 -1.25 Basis Св 5X1 4.36X3 S1 S2 a3 RHS -0.75 10.7 X3 1. 4.36 -0.13 11.25 1.25 -2.5 11.5 S2 0.1 X1 5.15 C-Z How much is it worth an extra hour added to b1 on the optimal solution?
Mr. Robertson owns a store. His mark-up percentage is 80%. He is also VAT registered, VAT is 15% of the selling price. Mr. Robertson buys handbags at R108 each, what is the selling price of these bags excluding VÁT? 2.1 2.2 How much profit would he earn selling 25 bags? | 2.3 Calculate the selling price of one handbag including VAT. 2.4 Mr. Robertson hires a new assistant. She calculates that a pair of shoes that is bought for R850 should be sold for R1572,50 excluding VAT. State, with calculations, whether her mark-up percentage was correct. 2.5 Mr. Robertson sells a pair of jeans for R459,99 excluding VAT. Calculate the cost price before the mark-up.
Customers at Joe’s Office Supply Store demand anaverage of 6,000 desks per year. Each time an order isplaced, an ordering cost of $300 is incurred. The annualholding cost for a single desk is 25% of the $200 cost of adesk. One week elapses between the placement of an orderand the arrival of the order. In parts (a)–(d), assume that noshortages are allowed.a Each time an order is placed, how many desks shouldbe ordered?b How many orders should be placed each year? c Determine the total annual costs (excluding purchas-ing costs) of meeting the customers’ demands for desks. d Determine the reorder point. If the lead time werefive weeks, what would be the reorder point? (52 weeksone year.)e How would the answers to parts (a) and (b) changeif shortages were allowed and a cost of $80 is incurredif Joe’s is short one desk for one year?
ecently, Phil Harris, the production control manager at Brunswick, read an article on time-phased requirements planning. He was curious about how this technique might work in scheduling Brunswick's engine assembly operations and decided to prepare an example to illustrate the use of time-phased requirements planning. Phil's first step was to prepare a master schedule for one of the engine types produced by Brunswick: the Model 1000 engine. This schedule indicates the number of units of the Model 1000 engine to be assembled each week during the last 12 weeks and is shown on the next page. Next, Phil decided to simplify his requirements planning example by considering only two of the many components that are needed to complete the assembly of the Model 1000 engine. These two components, the gear box and the input shaft, are shown in the product structure diagram below. Phil noted that the gear box is assembled by the Subassembly Department and subsequently is sent to the main engine…
d) A company can produce three products A, B and C. the products yield a contribution of Kshs.8, 5 and 10 respectively. The products use a machine which has 400 hours capacity. Each unit of the product uses 2, 3 and 1 hour respectively of the machines capacity. There are only 150 units available in the period of a special component which is used singly in product A and C. Only 200kgs of a special alloy is available in the period. The usage of special alloy is 2kgs per unit and 4kgs per unit respectively. There is an agreement with a trade association to produce no more than 50 units of product B in the period. Advise the company on the production plan that will maximize contribution.
53. Following figures are related to LM Ltd. for the yer ending March 31, 2014. Sales 24000 units @ 200 per unit P/V ratio-25%; BEP 50% of sales. You are required to: calculate fixed cost per year; profit earned for the year; units to be sold to earn a target profit of Rs. 11,00,000 for the year; no. of units to be sold to earn the net income of 25% on cost; SP per unit, if BEP is to be brought down by 4000 units. 13