Please use excel formulas and work used

Golden Trophy Inc. manufactures trophies and other promotional awards. The company uses an extrusion process in which metals and plastic are molded into a metal base of different sizes and shapes. Managers can either sell the unfinished base to other trophy companies, or incur additional conversion costs to convert it into a finished trophy. The cost incurred to produce the metal bases is $360,000, which is allocated to the products based on the sales value of the metal base. Following is information concerning the products that can be produced: Selling Price of Selling Price of Additional Number of Units the Metal Vase the Finished Trophy Processing Cost Product Trophy A 4,500 $105.00 $110.80 $46,200 Trophy B 6,200 92.00 118.50 85,500 Trophy C 980 124.30 146.50 22,450 Required: 1. Which costs are relevant to the decision to sell or process further? 2. Which products should be sold as an unfinished base and which should be further processed? 3. Assume that the $360,000 in costs is allocated based on the number of units of output. Which products should be sold as an unfinished base and which should be further processed? Chapter 7 Lab PB 7-2 & 7 pps 342 & 345 Q Search Sheet Home Insert Page Layout Formulas Data Review View + Share a Insert Calibri (Body) 12 A- A+ Wrap Text General 49: Delete Paste ,00 I B Merge & Center $ % > .00 0 HI Conditional Format Formatting as Table Sort & Filter Styles Format E15 A x foc A B C D E F G H 1 J L M N 0 P Create your own solution format considering incremental revenues and incremental costs! Inc Rev Inc. Cost 1 Chapter 7 Lab - PB 7-7, page 345 2 3 4 5 Given Data: 6 7 Production cost for metal bases $360,000 8 9 Product Units SP of Vase SP of Trophy Incremental Costs 10 Trophy A 4500 $105 $110.80 $46,200 11 Trophy B 6200 $92 $118.50 $85,500 12 Trophy C 980 $124.30 $146.50 $22,450 13 14 14 15 15 16 17 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Problem 1 Problem 2 + Enter + 100%