Archives: Solution Manual

Problem 14-50 Name: Insert your answers into the gray-shaded cells. If an answer is incorrect, the word “wrong” will appear. a. ÷ Total time = MCE 62,000 30% b. Process productivity 18,600 55.00 units per hour c. Process quality yield […]

Problem 14-44 Name: Insert your answers in the gray-shaded cells. If an answer is incorrect, the word “wrong” will appear. a. Sales 28,250,000$ Less operating expenses 25,885,000 Actual income 2,365,000$ Beginning assets 10,200,000$ Ending assets 12,300,000 Total assets 22,500,000$ Divided […]

Exercise 14-34 Name: Insert your answers into the gray-shaded cells. If an answer is incorrect, the word “wrong” will appear. a. ÷ Total time = MCE 25,000 61% b. Process productivity 15,160 6.89 units per hour c. Process quality yield […]

Exercise 14-33 Name: Insert your answers into the gray-shaded cells. If an answer is incorrect, the word “wrong” will appear. a. ÷ Total time = MCE 144,000 35% b. Process productivity 50,300 68.79 units per hour c. Process quality yield […]

Exercise 14-32 Name: Insert your answers into the gray-shaded cells. If an answer is incorrect, the word “wrong” will appear. a. ÷ Total time = MCE 2,750 23.64% b. Process productivity 650 1,141.6 units per hour c. Process quality yield […]

Problem 13-58 Insert your answers in the gray-shaded cells. Enter answers as formulas where appropriate. If an answer is incorrect, the word “wrong” or an asterisk “*” will appear. a. Administrative Costs : Base: 800 Cost: 2,130,000$ % of Base […]

Problem 13-56 Name: Insert your answers in the gray-shaded cells. Enter amounts to be subtracted as negatives. If an answer is incorrect, the word “wrong” will appear. Answers will differ slightly than printed solution due to greater precision of Excel. […]

Exercise 13-31 Name: Insert your answers in the gray-shaded cells. Insert amounts to be subtracted as negatives. If an answer is incorrect, the word “wrong” will appear. Type equation to show how much cost is allocated to each department S1 […]

Exercise 13-30 Name: Insert your answers in the gray-shaded cells. If an answer is incorrect, the word “wrong” will appear. Administration HR Accounting Administration – 0.10 0.10 Human resources 0.10 – 0.10 Accounting 0.10 0.10 – Checking 0.30 0.30 0.40 […]

Exercise 13-28 Name: Insert your answers in the gray-shaded cells. Insert formulas where appropriate. If an answer is incorrect, the word “wrong” will appear. Amount x Percent = Allocation Administration: Personnel 540,000$ 10% 54,000$ Accounting 540,000 10% 54,000 Checking 540,000 […]

Exercise 13-27 Name: Insert your answers in the gray-shaded cells. Insert formulas where appropriate. If an answer is incorrect, the word “wrong” will appear. Checking: Administration 202,500$ Personnel 135,000 Accounting 150,000 Direct costs 630,000 1,117,500$ Savings: Administration 270,000$ Personnel 90,000 […]

Exercise 12-13 Name: Insert your answers into the gray-shaded cells. Insert formulas in the answer cells of the table. If an answer is incorrect, the word “wrong will appear. Firm A Industry Average Net income 27% 10% Advertising 2% 17% […]

Problem 11-47 Name: Insert your answers into the gray-shaded cells. Enter formulas where appropriate. Enter amounts to be subtracted as negative numbers. If an answer is incorrect, the word “wrong” will appear. a. Joint cost allocation: Checking 464,000$ Credit cards […]

Problem 11-42 Name: Insert your answers in the gray-shaded cells. Select accounts for the journal entries from the drop-down lists. If an answer is incorrect, the word “wrong” will appear. a. Joint Cost Allocation Total Cost Forever 57,713$ 60,893$ Fantasy […]

Exercise 11-28 Name: Insert your answers in the gray-shaded cells of columns D and F. Enter amounts to be subtracted as negatives. Enter answers as formulas where appropriate. If an answer is incorrect, the word “wrong” will appear. a. Joint […]

Exercise 11-18 Name: Insert your answers in the gray-shaded cells of columns B, C, and E. Enter formulas where appropriate. If an answer is incorrect, the word “wrong” will appear. a. Units of output allocation: Total bottles 80,000 Perfume 270,000$ […]

