A manufacturer produces three models, I, II, and III, of a certain product using raw materials A and B. The following table gives the data for the problem. Requirement per unit Raw material I II III Availability Raw Material A 2 4 7797 Raw Material B 4 8 6701 Minimum demand 180 298 250 Price per unit ($) 35 25 55 The labor time per unit of model I is twice that of II and four times that of III. The entire labor force of the factory can produce the equivalent of 1987 units of model I. Market requirements specify the ratios 4:2:5 for the production of three respective models. Complete the LP model of the problem. Note: If any of the answers have decimal points, use a dot () to separate them. DON'T use comma or other symbols for the decimals. Decision variables: X = # of unites of model j (j=1,2,3) Objective function: Maximize z = * X,+ X2+ * X3 Subject to: *X1 + 4*X2 + 5*X3 s 4*X1 + *X2 + 8*X3 s Xị + 0.5*X2 + *X3 s 0.25*X1 : 0.5*X2 0.5*X2 *X3 X1 180, X2 X3 250 All variables are non-negative integers.

A manufacturer produces three models, I, II, and III, of a certain product using raw materials A and B. The following table gives the data for the problem. Requirement per unit Raw material I II III Availability Raw Material A 2 4 7797 Raw Material B 4 8 6701 Minimum demand 180 298 250 Price per unit ($) 35 25 55 The labor time per unit of model I is twice that of II and four times that of III. The entire labor force of the factory can produce the equivalent of 1987 units of model I. Market requirements specify the ratios 4:2:5 for the production of three respective models. Complete the LP model of the problem. Note: If any of the answers have decimal points, use a dot () to separate them. DON'T use comma or other symbols for the decimals. Decision variables: X = # of unites of model j (j=1,2,3) Objective function: Maximize z = * X,+ X2+ * X3 Subject to: X1 + 4X2 + 5X3 s 4X1 + X2 + 8X3 s Xị + 0.5X2 + X3 s 0.25X1 : 0.5X2 0.5X2 X3 X1 180, X2 X3 250 All variables are non-negative integers.

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

