Reference no: EM132158664
Assignment
Columbia Pizza has one oven that can make a whole pie in about 10 minutes. Their late-night business among hungry college students is booming, and from 9 pm - 11 pm, they average 8 pie orders per hour. However, from 5 pm - 9 pm, they average only 5 pie orders per hour. Both order rates can be assumed arrive according to a Poisson distribution.
The owner of Columbia Pizza has discovered that if people have to wait for more than 20 minutes from when they get in the door to when they receive their pie, they are likely to simply go next door to University Falafel, meaning that Columbia Pizza would lose out on their $10 sale.
The owner is thinking of buying a second pizza oven and register (e.g. a second channel) that he thinks would cost $75 per night to operate (for the sake of our example, that is both the amortized cost of the oven and the pay of the person who is taking orders for the six hours that the pizza shop is open).
Answer each of the questions below. You must show all work. Be sure to highlight your final answer and when asked, please be sure to justify your response.
1. If Columbia Pizza buys a second oven, calculate the following for the 5-9 shift and the 9-11 shift
1. Average # of orders in the system
2. Average time order spends in the system (minutes)
3. Average # of orders in the queue
4. Average waiting time in the queue (minutes)
5. Utilization
2. Assuming all customers are able to be served, what is the total maximum revenue opportunity for Columbia Pizza?
3. In order to achieve the 20 minute total time from door to when they receive their pie, assuming two ovens are available, what is the total revenue opportunity?
4. Calculate the average daily loss of sales to University Falafel.
5. Based on your calculations, should Columbia Pizza buy the second oven? Why? What is the net financial impact?
6. Assume now that an improvement in the pizza making process results in the time to make pizzas being reduced to 6 minutes/pizza. How does this change your recommendation in #9 (note: no change in order demand)? Please describe.
What is amount of interest should capitalize
: What is the amount of interest Seikely- Anderson should capitalize in 2013 assuming that the specific interest method is used
|
Develop general-purpose spreadsheet to calculate balance due
: Develop a general-purpose spreadsheet to calculate the balance due, principal payment, and interest payment for each period of a loan.
|
Internet control message protocol
: An attack that uses the Internet Control Message Protocol (ICMP) to flood a victim with packets.
|
What is the journal entry for the issuance of the note
: Shea industries, a dental supplies facilitator, borrowed $480,000 cash on October 1, 2013. What is the journal entry for the issuance of the note
|
Should columbia pizza buy the second oven
: Based on your calculations, should Columbia Pizza buy the second oven? Why? What is the net financial impact?
|
How long will take to recover the initial investment
: A homeowner may upgrade a furnace that runs on fuel oil to a natural gas unit. The investment will be $2500 installed. The cost of the natural gas will average.
|
Compute the cost of ending inventory under the fifo method
: Assume that Brian uses a periodic inventory system and that there are 760 units left at the end of the month. Compute the cost of ending inventory
|
Find out the interest payment for each period
: A 30-year mortgage for $120,000 has been issued. The interest rate is 10% and payments are made monthly. Print out the balance due, principal payment.
|
What is the present worth of the savings
: The market volume for widgets is increasing by 15% per year from current profits of $200,000. Investing in a design change will allow the profit per widget.
|