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 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 addtional units at a $60 per unit premium cost Subcontracting capacity is limited to 500 units per month (Entor all responses as whole numbers) Ending Subcontract Month 1 July 2 August 3 September Demand 1200 Production Inventory 1,200 (Units) 1300 1,200 1200 1,200 4. October 1700 1,200 5 November 6 December 1650 1,200 1400 1,200
Q: Eagle Fabrication has the following aggregate demand requirements and other data for the upcoming…
A: Given Information: Step 1: Quarter Demand 1 1400 2 1000 3 1500 4…
Q: A large manufacturer of household consumer goods is considering integrating an aggregate planning…
A: Based on the above-given case, the vice-president of the organization can make the following…
Q: For a product of your choice, describe and explain the following A one or two sentence description…
A: The product selected could be an Sports Utility Vehicle (SUV) car . Over the past decade few decades…
Q: Explain why aggregate planning is different when a business does not produce a tangible good
A: Aggregate planning is a technique for forecasting the volume and timing of future demand (3-18…
Q: Lunar Co.Ltd's estimated demand for the next 6 months in 2021 is as follows: Month Demand July…
A: Given, Below is the demand for the six months Month Demand July 1500 August 1700 September…
Q: Demand for walnut fudge ice cream at the Sweet Cream Dairy can be approximated by a…
A: Demand for walnut fudge ice-cream at SCD is a normal distribution with a mean of 21 gallons per…
Q: This company has the following aggregate demand requirements and other data for the upcoming four…
A: Find the Chase Plan below: The required total cost is $ 147800
Q: Given an aggregate demand for eight periods are expected to be 400, 300, 600, 600, 500, 40 500 and…
A: a) The system capacity as per the hiring/firing strategy is as follows:
Q: The S&OP team at Ka nsas Furniture has received thefo llowing estimates of demand requirements:…
A: A small introduction about Inventory Management Stock administration alludes to the most common way…
Q: The Bawl Corporation supplies alloy ball bearings to auto manufacturers in Detroit. Because of its…
A:
Q: Montreal Hardware Co. is making a make-or-buy decision. The market feedback shows that the optimal…
A: The decision tree based on given information is as follows:
Q: College Press publishes textbooks for the college market. The demand for college textbooks is high…
A: This is a multiperiod Aggregate planning problem. This problem can be solved in multiple ways, we…
Q: Amber's Fabrication has the following aggregate demand requirements and other data for the upcoming…
A: In chase plan production is always kept more than the demand (thats why it is called as chase as…
Q: Kansas Furniture has received the following demand requirements: Month Demand July…
A: Note: Since there is no capping on subcontracting, the requirements will be fulfilled by…
Q: Montreal Hardware Co. is making a make-or-buy decision. The market feedback shows that the optimal…
A: A decision tree refers to the tree that supports tools or equipment that utilizes a tree-like…
Q: gregate production plan for Bioway using (a) chase demand and (b) a mixed strategy where the current…
A: Below is the solution:-
Q: terprises, Tem Hill, projects the firm's aggregate demand requirements over the next 8 months as…
A: Month Demand Production 0 1 1500 1600 2 1500 1600 3 1700 1600 4 1700 1600 5 2200…
Q: Kaizer Plastics produces a variety of plastic items forpackaging and distribution. One item,…
A: It is given that 20,000 units of a container were produced last year and the selling price was $20,…
Q: Describe the different demand-based options used in aggregate planning and their implications for a…
A: Aggregate Planning - Aggregate planning is the process of developing, analyzing, and maintaining a…
Q: . Eastman Publishing Company is considering publishing a paperback textbook on spreadsheet…
A: Fixed cost of publishing is $160,000 variable cost is $6 per book selling cost is $46 per text.
Q: Is a chase or level strategy more appropriate for aggregate planning in an air conditioning…
A: Chase Planning Strategy : Adjusting capacity according to demand, Will lower workforce for better…
Q: The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements…
A: Given-
Q: GOT7 Soda Pop, Inc., has a new fruits drink. The production planner has assembled the following cost…
A: Since you have posted a question with multiple sub-parts, we will solve first three subparts for…
Q: Period Forecast Cust.Ord.…
A: Master plan scheduling is used to determine what quantity of products must be ordered at what time…
Q: A producer of felt-tip pens has received a forecast of demand of 30,000 pens for the coming month…
A: Demand (D) = 30,000 pens per month Fixed costs (FC) = $25,000 per month Variable costs (VC) = $0.37…
Q: Bits and Pieces uses overtime, inventory, and subcontract-ing to absorb fluctuations in demand. An…
A: Optimal production plan is as determined using Solver as follows:
Q: Problem 7-13 (Algo) Owen Conner works part-time packaging software for a local distribution company…
A: The Breakeven Point is that level of sales at which there is no profit no loss. In other words it is…
Q: Sit-Yuen Foo has produced monthly forecasts of demand for a family of products as shown below. At…
A: Find the Given details below: Month 1 2 3 4 5 6 7 8 9 10 Total Aggregate demand 460 420 390 450…
Q: An investment proposal will have annual fixed costs of $60,000, varial costs of $35 per unit of…
A: Given data , Annual fixed costs = $60000 Variable costs = $35 Revenue = $ 55 i) To determine the…
Q: Dwayne Cole, owner of a F lorida firm that ma nufacturesdisplay cabinets, develops an 8-month…
A: Given that REGULAR TIME COST 1000 OVERTIME COST 1300 SUBCONTRACT COST 1800 INVENTORY…
Q: Draw the PLC chart/diagram and briefly explain each stage by giving an example.
A: The Product Life Cycle is an associate degree approach that allows you to gauge however well a trade…
Q: List the strategic objectives of aggregate planning. Whichone of these is most often addressed by…
A: Aggregate Planning: It is the arranging procedure of creation measure, which assists with arranging…
Q: Discuss what is hybrid aggregate plan and why it's used ?
A: A hybrid aggregate plan is nothing more than a technique that blends level and chase procedures when…
Q: You are the production manager for Annie's Tricky Emporium, in charge of making exploding cigars.…
A: Find the Given details below: Day 1 2 3 4 Total Demand (Unit) 220 150 100 70 540
Q: Suppose that product A has the following parents and components, structure. Parentheses in the…
A: Following is the product tree:
Q: What is the breakeven point? What profit or loss can be anticipated with a demand of 3800 copies?…
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…
Q: Demand for walnut fudge ice cream at the Sweet Cream Dairy can be approximated by a…
A:
Q: The president of Hill Enterprises, Terri Hill, projectsthe firm’s aggregate demand requirements over…
A: Solution The stockout cost for lost sales is $100 per unit and inventory holding cost is $20 per…
Q: An item which can be sold for P63.00 per unit wholesale is being produced with the following cost…
A: The break-even point is the point where the total production cost and total sales revenue of the…
Q: The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements…
A: Average monthly requirement = Net requirement / number of months = 14,400 / 8 = 1800
Q: Is a chase or level strategy more appropriate for aggregate planning in an air conditioning…
A: In chase strategy, the production throughout the year varies with the demand so that there should be…
Q: Montreal Hardware Co. is making a make-or-buy decision. The market feedback shows that the optimal…
A:
Q: Develop a production plan and calculate the annual cost for a firm whose demand forecast is: fall,…
A: The factor rating method involves all qualitative and quantitative inputs, and it evaluates…
Q: a) What is the economic quantity for Ben to order? b) At what inventory level should he place an…
A: Annual Demand (D) = 5000Cost = $ 3Ordering cost (O) = $ 10Holding Cost (H) = 20% of Cost = $…
Q: Ram Roy’s firm has developed the following supply, demand, cost, and inventory data. Allocate…
A: Given information Period Regular Time Overtime Subcontract Demand Forecast 1 30 10 5 40…
Q: Stapleton Manufacturing intends to increase capacity through the addition of new equipment. Two…
A: GIVEN THAT FIXED COST OF PROPOSAL A= 55000 FIXED COST OF PROPOSAL B = 33000 VARIABLE COST OF…
Q: Siemens, a German multinational conglomerate and a focused technology corporation headquartered in…
A: Given, Production capacity = 400 motors / month Variable costs = P 500 Selling price = P 775 Fixed…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- The S&OP team at Ka nsas Furniture has received thefo llowing estimates of demand requirements: a) Assuming one-time stockout costs for lost sales of $ 100 perunit, inventory carrying costs of $25 per unit per month, andzero beginning and ending inventory, evaluate these two planson an incremental cost basis:• Plan A: Produce at a steady rate (equal to minimum requirements)of I ,000 units per month and subcontract additionalunits at a $60 per unit premium cost.• Plan B: Vary the workforce, to produce the prior month'sdemand. The fi rm produced I ,300 units in June. The cost ofhiring additional workers is $3,000 per 100 units produced.The cost of layoffs is $6,000 per l 00 units cut back.Nore: Both hiring and layoff costs are incurred in the month of thechange, (i.e., going from production of I ,300 in July to 1,000 inAugust requires a layofT [and related costs] of 300 units in August,j ust as…1. David Villa Manufacturing has the following demand aggregate requirements And other data for the next four periods: Quarter Forecast 1 1400 2 1200 3 1600 4 1500 COSTS/OTHER DATA Previous quarter’s output = 1,300 cases Beginning inventory = 0 cases Stock out cost = $50 per case Inventory holding cost = $10 per case at end of quarter Hiring employees = $40 per case Terminating employees = $80 per case Subcontracting cost = $60 per case Unit cost on regular time = $30 per case Overtime cost = $15 extra per case Capacity on regular time = 1,800 cases per quarter The three initial options he wants to evaluate are: Plan A: a strategy that hires and fires personnel as necessary to meet the forecast. Plan B: a level strategy. Plan C: a level strategy that produces 1,350 cases per quarter and meets the forecast demand with inventory and subcontracting. Which strategy is the lowest-cost plan? If you are…1. Osprey Machine Works has the following demand requirements and other data for the upcoming four quarters. Quarter 1 2 Previous quarter's output 2500 units Beginning inventory Stockout (backorder) cost $50 per unit Inventory holding cost Hiring workers Laying off workers What is the total cost of pursuing a level aggregate plan over the coming year? Demand 2300 2400 2600 2100 200 units 13 14 $10 per unit at end of quarter $4 per unit $8 per unit 2. Golden Eagle Machine Works has the following demand requirements and other data for th upcoming four quarters. Previous quarter's output 2500 units Beginning inventory Stockout (backorder) cost $50 per unit Inventory holding cost Hiring workers Laying off workers What is the total cost of pursuing a chase aggregate plan over the coming year? Demand 2300 2400 2600 2100 Quarter 1 200 units $10 per unit at end of quarter $4 per unit S8 per unit
- a) GOT7 Soda Pop, Inc., has a new fruits drink. The production planner has assembled the following cost data and demand forecast as follow: [GOT7 Soda Pop, Inc., mempunyai minuman buah-buahan yang baru, Perancang pengeluaran telah mengumpul data tentang kos dan ramalan permintaan seperti berikut:] Quarter Demand 1,800 First Second 1,200 Third 1,600 Fourth 1,300 Table 1: Cost and demand forecast [Jadual 1: Kos dan ramalan permintaan] Previous quater's output 1,300 cases Beginning inventory 0 cases Stockout cost Inventory holding cost Hiring employees Terminating employees Subcontracting cost Unit cost on regular time Overtime cost RM150 RM40 per case at the end of quater RM40 per case RM80 per case RM60 per case RM30 per case RM15 extra per case You as the production planner need to develop an aggregate planning. You are required to: [Anda sebagai perancang pengeluaran perlu membangunkan perancangan agregat Anda dikehendaki untuk:] i) Assess plan A: strategy that hires and fires…Hotel Galway is a 50 room Boutique hotel in a pop-ular city break destination in Ireland. Until recently the hotel has priced each room at $120 for bed and breakfast. On aver-age 40 rooms are occupied every weekend. The variable cost of each occupied room is $30. Following an internal review man-agement has decided to try a revenue management approach, with rooms priced at $90 for bookings up to one week early and $180 for bookings within a week of their stay. It is esti-mated the hotel will sell 28 rooms at the lower price and 14 at the higher price. Variable costs will not change. Recommendwhich approach is the most feasible.Southeast Soda Pop, Inc., has a new fruit drink for which it has high hopes. John Mittenthal, the production planner, has assembled the following cost data and demand forecast: demand forecast. Quarter Forecast 1 1,900 2 1,200 3 1,600 4 800 Costs/Other Data Previous quarter's output=1,200 cases Beginning inventory=0 cases Stockout cost of backorders=$160 per case Inventory holding cost=$40 per case at end of quarter Hiring employees=$35 per case Terminating employees=$80 per case Subcontracting cost=$65 per case Unit cost on regular time=$30 per case Overtime cost=$20 extra per case Capacity on regular time=1,900 cases per quarter John's job is to develop an aggregate plan. The three initial options he wants to evaluate are: • Plan A: a strategy that hires and fires personnel as necessary to meet the forecast. • Plan B: a level strategy. • Plan C: a level strategy that…
- A B с D E F G H J 1234567 FCB Inc. has the following aggregate demand requirements and other data for the upcoming four quarters: Production Data (in units) Previous quarter's output 6 Beginning inventory 8 Cost Data (per unit) Stockout cost 1500 0 9 10 Inventory holding cost (at the end of the quarter) $ 11 Hiring workers 12 Firing workers $ 13 Unit cost 14 15 Overtime $ sssss es ese $ 50.00 10.00 $ 40.00 80.00 $ 30.00 15.00 16 Quarter Demand 17 18 19 20 21 31 222222 23456782033 29 1 2 3 4 1,400 1,200 1,500 1,300 Time period Demand Regular Overtime Production Production Ending Inventory Available inventory Lost sale Backorder/ Change in production/workers Increase in produciton (Hire Previous Plan Q1 Q2 Q3 Q4 Total: Cost: Total cost of plan:Please provide answers to subparts d to J: Company B is a retailer of mobile phones in Australia that works 250 days in a year. The manager is determining a minimum-cost inventory plan for an upcoming phone to be launched in the market. She has collected the following information: • Annual demand: 1000 phones • Phone cost: $1,214 each • Phone RRP: $1,349 each • Net weight: 163 g each • Tare weight: 277 g each • Annual inventory holding cost: 15% • Cost per order to replenish inventory: $75 • Annual in-transit holding cost: 10% • Freight rate: $8.10 per kg • Time to process order for freight: 1 days • Freight transit time: 3 days Solve this problem using a non-linear programming (NLP) model to determine the followings: d. The total cost for holding the inventory e. The total cost for transportation f. The total cost for holding the phones during transit g. The total cost for this inventory plan h. The number of orders i. Ordering point j. The profit from this inventory planCyberphone, a manufacturer of cell phone accessories,ended the current year with annual sales (at cost) of $48 mil-lion. During the year, the inventory of accessories turned oversix times. For the next year, Cyberphone plans to increase an-nual sales (at cost) by 25 percent.a. What is the increase in the average aggregate inventoryvalue required if Cyberphone maintains the same inven-tory turnover during the next year?b. What change in inventory turns must Cyberphone achieveif, through better supply chain management, it wants tosupport next year’s sales with no increase in the averageaggregate inventory value?
- Sapphire Aerospace operates 52 weeks per year, and its costof goods sold last year was $6,500,000. The firm carries eightitems in inventory: four raw materials, two work-in-processitems, and two finished goods. Table 12.3 shows last year’saverage inventory levels for these items, along with their unitvalues.a. What is the average aggregate inventory value?b. How many weeks of supply does the firm have?c. What was the inventory turnover last year?2. Demand for Quiggly Pops (QP) follows an up and down pattern over the four quarters of a year, with peaks in the spring and winter months when special promotions are held. Production is handled by a highly-skilled local workforce during a regular 40-hour week (i.e., overtime and subcontracting are not used). The company likes to zero out its inventory at the end of a year so that it can start fresh each January. QP currently uses a level production strategy, but would like to evaluate other options. Create a production plan and calculate the cost of the plan for each strategy listed below. Which plan would you recommend to QP? (a) Level production (b) Chase demand Quarter Demand Forecast 1 70,000 2 100,000 3 50,000 4 150,000 Beginning workforce 40 workers Production rate per worker 1250 units/quarter Regular production cost $10 per unit Hiring cost $500 per worker Firing cost $500 per worker Holding cost $1 per unit per quarterThe current data for five trees that will be analyzed in the exercise are shown in the following table Expected Yearly Demand Quantity For Sale In-Field Quantity 440 74 Trees Christmas Palm Washingtonia Gumbo Limbo Yellow Poinciana Weeping Podo 81 165 159 49 185 Trees Christmas Palm Washingtonia Std Dev 31 155 35 32 68 Gumbo Limbo Yellow Poinciana The "expected yearly demand" is an estimate of the demand over the next year for the tree. The "std dev" is the standard deviation, a measure of the error, that corresponds to the forecast. For-sale and in-field quantities are given, and finally the total number of trees planted on the farm. The demand forecast and quantities are updated on an ongoing basis as trees are sold and planted on the farm. 374 70 42 290 Your first task is to evaluate the inventory "position" of each tree. The farm does not keep any backorder information, so the only data you have is "for-sale" and "in-field" quantities. Think about "for-sale" as on-hand trees, and…