(CA, May 1995) 20. Three products, A, B and C are produced at three machine centres, X, Y and Z. Each product invol operation at each of the machine centres. The time required for each operation on various products indicated in the following table: Machine centres Profit per unit (P) Product 10 7. 2 12 3. 4. C 1 2 1 1. Available Hours 100 77 80 (a) Formulate a linear programming problem on the basis of above information. (b) Find out the product mix so as to maximise profit. (c) Show that the total available hours of X and Y have been fully utilised and there is surplus hours of Z. How many hours are surplus in machine centre Z? A manufacturer of baby dolls makes thre these doll

(CA, May 1995) 20. Three products, A, B and C are produced at three machine centres, X, Y and Z. Each product invol operation at each of the machine centres. The time required for each operation on various products indicated in the following table: Machine centres Profit per unit (P) Product 10 7. 2 12 3. 4. C 1 2 1 1. Available Hours 100 77 80 (a) Formulate a linear programming problem on the basis of above information. (b) Find out the product mix so as to maximise profit. (c) Show that the total available hours of X and Y have been fully utilised and there is surplus hours of Z. How many hours are surplus in machine centre Z? A manufacturer of baby dolls makes thre these doll

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

Related questions

Q: Required: 1. Using the least-squares regression method, estimate the variable utilities cost per ton…

A: Mathematic models of decision-making help businesses take the correct decision for their operational…

Q: (Use an excel sheet to show formulas used)

A: (a) Volume break even= Fixed cost/(revenue per unit- variable cost per unit) (b) Profit=…

Q: Please do not give solution in image format thanku A producer of pottery is considering the…

A: Production is the process in which inputs are combined to produce the required output. It includes…

Q: APP Trial and Error Given the following information: Quarter Demand 2…

A: The utilization of a level procedure implies that an organization will deliver at a consistent rate…

Q: Bangs Leisure Chairs Linear solution Sling Chair: Adirondack Hammocks O 22,5806452 1,61290323 Data…

A: Decision variables: Suppose,S = No. of sling chairs to be producedA = No. of Adirondack chairs to…

Q: Supply/Demand Info Forecast (demand) Regular production Subcontract production Ending inventory…

Q: Problem 1 The following information applies to the City View Restaurant. May 1 Food inventory value:…

A: Inventory control is also described as the control of stock and is a means of managing of inventory…

Q: FEB MAR APR MAY BEGINNING INV PERIOD JAN JUN TOTAL BEGINNING WORKERS AVGE. MONTHLY OUTPUT PER WORKER…

A: The Chase plan strategy is an approach to production and capacity planning in which a company…

Q: *5. BagBoy makes a popular model pull cart for golfers. The company wants to determine the upcoming…

A: Now, let's solve this problem using Excel Solver. (a) **Interpretation of the solution:** The…

Q: Supply/Demand Info Forecast (demand) Regular production Subcontract production Ending inventory…

A: The Chase Production Plan is based on the production planning approach that adjusts the production…

Q: What is the Available-to-Promise (ATP) for week 2? (A)

A: ATP (available to promise) is that portion of inventory or stock which is uncommitted. It helps in…

Q: The industry in which Morton Company operates is quite sensitive to cyclical movements in the…

A: Answer information:Step 1:Answer 1. Morton CompanyContribution Income Statement Present…

Q: Given the following table solve by vogel approximation method

A: The transportation model is used to calculate the minimum cost of the route by selecting different…

Q: Plan production for the next year. The demand forecast is spring, 20,000; summer, 10,000; fall,…

A: The demand forecast is: Spring= 20,000Summer, 10,000Fall, 15,000winter, 18,000. Workers at the…

Q: The Lesseig Company has an opportunity to invest in one of two mutually exclusive machines that will…

A: Project management involves all those activities that is important for the smooth functioning of the…

Q: Fanning Company and Finch Company both apply overhead to the Work in Process Inventory account using…

A: Part (a): Compute the Predetermined Overhead Rate for Each Company The predetermined overhead rate…

Q: Product Locks Corporation produces three products, A, B, and C. Pertinent information on these…

A: Linear programming is a mathematical method used to find the best possible outcome or solution from…

Q: a. Within the dorm room, is the showing of a movie a publie good? Why or why not?

A: Since you have asked multiple questions, we will solve the first question for you. If you want any…

Question

(CA, May 1995)
20. Three products, A, B and C are produced at three machine centres, X,Y and Z. Each product involy
operation at each of the machine centres. The time required for each operation on various products
indicated in the following table:
Machine centres
Profit per unit
(7)
Product
Y
10
7
2
12
B
3
4
3
1
1
1.
Available Hours
100
77
80
(a) Formulate a linear programming problem on the basis of above information.
(b) Find out the product mix so as to maximise profit.
(c) Show that the total available hours of X and Y have been fully utilised and there is surplus hours
b of Z. How many hours are surplus in machine centre Z?
A manufacturer of baby dolls makes three types of dolls: Doll A. Doll R ond D
these dolls is done on three machines M
three h

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Step by step

