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
VITRAN Bus Services purchases diesel fuel from Domino Gas Supply. In addition to fuel cost, Domino Gas Supply charges VITRAN Bus Services $250 per order to cover the expenses of delivering and transferring the fuel to VITRAN Bus Services storage tanks. The lead time for new shipment from Domino Gas Supply is 10 days, the cost of holding a gallon of fuel in the storage tanks is $0.04 per month, or $0.48 per year and the annual usage of fuel is 150,000 gallons. VITRAN Bus Services buses operate 300 days a year.
What is the optimal order quantity for VITRAN Bus Services?
How frequently should VITRAN Bus Services order to replenish the gasoline supply?
An automotive warehouse stocks a variety of parts that are sold at neighborhoodstores. One particular part, a popular brand of oil filter, is purchased by thewarehouse for $1.50 each. It is estimated that the cost of order processing andreceipt is $100 per order. The company uses an inventory carrying charge based on warehouse for $1.50 each. It is estimated that the cost of order processing andreceipt is $100 per order. The company uses an inventory carrying charge based ona 28 percent annual interest rate.The monthly demand for the filter follows a normal distribution with mean280 and standard deviation 77. Order lead time is assumed to be five months.Assume that if a filter is demanded when the warehouse is out of stock, then thedemand is back-ordered, and the cost assessed for each back-ordered demand is$12.80. Determine the following quantities:a. The optimal values of the order quantity and the reorder level.b. The average annual cost of holding, setup, and stock-out associated…
Total demand for a transportation model is 15 while total supply is 20. Which of the following should be included?
a dummy demand of 35 units
a dummy demand of 5 units
a dummy supply of 5 units
a dummy supply of 35 units
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
- Located in the picturesque Berkshire Mountains of Western Massachusetts, Ski Butternut has been a family-owned, family-oriented ski destination for more than 50 years. The resort includes 22 trails for downhill skiing and snowboarding, two terrain parks for riding, and a dedicated area for snow tubing. Although Ski Butternut hosts some non-ski events during summer and fall, its business goes into high gear when snowy weather arrives, bringing skiers and riders from across Massachusetts, Connecticut, New York, and New Jersey. Matt Sawyer, Ski Butternuts director of marketing, says the primary target market has always been families with young children who are seeking affordable skiing. Everything from the snack-bar menus to the ski-shop merchandise is presented with families in mind. So that parents can have fun in the snow without worry, the resort has a Childrens Center for children who are too young to ski or have no interest. Fifth-graders are invited to ski for free when accompanied by an adult who buys an adult lift ticket. The resort also created two terrain parks for young snowboarders who were clamoring for a more exciting riding experience. Without the terrain parks, Sawyer says, these boarders would have asked their parents to take them to competing mountains in Vermont. Ski Butternuts research shows that first-timers are a particularly important segment, because they tend to have a strong allegiance to the resort where they learn to ski. First-timers typically visit the resort seven times before seeking out more challenging mountains. As a result, Ski Butternut has made teaching first-timers to ski or snowboard one of its specialties. For this market, the resort bundles ski or board rentals, lift tickets, and also offers a wide range of individual and group lessons for all ages and abilities at a value price. Because Ski Butternut has trails for different skill levels, beginners can challenge themselves by changing trails within the resort once they feel confident. Ski Butternut also targets seniors and college students. Knowing that weekends are the busiest period, the resort offers special midweek prices to attract seniors who have free time to ski on weekdays. College students are particularly value-conscious, and they often travel to ski resorts as a group. As a result, Ski Butternut offers weekend and holiday discounts to bring in large numbers of students who would otherwise ski elsewhere. Thanks to Facebook, Twitter, and other social media, students quickly spread the word about special pricing, which enhances Ski Butternuts ability to reach this key segment. In addition, the resort highlights discount pricing for families when targeting specific segments, such as scout troops, military personnel, emergency services personnel, and members of local ski clubs. Another segment Ski Butternut has selected for marketing attention is ski racers. The resort features professional coaching, lessons, and programs for ski racers in the age group of 8 to 20. Sawyer notes that these ski racers are extremely dedicated to training, which means theyre on the slopes as often as possible, a positive for the resorts attendance and revenue. To stay in touch with racers, Ski Butternut has a special website and a dedicated Facebook page. Sawyer conducts up to 1,200 customer surveys every year to better understand who his customers are and what they need. He also compares the results with skiers who visit mountains of a similar size in other areas. Digging deeper, he analyzes data drawn from the ski shops rental business to build a detailed picture of customers demographics, abilities, and preferences. Based on this research, he knows that the typical family at Ski Butternut consists of two children under age 18 who ski or ride, and at least one parent who skis. Because they can obtain so much information from and about their customers, Sawyer and his team are able to make better decisions about the marketing mix for each segment. By better matching the media with the audience, they get a better response from advertising, e-mail messages, and other marketing communications. As one example, they found that 15 percent of the visitors to Ski Butternuts website were using a smartphone to access the site. Sawyer has now created a special version of the site specifically for mobile use and created a text-message contest to engage skiers who have smartphones.16 How is Ski Butternut applying behavioristic variables in its segmentation strategy? Explain your answer.arrow_forwardLocated in the picturesque Berkshire Mountains of Western Massachusetts, Ski Butternut has been a family-owned, family-oriented ski destination for more than 50 years. The resort includes 22 trails for downhill skiing and snowboarding, two terrain parks for riding, and a dedicated area for snow tubing. Although Ski Butternut hosts some non-ski events during summer and fall, its business goes into high gear when snowy weather arrives, bringing skiers and riders from across Massachusetts, Connecticut, New York, and New Jersey. Matt Sawyer, Ski Butternuts director of marketing, says the primary target market has always been families with young children who are seeking affordable skiing. Everything from the snack-bar menus to the ski-shop merchandise is presented with families in mind. So that parents can have fun in the snow without worry, the resort has a Childrens Center for children who are too young to ski or have no interest. Fifth-graders are invited to ski for free when accompanied by an adult who buys an adult lift ticket. The resort also created two terrain parks for young snowboarders who were clamoring for a more exciting riding experience. Without the terrain parks, Sawyer says, these boarders would have asked their parents to take them to competing mountains in Vermont. Ski Butternuts research shows that first-timers are a particularly important segment, because they tend to have a strong allegiance to the resort where they learn to ski. First-timers typically visit the resort seven times before seeking out more challenging mountains. As a result, Ski Butternut has made teaching first-timers to ski or snowboard one of its specialties. For this market, the resort bundles ski or board rentals, lift tickets, and also offers a wide range of individual and group lessons for all ages and abilities at a value price. Because Ski Butternut has trails for different skill levels, beginners can challenge themselves by changing trails within the resort once they feel confident. Ski Butternut also targets seniors and college students. Knowing that weekends are the busiest period, the resort offers special midweek prices to attract seniors who have free time to ski on weekdays. College students are particularly value-conscious, and they often travel to ski resorts as a group. As a result, Ski Butternut offers weekend and holiday discounts to bring in large numbers of students who would otherwise ski elsewhere. Thanks to Facebook, Twitter, and other social media, students quickly spread the word about special pricing, which enhances Ski Butternuts ability to reach this key segment. In addition, the resort highlights discount pricing for families when targeting specific segments, such as scout troops, military personnel, emergency services personnel, and members of local ski clubs. Another segment Ski Butternut has selected for marketing attention is ski racers. The resort features professional coaching, lessons, and programs for ski racers in the age group of 8 to 20. Sawyer notes that these ski racers are extremely dedicated to training, which means theyre on the slopes as often as possible, a positive for the resorts attendance and revenue. To stay in touch with racers, Ski Butternut has a special website and a dedicated Facebook page. Sawyer conducts up to 1,200 customer surveys every year to better understand who his customers are and what they need. He also compares the results with skiers who visit mountains of a similar size in other areas. Digging deeper, he analyzes data drawn from the ski shops rental business to build a detailed picture of customers demographics, abilities, and preferences. Based on this research, he knows that the typical family at Ski Butternut consists of two children under age 18 who ski or ride, and at least one parent who skis. Because they can obtain so much information from and about their customers, Sawyer and his team are able to make better decisions about the marketing mix for each segment. By better matching the media with the audience, they get a better response from advertising, e-mail messages, and other marketing communications. As one example, they found that 15 percent of the visitors to Ski Butternuts website were using a smartphone to access the site. Sawyer has now created a special version of the site specifically for mobile use and created a text-message contest to engage skiers who have smartphones.16 What role do geographic variables play in Ski Butternuts segmentation and targeting?arrow_forwardAs part of a campaign to promote its annual clearance sale, Excelsior Company decided to buy television advertising time on Station KAOS. Excelsior's television advertising budget is $111,000. Morning time costs $3000/min, afternoon time costs $1000/min, and evening (prime) time costs $12,000/min. Because of previous commitments, KAOS cannot offer Excelsior more than 6 min of prime time or more than a total of 25 min of advertising time over the 2 weeks in which the commercials are to be run. KAOS estimates that morning commercials are seen by 200,000 people, afternoon commercials are seen by 100,000 people, and evening commercials are seen by 600,000 people. How much morning, afternoon, and evening advertising time should Excelsior buy to maximize exposure of its commercials? morning min afternoon min evening minarrow_forward
- The Frist Corporation has the followinginternal controls related to inventory:1. Only authorized inventory warehousing personnel are allowed in inventory storageareas.2. All inventory products are stored in warehousing areas that are segregated fromother storage areas used to house equipment and supplies.3. All inventory held on consignment at Frist Corporation is stored in a separatearea of the warehouse.4. The inventory purchasing system only allows purchases from pre-approved vendors.5. The perpetual inventory system tracks the average number of days each inventoryproduct number has been in the warehouse.6. Microchips are embedded in each product and when inventory items are removedfrom the warehouse to shipping, radio-frequencies signal a deduction of inventoryto the perpetual inventory system.7. On a weekly basis, inventory accounting personnel take samples of inventoryproducts selected from the perpetual inventory system and verify that the inventoryis on-hand in the warehouse…arrow_forwardThe Hawkins Supply Company is currently faced with an inventory rotation problem. This difficulty stems from the fact that some supplies must be used prior to a stated expiration date. Upon receipt, a new shipment of these perishable items must be stacked beneath the boxes that are currently in inventory. A substantial amount of time is consumed in restacking the items according to their expiration dates.The company would like to reduce the double and sometimes triple handling of items. How can this goal be achieved? Are there alternative solutions which might also be effective?arrow_forwardA shoe store orders shoes from the manufacturer and sells them at a mall. Storing shoes at the store costs $8 per shoe pair for a year. When reordering shoes from the manufacturer, there is a fixed cost of $16 per order as well as $4 per shoe pair. The retail store sells 750 shoe pairs each year. Find a function that models the total inventory costs as a function of the number of shoe pairs in each order from the manufacturer.arrow_forward
- SpeeDIY Sdn. Bhd. is an online Do-It-Yourself (DIY) store located in Sintok that provides home delivery of DIY products purchased via the Internet. SpeeDIY uses a fully integrated accounting system and practices automated Economic Order Quantity (EOQ) model in managing its inventory. For each registered item in the inventory database, the system specifies quantity on hand and a desired quantity on hand. When the quantity on hand falls below the desired quantity on hand, a notification automatically pops up on the purchasing clerk's computer screen, alerting the clerk to reorder the item. The purchasing clerk can proceed with the reordering of items simply by checking the acceptance box. When the acceptance box is checked, the purchase order transaction file is created. In addition, the vendor is notified electronically through a transmission from the purchasing system. The purchasing clerk prepares a purchase summary report to his manager at the end of the day. SpeeDIY warehouse has a…arrow_forwardThe KooKee bakery uses roughly 3,400 pounds of baking powder a year. KooKee currently purchases 300 pounds of baking powder per order and pays $3 per pound. The supplier of the baking powder has announced that orders of 1,000 pounds or more will be filled at a discount price of $2 per pound. KooKee incurs a cost of $100 each time it submits an order and the annual holding cost is 17 percent of the purchase price per pound. If the supplier offered the discount at 1,500 pounds instead of 1,000 pounds, what order size would minimize total cost?arrow_forwardMetaverse LLP is a laptop manufacturing company located at Bengaluru, India. One of the main components of the laptop is the Hard Disk Drive (HDD). The inventory of this item is controlled by the EOQ model. Presently the company imports 40 GB HDD from Micron Components and Devices at a unit price of $60 and a 15 day delivery time. Metaverse needs to determine the amount to order each time an order is placed. They also need to determine when to place the order. The forecasted demand for the coming year for the 40GB HDD is 3,000 units. The company incurs a high ordering cost of $225 per order. The average annual inventory holding cost is estimated to be 25% of the item cost and a safety stock of 25 HDDs is maintained. The company operates for 300 days a year. However, Micron wants to drastically increase prices of HDDs which is not acceptable to Metaverse. The purchase officer of Metaverse has identified another supplier Minnesota Data Products. This supplier is willing to supply at…arrow_forward
- Please answer the question with as much details as possiblearrow_forwardA quarry uses five types of rocks to fulfill four orders. The gypsum content, availability of each type of rock, and the production cost per pound for each rock, as well as the size of each order and the minimum and maximum gypsum percentage in each order, are given below.Rock type-------Cost-------% gypsum-------Amount Available1-------------------$1.00-----------2.0%-----------5002-------------------$5.00-----------5.0%-----------6003-------------------$5.50-----------4.5%-----------7004-------------------$2.00-----------3.0%-----------4005-------------------$1.20-----------6.0%-----------450 Order No.--------------------1----------2----------3---------4Order Size------------------500------600------500------350Min % gypsum-----------3.5%-----3.8%-----4.0%-----3.6%Max % gypsum----------4.4%-----4.6%-----4.7%-----4.8%What is the cheapest way to fill the orders?arrow_forwardKris Lee, the owner and manager of the Quality Hardware Store, is reassessing his inventory policy for hammers. He sells an average of 50 hammers per month, so he has been placing an order to purchase 50 hammers from a wholesaler at a cost of $20 per hammer at the end of each month. However, Kris does all the ordering for the store himself and finds that this is taking a great deal of his time. He estimates that the value of his time spent in placing each order for hammers is $75. What would the unit holding cost for hammers need to be for Kris' current inventory policy to be optimal according to the basic EOQ model? What is this unit holding cost as a percentage of the unit acquisition cost? What is the optimal order quantity if the unit holding cost actually is 20 percent of the unit acquisition cost? What is the corresponding value of TVC? What is TVC for the current inventory policy? If the wholesaler typically delivers an order of hammers in 5 working days (out of 25 working…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you