Question
Use Excel to answer this Assignment - (20 points) Exercises 5-14 - Page 141 (4 points) Potter Corporation has gained considerable market share in
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
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started