E. Use Goal Seek in Excel (Data/What If Analysis/Goal Seek) to determine the following: Each situation is independent of the others. price per item is needed to get the same net income as in Part B? 1) Assume the only change to the original data is that sales double, what sales 2) Assume the original data including unit sales, what is the total cost per unit needed to get the same net income as in Part B? 3) Assume the only change to the original data is that the sales price decreases to $12.00 per unit and sales in units double, what would selling costs need to be to get the same net income as in Part B? F. GO BACK TO THE ORIGINAL DATA. Use Solver in Excel to determine the following assuming these constraints: Sales price not more than $16.00 per unit Sales price not less than $10.00 per unit. Product costs not more than $8.00 per unit. Product costs not less than $4.00 per unit Administrative costs not more than $225,000 Administrative costs not less than $100.000, Sales in units not more than 100.000 Sales in units not less than 20,000 . Fach situation is independent of the others 1. How many units must be sold in order to get the same net income as in Part B? 2. What is the maximum net income Snazzy Pup can achieve with the above constraints? 3. What is the minimum net income Snazzy Pup can achieve with the above constraints? G. GO BACK TO THE ORIGINAL DATA. Use Scenario Manager in Excel. Prepare and print a Scenarios Summary Report for net income with the following options: Each situation is independent of the others. 1. Big Sale - Both sales in units and selling expenses double 2. Worst case - Sales in units are half as much as the original amount. 3. Lower prices - Sales price per unit decrease to $12.00 and sales in units double 4. Lower unit costs - Product cost per unit decreases to $5.00 5. Lower administrative costs - Administrative costs decline to $150,000 which causes a decrease in unit sales of 10%. 6. Change two - Sales in units increase by 50% and sale price per unit decreases 7. Makeover - An exclusive model is introduced. This causes sales in units to to $14 per unit. increase by 10,000, the sales price per unit to increase to $20, unit costs increase by $2.00, and selling costs increase to $175,000. E. Use Goal Seek in Excel (Data/What If Analysis/Goal Seek) to determine the following: Each situation is independent of the others. price per item is needed to get the same net income as in Part B? 1) Assume the only change to the original data is that sales double, what sales 2) Assume the original data including unit sales, what is the total cost per unit needed to get the same net income as in Part B? 3) Assume the only change to the original data is that the sales price decreases to $12.00 per unit and sales in units double, what would selling costs need to be to get the same net income as in Part B? F. GO BACK TO THE ORIGINAL DATA. Use Solver in Excel to determine the following assuming these constraints: Sales price not more than $16.00 per unit Sales price not less than $10.00 per unit. Product costs not more than $8.00 per unit. Product costs not less than $4.00 per unit Administrative costs not more than $225,000 Administrative costs not less than $100.000, Sales in units not more than 100.000 Sales in units not less than 20,000 . Fach situation is independent of the others 1. How many units must be sold in order to get the same net income as in Part B? 2. What is the maximum net income Snazzy Pup can achieve with the above constraints? 3. What is the minimum net income Snazzy Pup can achieve with the above constraints? G. GO BACK TO THE ORIGINAL DATA. Use Scenario Manager in Excel. Prepare and print a Scenarios Summary Report for net income with the following options: Each situation is independent of the others. 1. Big Sale - Both sales in units and selling expenses double 2. Worst case - Sales in units are half as much as the original amount. 3. Lower prices - Sales price per unit decrease to $12.00 and sales in units double 4. Lower unit costs - Product cost per unit decreases to $5.00 5. Lower administrative costs - Administrative costs decline to $150,000 which causes a decrease in unit sales of 10%. 6. Change two - Sales in units increase by 50% and sale price per unit decreases 7. Makeover - An exclusive model is introduced. This causes sales in units to to $14 per unit. increase by 10,000, the sales price per unit to increase to $20, unit costs increase by $2.00, and selling costs increase to $175,000
