1. Begin each formula with an = sign.
2. Reference cells, instead of entering values.

Example: =B3+C3

1. A copy center processes 18 orders per day, on average.Assume a 6 hour day.Assume the center has more than enough machines to meet the demand.On average, one order takes 10 minute to set up the machine and 20 minutes to print, package and label the order.At the end of a working day, how many orders are still in process?

Required:

At the end of a working day, how many orders are still in process?

Use the Open Excel in New Tab button to launch this question.

When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.

2. A package delivery company operates 12 trucks that can each carry 3,000 packages on each trip between various distribution centers.The company leadership wants to be able to load and unload 18,000 packages each week.Assume the trucks always travel fully loaded.What is the longest average travel time between distribution centers that allows them to meet their goal of 18,000 packages per week?

Required:

What is the longest average travel time (in weeks) between distribution centers that allows the company leadership to reach their goal?

Use the Open Excel in New Tab button to launch this question.

3. A welding shop purchases 600 kgs of steel per week to make slip rollers. Each slip roller uses 15 kg of steel. At any one time, on average, there are 110 slip rollers being made at various stations of the welding and assembly process.

Required:

On average, how much time (in weeks) elapses between when the steel arrives for a slip roller and when the slip roller is shipped to a customer (the completion of production)?

Use the Open Excel in New Tab button to launch this question.

4. It takes 30 minutes for an optomerist to examine one patient.

Required:

What is the capacity of the optomerist expressed in patients per hour?

Use the Open Excel in New Tab button to launch this question.

5. Process and Capacity 7

Sally's garage specializes in fluid change (oil, radiator, transmission) for cars. When she purchased the franchise, the garage and training were designed as such to service 46 cars per day. Over the past few months Sally has studied and measured her fluid change process and found the garage's effective capacity to be 40 automatically per day (on average). The actual number of cars her garage is able to service is, on average, 36 cars.

Required:

Calculate the Efficiency and Utilization of her garage.

Use the Open Excel in New Tab button to launch this question.

6. A local restaurant owned and operated by a retired IT professional has 20 tables with a seating capacity of 68 patrons. Using computer modeling she found that her combination of menu items and the design of her meal preparation process had a design capacity of 136 meals served per day. She collected data and studied the system and found - due to labor no-shows, breaks, meal prep errors and other issues, the effective capacity was 129 meals served per day.The actual number of meals served per day was 123.

Required:

Calculate the Efficiency and Utilization of her restaurant.

Use the Open Excel in New Tab button to launch this question.

7.Process and Capacity 9

An expresso coffee cart owner sets up her coffee cart outside a popular department store. She can produce 15 gourmet cups of coffee per hour, but her demand rate is only 12 cups per hour.

Required:

What is the flow rate?

What is the utilization rate of the coffee cart?

What is the cycle time?

Use the Open Excel in New Tab button to launch this question.

8. Dave's sandwich ship has an average demand of 140 sandwiches (units) per hour.

Station1 takes the order and prepares the bread.

Station2 applies the meat, cheese and sauce.

Station3 applies the vegies and gets payment from the customer.

Required:

What is the utilization rate for each Station?

Use the Open Excel in New Tab button to launch this question.

9. Carol's car detailing shop offers high-end car detaling and a relaxing waiting area. The area in which the shop is located has above average income and the weather is very rainy so there is always unlimited demand. The service process involves five activities which are preformed in the sequence described in the table below. The time for each service activity is given in the cell below the Station#. Carol employs five individuals, one for each service activity station

Activity

Welcome guest and offer refreshing drink

Park car, remove trash and other items. Vaccum

Wash and quick wax car. Towel dry. Armoll tires.

Clean glass. Wipe down inside of car

Ring up the gues's bill

Required:

What is the cycle time?

Use the Open Excel in New Tab button to launch this question.

10. Cp-Fr-Ct-Ur 1

It takes 30 minutes for an optometrist to examine one patient.

Required:

What is the capacity of the optometrist expressed in patients per hour?

Use the Open Excel in New Tab button to launch this question.

11. Cp-Fr-Ct-Ur 2

A landscaping company has 6 teams servicing landscape jobs. It takes a team 3 hours to complete one job (including travel time and breaks).

Required:

What is the capacity of the landscape company over a 9 hours workday?

Use the Open Excel in New Tab button to launch this question.

12. Cp-Fr-Ct-Ur 3

An expresso coffee cart owner sets up her coffee cart outside a popular department store. She can produce 15 gourmet cups of coffee per hour, but her demand rate is only 12 cups per hour.

Required:

What is the cycle time?

Use the Open Excel in New Tab button to launch this question.

13. Cp-Fr-Ct-Ur 4

The management of a factory which produces shoes has designed a multi-step process (each step is one workstation) that can produce 280 pairs of shoes per day. Assume a 7 hours working day.

Required:

What is cycle time for each workstation?

Use the Open Excel in New Tab button to launch this question.

14. Cp-Fr-Ct-Ur 5

Dave's sandwich ship has an average demand of 140 sandwiches (units) per hour.

Station1 takes the order and prepares the bread.

Station2 applies the meat, cheese and sauce.

Station3 applies the vegies and gets payment from the customer.

Required:

Processing Time

What is the capacity per sec for each Station?

What is the capacity per hour for each Station?

Which Station is the bottleneck?

Demand

What is the process capacity?

What is the flow rate of the process?

What is the cycle time of the process?

What is the utilization rate for each Station?

Use the Open Excel in New Tab button to launch this question.

15. Cp-Fr-Ct-Ur 6

Carol's car detailing shop offers high-end car detaling and a relaxing waiting area. The area in which the shop is located has above average income and the weather is very rainy so there is always unlimited demand. The service process involves five activities which are preformed in the sequence described in the table below. The time for each service activity is given in the cell below the Station#. Carol employs five individuals, one for each service activity station

Activity

Welcome guest and offer refreshing drink

Park car, remove trash and other itmes. Vaccum

Wash and quick wax car. Towel dry. Armoll tires.

Clean glass. Wipe down inside of car

Ring up the gues's bill

Required:

What is the capacity of each employee per minute?

What is the capacity of each employee per hour?

Which employee is the bottleneck?

What is the capacity of the process per hour?

What is the flow rate of the process?

What is the Utilization of each employee?

What is the cycle time?

Use the Open Excel in New Tab button to launch this question.