Please answer all of it, they are all part of the same question.

Marketing Analytics: Setting the Exact Price You are the marketing manager for a sail manufacturing company that produces two sizes of sails: small and large. You are asked to help price the products so that the company is able to make a profit AND the customer is happy. Based on last year's sales, you expect to sell 15,000 small sails and 6,500 large sails in the upcoming year. The accounting department reports a total fixed cost for producing the small and large sails of $750,000 and $800,000 respectively. The variable cost per small sail is $800 while the variable cost per large sail is $1,200. Your pricing objective surrounds maximizing profit. Because of this, you have a target return on investment of 30% profit for each sail. Consider the following formulas as you proceed forward on this exercise: Markup on cost percentage =( Markup Cost )100 Average cost of a single unit = All costs Total number of units Target return price per unit =[( Fixed Costs + Target Return ) Units ]+ variable cost per unit Complete the spreadsheet below and use it to answer the questions that follow. This activity is important because marketing managers benefit from understanding how optimal price is calculated in order to set an exact price for an offering. The goal of this activity is for you to demonstrate an understanding of the role of price and apply different pricing tactics and strategies to a pricing model. (You must (1) complete the spreadsheet and (2) answer the questions that follow to receive full credit for this exercise.) 1. Based on the data in the spreadsheet above, what is the total cost for small sails? 2. What is the average total cost for a large sail? 3. What would the price of a small sail be with a 30% markup? 4. What would be the total revenue for large sails, considering the usage of a 30% markup on cost (i.e. the markup applied in the nrinr culectionl? (Ploses ralrulate the tntal enct for the larne cail in the came manner in whirh voul calrulater the thtal rnct for 4. What would be the total revenue for large sails, considering the usage of a 30% markup on cost (i.e. the markup applied in the prior question)? (Please calculate the total cost for the large sail in the same manner in which you calculated the total cost for the small sail in the previous question. Be sure to round to whole numbers when making your calculation.) (Click to select) 5. Complete the mini-spreadsheet shown and use it to answer the following question: A10% discount is offered for purchases over 1,000 sails. What would be the total revenue for a purchase of 1,500 large sails (given that the same 30% markup on top of average total cost is being applied)? Assume no additional fixed cost as this order was placed after the expected 6,500 large sails had been sold. (Click to select) 6. Complete the mini-spreadsheet shown and use it to answer the following question: Your manager has increased the price of small sails to $1,275. Assuming the variable and fixed cost have not changed, what is the new percent markup on cost for small sails? Marketing Analytics: Setting the Exact Price You are the marketing manager for a sail manufacturing company that produces two sizes of sails: small and large. You are asked to help price the products so that the company is able to make a profit AND the customer is happy. Based on last year's sales, you expect to sell 15,000 small sails and 6,500 large sails in the upcoming year. The accounting department reports a total fixed cost for producing the small and large sails of $750,000 and $800,000 respectively. The variable cost per small sail is $800 while the variable cost per large sail is $1,200. Your pricing objective surrounds maximizing profit. Because of this, you have a target return on investment of 30% profit for each sail. Consider the following formulas as you proceed forward on this exercise: Markup on cost percentage =( Markup Cost )100 Average cost of a single unit = All costs Total number of units Target return price per unit =[( Fixed Costs + Target Return ) Units ]+ variable cost per unit Complete the spreadsheet below and use it to answer the questions that follow. This activity is important because marketing managers benefit from understanding how optimal price is calculated in order to set an exact price for an offering. The goal of this activity is for you to demonstrate an understanding of the role of price and apply different pricing tactics and strategies to a pricing model. (You must (1) complete the spreadsheet and (2) answer the questions that follow to receive full credit for this exercise.) 1. Based on the data in the spreadsheet above, what is the total cost for small sails? 2. What is the average total cost for a large sail? 3. What would the price of a small sail be with a 30% markup? 4. What would be the total revenue for large sails, considering the usage of a 30% markup on cost (i.e. the markup applied in the nrinr culectionl? (Ploses ralrulate the tntal enct for the larne cail in the came manner in whirh voul calrulater the thtal rnct for 4. What would be the total revenue for large sails, considering the usage of a 30% markup on cost (i.e. the markup applied in the prior question)? (Please calculate the total cost for the large sail in the same manner in which you calculated the total cost for the small sail in the previous question. Be sure to round to whole numbers when making your calculation.) (Click to select) 5. Complete the mini-spreadsheet shown and use it to answer the following question: A10% discount is offered for purchases over 1,000 sails. What would be the total revenue for a purchase of 1,500 large sails (given that the same 30% markup on top of average total cost is being applied)? Assume no additional fixed cost as this order was placed after the expected 6,500 large sails had been sold. (Click to select) 6. Complete the mini-spreadsheet shown and use it to answer the following question: Your manager has increased the price of small sails to $1,275. Assuming the variable and fixed cost have not changed, what is the new percent markup on cost for small sails