Can the solution be solved in the format of the tables below in question

Question.3 The MVA Pet Food Company distributes one of its products, Gro-Pup, through warehouses in Seattle and Portland. A central warehouse at the St. Louis plant distributes Gro-Pup to these two warehouses in serving the Northwest regional market. a) Develop a distribution schedule for the two warehouses and a production schedule for the plant for the next 8 week period. The sales forecast for this product is 20 units at the Seattle warehouse and 43 units of the product are currenth on hand. The shipment order quantity is 60 units, planned shipment lead time is one week and there are no safety stock requirements. Similar information is included for the other two locations. The product is packed in lots of 50 units at St. Louis; the packaging process takes two wreeks. b) Each Gro-Pup package requires one unit of packaging material. Develop a purchasing schedule for the packaging material assuming i) There are currently 25 units on hand ii) An open order for 100 units is due to be received from the vendor next week iii) The purchase order quantity equals 100 units iv) Purchasing lead time is four weeks. Solution Part al