The XYZ Firm has 56 units of SKU001 available in inventory right now. The forecast of demand for SKU001 is 20 units per week for the next 4 weeks. If XYZ Firm plans to produce 100 units of SKU001 this week, how much of SKU001 will be left in inventory at XYZ Firm by the end of this week?

The XYZ Firm has 56 units of SKU001 available in inventory right now. The forecast of demand for SKU001 is 20 units per week for the next 4 weeks. If XYZ Firm plans to produce 100 units of SKU001 this week, how much of SKU001 will be left in inventory at XYZ Firm by the end of this week?

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

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
Using labelled scatter diagrams, explore the relationship between Quarter 1 projected revenue and that of Quarters 2, 3 and 4, pointing out any differences between them.
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 quarter
Calculate available-to-promise quantities.
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,000 February 4,100 March 3,800 April 4,200 May 4,850 June 4,500 July 5,150 August 4,750 September 5,250 October 5,550 November 6,150 December 5,850 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.7. (picture below)(Do not round intermediate calculations. Round your answers to 2 decimal places.) Month Forecast january february march april may june july august september october november december
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…
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,000 February 4,100 March 3,800 April 4,200 May 4,850 June 4,500 July 5,150 August 4,750 September 5,250 October 5,550 November 6,150 December 5,850 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.7. (picture below)(Do not round intermediate calculations. Round your answers to 2 decimal places.) Month Forecast january february march april may june july august september october november december b. To…
Bhatti Company produces plastic photo frames. Two departments, molding and finishing, are involved in the manufacturing. The molding department fills the molds with hot liquid plastic that is left to cool and then opens them. The finishing department removes the plastic frame from the mold and strips the edges of the frames of extra plastic. The following information is available for the month of January: January 1 Quantity (pounds) January 31 Quantity (pounds) Work-in-Process Inventory Cost Cost Molding department Finishing department None None 5,000 $ 15,000 2,000 The WIP Inventory in the finishing department is estimated to be 40% complete for conversion both at the beginning and end of January. Costs of production for January follow: Direct Costs of Production Materials Conversion Molding department Finishing department $ 450,000 $ 90,000 80,290 The molding department started 50,000 pounds of product in January. The firm uses the FIFO method of process costing. Required: 1. Prepare…
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…
The Shades Sunglass Company assembles sunglasses from frames, which it makes,and lenses, which it purchases from an outside supplier. The sales department hasprepared the following 6-week forecast for Ebony, a popular model. The sunglassesare assembled in lots of 220, and the opening inventory is 300 pairs. Complete theprojected available balance and the master production schedule.
2) Life Cycle Assessment of Glass. Inventory Analysis Determine, as an example, the second phase (Inventory Analysis) of the Life Cycle Assessment of the glass used for the manufacture of soda bottles.
Subject: Logistic management Q): What are the 2 approaches of BPR for implementation, give example? Q): What are the types & category of inventory management?