must show excel formulas on each question. thanks!!

decided in 20x1 to begin manufacturing and seling small wooden canoes decorated with symbols hand painted by Native americans living near the park, Due to the zreat success of the canoes, the hotel began manufacturing and selling paddles as well in 203. Many hotel guests purchase a canoe and paddles for use in sel.guided tours of swiftcurrent Lake. Because production of the two products began in different years, the canoes and paddles are produced in separate production faclittes and employ different laborers. Each canoe selis for 5750 , and each paddle sells for 575 . A 20x3 fire destroyed the hotel's accounting records. Howevec, a new syitem put into place before the 20x4 season provides the following : 3. aprrefated data for the hotel's canoe and paddle manufacturing and marketing activities: The hotel's accounting system data show an average sales mix of approximately 500 cances and 1,250 paddles each season. $ignif cantly more paddles are sold relative to canoes because some inexperienced canoe guests accidentally break one or more paddles, while other guests purchase additonal paddies as presents for friends and relatives, in add tion, for this multiple-product CVp analysis, assume the eristence of an additsonal $40,000 of common fixed costs for a customer service hotiane used for both canoe and paddle customers. Use CVP analysis to calculate 28 the break-even point in units for both the canoe and paddle product lines combined (i.e. the multiple-product settingi. Calculate the hoter's marzin of safety (both in units and in sales dollars) for Many Glacier Motel, assuming the same facts as in Requrensent z, and Q2. assuming that it sells 350 canoes and 4,300 paddes next vear, 63. Show formulas 64 Planned sales tor canoes aso 65 Planned sales for paddles 4,300 66 MOS units above BE units. 67 MOS an sales dollass Be. 47 70. decided in 20x1 to begin manufacturing and seling small wooden canoes decorated with symbols hand painted by Native americans living near the park, Due to the zreat success of the canoes, the hotel began manufacturing and selling paddles as well in 203. Many hotel guests purchase a canoe and paddles for use in sel.guided tours of swiftcurrent Lake. Because production of the two products began in different years, the canoes and paddles are produced in separate production faclittes and employ different laborers. Each canoe selis for 5750 , and each paddle sells for 575 . A 20x3 fire destroyed the hotel's accounting records. Howevec, a new syitem put into place before the 20x4 season provides the following : 3. aprrefated data for the hotel's canoe and paddle manufacturing and marketing activities: The hotel's accounting system data show an average sales mix of approximately 500 cances and 1,250 paddles each season. $ignif cantly more paddles are sold relative to canoes because some inexperienced canoe guests accidentally break one or more paddles, while other guests purchase additonal paddies as presents for friends and relatives, in add tion, for this multiple-product CVp analysis, assume the eristence of an additsonal $40,000 of common fixed costs for a customer service hotiane used for both canoe and paddle customers. Use CVP analysis to calculate 28 the break-even point in units for both the canoe and paddle product lines combined (i.e. the multiple-product settingi. Calculate the hoter's marzin of safety (both in units and in sales dollars) for Many Glacier Motel, assuming the same facts as in Requrensent z, and Q2. assuming that it sells 350 canoes and 4,300 paddes next vear, 63. Show formulas 64 Planned sales tor canoes aso 65 Planned sales for paddles 4,300 66 MOS units above BE units. 67 MOS an sales dollass Be. 47 70