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
Valles Galactic Industries (VGI) owns a small company (VGI-Durango Sur) that manufactures various electronic products for original equipment manufacturers. Customer companies provide engineering designs, materials lists, and some unique materials. VGI-DS provides labor and space for the manufacturing and assembly operations and stocking a variety of inventory items for production, such as wire, cables, some electronic components, etc. Thus, VGI-DS orders a variety of components and raw materials by contract. The labor pool is primarily composed of about 100 retirees picking up extra cash by working four to six-hour shifts. Thus, the assembly operations must be simple and easy to teach. Skilled employees must do several raw material conversions for packaging—there are currently three such employees.
VGI-DS receives forecasts from VGI headquarters for planned production for two years on a rolling quarterly basis. Staff at VGI-DS develop schedules and inventory plans based on this…
Suppliers A, B, and C supply components to three plants -- F, G, and H via two transshipment facilities -- T1 and T2. It costs $4 to ship from T1 regardless of final destination and $3 to ship to T2 regardless of supplier. Shipping to T1 from A, B, and C costs $3, $4, and $5, respectively, and shipping from T2 to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. The Logistics Manager has come to you for help.
Answer the following question:
Which of these is not an element of the objective function?
Group of answer choices
4D-T1
600T1
9T2-G
3C-T2
Plz do fast asap
Golf World, Incorporated (GWI) sells products and services for the sport of golf. One of its key
business units specializes in the repair and reconditioning of golf carts. GWI enters into contracts
with a number of golf clubs throughout the U.S. in which the clubs send their carts to GWI for a
complete reconditioning: motor, frame repair where necessary, and replacement of seat covers
and canvas tops. The clubs usually will cycle 10–15% of their carts through this process each year.
Because GWI's business has been growing steadily, it is very important to complete the
reconditioning of the carts within a budgeted time and cost. The firm uses weighted-average
process costing to keep track of the costs incurred in the reconditioning process.
GWI's golf cart repair and reconditioning unit has the following information for the month of
November, in which 1,200 carts were started for reconditioning:
Beginning WIP: 150 units, 50% complete for materials ($16,600) and 30% complete for…
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_forwardThe Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.arrow_forward
- Your company offers a weekly consolidation service from Toronto to Frankfort , via Lufthansa Airways. The carrier has given you a 1000 kg (or less) buying rate of CAN $2.27/kg and a plus 1000 kg buying rate of CAN $1.85/kg. You sell this service to clients who ship 700 kg (or less) at a rate of CAN $2.95/kg and for clients who ship in excess of 700 kg at a rate of CAN $2.55/kg. A) Shipper: J&J Company 123 John Street Toronto, ON, Canada, L5R 2N3 Shipment: 140 cartons of books Total weight: 426 kg Dimensions of each carton: 15 cm x 49 cm x 47 cm B) Shipper: R&R Company 432 Avenue Road Toronto, ON, Canada, R2S 1A3 Shipment: 380 cartons of umbrellas Total weight: 700 kg Dimensions of each carton: 39 in x 18 in x 19 in What is the profit on this shipment? full calculationarrow_forwardHomie Appliance Company operates a branch in Manila City. The following are transactions between the home office and branch for the current year. The home office sends P200,000 cash to the branch. Shipments to branch are billed at cost of P78,750. The Home Office pays branch expense of P3,500. Home office expense of 3,375 are paid by the branch. The branch returned merchandise costing P10,000 to the home office. Home office acquires branch furniture for P20,500 cash. The said fixed asset is carried on Branch Books. The annual depreciation on the branch furniture is 5%. The branch sends a P15,000 cash remittance to home office. Q1-What is the adjusted balance of Branch Current account in the Home Office Books? Q2-What is the adjusted Home Office Current account in the Home Office Books?arrow_forwardSwell Productions is sponsoring an outdoor conclave for owners of collectible and classic Fords. The concession stand in the T-Bird area will sell clothing such as T-shirts and official Thunderbird racing jerseys. Jerseys are purchased from Columbia Products for $40 each and are sold during the event for $75 each. If any jerseys are left over, they can be returned to Columbia for a refund of $30 each. Jersey sales depend on the weather, attendance, and other variables. The following table shows the probability of various sales quantities. How many jerseys should Swell Productions order from Columbia for this one-time event?Sales Quantity Probability Quantity Sales Probability100 0.05 400 0.34200 0.11 500 0.11300 0.34 600 0.05arrow_forward
- Sarasota Go Karts (SGK) is a firm that manufactures racing go-karts (fictitious) in Sarasota Florida. They produce a low-volume, premium product used by those who race go-karts. In total, they produce and sell around 300 go-karts per year. They offer five different models, although some further customization can be added upon request. They sell their products directly to the consumer, who can visit their small showroom at their manufacturing plant if they are in the area. However, the majority of go-kart orders are placed via their website or the phone, and are then shipped to the customer. Over the years, SGK has ran into a number of problems. First is their inventory levels. Their finished goods inventory is substantial, at any one time they have between 250-300 finished go-karts on hand. This is because they want to have an inventory of all five go-kart models on hand at any point in time, and they produce each model in a batch of 50 units at a time. They also have substantial work…arrow_forwardDM Office Products (DMOP) is a wholesale supplier of office products with one facility in Pennsylvania. They have decided to build a new distribution warehouse in the state of New York to help serve the growing demand in that market. They have four major customers located in Buffalo, Syracuse, Albany, and New York City. Though New York City is the largest market, it also has the greatest competition and DMOP is not a major player there. When DMOP ships an order to a customer they use their own small fleet of two trucks to deliver, so the cost of delivery is essentially the same for a full or partially full truck. The expected number of annual shipments to each city and their coordinates on an x, y grid is shown in the following table. CITY Buffalo Syracuse Albany New York x-COORDINATES 370 1,465 2,345 2,320 y-COORDINATES 895 945 675 70 NUMBER OF SHIPMENTS 96 100 140 80 Use the centroid method to recommend a location for the new warehouse for DMOP (Round your answers to 1 decimal…arrow_forwardThe village board of Park City, Utah, arranges for the clearing of all snow in city streets. Weekly snowfall during the winter is normally distributed with a mean of 10 inches and a standard deviation of 4 inches. The board is considering a long term contract with a snow removal company. The long- term contract costs $1000 per truck per week. Thus, if the board signs a long-term contract for 12 inches, they pay $12,000 per week whether the trucks are used or not. Each truck is capable of clearing 1 inch of snow per week. If snowfall in a week exceeds the quantity that can be handled by the trucks included in the long term lease, the board must make emergency arrangements at a cost of $2,500 for each additional truck brought in. For how many trucks should the board sign a long term contract?arrow_forward
- In this problem, your company is a distributor of products. You serve as an inventorymanager for the regional distribution center (DC) here in the Atlanta area. In this role,you schedule the purchase and shipment of products from various suppliers inbound to theAtlanta DC. Once you receive the products at the DC, they are stored in inventory untilthey are picked, packed, and shipped outbound to your company’s downstream customersin response to orders.For each of your products, you currently use a single, dedicated supplier. Each of yoursuppliers ships their products to you from their facility using trucking services, and theyprovide you with choices of different LTL or truckload trucking carriers depending on yourshipment size.Consider managing inventory now for product 101 produced by Supplier A. Currently,you face demand for product 101 of about 200 units per week. Each unit of product 101has a purchase cost p of $500 and you decide to value your inventory at the slightly higherrate…arrow_forwardIn this problem, your company is a distributor of products. You serve as an inventorymanager for the regional distribution center (DC) here in the Atlanta area. In this role,you schedule the purchase and shipment of products from various suppliers inbound to theAtlanta DC. Once you receive the products at the DC, they are stored in inventory untilthey are picked, packed, and shipped outbound to your company’s downstream customersin response to orders.For each of your products, you currently use a single, dedicated supplier. Each of yoursuppliers ships their products to you from their facility using trucking services, and theyprovide you with choices of different LTL or truckload trucking carriers depending on yourshipment size.Consider managing inventory now for product 101 produced by Supplier A. Currently,you face demand for product 101 of about 200 units per week. Each unit of product 101has a purchase cost p of $500 and you decide to value your inventory at the slightly higherrate…arrow_forwardCompanies A, B, and C supply components to three plants (F, G, and H) via two crossdocking facilities (D and E). It costs $4 to ship from D regardless of final destination and $3 to ship to E regardless of supplier. Shipping to D from A, B, and C costs $3, $4, and $5, respectively, and shipping from E to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. Crossdock facilities D and E can handle 600 and 700 units, respectively. Logistics Manager, Aretha Franklin, had previously used "Chain of Fools" as her supply chain consulting company, but now turns to you for some solid advice. What is the objective function? Group of answer choices Max Z = $3AD + $3AE + $4BD + $3BE + $5CD + $3CE + $4DF + $4DG + $4DH + $10EF + $9EG + $8EH Min Z = $3AD + $3AE + $4BD + $3BE + $5CD + $3CE + $4DF + $4DG + $4DH + $10EF + $9EG + $8EH Min Z = $3AD + $3BE + $5CD + $3CE…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,