Refer to the original data given in the preceding problem for Rapid City Technology, Inc. In the
Question:
Refer to the original data given in the preceding problem for Rapid City Technology, Inc. In the preceding problem, Rapid City Technology, Inc. manufactures chemicals used in agricultural pest control. The controller has established the following activity cost pools and cost drivers.
An order for 1,000 boxes of a chemical product designated JLRP has the following production requirements.
Machine setups....................................................................... 6 setups
Raw material..................................................................... 9,000 pounds
Hazardous materials........................................................ 2,100 pounds
Inspections............................................................................... 8 inspections
Machine hours..................................................................... 550 machine hours
Required:
1. Calculate the unit cost of a production order for 100 specially coated containers used in transporting chemicals. In addition to direct material costing $210 per container and direct labor costing $60 per container, the order requires:
Machine setups...................................................................4
Raw material....................................................................800 pounds
Hazardous materials.......................................................400 pounds
Inspections..........................................................................4
Machine hours..................................................................60
2. Build a spreadsheet: Construct an Excel spreadsheet to solve the preceding requirement. (This will be an extension of the spreadsheet constructed for requirement (6) in the preceding problem.) Show how the solution will change if the data given in the preceding problem change as follows: the overhead associated with machine setups is $500,000, and there are 1,000 inspections budgeted.
Step by Step Answer:
Managerial Accounting Creating Value in a Dynamic Business Environment
ISBN: 978-0078025662
10th edition
Authors: Ronald Hilton, David Platt