Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell. Gas & Go is considering offering movie rentals through a self-service company that would locate a machine on the inside of the market store. BlueBox would charge an annual lease fee of $500 for delivery, setup and maintenance, and there is an energy cost of $0.08 for every video rented. GreenFilms would charge an annual lease of only $400, but the energy cost for every video rental is $0.10 due to the larger size of the machine. Customers rent each movie for $1.00, regardless of the company, and the Gas & Go would earn 30% of that revenue for each rental. a.At what forecasted volume should Gas & Go select BlueBox and what volume should the company select GreenFilms and why?

Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell. Gas & Go is considering offering movie rentals through a self-service company that would locate a machine on the inside of the market store. BlueBox would charge an annual lease fee of $500 for delivery, setup and maintenance, and there is an energy cost of $0.08 for every video rented. GreenFilms would charge an annual lease of only $400, but the energy cost for every video rental is $0.10 due to the larger size of the machine. Customers rent each movie for $1.00, regardless of the company, and the Gas & Go would earn 30% of that revenue for each rental. a.At what forecasted volume should Gas & Go select BlueBox and what volume should the company select GreenFilms and why?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section4.8: Data Envelopment Analysis (dea)

Problem 44P

See similar textbooks

Similar questions

1– Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell. 2. Gas & Go is considering offering movie rentals through a self-service company that would locate a machine on the inside of the market store. BlueBox would charge an annual lease fee of $500 for delivery, setup and maintenance, and there is an energy cost of $0.08 for every video rented. GreenFilms would charge an annual lease of only $400, but the energy cost for every video rental is $0.10 due to the larger size of the machine. Customers rent each movie for $1.00, regardless of the company, and the Gas & Go would earn 30% of that revenue for each rental. a. At what volume in number of rental transactions would the two options have the same cost?
1– Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell. 2.Gas & Go is considering offering movie rentals through a self-service company that would locate a machine on the inside of the market store. BlueBox would charge an annual lease fee of $500 for delivery, setup and maintenance, and there is an energy cost of $0.08 for every video rented. GreenFilms would charge an annual lease of only $400, but the energy cost for every video rental is $0.10 due to the larger size of the machine. Customers rent each movie for $1.00, regardless of the company, and the Gas & Go would earn 30% of that revenue for each rental. a. What is the annual break-even point for each option?
Damen Ship Repair has just introduced a new service. For a fixed annual fee, Damen will predict what are the most likely repair parts you will need for each of your cargo ships over the next year. It will then preposition those parts either on your ships or at Damen’s shipyards depending on whether your crew can install that part or it must be done at a shipyard. Then all you pay for is the installation labor you actually use each year, which also comes at a discounted rate. a) Specify the key features and benefits that they would want to inform customers about b) Develop an integrated marketing communication plan for marketing the service
Ethan Manufacturing Incorporated produces floor mats for automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenance costs. Together, you and Joseph determine that the single best cost driver for maintenance costs is machine hours. These data are from the previous fiscal year for maintenance costs and machine hours: Month Maintenance Costs Machine Hours $ 2,650 1 2 9 10 11 12 2,810 2,960 3,070 3,150 3,120 3,060 2,900 2,670 2,270 2,280 2,500 1,740 1,820 1,900 1,920 1,950 1,930 1,910 1,890 1,750 1,150 1,350 1,640 Required: 1. What is the cost equation for maintenance costs using the high-low method? 2. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1. (Input your final answer as a percentage rounded to 1 decimal…
13) Which of the following method is used for calculating Time value of Money? a. Future Value b. All of the options c. Annuity method d. Present value
Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell An operations manager must purchase new equipment has developed a table of conditional values for the various alternatives (equipment options) and states of nature (demand market conditions). states of nature (market conditions) Alternatives Good Average Poor X800 $38,000 $21,000 -$18,000 Y900 $33,000 $16,000 -$12,000 Z1000 $29,000 $19,000 $6,000 If the probabilities associated with the states of nature are 0.40 for a good market, 0.40 for an average market, and 0.20 for a poor market, determine: 2. the expected value of perfect information (EVPI)
Pls do fast within 5 minutes and i will give like for sure Solution must be in typed form Taylor Supply is a wholesaler of office supplies and equipment. Taylor purchases cartons of staples from Barker Manufacturing. Barker offers a price of $7 per carton of staples. Taylor incurs a fixed charge of $90 per order to cover order equipment and clerical costs. Each order takes 3 days to arrive . Taylor has projected sales to be 603 boxes per day. Taylor's accounting department has determined the holding costs relevant for inventory decisions are 28% of unit cost. Assume Q=3000. What is the demand for staples during lead time? 1) Assume Q=3000. What is the demand for staples during lead time? 2) Assume Q=3000. What z value is associated with a 90% confidence level? 3) Assume Q=3000. If Taylor wants a 90% service level, and the standard deviation in daily demand is 250, what is the appropriate reorder point? 4) Assume Q=3000. If Taylor wants to improve their service level to 95%, and…
Ms. Suzanne Morphy is a full time architect. She is also sells vegetables on the side from a small farm she runs in her backyard. In 2018, the first year of operation, she had a loss of $42500 and deducted the maximum allowable amount. What is the amount of her farm loss carryover to future years that can be applied against future farm income? Round to the nearest dollar. Do NOT write commas, dollar signs, or decimals in your response. Your Answer: Answer
Cost Estimation; High-Low Method; MAPE Ethan Manufacturing Inc. produces floor matsfor automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenancecosts. Together, you and Joseph determine that the single best cost driver for maintenancecosts is machine hours. These data are from the previous fiscal year for maintenance costs andmachine hours:Month Maintenance Costs Machine Hours1 $2,600 1,6902 2,760 1,7703 2,910 1,8504 3,020 1,8705 3,100 1,9006 3,070 1,8807 3,010 1,8608 2,850 1,8409 2,620 1,70010 2,220 1,10011 2,230 1,30012 2,450 1,590Required1. What is the cost equation for maintenance costs using the high-low method?2. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1.
Please do not give solution in image formate thanku. Birdie Masters is a successful chain of golf schools located in the southwestern United States. The company has been developing a new system that will automate all of the school’s operations and is about ready to begin the installation of the new system. Currently, the school locations are being run with a rather jumbled combination of manual and automated record keeping, and the intent of this new system is to rationalize and standardize the record keeping and improve reporting and analysis capabilities. The system also has a web-based component that is used by school students to check on classes, enroll in classes and lessons, and monitor progress. Because the winter golf season is approaching, activity at the golf schools is expected to increase soon, and management would like to have the new system in place. Discuss the conversion options that Birdie Masters should consider. What is your recommended conversion strategy? Explain…
Products A,B, and C are sold door-to-door. A costs $ 3 per unit, take 10 minutes to sell (on the average) and costs $0.50 to deliver to customer. B costs $ 5, takes 15 minutes to sell, and is left with the customer at the time of sale. C costs $ 4, takes 12 minutes to sell, and costs $ 1 to deliver. During any week, a salesperson is allowed to draw up to $ 500 worth of A,B,C (at cost) and is allowed delivery expenses not to exceeds $ 75. If a salesperson’s selling time is not expected to exceed 30 hours (1,800 minutes) in a week, and if the salesperson profit (net after all expenses) is $ 1 each on a unit of A and B and $ 2 on a unit of C, what combination of sales of A, B, and C will lead to maximum profit, and what is the maximum profIt?
Il-Fill in the blank Direction: Supply the missing word from the box. Write your answer on the blank before each number. 31 32 33 34 35 36 37 40 41 38 .........This report summarizes daily reservation activity in terms of creation, modification, and cancellation of reservation record. 39 Escorting guests during check in &out and run errands for the front desk. 42 Janitor / Reservation clerk /Turn Away report / Doorman Desk clerk / Valet parker / Advance Deposit / Guest / Porter Concierge /Reservation Transaction report/ Bell boy Telephone operator /Revenue Cart report / Front office manager Front desk supervisor / Reservation supervisor // Front office cashier Attends to settlement of guests bills. Attends to any request for guest assistance especially VIPs like making restaurant arrangements. He/she plans, organizes, directs, and controls all areas of front office operations Attends to the registration of guests and provide information assistance.. Attends to room sales and…