INSTRUCTIONS: Answer the $8$ questions below $(15$ points$).$ Please provide details of calculations next to the respective questions $($i$.$e$.$ not just the final answer$).$ You can create the appropriate columns. If you prefer to complete this manually rather than in Excel, please upload the document into the dropbox.

Sales for XYZ running shoes

$\backslash$table$[[,$Population,Product Sales,Total category sales$],[$Region$,10,400,277,1939],[$New England,$33,400,1,031,8000],[$Mid Atlantic,$25,600,919,7000],[$East Central,$29,200,478,6536],[$West Central,$38,000,1,054,10111],[$South East,$21,900,579,5000],[$South West,$36,400,671,4890],[$Pacific$,,,]]$

Based on the data above:

Q$2.$ What is the worst market for the product category and why? $(2$ pts$)$

Q$3$: What would your advice be $--$ regarding the Pacific market $-$ to a product manager allocating resources between these markets? $(2$ pts$)$

$\backslash$table$[[$Magazines$,\backslash$table$[[$Cost for full$],[$page color$],[$ad$]],$Circulation $(\text{'}000$s$)],[$A$,$$$54,000,165],[$B$,$$$33,000,116]]$

Q$4.$ What is the most cost$-$efficient magazine for our target audience? Mention the term used for cost$-$efficiency of print media $(3$ pts$)$