please help me answer these questions

Question 2 - 10 points CSL Seqirus is the worlds largest manufacturer of flu vaccine. Their largest plant is in Holly Springs, NC. The table below gives the total number of vaccine doses (in millions) that CSL must manufacture each month to satisfy its promised shipments. CSL must also have 40 million doses on hand in inventory at the end of Julv. - The Holly Springs plant uses a LEVEL production plan. How many doses (in millions) should the plant manufacture in each of the 4 months to meet forecasted demand and the ending July inventory requirement? Put your answer here and show me how you got the number. Using an Excel formula that I can see when I click on the box is fine. Correct answer with no work or associated Excel formula gets no credit. Question 3 - 32 points Let's return to Question 2. Forecasted demand and required July ending inventory are indicated in the first table below in the blue cells. Regular-time production is limited to 55 million doses per month. Additional production can be met using overtime but overtime production is limited to 10 million doses per month. The ending inventory level for July MUST be 40 million doses Regular-time production cost is $5 thousand per million doses. Overtime production cost is $6 thousand per million doses. Inventory carrying cost is $1.5 thousand per million doses per month and is based on AVERAGE monthly inventory. Common sense info: Overtime production cost is more than regular-time production cost so use all of your regular-time before you dip into overtime. Instructions: In the table below, set values for regular-time production and overtime production (peach colored cells). Given these production quantities, determine monthly beginning inventory, ending inventory, average inventory for each month. 40 ivote: All quantities are in milions Fill in ALL costs associated with vour plan in the table below. Note: All costs are in thousands