plz solve this problem . below is the data.

Cane Study? ( Dhoes Eicyrle Company) Ahou Bicycle Company (RDC), located in Seartle, is a wholesale ditritutor of bicycles and bincle parts. Formed ir 1981 fy Univeriry of Washingron Profestar Yong - Fin ihec, the firm 5 peimary retail outhots are located within a 400 mab radius of the distr bution center. These retal outlets receive the order from 70C within 2 ders after notilying the dintribution center, provided that the stock is available. Hewwever, if anorder is not fulfilied by the company, no backerder is pliced, the tetailers arrange io got then shiprent from other shatritors, and c loyes that ameant of business. The cocmpany distributes a wide variety of bicycles The most popular model, and the major apurce uf reverwe to the company, b the Aur Wing 7BC receves ail the modeh from a single manufactuter in Chitia, and shipment tabes as long as 4 week from the teme an order is placed. With the copt of conienunication, paperwork, and custorns clear ance included, ZEC estinates that each time an order is placed, it incurs a cost of 565 . The parchate price pad by ?BC, per bicycle, in roughly 600 of the suggesied igcal price far all 5170 per bichelen collected for the past 2 years are wumenariced in the following table. A forrcast for ArWing medil salek in 20t9 has been develebed and will be used 1o mele an ifiventery olat for sic Gusstonn 1. Develop an invertocy pion to help zaC 2. Biscuss HOPs and totalsosts 3. Hov can you addess demand that i not at the level of the planines hoizon? Zhou Bicycle Company (ZBC), located in Seattle, is a wholesale distributor of bicycles and bicycle parts. Formed in 1981 by University of Washington Professor Yong-Pin Zhou, the firm's primary retail outlets are located within a 400 -mile radius of the distribution center. These retail outlets receive the order from ZBC within 2 days after notifying the distribution center, provided that the stock is available. However, if an order is not fulfilled by the company, no backorder is placed; the retailers arrange to get their shipment from other distributors, and ZBC loses that amount of business. The company distributes a wide variety of bicycles. The most popular model, and the major source of revenue to the company, is the AirWing. ZBC receives all the models from a single manufacturer in China, and shipment takes as long as 4 weeks from the time an order is placed. With the cost of communication, paperwork, and customs clearance included, ZBC estimates that each time an order is placed, it incurs a cost of $65. The purchase price paid by 2BC, per bicycle, is roughly 60% of the suggested retail price for all the styles avallable, and the inventory carrying cost is 1% per month ( 12% per year) of the purchase price paid by BC. The retail price (paid by the customers) for the AirWing is $170 per bicycle. ZBC is interested in making an inventory plan for 2019. The firm wants to maintain a 959 service level with its customers to minimize the losses on the lost orders. The data collected for the past 2 years are summarized in the following table. A forecast for AirWing model sales in 2019 has Questions 1. Develop an inventory plan to help ZBC that each time an order is placed, it incurs a cost of $65. The purchase price paid by ZBC, per bicycle, is roughly 60% of the suggested retail price for all the styles available, and the inventory carrying cost is 1% per month ( 12% per year) of the purchase price paid by ZBC. The retail price (paid by the customers) for the AirWing is $170 per bicycle. ZBC is interested in making an inventory plan for 2019. The firm wants to maintain a 95% service level with its customers to minimize the losses on the lost orders. The data collected for the past 2 years are summarized in the following table. A forecast for AirWing model sales in 2019 has been developed and will be used to make an inventory plan for ZBC. Questions 1. Develop an inventory plan to help ZBC. 2. Discuss ROPs and total costs. 3. How can you address demand that is not at the level of the planning horizon