Hi,

Please help solve the below questions.

The solution spreadsheet is already provided below the question.

Thank you.

DATA INPUT Monthly capacity 10000 medals per month Current production 7500 medals per month Price per meda $ 175.00 Variable Costs Manufacturing Direct Labor 375,000 Direct Material $ 262,500 Marketing $ 187,500 Total Variable Costs $ 825,000 Fixed Costs Manufacturing $ 275,000 Marketing 175,000 Total Fixed Costs $ 450,000 Total Costs $ 1,275,000 Variable cost per unit 1 10.00 Fixed cost per unit 60.00 Average unit cost 170.00 Special Order 2500 medals ordered $100 per medal SOLUTION Current Monthly Production Special Order combined production Units produced Sales Variable costs Direct labor Direct material Marketing Total Variable Costs Fixed Costs Manufacture Marketing Total Fixed Costs Total Costs Income before tax Cost per units Variable Fixed Average unitcostWinner's Circle, Inc. manufactures medals for winners of athletic events and other contests. Its manufacturing plant has the capacity to produce 10,000 medals each month. Current monthly production is 7,500 medals. The company normally charges $1]; /per medal. Variable costs and fixed costs for the current activity level of 75 percent of capacity are as follows: Production Costs Variable Costs: Manufacturing: Direct labor 3': 375,000 Direct material 262,500 Marketing 187,500 Total variable costs 35 825,000 Fixed Costs: Manufacturing $ 275,000 Marketing 175,000 Total fixed costs $ 450,000 Total costs M Variable cost per unit $ 110 Fixed cost per unit 60 Average unit cost 5 170 Winner's Circle has just received a special one-time order for 2,500 medals at $100 per medal. For this particular order, no variable marketing costs will be incurred. Cathy Donato, a management accountant with Winner's Circle, has been assigned the task of analyzing this order and recommending whether the company should accept or reject it. In a Word Document: 1. Identify and explain the costs that will be relevant to Cathy Donato's analysis of the special order being considered by Winner's Circle, inc. 2. Determine if Winner's Circle should accept the special order. In explaining your answer, compute both the new average unit cost and the incremental unit cost for the special order. See Part 4 below. 3. Discuss any other considerations that Donato should include in her analysis of the special order. 4. Using the spreadsheet provided in the Assignment, construct an Excel spreadsheet to solve requirement 2