The S&OP team at Kansas Furniture, has received estimates of demand requirements as shown in the table. Assuming one-time stockout costs for lost sales of $100 per unit, inventory carrying costs of $25 per unit per month, and zero beginning and ending inventory, evaluate the following plan on an incremental cost basis: Plan A: Produce at a steady rate (equal to minimum requirements) of 1,200 units per month and subcontract additional units at a $70 per unit premium cost. Subcontracting capacity is limited to 500 units per month. (Enter all responses as whole numbers). Month Ending Subcontract Demand Production Inventory (Units) 1 July 1200 1,200 0 2 August 1300 1,200 0 3 September 1200 1,200 0 4 October 1700 1,200 0 5 November 1650 1,200 0 6 December 1400 1,200 0

The S&OP team at Kansas Furniture, has received estimates of demand requirements as shown in the table. Assuming one-time stockout costs for lost sales of $100 per unit, inventory carrying costs of $25 per unit per month, and zero beginning and ending inventory, evaluate the following plan on an incremental cost basis: Plan A: Produce at a steady rate (equal to minimum requirements) of 1,200 units per month and subcontract additional units at a $70 per unit premium cost. Subcontracting capacity is limited to 500 units per month. (Enter all responses as whole numbers). Month Ending Subcontract Demand Production Inventory (Units) 1 July 1200 1,200 0 2 August 1300 1,200 0 3 September 1200 1,200 0 4 October 1700 1,200 0 5 November 1650 1,200 0 6 December 1400 1,200 0

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

What role does demand variability play in the Wilson Approach, and how can it be managed effectively?
Hau Lee Furniture, Inc., spends 45% of its sales dollars in the supply chain and finds its current profit of $15,000 inadequate. The bank is insisting on an improved profit picture prior to approval of a loan for some new equipment. Hau would like to improve the profit line to $20,000 so he can obtain the bank's approval for the loan. Sales Cost of material Current Situation $100,000 $45,000 (45%) Production costs Fixed cost Profit $25,000 (25%) $15,000 (15%) $15,000 (15%) a) What percentage improvement is needed in the supply chain strategy for profit to improve to $20,000? What is the cost of material with a $20,000 profit? A decrease of ☐ % in material (supply-chain) costs is required to yield a profit of $20,000, for a new material cost of (Enter your response for the percentage decrease to one decimal place and enter your response for the new material cost as a whole number.)
Heather Adams, production manager for a Colorado exercise equipment manufacturer, needs to schedule an order for 50 UltimaSteppers, which are to be shipped in week 9. Subscripts indicate quantity required for each parent. Assumelot-for-lot ordering. c) Develop a net material requirements plan for F (enter your responses as whole numbers). Week Lead Time Item 2 3 4 5 6 7 8 9 (weeks) F Gross req Insert answer insert answer 2 On hand insert answer insert answer Net req insert answer insert answer Order receipt insert answer insert answer Order release insert answer insert answer
Lorie Nursery plans to sell 6,000 potted plants during May, 5, 700 in June, and 6,000 during July. The company keeps 10% of the next month's sales as ending inventory. How many units should Lorie Nursery produce during June?
Wal Mart, although they are not a manufacturing company, uses sophisticated computer software to forecast sales and order products to be stocked in their stores so that they do not run out of the things shoppers are looking for. What kind of software system does Wal Mart likely use? Group of answer choices a) Inventory control b) Just-in-time ordering c) E-procurement d) Materials Requirement Planning (MRP)
Problem 9a: Jones Surgicenter uses 90,000 bags of IV solution annually. The optimal safety stock (which is on hand initially) is 1,000 bags. Each bag costs the center $1.50, inventory carrying costs are 20 percent, and the cost of placing an order with the supplier is $15. Problem 9b: Continuing with the previous question, what is the total inventory cost, TIC? Do not include the dollar sign in your answer.
2. Complete the following grid using the weeks-of-supply method: Plan Sales for a Week $5,000 $8,000 $9,100 $500 $21,000 Annual Turnover 2.0 4.0 8.0 10.0 16.0 Weeks of Supply Inventory
hello, can someone help me to calculate the optimal amount of pipeline (in-transit) inventory with the following information: average customer demand: 100 units, Standard deviation of customer demand: 10 units, supplier lead time: 9 days, desired service level (order fill rate): 98.5%, and z score for 98.5: 2.17? thank you!
The Eagle Machine Company averaged $2 million in inventory last year, and the cost of goods sold was $10 million. Figure 12.5 shows the breakout of raw materials, work-in-process, and finished goods inventories. The best inventory turnover in the company’s industry is six turns per year. If the company has 52 business weeks per year, how many weeks of supply were held in inventory? What was the inventory turnover? What should the company do?
Assume you are the manager of a shop that assembles power tools. You have just received an order for 55 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws follows: Item Lead Time (weeks) On Hand Saw A B C D E F 2 1 2 2 1 1 2 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release Ĉ E(3) & E(2) LT = 1 week Lot size: Lot-for-Lot 15 10 5 65 20 10 30 Skip Extension Tip: Double click to open in new tab Show Transcribed Text Develop the material requirements plan for component E using lot-for-lot ordering for all items. (Leave no cells blank - be certain to enter "0" wherever required.) Components A(2), B(1), C(4) E(3), D(1) D (2), F(3) E(2), D (2) Beg. Inv. 1 2 3 190 5 210 6
LMNO Gaskets has formulated a production plan for a product to meet demand over the upcoming four quarters. Demand in each of the four quarters and production, overtime, and subcontracting capacities are reported in the table below, in addition to the feasible production plan. The relevant costs are: • Regular time production cost is $10/unit. Overtime production cost is $14/unit. Subcontracting cost is $18/unit Inventory is held at a cost of $1/unit/quarter. • Units may be backordered at a cost of $4/unit/quarter. Production Resource Regular Time Q1 Overtime Q1 Subcontract Q1 Regular Time Q2 Overtime Q2 Subcontract Q2 Regular Time Q3 Overtime Q3 Subcontract Q3 Demand in Quarter Demand in Quarter Q2 0 20 0 550 Q1 550 230 0 0 0 0 40 40 0 860 250 470 0 40 0 1330 What is the inventory cost for the year? What is the backorder cost for the year? What is the total cost for the year? Q3 0 0 0 0 0 30 510 160 0 700 What is the total overtime production cost for the year? Capacity 550 250 500…
Hau Lee Fumiture, Inc., spends 45% of its sales dollars in the supply chain and finds its current profit of $24,000 inadequate. The bank is insisting on an improved profit picture prior to approval of a loan for some new equipment. Hau would like to improve the profit line to $29,000 so he can obtain the bank's approval for the loan. Sales Cost of material Production costs Fixed cost Profit Current Situation $80,000 $36,000 (45%) $16,000 (20%) $4,000 (5%) $24,000 (30%) a) What percentage improvement is needed in the supply chain strategy for profit to improve to $29,000? What is the cost of material with a $29,000 profit? A decrease of % in material (supply-chain) costs is required to yield a profit of $29,000, for a new material cost of $ cost as a whole number.) (Enter your response for the percentage decrease to one decimal place and enter your response for the new material