Refer to the original data given in the preceding problem for Rapid City Technology, Inc.

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.