The 3J Company manufactures handbags, shoulder bags, and backpacks. The construction of the three products requires leather and synthetics, with leather being the limiting raw material. The production process uses two types of skilled labor: sewing and finishing. The following table gives the daily availability of the resources, their usage by the three products, and the prices per unit. Leather (ft³) Sewing (hr) Finishing (hr) Price in Pesos Hand bag 3 2 2 1200 Requirement per Unit Shoulder bag Backpack 4 3 2 2250 2 1.5 1 1100 Availability 45 43 47 a. Define the decision variables and formulate a linear programming model for this problem. b. Find the optimal solution using the Excel Solver and interpret the result. c. Determine the binding constraints.

The 3J Company manufactures handbags, shoulder bags, and backpacks. The construction of the three products requires leather and synthetics, with leather being the limiting raw material. The production process uses two types of skilled labor: sewing and finishing. The following table gives the daily availability of the resources, their usage by the three products, and the prices per unit. Leather (ft³) Sewing (hr) Finishing (hr) Price in Pesos Hand bag 3 2 2 1200 Requirement per Unit Shoulder bag Backpack 4 3 2 2250 2 1.5 1 1100 Availability 45 43 47 a. Define the decision variables and formulate a linear programming model for this problem. b. Find the optimal solution using the Excel Solver and interpret the result. c. Determine the binding constraints.

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

ChapterC: Cases

