View the step-by-step solution to:

# Hanan Aldraawi Mubarik Hasan Raja Ram Reddy Kontham Carl Sizemore Sailaja Cherukuri Record Your Answers in the Green Cells 2010 Income Statement...

please I want help to solve this project
all question and data listed with the file

Hanan Aldraawi Mubarik Hasan Raja Ram Reddy Kontham Carl Sizemore Sailaja Cherukuri
Record Your Answers in the Green Cells 2010 Income Statement 1 Build the formulas for the highlighted cells. (Use the same Formulas in #7) Revenue Projected 2 Using Units Sold at the Projected Number Record Net Income or Loss at 29200 2a Units Sold 29,200 Using Units Sold at the Projected Number Record Total Revenue 29200 2b Price per Unit \$28.50 Using Units Sold at the Projected Number Record Total Expenses 29200 2c Total Revenue 1 3 Using Goal Seek Calculate the Units Sold at the following: Variable Expenses Projected 3a Breakeven Point in Units 0 3a Units Produced 30,660 Variable Cost per Unit \$8.50 3b Desired Profit in Units of 200000 3b Total Variable Cost 1 Variable Portion Fixed Cost per Unit \$5.25 Total Variable Portion of Fixed Cost 1 Total Variable Expenses 1 4 Change the Units Sold back to 29200 and do the following: Fixed Expenses Projected Create a One-Variable Data Table with the following parameters. Salaries and Benefits \$240,000.00 Units Sold Revenue Expenses Net Income 30,000 Units Advertising \$25,000.00 Administrative \$15,000.00 15,000 Miscellaneous \$12,000.00 20,000 Total Fixed Expenses 1 25,000 30,000 Summary Projected 35,000 Total Revenue 40,000 Total Expenses Net Income 1 5 Using the One-Variable Data Table above Create: A Scattergram Chart of Cost Volume Profit Analysis with Revenue and Expenses = Dependent Variable Units Sold = Independent Variable Save the Chart in another Sheet of this Workbook 6 Change the Units Sold back to 29200 and do the following: Create a Two-Variable Data Table with the following parameters. Net Income Analysis Price per Unit 30,000 Units \$0.00 20 25 30 35 40 25 Price 15,000 20,000 25,000 30,000 35,000 40,000 7 Revenue Projected Units Sold 29,200 Fixed Costs Selling Price Demand Volume Price per Unit \$28.50 Total Revenue Best Case 385000 \$30.00 35,000 7a Worst Case 235000 \$26.00 20,000 7b Variable Expenses Projected Most Likely Case 292000 \$28.50 29,200 7c Units Produced 30,660 Variable Cost per Unit \$8.50 Net Income at the Listed Cases Total Variable Cost Best Case 7a Variable Portion Fixed Cost per Unit \$5.25 Worse Case 7b Total Variable Portion of Fixed Cost Most Likely Case 7c Total Variable Expenses Total Fixed Expenses \$292,000.00 Summary Projected Total Revenue Total Expenses Net Income What is the Projected Net Income @ What is the Projected Net Income @ Using Senario Manager Calculate Net Income Using the Data In the Yellow and Record Your Answers in the Green Boxes Below.
Show entire document

Hanan Aldraawi
Mubarik Hasan
Raja Ram Reddy Kontham
Carl Sizemore
2010 Income Statement
Revenue Units Sold
Price per Unit
Total Revenue...

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents