please double check my work, if anything is wrong specify what is wrong and show me how you got the correct answer, please use excel formulas. tell me what formulas you ise to get the correct answer. thank you in advance

It is now February and management is looking ahead to the summer tourist season. Sweetwater's management is considering adding a new item to its current assorted box of chocolates. The new item would be a cherry cordial (i.e., chocolate covered cherry) using Colorado cherries. Management believes that including two different chocolates from Colorado sources (peaches and cherries) will make the product more marketable to tourists. Three (3) cherry cordials would be included in each box of assorted chocolates. Management is considering whether it should produce the cherry cordials or outsource production to a local manufacturer. MAKE: If Sweetwater decides to make the cherry cordials and include 3 per box, the incremental estimated variable costs per unit (per box of chocolates) would be: Sweetwater would also have to purchase equipment and make some renovations to the building. These costs would add $2,000 per year of fixed costs as factory-related depreciation. Sweetwater's management believes that it will be able to reduce its cost of variable overhead after the first couple of years of producing the cherry cordials. Sweetwater would include 3 cherry cordials in each box which would allow it to remove 3 pieces of other filled chocolates from the box. Removing 3 pieces will save $1.50 in variable costs per box. If Sweetwater decides to make the cherry cordials and include 3 per box, the incremental estimated variable costs per unit (per box of chocolates) would be: Sweetwater would also have to purchase equipment and make some renovations to the building. These costs would add $2,000 per year of fixed costs as factory-related depreciation. Sweetwater's management believes that it will be able to reduce its cost of variable overhead after the first couple of years of producing the cherry cordials. Sweetwater would include 3 cherry cordials in each box which would allow it to remove 3 pieces of other filled chocolates from the box. Removing 3 pieces will save $1.50 in variable costs per box. BUY: Sweetwater can have a local manufacturer produce the cherry cordials using Sweetwater's recipe and production guidelines at a cost cordials using Sweetwater's recipe and production guidelines at a cost of $0.45 each ( $1.35 for the 3 cherry cordials per box). Sweetwater will also incur an additional $.75 of direct labor costs per box if it buys the cherry cordials because someone will have to unpack them from the manufacturer and manually put 3 pieces in each box of chocolates. Required: (A.) Prepare a make or buy analysis of costs for the cherry cordials. NOTE: Prepare the analysis for an entire year with sales of 25,000 units. (B.) How would you advise Sweetwater's management on the make-or-buy decision? Explain. Sweetwater should make because it will save them $2000. =J15-K15 Sweetwater should make beca