Operations planner Bradley is developing a sales and operations plan that involves back orders. The company’s demand and production rates for the next four periods are as follows An operations planner, Lovell Bradley, is developing a sales and operationsplan that involves back orders. The company's demand and production ratesfor the next four periods are as follows.Period Demand Production18,2008,000210,0008,0007,0008,0006,6007,60034Beginning inventory at the start of period 1 is 400 units.a) The company holds a positive level of ending inventory in periods[Select], and this level equals[Select]2 and 43 and 41 and 21 and 31 and 42 and 3in ears in periodsS. An operations planner, Lovell Bradley, is developing a sales and operationsplan that involves back orders. The company's demand and production ratesfor the next four periods are as follows.Period Demand Production18,2008,000210,0008,00037,0008,00046,6007,600Beginning inventory at the start of period 1 is 400 units.a) The company holds a positive level of ending inventory in periods[Select]✓, and this level equals[Select][Select]8002004001800in each of the periods.Cperiodsack orders are

If production plus beginning inventory is greater than the demand of period, then ending inventory will exist. If not, in such a case, backorders will exist. Some company (based on the industry nature) allow backorders while some don’t. If backorders are accepted they act as negative beginning inventory and adds to the demand of next period.

Business

Operations Management

An operations planner, Lovell Bradley, is developing a sales and operations plan that involves back orders. The company's demand and production rates for the next four periods are as follows. Period Demand Production 1 8,200 8,000 2 10,000 8,000 3 7,000 8,000 4 6,600 7,600 Beginning inventory at the start of period 1 is 400 units. a) The company holds a positive level of ending inventory in periods [ Select] 4 ✓, and this level equals [Select] 2 and 4 3 and 4 1 and 2 1 and 3 1 and 4 2 and 3 in ea rs in periods

An operations planner, Lovell Bradley, is developing a sales and operations plan that involves back orders. The company's demand and production rates for the next four periods are as follows. Period Demand Production 1 8,200 8,000 2 10,000 8,000 3 7,000 8,000 4 6,600 7,600 Beginning inventory at the start of period 1 is 400 units. a) The company holds a positive level of ending inventory in periods [ Select] 4 ✓, and this level equals [Select] 2 and 4 3 and 4 1 and 2 1 and 3 1 and 4 2 and 3 in ea rs in periods

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

