Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
1 . What were the Operating Margins, Gross Profits, Profit Margins by product line for oak, cherry, and walnut? 2 . Assume equal allocation of
What were the Operating Margins, Gross Profits, Profit Margins by product line for oak, cherry, and walnut? Assume equal allocation of all nonlumber expenses for each desk hardwaresalary benefit, utility, depreciation, etcIt means that for items like salaries you would divide them equally among the product lines, none of them 'cost' more than the other for these items. The Desk Corp Income Statement Revenue COGS Lumber Hardware Finishing supplies Cost of Goods Sold Gross Profit Administrative Expenses Salary & Benefits Utility Expenses Depreciation Total Operating Expenses Income From Operations Net Income Before Tax Corporate Income Tax Expense Net Income Loss YEAR Price Per Desk Q Volume Q Volume Q Volume Q Volume Y Volume Oak Desks $ Walnut Desks $ Cherry Desks $ Historic Revenue Revenue IRRNPV Analysis Q Q Q Q Y Actual Y Variance Oak Desks Walnut Desks Cherry Desks Total Revenue $ $ $ Lumber Oak Walnut Cherry Total Lumber $ $ $ Hardware Drawer Slides Knobs & Handles Electrical & Cable management Total Hardware $ $ $ All other Expenses Salary Wages Hourly Wages Benefit Expenses Total Salary & Benefits $ $ $ Utility Expenses Depreciation Total Other Expenses $
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
What were the Operating Margins, Gross Profits, Profit Margins by product line for oak, cherry, and walnut?
Assume equal allocation of all nonlumber expenses for each desk hardwaresalary benefit, utility, depreciation, etcIt means that for items like salaries you would divide them equally among the product lines, none of them 'cost' more than the other for these items.
The Desk Corp
Income Statement
Revenue
COGS
Lumber
Hardware
Finishing supplies
Cost of Goods Sold
Gross Profit
Administrative Expenses
Salary & Benefits
Utility Expenses
Depreciation
Total Operating Expenses
Income From Operations
Net Income Before Tax
Corporate Income Tax Expense
Net Income Loss
YEAR
Price Per Desk Q Volume Q Volume Q Volume Q Volume Y Volume
Oak Desks $
Walnut Desks $
Cherry Desks $
Historic Revenue
Revenue IRRNPV Analysis Q Q Q Q Y Actual Y Variance
Oak Desks
Walnut Desks
Cherry Desks
Total Revenue $ $ $
Lumber
Oak
Walnut
Cherry
Total Lumber $ $ $
Hardware
Drawer Slides
Knobs & Handles
Electrical & Cable management
Total Hardware $ $ $
All other Expenses
Salary Wages
Hourly Wages
Benefit Expenses
Total Salary & Benefits $ $ $
Utility Expenses
Depreciation
Total Other Expenses $
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started