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.

Chapter9: Decision Making Under Uncertainty

Section: Chapter Questions

Problem 46P

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. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
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?
Q: The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below: Material (measured in square inches) Model 1 Model 2 Model 3 Material Available Cardstock 12 10 14 1200 Satin 24 20 15 2000 Plain fabric 40 40 30 7500 Leather 11 11 10 1000 Profit per model $50 $44 $40 a) Generate the Answer Report using SOLVER in EXCEL. Then, clearly answer what is the optimal solution? What is the resulting profit?
Q: The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below: Material (measured in square inches) Model 1 Model 2 Model 3 Material Available Cardstock 12 10 14 1200 Satin 24 20 15 2000 Plain fabric 40 40 30 7500 Leather 11 11 10 1000 Profit per model $50 $44 $40 a) Clearly state the decision variables, objective function and constraints. The objective function and constraints should be written as inequality or equality formulas. b) Generate the Answer Report using SOLVER in EXCEL. Then, clearly answer what is the optimal solution? What is the resulting profit?
Q: The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below: Material (measured in square inches) Model 1 Model 2 Model 3 Material Available Cardstock 12 10 14 1200 Satin 24 20 15 2000 Plain fabric 40 40 30 7500 Leather 11 11 10 1000 Profit per model $50 $44 $40 a) Generate the Sensitivity Report in EXCEL for the model that you built. Interpret, in context, the Shadow Price for the Leather and the Satin constraints. Include units in your interpretations.
Q: The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below: Material (measured in square inches) Model 1 Model 2 Model 3 Material Available Cardstock 12 10 14 1200 Satin 24 20 15 2000 Plain fabric 40 40 30 7500 Leather 11 11 10 1000 Profit per model $50 $44 $40 a) Suppose the feasible region from a set of constraints in a linear programing problem is given in the shaded region of the attached graph. If the objective function is to minimize Cost = 9x + 4y, what would be the optimal solution? What is the resulting minimized cost? SOLVER is not used in this question. Explain your reasoning.
601 Ana Chavarria, front office manager at The Times Hotel, has completed a revenue management semi- nar at Keystone University and is preparing an argu- ment in favor of adopting this concept at The Times Hotel to present to Margaret Chu, the general man- ager. She begins by compiling a history of room occupancy and ADRS, which she hopes will reveal areas in which revenue management could help. She prepares an electronic spreadsheet that lists rooms sold with corresponding room rates and correlates the data to tourism activities in the area. Ana sends an analysis of revenue realized and revenue potential to Ms. Chu for review prior to their discussion After reviewing the analysis, Ms. Chu concludes, "This is just another scam; the industry is slow to adopt this," and disregards the entire report. She knows that occupancy percentage, ADR, and RevPAR are all you need to be efficient today, so why change? Ana passes Ms. Chu in the lobby, and Ms. Chu indicates her distrust of the revenue…
Demand for portable music players for joggers has caused Nancy Industries (Nancy) to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nancy expects demand for music player to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demands for the players for last year was as follows : Month Demand (units) Jan 4200 Feb 4300 Mar 4000 Apr 4400 May 5000 Jun 4700 Jul 5300 Aug 4900 Sep 5400 Oct 5700 Nov 6300 Dec 6000 Question : From the choice of simple moving average, weighted moving average, exponential smoothing, and linear regression analysis, which forecasting technique would you consider the most accurate to Nancy Industries? Why?
2. If the projected or forecasted sales of Malinao Bakery for the month of Januaryis 2100 loaves of bread, beginning inventory 50 loaves and the selling price isP50 per loaves. How much are the projected sales in peso of Malinao Bakeryfor January?A. P100,000. C. P107,500.B. P100,500. D. P105,000.
Knights Ltd Wayne tells you he is planning the 30 June 2021 Audit of Knights Ltd, a company that produces and exports timber products to South East Asian countries. Knights contracts timber cutters to deliver set tonnages of logs to its mill throughout the year. The timber is then transported to Asia on charter vessels, which make an average of one trip a month. Timber is purchased in 50 hectare lots from plantations and state forests. In the past, 75% of timber was sourced from plantations, however this has fallen to 40% in the current year. The corresponding increase in timber sourced from state forests has angered environmental groups. Protests have been held in several forests, which has slowed production and frustrated the contractors, who are only paid once set tonnages of timber are delivered to the mill. These issues have meant that several shipments of timber have been delayed, angering the Japanese customers who are threatening to deduct 20% from amounts owing as compensation…
Question: B) Identify The Economic Order Quanitity And Consider The Implications For Making An Error In Calculating Economic Order Quanitity. This problem has been solved! See the answer b) Identify the economic order quanitity and consider the implications for making an error in calculating economic order quanitity.
Q2 The lower daily needs for workers in a manufacturing organization provided in the below table, each worker works for eight hours, the management needs to determine the lower number of workers to maintain the flow and stability of the work in each shaft. Formulate LP model for this problem and suggest (only suggestion) a method to find the optimal solution Shaft