Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Following is the income and loss statement for Davis Blades taken from an Excel worksheet: Davis Blades The Professional Model Monthly Income Statement: North Central

Following is the income and loss statement for Davis Blades taken from an Excel worksheet:

Davis Blades The Professional Model Monthly Income Statement: North Central Region

Revenue

Units Sold

1,200

Price per Unit

$198

Total Revenue

$237,600

Variable Expenses

Units Produced

1,200

Material Cost per Unit

$50

Total Material Cost

$60,000

Manufacturing Cost per Unit

$30

Manufacturing Expenses

$36,000

Total Variable Expense

$96,000

Fixed Expenses

Leasing

$11,000

Salary and benefits

$90,000

Advertisement

$10,000

Administrative

$10,000

Total Fixed Expense

$121,000

Summary

Total Expenses

$217,000

Operating Income

$20,600

Step 1. Create an EXCEL workbook:

Name sheet1 as Documentation and it looks like the following:

Rename sheet2 as I&L Data and place the data from above table.

Step 2. Repeat the income and loss statement for the quantities 1200 (already given), 1400, 1600, 1800 and 2000. To do this, rename sheet3 as Quantity vs. I&L and copy I&L Data to it. Make a column for each quantity.

Step 3.

a. Prepare a graph for total revenues and total expenses for the quantities 1200, 1400, 1600, 1800, and 2000 and place it in a new worksheet Cost v. Revenues.

I NEED QUESTIONS 2 AND 3A

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions