Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Lorenzo, the owner of a local poster shop, comes to you for help. While his shop has been breaking even for the past two years,
Lorenzo, the owner of a local poster shop, comes to you for help. While his shop has been breaking even for the past two years, it has not been able to generate a profit. For him to keep the shop open, he needs to earn at least $ in operating income next year. You agree to help Lorenzo and ask him for some current information about his products selling price and costs. You tell him you will work through some possible scenarios that might involve changing his sales price to generate the number of units sold needed to reach his target profit. Lorenzo shares the following information with you as you ponder different scenarios to help your client. Selling price $ Cost for paper, per unit $ Cost for printing, per unit $ Cost for film, per unit $ Staff salaries $ Other operating costs $ Using Lorenzos data and proper Excel formulas, first, plan to get an understanding of Lorenzos financial situation based on breakeven. Then look at the following five pricing optionsscenarios: Lower the selling price by to increase sales volume by Advertise on radio and social media for a combined cost of $ to increase volume by Use a more affordable paper on which to print the posters available for $ per unit in combination with a lessexpensive film to coat the surface of the poster available for $ per unit Instead of paying the salespeople a fixed salary, move to a commissionbased compensation plan save $ in salary; incur $ per unit sold commission which should increase sales volume by Advertise on radio and social media for a combined cost of $ and, instead of paying salespeople a fixed salary, move to a commissionbased compensation plan save $ in salary; incur $ per unit sold commission which could increase sales volume by A few days later, Lorenzo calls back and says he realizes he didnt take into account any tax consequences. He lets you know that he estimates his tax rate to be about and asks if you could please factor that into the various options. He is open to raising the price of his posters if you think that is a viable option. He also lets you know that hes been approached by a potential client inquiring about a special order, and he wants you to advise him on whether to accept the order. The client wants custom posters for $ per poster. The posters will require a different type of paper that will cost $ more per poster. The order will also require Lorenzo to pay an extra $ in employee costs. Per Lorenzos request, you also decide to see what effect a price increase might have on Lorenzos position. You have noticed that Lorenzos is one of the only poster shops in the area, and customers may be willing to pay more, and a higher price may even signal higher quality. Though, there are no guarantees that the market will accept the price increase. Lorenzo is looking at increasing the sales price to $tableOptionsAfterTax ProfitAInsert formulaBInsert formulaC Insert formulaD Insert formulaEInsert formula
Lorenzo, the owner of a local poster shop, comes to you for help. While his shop has been breaking even for the past two years, it has not been able to generate a profit. For him to keep the shop open, he needs to earn at least $ in operating income next year.
You agree to help Lorenzo and ask him for some current information about his products selling price and costs. You tell him you will work through some possible scenarios that might involve changing his sales price to generate the number of units sold needed to reach his target profit.
Lorenzo shares the following information with you as you ponder different scenarios to help your client.
Selling price $
Cost for paper, per unit $
Cost for printing, per unit $
Cost for film, per unit $
Staff salaries $
Other operating costs $
Using Lorenzos data and proper Excel formulas, first, plan to get an understanding of Lorenzos financial situation based on breakeven. Then look at the following five pricing optionsscenarios:
Lower the selling price by to increase sales volume by
Advertise on radio and social media for a combined cost of $ to increase volume by
Use a more affordable paper on which to print the posters available for $ per unit in combination with a lessexpensive film to coat the surface of the poster available for $ per unit
Instead of paying the salespeople a fixed salary, move to a commissionbased compensation plan save $ in salary; incur $ per unit sold commission which should increase sales volume by
Advertise on radio and social media for a combined cost of $ and, instead of paying salespeople a fixed salary, move to a commissionbased compensation plan save $ in salary; incur $ per unit sold commission which could increase sales volume by
A few days later, Lorenzo calls back and says he realizes he didnt take into account any tax consequences. He lets you know that he estimates his tax rate to be about and asks if you could please factor that into the various options. He is open to raising the price of his posters if you think that is a viable option.
He also lets you know that hes been approached by a potential client inquiring about a special order, and he wants you to advise him on whether to accept the order. The client wants custom posters for $ per poster. The posters will require a different type of paper that will cost $ more per poster. The order will also require Lorenzo to pay an extra $ in employee costs.
Per Lorenzos request, you also decide to see what effect a price increase might have on Lorenzos position. You have noticed that Lorenzos is one of the only poster shops in the area, and customers may be willing to pay more, and a higher price may even signal higher quality. Though, there are no guarantees that the market will accept the price increase. Lorenzo is looking at increasing the sales price to $tableOptionsAfterTax ProfitAInsert formulaBInsert formulaC Insert formulaD Insert formulaEInsert formula
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started