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
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…
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…
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
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_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_forwardAnalyse eMMC ' s price and storage capacity with its benefitsarrow_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.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_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_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
- Boston Company use a special part in manufacturing of its finished products. The unit cost thisspecial part is $ 35, and details of its manufacturing cost is as follows. The $35 unit productcost of this part is based on average 25,000 number of parts produced each year.An outside supplier has offered to supply the 25,000 parts at a cost of $30 per part. The specialequipment used to manufacture the above part. This equipment can only be used formanufacturing of this part and if not used it has no resale value.The total amount of general factory overhead, which is allocated based on direct labor-hours,would be unaffected by this decision because it is fixed cost..Suggest the management whether to stop producing internally and buy them from theoutside supplier?Description CAD Direct Materials 10Direct Labor 6Variable overheads…arrow_forwardBrit Traders is planning on buying some RAINCOATS to sell during the Spring season. Due to prevailing market prices and the estimated costs, it plans on selling each umbrella at $25. The store manager has been in some communication with an online vendor who is selling the RAINCOATS at discounted prices depending on the units bought. Below is the quantity discount structure offered by the vendor. Quantity Discount Structure At least Unit cost 0 14.25 150 12.50 300 11.00 450 10.50 600 8.75 The fixed cost for the store is $120 and a branding cost of $2.75 for each umbrella. The manager wants to order 500 umbrellas but is uncertain about the demand which could be between 200 – 800. He has also decided that in case all the umbrellas will not be sold before the end of the season, any leftovers will be sold at a clearance price of $9 for each umbrella. The store manager has approached you to help him build a spreadsheet model to help him in making a decision on how many pieces to buy Create a…arrow_forwardSolve this question:arrow_forward
- LPM Corp. produces and sells two types of frozen burgers, Turkey Burgers and Veggie Burgers. In the most recent month, the firm sold 12,000 Turkey Burgers and 8,000 Veggie Burgers. Turkey Burgers sold for $14.00 per box and variable costs were $7.40 per box. The Veggie Burgers sold for $16.00 per box and variable costs were $8.25 per box. The fixed expenses of the entire company were $41,160. If the sales mix were to shift toward the Turkey Burgers product line with total sales volume remaining constant at 20,000, the overall break-even point for the entire company:arrow_forwardABC Company purchased its inventory at a lump price of P20,000. Relative sales value for each type of inventory was: Inventory XX, P10,000 Inventory YY, P4,000 Inventory ZZ, P10,000 How much would be the cost assigned to inventory XX, YY an ZZ respectively? 10,000. 4,000 and 10,000 respectively 10,000, 4,000 and 8,333 respectively 8,333, 3,333 and 8333 respectively 6667, 6667 and 6667 respectivelyarrow_forwardPlease do not give solution in image format thankuarrow_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