Please, show with excel and show excel functions and/or steps.

1. Problem One: SmartTek is an electronics company that produces two lines of high capacity flash drives, model J, and model Z. Based on preliminary studies and research, the company expects the demand for model J to be at least 1,000 units per day. In contrast, the demand for model Z is expected to be at least 3,900 units per day. Due to limitations in their manufacturing facility, the company cannot exceed 5,250 units for model J, and 6,785 for model Z respectively. Given their good product designs, the company has a contractual obligation to send at least 6,150 units every day. If the sale of each lot of model J yields a $5,150 profit, and the sale of each lot of model Z results in a $6,210 profit, (a) how many units of each model should SmartTek produce to maximize daily profits? (b) Create a Sensitivity Report and state, both the Reduced Cost, and the Shadow Price, (c) interpret the significance of both, Reduced Cost and the Shadow Price, (d) suppose the company cannot exceed 4,851 units for model J, how does that impact your profit