Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
8th Edition
ISBN: 9781305947412
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
gohotels.ph, a property of Robinson's Land, began test marketing its value hotel in May 2010 at its building along Edsa beside Robinson's Pioneer Street. It has about 200 rooms in the Edsa site but has chosen to have 60 to 100 rooms in each of their subsequent sites in the provincial areas. Its pricing is unique because it utilizes the revenue management model of the airline industry where prices would Ivary depending on demand, in this case, occupancy numbers. Thus, a 16 to 22 square meter room can command a price as low as P388 plus value added tax (VAT), or as high as P3,000 plus VAT, averaging about P1,550 plus VAT per room per night booked via internet. While the prices are low, the room boasts of a comfortable bed with two types of pillows (hypoallergenic and chiropractic), a clean private bathroom with rain shower, free wifi, LCD TV, convenient location with safe surroundings secured by CCTV and safety cabinet.
On its first month of its test market and despite using mostly…
Becky Shelton, a teacher at kemp middle school is in charge of ordering the T-shirts to be sold for the school's annual fund-raising project the t-shirts are printed with a special kemp school logo. In some years the supply of T-shirts has been insufficient to satisfy the number of sales orders. In other years, T-shirts have been left over. excess T-shirts are normally donated to some charitable organization. T-shirts cost the school $7 each and are normally sold for $14 each. Ms Shelton has decided to order 790 shirts.
RequiredÂ
1) if the school receives actual sales orders for 715 shirts, what amount of profit will the school earn?what is the cost of waste due to excess inventory?
2) If the school receives actual sales orders for 830 shits, what amount of profit will the school earn? What amount of opportunity cost will the school incur?
a) Profit $1,050
waste due to excess inventory
b) Profit
opportunity cost
CASELET
1. gohotels.ph, a property of Robinson's Land, began test marketing
its value hotel in May 2010 at its building along Edsa beside
Robinson's Pioneer Street. It has about 200 rooms in the Edsa site
but has chosen to have 60 to 100 rooms in each of their subsequent
sites in the provincial areas. Its pricing is unique because it utilizes
the revenue management model of the airline industry where
prices would vary depending on demand, in this case, occupancy
numbers. Thus, a 16 to 22 square meter room can command a price
as low as P388 plus value added tax (VAT), or as high as P3,000
plus VAT, averaging about P1,550 plus VAT per room per night
booked via internet. While the prices are low, the room boasts of
a comfortable bed with two types of pillows (hypoallergenic and
chiropractic), a clean private bathroom with rain shower, free wifi,
LCD TV, convenient location with safe surroundings secured by
CCTV and safety cabinet.
On its first month of its test market and despite using…
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
- Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?arrow_forwardSuppose this information is available for PepsiCo, Inc. for 2015, 2016, and 2017. (in millions)  2015  2016  2017 Beginning inventory  $ 2,100  $ 2,400  $ 2,300 Ending inventory  2,400  2,300  2,700 Cost of goods sold  18,227  20,071  20,478 Sales revenue  39,145  42,957  44,066 Calculate the days in inventory for PepsiCo, Inc. for 2015, 2016, and 2017. (Round days in inventory to 1 decimal place, e.g. 5.1.)   2015  2016  2017 Days in inventory    daysarrow_forwardL. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.) Item number 2349 should be classified as Item Code Item number 8210 should be classified as 1289 2347 2349 2363 2394 2395 6782 7844 8210 8310 9111 L. Houts Plastics Charlotte Inventory Levels Avg. Inventory (units) 380 300 120 70 POHONNO 60 25 20 12 5 7 Value ($/unit) 3,25 6 4.00 2.50 1.30 1.75 2.25 1.15 2.05 2.00 2.00 3.00 Dollar Volume 1,200 300 105 23 25 70 % of Dollar Volume 39.00 9.75 3.41 14 18 3,077 For the following three questions, consider only items 1289, 2349, and 8210 from the above table for relative classification (these are some of the items for which you computed the…arrow_forward
- Analyse eMMC ' s price and storage capacity with its benefitsarrow_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_forwardABC Corporation has determined that his cologne is selling at 300 per bottle with a fixed cost of Php 2,000 and a variable cost of Php100 per unit., EFG has decided to order 40 bottles of the cologne. Will you decide to produce the products based on the number of orders or will you decline the order? Why? Given the situation of ABC Corporation, suppose EFG has decided to order 5 bottles only, would you decide to produce the products? Why? What is the break even point of ABC Corporation before they can decide to produce the units? *arrow_forward
- Problem 20-10 (Algo) You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the printer and buy the day’s paper for $0.50 a copy. You sell a copy of San Pedro Times for $1.25. Daily demand is distributed normally with mean = 335 and standard deviation = 67. At the end of each morning, any leftover copies are worthless and they go to a recycle bin.  a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.)   b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.)arrow_forwardProblem 20-10 (Algo) You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the printer and buy the day's paper for $0.30 a copy. You sell a copy of San Pedro Times for $1.10. Daily demand is distributed normally with mean = 265 and standard deviation = 53. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) Optimal order quantity b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.) Probabilityarrow_forwardAnswer bold italicized questions Using excel. The Metropolitan Bus Company (MBC) purchases diesel fuel from AmericanPetroleum Supply. In addition to the fuel cost, American PetroleumSupply charges MBC $250 per order to cover the expenses of deliveringand transferring the fuel to MBC’s storage tanks. The lead time for anew shipment from American Petroleum is 10 days; the cost of holding agallon of fuel in the storage tanks is $0.04 per month, or $0.48 peryear; and annual fuel usage is 150,000 gallons. MBC buses operate 300days a year.a.What is the optimal order quantity for MBC?b.Howfrequently should MBC order to replenish the gasoline supply?c.TheMBC storage tanks have a capacity of 15,000 gallons. ShouldMBC consider expanding the capacity of its storage tanks?d.What isthe reorder point?arrow_forward
- Three suppliers A, B and C, each produce road grit which has to be delivered to council depots W, X, Y and Z. The stock held at each supplier and the demand from each depot is known. The cost, in pounds, of transporting one lorry load of grit from each supplier to each depot is also known. This information is given in the table.  Suppliers Depot W Depot X Depot Y Depot Z Stock (Lorry Loads) Supplier A 180 110 130 290 14 Supplier B 190 250 150 280 16 Supplier C 240 270 190 120 20 Demand (Lorry Loads) 11 15 14 10 50 Use VAT method to supply out all the stocksarrow_forwardProblem 20-10 (Algo) You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the printer and buy the day's paper for $0.45 a copy. You sell a copy of San Pedro Times for $1.40. Daily demand is distributed normally with mean = 340 and standard deviation = 68. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) 8 Answer is complete but not entirely correct. Optimal order quantity 0.05 b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.) * Answer is complete but not entirely correct. Probability 3 X %arrow_forwardCommunity Hospital orders latex sanitary gloves from a hospital supply firm. The hospital expects to use 40,000 pairs of gloves per year. The cost to order and to have the gloves delivered is $180. The annual carrying cost is $0.18 per pair of gloves. The hospital supply firm offers the following quantity discount pricing schedule: Quantity Price 0–9,999 $0.34 10,000–19,999 0.32 20,000–29,999 0.30 30,000–39,999 0.28 40,000–49,999 0.26 50,000+ 0.24 Determine the optimal order size for the hospital.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning