Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For this learning activity, use the MailCampaign.xlsx file. Use the Goal-Seek tab. Perform a goal-seek analysis that shows the average order size necessary to break

For this learning activity, use the MailCampaign.xlsx file. Use the Goal-Seek tab. Perform a goal-seek analysis that shows the average order size necessary to break even (i.e., have a net income of zero).

Mailing Campaign Analysis
Costs Mailing inputs
Printing 24,000.00 Fixed cost of printing 10,000
Mailing 14,000.00 Variable cost for printing 0.10
Total Costs 38,000.00 Variable cost for mailing 0.28
Number of catalogs mailed 50,000
Net order revenue
Revenues 220,000.00 Responses and orders
Variable costs 176,000.00 Response rate 0.08
Net revenue 44,000.00 Average order 55
Order processing costs (%) 15%
Net income 6,000.00 Cost of goods sold (%) 65%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Cases in Financial Reporting

Authors: Michael J. Sandretto

1st edition

538476796, 978-0538476799

More Books

Students also viewed these Finance questions

Question

3. What are some possible consequences of poor quality?

Answered: 1 week ago