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).

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education