Concept explainers
HIGHLINE FINANCIAL SERVICES, LTD.
Highline Financial Services provide; three categories of service to its clients. Managing partner Freddie Mack is getting ready to prepare financial and personnel hiring (or layoff) plans for the coming year. He is a bit perplexed by the following printout he obtained, which seems to the three categories of services ever the past eight quarters:
Examine the demand that this company has experienced for the three categories of services it offers over the preceding two years. Assuming nothing changes in terms of advertising or promotion, and competition doesn’t change, predict demand for the services the company offers for the next four quarters. Note that there are not enough data to develop seasonal relatives Nonetheless, you should be able to make reasonably good, approximate intuitive estimates of demand. What general observations can you make regarding demand? Should Freddie have any concerns? Explain.
Want to see the full answer?
Check out a sample textbook solutionChapter 3 Solutions
EBK OPERATIONS MANAGEMENT
- 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.arrow_forwardThe 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.)arrow_forwardThe 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?arrow_forward
- Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?arrow_forwardEdwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company’s needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Supplier Component 1 2 3 1 $13 $14 $15 2 $11 $12 $11 Each supplier has a limited capacity in terms of the total number of components it can supply. However, as long as Edwards provides sufficient advance orders, each supplier can devote its capacity to component 1, component 2, or any combination of the two components, if the total number of units ordered is within its capacity. Supplier capacities are as follows: Supplier 1 2 3 Capacity 400 800 600 If the Edwards production plan for the next period includes 800 units of component 1 and 600 units of component 2, what purchases do you recommend? That is, how many units of each component should be…arrow_forwardEdwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company’s needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Supplier Component 1 2 3 1 $12 $12 $15 2 $11 $10 $12 Each supplier has a limited capacity in terms of the total number of components it can supply. However, as long as Edwards provides sufficient advance orders, each supplier can devote its capacity to component 1, component 2, or any combination of the two components, if the total number of units ordered is within its capacity. Supplier capacities are as follows: Supplier 1 2 3 Capacity 575 950 800 If the Edwards production plan for the next period includes 1050 units of component 1 and 775 units of component 2, what purchases do you recommend? That is, how many units of each component should be…arrow_forward
- Frober Co's institutional investors are becoming increasingly impatient for growth at the company. The directors have identified a significant opportunity in a new market but Frober doesn't currently have the capabilities to exploit that opportunity. The nature of Frober's work means that its processes require a number of high technology processes, and the directors have agreed that Frober must retain full control over its operations in any markets it moves into. In this context, which of the following is the MOST appropriate basis of growth for Frober Co?arrow_forwardA goldsmith makes two types of jewelry. A model A ring is made with 1 g of gold and 1.5 g of silver and sells for 25 UM.Another model B ring sells for 30 UM and is made of 1.5 g of gold and 1 g of silver. If you only have 750 gof each metal, how many rings should be made of each type to obtain maximum profit?Requested:- Make Initial Table of the problem.- Obtain the Case Variables- Obtain the Objective Function- Get Restrictions- Create the Simplex Table- Obtain the Optimal Solution and the Slack Variables.Solve this operational research exercise.arrow_forwardAn automobile manufacturer wants to award contracts for the supply of four different fuel injection system components. Four contracts have submitted bids on the components; the Table below summarizes the prices bid per unit. Where no entry is made, the contractor submitted no bid. Component Contractor 1 2 3 4 1 $25 - $30 $40 2 $28 $80 $28 - 3 - $75 $33 - 4 $30 $82 - $42 Demand (units) 15,000 30,000 10,000 20,000 The demand for a component does not have to be supplied completely by one contractor. In fact, certain contractors have indicated maximum quantities that can be supplied at the bid price. Contractor 1 can supply no more than 18,000 of item 4, contractor 2 no more than 3,000 of item 1, contractor 4 no more than 15,000 units of item 2 and no more than 5,000 of item 4. There is no provision that awards must go to the low bidder. The automobile manufacturer wants to determine how many units of each…arrow_forward
- The state firefighters’ association has a membership of 15,000. The purpose of the organization is to provide some financial support to the families of deceased member firefighters and to organize a conference each year bringing together firefighters from all over the state. Annually, members are billed dues and calls. “Calls” are additional funds required to take care of payments made to the families of deceased members. The bookkeeping work for the association is handled by the elected treasurer, Bob Smith, although it is widely known that his wife, Laura, does all of the work. Bob runs unopposed each year at the election, since no one wants to take over the tedious and time consuming job of tracking memberships. Bob is paid a stipend of $8000 per year, but his wife spends well over 20 hours per week on the job. The organization, however, is not happy with their performance. A computer system is used to track the billing and receipt of funds. This system was developed in 1984 by a…arrow_forwardXYZ Limited is a clothing wholesaler that sells name-brand clothing to department stores and boutique dress shops. The Figure at the end of this question describes the credit sales procedures of XYZ Limited. In particular, the Figure describes different business activities of four departments including (1) Sales Department, (2) Accounting Department, (3) Warehouse/Shipping, and (4) Mailroom. Further, these activities are elaborated below. The sales department received the customer orders by fax and email. You should be aware that these sales orders are usually unstandardised sales orders. The sales clerk, who works on commission, performs the following tasks: approves the credit sales, calculates commission and discounts, and records the sales in the sales journal from the PC in the sales department. After entering these records, the sales clerk then prepares three documents, including (1) a sales order, (2) a customer invoice, and (3) a packing slip. These documents are…arrow_forwardKellpost Cereal Company sells four products: (1) Special L (a low-calorie, high-nutrition cereal); (2) Corn Bran (another low-calorie, high-nutrition cereal); (3) Admiral Smacks (a sugary cereal pitched at the children's market); and (4) Honey Pops (another sweet cereal pitched at the children's market). Kellpost has sufficient production capacity to produce a total of 10,000 boxes of cereal per month. For each of the past 16 months, Kellpost has kept track of the price and sales of each product. (These data are listed in the file P07_72.xlsx.) Market executives believe that Special L and Corn Bran might be substitutes for each other, as might be Admiral Smacks and Honey Pops. For example, this means that an increase in the price of Special L might raise the sales of Corn Bran. The variable cost of bringing a box of each cereal to market is as follows: Special L, $2.00; Corn Bran, $2.20; Admiral Smacks, $2.30; Honey Pops, $2.40. a. Use the given information to determine the price for…arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,