Exercise 1(50) You are planning ot utilize the Christmas season by selling seasonal products. You have 5 different resources that you will utilize to make 4 products. The demands (units/month) and revenues (S/unit) for the four products are the following: Demand (units/month) Revenue (S/unit) Product 1 80 50 Product 2 100 65 Product 3 120 30 Product 4 100 50 Not every product goes through each resource for processing. The time needed to process a specific product at a resource (in case it processes it) is provided below: Processing time (hours/unit) Resource 1 Resource 2 Resource 3 Resource 4 Resource5 Product 1 2.5 - 1 Product 2 2 2.5 Product3 2 1 Product 4 0.5 Because this si the holiday season, you are willing to put 10 hours of work each day. You plan to work for 25 days in a month. • • • • • Which resource si the bottleneck? What are the actual flow rates of the four products? (10) Suppose you are the only worker ni your factory. By choosing to work in this enterprise you are giving up the opportunity to earn at least $18/hour in a local shop. Consider this as the wage you could earn. What si the cost of direct labor? Do you have to make a distinction for the specific flow unit that is coming out? How would your answer change if you hire two more friends to do the work (total of three workers). Assuming each of the friends also have a wage of $18/hour, how would your approach to the calculation of cost of direct labor change? Assume that processing times remain the same. There is more than one way ot approach the problem. Use your imagination to get the answer. I will be looking for consistency ni logic, and appropriate use of formulas. (10) You have invested $1000 ot install the resources. What si your profit per month when you are the only worker? Do you have to adjust the flow rates of the various products to find the profit? If so, how? (10) How wil you improve productivity? How wil your profit be affected based on the changes? Implementing these changes is not costless. What is the most you wil pay (to hire a consultant) ot ensure that your profits are no less than without engaging in process improvement? Feel free to make up your own numbers, if needed. (10) Suppose that the demands for the products are not known with certainty. In fact, based on prior experience you know that the demand can vary by 20% (either more or less). How wil your approach ot the previous four questions change, if this si the case? (10)
Exercise 1(50)
In this exercise, we are given a scenario where we are selling seasonal products during the Christmas season. We have five resources that we will utilize to make four products, and the demands and revenues for each product are provided. The processing time for each product at each resource is also given. Our factory will operate for 25 days in a month, and we will work for 10 hours each day.
To find the resource that is the bottleneck, we need to identify which resource has the longest processing time for any of the products. In this case, the longest processing time is 2.5 hours per unit for Resource 1 for Product 1. Therefore, Resource 1 is the bottleneck.
To determine the actual flow rates of each product, we should calculate the total number of units that can be processed through the bottleneck resource in a month. The formula for this is as follows:
Actual flow rate = Demand / (Processing time per unit at bottleneck resource * Number of working hours per day * Number of working days per month)
Let's apply this formula to our scenario. The processing time per unit at the bottleneck resource for each product is 2.5 hours per unit for Resource 1 for Product 1. Therefore, we have:
Note: Since the Processing time for Product 4 is in hours per 0.5 unit, I converted it to 1 unit (by multiplying 0.5) in the formula above.
We can now calculate the actual output for each product per week and per month. For example, consider Product 1:
Exercise 1(10)
Suppose we are the only worker in the factory, and we could earn at least $18/hour in a local shop. By taking this job, we are giving up this opportunity. This wage can be considered as the wage paid for direct labor. Since we are the only worker, we do not have to distinguish between specific flow units that come out.
Assuming that adding more workers (two friends) to the factory will not change the processing times, and their wage is also $18/hour, the approach to calculating the cost of direct labor will not change. However, since we have added two more workers, the direct labor cost will increase by $72/hour (2 workers x $18/hour).
Exercise 1(10)
We have invested $1000 to install the resources. Let's calculate the profit per month by subtracting the cost of direct labor, the cost of indirect labor, expenses, and the depreciation of the resources from the net revenue. Let's assume that the cost of indirect labor and expenses remain the same, regardless of the number of workers. The net revenue for each product is calculated as follows:
Net revenue = Demand x Revenue per unit
Let's apply this formula to our scenario:
Let's calculate the profit per month:
Profit = Net revenue - Cost of Direct Labor - Cost of Indirect Labor - Expenses - Depreciation
Let's assume that the total cost of indirect labor and expenses is $5000/month. Also, let's assume that the depreciation for the resources is $833.33/month. Substituting these values into the formula for profit:
Profit = (Net revenue - Cost of Direct Labor) - Cost of Indirect Labor - Expenses - Depreciation
Profit = Net Revenue - (Direct Labor Cost + Cost of Indirect Labor + Expenses + Depreciation) Profit = (Product 1 Net Revenue + Product 2 Net Revenue + Product 3 Net Revenue + Product 4 Net Revenue) - (Total Direct Labor Cost + Cost of Indirect Labor + Expenses + Depreciation)
Let's calculate the profit per month:
Profit = (Product 1 Net Revenue + Product 2 Net Revenue + Product 3 Net Revenue + Product 4 Net Revenue) - ($12600 + $5000 + $3000 + $4000)
Profit = $19100 - $25600 Profit = $6500/month
So, our profit per month when we are the only worker is $6500.
Exercise 1(10)
To improve productivity, we could consider various options such as hiring more workers, improving the efficiency of our resources, or streamlining our procedures. Let's assume that by implementing these changes, we can reduce the processing time for each product at each resource by 20%, while keeping the total number of working hours per day the same.
Let's first recalculate the bottleneck resource and the actual flow rates for each product based on the new processing times. We can find the new processing time for each product at each resource by reducing the old processing time by 20%.
Let's identify the resource that has the longest processing time for any of the products with the new processing times. The longest processing time is now 2.0 hours per unit for Resource 1 for Product 1, instead of 2.5 hours per unit. Therefore, Resource 1 is still the bottleneck.
Let's calculate the actual flow rates of each product based on the new processing times. The formula is the same as before, except now we use the new processing times:
Let's calculate the profit per month with the new actual flow rates:
Profit = (Product 1 Net Revenue + Product 2 Net Revenue + Product 3 Net Revenue + Product 4 Net Revenue) - ($12600 + $5000 + $3000 + $40
wallstreetmojo.com
freshbooks.com
online.hbs.edu