Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditors Guide To IT Auditing

Authors: Richard E. Cascarino

2nd Edition

1118147618, 978-1118147610

More Books

Students also viewed these Accounting questions