****** Need answers for excel workbook provided down bellow, Thanks!!*****

Silva Chairs, Inc. makes two types of chairs. Model Diamond is a high-end product designed for professional offices. Model Gold is an economical product designed for family use. Jane Silva, the president, is worried about cut-throat price competition in the chairs market. Her company suffered a loss last quarter, an unprecedented event in its history. The company's accountant prepared the following cost data for Ms. Silva: Direct Cost per Unit Direct materials Direct labor Model Diamond (D) $45 per unit $24/hour x 2 hours production time Model Gold (G) $30 per unit x 1 hour production time $24/hour Category Unit level Batch level Product level Facility level Total Estimated cost $ 300,000 750,000 450,000 500,000 $2,000,000 Cost Driver Number of units Number of setups Number of TV commercials Number of machine hours Use of Cost Driver D: 15,000 units; G: 35,000 units D: 104 setups; G: 146 setups D: 5; G: 10 D: 1,500 hours; G: 3,500 hours The market price for office chairs comparable to Model Diamond is $180 and to Model Gold is $110. Facility Total Mach. Hrs. Facility Total Facility Total 5 SILVA CHAIRS, INC. 6 7 a. Overhead cost allocation ur 8 Unit Batch Product 9 Cost pool 10 Cost driver # of Units # Setups # Comm. 11 12 Base rate 13 14 15 Overhead Allocation 16 Model Diamond Unit Batch Product 17 Weight 18 x Rate 19 Allocation 20 No. of Units 21 Cost / Unit 22 23 24 Overhead Allocation 25 Model Gold Unit Batch Product 26 Weight 27 x Rate 28 Allocation 29 No. of Units 30 Cost / Unit 31 32 33 34 Cost Per Unit Direct Direct Allocated 35 Type of Product Materials Labor Overhead 36 Model Diamond 37 Model Gold 38 39 40 b. Price per unit under proposal 41 42 Batch-Level Cost Per Unit 43 Type of Product Batch Rate No. of Batches No. of Units 44 Model Diamond 45 Model Gold 46 47 48 Total Overhead Per Unit 49 Type of Product Unit Batch Product 50 Model Diamond 51 Model Gold 52 53 54 Cost Per Unit Direct Direct Allocated 55 Type of Product Materials Labor Overhead 56 Model Diamond 57 Model Gold 58 Total Batch-Level Cost/Unit Facility Total Total