Orbital Industries of Canada, Ltd. manufactures a variety of materials and equipment for the aerospace industry. A team of R&D engineers in the firm's Winnipeg plant has developed a new material that will be useful for a variety of purposes in orbiting satellites and spacecraft. Tradenamed Ceralam, the material combines some of the best properties of both ceramics and laminated plastics. Ceralam is already being used for a variety of housings in satellites produced in three different countries. Ceralam sheets are produced in an operation called rolling, in which the various materials are rolled together to form a multilayer laminate. Orbital Industries sells many of these Ceralam sheets just after the rolling operation to aerospace firms worldwide. However, Orbital also processes many of the Ceralam sheets further in the Winnipeg plant. After rolling, the sheets are sent to the molding operation, where they are formed into various shapes used to house a variety of instruments. After molding, the sheets are sent to the punching operation, where holes are punched in the molded sheets to accommodate protruding instruments, electrical conduits, and so forth. Some of the molded and punched sheets are then sold. The remaining units are sent to the dipping operation, in which the molded sheets are dipped in a special chemical mixture to give them a reflective surface.

During the month of November, the following products were manufactured at the Winnipeg plant. The direct-material costs are also shown.

The costs incurred in producing the various Ceralam products in the Winnipeg plant during November are shown in the following table. Manufacturing overhead is applied on the basis of direct-labor dollars at the rate of 150 percent.

Orbital Industries of Canada uses operation costing for its Ceralam operations in the Winnipeg plant. (There were no inventories of work in process or finished goods on November 1 or November 30.)

Required:
1. Prepare a table that includes the following information for each of the four operations.
• Total conversion costs.
• Units manufactured.
• Conversion cost per unit.
2. Prepare a second table that includes the following information for each product (i.e., rolled Ceralam sheets, nonreflective Ceralam housings, and reflective Ceralam housings).
• Total manufacturing costs.
• Units manufactured.
• Total cost per unit.
3. Prepare journal entries to record the flow of all manufacturing costs through the Winnipeg plant's Ceralam operations during November. (Ignore the journal entries to record sales revenue.)
4. Build a spreadsheet: Construct an Excel spreadsheet to solve requirements 1 and 2 above. Show how the solution will change if the following data change: the cost of direct material used in dipping was $66,000 and the overhead application rate is 200% of direct-laborcost.

Direct Materials Used in Direct Materials Used in Ceralam sheets (sold after the rolling operation) Nonreflective housings isold after the punching operation) Reflective housings (sold after the dipping operation Total 400,000 240,000 ...10,000 1,600,000 Units Ceralam SheetsDipping 6,000 $960,000 2,500 1,500 $60,000 $60,000 Rolling Molding Punching Dippling 060,000 600,000 $224,000 $256,000 90,000 900,000 336,000 384,000 35,000 $3,100,000 $560,000 $640,000 $285,000 $1,600,000 Direct material Direct labor.. Manufacturing overhead. Total 0-