Quantitative Analysis Problems: Problem 1 (7 total points) Product A, B, & C are all produced on Line 1 in Oakbrook, Illinois. Product A, B, & C are all produced at the same rate (5,000 lbs per day) Yearly Growth Current Year Demand Rate Line 1 Yearly Restricted Days Maintenance: 30 days Product A 400,000 lbs 8% Product B 8% Holidays: 10 days 400,000 lbs 400,000 lbs Product C -15% Sanitation: 10 days 1. Your organization needs to know when to invest in an additional manufacturing line. As a rule, when total utilization exceeds 85%, additional capacity is required. Using the information above: A. Create a table that shows total demand, total capacity, and % utilization per year for the next eight years. B. Determine if a line expansion is needed if so, in what year? C. If maintenance days are reduced from 30 to 15 per year, how does that change the answer to part B