Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use Excel to answer this Assignment - (20 points) Exercises 5-14 - Page 141 (4 points) Potter Corporation has gained considerable market share in

image text in transcribed

Use Excel to answer this Assignment - (20 points) Exercises 5-14 - Page 141 (4 points) Potter Corporation has gained considerable market share in recent years for its specialty, low- volume, complex line of products, but the gain has been offset by a loss in market share for its high-volume, simple line of products. This has resulted in a net decline in its overall profitability. Advise management about specific changes that may be required in its cost accounting system and explain why the existing system may be inadequate. Exercises 5-15 - Page 141 (6 points) Sigma Company produces three versions of a brass desk lamp: basic, custom, and deluxe. The planned production information for the upcoming month follows: Resources Cost per Fringe Total Hours per Month Benefits Month Direct labor Machinery $4,270 $800 $5,070 130 Indirect labor cost $4,210 $600 4,810 130 $50,000 $50,000 250 Basic Custom Deluxe Selling price per unit $170 $190 $230 Direct materials cost per unit $40 $50 $55 Production Information Basic Custom Deluxe Production and sales volume (units) 4,500 3,200 1,200 Direct labor hours per unit 2.00 2.50 3.00 Total direct labor hours 9,000 8,000 3,600 Machine hours per unit 0.05 0.08 0.09 Total machine run time (hours) 225 256 108 Number of production runs 12.00 10.00 8.00 Setup time per production run (machine hours) 2.00 1.00 2.50 Total setup time (machine hours) 24.00 10.00 20.00 Total machine hours 249 266 128 Indirect labor data per Setup time run (hours) 3.00 Number of employees per setup 4 4.00 4 6.00 4 Indirect labor hours per setup 12.00 16.00 24.00 Provide you Answer in an Excel file that you create and Upload to Canvas

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Accounting The Managerial Chapters

Authors: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura

11th Global Edition

1292105879, 978-1292105871

Students also viewed these Accounting questions

Question

=+ Describe the components. Which month was left out? Why?

Answered: 1 week ago

Question

Solve the following problem. PV=$17,067; n=62; i=0.027; PMT =?

Answered: 1 week ago