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…
A plastic manufacturing company that makes four major products seeks to expand its operationsin the coming year. At the beginning of the financial year, the company must decide on which offour new machines A, B, or C to purchase to be able to meet total annual demand. Each machineoperates 14 hours a day, 360 days a year. Machine A costs GH¢43,000, machine B costsGH¢37,500 and machine C costs GH¢75,000. The following product forecasts and processing times have been projected: Demand, units/year Processing times per Unit (Minutes) Product Machine A Machine B Machine CPenholders 16,000 5 3 6Bowls 14,000 4 3 5Cups 6,000 6 5 7Carrier Bags 24,000 3…
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?
The owner of Warwick Printing is planning direct labor needs for the upcoming year. The owner has provided you with the following information for next year's plans: Each color on the banner must be printed one at a time. Thus, for example, a four-color banner will need to be run through the printing operation four separate times. The total production volume last year was 800, as follows: The four-color banner is a new product offering for the upcoming year. The owner believes that the expected 1,000-unit increase in volume fromlast year means that direct labor expenses should increase bu 125% (1,000/800). What do you think?
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?
Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines: a shaper and a grinder. The times (in minutes) required on each machine are as follows: The shaper is available for 120 hours, and the grinder for 110 hours. No more than 200 units of component 3 can be sold, but up to 1,000 units of each of the other components can be sold. In fact, the company already has orders for 600 units of component 1 that must be satisfied. The profit contributions for components 1, 2, and 3 are 8, 6, and 9, respectively. a. Formulate and solve for the recommended production quantities. b. What are the objective coefficient ranges for the three components? Interpret these ranges for company management. c. What are the right-hand-side ranges? Interpret these ranges for company management. d. If more time could be made available on the grinder, how much would it be worth? e. If more units of component 3 can be sold by reducing the sales price by 4, should the company reduce the price?