Please help show work on excel.

NextPC, Inc. manufactures and sells desktops and notebooks. All components of the computers, with the exception of monitors, are produced in the company. The monitors are purchased from Bay Electronics Co. The company's annual requirements total 16,320 units, and the price per unit is $52.5. NextPC does not purchase in greater quantities because Bay Electronics, the supplier, does not offer quantity discounts. There are practically no shortages of monitors because Bay Electronics always meets the delivery schedule. Associated with the purchase of each shipment is the ordering cost of $875 per order. In addition to ordering cost, NextPC incurs inventory carrying cost that is equal to $254 per unit per year. Beginning in August of this year, management of NextPC, Inc. will embark on a company-wide cost control program in an attempt to improve its profits. One of the areas to be closely scrutinized for possible cost savings is inventory planning. One of the alternatives will be to evaluate the effectiveness of the current system of purchasing monitors, improve the current system, and continue purchasing monitors with improved inventory policy. However, over the past few months, the company's production capacity has been expanded. As a result, excess capacity is now available in certain production departments, and management is also considering the alternative of producing monitors inside the company. The production capacity (production rate) for monitors is available at the rate of 980 monitors weekly. It is felt that with a two- week lead time, schedules can be arranged so that the product can be produced whenever needed. All parameters of this production will be constant; shortages will not be allowed; production costs are expected to be $64 per monitor; and setup cost is $799 per set up of equipment for producing monitors. Questions 1. Identify NextPC's optimal inventory policy of outsourcing monitors from Bay Electronics Co. You need to calculate the optimal order quantity and annual total cost of inventory. Explain your results. 2. In case NextPC starts to produce monitors internally, identify the best inventory policy by calculating the optimal order quantity and annual total cost of inventory. Explain your results. (Hit: consider that the NexPC operates all 52 weeks a year). Make a recommendation as to whether the company should outsource (purchase) monitors from Bay Electronics Co. or to produce them internally. What is the savings associated with your recommendation as compared with the other option described? 3