ABсDEFGHJ1234567FCB Inc. has the following aggregate demand requirements and other data for the upcoming four quarters:Production Data (in units)Previous quarter's output6 Beginning inventory8 Cost Data (per unit)Stockout cost15000910 Inventory holding cost (at the end of the quarter)$11 Hiring workers12 Firing workers$13 Unit cost1415Overtime$sssss es ese$50.0010.00$40.0080.00$30.0015.0016 Quarter Demand171819202131222222234567820332912341,4001,2001,5001,300Time periodDemandRegularOvertimeProductionProductionEndingInventoryAvailableinventory Lost saleBackorder/Change inproduction/workersIncrease inproduciton (HirePrevious PlanQ1Q2Q3Q4Total:Cost:Total cost of plan:

Answered: FCB Inc. has the following aggregate…

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

Over the past 12 months, Super Toy Mart has experienced a demand variance of 10,250 units and has produced an order variance of 12,050 units. Part 2 a) The bullwhip measure for Super Toy Mart is ______ (round your response to two decimal places). Part 3 b) If Super Toy Mart had made a perfect forecast of demand over the past 12 months and had decided to order 1/12 of that annual demand each month, the bullwhip measure would have been ______ (round your response to the nearest whole number.)
Zeus Computer Chips, Inc., used to have major contracts to produce the Centrino-type chips. The market has been declining during the past three years because of the dual-core chips, which it cannot produce, so Zeus has the unpleasant task of forecasting next year. The task is unpleasant because the firm has not been able to find replacement chips for its production lines. Here is demand over the past 12 quarters: TWO LAST THIS YEARS AGO UNITS YEAR UNITS YEAR UNITS 4,805 3,505 4,305 3,005 3,505 2,705 3,490 2,405 3,195 2,105 2,705 1,705 II II II II IV IV IV Use the decomposition technique to forecast demand for the next four quarters. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Period Forecast (Units) II II IV · = = >
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January 4,240 February 4,340 March 4,040 April 4,440 May 5,040 June 4,740 July 5,340 August 4,940 September 5,440 October 5,740 November 6,335 December 6,030 a. Using linear regression analysis, what would you estimate demand to be for each month next year? (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 4 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? (Do not round intermediate calculations. Round…
Zeus Computer Chips, Inc., used to have major contracts to produce the Centrino-type chips. The market has been declining during the past three years because of the dual-core chips, which it cannot produce, so Zeus has the unpleasant task of forecasting next year. The task is unpleasant because the firm has not been able to find replacement chips for its production lines. Here is demand over the past 12 quarters: LAST THIS YEAR TWO YEARS AGO UNITS YEAR UNITS UNITS 4,785 3,495 2,696 3,475 3,210 2,078 2,705 1,695 I I I II 3,475 4,195 II II III III III IV 2,995 IV 2,375 IV Use the decomposition technique to forecast demand for the next four quarters. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Period Forecast (Units I II III IV
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January 4,220 February 4,320 March 4,020 April 4,420 May 5,020 June 4,720 July 5,320 August 4,920 September 5,420 October 5,720 November 6,320 December 6,020 Using linear regression analysis, what would you estimate demand to be for each month next year? (Round two decimal places) To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units…
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January February 4,100 4,200 March 3,900 April 4,300 May 4,900 June 4,600 July 5,200 August 4,800 September 5,300 October 5,600 November 6,200 December 5,900
11. Provide an example for each type of approach to demand analysis.
Using the actual demand shown in the table below, and a 3-month weighted moving average with weights 0.1, 0.4, 0.5 (the heaviest weight applied to the most recent period). Find the demand for May. Nov - 39 Dec - 36 Jan - 40 Feb - 38 Mar - 48 Apr - 46
Over the past 12 months, Super Toy Mart hasexperienced a demand variance of 10,000 units and has produced an order variance of 12,000 units.a) What is the bullwhip measure for Super Toy Mart?b) If Super Toy Mart had made a perfect forecast of demandover the past 12 months and had decided to order 1/12 ofthat annual demand each month, what would its bullwhipmeasure have been?
Supply/Demand Info Predicted Sales Regular production Overtime production Subcontract production Ending inventory Hired employees Fired employees Total employees Cost variables are as follows: Cost Variables Labor cost/hour Overtime cost/ton Subcontracting costiton Holding cost ton/month Hiring cost employee Firing cost/employee Beginning Apr May 4,200 531 $20 $32 $25 $10 $3.700 $4.000 Jun 51,500 50.300 61,600 Here is some additional relevant (capacity) information: Capacity Information Total labor hours/ton Regular production tons/employee/month Max regular production (tons/month) Max overtime production (tons/month) Max subcontractor production (tons/month) 3 100 56,700 3,700 6,000 Jul Aug Sep 45,400 56.600 62,800 Given the above information (and don't overlook beginning number of employees and inventory levels in the first table), create a LEVEL production plan with only the use of regular production and no inventory left over at the end of the six-month period. What is the regular…
Black Instrument Company replenishes highly specialized replacement (service) parts based on statistical reorder point. One part is a 40-mm thumbscrew. Relevant data for the thumbscrew are: Planned stock out frequency= Six per year. Planned lead time = 2 weeks Forecast for next week= 300 Batch size = 400 Standard deviation of demand = 20 (per week) What is the reorder point? What would be the effect on the ROP if lead time were five weeks instead of two? What other factors might impact your decision on when to reorder parts?
ABC analysis on the following set of products Item Annual Demand Unit CostA 211 800 R9B 390 100 R90C 003 450 R6D 100 400 R100E 707 85 R2,000F 660 250 R320G 473 500 R75H 921 100 R75 Soft goods department sells 175 units per month of a certain large bath towel. The unit cost of a towel to the manufacturer is R2.50 and the cost of placing an order has been estimated to be R12.00. There is an inventory carrying charge of 27% of the unit cost per year. What is the optimal order quantity, the order frequency, and the annual holding and setup cost. If the ordering cost can be cut to R4.00, what will be the new economicorder quantity, the order frequency, and annual holding and setup costs.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS