First:

Apply the appropriate statistical methods used in business planning for quality, inventory, and capacity management on the given scenarios below.

First scenario:

The following table represents the production capacity for Aqua factory and its subsidiary to $$gulf company$,$ business over the first five months of $2018$

Instructions:

$$ Use the given data in order to forecast and plan the production capacity for June by applying the appropriate statistical methods such as moving averageand Na$$ve$.$

$$ Based on the given data, Find the acceptable level of production capacity to be hold in relation to total quantity of inventory $2400$ units. Your planning should base on the appropriate statistical methods such as measures of forecasting using by simple linear regression $($using Excel$).$

Na$$ve Approach:

Production capacity $($June $)$:

Quantity of inventory $($June$)$ :

Moving Average approach:

Production capacity $($June $)$:

Quantity of inventory $($June$)$ :

Linear Regression $($insert from EXCEL$)$ :

Y $=2400$