OVERWORKED INC has 3 resources (Resource A, Resource B and Resource C) in its production process. The production process involves 3 products (Product A, Product B and Product C) being processed through these 3 resources. Currently, there is demand for 900 units of Product A, 1,000 units of Product B and 300 units of Product C per day. The processing times for each product at different resource levels in given in the table below: Product C Product B 0.72 minutes Resource A Product A 0.72 minutes 1.296 minutes 1.296 minutes Resource B Resource C 1.296 minutes 1.296 minutes Product C is not processed at Resource A. Product B is not processed at Resource B and Resource C. Assume that each work day has 24 hours. a) What is the demand rate for Product A per day. b) What is the demand rate for Product B per day c) What is the demand rate for Product C per day IIIII d) Find the daily capacity for Resource A. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. e) Find the daily capacity for Resource B. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. f) Find the daily capacity for Resource C. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. g) Find the implied utilization for Resource A. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. h) Find the implied utilization for Resource B. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. i) Find the implied utilization for Resource C. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. i) What is the highest implied utilization. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. k) Find the maximum daily flow rate of Product A Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. 1) Find the maximum daily flow rate of Product B Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. m) Find the maximum daily flow rate of Product C Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. n) Find the actual daily flow rate of Product A o) Find the actual daily flow rate of Product B Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. p) Find the actual daily flow rate of Product C Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. 9) Find the daily process capacity Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. Assuming that demand for each of the 3 products (Product A, Product B and Product C) changes to 100 units per day, answer the following questions: r) What is the demand rate for Resource A per day s) What is the demand rate for Resource B per day. t) What is the demand rate for Resource C per day. u) Find the daily capacity for Resource A. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. v) Find the daily capacity for Resource B. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. w) Find the daily capacity for Resource C. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. x) Find the implied utilization for Resource A. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. y) Find the implied utilization for Resource B. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. IIIIIIII z) Find the implied utilization for Resource C. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. aa) What is the highest implied utilization. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. ab) Find the maximum daily flow rate of Product A Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. ac) Find the maximum daily flow rate of Product B Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. ad) Find the maximum daily flow rate of Product C Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. ae) Find the actual daily flow rate of Product A Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. af) Find the actual daily flow rate of Product B Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. ag) Find the actual daily flow rate of Product C Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. ah) Find the daily process capacity Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. OVERWORKED INC has 3 resources (Resource A, Resource B and Resource C) in its production process. The production process involves 3 products (Product A, Product B and Product C) being processed through these 3 resources. Currently, there is demand for 900 units of Product A, 1,000 units of Product B and 300 units of Product C per day. The processing times for each product at different resource levels in given in the table below: Product C Product B 0.72 minutes Resource A Product A 0.72 minutes 1.296 minutes 1.296 minutes Resource B Resource C 1.296 minutes 1.296 minutes Product C is not processed at Resource A. Product B is not processed at Resource B and Resource C. Assume that each work day has 24 hours. a) What is the demand rate for Product A per day. b) What is the demand rate for Product B per day c) What is the demand rate for Product C per day IIIII d) Find the daily capacity for Resource A. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. e) Find the daily capacity for Resource B. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. f) Find the daily capacity for Resource C. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. g) Find the implied utilization for Resource A. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. h) Find the implied utilization for Resource B. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. i) Find the implied utilization for Resource C. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. i) What is the highest implied utilization. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. k) Find the maximum daily flow rate of Product A Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. 1) Find the maximum daily flow rate of Product B Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. m) Find the maximum daily flow rate of Product C Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. n) Find the actual daily flow rate of Product A o) Find the actual daily flow rate of Product B Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. p) Find the actual daily flow rate of Product C Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. 9) Find the daily process capacity Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. Assuming that demand for each of the 3 products (Product A, Product B and Product C) changes to 100 units per day, answer the following questions: r) What is the demand rate for Resource A per day s) What is the demand rate for Resource B per day. t) What is the demand rate for Resource C per day. u) Find the daily capacity for Resource A. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. v) Find the daily capacity for Resource B. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. w) Find the daily capacity for Resource C. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. x) Find the implied utilization for Resource A. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. y) Find the implied utilization for Resource B. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. IIIIIIII z) Find the implied utilization for Resource C. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. aa) What is the highest implied utilization. Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. ab) Find the maximum daily flow rate of Product A Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. ac) Find the maximum daily flow rate of Product B Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. ad) Find the maximum daily flow rate of Product C Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. ae) Find the actual daily flow rate of Product A Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. af) Find the actual daily flow rate of Product B Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. ag) Find the actual daily flow rate of Product C Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings. ah) Find the daily process capacity Instructions: Round the final answer to 2 decimal places. Do not round intermediate workings. Use Excel to avoid rounding intermediate workings