A firm wants to determine its production rate over the next twelve months. expected demand for its product is 30, 80, 90, 75, 80, 100, 95, 75, 200, 125, 130, 120 units for months 1 through 12 respectively. The product is perishable and thus cannot be stored from month to month. The loss per unit not sold is $8, and the penalty per unit short is $15. Because of the nature of the production process, the difference between production levels of two successive months cannot be more than 20. That is, if produce 50 in month 4, the production in month 5 can be between 30 and 70. Formulate this problem and solve to determine the optimal production schedule.
Q: A component used in a manufacturing facility is ordered from an outside supplier. Estimated demand…
A: Part period balancing PPB is a dynamic lot-size calculation technique that computes the production…
Q: An ad campaign for a new snack chip will be conducted in a limited geographical area and can use TV…
A: Given data is Medium Cost Reached Quality TV 500 10000 30 Radio 200 3000 40 Newspaper 400…
Q: Tyler is hoping to get a lot of custom cake and cookie orders in his new bakery for various parties…
A: The optimum order is known as the economic order quantity (EOQ). It is a company's optimal order…
Q: nformation on a business is given below. Variable Expenses: Raw material expense: 250 TL / piece…
A: Answer: a. Sum total of variable expense or variable cost: 250+150+100+75+125 = 700 TL and sum total…
Q: 2. Every evening, Empire News needs to determine how many copies of the newspaper to pur- chase for…
A: Given data, Number of newspapers 160 170 175 185 200 205 210 220 Probability…
Q: Marketing research has found that at a price of $179.95 per unit, sales would be 175,000 ui week. If…
A: Let Price be P The number of units produced and sold per week be x
Q: A retired couple supplement their income by making fruit pies, which they sell to a local grocery…
A:
Q: onomic Order Quantity Q* balloons anual Inventory Holding Cost dollars anual Ordering Cost O dollars…
A: We are allowed to do first three sub-parts only. The answer is as below:
Q: The company produces two types of valves, each valve of the first type needs twice the time it takes…
A: Let the company (x) value of type-1 and (y) numbers value of the second type.
Q: A large sporting goods store is placing an order for bicycles with its supplier. Four models can…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: A manufacturer of kitchen appliances is preparing to set the price on a new blender. Demand is…
A: Revenue is the income generated from selling the products, while profit is the income generated…
Q: A manufacturer of two products (Widgets and Gadgets) makes a profit of $180 for each widget sold and…
A: Profit for each Widgets=$180 Profit for each gadget =$180 Waste charges of Widgets=3w2 (Where w is…
Q: A firm is considering importing some products to sell in a local market. The unit price and cost for…
A:
Q: A retired couple supplement their income by making fruit pies, which they sell to a local grocery…
A: Maximize: 1.50A + 1.20G Subject to: Sugar: 1.5A + 2.0G£ 1,200 cups Flour: 3.0A + 3.0G£ 2,100 cups…
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: Manufacturer firm manufactures two product(X,Y ). Each kg of X requires 5 kWh of electricity and…
A: First, I would define the decision variables for the above question, here, let me define that total…
Q: A large sporting goods store is placing an order for bicycles with its supplier. Four models can be…
A: Linear programming or LP is one of the most simplistic methods to achieve optimization. It assists…
Q: Ringer Foods produces specialty soup sold in jars. The projected sales in dollars Ringer anticipates…
A: Given that: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Units Needed in sales 153500 180000…
Q: 1-18 Katherine D'Ann is planning to finance her college education by selling programs at the…
A: Given- Selling Price =$5Fixed cost =$400Variable cost =$3Fee =$1000
Q: 5) period. MARR is 10% per year compounded annually. Maintenance costs for a bridge are cyclic with…
A: Present worth of…
Q: A company produces a single product. Variable production costs are $14.00 per unit and variable…
A: Given Information: Variable production cost = $ 14 per unit Variable selling and administrative…
Q: Show & Sell can advertise its products on local radio and television (TV). The advertising budget is…
A: the advertising budget is limited to $10,000 a month. Each minute of radio advertising costs $15…
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: Each rented car makes a $100 profit per day and each unrented car makes a loss of $30 per day. It is…
A:
Q: Cox Electric makes electronic components and has estimated the following for a new design of one of…
A: Find the Given details below: Given Details: Fixed Cost 12750 $ Material Cost 0.16 $/Unit…
Q: Kilgore’s Deli is a small delicatessen located near a major university. Kilgore’s does a large…
A: Note: I have answered for part (a) and (b). Kindly post the remaining sub-parts separately
Q: A major oil company is considering the optimal timing for the construction of new refineries. From…
A:
Q: Assume the demand for a company’s drug Wozac during the current year is 50,000, and assume demand…
A: A pharmaceutical company wants to build a facility that will accommodate production at maximum…
Q: A jeweler and her apprentice make silver pins and necklaces by hand. Each week they have 80 hours of…
A: Summary-
Q: A company manufactures dog leashes that sell for $18.64, including shipping and handling. The…
A: Given, Total revenue = $18.64*Q Fixed cost = $24,131 Total variable cost = 9.18*Q Total cost =…
Q: A store manager estimates that the minimum number of cars needed over the next 3 weeks are 5, 8 and…
A: Dynamic Programming is an approach for solving multi-stage decision problems. When an optimization…
Q: What is the optimized net cost? $ b. Use SolverTable to see what happens to the decision…
A: SOLUTION IS AS BELOW:
Q: Based on Zangwill (1992). Murray Manufacturingruns a day shift and a night shift. Regardless of…
A: Given information, cost = 8000 Night shift = 45000 Demand Day 1 - 2000 Night 1 = 3000 Day 2 =…
Q: Do you think it is possible to depict this production function with an isoquant? Justify your answer…
A: Since you have asked multiple question, we will solve the first question for you. If you want any…
Q: 1. At the beginning of each semester, BOOKY can order 60, 80, or 100 copies of the book from the…
A: In the decision analysis, uncertainty is considered an important factor. The payoff table needs to…
Q: A retired couple supplement their income by making fruit pies, which they sell to a local grocery…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: A firm is considering importing some products to sell in a local market. The unit price and cost for…
A:
Q: he Wilcox Manufacturing Company produces an item that is subject to wide seasonal fluctuations in…
A: Linear programming model This is the model used by the firms to determine a level of activity,…
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: company operates a farm on which sheep are raised. The farm manager has determined that for the…
A:
Q: Software EG, a retail company, orders two kinds of software from TeleHard Software. Annually,…
A: Product 1: Annual Demand = D = 800 Purchasing Cost = $30 per unit Holding Cost = H = $5 per unit per…
Q: A total of 160 hours of labor are available each week at$15/hour. Additional labor can be purchased…
A: 160 hours of labor are available for each week at $15 per hour Additional Labor can be purchased at…
Q: Answer the following true or false.a. The lead time is always less than the cycle time.b. The…
A: Note:- We are authorized to answer one question at a time, since you have not mentioned which…
Q: Kilgore’s Deli is a small delicatessen located near a major university. Kilgore’s does a large…
A: Given Information:
Q: A company estimates the demand for its products for the next three periods as follows. The first…
A: Given data: The first period is 20 units, The second period is 10 units period 1—$13 period 2— $14…
Q: The management of the Book Warehouse Company wishes to apply the Miller-Orr model to manage its cash…
A: The question is related to Miller-Orr model of cash management. This model allows lower and upper…
Q: you are thinking of opening a small copy shop. It costs $5000 to rent a copier for a year, and it…
A: It is given that; the cost per copy is $0.03, variable cost (VC) = $0.03. Selling price per copy is…
Q: A jeweler and her apprentice make silver pins and necklaces by hand. Each week they have 80 hours of…
A:
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 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?
- 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?If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
- A company needs to schedule the monthly production of a certain item for the next 4 months. The unit production cost is estimated to be $12 for the first 2 months and $14 for the last two months. The monthly demands are 750, 1000, 850 and 950 units. The company can increase the monthly production during the second and third months by utilizing overtime. The increase in production by this measure is limited to 400 units per month, and costs an extra $4 per unit. The regular production capacity is 1000 units/month. Excess production can be stored at a cost of $3 per unit per month, but a maximum of 50 units can be stored in any month. Assuming that the beginning and ending inventory levels are zero, formulate this problems as an LP model so that the total cost s minimized.The operations manager of a mail order house purchases double (D) and twin (T) beds for resale. Each double bed costs $500 and requires 100 cubic feet of storage space. Each twin bed costs $300 and requires 90 cubic feet of storage space. The manager has $75,000 to invest in beds this week, and her warehouse has 18,000 cubic feet available for storage. Profit for each double bed is $300 and for each twin bed is $150. The manager’s goal is to maximize profits.What is the weekly profit when ordering the optimal amounts?The operations manager of a mail order house purchases double (D) and twin (T) beds for resale. Each double bed costs $500 and requires 100 cubic feet of storage space. Each twin bed costs $300 and requires 90 cubic feet of storage space. The manager has $75,000 to invest in beds this week, and her warehouse has 18,000 cubic feet available for storage. Profit for each double bed is $300 and for each twin bed is $150. The manager’s goal is to maximize profits.What is the weekly profit when ordering the optimal amounts? Multiple Choice $54,000 $0 $42,000 $45,000 $30,000