The Chineke Group of Company manufactures two products, namely product B and product P, and provides you with the following information: Prod. B Prod. P Selling price per unit 80.00 50.00 Less cost of sales: Direct material A @ R5.00 per kg 15.00 10.00 Direct material B @ R4.00 per kg 8.00 12.00 Direct labour @ R6.00 per hour 12.00 6.00 Variable manufacturing overhead @ R5.00 per labour hour 10.00 5.00 Fixed manufacturing overhead per unit 5.00 5.00 Gross profit 30.00 12.00 Less sales & administrative costs: Variable 6.00 4.00 Fixed 10.00 5.00 Net profit per unit 14.00 3.00 Take note of the following constraints: Material A available 360 kg Material B available 360 kg Labour hours available…
Breakeven between Two AlternativesGiven:Option A – Buying a MachineFC = 400,000.00 pesosSV = 80,000.00 pesosi = 10.00%n = 8 yearsAnnual Maintenance cost = 5,000.00 pesos/yearProduction cost = 800.00 pesos/dayOutput = 40 units/dayOption B – Manual ManufacturingAnnual cost = 30,000.00 pesos/yearProduction cost = 1200.00 pesos/dayOutput = 30 units/daya. Option A Annual Cost Equation = ?b. Option B Annual Cost Equation = ?c. Units per year for Breakeven = ?
123456789unn3u5167 10 5 6 Variable Cells 18 19 20 21 22 23 24 25 26 27 28 29 30 31 7 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 8 9 10 11 2 11 13 12 14 12 Constraints Name Cell $B$15 demand for A LHS $B$16 total demand LHS 16 17 $B$17 procssing time LHS Cell $C$8 A $D$8 B 15 16 Name Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 1E+30 250 100 Final Value Price 250 350 600 0 0 Shadow Constraint R.H. Side 0 4 -1 2 3 Q1 what is the range for objective coefficient of A and B? 125 350 600 1 1E+30 Allowable Allowable Increase Decrease Q4) if the objective coefficient of A goes up to 5 dollars what will happen? Q2 assume that the final value of B is 0 and the reduced cost of B is 1; explain the situation ? Q5 If the objective coefficient of B goes up to 8 dollars what will happen? Q6) if the obj coeff of A goes down to -5 dollars what does that mean? 125 125 100 1 Q3 if the objective coefficient of A goes down to 1 dollar and objective coefficient of B…
An analysis of maintenance cost of xyz Company is given below: Hours Cost HoursxCost Hours Squared 40 1,000 40,000 1,600 30 900 27,000 900 60 1,300 78,000 3,600 50 1,150 57,500 2,500 180 4,350 202,500 8,600 Using the Least Squares method of cost segregation, how much is the company’s fixed cost?a. 1,333.33b. 840c. 670d. 520e. 480 Using High-Low method of cost segregation, how much is the company’s fixed cost?a. 1,333.33b. 1,000c. 900d. 500e. 13.33
Given this frequency distribution, what demand values would be associated with the following random numbers? (Do not round intermediate calculations.) Demand Frequency 16 1 10 2 28 3 46 Random Number Simulated Demand 0.1 0.5 0.9 1.
Cesar Rego Computers, a Mississippi chain of computer hardware and software retail outlets, suppées both educational and commercial customers with memory and storage devices. It currently faces the following ordering decision relating to purchases of disks Quantly needed to quality for the discount 6.900 disks What is the LOQ9 EDO-0 unts (round your response to the nearest whole number) D S 1 Purchase price Discount price 30,900 disks $25 21% 50 89 50.01
Suppose we have a business of supplying fruits and vegetables to customers. So How to manage a order when there is lack of team members(more then 3-5 employes on leave on same time ) in the order management and order need to be fulfilled in short span of time in the following situations :-I) When Delivery team missing II) When Packaging Team missingIII) When Billing Team missing (Answer in points only ) upvote for quality answer
The following table contains figures on the annual usage and unit costs for a random sample of 12 items. Develop and A-B-C classification for these items: Item Name Annual Usage (No of Items) Unit Cost 1 500 TK 4300 2 3000 720 3 1900 500 4 1000 710 5 4500 250 6 2500 192 7 400 200 8 500 190 9 200 210 10 1000 35 11 3000 10 12 19000 3 Brown and Brown Electronics manufacture a line of digital audiotape (DAT) players. While there are differences among the various products, there are a number of common parts within each player. The bill materials showing the number of each item required, lead times and the current inventory on hand for the parts and components, follows: Demand of products A & B and demand of spares components are shown below: Item Demand on 5th week Demand on 7th Week On-Hand Lead Time (Weeks) A 700 ------ 30 1 B 1200 ------ 50…
Q6) Tracking signals track changes in control limits can lead to an increase in cumulative errors can capture changes in trends track changes in demand updates none of the above Q7) In an inventory problem, the fixed ordering costs are increased but all other factors remain the same. This change will increase the optimum order quantity change the demand pattern reduce the optimum order quantity change the stockout costs increase the optimum lead time Q8) In an MRP system, the lead time to acquire or produce components is used in calculating net requirement from gross requirements net requirements from available planned order releases from planned order receipts lot sizes for scheduled orders none of the above
Pls solve both for good rating
2. Say whether the following variances are favourable (F) or adverse (A) Variance/ reason for variance machine breakdown non-availability of material illness wage rate increase unforeseen discounts received greater care taken in purchasing change in material standards price increase careless purchasing output produced more quickly than expected because of work motivation better quality of equipment or materials production more than budgeted F/A
Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 128 units. The following is the BOM in indented form: DESCRIPTION Bracket assembly Wall board Hanger subassembly Hanger casting Ceramic knob Rivet head screw Metal tong Plastic cap USAGE 1 ITEM X A B D E 5 F G 3 1 Below is a table indicating current inventory levels: Item X 26 D 196 F G 95 Inventory 17 69 17 145 1,220 b. What are the net requirements for each item? (Leave no cells blank - be certain to enter "0" wherever required.) Item Net Requirements A B C D F G