Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Mini Excel Project Gardner Corporation manufactures skateboards and is in the process of preparing next year's budget. The pro forma income statement for the current
Mini Excel Project Gardner Corporation manufactures skateboards and is in the process of preparing next year's budget. The pro forma income statement for the current year is presented below. Question 1: Convert the Pro-Forma Income Statement to a Contribution Margin Income Statement. Fill in account names and type in numbers in blue cells $ 1,500,000 $ 1,500,000 Table 1 Sales Variable Costs: Pro-Forma Income Statement Sales Cost of sales: Direct Material Direct labor Variable Overhead Fixed Overhead Gross Profit Selling and G&A Variable Fixed Operating Income $ $ $ $ 250,000 150,000 75,000 100,000 $ $ 575,000 925,000 Contribution Mrgin Fixed Costs: $ $ 200,000 250,000 $ $ 450,000 475,000 Operating Income $ 475,000 Question 2: Calculate the breakeven point in sales dollars for Gardner Corporation by filling in FORMULAS in the blue cells with question marks. These formulas should be linked to the numbers on Table 1. BEP in sales $ = Fixed Costs CM Ratio Question 3: Prove that your breakeven sales $ from question 2 will produce a zero operating income by filling in FORMULAS in the cells with question marks These formulas should be linked to the numbers on Table 1. Sales ? This is your BEP sales $ from question 2. Variable Costs: Contribution Mrgin Fixed Costs: Operating Income
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started