Answer questions 5 & 6 based on the following information. A weekly sports magazine publishes a special edition for the World Series. The sales forecast is for the number of copies to be normally distributed with a mean of 800,000 copies and a standard deviation of 60,000 copies. It costs $0.35 to print a copy, and the newsstand price is $1.95. Unsold copies will be scrapped. Your job is to calculate the number of copies that should be printed. First, calculate P(demand

Answer questions 5 & 6 based on the following information. A weekly sports magazine publishes a special edition for the World Series. The sales forecast is for the number of copies to be normally distributed with a mean of 800,000 copies and a standard deviation of 60,000 copies. It costs $0.35 to print a copy, and the newsstand price is $1.95. Unsold copies will be scrapped. Your job is to calculate the number of copies that should be printed. First, calculate P(demand

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

Formulate the situation in matrix form. Be sure to indicate the meaning of your rows and columns. Find the requested quantities using the appropriate matrix arithmetic. A car dealer sells sedans, station wagons, vans, and pickup trucks at sales lots in Oakdale and Roanoke. The "dealer markup" is the difference between the sticker price and the dealer invoice price. The dealer invoice prices at both locations are the same: $15,000 per sedan, $19,000 per wagon, $24,000 per van, and $26,000 per pickup. The sticker prices at the Oakdale lot are $18,900 per sedan, $23,900 per wagon, $28,900 per van, and $28,900 per pickup, while at the Roanoke lot the sticker prices are $17,900 per sedan, $22,900 per wagon, $26,900 per van, and $30,900 per pickup. Represent these prices as a dealer invoice matrix D and a sticker price matrix S. Use these matrices to find the dealer markup matrix M for these vehicles at these sales lots. (Let row 1 represent the dealer in Oakdale and row 2 represent the…
You are the managerial accountant at Infostore, a manufacturer of hard drives. Its reporting year-end is December 31. The chief financial officer is concerned about having enough cash to pay the expected income tax bill because of poor cash flow management. On November 15, the purchasing department purchased excess inventory of raw materials in anticipation of rapid sales growth beginning in January. The chief financial officer tells you to record the purchase of raw materials as an expense in the current year; this would decrease the company’s tax liability by increasing expenses and reducing income. Required In which account should the purchase of raw materials be recorded? How should you respond to this request by the chief financial officer?
The market research team at AdRight is assigned the task to identify the profile of the typical customer for each treadmill product offered by CardioGood Fitness. The market research team decides to investigate whether there are differences across the product lines with respect to customer characteristics. The team decides to collect data on individuals who purchased a treadmill at a CardioGoodFitness retail store during the prior three months. The data are stored in the "Data" worksheet. CardioGood Fitness is a developer of cardiovascular exercise equipment. Its product line includes these treadmill models and prices: · TM195: $1500 · TM498: $1750 · TM798: $2500 CardioGood Fitness has a goal to increase sales of treadmills. They have hired your company as advertising consultants to identify the target markets that are most likely to buy more treadmills. Once these markets are identified targeted advertising will be used to generate product interest and increase consumer…
Watch Entice sells high end watches. The annual demand for the company’s product is 57,000 units.Ordering costs are $500 per order and carrying costs are $90 per unit, including $40 in the opportunitycost of holding inventory. It currently takes 2 weeks to supply an order to the store. The following tableshows the probability distribution of various demand levels during the 2-week purchase-order lead time:Total Demand Probability of Demand800 0.05900 0.21,000 0.51,100 0.21,200 0.05 Watch Entice does not hold any safety stock. If the company runs of stock, it has to rush order thecomputers at an additional cost of $10 per computer. What is the stock out cost?A. $21,600B. $14,400C. $7,200D. $17,400
Consider a two-tier supply chain with one manufacturer and one retailer whointeract in a single selling season. The manufacturer sells a product to the retailer, who in turn sells in the market. Demand E is uncertain with cumulative distribution function F (·)and probability density function f (·). Since the production lead time is much longer thanthe selling season, the retailer must place a single order before demand is realized and cannotreplenish her inventory during the season. The retailer sells the product at an exogenousand fixed retail price r. The manufacturer produces the product at a unit cost of c. Themanufacturer uses a linear sales rebate contract and determines the following contract terms:For each unit ordered, he charges the retailer a wholesale price w, and for each unit sold, hepays the retailer a rebate s. Assume that the product has zero salvage value at the end ofthe season, and the inventory holding cost during the season is…
Discuss and explain 4 challenges a salesperson may encounter when prospecting for new customers. Describe how you will resolve the following scenario: You are a Salesperson for a local ticket company, and you have been given the task of selling seasonal tickets for upcoming games in your hometown. A middle-aged married couple has expressed interest in buying 2 tickets for a football game. However, they are concerned that they may be out of town on some weekends when there are home games and they do not want their tickets to go to waste. Based on your understanding of prospecting and qualifying, what solutions would you offer to the couple in an effort to overcome their objections?
The supplier's unit cost for the product is $10. The product is sold by the supplier to the retailer for $15 per unit. The retailer then sells the product to end consumers for $20 per unit. There is no value for unsold items. Demand for the product in the consumer market follows a Normal distribution with a mean of 3000 and a standard deviation of 1000. The retailer must determine the quantity to order before actual demand is known. a) What is the optimal order amount for the retailer? b) The supplier offers to buy any unsold product at $5. What is the buyer's optimal order quantity? c) What would be the best buyback offer for the supplier? find the optimal buyback price that the supplier should offer to the retailer so that one does not earn less than the wholesale price contract in part a. (d) What would be the optimal order quantity if both companies were owned by the same person?
"Nordlund Boat Company has been repairing, refitting, and building custom boats. for over 60 years in the Pacific Northwest." The company is located in Tacoma, Washington. One of the engine's most critical components is the exhaust manifolds. The company purchases this item from the best manufacturers in the world. TJ is the buyer in charge of managing this item. TJ's purchasing agent currently submits an order release for this item every 4 weeks. The company's annual demand is 400 units (2 units per working day). Nordlund's relatively low volume and quality focus, rather than volume focus, means the company cannot take advantage of quantity discounts. The supplier has agreed to deliver this item within 1 week following an order release. For this reason, Nordlund has never had a shortage of exhaust manifolds. The total time between the release date and date of receipt is 1 week or 5 working days. The accounting has generated the following inventory-related costs. Procurement costs…
Algro Inc. keeps a wide range of parts and materials on hand for use in its production processes. Management has recently had difficulty managing parts inventory as demand for its finished goods has increased; they frequently run out of some critical parts while having an endless supply of others. They would like to classify their parts inventory according to the ABC approach to better control inventory. The following is a list of parts, along with their annual usage and unit value: Item Annual Unit Item Annual Unit Number Usage Cost Number Usage Cost 1 36 $350 2 510 30 3 50 23 4 300 45 5 18 1900 6 500 8 7 710 4 8 80 26 9 344 28 10 67 440 11 510 2 12 682 35 13 1216 95 50 14 10 3 15 820 1 KARAN2222222222 16 60 $610 17 120 20 18 270 15 19 45 50 20 19 3200 21 910 3 12 4750 23 30 2710 24 24 1800 25 870 105 26 244 30 27 750 15 28 45 110 29 46 160 30 165 25 a. Classify the inventory items according to the ABC approach using the dollar value of annual demand. b. Clearly explain why you…
The lease cost for a specialized highway design software package is estimated to be $13,000 for each of years 1, 2, and 3 (future dollars). (a) Calculate the CV amount today (year 0) of each future cost estimate at the inflation rate of 6% per year. (b) Develop a spreadsheet and graph for inflation rates of 3%, 6%, and 8% per year that show the CV today.
Use a single excel file with formulas within answer cells. Show formulas for how to get the answer. The ticketing office at a professional sports venue has noticed that ticket sales seem to fluctuate. The manager wants to introduce the strategy of demand-pricing in order to maximize attendance and therefor revenue. Based on historical sales, manager wonders if there is a connection between winning percentage (in decimal form) of the team and attendance (seats). Attendance (seats) Winning Percentage (decimal form) 78,000 0.6 89,000 0.67 93,000 0.7 59,000 0.5 65,000 0.55 97,000 0.9 86,000 0.6 75,000 0.55 91,000 0.8 61,000 0.52 What is the forecasted attendance if winning percentage is 0.67?
Morgan Stokes, a division 3 collegiate volleyball player, wears a lot of athletic apparel such as shorts, yoga pants, tights, and tops. She loves having the latest styles and colors but likes to save money too. Morgan has discovered that she can purchase the top quality brands such as Nike and Under Armour at Academy Sports + Outdoors. The store is not as large as Dick’s Sporting Goods, but Morgan believes the selection, price point, and level of quality is very competitive. She enjoys purchasing name-brand items at 25% to 30% savings compared to Dick’s Sporting Goods. Which of the following best describes Morgan and her selection of Academy as her preferred store for sports apparel? Morgan Stokes, a division 3 collegiate volleyball player, wears a lot of athletic apparel such as shorts, yoga pants, tights, and tops. She loves having the latest styles and colors but likes to save money too. Morgan has discovered that she can purchase the top quality brands such as Nike and…