, SOLUTION MANUAL FOR Excel Companion for Managerial Accounting
Courses Weinstein
Important Notes
The file includes the complete test bank, organized chapter by chapter.
A sample of selected pages has been provided for preview.
All available appendices and Excel files (if included in the original resources) are
provided.
We continuously update our files to ensure you receive the latest and most accurate
editions.
New editions are added regularly – stay connected for updates!
⚠️Note on Answer Keys: If the answer key is not included within the chapter
questions, you will find the complete answers and solutions at the end of each
chapter.
✅ Why Buy From Us?
📚 Complete & organized chapter-by-chapter – no missing content, no guessing.
⚡ Instant digital delivery – get your file the moment you pay, no waiting.
📅 Always up to date – we track new editions so you always get the latest version.
💬 Friendly support – real humans ready to help, anytime you need us.
🔒 Safe & secure – thousands of satisfied students trust us every semester.
🛡️Our Guarantees
💰 Money-Back Guarantee: Not satisfied? We offer a full refund – no questions asked.
🔄 Wrong File? No Problem: Contact us and we will replace it immediately with the
correct version, free of charge.
⏰ 24/7 Support: We are always here – reach out anytime and expect a fast response.
,Practice Exercises Answer Key
Answer Key
Practice Exercises are completed in Excel. Once students complete their worksheet, they answer
a series of questions, which can be auto-graded in your LMS (if using). You may also want your
students to submit their Excel files to you so you can take a closer look.
This answer key shows the answers to all the questions that appear in the Practice Exercises
sections.
Job Order Costing
Check My Work: Prometheus Auto (answers also shown in the ebook)
1. $720,000
2. $1,395,000
3. $306,000
4. $3,920,000
5. Overapplied
6. $12,000
Exercise 1: Triton Marine Exercise 3: Caan Entertainment
1. $310,000 1. $180,000
2. $590,000 2. $551,000
3. $56,000 3. $144,000
4. $3,950,000 4. $2,380,000
5. Underapplied 5. Underapplied
6. $18,000 6. $8,000
Exercise 2: Knotty Pine Furniture Exercise 4: Statham Uniforms
1. $55,000 1. $75,000
2. $163,000 2. $128,000
3. $80,000 3. $29,000
4. $1,730,000 4. $825,000
5. Overapplied 5. Overapplied
6. $3,000 6. $10,000
Excel Companion for Managerial Accounting Courses Page 1 of 7
,Practice Exercises Answer Key
Process Costing
Check My Work: Condiment Masters (answers also shown in the ebook)
1. 500,000
2. 470,000
3. $2.40
4. $2.10
5. $2,070,000
6. $117,000
Exercise 1: The Franzen Company Exercise 3: Southeast Clean
1. 3,200,000 1. 900,000
2. 3,080,000 2. 865,000
3. $4.90 3. $3.00
4. $5.30 4. $3.60
5. $30,600,000 5. $5,478,000
6. $1,404,000 6. $336,000
Exercise 2: Aquatics Unlimited Exercise 4: Danton Corporation
1. 80,000 1. 520,000
2. 78,600 2. 448,000
3. $1.70 3. $6.40
4. $1.50 4. $5.30
5. $249,600 5. $5,148,000
6. $4,300 6. $554,400
Excel Companion for Managerial Accounting Courses Page 2 of 7
,Practice Exercises Answer Key
CVP Analysis
Check My Work: Wilson Automotive (answers also shown in the ebook)
1. 320
2. $19,600
3. $0
4. $13,200
5. $50
6. Sales Revenue and Total Costs
Exercise 1: Nguyen Collectibles Exercise 3: O’Halloran Exercise Equip.
1. 120 1. 100
2. $22,800 2. $128,000
3. $0 3. $0
4. $12,000 4. $240,000
5. $140 5. $800
6. Sales Revenue and Total Costs 6. Sales Revenue and Total Costs
Exercise 2: Singh Athletics Exercise 4: Webster Pet Supply
1. 300 1. 80
2. $200,000 2. $136,000
3. $0 3. $0
4. $40,000 4. $40,000
5. $300 5. $600
6. Sales Revenue and Total Costs 6. Sales Revenue and Total Costs
Excel Companion for Managerial Accounting Courses Page 3 of 7
,Practice Exercises Answer Key
Capital Projects
Check My Work: Earthworm Corporation (answers also shown in the ebook)
1. $4,213,206
2. $659,873
3. -$2,253,529
4. $4,758,078
5. Light-duty equipment project
6. Electric equipment project
Exercise 1: Hometown Cooking Exercise 3: Virgo Rentals
1. $19,599,704 1. $18,900,717
2. $68,329 2. $4,710,090
3. -$1,289,713 3. -$451,578
4. $19,568,596 4. $21,118,577
5. Second project 5. Electric vehicle project
6. Second project 6. Expansion project
Exercise 2: Oak College Exercise 4: Pete E. Pizza
1. $10,473,492 1. $19,204,814
2. -$100,029 2. -$1,667,596
3. -$95,818 3. $2,906,067
4. $9,955,935 4. $17,768,259
5. Solar panel project 5. Arcade project
6. Classroom project 6. Arcade project
Excel Companion for Managerial Accounting Courses Page 4 of 7
,Practice Exercises Answer Key
Variance Analysis
Check My Work: Source Medical (answers also shown in the ebook)
1. $215,200 F
2. $60,800 U
3. $3,372 U
4. $3,000 F
5. $5,620 F
6. $2,560 F
Exercise 1: Feinberg Auto Exercise 3: Old World Utensils
1. $321,600 U 1. $3,384 U
2. $84,000 U 2. $4,200 U
3. $26,240 F 3. $934 F
4. $81,600 U 4. $912 U
5. $26,240 F 5. $2,802 F
6. $46,800 U 6. $1,072 U
Exercise 2: Luxury Living Exercise 4: Zimmerman Flooring
1. $113,148 F 1. $161,200 U
2. $70,980 F 2. $8,000 U
3. $21,527 U 3. $2,916 F
4. $495 F 4. $6,944 F
5. $21,527 F 5. $5,832 U
6. $300 F 6. $10,416 F
Excel Companion for Managerial Accounting Courses Page 5 of 7
,Practice Exercises Answer Key
Statement of Cash Flows
Check My Work: Fitzpatrick Chemicals (answers also shown in the ebook)
1. $125,900
2. -$6,800
3. $13,800
4. $132,900
5. $228,900
6. Financing activities
Exercise 1: Henderson Industrial Exercise 3: Castle Suppliers
1. $2,100 1. $1,000
2. -$4,900 2. -$7,500
3. -$13,200 3. $5,000
4. -$16,000 4. -$1,500
5. $24,000 5. $49,500
6. Operating activities 6. Investing activities
Exercise 2: Vital Products Exercise 4: Spotlight Manufacturers
1. $24,900 1. -$17,400
2. -$29,800 2. -$3,400
3. $25,000 3. $5,300
4. $20,100 4. -$15,500
5. $108,100 5. $178,500
6. Operating activities 6. Financing activities
Excel Companion for Managerial Accounting Courses Page 6 of 7
,Practice Exercises Answer Key
Financial Statement Analysis
Check My Work: Alex’s Auto Parts (answers also shown in the ebook)
1. $58,860
2. $14,400
3. $226,930
4. $3.68
5. 16.34
6. 0.39
Exercise 1: Tool Masters Exercise 3: Rest Easy
1. $40,420 1. $12,730
2. $10,300 2. $2,300
3. $120,760 3. $152,215
4. $3.16 4. $0.80
5. 10.26 5. 78.62
6. 0.22 6. 0.22
Exercise 2: Party Warehouse Exercise 4: Rick’s Sports
1. $4,000 1. $96,600
2. $3,300 2. $38,000
3. $43,600 3. $412,750
4. $0.33 4. $1.79
5. 13.42 5. 10.08
6. 0.30 6. 0.29
Excel Companion for Managerial Accounting Courses Page 7 of 7
, Capital Project Alternatives
Assumptions:
Light-Duty Electric
Equipment Equipment
Annual Net Cash Flow $840,000 $1,240,000
Project Life (years) 8 8
Required Rate of Return 12% 12%
Initial Investment $5,500,000 $5,500,000
Additional Cash Flow in Final Year $100,000 $0
Analysis:
Present Value of Net Cash Flows $4,213,206 $6,159,873
Initial Investment $5,500,000 $5,500,000
Net Present Value -$1,286,794 $659,873
Only the manufacturing of electric equipment results in a positive
net present value here, so it is resonable to conclude that only
thos project should be pursued. Qualitative factors should be
considered as well, as this conclusion is solely based on the
quantitative analysis shown here.
Courses Weinstein
Important Notes
The file includes the complete test bank, organized chapter by chapter.
A sample of selected pages has been provided for preview.
All available appendices and Excel files (if included in the original resources) are
provided.
We continuously update our files to ensure you receive the latest and most accurate
editions.
New editions are added regularly – stay connected for updates!
⚠️Note on Answer Keys: If the answer key is not included within the chapter
questions, you will find the complete answers and solutions at the end of each
chapter.
✅ Why Buy From Us?
📚 Complete & organized chapter-by-chapter – no missing content, no guessing.
⚡ Instant digital delivery – get your file the moment you pay, no waiting.
📅 Always up to date – we track new editions so you always get the latest version.
💬 Friendly support – real humans ready to help, anytime you need us.
🔒 Safe & secure – thousands of satisfied students trust us every semester.
🛡️Our Guarantees
💰 Money-Back Guarantee: Not satisfied? We offer a full refund – no questions asked.
🔄 Wrong File? No Problem: Contact us and we will replace it immediately with the
correct version, free of charge.
⏰ 24/7 Support: We are always here – reach out anytime and expect a fast response.
,Practice Exercises Answer Key
Answer Key
Practice Exercises are completed in Excel. Once students complete their worksheet, they answer
a series of questions, which can be auto-graded in your LMS (if using). You may also want your
students to submit their Excel files to you so you can take a closer look.
This answer key shows the answers to all the questions that appear in the Practice Exercises
sections.
Job Order Costing
Check My Work: Prometheus Auto (answers also shown in the ebook)
1. $720,000
2. $1,395,000
3. $306,000
4. $3,920,000
5. Overapplied
6. $12,000
Exercise 1: Triton Marine Exercise 3: Caan Entertainment
1. $310,000 1. $180,000
2. $590,000 2. $551,000
3. $56,000 3. $144,000
4. $3,950,000 4. $2,380,000
5. Underapplied 5. Underapplied
6. $18,000 6. $8,000
Exercise 2: Knotty Pine Furniture Exercise 4: Statham Uniforms
1. $55,000 1. $75,000
2. $163,000 2. $128,000
3. $80,000 3. $29,000
4. $1,730,000 4. $825,000
5. Overapplied 5. Overapplied
6. $3,000 6. $10,000
Excel Companion for Managerial Accounting Courses Page 1 of 7
,Practice Exercises Answer Key
Process Costing
Check My Work: Condiment Masters (answers also shown in the ebook)
1. 500,000
2. 470,000
3. $2.40
4. $2.10
5. $2,070,000
6. $117,000
Exercise 1: The Franzen Company Exercise 3: Southeast Clean
1. 3,200,000 1. 900,000
2. 3,080,000 2. 865,000
3. $4.90 3. $3.00
4. $5.30 4. $3.60
5. $30,600,000 5. $5,478,000
6. $1,404,000 6. $336,000
Exercise 2: Aquatics Unlimited Exercise 4: Danton Corporation
1. 80,000 1. 520,000
2. 78,600 2. 448,000
3. $1.70 3. $6.40
4. $1.50 4. $5.30
5. $249,600 5. $5,148,000
6. $4,300 6. $554,400
Excel Companion for Managerial Accounting Courses Page 2 of 7
,Practice Exercises Answer Key
CVP Analysis
Check My Work: Wilson Automotive (answers also shown in the ebook)
1. 320
2. $19,600
3. $0
4. $13,200
5. $50
6. Sales Revenue and Total Costs
Exercise 1: Nguyen Collectibles Exercise 3: O’Halloran Exercise Equip.
1. 120 1. 100
2. $22,800 2. $128,000
3. $0 3. $0
4. $12,000 4. $240,000
5. $140 5. $800
6. Sales Revenue and Total Costs 6. Sales Revenue and Total Costs
Exercise 2: Singh Athletics Exercise 4: Webster Pet Supply
1. 300 1. 80
2. $200,000 2. $136,000
3. $0 3. $0
4. $40,000 4. $40,000
5. $300 5. $600
6. Sales Revenue and Total Costs 6. Sales Revenue and Total Costs
Excel Companion for Managerial Accounting Courses Page 3 of 7
,Practice Exercises Answer Key
Capital Projects
Check My Work: Earthworm Corporation (answers also shown in the ebook)
1. $4,213,206
2. $659,873
3. -$2,253,529
4. $4,758,078
5. Light-duty equipment project
6. Electric equipment project
Exercise 1: Hometown Cooking Exercise 3: Virgo Rentals
1. $19,599,704 1. $18,900,717
2. $68,329 2. $4,710,090
3. -$1,289,713 3. -$451,578
4. $19,568,596 4. $21,118,577
5. Second project 5. Electric vehicle project
6. Second project 6. Expansion project
Exercise 2: Oak College Exercise 4: Pete E. Pizza
1. $10,473,492 1. $19,204,814
2. -$100,029 2. -$1,667,596
3. -$95,818 3. $2,906,067
4. $9,955,935 4. $17,768,259
5. Solar panel project 5. Arcade project
6. Classroom project 6. Arcade project
Excel Companion for Managerial Accounting Courses Page 4 of 7
,Practice Exercises Answer Key
Variance Analysis
Check My Work: Source Medical (answers also shown in the ebook)
1. $215,200 F
2. $60,800 U
3. $3,372 U
4. $3,000 F
5. $5,620 F
6. $2,560 F
Exercise 1: Feinberg Auto Exercise 3: Old World Utensils
1. $321,600 U 1. $3,384 U
2. $84,000 U 2. $4,200 U
3. $26,240 F 3. $934 F
4. $81,600 U 4. $912 U
5. $26,240 F 5. $2,802 F
6. $46,800 U 6. $1,072 U
Exercise 2: Luxury Living Exercise 4: Zimmerman Flooring
1. $113,148 F 1. $161,200 U
2. $70,980 F 2. $8,000 U
3. $21,527 U 3. $2,916 F
4. $495 F 4. $6,944 F
5. $21,527 F 5. $5,832 U
6. $300 F 6. $10,416 F
Excel Companion for Managerial Accounting Courses Page 5 of 7
,Practice Exercises Answer Key
Statement of Cash Flows
Check My Work: Fitzpatrick Chemicals (answers also shown in the ebook)
1. $125,900
2. -$6,800
3. $13,800
4. $132,900
5. $228,900
6. Financing activities
Exercise 1: Henderson Industrial Exercise 3: Castle Suppliers
1. $2,100 1. $1,000
2. -$4,900 2. -$7,500
3. -$13,200 3. $5,000
4. -$16,000 4. -$1,500
5. $24,000 5. $49,500
6. Operating activities 6. Investing activities
Exercise 2: Vital Products Exercise 4: Spotlight Manufacturers
1. $24,900 1. -$17,400
2. -$29,800 2. -$3,400
3. $25,000 3. $5,300
4. $20,100 4. -$15,500
5. $108,100 5. $178,500
6. Operating activities 6. Financing activities
Excel Companion for Managerial Accounting Courses Page 6 of 7
,Practice Exercises Answer Key
Financial Statement Analysis
Check My Work: Alex’s Auto Parts (answers also shown in the ebook)
1. $58,860
2. $14,400
3. $226,930
4. $3.68
5. 16.34
6. 0.39
Exercise 1: Tool Masters Exercise 3: Rest Easy
1. $40,420 1. $12,730
2. $10,300 2. $2,300
3. $120,760 3. $152,215
4. $3.16 4. $0.80
5. 10.26 5. 78.62
6. 0.22 6. 0.22
Exercise 2: Party Warehouse Exercise 4: Rick’s Sports
1. $4,000 1. $96,600
2. $3,300 2. $38,000
3. $43,600 3. $412,750
4. $0.33 4. $1.79
5. 13.42 5. 10.08
6. 0.30 6. 0.29
Excel Companion for Managerial Accounting Courses Page 7 of 7
, Capital Project Alternatives
Assumptions:
Light-Duty Electric
Equipment Equipment
Annual Net Cash Flow $840,000 $1,240,000
Project Life (years) 8 8
Required Rate of Return 12% 12%
Initial Investment $5,500,000 $5,500,000
Additional Cash Flow in Final Year $100,000 $0
Analysis:
Present Value of Net Cash Flows $4,213,206 $6,159,873
Initial Investment $5,500,000 $5,500,000
Net Present Value -$1,286,794 $659,873
Only the manufacturing of electric equipment results in a positive
net present value here, so it is resonable to conclude that only
thos project should be pursued. Qualitative factors should be
considered as well, as this conclusion is solely based on the
quantitative analysis shown here.
