Question: These need to be solved using excel. If you could show what functions to use please 7. Andy Mendoza makes handcrafted dolls, which he sells

These need to be solved using excel. If you could show what functions to use please
7. Andy Mendoza makes handcrafted dolls, which he sells at craft fairs. He is considering massproducing the dolls to sell in stores. 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 doll. If the dolls are sold for $30 each, what sales volume is necessary for Andy to break even? 11. If the Gobblecakes bakery in Problem changes the selling price for a cupcake from $3.20 to $2.75, what effect will the change have on the break-even volume? 15. Pastureland Dairy makes cheese, which it sells at local supermarkets. The fixed monthly cost of production is $4,000, and the variable cost per pound of cheese is $0.21. The cheese sells for $0.75 per pound; however, the dairy is considering raising the price to $0.95 per pound. The dairy currently produces and sells 9,000 pounds of cheese per month, but if it raises its price per pound, sales will decrease to 5,700 pounds per month. Should the dairy raise the priceStep 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
