Data. Shelby Shelving.xlsx - Shelby Shelving Data for Current Production Schedule Machine requirements(hours per unit Model S Stamping 0.3 Forming 0.25

Data. Shelby Shelving.xlsx - Shelby Shelving Data for...

This preview shows page 1 - 3 out of 9 pages.

Shelby Shelving Data for Current Production Schedule Machine requirements (hours per unit) Given monthly overhead cost data Model S Model LX Available Fixed Variable S Variable LX Stamping 0.3 0.3 800 Stamping $125,000 $80 $90 Forming 0.25 0.5 800 Forming $95,000 $120 $170 Model S Assembly $80,000 $165 $0 Model S Model LX Model LX Assembly $85,000 $0 $185 Current monthly production 400 1400 Hours spent in departments Model S Model LX Model S Model LX Totals Direct materials $1,000 $1,200 Stamping 120 420 540 Direct labor: Forming 100 700 800 Stamping $35 $35 Forming $60 $90 Percentages of time spent in departments Assembly $80 $85 Model S Model LX Total direct labor $175 $210 Stamping 22.2% 77.8% Overhead allocation Forming 12.5% 87.5% Stamping $149 $159 Forming $150 $229 Unit selling price $1,800 $2,100 Assembly $365 $246 Total overhead $664 $635 Assembly capacity 1900 1400 Total cost $1,839 $2,045 Model: Model S Model LX Standard costs of the shelves -- based on the current production levels
Image of page 1
Shelby Shelving Data for Current Production Schedule Machine requirements (hours per unit) Given monthly overhead cost data Model S Model LX Available Fixed Variable S Variable LX Stamping 0.3 0.3 800 Stamping $125,000 $80 $90 Forming 0.25 0.5 800 Forming $95,000 $120 $170 Model S Assembly $80,000 $165 $0 Model S Model LX Model LX Assembly $85,000 $0 $185 Current monthly production 400 1400 Hours spent in departments Model S Model LX Model S Model LX Totals Direct materials $1,000 $1,200 Stamping 120 420 540 Direct labor: Forming 100 700 800 Stamping $35 $35 Forming $60 $90 Percentages of time spent in departments Assembly $80 $85 Model S Model LX Total direct labor $175 $210 Stamping 22.2% 77.8% Overhead allocation
Image of page 2
Image of page 3

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture