Philip wants to use television advertising to maximize his brand exposure so he negotiates an expense reduction to $75,000. How many shirts would he have to sell to achieve a 40 percent profit margin with the reduced expense? Reset the television data to its initial values. Assume Philip wants to run two advertising campaigns. Which advertising campaign should Philip fund in addition to direct mail/refer a friend to balance exposure and profit? Television advertising + Magazine advertising Television advertising + Direct mail/Refer a friend Online advertising + Direct mail/Refer a friend Magazine advertising + Direct mail/kefer a friend Financial Projections and Forecasts for Chemise company: Assignment Instructions: Create a table containing 2-year sales and revenue forecast. Assume that we'll achieve profitability once production exceeds 800,000 shirts. - the breakeven point-early in the second year. Shirts are priced at $120 each. Each case has 10000 shirts. Use the table in the Chemise company description to calculate operating costs. Create a bar graph that compares the two year's sale revenue. Upload a screenshot of your work. Financial Project Table should cohtain the following: - Net Sales projections over the 2 years - Gross Profit projections over the 2 years - Operating profit or loss - Cases Sold Philip wants to use television advertising to maximize his brand exposure so he negotiates an expense reduction to $75,000. How many shirts would he have to sell to achieve a 40 percent profit margin with the reduced expense? Reset the television data to its initial values. Assume Philip wants to run two advertising campaigns. Which advertising campaign should Philip fund in addition to direct mail/refer a friend to balance exposure and profit? Television advertising + Magazine advertising Television advertising + Direct mail/Refer a friend Online advertising + Direct mail/Refer a friend Magazine advertising + Direct mail/kefer a friend Financial Projections and Forecasts for Chemise company: Assignment Instructions: Create a table containing 2-year sales and revenue forecast. Assume that we'll achieve profitability once production exceeds 800,000 shirts. - the breakeven point-early in the second year. Shirts are priced at $120 each. Each case has 10000 shirts. Use the table in the Chemise company description to calculate operating costs. Create a bar graph that compares the two year's sale revenue. Upload a screenshot of your work. Financial Project Table should cohtain the following: - Net Sales projections over the 2 years - Gross Profit projections over the 2 years - Operating profit or loss - Cases Sold