5-53 Drirs Refer to the original data given in the preceding problem for Rapid City Technology, Inc. Required: I. Calculate the unit cost of a production order for 200 specially coated containers used in transporting chemicals. In addition to direct material costing $250 per container and direct la costing $80 per container, the order requires: Machine setups Raw material Hazardous materials Inspections Machine hours 1,000 pounds 500 pounds 80 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 fol- lows: the overhead associated with machine setups is $500,000, and there are 1,000 inspections budgeted. 5-53 Drirs Refer to the original data given in the preceding problem for Rapid City Technology, Inc. Required: I. Calculate the unit cost of a production order for 200 specially coated containers used in transporting chemicals. In addition to direct material costing $250 per container and direct la costing $80 per container, the order requires: Machine setups Raw material Hazardous materials Inspections Machine hours 1,000 pounds 500 pounds 80 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 fol- lows: the overhead associated with machine setups is $500,000, and there are 1,000 inspections budgeted