$($Please use excel for solution and add picture from excel on answer section.$)$

Alvarez and Takamine are two Japanese guitar companies that share a distribution and logistics hub for handling and shipping guitar orders to a major online retailer in North America. Uncorrelated Demand and related data profiles for each of the four guitar products at the Osaka Global Distribution Center are listed below. Any shipment has a common order cost of $$1300$ to the retailer's North American warehouse. Show the cost savings that could be achieved if packaging and shipping services could be aggregated for the four products listed below if the company spends $$80,000$ per year $($every $12$ months$)$ to stage the facility for this function. Based on your analysis, should the companies proceed with the plan to perform this type of service? Please report lot sizes, order frequency $($flow time$),$ and costs for independent and joint ordering conditions to justify your analysis.

$\backslash$table$[[,\backslash$table$[[$A$2204],[$Prestige$]],\backslash$table$[[$RG$550],[$Genesis$]],\backslash$table$[[$Artist$],[$Pro$]],\backslash$table$[[$ES$-445],[$Premier$]]],[\backslash$table$[[$Forecast$],[$Demand$],[($Monthly$)]],10,000,15,500,8,500,3,650],[\backslash$table$[[$Product$-$specific$],[$order cost$]],$$$150,$$$100,$$$250,$$$350$