Question: please solve question using excel, if applicable make use of solver. Thanks. 1. Harrison Ford makes handcrafted Star Wars Action figures, which he sells at
please solve question using excel, if applicable make use of solver. Thanks.
1. Harrison Ford makes handcrafted Star Wars Action figures, which he sells at Comic Conventions. He is considering mass producing the dolls to sell in stores (because I mean hey...he is Harrison Ford). He estimates that the initial investment for plant and equipment will be $25,000, whereas labor, material, packaging, and shipping will be about $10 per action figure. A. If the action figures are sold for $30 each, what sales volume is necessary for Mr. Ford to break even? B. Mr. Ford has determined that $10,000 worth of advertising will increase sales volume by 400 action figures. Should he spend the extra amount for advertising? (Material from Week 1/Chapter 1)
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
