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
Georgia Cabinets manufactures kitchen cabinets that are sold to local dealers throughout the Southeast. Because of a large backlog of orders for oak and cherry cabinets, the company decided to contract with three smaller cabinetmakers to do the final finishing operation. For the three cabinetmakers, the number of hours required to complete all the oak cabinets, the number of hours required to complete all the cherry cabinets, the number of hours available for the final finishing operation, and the cost per hour to perform the work are shown here:
Cabinetmaker 1
Cabinetmaker 2
Cabinetmaker 3
Hours required to complete all the oak cabinets
50
44
32
Hours required to complete all the cherry cabinets
61
46
34
Hours available
35
25
30
Cost per hour
$36
$43
$56
For example, Cabinetmaker 1 estimates that it will take 50 hours to complete all the oak cabinets and 61 hours to complete all the cherry cabinets. However, Cabinetmaker 1 only has 35 hours available for the final…
Georgia Cabinets manufactures kitchen cabinets that are sold to local dealers throughout the Southeast. Because of a large backlog of orders for oak and cherry cabinets, the company decided to contract with three smaller cabinetmakers to do the final finishing operation. For the three cabinetmakers, the number of hours required to complete all the oak cabinets, the number of hours required to complete all the cherry cabinets, the number of hours available for the final finishing operation, and the cost per hour to perform the work are shown here:
Cabinetmaker 1
Cabinetmaker 2
Cabinetmaker 3
Hours required to complete all the oak cabinets
50
44
32
Hours required to complete all the cherry cabinets
61
46
34
Hours available
35
25
30
Cost per hour
$36
$43
$56
For example, Cabinetmaker 1 estimates that it will take 50 hours to complete all the oak cabinets and 61 hours to complete all the cherry cabinets. However, Cabinetmaker 1 only has 35 hours available for the final…
Georgia Cabinets manufactures kitchen cabinets that are sold to local dealers throughout the Southeast. Because of a large backlog of orders for oak and cherry cabinets, the company decided to contract with three smaller cabinetmakers to do the final finishing operation. For the three cabinetmakers, the number of hours required to complete all the oak cabinets, the number of hours required to complete all the cherry cabinets, the number of hours available for the final finishing operation, and the cost per hour to perform the work are shown here:
Cabinetmaker 1
Cabinetmaker 2
Cabinetmaker 3
Hours required to complete all the oak cabinets
47
40
27
Hours required to complete all the cherry cabinets
64
51
36
Hours available
40
30
35
Cost per hour
$34
$41
$52
For example, Cabinetmaker 1 estimates it will take 47 hours to complete all the oak cabinets and 64 hours to complete all the cherry cabinets. However, Cabinetmaker 1 only has 40 hours available for the final…
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
- Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?arrow_forwardGeorgia Cabinets manufactures kitchen cabinets that are sold to local dealers throughout the Southeast. Because of a large backlog of orders for oak and cherry cabinets, the company decided to contract with three smaller cabinetmakers to do the final finishing operation. For the three cabinetmakers, the number of hours required to complete all the oak cabinets, the number of hours required to complete all the cherry cabinets, the number of hours available for the final finishing operation, and the cost per hour to perform the work are shown here: Hours required to complete all the oak cabinets Hours required to complete. all the cherry cabinets Hours available Cost per hour Min s.t. 01 Let O₁ O₂ 01 01 For example, Cabinetmaker 1 estimates it will take 50 hours to complete all the oak cabinets and 60 hours to complete all the cherry cabinets. However, Cabinetmaker 1 only has 40 hours available for the final finishing operation. Thus, Cabinetmaker 1 can only complete 40/50 = 0.8, or 80%,…arrow_forwardc. If Cabinetmaker 1 has additional hours available, would the optimal solution change? If required, round your answers to three decimal places. If your answer is zero, enter "0". Explain. ✓ because Cabinetmaker 1 has dual value Yes ✓ of No -1.84 ✔ ✓ of Therefore, each additional hour of time for cabinetmaker 1 will reduce total cost by $ d. If Cabinetmaker 2 has additional hours available, would the optimal solution change? If required, round your answers to three decimal places. If your answer is zero, enter "0". Use a minus sign to indicate the negative figure. Explain. ✔ because Cabinetmaker 2 has a slack 1.84 ✔ per hour, up to a maximum of 30 X hours. Alternatively, the dual value is 50 ✓ hours. 0.00 ✓ which means that adding one hour to this constraint will decrease total cost by $ 0.00 ✓.arrow_forward
- Jerry Wei, the hospital administrator at St. Charles General, must appoint head nurses to four newly established departments: urology, cardiology, orthopedics, and obstetrics. In anticipation of this staffing problem, he had hired four nurses, considered their backgrounds, personalities, and talents, and developed a cost scale ranging from 0 to 100 to be used in the assignment. A 0 for a nurse being assigned to the cardiology unit implies that the nurse would be perfectly suited to that task. A value close to 100, on the other hand, would imply that he or she is not at all suited to head that unit. The accompanying table gives the complete set of cost figures that the hospital administrator feels represented all possible assignments. Which nurse should be assigned to which unit? Department Urology Cardiology Orthopedics 28 18 15 32 48 23 51 36 24 25 38 55 Determine the assignment of nurses. The total cost is (enter your response as a whole number). Nurse Kitty Forman Carol Hathaway…arrow_forwardTrips Logistics, a third-party logistics firm that provides warehousing and other logistics services, is facing a decision regarding the amount of space to lease for the upcoming three-year period. The general manager has forecast that Trips Logistics will need to handle a demand of 100,000 units for each of the next three years. Historically, Trips Logistics has required 1,000 square feet of warehouse space for every 1,000 units of demand. For the purposes of this discussion, the only cost Trips Logistics faces is the cost for the warehouse. Trips Logistics receives revenue of $1.22 for each unit of demand. The general manager must decide whether to sign a three-year lease or obtain warehousing space on the spot market each year. The three-year lease will cost $1 per square foot per year, and the spot market rate is expected to be $1.20 per square foot per year for each of the three years. Trips Logistics has a discount rate of k = 0.1.arrow_forwardMercury Electronics must develop a plan to allocate capacity to fulfilling forecasted demand of 400 units in March, 500 units in April, and 700 units in May. Mercury has 50 units of inventory currently on hand. For each month, Mercury can produce units as follows: Regular Time Month March Overtime 50 Subcontracting 100 350 April 400 50 100 May 450 50 100 Assume the following costs: Regular time cost per unit $50 Overtime cost per unit $65 Subcontract cost per unit $80 Carrying cost per unit per month $1 Back order cost per unit per month $4 Develop an Excel model that allocates production capacity to satisfy demand at a minimum cost.arrow_forward
- The Seaside Hotel is a three-star hotel in Newquay, Cornwall. It contains 108 rooms and employs 30 fulltime and 40 parttime personnel. Between May and August, the hotel's workforce is nearly doubled by casual and temporary workers. Cornwall is a difficult place to do business, especially in the tourism industry. Business is highly seasonal with hotels experiencing very low occupancy during the offseason and many hotels choose not to operate during this time. The Seaside Hotel operates all year round by supplementing its tourism trade during the off-season by offering discounted conferencing facilities for local businesses and as a cheap base for corporate events and activities, such as team building weekends. Tourism is, however, vitally important for the region and its businesses and provides a significant proportion of all jobs in the South West. Cornwall can, however, be a difficult place in which to work. For instance, Newquay – Cornwall’s most popular holiday destination – is one…arrow_forwardHudson Corporation is considering three options for managing its data processing operation: continuing with its own staff, hiring an outside vendor to do the managing (referred to as outsourcing), or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of dollars) depends on demand as follows: Demand Staffing Options High Medium Low Own staff 600 550 350 Outside vendor 900 650 450 Combination 700 600 400 a. If the demand probabilities are 0.4, 0.25, and 0.35, which decision alternative will minimize the expected cost of the data processing operation? Own Staff What is the expected annual cost associated with that recommendation? If required, round your answer to the nearest thousand of dollars. Expected annual cost = $ ___________arrow_forwardA 36,000 square foot office building in Emeryville, California that was 88% leased had a 2023 annual net operating income estimated to be $1,880,000 with gross leases for all its tenants and a three level subterranean parking garage with 180 parking spaces. The 2024 NOI could be increased by all the following, EXCEPT: Increasing the operating expenses by adding additional maintenance staff Increasing the parking income by charging tenants for their employee parking Increasing the occupancy rate of the building by signing leases with new tenants Increasing the rental rates in new leases that are signed for the buildingarrow_forward
- Star Garage Limited provides motor vehicle accessories and services for a wide range of vehicles in Dominica. Customers purchase parts to take to their individual mechanics to complete vehicle repairs or they may choose to bring their vehicles to Star Garage for in-house repairs and servicing. This means that they pay for both the parts and the labour associated with the type of service required. Some services do not include any new parts, just the labour costs for that service. Individual customers must pay for all parts purchases in full at the time of sale. Individual customers must pay 50% down when they bring their vehicles in for servicing and pay the balance when they come to pick them up when the job is completed. Corporate customers, however, are billed monthly for all sales (parts or service). Although Star Garage Limited has several different banking accounts, all sales are deposited intact into its main chequing account. Star Garage Limited purchases its inventory of parts…arrow_forwardthe excel file president’s inn guest database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed- and-breakfast inn during one month. room rates are the same for one or two guests; however, additional guests must pay an additional $20 per person per day for meals. guests staying for seven days or more receive a 10% discount. modify the spreadsheet to calculate the number of days that each party stayed at the inn and the total revenue for the length of stay.arrow_forwardLevi Landon owns a small lawn care business with three employees. He owns the lawn mowers, rakes, and weed whackers that are housed in a storage area at the back of his home. He currently keeps his records in a spiral-bound book. He has a page for his list of customers, and their information including when he first started to do their garden, and the size of their lawns. He has another section to keep track of payments. Levi usually requires payment on completion of the service, but this rarely happens and he has lost track of who owes him and how much. Levi realizes that he is not as efficient as he could be in his record keeping and asks you to help him to track customer service dates, payments and lawn care revenue. He may want to get a loan to purchase some more equipment. He provides you with his book of customers, and payments and prices of the various lawn sizes. To help Levi with the reporting requirements, you need to work with Customer, Payment, and Prices tables that are…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,