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

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.…
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 company uses Component M at the rate of 2,900 per week. The timebetween placing an order and receiving the components is five weeks.The reorder quantity is 15,000 units.Required:- Calculate the reorder level.?
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
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).
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?
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?
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?
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?
The Silver Star Bicycle Company will manufacture both mens and womens models for its Easy-Pedal bicycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 mens and 125 womens models to be shipped during the first month and 200 mens and 150 womens models to be shipped during the second month. Additional data are as follows: Last month, the company used a total of 1,000 hours of labor. The companys labor relations policy will not allow the combined total hours of labor (manufacturing plus assembly) to increase or decrease by more than 100 hours from month to month. In addition, the company charges monthly inventory at the rate of 2% of the production cost based on the inventory levels at the end of the month. The company would like to have at least 25 units of each model in inventory at the end of the two months. (Hint: Define variables for production and inventory held in each period for each product. Then use a constraint to define the relationship between these: inventory from end of previous period + produced this period demand this period = inventory at end of this period.) a. Establish a production schedule that minimizes production and inventory costs and satisfies the labor-smoothing, demand, and inventory requirements. What inventories will be maintained and what are the monthly labor requirements? b. If the company changed the constraints so that monthly labor increases and decreases could not exceed 50 hours, what would happen to the production schedule? How much will the cost increase? What would you recommend?