Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You have an internship at The Bike Store. The Chief Financial Officer needs your help to prepare the 2021 Budget which YOU will present to

You have an internship at The Bike Store. The Chief Financial Officer needs your help to prepare the 2021 Budget which YOU will present to the Board of Directors Meeting at their meeting next week.

Your task is to create the 2021 Budget in an Excel Spreadsheet. You only need to prepare an Income Statement

Assume:

  1. The company will sell 16,000 bicycles at an average price of $2,500 each
  2. Cost of Labor is 20% of Sales
  3. Cost of Materials is 10% of Sales
  4. Variable Overhead is 6% of Sales
  5. Fixed Manufacturing Overhead is $4,000,000
  6. Office Salaries are 5,000,000
  7. Office Deprecation Expense is $500,000
  8. Lease Expense of Corporate Office is $2,000,000
  9. Advertising is $1,000,000
  10. Income Taxes are 30% of all revenues minus all expenses before income taxes.

The Board of Directors will also want to know, with the assumptions above what would be the company:

  1. Gross Profit Margin?
  2. Operating Profit Margin?
  3. Net Profit Margin?
  4. Number of bicycles to sell to breakeven? Assume if the company is breakeven, income taxes will be zero.

Since this is an internal report, you dont necessarily have to use a GAAP Income Statement

Make sure the report is easy to follow

image text in transcribed

After you have finished Step 1, below is what your report should read. Item Correct Figure 1 - Net Income $9,170,000 2 - Gross Profit Margin 54.00% 32.75% 3 - Operating Profit Margin 4 - Net Profit Margin 22.93% 5 - Number of bicycles to sell to breakeven? 7,813 (rounded up)

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

Accounting

Authors: Charles T. Horngren, Walter T. Harrison

7th Edition

0132439603, 9780132439602

More Books

Students also viewed these Accounting questions

Question

TEENAGE DRIVERS ARE MORE LIKELY TO BE INVOLVED IN A CRASH WHEN:

Answered: 1 week ago