Grand Jean Financial Statements Assignment

Grand Jean Financial Statements Assignment - $0.20 $16,000...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
11/09/2011 17:00:17 5f9654f58f78b24b95c0e6bbb38d1aaa4a8168ce.xlsx Grand Jean Company Production Schedule # Plants Jeans/week Weeks/yr Total Units 25 20,000 52 26,000,000 Contract 14,000,000 Total Production 40,000,000 DuPont Model Revenue per unit $20 $800,000,000 COS - plants per unit $12 $312,000,000 COS - contract per unit $14 $196,000,000 Gross Margin $292,000,000 GM% Revenue 36.5% % Revenue 20% $160,000,000 Administration % Revenue 8% $64,000,000 Operating Profit $68,000,000 OP% Revenue 8.5% Assets $640,000,000 OP% Assets 10.6% Oshkosh Plant Per Unit Budget Actual + 10% Actual - 10% # Units per Month 80,000 88,000 72,000 Material $6.00 $480,000 $528,000 $432,000 Direct Labor $3.00 $240,000 $264,000 $216,000 Occupancy $1.20 $96,000 $105,600 $86,400 Variable Utilities
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $0.20 $16,000 $17,600 $14,400 Fixed Utilities $0.30 $24,000 $26,400 $21,600 Depreciation $0.80 $64,000 $70,400 $57,600 Mgmt/Supervision $0.50 $40,000 $44,000 $36,000 Total Cost $12.00 $960,000 $1,056,000 $864,000 Oshkosh Plant Per Unit Budget Actual + 10% Actual - 10% # Units per Month 80,000 88,000 72,000 Material $6.00 $480,000 $528,000 $432,000 Direct Labor $3.00 $240,000 $264,000 $216,000 Occupancy $1.20 $96,000 $96,000 $96,000 Variable Utilities $0.20 $16,000 $17,600 $14,400 Fixed Utilities $0.30 $24,000 $24,000 $24,000 Depreciation $0.80 $64,000 $70,400 $57,600 Mgmt/Supervision $0.50 $40,000 $40,000 $40,000 Total Cost $12.00 $960,000 $1,040,000 $880,000...
View Full Document

Ask a homework question - tutors are online