Alan Industries is expanding its product line to include three new products: A, B, and C. These are to be produced on the same production equipment, and the objective is to meet the demands for the three products using overtime where necessary. The demand forecast for the next four months, in hours required to make each product is: PRODUCT APRIL MAY JUNE A 790 590 790 JULY 1,190 B 590 690 890 с 690 490 690 1,090 840 Because the products deteriorate rapidly, there is a high loss in quality and, consequently, a high carrying cost when a product is made and carried in inventory to meet future demand. Each hour's production carried into future months costs $3 per production hour for A, $4 for B, and $5 for C. Production can take place either during regular working hours or during overtime. Regular time is paid at $4 when working on A, $5 for B, and $6 for C. The overtime premium is 50 percent of the regular time cost per hour. The number of production hours available for regular time and overtime is Regular time Overtime APRIL 1,490 MAY 1,380 690 640 JUNE 1,790 JULY 2,000 890 940 Calculate the objective value using Excel Solver. (Do not round intermediate calculations.) Objective value

Alan Industries is expanding its product line to include three new products: A, B, and C. These are to be produced on the same production equipment, and the objective is to meet the demands for the three products using overtime where necessary. The demand forecast for the next four months, in hours required to make each product is: PRODUCT APRIL MAY JUNE A 790 590 790 JULY 1,190 B 590 690 890 с 690 490 690 1,090 840 Because the products deteriorate rapidly, there is a high loss in quality and, consequently, a high carrying cost when a product is made and carried in inventory to meet future demand. Each hour's production carried into future months costs $3 per production hour for A, $4 for B, and $5 for C. Production can take place either during regular working hours or during overtime. Regular time is paid at $4 when working on A, $5 for B, and $6 for C. The overtime premium is 50 percent of the regular time cost per hour. The number of production hours available for regular time and overtime is Regular time Overtime APRIL 1,490 MAY 1,380 690 640 JUNE 1,790 JULY 2,000 890 940 Calculate the objective value using Excel Solver. (Do not round intermediate calculations.) Objective value

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter11: Linear Optimization Models

Section: Chapter Questions

Problem 19P: The Calhoun Textile Mill is in the process of deciding on a production schedule. It wishes to know...

See similar textbooks

Similar questions

