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
QL (“Quebec Lumber”) is a logging and wood processing firm in a remote part of the Canadian province of Quebec. They have recently acquired a remote track of timber that is located ten miles from their processing facility. Normally, this is not a problem as they are able to simply cut the timber and haul it using trucks to their processing facility. However, this track of forestland is ten miles to their north, and there are no roads connecting the tract of land to their facility. They have also acquired a narrow (120 foot wide) ten-mile strip of land connecting this tract of timber to their processing facility. QL considered building their own road between the two points, and have log trucks haul the logs to the processing facility. However, they have decided instead to go with a less expensive option, a narrow gauge railroad. The narrow gauge railroad would require the laying of ties and steel tracks, and will require a custom-built locomotive and rolling stock (train cars that will…
ABC Apple Juice Company produces and markets fresh fruit juice. During the apple harvest season, trucks bring apples from the fields to the process plant during a workday that runs long hours from 7AM. On peak days, approximately 3,000 kg of apples are trucked in per hour. Trucks dump their contents in a holding bin with a storage capacity of 9,000 kg. When the bin is full, incoming trucks must wait until it has sufficient available space. A conveyor moves apples from bin to the processing plant. The plant is configured to process apples at the rate of 2,000 kg per hour. Trucks arrive uniformly between 7:00AM to 5:00PM. Each truck holds about 1,000 kg of apples. The truck drivers are paid at the rate of $10 per hour. As ABC makes fresh juice, it does not store apples. Processing plant starts at 10:00AM and ends when all the apples received during the day have been processed. It takes 2 hours to clean the empty plant that must be kept ready for the next day production. Trucks are owned…
3.4-15* A cargo plane has three compartments for storing cargo:
front, center, and back. These compartments have capacity limits
on both weight and space, as summarized below:
Weight
Саpacity
(Tons)
Space
Сapacity
(Cubic Feet)
Compartment
Front
7,000
9,000
5,000
12
Center
18
Back
10
Furthermore, the weight of the cargo in the respective compart-
ments must be the same proportion of that compartment's weight
capacity to maintain the balance of the airplane.
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
- The 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_forwardThe Sure To Peal Paint Company stores all its metal compressed gas containers in a warehouse. These long cylindrical metal tanks contain various gases used in manufacturing cans of spray paint. The gas tanks are delivered to the warehouse by truck. Two receiving dock workers unload the containers from the delivery trucks and place them on four wheel trucks. Two materials handlers are responsible for pushing the loaded trucks into the warehouse, unloading the tanks and setting them up on end. The two materials handlers spend a major portion of their day moving loads of the gas tanks into the warehouse and placing them into the proper storage locations. In total, there are five different types of gases that in equal proportion make up 98% of all gas handled. Question: Management would like to identify a better way to handle these gas tanks. How can the handling operation be improved?arrow_forward17arrow_forward
- 33 White & Becker Tools (W&B) requires 2,000 elec- tric motors next month for its product line of weed trimmers. Each motor is composed of three com- ponents: a coil, a shaft, and housing. W&B has the capability to produce these components or purchase them from an outside vendor. The costs of produc- ing them and purchasing them are shown in the following table. COMPONENT Coil Shaft Housing DEPART- MENT PRODUCTION COST PER UNIT Fabrication 0.5 Molding 0.4 Inspection 0.2 $2.60 $1.80 $1.40 The components that are produced by W&B must pass through three departments: fabrication, molding, and inspection. The number of hours each component requires in each department and the total number of hours available next month in each department are shown in the following table: 0.2 0.7 0.3 PURCHASE COST PER UNIT COIL SHAFT HOUSING AVAILABILITY (HR.) (HR.) (HR.) (HR.) $3.12 $2.16 $1.68 0.6 0.3 0.4 3,000 3,000 1,800 In order to determine the number of components that will be produced and the number…arrow_forwardThe MFA Co. Ltd. presently moves pallet loads of cans from production to the truck dock for loading. The loading dock foreman claims that due to increased production the company needs to purchase five new fork trucks and to hire five persons to operate these trucks. Using the present equipment (fork trucks) the maximum load of cans that can be transported is 1500 lb. at a 13.5” load center. The fork truck currently in use is manufacturer - rated for 3,000 lb. at the 24” load center. Question: Can the pallet load capacity be increased? What, if any, new equipment is required?arrow_forwardNOTE: The answer of this question should be limited to ONE page of writing with reasonable size of fonts. The provincial government plans to distribute certain types of vaccines to the 3 major urban centers of the province covering a large portion of the provincial population. The 5 million doses of vaccines are expected to arrive in large batches at one of the major cargo airports by 2 military transporter airplanes in a single day. The vaccines will then be distributed to the 3 cities with the number of doses corresponding to the population sizes of the 3 cities. They will be further distributed to the 20 hospitals and about 200 local clinics in these 3 cities. Officials of the provincial health agency must plan for the upcoming vaccine distribution. Assume that you are asked to suggest several methods/tools in Industrial Engineering and Operations Research you have learned from this course. Present 3 such methods and for EACH of these methods, briefly explain: 6.1) For solving which…arrow_forward
- Company ZWZ manufactures three products in a serial system; Product XA is manufactured in Stage 1, Product XB in Stage 2, and XC in Stage 3. Product XB has a sales potential in the market; hence, some of it can be sold at the end of Stage 2, and the remaining can be moved to Stage 3. The third stage produces Product XC, and then delivers it to customers. Two units of Product XA produced in Stage 1 are required for each unit of Product XB in Stage 2. In addition, four units of Product XB produced in Stage 2 are required for each unit of Product XC in Stage 3. Stage 1 can only use regular time; however, Stage 2 has the options of using regular time and overtime in manufacturing. On the other hand, Stage 3 has only one alternative, which is subcontracting. The pertinent data are provided below: Stage 2 Stage 1 11 No overtime No subcontracting No sales 0.07 Unit regular time cost (TL) Unit overtime cost (TL) Unit subcontracting cost (TL) Unit selling price (TL) Unit processing time (hrs)…arrow_forwardSouthern Sporting Goods Company makes basketballs and footballs. Each product is produced from two resources-rubber and leather. The resource requirements for each product and the total resources available are as follows: Product Resource Requirement per Unit Rubber (lb.) Basketball 4 Football 5 Total Resources available 500 lb. 800 ft.2 * Each basketball produced results in a profit of $12, and each football earns $16 in profit. b. Transform this model into standard form Leather (ft.2) 3 2 a. Formulate a linear programming model to determine the number of basketballs and footballs to produce in order to maximize profit.arrow_forwardA certain city the Transportation Authority (CTA) has trollies leaving regularly throughout the day beginning at 5:00 a.m. Although the length of a trip and the number of stops are constant, the time taken for each trip varies due to weather, traffiffiffic, and time of the day. According to the CTA, the mean time taken for the trip is 50 minutes. Suppose the travel time is Normally distributed with standard deviation σ = 4 minutes. A random sample of 25 trips is obtained, and the time for each is recorded. Find the probability that the sample mean time will be less than 48 minutes.arrow_forward
- Shipping Fruit. Wollmer Distribution Company collects fruit from several small farms in the region, consolidates its collections, and then ships the fruit to a regional wholesale fruit market by truck. Having made their collections, the company has in stock 57 tons of grapes, 62 tons of peaches, and 81 tons of bananas. Wollmer owns four trucks that can transport fruit to market. Each truck has its own capacity, and Wollmer has discovered that yield losses occur at different rates depending on which fruit is carried in which truck. The truck suspension system and the efficiency of the refrigeration system seem to account for most of the losses. The following table shows the loss as a percentage: Grapes Peaches Bananas Capacity Truck 1 12% 10% 4% 40 T Truck 2 12% 14% 5% 50 T Truck 3 16% 13% 6% 55 T Truck 4 18% 17% 8% 75 T The current market prices for the three fruits are as follows: Fruit Price / Ton Grapes $ 500 Peaches 1,000 Bananas 1,750 As a logical way of loading the trucks, a…arrow_forwardGilman Heating and Air Conditioning Gilman Heating and Air Conditioning Inc. provides a broad range of services to commercial and residential customers, including installation and repair of several different brands of heating and air-conditioning systems, Gilman has a fleet of 28 trucks, each operated by one or more service technicians, depending on the size of a job. A recurrent problem for Gilman has been coordinating the service teams during the day to determine the status of a job and the need for parts not kept in the service vehicle, as well as to identify which team to send on emergency calls. Gilman's service area is spread over an urban/rural area of approximately 50 square miles. The company has developed cost and price sheets so that the service technicians accurately and consistently price the service work they perform.arrow_forwardRoedel Electronics produces tablet computer accessories, including integrated keyboard tablet stands that connect a keyboard to a tablet device and holds the device at a preferred angle for easy viewing and typing. Roedel produces two sizes of integrated keyboard tablet stands, small and large. Each size uses the same keyboard attachment, but the stand consists of two different pieces, a top flap and a vertical stand that differ by size. Thus, a completed integrated keyboard tablet stand consists of three subassemblies that are manufactured by Roedel: a keyboard, a top flap, and a vertical stand. Roedel's sales forecast indicates that 7,000 small integrated keyboard tablet stands and 5,000 large integrated keyboard tablet stands will be needed to satisfy demand during the upcoming Christmas season. Because only 500 hours of in-house manufacturing time are available, Roedel is considering purchasing some, or all, of the subassemblies from outside suppliers. If Roedel manufactures a…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,