Working out of excel. trying to use the table/ data to figure out "Ri" and "Ro" as well as total back orders for system.

Table: Team Results for 10 weeks Table: Team Results for 10 weeks Scenario Consider the flow dugram below to represent the flow at the retailer. The flow unit is cases of ebeer. Ri = demanded cases per week. Ro = actual sales per week. So, inventory (T) is the demand not met, or bockorders. The data for 10 weeks of sales is shown in the table above for this eBect team. 1710 Enter the data for the Ri, Ro and I below. Table: Team Results for 10 weeks Table: Team Results for 10 weeks Scenario Consider the flow dugram below to represent the flow at the retailer. The flow unit is cases of ebeer. Ri = demanded cases per week. Ro = actual sales per week. So, inventory (T) is the demand not met, or bockorders. The data for 10 weeks of sales is shown in the table above for this eBect team. 1710 Enter the data for the Ri, Ro and I below