HERO Corporation is considering three options for managing its data processing operation: continuing with its own staff, hiring an outside vendor to do the managing (referred to as outsourcing), or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of pesos) depends on demand as follows: Demand Demand Demand Staffing Options High Medium Low Own staff 352 325 300 Outsider vendor 450 300 150 Combination 400 325 250 If the decision maker knows nothing about the probabilities of the four states of nature, what is the recommended decision using:i. the optimistic approach and the conservative approach iii. the minimax regret approach iv. the Laplace method
Dineshbhai
Current total inventory level of a company (Ip) is 5,000 units, which are held at 4 different facilities (nE). Next year, the company plans to open 5 new facilities. Provide an estimate on the total future inventory level (IF) for the company. 27 11,250 units 4,472 units 7,500 units 8,944 units 5,590 units
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,200 February 1,600 June 2,300 March 1,600 July 1,700 April 1,900 August 1,300 Her operations manager is considering a new plan, which begins in January with 200 units on hand and ends with zero inventory. Stockout cost of lost sales is $125 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is called plan B. Plan B: Produce at a constant rate of 1,300 units per month, which will meet minimum demands. Then use subcontracting, with additional units at a premium price of $80 per unit. Subcontracting capacity is limited to 1,000 units per month. Evaluate this plan by computing the costs for January through August. Part 2 In order to arrive at the costs, first compute the ending inventory and subcontracting units for each month by…
As part of the answer, you are required to: Determine supply chain's competitive strategy (You can read the sion on textbook about different competitive strategies in some example supply chains) Once you determine competitive strategy than you areed to select a distribution network design (You can select one of the six designs. distribution network design. You are required to select a product family consisting of four products for your distribution network, products(s) should be simple assemblies with a basic bill of material structure. You can choose simple products consisting of only a handful of components. For example a bill of material for Office table is given below, if your part family consists of four parts with each part being a different Office table, for example Part A: Short Office table, Part B: Wide Office Table, Part C: Four Legged Table and Part D: Long Office Table. Bill of Material for Office Table Table Final Assembly Top Assembly (1 required) Support Assembly (1…
ABC company is deciding where to assign its summer intern. The manager estimates that the intern can save $20,000 in the supply chain or increase sales (revenue) by $40,000. If sales (revenue) is divided into the three categories shown in the table, where should the manager assign the intern to maximize profits? Assume that the company has a current sales of $100,000. Sales SC PC Profit Production It doesn't matter where Sales 100% 40% 30% 30% Research and development Supply chain
Marketing system provides some useful insights regarding the sales order. Different departments use this information. For instance, the production process uses this information to forecast the expected sale for next month. The production clerk uses this to create an online production schedule. From this schedule, the system automatically prepares weekly online work orders to be used by the production department.The production supervisor assesses the work orders from his terminal and prepares the necessary paper-based move tickets and materials requisitions. Then, the move tickets and two copies of the materials requisitions are distributed to each work centre. Later, work centre employees submit the two copies of the materials requisitions to the warehouse in exchange for materials and sub-assemblies. If additional new materials are needed beyond the standard quantity, the supervisor issues additional materials requisitions. Work centre employees record their work hours on paper-based…
5. Formulate a level sales and operations plan for a company with the following predicted demand: Month Demand 6,300 2 9,000 3 6,000 4 9,000 5 15,000 6 6,000 Total 51,300 The beginning workforce is 125 employees. The monthly output per employee is 150 units. The costs to hire and lay off a worker are $2,500 and $4,000, respectively. The cost to carry an item in inventory for one month is estimated at $10, and the stockout cost is $25 per unit. Show the production schedule, the inventory levels, and the changes in workforce from period to period. Compute the plan's cost.
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: May 2,100 January February 1,450 1,700 1,700 June 2,300 July 1,900 March April 1,700 August 1,300 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $65 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. Evaluate the following plan. This exercise contains only Plan E. Plan E: Keep the current workforce, which is producing 1,600 units per month, and subcontract to meet the rest of the demand. Subcontract cost is $75 per unit. Month 10 December 1 January 2 February 3 March 4 April 5 May 6 June 7 July 8 August Demand 1,450 1,700 1,700 1,700 2,100 2,300 1,900 1,300 Production (Units) 1,600 1,600 1,600 1,600 1,600 1,600 1,600 1,600 Plan E Ending Subcontract (Units) Inventory 200 The total subcontracting cost = $ (Enter your response as…
A line of furniture is made by the Drazal Company in South Carolina and is being considered for outsourcing to China. The unit manufacturing costs in the U.S. are:Unit Cost of Goods SoldDirect labor 53Materials 122Overhead 49Total 224When produced in China, direct labor will be 60 percent of the U.S. cost and overhead will also be 60 percent of the U.S. cost, since it consists mostly of salaries. Materialscosts will be 10 percent lower in China. Transporting the furniture from China will cost $27,000 for seven containersto transport the annual supply of 500 units from the factory in China to the Drazal warehouse in the U.S. by rail, truck, and sea. To ensure quality, it will cost $12,000 per year to mmonitor the supplier and inspect the units in China before they are sent. The cost of administering the contract is $5,000 per year.a. What are the total costs of supplying this product from China?b. What risks are associated with the Chinese supplier?c. Should the product be outsourced to…
Strama, Incorporated, manufactures and sells two products: Product A6 and Product I5. The company has an activity-based costing system with the following activity cost pools, activity measures, and expected activity: Activity Cost Pools Activity Measures Estimated Overhead Cost Expected Activity Product A6 Product I5 Total Labor-related DLHs $ 198,138 8,900 3,500 12,400 Production orders orders 48,124 1,250 1,450 2,700 Order size MHs 190,147 6,300 6,400 12,700 $ 436,409 The activity rate for the Order Size activity cost pool under activity-based costing is closest to:
5 X Month fx B C D E F G H Problem 7 Given the following forecast and cost information, determine the total cost of a chase plan that uses regular time production output of 400 units per month, overtime is used when needed up to a maximum of 40 units per month, and subcontracting is used if additional units are needed to meet the forecast. 1 2 3 45 6 Font Forecast Cover 440 400 450 460 480 490 Totals Problem 6 Accessibility: Investigate √5 Level Production. Production Overtime Problem 7 Alignment Subcontr acting Inventory Total Holding Cost Problem 8 Problem 18 F Number Ty Costs Formatting Table Styles Production Costs. Regular Overtime Subcontracting $ 555 E 50.00 65.00 75.00 Regular Time Overtime Subcontracting Total Cost M