please do both problems

Problem 3. (18 points) The following data were collected f 12 months using a company's sales reports. The report shows, for each month, the amount of money the company spent for advertising (x) and the amount of sales (y) made after those advertising expenditures. Both the advertising and sales dollars are in units of thousand dollars. The Chief Executive Officer of the company is interested in the impact of the advertising spending on the actual sales. (a) Provide the scatter plot for advertising vs sales dollars with the trend line. (4 points) (b) Obtain a linear regression line for the data. (Hint: You need to calculate a and b to get the linear regression equation: y=a+bx) ( 8 points) You need to show all the work in Excel or manually when you computed the line equation. (c) Predict the sales figures in months 13 and 14 if the advertising budgets allocated for months 13 and 14 are $110,000 and $105,000, respectively. (6 points) (b) Obtain a linear regression line for the data. (Hint: You need to calculate a and b to get the linear regression equation: y=a+bx)(8 points) You need to show all the work in Excel or manually when you computed the line equation. (c) Predict the sales figures in months 13 and 14 if the advertising budgets allocated for months 13 and 14 are $110,000 and $105,000, respectively. (6 points) Bonus Problem (6 points) (Bonus points will be added to your homework score). a) A supplier of instrument gauge clusters uses a Kanban system to control material flow. The gauge cluster housings are transported five at a time. A fabrication center produces approximately 16 gauges per hour. It takes approximately two hours for the housing to be replenished. Due to variations in processing times, management has decided to keep 35 percent of the needed inventory as safety stock. How many Kanban card sets are needed? ( 3 points) b) Transmissions are delivered to the fabrication line six at a time. It takes 120 minutes for transmissions to be delivered. Approximately eighteen vehicles are produced each hour, and management has decided that 20 percent of expected demand should be maintained as safety stock. How many Kanban card sets are needed? (3 points)