on breakeven. Then look at the following five pricing options/scenarios: 1. Lower the selling price by 10% to increase sales volume by 5%. 2. Advertise on radio and social media for a combined cost of $1,000 to increase volume by 10%. 3. Use a more affordable paper on which to print the posters (available for $ 0.60 per unit), in combination with a less - expensive film to coat the surface of the poster (available for $ 0.40 per unit).

Personal Finance
13th Edition
ISBN:9781337669214
Author:GARMAN
Publisher:GARMAN
Chapter8: Vehicle And Other Major Purchases
Section: Chapter Questions
Problem 1FPC
icon
Related questions
Question
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 $12,000 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 $7.50 Cost for paper, per unit $0.70 Cost for printing, per unit $
1.10 Cost for film, per unit $0.60 Staff salaries $48,000.00 Other operating costs $12, 120.00 Using Lorenzo'
s data and proper Excel formulas, first, plan to get an understanding of Lorenzo's financial situation based
on breakeven. Then look at the following five pricing options/scenarios: 1. Lower the selling price by 10%
to increase sales volume by 5%. 2. Advertise on radio and social media for a combined cost of $1,000 to
increase volume by 10%. 3. Use a more affordable paper on which to print the posters (available for $
0.60 per unit), in combination with a less - expensive film to coat the surface of the poster (available for $
0.40 per unit).
Transcribed Image Text: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 $12,000 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 $7.50 Cost for paper, per unit $0.70 Cost for printing, per unit $ 1.10 Cost for film, per unit $0.60 Staff salaries $48,000.00 Other operating costs $12, 120.00 Using Lorenzo' s data and proper Excel formulas, first, plan to get an understanding of Lorenzo's financial situation based on breakeven. Then look at the following five pricing options/scenarios: 1. Lower the selling price by 10% to increase sales volume by 5%. 2. Advertise on radio and social media for a combined cost of $1,000 to increase volume by 10%. 3. Use a more affordable paper on which to print the posters (available for $ 0.60 per unit), in combination with a less - expensive film to coat the surface of the poster (available for $ 0.40 per unit).
Option 1
Contribution Margin Income Statement
Sales
Less Variable Costs:
Contribution Margin
Less Fixed Costs
Operating Income
New Selling Price
New Sales Volume Units
[Insert forumla]
[Insert formula]
[Insert formula]
[Insert formula]
[Insert formula]
[Insert value]
[Insert value]
Option 2
Contribution Margin Income Statement
Sales
Less Variable Costs:
Contribution Margin
Less Fixed Costs
Operating Income
New Fixed Costs
New Sales Volume Units
[Insert formula]
[Insert formula]
[Insert formula]
[Insert formula]
[Insert formula]
[Insert value]
[Insert value]
Option 3
Contribution Margin Income Statement
Sales
Less Variable Costs:
Contribution Margin
Less Fixed Costs
Operating Income
New Variable Cost per unit
[Insert formula]
[Insert formula]
[Insert formula]
[Insert formula]
[Insert formula]
[Insert value}
Transcribed Image Text:Option 1 Contribution Margin Income Statement Sales Less Variable Costs: Contribution Margin Less Fixed Costs Operating Income New Selling Price New Sales Volume Units [Insert forumla] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert value] [Insert value] Option 2 Contribution Margin Income Statement Sales Less Variable Costs: Contribution Margin Less Fixed Costs Operating Income New Fixed Costs New Sales Volume Units [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert value] [Insert value] Option 3 Contribution Margin Income Statement Sales Less Variable Costs: Contribution Margin Less Fixed Costs Operating Income New Variable Cost per unit [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert formula] [Insert value}
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps

Blurred answer
Knowledge Booster
Asset replacement decision
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Personal Finance
Personal Finance
Finance
ISBN:
9781337669214
Author:
GARMAN
Publisher:
Cengage
SWFT Comprehensive Vol 2020
SWFT Comprehensive Vol 2020
Accounting
ISBN:
9780357391723
Author:
Maloney
Publisher:
Cengage
Individual Income Taxes
Individual Income Taxes
Accounting
ISBN:
9780357109731
Author:
Hoffman
Publisher:
CENGAGE LEARNING - CONSIGNMENT
SWFT Essntl Tax Individ/Bus Entities 2020
SWFT Essntl Tax Individ/Bus Entities 2020
Accounting
ISBN:
9780357391266
Author:
Nellen
Publisher:
Cengage
SWFT Comprehensive Volume 2019
SWFT Comprehensive Volume 2019
Accounting
ISBN:
9780357233306
Author:
Maloney
Publisher:
Cengage
CONCEPTS IN FED.TAX., 2020-W/ACCESS
CONCEPTS IN FED.TAX., 2020-W/ACCESS
Accounting
ISBN:
9780357110362
Author:
Murphy
Publisher:
CENGAGE L