Question
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
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