Explore BrainMass
Share

Analyzing small business inventory and operations

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

See the attachment.
Process Analysis Queuing
You have taken a job as manager of Cupcake Heaven in Old Town Alexandria, Virginia. It is located on a busy street with lots of walk-in traffic. The owner, Sue, is thrilled at the prospect of you helping her analyze her operations. Cupcake Heaven currently operates in the following manner.

The baker arrives each morning at 5 am. It takes her 30 min to mix and bake a batch of cupcakes. A batch is 50 cupcakes. While a batch bakes, she is cleaning up from the first batch and therefore cannot start a second batch until the first has finished baking. The decorator, who frosts and decorates the cupcakes, arrives at 5:30 am. It takes him 40 minutes to decorate a batch. The baker finishes baking at 10 am. She then finishes cleaning up, makes coffee for customers, takes inventory, and places a replenishment order to be delivered later that day for the next day's baking. The store opens at 10 am and remains open until 8 pm. Some days the cupcakes sell out by 2 pm, other days they have leftovers. Averaging the demand for an entire day, they have found demand to be about 40 cupcakes per hour with a standard deviation of 5.

Sue wants you to answer the following questions for her.

1. What is the current daily capacity of the baking/decorating process? Is it sufficient to meet the daily average demand?
2. What is the maximum inventory level of cupcakes (in batches) waiting to be decorated?
3. What is the maximum length of time for which a batch of cupcakes will wait (in inventory) to be decorated? What time is the decorator finished decorating?
4. Now consider the customer's service experience. Customers start arriving at 10 am. However, the weekday is really only busy at lunch time 11:30-1:30 and after school 2:30-4:30. Weekends are different, with pretty steady customer arrivals all day. Customers during the weekday busy periods tend to buy just one cupcake, while on weekends the average order is for 3 cupcakes. When you ask, Sue is not sure what the arrival process is during the weekday busy periods but knows on average she sells 150 cupcakes during each two hour busy period. It takes the cashier about 30 seconds to write up and ring up an order and accept payment, but sometimes customers don't know what they want and other times, they pay with cash which takes longer. On average, Sue estimates a cashier takes about 45 seconds to ring someone up, but it is fairly random. Sue has space inside for 5 people in line and 5 people waiting for their cupcakes. In addition, there is a line demarcated by ropes outside that can hold 5 more people.

Fill out the following table based on weekday lunch time two-hour rush. Show your work and and include appropriate units.

λ
Average interarrival time
μ
Average service time
Utilization
S
Ca
Cs
Lq
Ls
Wq
Ws
How much free time do(es) the server(s) have for clean up, refilling napkin holders etc. during the two hour period?

Now turn to the ordering/packaging process. The packaging process though can be lengthy. A customer tells the cashier what he wants, the cashier marks it on a slip of paper, and puts it on the packaging table behind the counter. This part on average takes 30 seconds. The packaging person gets the cupcake (or cupcakes) from the correct tray (15 seconds), folds the package container (10 seconds), places the cupcake in the package and closes the package (15 seconds), then calls the customer's name and waits for the customer to get the package (20 seconds). Ignore variability in the process and assume that there is one cashier and one packaging person.

5. Draw a flow chart, label each step and determine the capacity of each step.
6. Where is the system capacity? What is the cycle time of the process?
7. If the packaging person goes on break and the cashier has to do all the steps, what is the cycle time of the process?

© BrainMass Inc. brainmass.com October 25, 2018, 8:48 am ad1c9bdddf
https://brainmass.com/business/inventory-management/analyzing-small-business-inventory-operations-552936

Attachments

Solution Preview

Process Analysis Queuing
You have taken a job as manager of Cupcake Heaven in Old Town Alexandria, Virginia. It is located on a busy street with lots of walk-in traffic. The owner, Sue, is thrilled at the prospect of you helping her analyze her operations. Cupcake Heaven currently operates in the following manner.

The baker arrives each morning at 5 am. It takes her 30 min to mix and bake a batch of cupcakes. A batch is 50 cupcakes. While a batch bakes she is cleaning up from the first batch and therefore cannot start a second batch until the first has finished baking. The decorator, who frosts and decorates the cupcakes, arrives at 5:30 am. It takes him 40 minutes to decorate a batch. The baker finishes baking at 10 am. She then finishes cleaning up, makes coffee for customers, takes inventory, and places a replenishment order to be delivered later that day for the next day's baking. The store opens at 10 am and remains open until 8 pm. Some days the cupcakes sell out by 2 pm, other days they have leftovers. Averaging the demand for an entire day, they have found demand to be about 40 cupcakes per hour with a standard deviation of 5.

Sue wants you to answer the following questions for her.

1. What is the current daily capacity of the ...

Solution Summary

The solution assists with analyzing small business inventory and operations.

$2.19
See Also This Related BrainMass Solution

Financial Research Report: CostCo

This assignment is an analysis of a U.S. publicly-traded company, with either a subsidiary or division operating outside of North America and its common stock as a prospective investment. Format and actions to complete:

Company Overview. Conduct research and describe the company, its operations, locations, markets, and lines of business. Collect financial statements for the past 3 years, fiscal or calendar.

Ratio Analysis. Perform trend and ratio analysis on current and fixed assets, current and long term liabilities, owner's equity, sales revenues, EBIT, net income, and earnings per share. Project these trends 3 years in the future.

Stock Price Analysis. Research the company's common stock price for the past 5 years. Research the Standard & Poor's Stock Market Index (S&P 500) for the past 5 years. Chart the price movement in the company's common stock against the S&P price movement. State and support your opinion on the company's common stock as an investment today.

Foreign Operations. Select a company subsidiary or division operating outside of North America and describe the subsidiary's or division's operation, location, market(s), and line(s) of business, and how they relate to the parent company's operations. Compare the financial growth of its overseas operations for the past 3 years.

Global Analysis. Decide whether, in the event of an economic slowdown in the U.S., the company's overseas revenue generation might serve to shelter the parent from slow or negative growth in the U.S. market. Explain and support your opinion.

References. Use at least 5 references

View Full Posting Details