In this problem we have a company's aggregate production planning activities:QuarterDemand Forecast141,500245,000325,000462,500Beginning Workforce = 87 workersProduction per Employee = 500 units per quarterHiring Cost = $850 per workerFiring Cost = $1,600 per workerInventory Carrying Cost = $8 per unit per quarterRegular Production cost = $ 4 per unitIf a Level Production strategy is used, the annual inventory cost is:1400069000168000O 172000

As per Level Production Strategy, production in each period will be equal. Regular Production per…

Answered: If a Level Production strategy is used,…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section: Chapter Questions

Problem 133P

See similar textbooks

Similar questions

The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Can you guess the results of a sensitivity analysis on the initial inventory in the Pigskin model? See if your guess is correct by using SolverTable and allowing the initial inventory to vary from 0 to 10,000 in increments of 1000. Keep track of the values in the decision variable cells and the objective cell.
The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. As indicated by the algebraic formulation of the Pigskin model, there is no real need to calculate inventory on hand after production and constrain it to be greater than or equal to demand. An alternative is to calculate ending inventory directly and constrain it to be nonnegative. Modify the current spreadsheet model to do this. (Delete rows 16 and 17, and calculate ending inventory appropriately. Then add an explicit non-negativity constraint on ending inventory.)
The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Dont forget to modify range names. Then modify the model again so that there are only four months in the planning horizon. Do either of these modifications change the optima] production quantity in month 1?
Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?
How much influence can the employee requirements for one, two, or three days have on the weekly schedule in the employee scheduling example? Explore this in the following questions: a. Let Monday’s requirements change from 17 to 25 in increments of 1. UseSolverTable to see how the total number of employees changes.b. Suppose the Monday and Tuesday requirements can each, independently of one another, increase from 1 to 8 in increments of 1. Use a two-way SolverTable to see how the total number of -employees changes.c. Suppose the Monday, Tuesday, and Wednesday -requirements each increase by the same amount, where this increase can be from 1 to 8 in -increments of 1. Use a one-way SolverTable to -investigate how the total number of employees changes.
How much influence can the employee requirements for one, two, or three days have on the weekly sched-ule in the employee scheduling example? Explore this in the following questions:a. Let Monday’s requirements change from 17 to 25in increments of 1. Use SolverTable to see how thetotal number of employees changes.b. Suppose the Monday and Tuesday requirementscan each, independently of one another, increasefrom 1 to 8 in increments of 1. Use a two-waySolverTable to see how the total number ofemployees changes. c. Suppose the Monday, Tuesday, and Wednes-day requirements each increase by the same amount, where this increase can be from 1 to 8in increments of 1. Use a one-way SolverTableto investigate how the total number of employeeschanges.
The Westerbeck Company manufactures several models of automatic washers and dryers. The projected requirements over the next year for their washers are shown in the table below: Month & Requirement January - 710 February - 1090 March - 880 April - 690 May - 1400 June - 1130 July - 1550 August - 1020 September - 530 October - 390 November - 980 December - 1210 Current inventory is 140 units. Current capacity is 1,030 units per month. The average salary of production workers is $1,150 per month. Material costs $140/unit. Each production worker accounts for 35 units per month. Overtime is paid at time and a half. Any increase or decrease in the production rate costs $40/unit for tooling, setup, and line changes. This does not apply, however, to overtime. Inventory-holding costs are $30 per unit per month. Lost sales are valued at $70 per unit. Compare the costs of level and chase demand production plans using the Agg Plan – Level and Agg Plan – Chase…
A company is preparing an aggregate production plan for its product for the next four months. The company's expected monthly demand is given in the following table. The company will have 100 million in inventory at the beginning of this month and wishes to hold at least 100 Units at the end of each month.Important data is shown below: production cost per unit =$125 cost of inventory storage per month per unit =$10 cost of hiring per worker =$50 firing cost per worker =$100 initial number of workers =25 each worker can produce =25 units per month Month->expected demand: M1 ->600 M2->800 M3->700 M4->900 What is the total cost of a chase plan that uses only hiring/firing?
A paper published in the Harvard Business Review points out a new way to calculate economic profit that could be more appropriate for service firms and other people-intensive companies. Instead of focusing on investment and return on investment, the focus is on employee productivity, both in terms of generating revenues and reducing costs. The approach is to first determine economic profit in the conventional way, except that we ignore taxes, so that economic profit is before tax, as follows: Economic profit = Operating profit − Capital charge Assume the following information for a hotel chain that wishes to adopt the new method. The firm has $100 million in operating profit, has $1 billion in investment, and uses a cost of capital rate of 5%, so the capital charge is $50 million and the economic profit is $50 million. Relevant calculations are contained in Part 1 of the following schedule: Part 1: Economic Profit (in thousands, except cost of capital rate) Revenue $…
RMC, Inc., is a small firm that produces a variety of chemical products. In a particular production process, three raw materials are blended (mixed together) to produce two products: a fuel additive and a solvent base. Each ton of fuel additive is a mixture of 25 ton of material 1 and 35 of material 3. A ton of solvent base is a mixture of 12 ton of material 1, 15 ton of material 2, and 310 ton of material 3. After deducting relevant costs, the profit contribution is $40 for every ton of fuel additive produced and $30 for every ton of solvent base produced. RMC’s production is constrained by a limited availability of the three raw materials. For the current production period, RMC has available the following quantities of each raw material: RAW MATERIAL Amount Available for Production Material 1 20 Tons Material 2 5…
The cost data for Evencoat Paint for the year 2019 is as follows: Month Gallons ofPaintProduced EquipmentMaintenanceExpenses January 110,000 $70,700 February 68,000 66,800 March 71,000 67,000 April 77,000 68,100 May 95,000 69,200 June 101,000 70,300 July 125,000 70,400 August 95,000 68,900 September 95,000 69,500 October 89,000 68,600 November 128,000 72,800 December 122,000 71,450 A. Using the high-low method, express the company’s maintenance costs as an equation where x represents the gallons of paint produced. Then estimate the fixed and variable costs. Fixed cost $ Variable cost $
At modern woodworks, president and producer of apple crates sold to growers, has been able, with his current equipment, to produce 240 crates per 100 logs. He currently purchases 100 logs per day, and each log requires 3 labor hours to process. He believes that he can hire a profesional buyer who can buy a better quality log at the same cost. if this is the case, he can increase hos production to 260 crates per 100 logs. His labour-hours will increase by 8 hours per day. What will be the impact on productivity (measured in crates per labor-hour) if the buyer is hired?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS

If a Level Production strategy is used, the annual inventory cost is: 14000 69000 168000 172000