Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Revenue $ 291,798 Expense 1. Variable Expenses $ 105,310 2. Fixed Expenses $ 120,000 Total Expenses $ 225,310 Profits $ 66,487 Data Table: 1. a.
Revenue $ 291,798 Expense 1. Variable Expenses $ 105,310 2. Fixed Expenses $ 120,000 Total Expenses $ 225,310 Profits $ 66,487 Data Table: 1. a. Use Goal Seek to identify the Price to generate Profits of $72,000. Don't save the results. b. Use Goal Seek to identify the Variable cost to generate Profits of $70,000. Don't save the results. 2. Create a one-way Data Table showing.... a. Quantity Sold b. Revenue c. Total Expenses d. Profits ..for Prices ranging from $19.00 to $25.00 3. Create a two-way Data Table showing Profits for a. Prices ranging from $19.00 to $25.00 b. Variable Costs ranging from $6.00 to $9.00. Revenue $ 291,798 Expense 1. Variable Expenses $ 105,310 2. Fixed Expenses $ 120,000 Total Expenses $ 225,310 Profits $ 66,487 Data Table: 1. a. Use Goal Seek to identify the Price to generate Profits of $72,000. Don't save the results. b. Use Goal Seek to identify the Variable cost to generate Profits of $70,000. Don't save the results. 2. Create a one-way Data Table showing.... a. Quantity Sold b. Revenue c. Total Expenses d. Profits ..for Prices ranging from $19.00 to $25.00 3. Create a two-way Data Table showing Profits for a. Prices ranging from $19.00 to $25.00 b. Variable Costs ranging from $6.00 to $9.00
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