Hart Manufacturing makes three products. Each product requires manufacturingoperations in three departments: A, B, and C. The labor-hour requirements, bydepartment, are as follows:DepartmentProduct 1Product 2Product 3A1.503.002.00B2.001.002.500.250.250.25During the next production period, the labor-hours available are 450 in department A, 350in department B, and 50 in department C. The profit contributions per unit are $25 forproduct 1, $28 for product 2, and $30 for product 3. The setup costs are $400 for product 1,$550 for product 2, and $600 for product 3. At most, 175 units of product 1, 150 units ofproduct 2, and 140 units of product 3 can be produced.Part a Formulate a mixed-integer linear programming model (identify and define decisionvariables, objective function and constraints) that can be used for maximizing total profitcontribution. For “Part a" you do NOT need to solve this problem using Excel, you justneed to do the formulation in the standard mathematical format.Part b Using the excel template provided, use Solver in Microsoft Excel to solve the modelthat you developed in "Part a". Give the values of each decision variable and the objectivefunction. You MUST attach a copy of the solution report. BEG1 Model23Max ProfitConstraintsLHSRHS456 Decision Var. Value7891011121314

Hello thank you for the question. As per guidelines, we would provide only one answer at a time.…

Part a Formulate a mixed-integer linear programming model (identify and define decision variables, objective function and constraints) that can be used for maximizing total profit contribution. For “Part a" you do NOT need to solve this problem using Excel, you just need to do the formulation in the standard mathematical format.

Part a Formulate a mixed-integer linear programming model (identify and define decision variables, objective function and constraints) that can be used for maximizing total profit contribution. For “Part a" you do NOT need to solve this problem using Excel, you just need to do the formulation in the standard mathematical format.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter12: Queueing Models

Section: Chapter Questions

Problem 59P

See similar textbooks

Similar questions

