D E G H K M Problem 1 (12 points) Management of the Toys R4U Company needs to decide whether to introduce a certain new novelty toy for the upcoming Christmas season, after which it would be discontinued. The total cost required to produce and market this toy would be $500,000 plus $15 per toy produced. The company would receive revenue of $35 for each toy sold. A. Complete the breakeven excel model provided in the Problem 1 worksheet. (10 pts) B. Based on the breakeven results, what is the minimum number of units will the company have to sale to not lose money? (5 pts) C. How much revenue will be generated at this minimum number of units? (5 pts)File Home Insert Draw Page Layout Formulas Data Rev H14 X A B Problem 1 2 Known parameters: 3 Selling price per unit 4 Fixed cost Problem 1 (12 5 Variable cost per unit Management upcoming Chri 6 toy would be A. Complete 7 Input Data 8 Number of units B. Based on 9 money? (5 pt 10 Results How mu 11 Total revenue 12 Fixed cost 13 Total variable cost 14 Total cost 15 Profit 16 BEP 17 BEP$ 18 19 20 21 Problem 1 Problem 2 Problem 4 Ready O X Accessibility: Investigate Type here to search