Suppose that a manufacturer plans to produce 78,000 units of product duringa year. A lot of size L, to be determined, is to be made periodically, andevery time a lot is made, it is necessary to set up the appropriate machineryand other production facilities before production starts. The set up cost is thena fixed cost incurred for each lot produced and it is determined as $ 200. Whenproduction commences , the cost of making a unit is constant at $ 7.5 per unit.Inventory cost is to be determined on the basis that it costs $ 0.50 per year tocarry one unit in inventory. Also find how many lots the manufacturerwould make per year and each lot would be produced in how manydays ?.
The Sandstone Corporation uses an injection molding machine to make a plastic product, Z35, after receiving firm orders from its customers. Sandstone estimates that it will receive 60 orders for Z35 during the coming year. Each order of Z35 will take 100 hours of machine time. The annual machine capacity is 8,000 hours. Q. Calculate (a) the average amount of time that an order for Z35 will wait in line before it is processed and (b) the average manufacturing cycle time per order for Z35.
Riggins, Inc. manufactures one product called tybos. The company uses a standard cost system and sells each tybo for $8. At the start of monthly production, Riggins estimated 9,500 tybos would be produced in March. Riggins has established the following material and labor standards to produce one tybo: Standard Quantity Standard Price Direct materials 2.5 pounds $3 per pound Direct labor 0.6 hours $10 per hour During March 2022, the following activity was recorded by the company relating to the production of tybos: 1. The company produced 9,000 units during the month. 2. A total of 24,000 pounds of materials were purchased at a cost of $66,000. 3. A total of 24,000 pounds of materials were used in production. 4. 5,000 hours of labor were incurred during the month at a total wage cost of $55,000. Calculate the following variances for March for Riggins, Inc. Identify whether each variance is favorable or unfavorable.…
The Pacific Lumber Company and Mill processes 10,000 logs annually, operating 250 days peryear. Immediately upon receiving an order, the logging company’s supplier begins delivery tothe lumber mill, at a rate of 60 logs per day. The lumber mill has determined that the orderingcost is $1,600 per order and the cost of carrying logs in inventory before they are processed is$15 per log on an annual basis. Determine The number of operating days required to receive an order
Midwest Industrial Products Corporation makes two products, Product H and Product L. Product H isexpected to sell 50,000 units next year and Product L is expected to sell 10,000 units. A unit of either product requires 0.2 direct labor-hours.The company’s total manufacturing overhead for the year is expected to be $1,920,000.Required:1. The company currently applies manufacturing overhead to products using direct labor-hours asthe allocation base. If this method is followed, how much overhead cost would be applied to eachproduct? Compute both the overhead cost per unit and the total amount of overhead cost that wouldbe applied to each product. (In other words, how much overhead cost is applied to a unit of ProductH? Product L? How much overhead cost is applied in total to all the units of Product H? Product L?)2. Management is considering an activity-based costing system and would like to know what impact thischange might have on product costs. For purposes of discussion, it has been…
Southeastern Bell stocks a certain switch connector at its central warehouse for supplying field service offices. The yearly demand for these connectors is 15,300 units. Southeastern estimates its annual holding cost for this item to be $23 per unit. The cost to place and process an order from the supplier is $74. The company operates 300 days per year, and the lead time to receive an order from the supplier is 2 working days. a) What is the economic order quantity? units (round your response to the nearest whole number).
Nash Corporation manufactures and sells custom snowmobiles. From the time an order is placed till the time the snowmobile reaches the customer averages 50 days. This 50 days is spent as follows: Wait time: 10 days Move time: 5 days Process time: 15 days Queue time: 15 days Inspection time: 5 days What is Nash's manufacturing cycle efficiency (MCE) for its snowmobiles?
Answer all subparts a to f.if answered within 30mins,it would be helpful Accounting ETS manufactures a component for its computer products. The annual demand for thiscomponent is 2500 units. The annual cost of maintaining inventory is10% per unit and the cost of preparing an order and setting up productionfor the order is $ 50.The machine used to make this part has a production rate of 10,000units per year and the cost is $ 22 per unit.a. Find the EPQ(Economic Production Quantity)A. How long does it take to produce the batch?B. How many batches will be produced per year?C. What is the maximum inventory level?D. What is the total cost per year?E. A supplier offers to sell a similar component for $ 25 per unit with a charge$ 5 per service per order. Should the company accept the offer?F. Find the average inventory level for each situation
TimsTabletCo (TTC) produces tablet computers, and it must determine the number of units to be produced during each of the next four months. The following table gives the monthly demand and the monthly cost of producing each unit: Month 1 2 3 4 Demand (in units) 5000 2000 6000 1000 Production Cost (dollars per unit) 400 600 200 300 At the start, before Month 1, TTC has an inventory of 2000 units. Each month, up to 4000 units can be produced. TTC can use the units produced in a particular month in two ways: either use some units to satisfy the demand in the same month, or store some units in inventory for future use. The cost of storing units in inventory is $100 per unit per month. (a) Formulate an LP problem (P) to minimize the total cost of meeting the demands of the next four months. (b) Write the dual LP (D) of (P).
Remarkable Enterprises requires four units of part A for every unit of Al that it produces. Currently, part A is made by Remarkable, with these per-unit costs in a month when 4,000 units were produced: Variable manufacturing overhead is applied at $1.60 per unit. The other $0.50 of overhead consists of allocated fixed costs. Remarkable will need 8,000 units of part A for the next years production. Altoona Corporation has offered to supply 8,000 units of part A at a price of $8.00 per unit. If Remarkable accepts the offer, all of the variable costs and $2,000 of the fixed costs will be avoided. Should Remarkable accept the offer from Altoona Corporation?
Gent Designs requires three units of part A for every unit of Al that it produces. Currently, part A is made by Gent, with these per-unit costs in a month when 4.000 units were produced: Variable manufacturing overhead is applied at $1.00 per unit. The other $0.30 of overhead consists of allocated fixed costs. Gent will need 6,000 units of part A for the next years production. Cory Corporation has offered to supply 6,000 units of part A at a price of $7.00 per unit. It Gent accepts the offer, all of the variable costs and $1,200 of the fixed costs will be avoided. Should Gent Designs accept the offer from Cory Corporation?
Bobcat uses a traditional cost system and estimates next years overhead will be $800.000, as driven by the estimated 25,000 direct labor hours. It manufactures three products and estimates the following costs: If the labor rate is $30 per hour, what is the per-unit cost of each product?