Section: Chapter Questions

Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
Cryolab Inc makes and sells a lawn fertilizer called Hypergro. The company has developed standard costs for one bag of Hypergro as follows: Standard Quantity/Hours Standard Price/Rate Standard Cost per Bag Direct Material 25 pounds ₱ 0.75 ₱18.75 Direct Labor 0.25 hours ₱69.00 ₱17.30 Variable overhead 0.25 hours ₱24.00 ₱ 6.00 Total ₱42.05 The company had no beginning inventories of any kind on January 1. Variable overhead is applied to production on the basis of standard direct labor hours. During January, the following activity was recorded by the company: Production of Fastgro: 23,000 bags Direct materials purchased: 585,000 pounds at a cost of ₱436,250 Direct labor worked: 5,800 hours at a cost of ₱397,300 Variable overhead incurred: ₱140,650 Inventory of direct materials on January 31: 8,000 pounds Compute the variances and indicate whether it is FAVORABLE (F) or UNFAVORABLE (U) in your solution sheet. The raw…
Your head of division has asked you to evaluate the alternatives for producing newly designed jig on milling machine. He gives you the following facts: An old milling machine valued at RM 150,000 exists in the warehouse that can be modified for the new jig. The production line supervisor has given an estimate of RM 25,000 to modify this machine. It is hoped that the milling machine will be able to meet production requirements at full capacity. Another vendor, CARE Sdn Bhd, has produced the machine five years ago and can easily do the same modifications for RM45,000. The cooling system used for this machine is not environmentally safe and would require some disposal costs. CARE Sdn Bhd has offered to build a new milling machine to be more environmental friendly and a higher capacity for a price RM250,00. For this scenario: (a) Define the problem statement. (b) Explain ONE (1) key assumption. (c) Explain THREE (3) alternatives available.
Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) January 4,150 February 4,250 March 3,950 April 4,350 May 4,950 June 4,650 July 5,250 August 4,850 September 5,350 October 5,650 November 6,250 December 5,950 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this…
Mpho is an avid seamstress and want to sew and sell high quality, reusable, designer face masks during the current Covid-19 pandemic. She will design and sew the masks herself and use her automatic embroidery machine to put her logo on each mask sold. With the help of her son, deliveries will be made all over Gauteng within 3 days of placing the order. Every mask will have a unique three-layer design with adjustable straps to ensure comfort and fit. Mpho’s only expense is the material needed to sew the masks and delivery costs. At this stage, Mpho’s target market is limited to Gauteng. Question: Create a diagram to illustrate the transformation process of Mpho’s new business. Be sure to include all relevant elements, headings and arrows to indicate the flowof products/ services. What should be in the diagram: outputs, inputs, feedback, transformation process and flow of product and service ect.
Handerson Corporation makes a product with the following standard costs: Direct materials Direct labor Variable overhead Standard Quantity or Hours 8.5 kilos 0.4 hours 0.4 hours Standard Price or The company reported the following results concerning this product in August. Actual output Raw materials used in production Purchases of raw materials Rate $ 6.00 per kilo $ 20.00 per hour $ 6.00 per hour 3,200 units 29,030 kilos 31,600 kilos Actual direct labor-hours 1,160 hours Actual cost of raw materials purchases $ 195,920 $ 22,736 Actual variable overhead cost $ 7,540 Actual direct labor cost The company applies variable overhead on the basis of direct labor-hours. The direct materials purchases variance is computed when the materials are purchased. The materials price variance for August is: Multiple Choice $5,440 F
Green Gardens' owner has asked your advice about a possible problem at his business. Over the last 6 months the large-sized lawn and garden inventory (ie, tables, chairs, planters, etc.) has appeared to be short. The inventory records that employees use to determine what is on hand show that more inventory is available than can actually be located. This has cause frustration and mis-trust in the inventory records for the sales employees. The owner realizes that the problem is bigger than just frustrated employees. He is afraid that inventory is being stolen, a problem he didn't think possible given that these are large items that are not easily moved. Requirements: Provide the owner with two internal controls that he could implement to reduce the likelihood of theft of the lawn and garden inventory.
Mpho is an avid seamstress and want to sew and sell high quality, reusable designer face masks during the current Covid-19 pandemic. She will design and sew the masks herself and use her automatic embroidery machine to put her logo on each mask sold. With the help of her son, deliveries will be made all over Gauteng within 3 days of placing the order. Every mask will have a unique three-layer design with adjustable straps to ensure comfort and it. Mpho’s only expenseis the material needed to sew the masks and delivery costs. At this stage, Mpho’starget market is limited to Gauteng. Draw a diagram to illustrate the transformation process of Mpho’s new business. Be sure to include all relevant elements, headings and arrows to indicate the flow of products/ services. Question: 1. Draw a diagram to illustrate the transformation process of Mpho’s new business. Be sure to include all relevant elements, headings and arrows to indicate the flow of products/ services.
Mpho is an avid seamstress and want to sew and sell high quality, reusable, designer face masks during the current Covid-19 pandemic. She will design and sew the masks herself and use her automatic embroidery machine to put her logo on each mask sold. With the help of her son, deliveries will be made all over Gauteng within 3 days of placing the order. Every mask will have a unique threelayer design with adjustable straps to ensure comfort and fit. Mpho’s only expense is the material needed to sew the masks and delivery costs. At this stage, Mpho’s target market is limited to Gauteng. Draw a diagram to illustrate the transformation process of Mpho’s new business. Be sure to include all relevant elements, headings and arrows to indicate the flow of products/ services
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January 4,220 February 4,320 March 4,020 April 4,420 May 5,020 June 4,720 July 5,320 August 4,920 September 5,420 October 5,720 November 6,320 December 6,020 Using linear regression analysis, what would you estimate demand to be for each month next year? (Round two decimal places) To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units…
Identify the concepts and their corresponding description, obtained from the survey of a construction company: In the context of a construction company, it is required to maintain the organization of different works that the company carries out. Our client is in the habit of organizing a set of tasks into what is called a batch. Items are used as units of work intermediate level, to which a limited amount of material can be assigned to fulfill the tasks that compose them. It is necessary to distinguish the suppliers and the prices of each material, even if there is only one supplier for each material. Although rare, tasks can have an associated machine; but generally, they have more than one. The machines are not related to the work other than by the tasks and the items; and only operators with category “A” can operate them. All workers are paid according to their category and the hours worked, regardless of the work. ➢ Carry out the definition of the types of objects found. ➢ Develop…
Franklin Company makes fine jewelry that it sells to department stores throughout the United States. Franklin is trying to decide which of the two bracelets to manufacture. Cost data pertaining to the two choices follow. Bracelet A Bracelet B Cost of materials per unit Cost of labor per unit Advertising cost per year Annual depreciation on existing equipment %24 30 37 43 43 8,800 6,500 7,700 5,900 Required a. Identify the fixed costs and determine the amount of fixed cost for each product. b. Identify the variable costs and determine the amount of variable cost per unit for each product. c. Identify the avoidable costs and determine the amount of avoidable cost for each product.