MZ Entertainment has been using this equation, which was developed by regressing inventories on sales over the past 5 years, to forecast inventory requirements: Inventories = P25M + 0.125(Sales). The company expects sales of P355 million during the current year, and it expects sales to grow by 20% next year. What is the inventory forecast for next year?

MZ Entertainment has been using this equation, which was developed by regressing inventories on sales over the past 5 years, to forecast inventory requirements: Inventories = P25M + 0.125(Sales). The company expects sales of P355 million during the current year, and it expects sales to grow by 20% next year. What is the inventory forecast for next year?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
Q2: A company has seasonal demand, with the forecast for the next 12 months as given below. The current labor force can produce 500 units per month. Each employee can produce 20 units per month, and is paid $2,000 per month. The inventory carrying cost is $50 per unit per period. It costs $100 to hire or layoff an employee. Assume 200 units of initial inventory and we would like to keep the similar level at the end of the year. Month 1 3 4 7 8 9 10 11 12 Demand 660 700 840 700 660 500 600 840 80 900 700 600 Please use level and chase strategy to calculate the total cost of two plans (please show your work).
Demand for stereo headphones and music 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 this year was as follows: MONTH DEMAND (UNITS) January 4,150 February 4,250 March 3,950 April 4,350 May 4,950 June 4,650 July 5,250 August 4,850 September 5,350 October 5,650 November 6,250 December 5,950 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.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this…
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
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 · = = >
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 YEARS AGO UNITS 4,815 3.515 4,315 3,015 I || III IV || III IV Period I LAST YEAR I III IV UNITS Forecast (Units) 3,510 2,715 3,515 2,415 THIS YEAR I || III 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.) UNITS 3,215 2,116 2,695 1,695
Table 1. Demand of Hairdryer from January to July [Jadual 1. Permintaan Pengering Rambut dari Januari 2021 hingga Julai 2021] Month Demand January February 2800 2870 March 2968 April Мay 3000 3100 Jun 3150 July 3400 a) Calculate forecast future demand for May, June, July and August by using 3 months simple moving average.[hitung ramalan permintaan masa depan untuk bulan Mei, Jun, Julai dan Ogos dengan menggunakan purata bergerak sederhana 3 bulan.] *
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,120 February 4,220 March 3,920 April 4,320 May 4,920 June 4,620 July 5,220 August 4,820 September 5,320 October 5,620 November 6,220 December 5,920 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 3 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…
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.)
A method of estimating future demand usedfor decision making in order to set reasonable targets and control orlimit uncertainties or risks.
In past 4 weeks, AOC (Arab oil company) started producing and distributing national engine oil to substitute French Total and Esso brands. Production reported to be in thousands: 2, 4, 3, 5 TG Thousand Gallons). AOC production will be calculated after 5 more weeks.