Solved in 3 steps with 9 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions

Q.1. a) Identify the challenges affecting the delivery performance and buffer levels in an in-house material handling system at BRL. (
4. (Ch10) A retailer experiences a seasonal demand pattern for its services. Labor requirements over a typical six-month period follow. Period Requirement 1 12 2 10 Costs associated with operations are as follows: Wages = $1,500 per worker per month Hiring cost = $1,500 per worker Layoff cost = $1,500 per worker 3 12 4 8 5 9 6 8 The current workforce level is 11 workers. Use the spreadsheet approach and the preceding data to answer the following questions. a. What is the total cost of the staffing plan, including the cost of regular wages, hiring, and layoffs using a chase strategy with hiring and layoffs, but no overtime? b. What is the total cost of the staffing plan, using a level strategy in which no overtime is allowed, and the undertime paid for? c. Suppose that overtime is allowed up to 25% of the regular-time capacity, and that overtime wages are 150% of the regular-time rate. What is the total cost of the level strategy with overtime and undertime that also minimizes…
1
PP.71 A small manufacturer of specialty welding equipment has developed a combination production plan for the next four quarters, as seen below. Supply/Demand Info Pre-Q1 Q1 4,620 4,620 Forecast (demand) Regular production Subcontract production Ending inventory Hired employees Fired employees Total employees 42 42 Q2 Q3 Q4 4,730 5,390 5,170 5.080 5.060 5.080 330 4 46 The table below shows additional relevant information: Capacity Information & Cost Variables Production rate (units/employee/quarter) Subcontractor capacity (units/quarter) Regular production cost/unit Holding cost'unit/quarter Hiring cost/employee Firing cost/employee Subcontract cost/unit 110 480 $85 $13 $820 $2,150 $119 110 110 46 46 What is the overall total cost for this production plan? (Display your answer to the nearest whole number.) Number What is the total subcontract cost for this production plan? (Display your answer to the nearest whole number.) Number What is the total holding cost for this production plan?…
Need d and e
11
Question 40 A production manager wants to determine how many units of each product to produce weekly to maximize weekly profits. Production requirements for the products are shown in the following table. TTIT Product Material 1 Material 2 Labor ... (Ibs.) (Ibs.) (hours) A 4 B 1 4 5 none 3.5 Each week there are 300 pounds of material 1; 400 pounds of material 2; and 200 hours of labor. There is a standing order of 10 units of product C each week. The following table shows the output of POMQM. Variable Value Reduced Cost Original Val Lower Bound -In finity Upper Bound A 10 10 20 B 82.5 10 5.7143 Infinity C 10 10 -In finity 17.5 Original Val Lower Bound 300 Constraint Dual Value Slack/Surplus Upper Bound Constraint 1 167.5 In finity In finity 235 132.5 Constraint 2 70 400 330 Constraint 3 5 200 35 Constraint 4 -7.5 10 57.1429 Which constraints are binding? A All constraints are binding. B 1 and 2 3 and 4 D 2 and 3 E) 1 and 4
Q7. The president of Rose Bowl Enterprises, Desmond Howard, projects the firms aggregate DEMAND requirements over the next 8 months as follows: These are the monthly DEMAND, not production. MONTH JAN FEB MAR APR MAY JUN JULY AUG DEMAND 1,400 1,600 1,800 1,800 2,200 2,200 1,800 1,800 PRODUCTION 1,600 from December INVENTORY 200 from Dec plus 200 His operations manager is considering a new plan, which begins in January with 200 units on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle time costs. The plan is called plan A. Plan A: Vary the workforce level to execute a strategy that produces the quantity demanded in the prior month. The December demand was given as 1,600 units per month. Therefore, the production for JAN will be 1,600. However, only 1,400 are needed. Therefore, the extra 200 produced go into inventory and there is a holding cost for inventory. Also, per the above, you already have 200 units in inventory…
Question 15 $1 h $0.50 $0.75 Estimate the cost of a stock-out if the margin is $1 and half the time the customer simply doesn' buy anything. $0.25 B Question 16 nwacc.instructure.com TH 2 mond of 6. Unfortunatel:
Q: Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 consider Cake (C) 0 -0.5 4.5 0.5 1E+30 $C$5 consider Dozen Cookies (D) 10 0 10 1E+30 1 what does the value minus .5 for the reduced cost of C mean (other than it is the change in thevalue of the coefficient in the objective function so that the solution includes a positive amountof C)?
10