This is all about Perpetual order method. Answer what is required and compile the answer in the excel and provide screenshots. Show solutions thank you and Godbless.

Question # 1: Happy Lang Restaurant, uses the perpetual order method for its nonperishable foods. Given the following information, determine the reorder point and the reorder quantity for each of the following items. Add 50 percent to the amount you calculate as the amount needed until delivery as a safety factor when Requirement #1: Determine the reorder Canned Tomato Juice point for each of the following items Requirement # 2: Determine the reorder Normal Usage (Cans ) 2 quantity for each of the following items Time to get delivery Requirement #3: Determine the reorder (Days) 5 quantity including safety stock Par Stock 24 ILLUSTRATE YOUR SOLUTION AND ANSWER Number of Cans to ca 6 IN THE NEXT TAB Canned Peaches Normal Usage (Cans ) 3 Time to get delivery (Days) 4 Par Stock 36 Number of Cans to ca 12 Canned Black Olives Normal Usage (Cans Time to get delivery (Days) 5 Par Stock 12 Number of Cans to ca 12