Manufacturing Aggregate Planning Manufacturers Inc. (MI) currently has a labor force of 10, which can produce 600 units per period. The labor cost is now $5000 per period per employee. The company has a long-standing rule that does not allow it to make use of any overtime. In addition, the product cannot be subcontracted, due to the specialized nature of the machinery that MI uses to produce it. As a result, MI can only increase/decrease production by hiring or laying off employees. The cost is $10000 to hire or lay off an employee. Inventory carrying costs are $200 per unit for any unsold items at the end of the period. The inventory level at the beginning of period 1 is 400 units. The forecast demand is 700 in period 1,600 in period 2,450 in period 3, 250 in period 4,500 in period 5, and 550 in period 6. a.) Compute the costs of the Chase Demand Strategy. b.) Compute the costs of the Level Strategy c.) Compare the costs of the two strategies. Which one is superior?
Because of its labor contract, a company must hire enough labor for 100 units ofproduction per week on one shift or 200 units per week on two shifts. It cannot hire,lay off, or assign overtime. During the fourth week, workers will be available fromanother department to work part or all of an extra shift (up to 100 units). There is aplanned shutdown for maintenance in the second week, which will cut production tohalf. Develop a production plan. The opening inventory is 200 units, and the desiredending inventory is 300 units
Manufacturers Inc. (MI) currently has a labor force of 10, which can produce 600 units per period. The labor cost is now $5000 per period per employee. The company has a long-standing rule that does not allow it to make use of any overtime. In addition, the product cannot be subcontracted, due to the specialized nature of the machinery that MI uses to produce it. As a result, MI can only increase/decrease production by hiring or laying off employees. The cost is $10000 to hire or lay off an employee. Inventory carrying costs are $200 per unit for any unsold items at the end of the period. The inventory level at the beginning of period 1 is 400 units. The forecast demand is 700 in period 1,600 in period 2,450 in period 3, 250 in period 4,500 in period 5, and 550 in period 6. a.) Compute the costs of the Chase Demand Strategy.
Tuff-Rider, Inc., manufactures touring bikes and mountainbikes in a variety of frame sizes, colors, and component com-binations. Identical bicycles are produced in lots of 100. Theprojected demand, lot size, and time standards are shown inthe following table: Item Touring MountainDemand forecast 5,000 units/year 10,000 units/yearLot size 100 units 100 unitsStandard processing time .25 hour/unit .50 hour/unitStandard setup time 2 hours/lot 3 hours/lot The shop currently works 8 hours a day, 5 days a week,50 weeks a year. It operates five workstations, each producingone bicycle in the time shown in the table. The shop main-tains a 15 percent capacity cushion. How many workstationswill be required next year to meet expected demand withoutusing overtime and without decreasing the firm’s currentcapacity cushion?
The manager of Roth Corporation, wants to determine whether or not the type of work schedule for her employees has any effect on their productivity. She has selected 15 production employees at random and then randomly assigned 5 employees to each of the 3 proposed work schedules. The following table shows the units of production (per week) under each of the work schedules. Work Schedule (Treatments) Schedule 1 50 60 70 40 45 Compute MSTR MSTR- 95 94.68 128.166 3.8856 Schedule 2 60 65 65 58 57 Schedule 3 75 75 55 40 55
4. The Spencer Optics Company produces an inexpensive line of sunglasses. The manufacturing process consists of assembling two plastic lenses (produced by the firm's plastic molding depart- ment) into a finished frame (purchased from an outside supplier). The company is interested in using material requirements planning to schedule its operations and has asked you to prepare an example to illustrate the technique. The firm's sales manager has prepared a 10-week sales forecast for one of the more popular sunglasses (the Classic model) for your example. The forecast is 100 units per week. Spencer has customer orders of 110 units, 80 units, 50 units, and 20 units in weeks 1, 2, 3, and 4, respectively. The sunglasses are assembled in batches of 300 units. Presently, three such batches are sched- uled: one in week 2, one in week 5, and one in week 8. Complete the following time-phased record: Week hand 1 2 3 4 5 6 7 8 9 10 Classic Model On MPS Record Forecast Orders Projected available…
A company produces three products A,B, and C. The products are processed through three machines as follows Standard Standard Standard ProductAnnual demand Time on m/c 1Time on m/c 2Time on m/c 3 A 600 15 350 2 1000 12 10 If there are 250 working days per year and the company plans to work one seven hours shift per day, then compute the number of machines required. B.
QuestionByron Sports is a manufacturer of sportswear. It produces all of its products in one department using a process costing system.The information for the current month is as follows:Beginning work in process (30% complete as to conversion cost) 12,000 unitsUnits started 90,000 unitsUnits completed and transferred out ?Ending work in process (70% complete as to conversion) 8,000 unitsCosts:Beginning work-in-process direct materials $28,800Beginning work-in-process conversion $5,040Direct materials added during month $216,000Conversion costs incurred during the month $139,200Direct materials are added at the beginning of the process. Conversion costs are incurred uniformlythroughout the production process. Costing is handled on a FIFO basis Required:a. Prepare a production cost worksheet using 5 steps approach.b. Under what conditions would a process costing system be more appropriate than a job order costing system? Explain.
A company produces two products: A and B. Prod-uct A sells for $11 per unit and product B sells for $23 per unit. Producing a unit of product A requires two hours on assembly line 1 and one unit of raw ma-terial. Producing a unit of product B requires two units of raw material, one unit of A, and two hours on as-sembly line 2. On line 1, 1300 hours of time are avail-able, and 500 hours are available on line 2. A unit of raw material can be bought (for $5 a unit) or produced(at no cost) by using two hours of time on line 1.a. Determine how to maximize profit.b. The company will stop buying raw material whenthe price of raw material exceeds what value? (UseSolverTable.)
) The following data have been prepared for master production scheduling purposes in IKEA Australia: End product A: Beginning inventory of 60, Period forecast of 10, Lot size of 30, and 30 hours in lot size. End product B: Beginning inventory of 20, Period forecast of 5, Lot size of 20, and 20 hours in lot size. End product C: Beginning inventory of 30, Period forecast of 15, Lot size of 50, and 50 hours in lot size. Capacity: 38 hours/ week (i) Prepare the master production schedule for these items during the next four periods using the Ethan Allen master production scheduling method. (ii) Suppose that the master production schedule is frozen for the next three periods. What specific impact would the policy have on the IKEA's performance?
A bicycle component manufacturer produces hubs for bike wheels. Two processes are possible for manufacturing, and the parameters of each process are as follows: Process 1 Production rate Daily production time Process 2 35 parts/hour 4 hours/day 20% 15 parts/hour 7 hours/day 9% Percent parts rejected Assume that the daily demand for hubs allows all defect-free hubs to be sold. Select the process that maximizes profit per day if each part is made from $4 worth of material and can be sold for $30. Both processes are fully automated, and variable overhead cost is charged at the rate of $40 per hour.
Direct Materials and Direct Labor Variance Analysis Shasta Fixture Company manufactures faucets in a small manufacturing facility. The faucets are made from brass. Manufacturing has 50 employees. Each employee presently provides 32 hours of labor per week. Information about a production week is as follows: Standard wage per hour $12.00 Standard labor time per unit 15 min. Standard number of lbs. of brass 1.5 lbs. Standard price per lb. of brass $11.00 Actual price per lb. of brass $11.25 Actual lbs. of brass used during the week 11,124 lbs. Number of units produced during the week 7,200 Actual wage per hour $12.36 Actual hours for the week (50 employees × 32 hours) 1,600 Required: a. Determine the standard cost per unit for direct materials and direct labor. Round the cost per unit to two decimal places. Direct materials standard cost per unit $fill in the blank 1 Direct labor standard cost per unit $fill in the blank 2 Total standard cost per unit $fill in…