The production planner of a company forecasts the sales over the next four months as 2000, 1400, 1100, and 800 units, respectively. During a 60-day period when there were 40 workers, the company produced 15000 units. Assume that the numbers of workdays over the four months are 21, 22, 20, and 18, respectively. There are currently 12 workers employed, and there is no beginning inventory. The unit costs are given as follows: Inventory holding cost is 0.40 TL per unit per month; hiring cost is 140 TL per worker, and firing cost is 110 TL per worker. The planner solves the mathematical model of this problem. The optimal solution gives the following results, where W; is the workforce level in period t W2 W3 W4 15.24 10.18 8.80 8.80 By rounding the values of the workforce levels up, what is the total cost (in TL) of the resulting plan? O a 1558 Ob. 1730 Oc. 1166 Od. 1422 O e. 892
Q: Flor’s Flours is small business that produces two types of ready-to-use multigrain flours using…
A: here we have from the above question Given Pounds of wheat used in pancakes me = x11 Pounds of wheat…
Q: Develop a linear programming model to minimize the total dollars needed to be invested now to meet…
A: Excel Solver Model: Add the following solver parameters: Solution:
Q: pronit per table is $120 while the profit per chair is $80. Currently, each week there are 200 hours…
A:
Q: A university has three professors who each teach four courses per year. Each year, four sections of…
A: A Small Introduction about Production Management Production management alludes to the method…
Q: Mondo Motorcycles is determining its production schedule for the next 4 quarters. Demands for…
A: The given problem is an aggregate planning ILP problem.
Q: A company is considering two insurance plans with the following types of coverage and premiums Plan…
A: Given that: Total coverage for fire/theft insurance = $6,36,000 Total coverage for liability…
Q: Dr. Thompson’s sporting goods store is placing an order for scooters with its supplier. Four models…
A: Given data, Scooter are sold = 30,25,22,20 Store space= 500feet Assembly time = 1200 hours…
Q: In the original RedBrand problem (Example 5.4), suppose that the company could add up to 100 tons of…
A: Analyze the case when a company adds 100 tons of extra capacity in increments of 10 tons to any…
Q: Dr. Thompson’s sporting goods store is placing an order for scooters with its supplier. Four models…
A: Given data, Store Space = 500ft Assembly Time = 1200 hours Boys and girls scooter = 4 hours of…
Q: PRODUCT MIX: The JP Manufacturing Company produces two products. Resource requirements for…
A: Decision Variable:Suppose- A be the no. of units produced per week of the product ‘A’ B be the…
Q: 1. Muscat Inc. is working on its cash budget for December. The budgeted beginning cash balance is…
A: [Comment:] Thank you for your questions. Please note per the guidelines, only one multiple-choice…
Q: Leach Distributors packages and distributes industrial supplies. A standard shipment can be packaged…
A: Linear programming problem: Max 6x1 + 10x2 + 8x3 s.t 2x1 + x2 + 3x3 <= 180 2x1 + 6x2 + 4x3 = 240…
Q: The operations manager of a mail order house purchases double (D) and twin (T) beds for resale. Each…
A: The LP modelThe decision variables are the number of double beds (D) and twin beds (T).The…
Q: Dr. Thompson’s sporting goods store is placing an order for scooters with its supplier. Four models…
A: Given data, Scooter sold = 30,25,22,20 Area of store 500 Assembly time = 1200 Boys and girls…
Q: Shoemakers of America forecasts the following demandfor each of the next six months: month 1—5,000…
A:
Q: Shoemakers of America forecasts the following demandfor each of the next six months: month 1—5,000…
A: Gien data, Month1 = 5000 pairs of shoes Month 2 = 6000pair Month 3 = 5000 Time is taken by a…
Q: Maximizing Profit Johnson's Household Products has a division that produces two sizes of bar soap.…
A: The retail price of the 3.5-oz size bar soaps is p $ per 100 The retail price of the 5-oz size bar…
Q: Leach Distributors packages and distributes industrial supplies. A standard shipment can be packaged…
A: Based on the data given, we understand it is a Linear Programming Problem. The decision variables…
Q: The CFO for the Shelton Corporation has $1.2 million to allocate to the following budget requests…
A: Under the given conditions, we have an additional constraint. The constraint is…
Q: Each year, Paynothing Shoes faces demands (whichmust be met on time) for pairs of shoes as shown in…
A: Let, xt be the number of workers hired at the start of the quarter t in which t can be 1, 2, 3, and…
Q: A company produces two types of tables a and be if it takes 2jours of cutting and 4hours of…
A: The problem can be solved by formulating an LPP. This will help in finding the optimal solution to…
Q: A linear programming computer package is needed. The employee credit union at State University is…
A: A = Amount to be allocated to Automobile loan F = Amount to be allocated to Furniture loan O =…
Q: Formulate a linear integer program that generates a feasible production plan to maximize the total…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: During the next four months, a customer requires,respectively, 500, 650, 1000, and 700 units of…
A: Cost is one of the most important elements of any organization. The organization produces goods and…
Q: A company needs to schedule the monthly production of a certain item for the next 4 months. The unit…
A: Given data, Production cost estimated for the first 2 month = $12 For the last 2 month = $14…
Q: A company produces A, B, and C and can sell theseproducts in unlimited quantities at the following…
A: Linear programming is a quantitative or mathematical technique for determining the optimal…
Q: A manufacturing company makes two circuit boards R, and R2, constructed as follows: R1 comprises 3…
A: Given data is Profit by R1 = 5p Profit by R2 = 9p Resistors required by R1 = 3 Capacitors required…
Q: Dr. Thompson’s sporting goods store is placing an order for scooters with its supplier. Four models…
A: Given Information: It is given that store would like to place an order for at least 275 scooters
Q: Write in normal form and solve by the simplex method, assuming x, to be nonnegative. 1. The owner of…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: Rosa is joining a fundraising event next month to help raise awareness about cancer. She contacted…
A: The problem can be solved using linear programming as a maximization problem. The sensitivity report…
Q: The owner of a snack food business wants to create two nut mixes for the holiday season. The regular…
A: Decision variable: Suppose-R be the no. of regular nut mixD be the no. of delux nut mix
Q: If the profit generated per cabinet is P80 and per dresser is P100, write the objecti that best…
A: Linear programming is a process to reach the best outcome such as maximum profit or lowest cost in a…
Q: 1. A biologist is developing two new strains of bacteria. Each sample of Type A bacteria produces…
A: Objective Functions and Constraints: Based on the given details, we found the…
Q: The operations manager of a mail order house purchases double (D) and twin (T) beds for resale. Each…
A: Answer:Introduction:The given problem is solved using linear programming. The given problem is…
Q: gelleratng a IS following function: H(P) = 120 +9.3 P + 0.0025 P² MJ/h This unit has a minimum…
A: Solution - Brief Introduction with Operating Profit and Loss…
Q: A manufacturer can sell product 1 at a profit of $2/unitand product 2 at a profit of $5/unit. Three…
A: An IP (Integer Programming) refers to the set of problems that can be solved using linear…
Q: What is the optimized net cost? $ b. Use SolverTable to see what happens to the decision…
A: SOLUTION IS AS BELOW:
Q: An ad campaign for a new snack chip will be conducted in a limited geographical area and can use TV…
A: Use the minimization function in order to calculate the least total cost.
Q: FORUM Furniture buys two products for resale: big shelves (B) and medium shelves (M). Each big shelf…
A: B = Number of Big shelves M = Number of Medium shelves Objective function: Maximize Z = 360B + 250M…
Q: A company faces the following demands during the next three weeks: week 1, 2000 units; week 2, 1000…
A: Demand: Week 1: 2000 units Week 2: 1000 units Week 3: 1500 units Production cost per unit: Week 1:…
Q: Build an appropriate LP model. Solve the model using the graphical solution method. Develop a…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: An electronics firm has a contract to deliver thefollowing number of radios during the next three…
A: Monthly Requirements are 200, 300 and 300 respectively Variable cost in first two months is 10 and…
Q: A campany wants to plan production for the months of January, February, March and April. The demand…
A: Find the Given details below: Month January February March April Total Demand (Unit) 35000…
Q: Mondo Motorcycles is determining its production schedule for the next 4 quarters. Demands for…
A: Linear programming:Linear programming is a simplistic method where we describe complex relations…
Q: Mondo Motorcycles is determining its production schedule for the next four quarters. Demand for…
A:
Q: A customer requires during the next four months, respectively, 50, 65, 100, and 70 units of a…
A: Summarized data: Month Cost of Production/Unit Demand 1 $5 50 2 $8 65 3 $4 100 4 $7 70…
Q: A company produces three types of items. A singlemachine is used to produce the three items on a…
A:
Q: a. Formulate a linear programming model that can be used to determine the number of gallons of…
A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…
Q: Your corporation has just approved an 8-year expansion plan to grow its market share. The plan…
A: Excel solver formula: Use the following solver parameters. Solution:
Q: Highland’s TV-Radio Store must determine how manyTVs and radios to keep in stock. A TV requires 10…
A: Let ‘a’ be the number of TVs. Let ‘b’ be the number of radios.
Step by step
Solved in 2 steps with 5 images
- 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?
- Another way to derive a demand function is to break the market into segments and identify a low price, a medium price, and a high price. For each of these prices and market segments, we ask company experts to estimate product demand. Then we use Excels trend curve fitting capabilities to fit a quadratic function that represents that segments demand function. Finally, we add the segment demand curves to derive an aggregate demand curve. Try this procedure for pricing a candy bar. Assume the candy bar costs 0.55 to produce. The company plans to charge between 1.10 and 1.50 for this candy bar. Its marketing department estimates the demands shown in the file P07_47.xlsx (in thousands) in the three regions of the country where the candy bar will be sold. What is the profit-maximizing price, assuming that the same price will be charged in all three regions?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?