Problem 10-45 Name: Insert your answers in the gray-shaded cells. Enter amounts to be subtracted as negatives. If an answer is incorrect, an asterisk will appear. a. Fixed factory OH costs 350,000$ Fixed regional promo. costs 50,000 Total costs to […]

Problem 10-41 Name: Insert your answers into the gray-shaded cells. Enter amounts to be subtracted as negatives. If an answer is incorrect, the word “wrong” will appear. a. Maximizing the contribution margin per unit of scarce resource: (Direct labor hours […]

Exercise 10-21 Name: Insert your answers in the gray-shaded cells. Enter amounts to be deducted as negatives. If an answer is incorrect, the word “wrong” will appear. a. Individual Estate Corporate Sales price 350$ 1,200$ 750$ Variable costs (50) (200) […]

Exercise 10-17 Name: Insert your answers in the gray-shaded cells. If an answer is incorrect, the word “wrong” will appear. a. Relevant cost to manufacture 4.60$ Relevant cost to buy 4.00 Difference 0.60$ x Units required annually 120,000 Advantage to […]

Problem 9-48 Name: Insert your answers into the gray-shaded cells of columns D, F and H. Insert formulas where appropriate. If an answer is incorrect, the word “wrong” will appear. a. 2013 2014 Sales 600,000$ 960,000$ Less Variable Expense 420,000 […]

Exercise 9-22 Name: Insert your answers into the gray-shaded cells. Enter formulas where appropriate. If an answer is incorrect, the word “wrong” will appear. a. Daily Ferry Usage Daily tolls 1,450$ Divided by cost per passenger 0.50 People using ferry […]

Exercise 9-14 Name: Insert your answers into the gray-shaded cells of column F. If an answer is incorrect, the word “wrong” will appear. Sales 3,000,000$ Less variable costs 2,100,000 Contribution margin 900,000$ Less fixed costs 600,000 Profit 300,000$ Sales 3,000,000$ […]

Exercise 9-9 Name: Insert your answers into the gray-shaded cells of columns E and G. If an answer is incorrect, the word “wrong” will appear. a. Direct materials 150,000$ Direct labor 100,000 Manufacturing overhead 75,000 Total variable production cost 325,000$ […]

Problem 8-54 Name: Insert your answers in the gray-shaded cells of columns D, F, I, and K. Enter amounts to be subtracted as negatives. If an answer is incorrect, an asterisk “*” will appear. Beginning cash bal. –$ (95,000)$ Collections-Schedule […]

Problem 8-48 Name: Insert your answers in the gray-shaded cells of column F. Enter amounts to be subtracted as negatives. Enter formulas where appropriate. If an answer is incorrect, the word “wrong” will appear. a. Production Budget Sales budget 600,000 […]

Exercise 8-28 Name: Insert your answers in the gray-shaded cells of columns D, F, and H. If an answer is incorrect, the word “wrong” will appear. a. January February March Nov. sales 24,900$ – – Dec. sales 22,800 – – […]

Exercise 8-25 Name: Insert your answers in the gray-shaded cells of columns D and F. If an answer is incorrect, the word “wrong” will appear.” a. Production Budget Boxes Trays Total Units of sales 42,000 30,000 72,000$ Units desired in […]

Problem 7-58 Name: Insert or select your answers in the gray-shaded cells. If an answer is incorrect, the word “wrong” will appear. a. Material price variance: Material price variance = AQ x (AP – SP) Aluminum Copper Total Actual price […]

Problem 7-53 Name: Insert your answers in the gray-shaded cells in columns B, D, F, H, and J. If an answer is incorrect, the word “wrong” will appear. a. Actual cost 33.05$ Expected cost (24.00) Cost difference 9.05$ b. Variable […]

Exercise 7-35 Name: Insert your answers in the gray-shaded cells. If an answer is incorrect, the word “wrong” will appear. a. Actual machine hours 442,880$ ÷ 20$ = 22,144 MH MH budgeted 1,000,000$ ÷ 40$ = 25,000 MH MH applied […]

Exercise 7-33 Name: Insert your answers in the gray-shaded cells. If an answer is incorrect, the word “wrong” will appear. a. November production 4,800 Standard materials per bag ×0.50 Total square yards 2,400 b. November production 4,800 Standard labor per […]

Problem 6-58 Name: Insert your answers in the gray-shaded cells of columns C, E, G, and I. If an answer is incorrect, an asterisk will appear. a. Production Data: Units Beginning inventory 8,000 Units started 36,000 Units to account for […]

Problem 6-55 Name: Insert your answers in the gray-shaded cells of columns B, C, E, G, and I. If an answer is incorrect, an asterisk will appear. a. Production Data: Units Beginning inventory 4,000 Units started 21,000 Units to account […]

Problem 6-54 Name: Insert your answers in the gray-shaded cells of columns C, E, G and I. If an answer is incorrect, an asterisk will appear. a. Production Data: Units Beginning WIP inventory 12,000 Units started 90,000 Units to account […]

Exercise 6-46 Name: Insert your answers in the gray-shaded cells of columns E, G and I. If an answer is incorrect, an asterisk will appear. a. Units Material Conversion Beginning inventory 40,000 Pounds started 425,000 Pounds to account for 465,000 […]

Exercise 6-44 Name: Insert your answers in the gray-shaded cells. If an answer is incorrect, an asterisk will appear. Pounds started 120,000 Maximum normal spoilage percentage 8% Maximum normal spoilage allowed 9,600 Units Material Conversion Beginning inventory 36,000 Pounds started […]

Exercise 6-38 Name: Insert your answers in the gray-shaded cells. If an answer is incorrect, an asterisk will appear. a. Fabrication: Beginning WIP inventory 5,000 Beginning WIP inventory 5,000 Started 40,000 Started & completed 33,200 Units accounted for 45,000 Ending […]

Problem 5-47 Name: Insert your answers in the gray-shaded cells of columns C, G, and I. Enter amounts to be deducted as negatives. If an entered answer is incorrect, an asterisk will appear. a-b. Direct material and raw material issued […]

Problem 5-42 Name: Fill in the shaded cells in columns B, C, E, G, and I as appropriate. Enter amounts to be subtracted as negatives. An asterisk (*) will appear if you have entered incorrect data. The journal entry accounts […]

Exercise 5-22 Name: Insert your answers in the gray-shaded cells of columns C, G, and I. Enter amounts to be subtracted as negatives. If an answer is incorrect, an asterisk will appear. a. Direct material 2,850$ Direct labor 800 Applied […]

Exercise 5-18 Name: Insert your answers in the gray-shaded cells of column G. If an amount is to be subtracted, enter it as a negative. If an answer is incorrect, the word “wrong” will appear. a. Cost of goods sold […]

Problem 4-48 Name: Insert your answers in the gray-shaded cells of columns B, E and G. If an answer is incorrect, the word “wrong” will appear. a. Predetermined overhead rate: Budgeted overhead 5,850,000$ Budgeted machine hours 1,000,000 Predetermined overhead rate […]

Problem 4-47 Name: Insert your answers in the gray-shaded cells. If an answer is incorrect, the word “wrong” will appear. a. Utility costs 1,800,000$ ÷ Machine hours 90,000 Utility cost per MH 20$ Scheduling & setup costs 1,638,000$ ÷ Number […]

Problem 4-46 Name: Insert your answers in gray-shaded cells of columns D and F. If an answer is incorrect, the word “wrong” will appear. a. Indirect labor: Department 1 307,000$ Department 2 262,000 Machine 1,200,000 Power 400,000 Building 1,000,000 Purchasing […]

Problem 4-45 Name: Insert your answers into the gray-shaded cells. If an answer is incorrect, the word “wrong” will appear. a. Umbrella: Overhead per unit of umbrellas 24$ Overhead rate per hour ÷30$ Percent of overhead 80% Minutes in an […]

Problem 4-41 Name: Insert your answers in gray-shaded cells. If an answer is incorrect, the word “wrong” will appear. a. Base wages 63,000,000$ Direct labor hours 3,150,000 Base wages per DLH 20.00$ Health care benefit costs 10,500,000$ Average number of […]

Exercise 4-35 Name: Insert amounts in the gray-shaded cells of columns C, E, and G. If an answer is incorrect the word “Wrong” will appear. a. Cost of finding best suppliers 375,000$ Number of phone calls made 75,000 Cost per […]

SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA df SS MS F Significance F Regression 1 6.92E+08 6.92E+08 108.8096 1.62E-05 Residual 7 44489230 6355604 Total 8 7.36E+08 Coefficients Standard Error t Stat P-value […]

Problem 3-43 Name: Fill in the correct data in columns C, E, and G. Then run a regression in Excel. The word “wrong” will appear when incorrect data is input except for the formula because formats may vary. Excel may […]