Assignment #1: JET Copies Case Problem Read the “JET Copies” Case Problem on pages 678-679 of the text. Using simulation estimate the loss of revenue due to copier breakdown for one year, as follows: 1. In Excel, use a suitable method for generating the number of days needed to repair the copier, when it is out of service, according to the discrete distribution shown. 2. In Excel, use a suitable method for simulating the interval between successive breakdowns, according to the continuous distribution shown. 3. In Excel, use a suitable method for simulating the lost revenue for each day the copier is out of service. 4. Put all of this together to simulate the lost revenue due to copier breakdowns over 1 year to …show more content…
This gave James an idea, which he shared with Ernie and their friend Terri Jones when he got home later that evening. “Look, you guys, I’ve got an idea to make some money,” James started. “Let’s open a copy business! All we have to do is buy a copier, put it in Terri’s duplex next door, and sell copies. I know we can get customers because I’ve just seen them all at Klecko’s. If we provide a copy service right here in the Southgate complex, we’ll make a killing.” Terri and Ernie liked the idea, so the three decided to go into the copying business. They would call it JET Copies, named for James, Ernie, and Terri. Their first step was to purchase a copier. They bought one like the one used in the college of business office at State for $ 18,000. (Terri’s parents provided a loan.) The company that sold them the copier touted the copier’s reliability, but after they bought it, Ernie talked with someone in the dean’s office at State, who told him that the University’s copier broke down frequently and when it did, it often took between 1 and 4 days to get it repaired. When Ernie told this to Terri and James, they became worried. If the copier broke down frequently and was not in use for long periods while they waited for a repair person to come fix it, they could lose a lot of revenue. As a result, James, Ernie, and Terri thought they might need to purchase a smaller backup copier for $ 8,000 to use when the main copier broke down. However,
Compute the projected profit for the order quantities suggested by the management team under three scenarios: worst case in which sales = 10,000 units, most likely case in which sales = 20,000 units, and best case in which sales = 30,000 units.
One of specialty’s managers felt that the profit potential was so great that the order quantity should have a 70% chance of meeting demand and only a 30% chance of any stock-outs. What quantity would be ordered under this policy, and what is the projected profit under the three sales scenarios?
Mendel Paper Company has been doing relatively well with the sales of computer paper, napkins, place mats, and poster board. With more people eating out, the demand for napkins and place mats have increased. Computer paper and poster boards have slowly increased in demand as well. However, there is concern at the company with the fixed cost of operations. Marlene Herbert, the plant superintendent, said, “As we have automated our operation, we have experienced increases in fixed overhead and even variable overhead. And, we will have to add more equipment since it appears that we need even more plant capacity. We are operating over our normal capacity as it is.” (Case 2B). With the new production costs added in, will
The average number of breakdowns from the simulation trials was 1.93 with a standard deviation of 0.20. No. of breakdowns per week
Asterex Inc. produces silicon gaskets that are used to connect piping materials for the petroleum
In our second assumption, instead of using the cost of goods per cases in 1986, we try to use the percentage it counts in the total expenses which is 50.4% and to find the sales needed to break-even. The detail of the calculation is shown in the answer for questions d. The result is that 95,635, a little bit higher than the estimated sales of 90,000.
Calculate purchases, gross margin, inventory turn days, accounts receivable turn days, and accounts payable turn days for the years ended 20x2, 20x3, 20x4, 20x5
A. The simulated function given in the Excel spreadsheet “Hamptonshire Express: Problem_#1” allows the user to find the optimal quantity of newspapers to be stocked at the newly formed Hamptonshire Express Daily Newspaper. Anna Sheen estimated the daily demand of newspapers to be on a normal standard distribution; stating that daily demand will have a mean of 500 newspapers per day with a standard deviation of 100 newspapers per day. Using the function provided, the optimal stocking quantity, which maximizes expected profit, is determined to be approximately 584 newspapers. If 584 newspapers were to be ordered, Hamptonshire Express will net an
(b) How many units will Yabba have to sell next year in order for it to achieve the same profit that it did this year?
For instance, Canada's federal government has delegated the responsibility for airports to local authorities. As a result, many Canadian airports have transformed into brighter, cleaner, and more modern facilities that have become more expensive to operate 3. Canada’s airports have spent more than $9.5 billion on improvements since 19922. According to the CEO of Transat A.T. Inc, “it costs three times as much for an airline to land in Pearson Airport in Toronto as at Charles-de-Gaulle in Paris” 2. Such high landing fees have made Pearson and other major Canadian airports less desirable landing destinations; increasing costs for airlines, and as a result, often increasing prices for consumers. Pearson Airport is West Jet’s “second-largest hub and main connection point in Eastern Canada” and almost half of its destinations are to Canadian airports2, Such high costs of landing in major Canadian cities require that WestJet finds more ways to cut costs and remain the cost leader in its industry.
a. For an annual volume of 12,000 tires, determine the total cost, total revenue, and profit.
* Refer sheet “25000 Sales” for cost incurred and Gain/loss for AIFS for different scenarios and actual sales volume of 25000.
a. Assuming the most current operational cost levels, what sales must it generate to recoup the above investment?
Assume that under no unusual circumstances (no storm), Jaeger sells 1,000 cases of Riesling. Consider different cases: 1. Jaeger harvests grapes in anticipations of storm. Then the total revenue will be equal to 12×1000×$2.85 = $34200. 2. Jaeger doesn’t harvest and there is no storm with 50% chance. 2.1. With 40% chance, sugar concentration is 25%, then the total revenue is 12 × 1000 × $3.50 = $42000 2.2. With 40% chance, sugar concentration is 20%, then the total revenue is 12 × 1000 × $3.00 = $36000 2.3. With 20% chance, sugar concentration is below 20%, then the total revenue is 12 × 1000 × $2.50 = $30000 3. There is storm with 50% chance 3.1. Storm causes botrytis
The case study provided the probability for how long, in terms of days, repairing a copier break down would be. Essentially, finding the number of days that should be expected to fix a broken copier would then mean finding the cumulative average of these probabilities. Thus, in Excel, I multiplied the repair time with the corresponding probability. These were then added together to combine the likelihood of the average repair time in terms of days it would take to repair the average copier breakdown. The resulting number was 2.25 for the average breakdown.