Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
A manufacturer has a production facility that requires 10,237 units of component JY21 per year.
Following a long-term contract, the manufacturer purchases component JY21 from a supplier with
a lead time of 6 days. The unit purchase cost is $31.4 per unit. The cost to place and process an
order from the supplier is $168 per order. The unit inventory carrying cost per year is 12.2 percent
of the unit purchase cost. The manufacturer operates 250 days a year. Assume EOQ model is
appropriate. If the manufacturer uses a constant order quantity of 1,053 units per order, what is
the annual holding cost?
Use at least 4 decimal places.
(All answers were generated using 1,000 trials and native Excel functionality.) Galaxy Co. sells virtual reality (VR) goggles, particularly targeting customers who like to play video games. Galaxy procures each pair of goggles for $150 from its supplier and sells each pair of goggles for $300. Monthly demand for the VR goggles is a normal random variable with a mean of 160 units and a standard deviation of 40 units. At the beginning of each month, Galaxy orders enough goggles from its supplier to bring the inventory level up to 140 goggles. If the monthly demand is less than 140, Galaxy pays $20 per pair of goggles that remains in inventory at the end of the month. If the monthly demand exceeds 140, Galaxy sells only the 140 pairs of goggles in stock. Galaxy assigns a shortage cost of $40 for each unit of demand that is unsatisfied to represent a loss-of-goodwill among its customers. Management would like to use a simulation model to analyze this situation.
(c) Use the simulation model…
Jankord Jewelers permits the return of their diamond wedding rings, provided the return occurs within two weeks. Typically, 20 percent are returned. If nine rings are sold today, what is the probability that fewer than four will be returned?
A- 0.914
B- 0.962
C- 0.923
D- 0.935
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- (All answers were generated using 1,000 trials and native Excel functionality.) The management of Madeira Computing is considering the introduction of a wearable electronic device with the functionality of a laptop computer and phone. The fixed cost to launch this new product is $300,000. The variable cost for the product is expected to be between $128 and $192, with a most likely value of $160 per unit. The product will sell for $240 per unit. Demand for the product is expected to range from 0 to approximately 20,000 units, with 4,000 units the most likely. (a) Develop a what-if spreadsheet model computing profit for this product in the base-case, worst-case, and best-case scenarios. If your answer is negative, use minus sign. Best-case profit Worst-case profit Base-case profit (b) Model the variable cost as a uniform random variable with a minimum of $128 and a maximum of $192. Model the product demand as 1,000 times the value of a gamma random variable with an alpha parameter of 3…arrow_forward84 Large-scale integrated (LSI) circuit chips are made in one department of an electronics firm. These chips are incorporated into analog devices that are then encased in epoxy. The yield is not particularly good for LSI manufacture, so the AQL specified by that department is 12% while the LTPD acceptable by the assembly department is 35%. Assume the company is willing to accept a consumer's risk of 10 percent and a producer's risk of 5 percent. a. Find the sample size. Use Exhibit 10.16. Note: if the exact value of the computed LTPD/AOQ ratio does not appear in Exhibit 10.16, use the next higher ratio Note: Round up your answer to the next whole number.arrow_forwardThe Instant Paper Clip Office Supply Company sells and delivers office supplies to companies, schools, and agencies within a 50-mile radius of its warehouse. The office supply business is competitive, and the ability to deliver orders promptly is a big factor in getting new customers and maintaining old ones. (Offices typically order not when they run low on supplies, but when they completely run out. As a result, they need their orders immediately.) The manager of the company wants to be certain that enough drivers and vehicles are available to deliver orders promptly and that they have adequate inventory in stock. Therefore, the manager wants to be able to forecast the demand for deliveries during the next month. From the records of previous orders, management has accumulated the following data for the past 10 months: Month Jan. Feb. Mar. Apr. May Jun. Jul. Aug. Sep. Oct. Orders 145 70 115 85 120 54 82 141 123 94 Compute the…arrow_forward
- The Instant Paper Clip Office Supply Company sells and delivers office supplies to companies, schools, and agencies within a 50-mile radius of its warehouse. The office supply business is competitive, and the ability to deliver orders promptly is a big factor in getting new customers and maintaining old ones. (Offices typically order not when they run low on supplies, but when they completely run out. As a result, they need their orders immediately.) The manager of the company wants to be certain that enough drivers and vehicles are available to deliver orders promptly and that they have adequate inventory in stock. Therefore, the manager wants to be able to forecast the demand for deliveries during the next month. From the records of previous orders, management has accumulated the following data for the past 10 months: Month Jan. Feb. Mar. Apr. May Jun. Jul. Aug. Sep. Oct. Orders 145 70 115 85 120 54 82 141 123 94 Compute the…arrow_forwardThe Instant Paper Clip Office Supply Company sells and delivers office supplies to companies, schools, and agencies within a 50-mile radius of its warehouse. The office supply business is competitive, and the ability to deliver orders promptly is a big factor in getting new customers and maintaining old ones. (Offices typically order not when they run low on supplies, but when they completely run out. As a result, they need their orders immediately.) The manager of the company wants to be certain that enough drivers and vehicles are available to deliver orders promptly and that they have adequate inventory in stock. Therefore, the manager wants to be able to forecast the demand for deliveries during the next month. From the records of previous orders, management has accumulated the following data for the past 10 months: Month: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Orders: 1230 1155 1263 1159 1361 1273 1147 1250 1356 1155 Create tables to support your answer: a. Compute the monthly…arrow_forwardA cosmetics company fills its best selling jars of facial cream by an automatic dispensing machine. The machine is set to dispense a mean of 7.2 ounces per jar. Uncontrollable factors in the process can cause either underfill or overfill, both of which are undesireable. In such a case, the dispensing can be stopped and recalibrated. Regardless of the mean amount despensed, the standard deviation of the amount dispwnsed always has a value of 0.25 ounce. A quality control engineer routinely selects 36 jars from the assembly line to check the amounts filled. On one occasion, the sample mean is 7.8 ounces. Determine if there is sufficient evidence in the sample to indicate, at the 1% level of significance, that the machine should be recalibrated.arrow_forward
- The seasonal yield of olives in a Piraeus, Greece, vineyard is greatly influenced by a process of branch pruning. If olive trees are pruned every two weeks, output is increased. The pruning process, however, requires considerably more labor than permitting the olives to grow on their own and results in a smaller size olive. It also, though, permits olive trees to be spaced closer together. The yield of 1 barrel of olives by pruning requires 5 hours of labor and 1 acre of land. The production of a barrel of olives by the normal process requires only 2 labor hours but takes 2 acres of land. An olive grower has 250 hours of labor available and a total of 150 acres for growing. Because of the olive size difference, a barrel of olives produced on pruned trees sells for $20, whereas a barrel of regular olives has a market price of $30. The grower has determined that because of uncertain demand, no more than 40 barrels of pruned olives should be produced. Use graphical LP to find (a) the…arrow_forwardBad simulations Explain why each of the followingsimulations fails to model the real situation properly:a) Use a random integer from 0 through 9 to representthe number of heads when 9 coins are tossed. b) A basketball player takes a foul shot. Look at a ran-dom digit, using an odd digit to represent a good shot and an even digit to represent a miss.c) Use random numbers from 1 through 13 to represent thedenominations of the cards in a five-card poker hand.arrow_forwarddo fastarrow_forward
- Cost Estimation; High-Low Method; MAPE Ethan Manufacturing Inc. produces floor matsfor automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenancecosts. Together, you and Joseph determine that the single best cost driver for maintenancecosts is machine hours. These data are from the previous fiscal year for maintenance costs andmachine hours:Month Maintenance Costs Machine Hours1 $2,600 1,6902 2,760 1,7703 2,910 1,8504 3,020 1,8705 3,100 1,9006 3,070 1,8807 3,010 1,8608 2,850 1,8409 2,620 1,70010 2,220 1,10011 2,230 1,30012 2,450 1,590Required1. What is the cost equation for maintenance costs using the high-low method?2. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1.arrow_forwardCassette tapes are still used in some handheld recording devices and in less expensive portable musical instrument recording devices. The desired speed of a cassette tape is 1.900 inches per second. Any deviation from this value causes a change in pitch and tempo and thus poor sound quality. Suppose that adjusting the tape speed under warranty when a customer complains and returns a device costs a manufacturer $20. Based on past information, the company knows the average customer will return a device if the tape speed is off the target by at least 0.200 inches per second; in other words, when the speed is either 2.100 or 1.700. Suppose that a technician tests the tape speed prior to packaging and can adjust the speed to the target of 1.900 at a cost of $6. What should the economic specification limit be? The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Questions 1. In the Taguchi…arrow_forwardCassette tapes are still used in some handheld recording devices and in less expensive portable musical instrument recording devices. The desired speed of a cassette tape is 1.900 inches per second. Any deviation from this value causes a change in pitch and tempo and thus poor sound quality. Suppose that adjusting the tape speed under warranty when a customer complains and returns a device costs a manufacturer $20. Based on past information, the company knows the average customer will return a device if the tape speed is off the target by at least 0.200 inches per second; in other words, when the speed is either 2.100 or 1.700. Suppose that a technician tests the tape speed prior to packaging and can adjust the speed to the target of 1.900 at a cost of $6. What should the economic specification limit be? The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Question 4. What are the…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,